Re: [gnome-db] sql statement not parsed correctly (postgresql)
Vivien Malerba <[email protected]>
| Newsgroups | gmane.comp.gnome.db |
|---|---|
| Message-ID | <CAEP1ZNko0ydeK6FvKrbMjRmsZ+uCH_Lg2vBvaWsy2df_afvaZA@mail.gmail.com> |
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 Regards, Vivien _______________________________________________ gnome-db-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnome-db-list