On Feb 18, 2008 8:42 PM, Massimo Cora' <[EMAIL PROTECTED]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi, > > I'm hacking a little around with libgda-v4 branch. > I know from bug #516442 that there are performance improvements, so I > would like to try them out. > I would also like to know just one thing: are subqueries already supported?
They should pose no problem... > I tried with some simple query as > > SELECT * FROM file WHERE file_id NOT IN (SELECT file_defined_id FROM symbol) > > but I just got all the contents of table 'file'. > The same happens with some other subqueries like > > SELECT * FROM file WHERE prj_id = (SELECT project_id FROM project WHERE > project_name = 'foo_project') Could you send me a sample database? > > Tests have been done using a modified version of samples/SimpleExample. > BTW: there are some compilation issues there, with > gda_client_open_connection_from_string () that needs a different number > of parameters. Yes, the API has changed quite a lot (it _was_ necessary to clean things up...) > > thanks and regards, Cheers, Vivien _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
