Re: [SQLObject] Re: Know bugs in Firebird

[Ian B. <ia...@co...>]

On Saturday, September 27, 2003, at 09:41 PM, Ian Sparks wrote:
>> * NamesTest doesn't create the table correctly.  Is "names" a reserved
>> word?
>
> Yes.
>
> It occured to me in the few hours working with SQLObject that there 
> are a
> number of simple ways to break it. Two things that would help novices 
> would
> be a list of reserved words for each DB and a "__MaxIdentifierLength"
> property (31chars for Interbase as I recall, James?). Remedy could be
> failure or name-mangling. Whatever, some warning would be nice.
>
> The complete list of keywords can be found in the IB 6 manuals 
> starting at
> page 184 Section "Keywords". Firebird has added some more but I'm not 
> sure
> this is well documented. If you decide you want to add reserved word 
> support
> just say how you want this formatted and I'll contribute it.

It's probably easier if we just start quoting all the columns.  That's 
pretty easy with automatic SQL generation anyway.  Postgres uses 
"column", MySQL `column`, what does Firebird use?  (SQLite?)

That doesn't fix the 31 character limit.  Raising an exception would be 
best in that case.  It confuses me terribly when I hit that limit (I 
think Postgres has the same limit) and names get truncated.

   Ian