Menu

#98 Query Builder: changing join type in graph is not applyed in SQL text

Candidates
open
nobody
Bug (150)
2
2016-07-06
2012-10-28
PAscal
No

This appens for NON ANSI SQL reversed with SQLeo

taking SQL in syntax window
SELECT
C.TABLE_SCHEM,
C.TABLE_NAME,
T.TABLE_TYPE,
C.COLUMN_NAME
FROM
INFORMATION_SCHEMA.SYSTEM_TABLES T, INFORMATION_SCHEMA.SYSTEM_COLUMNS C where T.TABLE_CAT = C.TABLE_CAT
AND T.TABLE_NAME = C.TABLE_NAME
AND T.TABLE_SCHEM = C.TABLE_SCHEM

reversing it (going into designer window)
changing join type in graph is not reflected in SQL syntax.

Conclusion: Changing Join type is only possible for ANSI SQL.

Workarround: reverting two times an NON ANSI SQL generates an ANSI SQL where join types can be modified

Discussion

  • PAscal

    PAscal - 2014-04-02
    • status: open --> accepted
    • assigned_to: Anu
    • Milestone: Candidates --> 2014.05
     
  • PAscal

    PAscal - 2014-04-27
    • Milestone: 2014.05 --> 2014.06
     
  • PAscal

    PAscal - 2014-05-19
    • status: accepted --> open
    • assigned_to: Anu --> nobody
    • Milestone: 2014.06 --> Candidates
     
  • PAscal

    PAscal - 2016-07-06
    • priority: 1 --> 2
     

Log in to post a comment.