Re: [gnome-db] strange sql parsing behavior

[Vivien Malerba <vmalerba gmail com>]

2009/8/10 Andrea Zagli <azagli libero it>

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=26f214fbfbd99ded4b30576999285c1fb7eba06f for 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
gnome-db-list gnome org
http://mail.gnome.org/mailman/listinfo/gnome-db-list