[SQLObject] Re: Know bugs in Firebird

[Ian S. <ia...@et...>]

"Ian Bicking" <ia...@co...> wrote in message
news:A6B...@co......
> I sent this to James, but then I though Ian or someone else might want
> to look at these.

Thanks.

> * 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.

- Ian Sparks.