[sqlite] Bug: CREATE TABLE AS with GROUP BY preserves backticks in generated column name

[Alek Storm]

> CREATE TABLE t1 (col1 INT);
> CREATE TABLE t2 AS SELECT `col1` FROM t1 GROUP BY col1;
> .schema t2
CREATE TABLE t2("`col1`" INT);

I expected: CREATE TABLE t2(col1 INT);

Note the following generate the schema I expect:
# With backticks, without GROUP BY:
> CREATE TABLE t2 AS SELECT `col1` FROM t1;
> .schema t2
CREATE TABLE t2(col1 INT);

# Without backticks, with GROUP BY:
> CREATE TABLE t2 AS SELECT col1 FROM t1 GROUP BY col1;
> .schema t2
CREATE TABLE t2(col1 INT);

Alek
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users