#14416: 'Alter session' script fails to change the current schema

anilkalshetti reported 2016-05-05T05:59:56Z · last modified 2016-12-10T07:58:07Z

'Alter session' script fails to change the current schema

Dev	tomconrad
QA	ivangron

Priority	Low
Complexity	Unknown

Component	DB - Oracle
Version	18.0

Aqua Data Studio 18.0.0-devi-129
Build #: 49706
Built on: 2016-May-03 08:50:33 PM

OS: Ubuntu 16.04 LTS
Linux (4.4.0-21-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_72-b15
Memory: Max=704,643,072; Total=459,800,576; Free=383,227,232; CPUs=8

Database: Oracle 12c

Issue:'Alter session' script fails to change the current schema- each time sets CURRENT_SCHEMA as 'ANONYMOUS'

Steps:
1. Open Query analyzer. Consider your current schema is 'c##project'

2. Open attached script1.sql file and execute on Query Analyzer
3. This attached file has script to

- create schema 'c##Source5'

- change current schema to 'c##Source5'

- create table 'P1_LONGRAW_to_FLOAT_11'

4. It's observed that,

- schema 'c##Source5' is created

- change current schema 'Alter Session' script doesn't work

-----ADS switch schema to 'ANONYMOUS' <--Issue

ALTER   SESSION SET   CURRENT_SCHEMA = "ANONYMOUS"

Analysis: This script is generated by ADS unnecessarily.

User Sceanrio:

This affects the table creation, if user executes the scripts one by one -[Table is created in schema 'ANONYMOUS']

1. User open Query Analyzer with schema - c##project

2. User execute script A]- to create schema- c##Source5

3. User execute script B] 'Alter Session'- to alter current schema to - c##Source5

Observed- Schema drop down automatically changed to 'ANONYMOUS'

SQL LOG - 2 scripts observed-

ALTER    SESSION  SET    CURRENT_SCHEMA="c##Source5"

ALTER    SESSION  SET    CURRENT_SCHEMA = "ANONYMOUS"

4. User execute script C] 'Create Table'-[Table is created in schema 'ANONYMOUS']

Expected:

'Alter session' script should change the current schema to 'c##Source5'

----This issue is also observed in previous ADS versions: ADS16.0.10 and ADS17.0.4-4

Extra Info:

'Alter Session' query works properly in below scenario

Once user Create New schema[c##Source5] in QA-Tab1[schema-c##project] .

and then open new Query Analyzer-Tab2,

and in this, if 'Alter Session' script is executed schema gets changed properly.

- If the schema mentioned in 'Alter Session' script is present in Query Analyzer 'Schema' drop-down list, then only this script works properly.

2 attachments

screenshot1.png

2016-05-05T05:59:56Z

376 KB
script1.sql

2016-05-05T05:59:56Z

2 KB

All Comments (4) Change History

tomconrad 2016-09-19T21:58:53Z

svn# 51199

SachinPrakash 2016-09-19T23:29:42Z

@tom: pls explain what was the underlying issue & your fix

SachinPrakash 2016-09-20T00:38:06Z

@tom: pls rollback your change & then mark issue as won't fix.

The described behavior in the issue is how ADS is designed to work. The list of schemas & the list of DBs in the drop down is not automatically refreshed.

If you have further questions, lets do a hangout to discuss

tomconrad 2016-09-20T14:34:09Z

Hi Sachin, Change is reverted - svn# 51203

Search Tips

Aqua Data Studio / nhilam

'Alter session' script fails to change the current schema

2 attachments

Issue #14416

Completion

Search Tips

Aqua Data Studio / nhilam

Title

'Alter session' script fails to change the current schema

2 attachments

Issue #14416

Completion