Il giorno gio 06 ott 2011 17:32:06 CEST, Vivien Malerba ha scritto:
On 6 October 2011 10:33, Andrea Zagli <[email protected]> wrote:
this sql
(SELECT data FROM mezzo_chilometraggi
WHERE status <> 'E' AND id_mezzi = 4 AND data = '2011-01-01' LIMIT 1)
UNION
(SELECT data FROM mezzo_chilometraggi
WHERE status <> 'E' AND id_mezzi = 4 AND data < '2011-01-01' ORDER BY data
DESC LIMIT 1)
is not parsed correctly; the result is without parenthesis that delimit
queries before and after union
I understand you mean the SQL rendering is not correct, but the parsiing
itself is correct. Is that right?
yes
the problem is how libgda change the string, removing parenthesis
_______________________________________________
gnome-db-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnome-db-list
