|
|
|
When using a "regular" SQL Alter Table (not a "hot alter table"), the following failed:
CREATE TABLE Hot(id BIGINT PRIMARY KEY, allow_update BIT, f1 INTEGER );
INSERT INTO Hot (id,allow_update,f1) VALUES (1,0,1319664638);
--works
ALTER TABLE hot add f26 BINARY(22) DEFAULT '2-28-2000 12:01:11.001';
select CASE f26 WHEN '2-28-2000 12:01:11.001' THEN 'PASS' ELSE 'FAIL' END as T23 from Hot WHERE id = 1;
ALTER TABLE hot add f27 VARBINARY(22) DEFAULT '2-28-2000 12:01:11.001';
select CASE f27 WHEN '2-28-2000 12:01:11.001' THEN 'PASS' ELSE 'FAIL' END as T24 from Hot WHERE id = 1;
error(-21025): CTDB - Internal error
and "PANIC - SEG read_record_buffer SQL data format error -20052 reading .\ctreeSQL.dbs\admin_hot field 3 offset 19351 PID 18768"
The logic has been corrected.
