× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Nilesh Mali
nileshhmali reported 2017-06-19T09:16:38Z  · tariqrahiman last modified 2017-08-11T19:57:28Z

"Identity" option is disabled in CREATE TABLE GUI for Float datatype.


Dev
Thomas Conrad
tomconrad
QA
Ivan Gron
ivangron
Priority Low
Complexity Unknown
Component DB - Oracle
Version 19.0
Product: Aqua Data Studio
Version: 19.0.0-alpha-47
Build #: 54772
Build Date: 2017-Jun-18 10:20:59 PM
 
Operating Environment: Linux (4.4.0-64-generic, amd64) / UTF-8 / en / US / Oracle Corporation 1.8.0_102-b14
Memory: Max=704,643,072;  Total=438,304,768;  Free=247,418,216;  CPUs=8
 
 
Connect Oracle12c
 
Scenario-01:
Go to table tree node and 
Right click on table tree node and select Create Table option
create table tab opens
Enter table name and column name
Select float datatype from datatype column
Go to options pane
 
Actual Result:
You can see that "Identity" option is disabled for Float datatype.
 
 
Scenario-02:
create a  table using below script
 
CREATE TABLE "c##C_nilesh"."Test_identity"  ( 
"c1" Float GENERATED ALWAYS AS IDENTITY NOT NULL,
"c2" VARCHAR2(25) NULL 
)
STORAGE( BUFFER_POOL DEFAULT )
PARALLEL( DEGREE DEFAULT )
GO
 
Go to table tree node and 
Right click on table tree node and select Alter table option
Alter table tab opens
Select float datatype column 
Go to options pane
 
 
Actual Result:
You can see that "Identity" option is not applied for Float datatype column.
 
 
Observation:
1)I have inserted values in this table without "c1"
 
INSERT INTO "c##C_nilesh"."Test_identity"( "c2") 
VALUES('nilesh')
GO
=>Data is inserted successfully.
 
 
2)I have inserted values in this table with "c1"
INSERT INTO "c##C_nilesh"."Test_identity"("c1", "c2") 
VALUES(3, 'nilesh')
GO
 
=>Execution failed and displayed error message "ORA-32795: cannot insert into a generated always identity column"
 
 
Expected Result:
"Identity" option should be enabled in CREATE TABLE GUI  for Float datatype.
 
Please refer doc
 
 
2 attachments
  •  
  •  
  • No shares
  •  
All Comments (7) Change History
Sort 

Issue #15323
Closed
Fixed
Resolved 2017-08-09T17:13:24Z
 
 
Completion
No due date
Fixed Build ADS 19.0.0-beta-38
No time estimate

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