Hello everybody,
I have problems with column aliasing using AS when I select
rows with the same string:
.headers ON
CREATE TABLE TEST1 (name TEXT,value TEXT);
INSERT INTO TEST1 VALUES ("name1","value1");
SELECT value AS name1 FROM TEST1 WHERE name="name1"; // gives no result
SELECT value AS name1_ FROM TEST1 WHERE name="name1"; // gives proper
result
Looks like a bug for me.
Tested with sqlite-shell-win32-x86-3070603.zip
Greetings,
Rene Fink
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
