Views with a column named 'LEAVE' cause a warning

[mailtowim]

Views with a column 'LEAVE' cause a warning, which is caused by an exception in ParametricQuery.exec(String expression)

If you add the keyword 'LEAVE' to SqlConverter.KEYWORDS_LIST, the warning goes away.

Having a column 'LEAVE' in a view causes a privilege error.

[spannm]

Thanks for raising this issue.

LEAVE is a routine statement in HSQLDB and as such should probably receive special treatment, see https://hsqldb.org/doc/guide/sqlroutines-chapt.html
I will take a closer look soon.

[spannm]

Hello @mailtowim,

can you confirm this behavior was encountered while loading an existing view (saved query) from an Access db?
Please attach your minimal Access db (any version) suitable for usage in a JUnit test case (the smaller the better).

cheers
Markus

[mailtowim]

Sample.zip

You can find the zipped access database attached. The name of the view should also contain a space.

Following warning is shown: WARNING: Error message was: unexpected token : ] required: AS

[spannm]

Fixed in current snapshot and will be part of next release.
Thanks for reporting!