|
|
|
An ALTER TABLE of the following construct:
ALTER TABLE groups ADD "IsExpired" bit not null default '1';
was failing with this error:
Error : -21042 Error Description : CTDB - Can't perform type conversion
BIT fields are mapped into c-treeACE type CT_BOOL and default values are set as strings. When adding the new field, the ALTER TABLE logic tried to apply the default value passing the string "1". However, CT_BOOL only converted the strings "true" and "false" (case insensitive).
Comparison logic was modified to allow proper Boolean checking.
