Bug #79699 mysqldbimport fails importing BIT fields

• Submitted: 18 Dec 2015 9:24
• Modified: 18 Dec 2015 9:48
• Reporter: Roberto Polli
• Status: Duplicate
• Category: MySQL Utilities
• Severity: S3 (Non-critical)
• Version: latest
• OS: Linux
• CPU Architecture: Any
• Tags: mysqldbimport, mysqldump

[18 Dec 2015 9:24] Roberto Polli

Description:
mysqldbimport fails importing BIT fields generated by:

  - mysqldump 
  - mysqldbexport

How to repeat:
1. Create and populate a table with bit fields;
2. export the table either with:
   - mysqldump test > dump.sql;
   - mysqldbexport --output-file=dump.sql;
3. mysqldbimport dump.sql

I expect:

  - data is correctly imported;

Instead:
  
  - you get an importing error

It's somehow related to http://bugs.mysql.com/bug.php?id=70404

Suggested fix:
I wrote a patch here, to insert BIT fields as 64bit integers:
 
  - https://github.com/mysql/mysql-utilities/pull/4

Let me know if it's fine.

[18 Dec 2015 9:27] Roberto Polli

fixed Category

[18 Dec 2015 9:32] MySQL Verification Team

Thank you for the bug report. Duplicate of https://bugs.mysql.com/bug.php?id=70404.

[18 Dec 2015 9:33] Roberto Polli

mysqldbimport fails to read this file

Attachment: mysqldbimport-fails-to-import-me.tsv (text/tab-separated-values), 793 bytes.

[18 Dec 2015 9:48] Roberto Polli

Hi Miguel,

while the bug is related to the linked one, I'm not sure it's a duplicate.

I can't read existing dump files with *mysqldbimport*.
They can't read existing dump files with *mysql*.

As my patch won't affect:

  - mysqldump output;
  - mysql import abilities.

the reporter of http://bugs.mysql.com/bug.php?id=70404 may not be interested in that.