[Commits] Rev 2855: Disable warning that comes 'occasionable' depending on if HAVING is executed or not. in lp:maria/5.3

Michael Widenius monty at askmonty.org
Sun Nov 28 15:02:12 EET 2010


At lp:maria/5.3

------------------------------------------------------------
revno: 2855
revision-id: monty at askmonty.org-20101128130212-0kxl3o2rfwiqbdfa
parent: monty at askmonty.org-20101128123859-ctg8g3verq4ivhn4
committer: Michael Widenius <monty at askmonty.org>
branch nick: maria-5.3
timestamp: Sun 2010-11-28 15:02:12 +0200
message:
  Disable warning that comes 'occasionable' depending on if HAVING is executed or not.
-------------- next part --------------
=== modified file 'mysql-test/t/subselect_cache.test'
--- a/mysql-test/t/subselect_cache.test	2010-11-09 11:13:56 +0000
+++ b/mysql-test/t/subselect_cache.test	2010-11-28 13:02:12 +0000
@@ -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;



More information about the commits mailing list