Download - Draware

Bugs Fixed
fixed by A. Harrison
~ ~ ~
SF #223060
Processing of the GREATER-THAN operator was too slow.
fixed by V. Horsun
~ ~ ~
Not registered
CHECK constraints were not SQL-compliant with regard to the handling of
NULL. Until now, if NULL were to be allowed, it had to be specified explicitly in the constraint
definition. Under the standard, NULL is allowed unless explicitly constrained by NOT NULL or
CHECK (.. IS NOT NULL).
Example of Problem
The following definition now allows NULL in DEPTNO, where previously it did not:
CHECK (DEPTNO IN (10, 20, 30))
fixed by P. Ruizendaal, D. Yemanov
~ ~ ~
Not registered
NULLs.
It was possible to create a primary key constraint on a column consisting of
Example of Problem
create table bug (f1 int not null, f2 int not null);
insert into bug (f1, f2) values (1, 1);
commit;
alter table bug add pk int not null primary key;
fixed by V. Horsun
~ ~ ~
SF #1334034
REVOKE was damaging the ACL (Access Control List).
fixed by D. Yemanov
~ ~ ~
129