Re: [SQLObject] Fail to create table with fields named 'intersect' or 'group'

[Oleg B. <ph...@ph...>]

On Sat, Apr 23, 2011 at 05:52:07PM -0600, Pгoм???тн?????s 0x01 wrote:
> Not sure if this is a bug or not, but it seems like I cannot create tables
> that have variables (columns) named after SQL keywords; could/should they be
> escaped in some way, or is this a limitation of SQLObject?

   Not a bug, rather a deficiency - SQLObject doesn't quote column
names. You can try to create a patch, at least for MySQL, but pleas
don't make entire SQLObject MySQL-oriented; i.e. you should quote
column names only if the current DB is MySQL.

Oleg.
-- 
     Oleg Broytman            http://phdru.name/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.