× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Shavibala Rajhans
Shavi57 reported 2013-10-25T05:24:50Z  · tariqrahiman last modified 2013-10-28T21:20:11Z

Does not show error message while adding constraint during alteration of table


Dev
Sachin Prakash
SachinPrakash
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component App - Visual Editing
Version Future - .1
Aqua Data Studio 14.0.3
Database version: Netezza 7.0
 
1.Create Database:
 
CREATE DATABASE TEST
GO
 
2. Create Table without Constraint:
 
CREATE TABLE "TEST"  ( 
"COL1" INT1  NULL,
"COL2" VARCHAR(25) NULL,
"COL3" VARCHAR(25) NULL
)
 
Table Created Successfully.
 
3.Alter Table "TEST" and Add Primary key Constraint to the table.
ALTER TABLE "TEST"
ADD CONSTRAINT "PK"
PRIMARY KEY ("COL1")
GO
 
ADS show that command is executed Successfully. ADS do not show any message or warnings. But when we check constraint node Primary Constraint is not added to the table.
 
NZSQL Prompt Behaviour:
 
Now go to nzsql prompt and Run above Alter Table query. The nzsql prompt will display the error message "Primary key constraint cannot be added, at least one of the fields is nullable".
 
  •  
  •  
  • No shares
  •  
All Comments (1) Change History
Sort 

Issue #10590
Closed
 
 
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