diff options
| author | Michael Widenius <monty@askmonty.org> | 2010-11-28 15:02:12 +0200 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2010-11-28 15:02:12 +0200 |
| commit | b0d186e006609d2fde2c840281030fd2a4089709 (patch) | |
| tree | 23b4072fee071f412a4f9accd8f5a844f6e4a79b /mysql-test/t/subselect_cache.test | |
| parent | b2beb40728ba2f61a0c923a590512cf9dc0e11c3 (diff) | |
| download | mariadb-git-b0d186e006609d2fde2c840281030fd2a4089709.tar.gz | |
Disable warning that comes 'occasionable' depending on if HAVING is executed or not.
Diffstat (limited to 'mysql-test/t/subselect_cache.test')
| -rw-r--r-- | mysql-test/t/subselect_cache.test | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/t/subselect_cache.test b/mysql-test/t/subselect_cache.test index e8dd256b20b..12f42aab7d6 100644 --- a/mysql-test/t/subselect_cache.test +++ b/mysql-test/t/subselect_cache.test @@ -1598,6 +1598,8 @@ CREATE TABLE `t3` ( ) DEFAULT CHARSET=latin1; INSERT INTO `t3` VALUES (1,'w'); +# We may get warnings about 'h' not beeing a double here +--disable_warnings SELECT SUM( DISTINCT table2 . `pk` ) AS field2 , (SELECT SUM( SUBQUERY1_t2 . `pk` ) AS SUBQUERY1_field1 FROM t2 AS SUBQUERY1_t2 STRAIGHT_JOIN @@ -1610,4 +1612,5 @@ FROM ( t1 AS table1 LEFT JOIN WHERE ( table1 . `pk` < 5 ) OR ( table1 . `col_varchar_key` IS NOT NULL) GROUP BY field3 HAVING (field3 <= 'h' AND field2 != 4) ; +--enable_warnings drop tables t1, t2, t3; |