[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

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