Product Documentation

V11.5 Release Notes

Previous Topic

Next Topic

SQL - DEFAULT NUMERIC, BIGINT values

The following SQL statement failed:

CREATE TABLE Hot(id BIGINT PRIMARY KEY, allow_update BIT, f1 INTEGER );

INSERT INTO Hot (id,allow_update,f1) VALUES (1,0,1319664638);

ALTER TABLE hot add f13 BIGINT DEFAULT 77777777777777777;

select f13,CASE f13 WHEN 77777777777777777 THEN 'PASS' ELSE 'FAIL' END as T10 from Hot WHERE id = 1;

ALTER TABLE hot add f14 NUMERIC(32,4) DEFAULT 7777777777777777777777777777.7777;

select f14,CASE f14 WHEN 7777777777777777777777777777.7777 THEN 'PASS' ELSE 'FAIL' END as T11 from Hot WHERE id = 1;

ALTER TABLE hot add f15 MONEY(30) DEFAULT -7777777777777777777777777777.99;

select f15,CASE f15 WHEN -7777777777777777777777777777.99 THEN 'PASS' ELSE 'FAIL' END as T12 from Hot WHERE id = 1;

The logic has been modified to correct this.

TOCIndex