diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2012-05-21 20:54:41 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2012-05-21 20:54:41 +0200 |
| commit | 1185420da0964b2f06d9fd91bd02d067b0a359de (patch) | |
| tree | 0b4162e316a18fa6ce3f56ee447454b4c73d1805 /mysql-test/t/select.test | |
| parent | 431e042b5d76ed5fd219c39db798c9e7478731c8 (diff) | |
| parent | 7f6f53a8df10c76f93848c8d06bc5af71051c525 (diff) | |
| download | mariadb-git-1185420da0964b2f06d9fd91bd02d067b0a359de.tar.gz | |
5.3 merge
Diffstat (limited to 'mysql-test/t/select.test')
| -rw-r--r-- | mysql-test/t/select.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index 44fb3ba46f5..3a85ca3a3a9 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -4447,3 +4447,17 @@ DROP VIEW view_t1; 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 |