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

[Andrea Zagli <azagli libero it>]

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 = '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