1. Launch Query Analyzer using an Oracle server connection.
2. Note that the current schema is SYS.
3. Do Reconnect first. (This step is necessary to reproduce the issue.)
4-a. Now switch to a different schema, e.g. CHINOOK.
4-b. Run a query for a table in the CHINOOK schema, e.g. select * from ARTIST
4-c. An error message is returned, complaining that the table does not exist, even though the table exists in the CHINOOK schema.
4-d. Notice that the schema drop-down switches to SYS.
5-a. Now switch to the CHINOOK schema again.
5-b. Run this query select SYS_CONTEXT('USERENV','CURRENT_SCHEMA') sid from dual
(which retrieves the current schema context)
5-c. Notice that the schema drop-down switches to SYS and the query result also confirms that the current schema context is SYS.
This issue is reproducible starting in v14. I haven't tried v13 or any prior version.
|
72 KB
|
151 KB
|
194 KB
A listener is attached to the Schema combo-box to detect if user chooses a different schema. During Reconnect, the Schema combo-box was recreated but there was no listener attached to the new combo-box. As a result, schema change didn't take effect.
Fixed the Reconnect code to use the existing Schema combo-box and just repopulate the list of schema.
Verified in ads 18.0.0-dev-121.
Please refer to screenshot : #14225.png
Verified in ads 18.0.0-dev-121.
Please refer to screenshot : #14225.png
Verified in ads build v17.0.11 & v18.0-preview-36
Please refer to the screenshot :
v17 :14225_17.0.11.png
Verified in ads build v17.0.11 & v18.0-preview-36
Please refer to the screenshot :
v17 :14225_17.0.11.png
Issue #14225 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 17.0.10-11, 18.0.0-dev-35 |
No time estimate |
A listener is attached to the Schema combo-box to detect if user chooses a different schema. During Reconnect, the Schema combo-box was recreated but there was no listener attached to the new combo-box. As a result, schema change didn't take effect.
Fixed the Reconnect code to use the existing Schema combo-box and just repopulate the list of schema.