I recently came across an oddity in SQL Studio (7.6.03 Build 10):
When choosing 'ORACLE' as sqlmode SQL Studio GUI displays that it has changed the sqlmode.
But checking in the SESSIONS table shows always "INTERNAL" as sqlmode.
The same happens when using sqlcli:
sqlcli sdb=> \m ORACLE SQL mode changed to ORACLE sqlcli sdb=> select sqlmode from sessions where own='YES' | SQLMODE | | -
Only when I start sqlcli directly with the sqlmode selection it works. Unfortunately a later change is still not possible.
C:\WINDOWS>sqlcli -d sdb -u lars,lars -S ORACLE Welcome to the MaxDB interactive terminal. Type: \h for help with commands \q to quit sqlcli sdb=> select sqlmode from sessions where own='YES' | SQLMODE | | -
This happens on 7.6.3 /7.6.4 databases.
Can somebody check this?
Thanks and regards,