MySQL DataType - BIT size and default not captured on Snapshot

Description

Create table like so:

CREATE TABLE TESTBIT(
BIT_NULL BIT(6) NULL,
BIT_NOTNULL BIT(6) NOT NULL,
BIT_DEFAULT BIT(6) DEFAULT '1',
BIT_PK BIT(6) NOT NULL,
BIT_UNIQUE BIT(6) NOT NULL,
CONSTRAINT PK_BIT PRIMARY KEY (BIT_PK),
CONSTRAINT UN_BIT UNIQUE (BIT_UNIQUE)
);

Note the sizing of BIT(6). Take snapshot and note the size is BIT(1)

<changeSet author="robert" id="1383674467554-3">
<createTable tableName="testbit">
<column name="BIT_NULL" type="BIT(1)"/>
<column name="BIT_NOTNULL" type="BIT(1)">
<constraints nullable="false"/>
</column>
<column defaultValueNumeric="110001" name="BIT_DEFAULT" type="BIT(1)"/>
<column name="BIT_PK" type="BIT(1)">
<constraints nullable="false"/>
</column>
<column name="BIT_UNIQUE" type="BIT(1)">
<constraints nullable="false"/>
</column>
</createTable>
</changeSet>

Environment

Linux and MySQL

Activity

Show:
Fixed

Details

Reporter

Fix versions

Affects versions

Priority

Created November 11, 2013 at 8:44 PM
Updated November 27, 2013 at 4:10 PM
Resolved November 27, 2013 at 4:10 PM