search

DDieterich / DTGen

DTGEN Code Generation Tool for Relational Designers (See Wiki Branch)
http://dtgen.org
3 stars 0 forks source link

Need to Change Single Column Table Constraints to Column Constraints #48

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What will the enhancement do?

 -) Need to Change Single Column Table Constraints to Column Constraints

How is this currently done or handled?

 -) Table Constraints don't work the same way as column constraints in the optimizer

What version of the product are you using? On what operating system?

 -) Release 0.11

Please provide any additional information below.

 -) Both Not Null and Single Column Check Constraints

Original issue reported on code.google.com by Duane.Di...@gmail.com on 24 Jul 2012 at 12:14

GoogleCodeExporter commented 9 years ago 
alter table t1 modify c1 constraint t1_nn1 not null;
alter table t1 modify c1 constraint t1_ck1 check (c1 > 0);

Original comment by Duane.Di...@gmail.com on 24 Jul 2012 at 12:18

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
Only Not Null constraints were converted.  Check constraints like "c1 > 0" need 
to be limited to a single column constraint, and the column must be identified.

Original comment by Duane.Di...@gmail.com on 31 Jul 2012 at 7:36