Hello,
Does global temporary table support "default" and constraint?
I defined default value on a column in global temporary table on ASE 16.0 SP03 PL02, but it does not work.
I added check constraint on another column, but the constraint is ignored.
Reproducing the issues:
1> create global temporary table t1 (a int not null, b int default 0 null)
2> go
1> insert into t1 (a) values (1)
2> go
(1 row affected)
1> select * from t1
2> go
a b
----------- -----------
1 NULL
(1 row affected)
1> create global temporary table t2 (a int check (a>0))
2> go 1> insert into t2 values (-12345) 2> go (1 row affected) 1> select * from t2 2> go a ------------ -12345 (1 row affected) 1>
CR 813529 may be describing this issue.
"CR 813529 Correct handling of default values for global temporary tables. See KBA 2608519."
I tried to see KBA 2608519 for detail, but blocked.
Could anyone make sure they are the known issues?
Regrads,
Kazuo Otani