Description: When we insert data in the Global Temporary Table and then execute the select script, it does not show the inserted records.
Steps to Reproduce the issue:
CREATE GLOBAL TEMPORARY TABLE "GLOBAL_TEMP_TABLE" ( "id" NUMBER(15,5) NOT NULL, "name" VARCHAR2(25 BYTE) NULL ) GO INSERT INTO "GLOBAL_TEMP_TABLE"("id", "name") VALUES(1, 'David') GO INSERT INTO "GLOBAL_TEMP_TABLE"("id", "name") VALUES(2, 'Erica') GO INSERT INTO "GLOBAL_TEMP_TABLE"("id", "name") VALUES(3, 'Peter') GO
Actual Result: The records are inserted in the Global Temporary Table without any error. But after executing the Select script, the inserted records are not displayed in the Results pane.
Expected Result: The inserted records in the Global Temporary Table must be displayed after executing the Select script.
Observations:
Behavior in different ADS builds.
|
Behaviour in different versions. | ||
Oracle 12c | Oracle 11g | Oracle 10g | |
ADS 19 dev-20 | Y | Y | Y |
ADS v18 | Y | Y | Y |
ADS v17 | Y | Y | Y |
Y - Issue is Reproducible. | |||
N - Issue is not reproducible. |
|
167 KB
The Same behavior is observed for Sybase IQ Server. We can insert data in the Global Temporary Table but Result Pane do not display the inserted records after executing the Select script.
Executed below script to reproduce this issue in the Sybase IQ.
CREATE GLOBAL TEMPORARY TABLE "GLOBAL_TEMP_TABLE" ( "id" INTEGER NOT NULL, "name" VARCHAR (25) NULL ) GO INSERT INTO DBA.GLOBAL_TEMP_TABLE(id, name) VALUES(1, 'David') GO INSERT INTO DBA.GLOBAL_TEMP_TABLE(id, name) VALUES(2, 'Erica') GO INSERT INTO DBA.GLOBAL_TEMP_TABLE(id, name) VALUES(3, 'Peter') GO
Issue #15153 |
New |
Completion |
No due date |
No fixed build |
No time estimate |
The Same behavior is observed for Sybase IQ Server. We can insert data in the Global Temporary Table but Result Pane do not display the inserted records after executing the Select script.
Executed below script to reproduce this issue in the Sybase IQ.