Re: [gnome-db] sql statement not parsed correctly (postgresql)
Andrea Zagli <[email protected]>
| Newsgroups | gmane.comp.gnome.db |
|---|---|
| Message-ID | <20111007133559.Horde.azbdCRs-3RBOjuQfooRFZOA@saetta.homelinux.org> |
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