>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
It's due to your misuse of double quotes instead of single quotes
(apostrophes) to enclose literal strings.
Try:
CREATE TABLE TEST1 (name TEXT,value TEXT);
INSERT INTO TEST1 VALUES ('name1', 'value1');
SELECT value AS name1 FROM TEST1 WHERE name='name1';
SELECT value AS name1_ FROM TEST1 WHERE name='name1';
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
