× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ranarohitp(*) reported 2013-05-20T12:16:29Z  · last modified 2013-06-07T10:56:57Z

Extra check keyword in Sybase ASE


Priority Major
Complexity Unknown
Component Tools - Compare
Version 14.0

ADS version : ads-windows-x64-14.0.0-alpha-18
Database:Sybase ASE 15.7.

To reproduce:
 Connect to Sybase ASE and create given below tables.
 

create table employee_sybase
(ID SMALLINT NOT NULL,
NAMEa VARCHAR(9) ,
DEPT SMALLINT,
JOB CHAR(5) CHECK (JOB IN ('Sales', 'Mgr', 'Clerk')),
HIREDATE DATE,
LEVDATE DATE,
SALARY DECIMAL(7,2),
COMM DECIMAL(7,2),
PRIMARY KEY (ID),
CONSTRAINT yearsal CHECK ((HIREDATE > LEVDATE) OR (SALARY > 40500)),
constraint deptid CHECK (DEPT BETWEEN 10 AND 100) )

create table employee_sybase
(ID SMALLINT NOT NULL,
NAMEa VARCHAR(9) CHECK (NAMEa IN ('Sales', 'Mgr', 'Clerk')) ,
DEPT SMALLINT,
JOB CHAR(5) CHECK (JOB IN ('Sales', 'Mgr', 'Clerk')),
HIREDATE DATE,
LEVDATE DATE,
SALARY DECIMAL(7,2),
COMM DECIMAL(7,2),
PRIMARY KEY (ID),
CONSTRAINT yearsal CHECK ((HIREDATE > LEVDATE) OR (SALARY > 40500)),
constraint deptid CHECK (DEPT BETWEEN 10 AND 100)).

Go to Tools->Compare Tools->Schema compare->Choose server1 and server2 as Syabse ASE-> Select respective table and schema values from list and from options select all options.

Now in result look for system generated constraint names you will see that there will be "double" check keyword. Where we have given constraint names there will be only single check constraint keyword.

1 attachment

Issue #9036

Closed
Fixed
Resolved 2013-05-20T20:48:20Z
 
 
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