aishee / sqlalchemy-migrate

Automatically exported from code.google.com/p/sqlalchemy-migrate
MIT License
0 stars 0 forks source link

Can not add column to table containing column with reserved word as its name #56

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1. Have an initial SQLite table that has a table with a column having a name of 
table (IE the 
column name is "table")
2. use changeset to add a column to this table
3.

What is the expected output?
I expect the column to be added.

What do you see instead?
I see an error cause the column name is not quoted
sqlalchemy.exc.OperationalError: (OperationalError) near "table": syntax error 
u'INSERT INTO 
p00_som_indexes SELECT name,object_id,table,revision,id from migration_tmp' ()

What version of the product are you using? On what operating system?
SVN revision 519 (thats the revision of the CHANGELOG file)
0.5.2 according to CHANGELOG

Please provide any additional information below.

Original issue reported on code.google.com by jarrod.c...@gmail.com on 17 May 2009 at 11:53

GoogleCodeExporter commented 8 years ago
looks like a quoting problem, i.e. the reserved word "table" should be quoted

Original comment by jan.ditt...@gmail.com on 17 May 2009 at 12:32

GoogleCodeExporter commented 8 years ago

Original comment by iElect...@gmail.com on 10 Jun 2009 at 5:14