Re: [gnome-db] possible bug on sql parser

[Vivien Malerba <vmalerba gmail com>]

On 30 December 2010 08:49, Andrea Zagli <azagli libero it> wrote:

the parser removes () from this query and then the query no longer works

select (case when iva > 0 then (iva + 100) / 100) from costi

become

select case when iva > 0 then iva + 100 / 100 from costi

that is equal to

select case when iva > 0 then iva + 1 from costi


i have tried with libgda from git and only with postgresql provider

This is now fixed in git/master:  http://git.gnome.org/browse/libgda/commit/?id=c478a1f3d2f6f7aba0fcef2f724e921244459db5

You can check with the example program attached.

Regards,

Vivien

Attachment: test_parser_parenthesis.tbz
Description: Binary data