Re: [gnome-db] strange sql parsing behavior

[Vivien Malerba <vmalerba gmail com>]

2009/8/26 Andrea Zagli <azagli libero it>:
> 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