Subject Re: [ib-support] FB 1.5 beta1 error
Author Helen Borrie
At 12:47 PM 7/02/2003 +0800, you wrote:
>Hi ,
>
> I have a table which name "LEAVE" , it works in FB1.02 and ib7.0 ,but
> it doesn't
>work in FB1.5,what's the problem, whether the "leave" is key word? the table
>is as the follows. please help!

Erm, yes, it has gone into PSQL as a keyword for jumping out of a flow
control block.
From the release notes:
2002-12-18 16:01 dimitr

* firebird2/src/dsql/: ddl.cpp, dsql.h, dsql.tab.h, gen.cpp,
keywords.cpp, node.h, parse.cpp, parse.y, pass1.cpp:

Fixed bug with BREAK and partially implemented labels and LEAVE
statement.

'Tis always such a good idea to read the release notes...

Your choices are to double-quote the table name or to rename it. Either
way, you will have to create a new table and pump your data into it.

Could you take your beta problems to firebird-devel please? That is the
testers' forum. Please keep this channel clear for support of the
production software.

Ta.
^heLen