2009/8/26 Andrea Zagli <[email protected]>: > Il giorno mer 12 ago 2009 15:10:00 CEST, Vivien Malerba ha scritto: >> >> [...] >> Yes, the same applies. The correction was made in both the 4.0 and 4.1 >> (master) branches. > > i just tried 4.1.1 and > > select distinct year from customer > > now works, but > > select * from customers where exists (select orders.* from orders where > customers.id = orders.id_customers) > > return the same error «near "(": syntax error»
Ok, this was another rendering problem bug: the statement was rendered as: select * from customers where exists ((select orders.* from orders where customers.id = orders.id_customers)) which SQLite does not like. Can you check with git master? Thanks, Vivien _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list
