summaryrefslogtreecommitdiff
path: root/tests/basic
diff options
context:
space:
mode:
authorAnssi Kääriäinen <akaariai@gmail.com>2013-08-20 10:32:18 +0300
committerAnssi Kääriäinen <akaariai@gmail.com>2013-08-20 10:55:00 +0300
commit905409855c6b69f613190fcc2d8bd8bf5e1580b5 (patch)
treef93badc4eb4dc8a1122178624381c3f57d6d203a /tests/basic
parentb53ed351b34918e337cbf26773998dafc6f82f4d (diff)
Fixed #14056 -- Made sure LEFT JOIN aren't trimmed in ORDER BY
If LEFT JOINs are required for correct results, then trimming the join can lead to incorrect results. Consider case: TBL A: ID | TBL B: ID A_ID 1 1 1 2 Now A.order_by('b__a') did use a join to B, and B's a_id column. This was seen to contain the same value as A's id, and so the join was trimmed. But this wasn't correct as the join is LEFT JOIN, and for row A.id = 2 the B.a_id column is NULL.
Diffstat (limited to 'tests/basic')
0 files changed, 0 insertions, 0 deletions