× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ashwini.durge(*) reported 2017-04-13T07:25:22Z  · tomconrad last modified 2018-03-09T23:09:07Z

Inserted records in the Global Temporary Table are not displayed after executing the Select script


PM
Priority Low
Complexity Unknown
Component DB - Oracle
Version Future
Product: Aqua Data Studio
Version: 19.0.0-dev-20
Build #: 53919
Build Date: 2017-Apr-11 04:18:11 PM
 
Operating Environment: Windows 8.1 (6.3, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_102-b14
Memory: Max=704,643,072;  Total=424,673,280;  Free=258,131,328;  CPUs=4
 

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:

  1. Connect to the Oracle Server.
  2. Navigate to the Schema node and select any schema.
  3. In the selected schema, right-click the Table node and then select Query Analyzer.
  4. Execute the below script in the Query Analyzer.
    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
  5. Execute the Select script.

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:

  • The message is displayed in the Tex Result tab that "0 record(s) selected"
  • In the Grid tab, the columns are empty.
  • In the Table Data Editor, after inserting records and selecting Save and Refresh, the messages is shown that "Changes Committed" but records are not displayed in columns.
  • In the native tool, the inserted records are displayed successfully.
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.

 

1 attachment

Issue #15153

New
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017