Bug #75256 Joins are not pushed after WL6042
Submitted: 18 Dec 2014 9:59 Modified: 14 Feb 2015 17:00
Reporter: Magnus Blåudd Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:5.7.5 OS:Any
Assigned to: CPU Architecture:Any

[18 Dec 2014 9:59] Magnus Blåudd 
Description:
Tthe call to ha_make_pushed_join() must be done before
pick_table_access_method() since the latter potentially choose a different read_first_record and
read_record.read_record implementation based on the pushed_root created by ha_make_pushed_join.

How to repeat:
Discovered after merge of 5.7.5 into mysql-trunk-cluster[-stage]

Suggested fix:
Find the right place to put the call to ha_make_pushed_joinf().

Add tests for "pushed joins" to the new 'ndbcluster' integration suite which runs per push to mysql-trunk in PB.
[14 Feb 2015 17:00] Paul DuBois 
Noted in 5.7.6 changelog.

Pushed joins were not working for NDB tables.