Drizzledump migration does not appear to handle BIT datatype gracefully

Bug #684986 reported by Patrick Crews
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Fix Released
Andrew Hutchings
Fix Released
Andrew Hutchings

Bug Description

When attempting to migrate a table composed of various BIT columns, drizzledump migration failed as follows:

../client/drizzledump --compact --host= --port=13000 --destination-type=database --destination-host=localhost --destination-port=9306 --destination-user=root --destination-database=drizzledump_migrate_test --user=root drizzledump_migrate_test
Error executing query: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near 'BIT DEFAULT NULL, `col_bit1_not_null` BIT NOT NULL, `col_bit1_default_null` BI' at line 1

MySQL table:
CREATE TABLE bit_table(description TEXT,
col_bit1 bit(1),
col_bit1_not_null bit(1) NOT NULL,
col_bit1_default_null bit(1) DEFAULT NULL,
col_bit1_default_min bit(1) DEFAULT 0,
col_bit1_default_max bit(1) DEFAULT 1,
col_bit64 bit(64),
col_bit64_default_null bit(64) DEFAULT NULL,
col_bit64_default_min bit(64) DEFAULT 0,
col_bit64_default_max bit(64) DEFAULT b'1111111111111111111111111111111111111111111111111111111111111111'

To repeat:
Use the attached branch and run:
./test-run --suite=mysql_migrate bit_type
View the README in drizzle/tests/suite/mysql_migrate for further details on how to run this particular suite.

Related branches

Changed in drizzle:
assignee: nobody → Andrew Hutchings (linuxjedi)
status: New → Confirmed
Changed in drizzle:
importance: Undecided → High
milestone: none → 2010-12-20
Revision history for this message
Andrew Hutchings (linuxjedi) wrote :

ok, so Drizzle doesn't do BIT data type, I missed that one

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.