Re: [gnome-db] sql statement not parsed correctly (postgresql)
Andrea Zagli <[email protected]>
| Newsgroups | gmane.comp.gnome.db |
|---|---|
| Message-ID | <[email protected]> |
Il giorno sab 08 ott 2011 14:38:29 CEST, Vivien Malerba ha scritto: > On 7 October 2011 13:35, Andrea Zagli <[email protected]> wrote: > >> 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 >> >> > Ok, this is now corrected, see > http://git.gnome.org/browse/libgda/commit/?id=230b9fc71552b503916b855e18d0f1a3d714214c thanks, but i forgot to mention that i'm using the branch libgda_4_2... sorry how can i "merge" it into that branch?