|
|
|
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.
