NOTE: This appears related to bug - https://bugs.launchpad.net/drizzle/+bug/585628 Adding STRAIGHT_JOIN to certain queries results in loss of returned rows, but the effect is the opposite.
Still researching a bit on both of these and will update / close one out as a duplicate if evidence appears to point to a single root cause.
NOTE: This appears related to bug - https:/ /bugs.launchpad .net/drizzle/ +bug/585628 Adding STRAIGHT_JOIN to certain queries results in loss of returned rows, but the effect is the opposite.
Still researching a bit on both of these and will update / close one out as a duplicate if evidence appears to point to a single root cause.