On 2/22/2012 4:21 PM, Pete 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. For example if I "SELECT Col 1 FROM..." I get a "syntax error near 1" (which I'd expect). If I try 'SELECT "CoL 1" FROM...", I get and error "no such column "Col1" - notice there is no space in the column name listed in the error message".
Must be a problem with a tool or wrapper you use. Column names enclosed in double quotes do work in SQLite.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users