coleifer/peewee — Issue #42: sqlite syntax error when a field is named group
Author: aflower
Created: 2012-01-08 12:03:10+00:00
State: open

The orm generates this sql string

CREATE TABLE thethable (stat INTEGER NOT NULL, group VARCHAR(255) NOT NULL)

for a model that has stat an integerField and group a CharField.

sqlite3 then gives an operationalError: near "group" syntax error

probably since group is a keyword, but if we put quote marks around group, the statement passes.