JaverSphinxBundle icon indicating copy to clipboard operation
JaverSphinxBundle copied to clipboard

Published 20 hours ago • verified publisher icon javer

Bug - Floats cast as Strings cause Sphinx Error

Open Bastlynn opened this issue 4 years ago • 1 comments

In Sphinx::quoteValue() - passed in float values will end up getting quoted as strings. Sphinx will then throw an error complaining about the type mismatch between a string and a float column.

Bastlynn avatar Feb 11 '21 03:02 Bastlynn

Following up on this - it looks like Sphinx gets picky about the float type not accepting ints for comparison when upgrading from version Sphinx 2.2.11-id64-release to 2.3.1-beta. So this is a bug people are gonna hit when the beta is released.

Relevant builds: https://launchpad.net/~builds/+archive/ubuntu/sphinxsearch-daily https://launchpad.net/~builds/+archive/ubuntu/sphinxsearch-beta

I'm testing a fix in my LDE now, when it's ready I'll do a PR and add tests for it.

Bastlynn avatar Feb 11 '21 14:02 Bastlynn