Skip to Content
0
Apr 05, 2018 at 06:39 AM

SAP ASE 16.0: "default" and constraint do not work on a global temporary table

120 Views

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