odd mis-interpretation of bind parameter on OSX
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
oursql |
Incomplete
|
Undecided
|
Aaron Gallagher |
Bug Description
I'm not sure what this one is about, as I've used OurSQL successfully on OSX in the past and I don't recall a bug like this one. This is reproducible with OurSQL 0.9.2 as well as trunk (your trunk still has "0.9.2" for __version__, FYI), on Mac OSX 10.6.5 MySQL 5.1.22:
import oursql
c = oursql.
cursor = c.cursor()
cursor.
print cursor.fetchall()
result:
[(u'f',)]
it doesn't get much better if you try adding params:
import oursql
c = oursql.
cursor = c.cursor()
cursor.
print cursor.fetchall()
[(u'f', u'bar', u'b')]
the correct answer is of course "(('foo', 'bar', 'bat'),)" which is what you get with MySQLdb, so this is an OurSQL issue.
I can't reproduce this bug on my computer. 10.6.5, mysql client/server 5.1.48, oursql trunk. I'll install 5.1.22 later tonight to try it, but I'm pretty sure this is a mysql bug that's since been fixed.