Bug #26225 Engine condition pushdown doesn't work with prepared statements (ps_7ndb)
Submitted: 9 Feb 2007 16:28 Modified: 10 Apr 2007 6:50
Reporter: Martin Skold
Status: Closed
Category:Server: Cluster Severity:S3 (Non-critical)
Version:5.0 OS:Any
Assigned to: Martin Skold Target Version:

[9 Feb 2007 16:28] Martin Skold 
Description:
Preparaed statements which result in select statements with
conditions that might be possible to push to storage engines
fail due to missiing code for analyzing such query plans.

How to repeat:
Run:
./mysql-test-run.pl --mysqld="--engine-condition-pushdown=1" --do-test=ps_7ndb

Suggested fix:
Fix the code that analyzes the query plan.
[9 Feb 2007 16:31] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/19620

ChangeSet@1.2300, 2007-02-09 16:31:12+01:00, mskold@mysql.com +2 -0
  bug #26225  Engine condition pushdown doesn't work with prepare statements (ps_7ndb):
ensure that query plan for prepared statement is analyzed correctly
[21 Feb 2007 16:18] Tomas Ulin 
pushed to 5.1.16 release
[7 Apr 2007 9:00] Bugs System 
Pushed into 5.0.40
[10 Apr 2007 6:50] Jon Stephens 
Thank you for your bug report. This issue has been committed to our source repository of
that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available
version, including the bug fix. More information about accessing the source trees is
available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bugfix in 5.0.40 and 5.1.16 changelogs.