[gnome-db] strange sql parsing behavior
- From: Andrea Zagli <azagli libero it>
- To: gnome-db-list gnome org
- Subject: [gnome-db] strange sql parsing behavior
- Date: Mon, 10 Aug 2009 18:58:58 +0200
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
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]