#201 Wrong quotes in generated SELECT statement.

v1.0
wont-fix
mariuz
3
2014-06-27
2011-03-10
Anonymous
No

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

Discussion

  • That causes no error but is still wrong. Without any quotes would work the way expected.

     
  • Michael Hieke
    Michael Hieke
    2011-04-05

    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.

     

  • Anonymous
    2012-10-23

    The Problem occurs on a dialect 1 database.
    There should be no automatic quoting for the VERSION column.

     

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

     
  • Michael Hieke
    Michael Hieke
    2012-11-05

    • status: closed --> open
    • assigned_to: Michael Hieke --> nobody
    • milestone: --> v1.0
     
  • mariuz
    mariuz
    2014-06-27

    • status: open --> wont-fix
    • assigned_to: mariuz
     
  • mariuz
    mariuz
    2014-06-27

    please migrate to a dialect 3 database
    dialect 1 is transitional

     


Anonymous


Cancel   Add attachments