Skip to Content
0
Apr 18, 2008 at 12:20 PM

SQLMode-Selection not working!?

16 Views

Hi all,

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 | | -


| | INTERNAL | 1 row selected (154.150 msec) sqlcli sdb=> sqlcli sdb=> \m ORACLE SQL mode changed to ORACLE sqlcli sdb=> select sqlmode from sessions where own='YES' | SQLMODE | | -
| | INTERNAL | 1 row selected (23.453 msec)

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 | | -


| | ORACLE | 1 row selected (3592 usec) sqlcli sdb=> \m INTERNAL SQL mode changed to INTERNAL sqlcli sdb=> select sqlmode from sessions where own='YES' | SQLMODE | | -
| | ORACLE | 1 row selected (3882 usec)

This happens on 7.6.3 /7.6.4 databases.

Can somebody check this?

Thanks and regards,

Lars