[ http://issues.apache.org/jira/browse/DERBY-34?page=history ] Sunitha Kambhampati closed DERBY-34: ------------------------------------
I have tested it and it works ok; so closing the bug. > Setting default value for a char(1) for bit data column does not work > --------------------------------------------------------------------- > > Key: DERBY-34 > URL: http://issues.apache.org/jira/browse/DERBY-34 > Project: Derby > Type: Bug > Components: SQL > Versions: 10.0.2.0 > Reporter: Sunitha Kambhampati > > 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'. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
