Hi all, I'm having problems with the following query (and, in general, in queries using left joins):
[EMAIL PROTECTED]:~$ sqlite3 parana SQLite version 3.4.1 Enter ".help" for instructions sqlite> SELECT t_dados.id FROM (Points1 LEFT JOIN t_dados ON Points1.object_id = t_dados.id) WHERE 1 = 1 AND 1 = 1 ORDER BY t_dados.id, Points1.geom_id; SQL error: no such column: t_dados.id sqlite> .q Apparently, as I've discovered in the SQLite's "Known Issues with descriptions" page ( http://www.sqlite.org/cvstrac/rptview?rn=15 , mainly issue #1994 ) and in related posts in the mailing lists (such as http://marc.10east.com/?t=115378699000001 ), this is related to the columns from nested joins which aren't propagated correctly and is a low-priority bug. In order to avoid this problem, one can simply remove the parenthesis or set proper aliases. That's fine. The issue is: the above and similar queries are generated automatically, the same code (query) is used in MySQL, Postgrees and Oracle AND, as it is not my code that generates these expressions, I cannot modify the generating code of these queries. Does anyone has an idea of how can I solve this? Will this issue be corrected in a near future SQLite update? Any hint will be pretty much appreciated. Thanks in advance. Best regards, Bruno -- /** * Bruno S. Oliveira * Bacharel em Ciência da Computação * Mestrando em Inteligência Computacional * http://www.inf.ufpr.br/brunoso/ * * http://www.last.fm/user/bsoliveira/ */
