[DERBY-34] Setting default value for a char(1) for bit data column does not work

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.0.2.0
• Fix Version/s: 10.0.2.1
• Component/s: SQL
• Assignee: Satheesh E. Bandaram
• Reporter: Sunitha Kambhampati
• Created: 07/Oct/04 00:03
• Updated: 11/Apr/06 00:38
• Resolved: 11/Apr/06 00:37

Description

create table t2 (i1 char(1) for bit data default x'02');

throws the following error:
ERROR 42894: DEFAULT value or IDENTITY attribute value is not valid for column 'I1'.