Re: [sqlite] Possibly Alias Bug

>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

[sqlite] Possibly Alias Bug

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