Generates 0x in script for empty blob type field

Compares and synchronizes MySQL database content

Moderators: Chris Auckland, eddie davis, Michael Christofides

Generates 0x in script for empty blob type field

Postby hrjk » Fri Feb 21, 2014 6:25 pm

MySQL Data Compare generates scripts with 0x for empty value for blob type field and when i run the script in MySQL workbench it throws this error "Error Code: 1054. Unknown column '0x' in 'field list'" error. How can I fix it or is it a bug?
hrjk
 
Posts: 3
Joined: Fri Feb 21, 2014 6:17 pm

Postby eddie davis » Mon Feb 24, 2014 5:42 pm

Thank you for your forum post.

This is an error I personally not seen before. Is the cause of the error due to the '0x' only having single quotation marks surrounding it where it needs two single quotation marks, ''0x'', as per this internet ARTCLE?

If the answer is yes, I will need to submit a bug report.

A support call has been created for you HERE. Would it be possible to obtain a CREATE TABLE syntax for us to attempt a reproduction? Please either update the support call or reply to this forum post.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby hrjk » Mon Feb 24, 2014 7:17 pm

No it generates script without any quotation mark like shown below:

Code: Select all
INSERT INTO tablename VALUES (0x, 0x, 'testabc');


But if the blob field is not empty then it generates hex value without quotation mark and that works fine but only for empty value it generates script like above and when I run that script it throws error.
hrjk
 
Posts: 3
Joined: Fri Feb 21, 2014 6:17 pm

Postby hrjk » Mon Feb 24, 2014 9:31 pm

If you can generate script like below for empty blob field then that should work:

Code: Select all
INSERT INTO tablename VALUES ('', '', 'testabc');
hrjk
 
Posts: 3
Joined: Fri Feb 21, 2014 6:17 pm

Postby eddie davis » Mon Mar 03, 2014 5:53 pm

Thank you for your reply.

With the further information you have provided, I am able to reproduce this problem. Therefore I have submitted a Bug Report for the Product manager and Development Team to consider. The Bug Report reference is MSDC-33.

Now for the bad news, sadly I do not know when this bug will be fixed. I will be maintaining what our bug tracking system calls a 'watch' on the report submitted, which means I can update when a fix for the problem becomes available.

Thank you for bringing this error to our attention.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to MySQL Data Compare

Who is online

Users browsing this forum: No registered users and 1 guest