Changes between Initial Version and Version 1 of Ticket #32711, comment 2
- Timestamp:
- May 12, 2021, 9:34:12 AM (3 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #32711, comment 2
initial v1 5 5 https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html 6 6 7 It seems we are properly following the docs though with our `outer_expr=inner_expr` usage via `U0.id = auth_user.id` unless MySQL doesn't like swapping usto `inner_expr=outer_expr` format?7 It seems we are properly following the docs though with our `outer_expr=inner_expr` usage via `U0.id = auth_user.id` unless MySQL doesn't like us swapping to `inner_expr=outer_expr` format? 8 8 9 9 Thomas, are you using the latest version of MySQL 5.7 and does swapping `AND U0.id = auth_user.id` to `AND auth_user.id = U0.id` in the subquery make any difference?