I'm using Sphinx (1.10beta) with strings. and when I pass a string that looks like a number
the server barfs:
DBD::Wire10::st execute failed: row 1, column 2: string expected
The reason is that the string is passed as a number in the statement to the server.
INSERT ... VALUES (94107)
instead of
INSERT ... VALUES ('94107')
binding this param to a SQL_VARBINARY breaks it even further (with a _binary prefix that the
server doesn't seem to understand), and SQL_VARCHAR doesn't help.
I found the reason being this line:
$value = Net::Wire10::Util::quote($value) if $value !~ $workaround_bug_1337;
If the value is always quoted it works.