#201 Wrong quotes in generated SELECT statement.

v1.0
wont-fix
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

  • Nobody/Anonymous

    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
     
  • Popa Adrian Marius

    • status: open --> wont-fix
    • assigned_to: mariuz
     
  • Popa Adrian Marius

    please migrate to a dialect 3 database
    dialect 1 is transitional

     


Anonymous

Cancel  Add attachments





Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks