Subject Re: [firebird-support] FB2.1 reserved word problem
Author Helen Borrie
At 03:43 PM 23/03/2009, you wrote:
>> "START" and START are two different identifiers. You would have needed
>> to do this to make the (now illegal) identifier START into "START":
>So Firebird lets you reference a "keyword" table column in ALTER TABLE
>(to allow you to change it?) but not in SELECT?

How else could you refer to it to alter it? ;-)
Don't get confused between ALTER something (which is DDL) and SELECT (which is DML). DDL has stuff under the hood (SQL ops and others) that gets past the human barriers for its own purposes.

Remember to separate DDL in its own transaction and commit that transaction before you proceed to make any futher reference to the affected objects.