diff options
| author | sergefp@mysql.com <> | 2005-09-09 10:54:59 +0400 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2005-09-09 10:54:59 +0400 |
| commit | 3d6759d1909a2565e0d0265a4eb78178816321e9 (patch) | |
| tree | d061df624f7dfc9d9b60f22b9a9d7e570f0a819d /mysql-test/t/group_by.test | |
| parent | 9c51a97e90107e1ce69844c48062fb85a6b26bb7 (diff) | |
| parent | 819db2471c967aca1cf1d3a564cabbf2cd4ddb07 (diff) | |
| download | mariadb-git-3d6759d1909a2565e0d0265a4eb78178816321e9.tar.gz | |
Merge 4.1->5.0
Diffstat (limited to 'mysql-test/t/group_by.test')
| -rw-r--r-- | mysql-test/t/group_by.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/group_by.test b/mysql-test/t/group_by.test index 8300b502518..4631fad3352 100644 --- a/mysql-test/t/group_by.test +++ b/mysql-test/t/group_by.test @@ -575,6 +575,16 @@ CREATE TABLE t1 (id varchar(20) NOT NULL); INSERT INTO t1 VALUES ('trans1'), ('trans2'); CREATE TABLE t2 (id varchar(20) NOT NULL, err_comment blob NOT NULL); INSERT INTO t2 VALUES ('trans1', 'a problem'); +# +# BUG#12695: Item_func_isnull::update_used_tables +# did not update const_item_cache +# +create table t1(f1 varchar(5) key); +insert into t1 values (1),(2); +select sql_buffer_result max(f1) is null from t1; +select sql_buffer_result max(f1)+1 from t1; +drop table t1; + SELECT COUNT(DISTINCT(t1.id)), LEFT(err_comment, 256) AS comment FROM t1 LEFT JOIN t2 ON t1.id=t2.id GROUP BY comment; |