On Wed, Feb 22, 2012 at 10:21 PM, Pete <p...@mollysrevenge.com> wrote:
> I seem to have stumbled upon what looks like a bug in SQLite. I
> accidentally created a column in a table that included a space in its
> name,eg "Col 1". The CREATE TABLE command accepted without an error but if
> I try to access that column in any way, I get an error, no matter whether I
> specify the column name with no quotes, single quotes or double quotes.
> ...
stephan@tiny:~$ sqlite3
SQLite version 3.7.7 2011-06-23 19:49:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table t([Col 1]);
sqlite> .h on
sqlite> insert into t values('a');
sqlite> select * from t;
Col 1
a
sqlite> select [Col 1] from t;
Col 1
a
Hope that helps,
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
http://gplus.to/sgbeal
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
