Transaction_reader not handling CHAR values that include quotes properly

Bug #643630 reported by Patrick Crews
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
Medium
David Shrewsbury
7.0
Fix Released
Medium
David Shrewsbury

Bug Description

drizzled/message/transaction_reader isn't handling CHAR values containing quotes properly:
INSERT INTO `test`.`aa` (`pk`,`col_char_10`,`col_bigint`,`col_text`,`col_char_10_key`,`col_char_10_not_null`,`col_char_1024`,`col_int`,`col_enum_not_null_key`,`col_enum`,`col_bigint_not_null_key`,`col_char_1024_not_null_key`,`col_int_not_null_key`,`col_bigint_not_null`,`col_char_1024_not_null`,`col_char_10_not_null_key`,`col_int_key`,`col_text_not_null`,`col_char_1024_key`,`col_enum_not_null`,`col_bigint_key`,`col_text_key`,`col_text_not_null_key`,`col_int_not_null`,`col_enum_key`) VALUES

(4,'didn't',6,NULL,'HMHFF','BYTHJ','PUKQU',9,'o','n',-9123448420122492928,'d',880148480,-2739595948324814848,'TQVBJ','your',1734213632,'','on','o',NULL,NULL,'',295501824,'d');

NOTE the second value in the values_list - 'didn't'

The mix of quoting the value + the quote in the value itself is causing INSERTs based on transaction_reader output to fail

I can work around this by not allowing such values into the test bed, but this is something we need to fix / code for, I suspect.

Tags: replication

Related branches

Changed in drizzle:
status: New → Confirmed
importance: Undecided → Medium
Changed in drizzle:
assignee: nobody → David Shrewsbury (dshrews)
tags: added: replication
Changed in drizzle:
status: Confirmed → In Progress
Changed in drizzle:
status: In Progress → Fix Committed
milestone: none → 2010-09-27
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.