diff options
| author | unknown <mskold@mysql.com> | 2005-05-09 18:56:29 +0200 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2005-05-09 18:56:29 +0200 |
| commit | 9e04ebfa99c12ffef5f03846c3696ba650986f4b (patch) | |
| tree | a3d7b83970e3b023e85cf9a51bf68db2bf25eeae /mysql-test/t/ndb_condition_pushdown.test | |
| parent | 848611b5ed1e565d02eea896e22753b818c458c5 (diff) | |
| download | mariadb-git-9e04ebfa99c12ffef5f03846c3696ba650986f4b.tar.gz | |
Fix for Bug #9246 Condition pushdown and left join, wrong result
Diffstat (limited to 'mysql-test/t/ndb_condition_pushdown.test')
| -rw-r--r-- | mysql-test/t/ndb_condition_pushdown.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_condition_pushdown.test b/mysql-test/t/ndb_condition_pushdown.test index 1d201a94c95..c6f3f67a65f 100644 --- a/mysql-test/t/ndb_condition_pushdown.test +++ b/mysql-test/t/ndb_condition_pushdown.test @@ -1044,6 +1044,8 @@ explain select auto from t1 where string = "aaaa" collate latin1_general_ci order by auto; explain select * from t2 where (attr1 < 2) = (attr2 < 2) order by pk1; +explain +select * from t3 left join t4 on t4.attr2 = t3.attr2 where t4.attr1 > 1 and t4.attr3 < 5 or t4.attr1 is null order by t4.pk1; set engine_condition_pushdown = @old_ecpd; DROP TABLE t1,t2,t3,t4; |