diff options
| author | unknown <sanja@montyprogram.com> | 2012-05-07 21:14:37 +0300 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2012-05-07 21:14:37 +0300 |
| commit | ea8314fdd537d14061bb261e6494f38a8fc9291b (patch) | |
| tree | 26532ba2039fca7d1e35c8fd2bcc84dfb910c94b /mysql-test/t/select.test | |
| parent | d335b471918b4ab0bca05984a70669653cf3169f (diff) | |
| download | mariadb-git-ea8314fdd537d14061bb261e6494f38a8fc9291b.tar.gz | |
LP bug#994275 fix.
In 5.3 we substitute constants in ref access values it can't be null so we do not need add NOT NULL for early NULL filtering.
Diffstat (limited to 'mysql-test/t/select.test')
| -rw-r--r-- | mysql-test/t/select.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index 75ea88b6bde..b937462e3e9 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -4272,3 +4272,18 @@ DROP TABLE t1; DROP VIEW v1; SET optimizer_switch=@save_optimizer_switch; + +--echo # +--echo # LP bug#994275 Assertion `real->type() == Item::FIELD_ITEM' failed +--echo # in add_not_null_conds(JOIN*) with JOIN, ZEROFILL column, PK +--echo # + +CREATE TABLE t1 ( a INT(6) ZEROFILL ); +INSERT INTO t1 VALUES (1),(2); + +CREATE TABLE t2 ( b INT PRIMARY KEY ); +INSERT INTO t2 VALUES (3),(4); +SELECT * FROM t1, t2 WHERE a=3 AND a=b; +drop table t1,t2; + +--echo End of 5.3 tests |