[gnome-db] subqueries in libgda-v4



-----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?
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
of parameters.

thanks and regards,
Massimo

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)

iD8DBQFHud+ccfVTgMRILk0RAtdpAJ9SaZ0IbXLoZch/xJ9d7J0CJeW83ACdFatf
o8EHQmkge821gdBeMpM+bYQ=
=qc6U
-----END PGP SIGNATURE-----


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]