Problems with apostrophe

Bug #675425 reported by armakuni
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Connector/Python
Fix Released
Critical
Geert JM Vanderkelen

Bug Description

Problem:
I get SQL syntax error if inserted string has apostrophe with backslash before it: Example:
values = [[u"foo"], [u"bar"], [u"foo \\' bar"]]
cursor.executemany("INSERT INTO foo VALUES (%s)", values)

Environment:
0.2.1 devel 273
Windows XP
Python 2.7
MySQL 5.0.87

Related branches

Revision history for this message
Geert JM Vanderkelen (geertjmvdk) wrote :

Thank you for reporting this problem.
I managed to reproduce on Mac, thus not platform specific.

Changed in myconnpy:
assignee: nobody → Geert JM Vanderkelen (geertjmvdk)
importance: Undecided → Critical
status: New → Confirmed
Changed in myconnpy:
status: Confirmed → Fix Committed
Changed in myconnpy:
milestone: none → 0.2.2
Changed in myconnpy:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Bug attachments

Remote bug watches

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