strange sql parsing behavior
|
View:
New views
8 Messages
—
Rating Filter:
Alert me
|
 |
strange sql parsing behavior
by Andrea Zagli-2
::
Rate this Message:
libgda 4.0.1 - provider sqlite (i didn't try with other providers) -
sqlite 3.6.16 when i execute this sql select distinct year from customer i get n rows per year instead one only when i execute this sql select * from customers where exists (select orders.* from orders where customers.id = orders.id_customers) i get the error «near "(": syntax error» both the sql work as i expect if executed inside sqlite console why? i didn't understand thanks in advance _______________________________________________ gnome-db-list mailing list gnome-db-list@... http://mail.gnome.org/mailman/listinfo/gnome-db-list |
|
|
Re: strange sql parsing behavior
by Vivien Malerba
::
Rate this Message:
2009/8/10 Andrea Zagli <azagli@...> libgda 4.0.1 - provider sqlite (i didn't try with other providers) - sqlite 3.6.16 This has been corrected, but is not yet available in a public release, it will be in 4.0.3, see http://git.gnome.org/cgit/libgda/commit/?id=26f214fbfbd99ded4b30576999285c1fb7eba06f for details. The problem is due to the fact that Libgda adds some extra columns to SELECT statements in SQLite to be able to generate update, insert and delete statement when modifying the results of a SELECT and there was a bug in the process. In the meanwhile, you can use Libgda from git or I can send you a tarball with the current sources which will become version 4.0.3. Regards, Vivien
_______________________________________________ gnome-db-list mailing list gnome-db-list@... http://mail.gnome.org/mailman/listinfo/gnome-db-list |
|
|
Re: strange sql parsing behavior
by Andrea Zagli-2
::
Rate this Message:
Il giorno lun 10 ago 2009 21:26:40 CEST, Vivien Malerba ha scritto:
> 2009/8/10 Andrea Zagli <azagli@...> > >> libgda 4.0.1 - provider sqlite (i didn't try with other providers) - sqlite >> 3.6.16 >> >> [...] >> > > This has been corrected, but is not yet available in a public release, it > will be in 4.0.3, see > http://git.gnome.org/cgit/libgda/commit/?id=26f214fbfbd99ded4b30576999285c1fb7eba06ffor > details. The problem is due to the fact that Libgda adds some extra > columns to SELECT statements in SQLite to be able to generate update, insert > and delete statement when modifying the results of a SELECT and there was a > bug in the process. sorry for the mistake, but i'm using libgda 4.1.0 and not 4.0.1 as i wrote what you wrote is valid also for that version? _______________________________________________ gnome-db-list mailing list gnome-db-list@... http://mail.gnome.org/mailman/listinfo/gnome-db-list |
|
|
Re: strange sql parsing behavior
by Vivien Malerba
::
Rate this Message:
2009/8/12 Andrea Zagli <azagli@...>
Il giorno lun 10 ago 2009 21:26:40 CEST, Vivien Malerba ha scritto: Yes, the same applies. The correction was made in both the 4.0 and 4.1 (master) branches. Vivien _______________________________________________ gnome-db-list mailing list gnome-db-list@... http://mail.gnome.org/mailman/listinfo/gnome-db-list |
|
|
Re: strange sql parsing behavior
by Andrea Zagli-2
::
Rate this Message:
Il giorno mer 12 ago 2009 15:10:00 CEST, Vivien Malerba ha scritto:
> [...] > Yes, the same applies. The correction was made in both the 4.0 and 4.1 > (master) branches. i just tried 4.1.1 and select distinct year from customer now works, but select * from customers where exists (select orders.* from orders where customers.id = orders.id_customers) return the same error «near "(": syntax error» _______________________________________________ gnome-db-list mailing list gnome-db-list@... http://mail.gnome.org/mailman/listinfo/gnome-db-list |
|
|
Re: strange sql parsing behavior
by Vivien Malerba
::
Rate this Message:
2009/8/26 Andrea Zagli <azagli@...>:
> Il giorno mer 12 ago 2009 15:10:00 CEST, Vivien Malerba ha scritto: >> >> [...] >> Yes, the same applies. The correction was made in both the 4.0 and 4.1 >> (master) branches. > > i just tried 4.1.1 and > > select distinct year from customer > > now works, but > > select * from customers where exists (select orders.* from orders where > customers.id = orders.id_customers) > > return the same error «near "(": syntax error» Ok, this was another rendering problem bug: the statement was rendered as: select * from customers where exists ((select orders.* from orders where customers.id = orders.id_customers)) which SQLite does not like. Can you check with git master? Thanks, Vivien _______________________________________________ gnome-db-list mailing list gnome-db-list@... http://mail.gnome.org/mailman/listinfo/gnome-db-list |
|
|
Re: [SOLVED] strange sql parsing behavior
by Andrea Zagli-2
::
Rate this Message:
Il giorno mer 26 ago 2009 21:37:40 CEST, Vivien Malerba ha scritto:
>> select * from customers where exists (select orders.* from orders where >> customers.id = orders.id_customers) >> >> return the same error «near "(": syntax error» > > Ok, this was another rendering problem bug: the statement was rendered as: > select * from customers where exists ((select orders.* from orders where > customers.id = orders.id_customers)) > > which SQLite does not like. > > Can you check with git master? ok it seems to work, thanks a lot when do you release libgda 4.1.2? ;-) _______________________________________________ gnome-db-list mailing list gnome-db-list@... http://mail.gnome.org/mailman/listinfo/gnome-db-list |
|
|
Re: [SOLVED] strange sql parsing behavior
by Vivien Malerba
::
Rate this Message:
2009/9/10 Andrea Zagli <azagli@...>:
> Il giorno mer 26 ago 2009 21:37:40 CEST, Vivien Malerba ha scritto: >>> >>> select * from customers where exists (select orders.* from orders where >>> customers.id = orders.id_customers) >>> >>> return the same error «near "(": syntax error» >> >> Ok, this was another rendering problem bug: the statement was rendered as: >> select * from customers where exists ((select orders.* from orders where >> customers.id = orders.id_customers)) >> >> which SQLite does not like. >> >> Can you check with git master? > > ok it seems to work, thanks a lot > > when do you release libgda 4.1.2? ;-) > Probably next week when I have finished correcting some annoying bugs and implementing query execution in the GdaBrowser program. Vivien _______________________________________________ gnome-db-list mailing list gnome-db-list@... http://mail.gnome.org/mailman/listinfo/gnome-db-list |
| Free embeddable forum powered by Nabble | Forum Help |
