[gnome-db] strange sql parsing behavior

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

_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list