PAscal
-
2014-04-02
- status: open --> accepted
- assigned_to: Anu
- Milestone: Candidates --> 2014.05
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