ahiguti/HandlerSocket-Plugin-for-MySQL — Issue #72: IN() query silently failing to filter when column is not in base query
Author: Azhrarn
Created: 2012-01-16 21:32:42+00:00
State: open

Lets see if I can write this out in a sane way:
If you have a query with a multi field index, like "id, group_id"

And then do a request that matches the first column, and uses an IN() query to match the second column, like so:

1 = 1 55 1 0 @ 1 2 200 300

\

The result set completely ignores the IN() arguments, returning any fields that match the main part of the query sans the IN() data. No errors are given either.

The IN() query works if I specify the in() column in the match fields. But that's less then useful in this particular case (as I'm doing an = check, not a range). :(

Thanks, let me know if you need any more information!