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



Il giorno sab 08 ott 2011 14:38:29 CEST, Vivien Malerba ha scritto:

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



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]