Re: [gnome-db] subqueries in libgda-v4

["Vivien Malerba" <vmalerba gmail com>]

On Feb 18, 2008 8:42 PM, Massimo Cora' <maxcvs email it> 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