Product Documentation

c-treeACE V10.0 Release Notes

Previous Topic

Next Topic

c-treeACE SQL Default Value Usage Corrected for BIT Columns

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.

TOCIndex