Re: [gnome-db] strange sql parsing behavior

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 = 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 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.



gnome-db-list mailing list
gnome-db-list gnome org

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