Re: [gnome-db] sql statement not parsed correctly (postgresql)

[Vivien Malerba <vmalerba gmail com>]

On 7 October 2011 13:35, Andrea Zagli <azagli libero it> wrote:

Il giorno gio 06 ott 2011 17:32:06 CEST, Vivien Malerba ha scritto:

On 6 October 2011 10:33, Andrea Zagli <azagli libero it> wrote:

this sql

(SELECT data FROM mezzo_chilometraggi
WHERE status <> 'E' AND id_mezzi = 4 AND data = "" 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