Re: [gnome-db] sql statement not parsed correctly (postgresql)
- From: Andrea Zagli <azagli libero it>
- To: Vivien Malerba <vmalerba gmail com>
- Cc: "gnome-db-list gnome org" <gnome-db-list gnome org>
- Subject: Re: [gnome-db] sql statement not parsed correctly (postgresql)
- Date: Sun, 09 Oct 2011 08:55:25 +0200
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]