The generated SELECT statement for a given table with a column "VERSION" is:
SELECT a."VERSION" FROM VERSION_TABLE a
This causes an error. It should be:
SELECT "a.VERSION" FROM VERSION_TABLE a
It is certainly not wrong to quote the column name, even though it wouldn't be necessary. Quoting table and column name as one entity would be completely wrong, OTOH.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2012-10-23
The Problem occurs on a dialect 1 database.
There should be no automatic quoting for the VERSION column.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2012-11-05
Please reopen this Ticket because it is still a problem as of version 0.9.3.2246.
FlameRobin does not honor that dialect 1 does not support quoting.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
That causes no error but is still wrong. Without any quotes would work the way expected.
It is certainly not wrong to quote the column name, even though it wouldn't be necessary. Quoting table and column name as one entity would be completely wrong, OTOH.
The Problem occurs on a dialect 1 database.
There should be no automatic quoting for the VERSION column.
Please reopen this Ticket because it is still a problem as of version 0.9.3.2246.
FlameRobin does not honor that dialect 1 does not support quoting.
please migrate to a dialect 3 database
dialect 1 is transitional