2009/8/10 Andrea Zagli <[email protected]> > libgda 4.0.1 - provider sqlite (i didn't try with other providers) - sqlite > 3.6.16 > > > when i execute this sql > > select distinct year from customer > > i get n rows per year instead one only > > > when i execute this sql > > select * from customers where exists (select orders.* from orders where > customers.id = orders.id_customers) > > i get the error «near "(": syntax error» > > > both the sql work as i expect if executed inside sqlite console > > why? i didn't understand > > thanks in advance >
This has been corrected, but is not yet available in a public release, it will be in 4.0.3, see http://git.gnome.org/cgit/libgda/commit/?id=26f214fbfbd99ded4b30576999285c1fb7eba06ffor details. The problem is due to the fact that Libgda adds some extra columns to SELECT statements in SQLite to be able to generate update, insert and delete statement when modifying the results of a SELECT and there was a bug in the process. In the meanwhile, you can use Libgda from git or I can send you a tarball with the current sources which will become version 4.0.3. Regards, Vivien > > _______________________________________________ > gnome-db-list mailing list > [email protected] > http://mail.gnome.org/mailman/listinfo/gnome-db-list >
_______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
