I perceived a queer sql generation under certain circumstances. Can this be attuned somehow?
Query generation for the follwowing combination
- Multi source data foundation
- derived table (here with oracle syntax: “SELECT 1 as one FROM DUAL”)
- IDT will let me choose between “Standard SQL-92” and “Database-specific” → I choose “Database-specific”
When this source would be used in a query, the resulting sql is encapsulated by something “WITH …AS NATIVE …, “ONE” DECIMAL (127,0…)”
It is inconvenient to extract a statement for Toad/etc. for debugging purposes.
Thanks in advance