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

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


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:

You can check with the example program attached.



Attachment: test_parser_parenthesis.tbz
Description: Binary data

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