[gnome-db] subqueries in libgda-v4
- From: Massimo Cora' <maxcvs email it>
- To: gnome-db-list gnome org, Johannes Schmid <johannes schmid gmx de>
- Subject: [gnome-db] subqueries in libgda-v4
- Date: Mon, 18 Feb 2008 20:42:21 +0100
-----BEGIN PGP SIGNED MESSAGE-----
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?
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')
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
thanks and regards,
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
-----END PGP SIGNATURE-----
] [Thread Prev