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

Derby

Setting default value for a char(1) for bit data column does not work

Created: 07/Oct/04 12:03 AM Updated: 11/Apr/06 12:38 AM

Return to search

Component/s:

SQL

Affects Version/s:

10.0.2.0

Fix Version/s:

10.0.2.1

Time Tracking:

Not Specified

Resolution Date:

11/Apr/06 12:37 AM

Description

« Hide

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'.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

[ Permlink | « Hide ]

Satheesh Bandaram added a comment - 24/Nov/04 12:34 AM

Submitted fix for satheesh@Sourcery.org.

SVN LOG: 53974

[ Permlink | « Hide ]

Sunitha Kambhampati added a comment - 21/Jan/05 07:42 AM

I have tested it and it works ok; so closing the bug.

[ Permlink | « Hide ]

Sunitha Kambhampati added a comment - 11/Apr/06 12:37 AM

Updating the fixin.

http://svn.apache.org/viewcvs.cgi?view=rev&rev=53974