#11829: System generated column should not be included in Insert script generated by ADS.

chandradipjain(*) reported 2014-03-07T06:58:44Z · last modified 2014-11-27T20:08:02Z

System generated column should not be included in Insert script generated by ADS.

Dev	ivangron
QA	tariqrahiman

Priority	Major
Complexity	Unknown

Component	DB - Oracle
Version	15.0

Aqua Data Studio 15.0.0-dev-145

Build #: 36514

Built on: 2014-Mar-06 04:40:22 PM

OS Environment: Windows 8(x64 bit)

Database: Oracle 12C

Steps to reproduce:

1. Connect to Oracle 12c server,Go to schemas folder --> Select any schema

2. Create Table in selected schema

CREATE TABLE "C##TEST"."Employee" (

"ID" NUMBER(15,5) NULL,

"EName" VARCHAR2(25) NULL,

"Location" VARCHAR2(25) NULL,

"Salary" NUMBER(15,5) NULL,

)

3. Create Index in descending order on above table

CREATE INDEX "C##TEST"."indxDSC"

ON "C##TEST"."Employee"("Salary" DESC)

"SYS_NC00005$" virtual column is also generated by the system in table.

4. Select and right click on above created table, Select Script Object to window as --> INSERT option

5. Below Insert script generated by ADS

INSERT INTO "C##TEST"."Employee"("ID", "EName", "Location", "Salary", "SYS_NC00005$")

VALUES(0, '', '', 0, '')

6. System doesn't allow us to do insert operation on Virtual column.

So system generated virtual column should not be included in INSERT script generated by ADS.

Please see attached screenshot.

2 attachments

virtualCol_Insert.png

2014-03-07T06:58:44Z

116 KB
Screen Shot 2014-11-25 at 4.57.49 PM.png

2014-11-26T00:57:57Z

108 KB

All Comments (4) Change History

tariqrahiman 2014-11-26T00:58:48Z

SQL Developer does not display the System Generated Column. See attached screenshot

ivangron 2014-11-26T16:56:43Z

There is a bug in the code. The invisible columns should be displayed in the tree node but they shouldn't be scripted unless they are user generated. Looking at extraction code history to see what happen, should have a fix in the next hour.

ivangron 2014-11-26T17:31:45Z · (edited)

Code has been fixed in the following ways.

1.) Tree Node will now only display the User Generated Columns [visible or invisible]. Any system generated columns will no longer display in the tree node.

2.) All extraction and scripting will only work with the user generated Columns. System generated columns should have never been added to the object.

Checking code into data studio version 15 and 16

tariqrahiman 2014-11-27T20:08:02Z

Verified in ADS v15.0.11-4

Search Tips

Aqua Data Studio / nhilam

System generated column should not be included in Insert script generated by ADS.

2 attachments

Issue #11829

Completion

Search Tips

Aqua Data Studio / nhilam

Title

System generated column should not be included in Insert script generated by ADS.

2 attachments

Issue #11829

Completion