diff options
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/bigint.result | 4 | ||||
| -rw-r--r-- | mysql-test/r/dyncol.result | 44 | ||||
| -rw-r--r-- | mysql-test/r/explain.result | 15 | ||||
| -rw-r--r-- | mysql-test/r/func_math.result | 2 | ||||
| -rw-r--r-- | mysql-test/r/func_str.result | 250 | ||||
| -rw-r--r-- | mysql-test/r/join_outer.result | 2 | ||||
| -rw-r--r-- | mysql-test/r/join_outer_jcl6.result | 2 | ||||
| -rw-r--r-- | mysql-test/r/mysqldump-max.result | 8 | ||||
| -rw-r--r-- | mysql-test/r/select.result | 13 | ||||
| -rw-r--r-- | mysql-test/r/select_jcl6.result | 13 | ||||
| -rw-r--r-- | mysql-test/r/select_pkeycache.result | 13 | ||||
| -rw-r--r-- | mysql-test/r/subselect.result | 19 | ||||
| -rw-r--r-- | mysql-test/r/subselect_no_mat.result | 19 | ||||
| -rw-r--r-- | mysql-test/r/subselect_no_opts.result | 19 | ||||
| -rw-r--r-- | mysql-test/r/subselect_no_semijoin.result | 19 | ||||
| -rw-r--r-- | mysql-test/r/type_blob.result | 6 | ||||
| -rw-r--r-- | mysql-test/r/type_newdecimal.result | 16 | ||||
| -rw-r--r-- | mysql-test/r/warnings.result | 2 |
18 files changed, 301 insertions, 165 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result index 38c417b4628..2dac5614f9f 100644 --- a/mysql-test/r/bigint.result +++ b/mysql-test/r/bigint.result @@ -362,12 +362,12 @@ select cast(19999999999999999999 as signed); cast(19999999999999999999 as signed) 9223372036854775807 Warnings: -Error 1655 Got overflow when converting '19999999999999999999' to INT. Value truncated. +Error 1657 Got overflow when converting '19999999999999999999' to INT. Value truncated. select cast(-19999999999999999999 as signed); cast(-19999999999999999999 as signed) -9223372036854775808 Warnings: -Error 1655 Got overflow when converting '-19999999999999999999' to INT. Value truncated. +Error 1657 Got overflow when converting '-19999999999999999999' to INT. Value truncated. select -9223372036854775808; Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr def -9223372036854775808 8 20 20 N 32897 0 63 diff --git a/mysql-test/r/dyncol.result b/mysql-test/r/dyncol.result index f58340841c2..b6584a6fe55 100644 --- a/mysql-test/r/dyncol.result +++ b/mysql-test/r/dyncol.result @@ -41,7 +41,7 @@ select hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS unsigned int)); hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS unsigned int)) 000100010001FFFFFFFFFFFFFF7F Warnings: -Error 1655 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated. +Error 1657 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated. select hex(COLUMN_CREATE(1, NULL AS int)); hex(COLUMN_CREATE(1, NULL AS int)) 000000 @@ -67,7 +67,7 @@ select hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS int)); hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS int)) 000100010000FEFFFFFFFFFFFFFF Warnings: -Error 1655 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated. +Error 1657 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated. select hex(COLUMN_CREATE(1, NULL AS double)); hex(COLUMN_CREATE(1, NULL AS double)) 000000 @@ -211,7 +211,7 @@ select column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 as unsigned int) 18446744073709551615 Warnings: -Error 1655 Got overflow when converting '99999999999999999999999999999' to UNSIGNED INT. Value truncated. +Error 1657 Got overflow when converting '99999999999999999999999999999' to UNSIGNED INT. Value truncated. select column_get(column_create(1, 999.9999999999999999 AS decimal), 1 as unsigned int); column_get(column_create(1, 999.9999999999999999 AS decimal), 1 as unsigned int) 1000 @@ -219,12 +219,12 @@ select column_get(column_create(1, -1 AS decimal), 1 as unsigned int); column_get(column_create(1, -1 AS decimal), 1 as unsigned int) 0 Warnings: -Error 1655 Got overflow when converting '-1' to UNSIGNED INT. Value truncated. +Error 1657 Got overflow when converting '-1' to UNSIGNED INT. Value truncated. select column_get(column_create(1, 99999999999999999999999999999 AS double), 1 as unsigned int); column_get(column_create(1, 99999999999999999999999999999 AS double), 1 as unsigned int) 18446744073709551615 Warnings: -Warning 1655 Got overflow when converting '1e+29' to UNSIGNED INT. Value truncated. +Warning 1657 Got overflow when converting '1e+29' to UNSIGNED INT. Value truncated. select column_get(column_create(1, 999.9 AS double), 1 as unsigned int); column_get(column_create(1, 999.9 AS double), 1 as unsigned int) 1000 @@ -232,12 +232,12 @@ select column_get(column_create(1, -1 AS double), 1 as unsigned int); column_get(column_create(1, -1 AS double), 1 as unsigned int) 0 Warnings: -Warning 1655 Got overflow when converting '-1' to UNSIGNED INT. Value truncated. +Warning 1657 Got overflow when converting '-1' to UNSIGNED INT. Value truncated. select column_get(column_create(1, "1212III" AS char), 1 as unsigned int); column_get(column_create(1, "1212III" AS char), 1 as unsigned int) 1212 Warnings: -Warning 1657 Encountered illegal value '1212III' when converting to UNSIGNED INT +Warning 1659 Encountered illegal value '1212III' when converting to UNSIGNED INT # # column get int # @@ -296,12 +296,12 @@ select column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 as int) 9223372036854775807 Warnings: -Error 1655 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated. +Error 1657 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated. select column_get(column_create(1, -99999999999999999999999999999 AS decimal), 1 as int); column_get(column_create(1, -99999999999999999999999999999 AS decimal), 1 as int) -9223372036854775808 Warnings: -Error 1655 Got overflow when converting '-99999999999999999999999999999' to INT. Value truncated. +Error 1657 Got overflow when converting '-99999999999999999999999999999' to INT. Value truncated. select column_get(column_create(1, 999.9999999999999999 AS decimal), 1 as int); column_get(column_create(1, 999.9999999999999999 AS decimal), 1 as int) 1000 @@ -312,17 +312,17 @@ select column_get(column_create(1, -99999999999999999999999999999 AS double), 1 column_get(column_create(1, -99999999999999999999999999999 AS double), 1 as int) -9223372036854775808 Warnings: -Warning 1655 Got overflow when converting '-1e+29' to INT. Value truncated. +Warning 1657 Got overflow when converting '-1e+29' to INT. Value truncated. select column_get(column_create(1, "-1212III" AS char), 1 as int); column_get(column_create(1, "-1212III" AS char), 1 as int) -1212 Warnings: -Warning 1657 Encountered illegal value '-1212III' when converting to INT +Warning 1659 Encountered illegal value '-1212III' when converting to INT select column_get(column_create(1, "1212III" AS char), 1 as int); column_get(column_create(1, "1212III" AS char), 1 as int) 1212 Warnings: -Warning 1657 Encountered illegal value '1212III' when converting to INT +Warning 1659 Encountered illegal value '1212III' when converting to INT # #column get char # @@ -433,12 +433,12 @@ select column_get(column_create(1, "1223.5aa" AS char), 1 as double); column_get(column_create(1, "1223.5aa" AS char), 1 as double) 1223.5 Warnings: -Warning 1657 Encountered illegal value '1223.5aa' when converting to DOUBLE +Warning 1659 Encountered illegal value '1223.5aa' when converting to DOUBLE select column_get(column_create(1, "aa" AS char), 1 as double); column_get(column_create(1, "aa" AS char), 1 as double) 0 Warnings: -Warning 1657 Encountered illegal value 'aa' when converting to DOUBLE +Warning 1659 Encountered illegal value 'aa' when converting to DOUBLE select column_get(column_create(1, "1223.5555" AS double), 1 as double(5,2)); column_get(column_create(1, "1223.5555" AS double), 1 as double(5,2)) 999.99 @@ -502,12 +502,12 @@ select column_get(column_create(1, "1223.5aa" AS char), 1 as decimal(32,10)); column_get(column_create(1, "1223.5aa" AS char), 1 as decimal(32,10)) 1223.5000000000 Warnings: -Warning 1657 Encountered illegal value '1223.5aa' when converting to DECIMAL +Warning 1659 Encountered illegal value '1223.5aa' when converting to DECIMAL select column_get(column_create(1, "aa" AS char), 1 as decimal(32,10)); column_get(column_create(1, "aa" AS char), 1 as decimal(32,10)) 0.0000000000 Warnings: -Warning 1657 Encountered illegal value 'aa' when converting to DECIMAL +Warning 1659 Encountered illegal value 'aa' when converting to DECIMAL select column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as decimal); column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as decimal) 9999999999 @@ -640,17 +640,17 @@ select column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as d column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as datetime) NULL Warnings: -Warning 1657 Encountered illegal value '18446744073709551615' when converting to DATE or DATETIME +Warning 1659 Encountered illegal value '18446744073709551615' when converting to DATE or DATETIME select column_get(column_create(1, 9223372036854775807 AS int), 1 as datetime); column_get(column_create(1, 9223372036854775807 AS int), 1 as datetime) NULL Warnings: -Warning 1657 Encountered illegal value '9223372036854775807' when converting to DATE or DATETIME +Warning 1659 Encountered illegal value '9223372036854775807' when converting to DATE or DATETIME select column_get(column_create(1, -9223372036854775808 AS int), 1 as datetime); column_get(column_create(1, -9223372036854775808 AS int), 1 as datetime) NULL Warnings: -Warning 1657 Encountered illegal value '-9223372036854775808' when converting to DATE or DATETIME +Warning 1659 Encountered illegal value '-9223372036854775808' when converting to DATE or DATETIME select column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as datetime); column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as datetime) NULL @@ -770,17 +770,17 @@ select column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as d column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as date) NULL Warnings: -Warning 1657 Encountered illegal value '18446744073709551615' when converting to DATE or DATETIME +Warning 1659 Encountered illegal value '18446744073709551615' when converting to DATE or DATETIME select column_get(column_create(1, 9223372036854775807 AS int), 1 as date); column_get(column_create(1, 9223372036854775807 AS int), 1 as date) NULL Warnings: -Warning 1657 Encountered illegal value '9223372036854775807' when converting to DATE or DATETIME +Warning 1659 Encountered illegal value '9223372036854775807' when converting to DATE or DATETIME select column_get(column_create(1, -9223372036854775808 AS int), 1 as date); column_get(column_create(1, -9223372036854775808 AS int), 1 as date) NULL Warnings: -Warning 1657 Encountered illegal value '-9223372036854775808' when converting to DATE or DATETIME +Warning 1659 Encountered illegal value '-9223372036854775808' when converting to DATE or DATETIME select column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as date); column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as date) NULL diff --git a/mysql-test/r/explain.result b/mysql-test/r/explain.result index 25fc524bc9b..4bcdf7344a7 100644 --- a/mysql-test/r/explain.result +++ b/mysql-test/r/explain.result @@ -298,3 +298,18 @@ id select_type table type possible_keys key key_len ref rows Extra DEALLOCATE PREPARE stmt; DROP TABLE t1; End of 5.1 tests. +# +# Bug#776295: EXPLAIN EXTENDED with always false multiple equality +# in the WHERE condition of a derived table +# +CREATE TABLE t1 (a int) ; +CREATE TABLE t2 (a int) ; +INSERT INTO t2 VALUES (8); +EXPLAIN EXTENDED +SELECT * FROM ( SELECT t1.a FROM t1,t2 WHERE t2.a = t1.a ) AS t; +id select_type table type possible_keys key key_len ref rows filtered Extra +1 PRIMARY <derived2> system NULL NULL NULL NULL 0 0.00 const row not found +2 DERIVED NULL NULL NULL NULL NULL NULL NULL NULL no matching row in const table +Warnings: +Note 1003 select NULL AS `a` from (select NULL AS `a` from `test`.`t1` join `test`.`t2` where 0) `t` +DROP TABLE t1,t2; diff --git a/mysql-test/r/func_math.result b/mysql-test/r/func_math.result index ea9e034e6c5..9fdbd607860 100644 --- a/mysql-test/r/func_math.result +++ b/mysql-test/r/func_math.result @@ -516,7 +516,7 @@ SELECT -9999999999999999991 DIV -1; -9999999999999999991 DIV -1 -9223372036854775808 Warnings: -Error 1655 Got overflow when converting '-9999999999999999991' to INT. Value truncated. +Error 1657 Got overflow when converting '-9999999999999999991' to INT. Value truncated. SELECT -9223372036854775808 DIV -1; -9223372036854775808 DIV -1 -9223372036854775808 diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 03fa25ba7b5..4a8f1b53d7e 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -1533,7 +1533,7 @@ select locate('lo','hello',-18446744073709551615); locate('lo','hello',-18446744073709551615) 0 Warnings: -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. select locate('lo','hello',18446744073709551615); locate('lo','hello',18446744073709551615) 0 @@ -1541,22 +1541,22 @@ select locate('lo','hello',-18446744073709551616); locate('lo','hello',-18446744073709551616) 0 Warnings: -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. select locate('lo','hello',18446744073709551616); locate('lo','hello',18446744073709551616) 0 Warnings: -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. select locate('lo','hello',-18446744073709551617); locate('lo','hello',-18446744073709551617) 0 Warnings: -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. select locate('lo','hello',18446744073709551617); locate('lo','hello',18446744073709551617) 0 Warnings: -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. select left('hello', 10); left('hello', 10) hello @@ -1588,8 +1588,8 @@ select left('hello', -18446744073709551615); left('hello', -18446744073709551615) Warnings: -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. select left('hello', 18446744073709551615); left('hello', 18446744073709551615) hello @@ -1597,26 +1597,26 @@ select left('hello', -18446744073709551616); left('hello', -18446744073709551616) Warnings: -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. select left('hello', 18446744073709551616); left('hello', 18446744073709551616) hello Warnings: -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. select left('hello', -18446744073709551617); left('hello', -18446744073709551617) Warnings: -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. select left('hello', 18446744073709551617); left('hello', 18446744073709551617) hello Warnings: -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. select right('hello', 10); right('hello', 10) hello @@ -1648,8 +1648,8 @@ select right('hello', -18446744073709551615); right('hello', -18446744073709551615) Warnings: -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. select right('hello', 18446744073709551615); right('hello', 18446744073709551615) hello @@ -1657,26 +1657,26 @@ select right('hello', -18446744073709551616); right('hello', -18446744073709551616) Warnings: -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. select right('hello', 18446744073709551616); right('hello', 18446744073709551616) hello Warnings: -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. select right('hello', -18446744073709551617); right('hello', -18446744073709551617) Warnings: -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. select right('hello', 18446744073709551617); right('hello', 18446744073709551617) hello Warnings: -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. select substring('hello', 2, -1); substring('hello', 2, -1) @@ -1708,8 +1708,8 @@ select substring('hello', -18446744073709551615, 1); substring('hello', -18446744073709551615, 1) Warnings: -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. select substring('hello', 18446744073709551615, 1); substring('hello', 18446744073709551615, 1) @@ -1717,26 +1717,26 @@ select substring('hello', -18446744073709551616, 1); substring('hello', -18446744073709551616, 1) Warnings: -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. select substring('hello', 18446744073709551616, 1); substring('hello', 18446744073709551616, 1) Warnings: -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. select substring('hello', -18446744073709551617, 1); substring('hello', -18446744073709551617, 1) Warnings: -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. select substring('hello', 18446744073709551617, 1); substring('hello', 18446744073709551617, 1) Warnings: -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. select substring('hello', 1, -1); substring('hello', 1, -1) @@ -1762,8 +1762,8 @@ select substring('hello', 1, -18446744073709551615); substring('hello', 1, -18446744073709551615) Warnings: -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. select substring('hello', 1, 18446744073709551615); substring('hello', 1, 18446744073709551615) hello @@ -1771,26 +1771,26 @@ select substring('hello', 1, -18446744073709551616); substring('hello', 1, -18446744073709551616) Warnings: -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. select substring('hello', 1, 18446744073709551616); substring('hello', 1, 18446744073709551616) hello Warnings: -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. select substring('hello', 1, -18446744073709551617); substring('hello', 1, -18446744073709551617) Warnings: -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. select substring('hello', 1, 18446744073709551617); substring('hello', 1, 18446744073709551617) hello Warnings: -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. select substring('hello', -1, -1); substring('hello', -1, -1) @@ -1816,10 +1816,10 @@ select substring('hello', -18446744073709551615, -18446744073709551615); substring('hello', -18446744073709551615, -18446744073709551615) Warnings: -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. select substring('hello', 18446744073709551615, 18446744073709551615); substring('hello', 18446744073709551615, 18446744073709551615) @@ -1827,34 +1827,34 @@ select substring('hello', -18446744073709551616, -18446744073709551616); substring('hello', -18446744073709551616, -18446744073709551616) Warnings: -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. select substring('hello', 18446744073709551616, 18446744073709551616); substring('hello', 18446744073709551616, 18446744073709551616) Warnings: -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. select substring('hello', -18446744073709551617, -18446744073709551617); substring('hello', -18446744073709551617, -18446744073709551617) Warnings: -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. select substring('hello', 18446744073709551617, 18446744073709551617); substring('hello', 18446744073709551617, 18446744073709551617) Warnings: -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. select insert('hello', -1, 1, 'hi'); insert('hello', -1, 1, 'hi') hello @@ -1880,7 +1880,7 @@ select insert('hello', -18446744073709551615, 1, 'hi'); insert('hello', -18446744073709551615, 1, 'hi') hello Warnings: -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. select insert('hello', 18446744073709551615, 1, 'hi'); insert('hello', 18446744073709551615, 1, 'hi') hello @@ -1888,22 +1888,22 @@ select insert('hello', -18446744073709551616, 1, 'hi'); insert('hello', -18446744073709551616, 1, 'hi') hello Warnings: -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. select insert('hello', 18446744073709551616, 1, 'hi'); insert('hello', 18446744073709551616, 1, 'hi') hello Warnings: -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. select insert('hello', -18446744073709551617, 1, 'hi'); insert('hello', -18446744073709551617, 1, 'hi') hello Warnings: -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. select insert('hello', 18446744073709551617, 1, 'hi'); insert('hello', 18446744073709551617, 1, 'hi') hello Warnings: -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. select insert('hello', 1, -1, 'hi'); insert('hello', 1, -1, 'hi') hi @@ -1929,7 +1929,7 @@ select insert('hello', 1, -18446744073709551615, 'hi'); insert('hello', 1, -18446744073709551615, 'hi') hi Warnings: -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. select insert('hello', 1, 18446744073709551615, 'hi'); insert('hello', 1, 18446744073709551615, 'hi') hi @@ -1937,22 +1937,22 @@ select insert('hello', 1, -18446744073709551616, 'hi'); insert('hello', 1, -18446744073709551616, 'hi') hi Warnings: -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. select insert('hello', 1, 18446744073709551616, 'hi'); insert('hello', 1, 18446744073709551616, 'hi') hi Warnings: -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. select insert('hello', 1, -18446744073709551617, 'hi'); insert('hello', 1, -18446744073709551617, 'hi') hi Warnings: -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. select insert('hello', 1, 18446744073709551617, 'hi'); insert('hello', 1, 18446744073709551617, 'hi') hi Warnings: -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. select insert('hello', -1, -1, 'hi'); insert('hello', -1, -1, 'hi') hello @@ -1978,8 +1978,8 @@ select insert('hello', -18446744073709551615, -18446744073709551615, 'hi'); insert('hello', -18446744073709551615, -18446744073709551615, 'hi') hello Warnings: -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. select insert('hello', 18446744073709551615, 18446744073709551615, 'hi'); insert('hello', 18446744073709551615, 18446744073709551615, 'hi') hello @@ -1987,26 +1987,26 @@ select insert('hello', -18446744073709551616, -18446744073709551616, 'hi'); insert('hello', -18446744073709551616, -18446744073709551616, 'hi') hello Warnings: -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. select insert('hello', 18446744073709551616, 18446744073709551616, 'hi'); insert('hello', 18446744073709551616, 18446744073709551616, 'hi') hello Warnings: -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. select insert('hello', -18446744073709551617, -18446744073709551617, 'hi'); insert('hello', -18446744073709551617, -18446744073709551617, 'hi') hello Warnings: -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. select insert('hello', 18446744073709551617, 18446744073709551617, 'hi'); insert('hello', 18446744073709551617, 18446744073709551617, 'hi') hello Warnings: -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. select repeat('hello', -1); repeat('hello', -1) @@ -2038,8 +2038,8 @@ select repeat('hello', -18446744073709551615); repeat('hello', -18446744073709551615) Warnings: -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. select repeat('hello', 18446744073709551615); repeat('hello', 18446744073709551615) NULL @@ -2049,27 +2049,27 @@ select repeat('hello', -18446744073709551616); repeat('hello', -18446744073709551616) Warnings: -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. select repeat('hello', 18446744073709551616); repeat('hello', 18446744073709551616) NULL Warnings: -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated select repeat('hello', -18446744073709551617); repeat('hello', -18446744073709551617) Warnings: -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. select repeat('hello', 18446744073709551617); repeat('hello', 18446744073709551617) NULL Warnings: -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated select space(-1); space(-1) @@ -2102,8 +2102,8 @@ select space(-18446744073709551615); space(-18446744073709551615) Warnings: -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. select space(18446744073709551615); space(18446744073709551615) NULL @@ -2113,27 +2113,27 @@ select space(-18446744073709551616); space(-18446744073709551616) Warnings: -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. select space(18446744073709551616); space(18446744073709551616) NULL Warnings: -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated select space(-18446744073709551617); space(-18446744073709551617) Warnings: -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. select space(18446744073709551617); space(18446744073709551617) NULL Warnings: -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated select rpad('hello', -1, '1'); rpad('hello', -1, '1') @@ -2166,8 +2166,8 @@ select rpad('hello', -18446744073709551615, '1'); rpad('hello', -18446744073709551615, '1') NULL Warnings: -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. select rpad('hello', 18446744073709551615, '1'); rpad('hello', 18446744073709551615, '1') NULL @@ -2177,27 +2177,27 @@ select rpad('hello', -18446744073709551616, '1'); rpad('hello', -18446744073709551616, '1') NULL Warnings: -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. select rpad('hello', 18446744073709551616, '1'); rpad('hello', 18446744073709551616, '1') NULL Warnings: -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. Warning 1301 Result of rpad() was larger than max_allowed_packet (1048576) - truncated select rpad('hello', -18446744073709551617, '1'); rpad('hello', -18446744073709551617, '1') NULL Warnings: -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. select rpad('hello', 18446744073709551617, '1'); rpad('hello', 18446744073709551617, '1') NULL Warnings: -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. Warning 1301 Result of rpad() was larger than max_allowed_packet (1048576) - truncated select lpad('hello', -1, '1'); lpad('hello', -1, '1') @@ -2230,8 +2230,8 @@ select lpad('hello', -18446744073709551615, '1'); lpad('hello', -18446744073709551615, '1') NULL Warnings: -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551615' to INT. Value truncated. select lpad('hello', 18446744073709551615, '1'); lpad('hello', 18446744073709551615, '1') NULL @@ -2241,27 +2241,27 @@ select lpad('hello', -18446744073709551616, '1'); lpad('hello', -18446744073709551616, '1') NULL Warnings: -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551616' to INT. Value truncated. select lpad('hello', 18446744073709551616, '1'); lpad('hello', 18446744073709551616, '1') NULL Warnings: -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551616' to INT. Value truncated. Warning 1301 Result of lpad() was larger than max_allowed_packet (1048576) - truncated select lpad('hello', -18446744073709551617, '1'); lpad('hello', -18446744073709551617, '1') NULL Warnings: -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '-18446744073709551617' to INT. Value truncated. select lpad('hello', 18446744073709551617, '1'); lpad('hello', 18446744073709551617, '1') NULL Warnings: -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. -Error 1655 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. +Error 1657 Got overflow when converting '18446744073709551617' to INT. Value truncated. Warning 1301 Result of lpad() was larger than max_allowed_packet (1048576) - truncated SET @orig_sql_mode = @@SQL_MODE; SET SQL_MODE=traditional; diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index 691bedbe428..c1171570dca 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -1302,7 +1302,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 system NULL NULL NULL NULL 1 100.00 1 SIMPLE t2 system NULL NULL NULL NULL 1 100.00 Warnings: -Note 1003 select '1' AS `f1`,NULL AS `f2`,'3' AS `f3`,NULL AS `f1`,NULL AS `f2` from `test`.`t1` left join `test`.`t2` on(multiple equal(NULL)) where ((coalesce('1',NULL),'3') in ((1,3),(2,2))) +Note 1003 select '1' AS `f1`,NULL AS `f2`,'3' AS `f3`,NULL AS `f1`,NULL AS `f2` from `test`.`t1` left join `test`.`t2` on(0) where ((coalesce('1',NULL),'3') in ((1,3),(2,2))) SELECT * FROM t1 LEFT JOIN t2 ON t1.f2 = t2.f2 WHERE (COALESCE(t1.f1, t2.f1), f3) IN ((1, 3), (2, 2)); f1 f2 f3 f1 f2 diff --git a/mysql-test/r/join_outer_jcl6.result b/mysql-test/r/join_outer_jcl6.result index 7ca0b89df97..5b679b9b083 100644 --- a/mysql-test/r/join_outer_jcl6.result +++ b/mysql-test/r/join_outer_jcl6.result @@ -1309,7 +1309,7 @@ id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE t1 system NULL NULL NULL NULL 1 100.00 1 SIMPLE t2 system NULL NULL NULL NULL 1 100.00 Warnings: -Note 1003 select '1' AS `f1`,NULL AS `f2`,'3' AS `f3`,NULL AS `f1`,NULL AS `f2` from `test`.`t1` left join `test`.`t2` on(multiple equal(NULL)) where ((coalesce('1',NULL),'3') in ((1,3),(2,2))) +Note 1003 select '1' AS `f1`,NULL AS `f2`,'3' AS `f3`,NULL AS `f1`,NULL AS `f2` from `test`.`t1` left join `test`.`t2` on(0) where ((coalesce('1',NULL),'3') in ((1,3),(2,2))) SELECT * FROM t1 LEFT JOIN t2 ON t1.f2 = t2.f2 WHERE (COALESCE(t1.f1, t2.f1), f3) IN ((1, 3), (2, 2)); f1 f2 f3 f1 f2 diff --git a/mysql-test/r/mysqldump-max.result b/mysql-test/r/mysqldump-max.result index cc5fe207800..6722f308358 100644 --- a/mysql-test/r/mysqldump-max.result +++ b/mysql-test/r/mysqldump-max.result @@ -334,10 +334,10 @@ DROP TABLE t1; DROP TABLE t2; SHOW BINLOG EVENTS LIMIT 6,3; Log_name Pos Event_type Server_id End_log_pos Info -master-bin.000001 658 Query 1 726 BEGIN -master-bin.000001 726 Query 1 823 use `test`; INSERT INTO t2 VALUES (1,0), (2,0) -master-bin.000001 823 Xid 1 850 COMMIT /* XID */ --- CHANGE MASTER TO MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=850; +master-bin.000001 663 Query 1 731 BEGIN +master-bin.000001 731 Query 1 828 use `test`; INSERT INTO t2 VALUES (1,0), (2,0) +master-bin.000001 828 Xid 1 855 COMMIT /* XID */ +-- CHANGE MASTER TO MASTER_LOG_FILE='master-bin.000001', MASTER_LOG_POS=855; SELECT * FROM t1 ORDER BY a; a 1 diff --git a/mysql-test/r/select.result b/mysql-test/r/select.result index 56d383a57b7..f9d6c80018b 100644 --- a/mysql-test/r/select.result +++ b/mysql-test/r/select.result @@ -5018,3 +5018,16 @@ WHERE t7.f71>0; f23 DROP TABLE t1,t2,t3,t4,t5,t6,t7; End of 5.1 tests +# +# BUG#776274: substitution of a single row table +# +CREATE TABLE t1 (a int NOT NULL , b int); +INSERT INTO t1 VALUES (2,2); +SELECT * FROM t1 WHERE a = b; +a b +2 2 +EXPLAIN +SELECT * FROM t1 WHERE a = b; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 system NULL NULL NULL NULL 1 +DROP TABLE t1; diff --git a/mysql-test/r/select_jcl6.result b/mysql-test/r/select_jcl6.result index caa0fcb5cf6..ca7241d8f87 100644 --- a/mysql-test/r/select_jcl6.result +++ b/mysql-test/r/select_jcl6.result @@ -5025,6 +5025,19 @@ WHERE t7.f71>0; f23 DROP TABLE t1,t2,t3,t4,t5,t6,t7; End of 5.1 tests +# +# BUG#776274: substitution of a single row table +# +CREATE TABLE t1 (a int NOT NULL , b int); +INSERT INTO t1 VALUES (2,2); +SELECT * FROM t1 WHERE a = b; +a b +2 2 +EXPLAIN +SELECT * FROM t1 WHERE a = b; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 system NULL NULL NULL NULL 1 +DROP TABLE t1; set join_cache_level=default; show variables like 'join_cache_level'; Variable_name Value diff --git a/mysql-test/r/select_pkeycache.result b/mysql-test/r/select_pkeycache.result index 56d383a57b7..f9d6c80018b 100644 --- a/mysql-test/r/select_pkeycache.result +++ b/mysql-test/r/select_pkeycache.result @@ -5018,3 +5018,16 @@ WHERE t7.f71>0; f23 DROP TABLE t1,t2,t3,t4,t5,t6,t7; End of 5.1 tests +# +# BUG#776274: substitution of a single row table +# +CREATE TABLE t1 (a int NOT NULL , b int); +INSERT INTO t1 VALUES (2,2); +SELECT * FROM t1 WHERE a = b; +a b +2 2 +EXPLAIN +SELECT * FROM t1 WHERE a = b; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 system NULL NULL NULL NULL 1 +DROP TABLE t1; diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 53f38141f66..69deebb04b5 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -5068,3 +5068,22 @@ pk i 12 5 15 0 DROP table t1,t2; +# +# Bug#751350: crash with pushed condition for outer references when +# there should be none of such conditions +# +CREATE TABLE t1 (a int, b int) ; +INSERT INTO t1 VALUES (0,0),(0,0); +EXPLAIN +SELECT b FROM t1 +WHERE ('0') IN ( SELECT a FROM t1 GROUP BY a ) +GROUP BY b; +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort +2 DEPENDENT SUBQUERY t1 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort +SELECT b FROM t1 +WHERE ('0') IN ( SELECT a FROM t1 GROUP BY a ) +GROUP BY b; +b +0 +DROP TABLE t1; diff --git a/mysql-test/r/subselect_no_mat.result b/mysql-test/r/subselect_no_mat.result index 7ab96bad552..fe1d2558d80 100644 --- a/mysql-test/r/subselect_no_mat.result +++ b/mysql-test/r/subselect_no_mat.result @@ -5070,6 +5070,25 @@ pk i 12 5 15 0 DROP table t1,t2; +# +# Bug#751350: crash with pushed condition for outer references when +# there should be none of such conditions +# +CREATE TABLE t1 (a int, b int) ; +INSERT INTO t1 VALUES (0,0),(0,0); +EXPLAIN +SELECT b FROM t1 +WHERE ('0') IN ( SELECT a FROM t1 GROUP BY a ) +GROUP BY b; +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort +2 DEPENDENT SUBQUERY t1 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort +SELECT b FROM t1 +WHERE ('0') IN ( SELECT a FROM t1 GROUP BY a ) +GROUP BY b; +b +0 +DROP TABLE t1; set optimizer_switch=default; select @@optimizer_switch like '%materialization=on%'; @@optimizer_switch like '%materialization=on%' diff --git a/mysql-test/r/subselect_no_opts.result b/mysql-test/r/subselect_no_opts.result index 6f923c0e626..2087fc269d2 100644 --- a/mysql-test/r/subselect_no_opts.result +++ b/mysql-test/r/subselect_no_opts.result @@ -5067,4 +5067,23 @@ pk i 12 5 15 0 DROP table t1,t2; +# +# Bug#751350: crash with pushed condition for outer references when +# there should be none of such conditions +# +CREATE TABLE t1 (a int, b int) ; +INSERT INTO t1 VALUES (0,0),(0,0); +EXPLAIN +SELECT b FROM t1 +WHERE ('0') IN ( SELECT a FROM t1 GROUP BY a ) +GROUP BY b; +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort +2 DEPENDENT SUBQUERY t1 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort +SELECT b FROM t1 +WHERE ('0') IN ( SELECT a FROM t1 GROUP BY a ) +GROUP BY b; +b +0 +DROP TABLE t1; set optimizer_switch=default; diff --git a/mysql-test/r/subselect_no_semijoin.result b/mysql-test/r/subselect_no_semijoin.result index 889735b1dc2..946521071f6 100644 --- a/mysql-test/r/subselect_no_semijoin.result +++ b/mysql-test/r/subselect_no_semijoin.result @@ -5067,4 +5067,23 @@ pk i 12 5 15 0 DROP table t1,t2; +# +# Bug#751350: crash with pushed condition for outer references when +# there should be none of such conditions +# +CREATE TABLE t1 (a int, b int) ; +INSERT INTO t1 VALUES (0,0),(0,0); +EXPLAIN +SELECT b FROM t1 +WHERE ('0') IN ( SELECT a FROM t1 GROUP BY a ) +GROUP BY b; +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY t1 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort +2 DEPENDENT SUBQUERY t1 ALL NULL NULL NULL NULL 2 Using temporary; Using filesort +SELECT b FROM t1 +WHERE ('0') IN ( SELECT a FROM t1 GROUP BY a ) +GROUP BY b; +b +0 +DROP TABLE t1; set optimizer_switch=default; diff --git a/mysql-test/r/type_blob.result b/mysql-test/r/type_blob.result index e6fd49b4247..1de119f0d24 100644 --- a/mysql-test/r/type_blob.result +++ b/mysql-test/r/type_blob.result @@ -985,3 +985,9 @@ COUNT(*) DROP FUNCTION f1; DROP TABLE t1; End of 5.1 tests +CREATE TABLE t1 ( f1 blob, f2 blob ); +INSERT INTO t1 VALUES ('',''); +SELECT f1,f2,"found row" FROM t1 WHERE f1 = f2 ; +f1 f2 found row + found row +DROP TABLE t1; diff --git a/mysql-test/r/type_newdecimal.result b/mysql-test/r/type_newdecimal.result index 3ce3805df62..199dd95d32b 100644 --- a/mysql-test/r/type_newdecimal.result +++ b/mysql-test/r/type_newdecimal.result @@ -838,12 +838,12 @@ select 9999999999999999999999999999999999999999999999999999999999999999999999999 x 99999999999999999999999999999999999999999999999999999999999999999 Warnings: -Error 1655 Got overflow when converting '' to DECIMAL. Value truncated. +Error 1657 Got overflow when converting '' to DECIMAL. Value truncated. select 9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999 + 1 as x; x 100000000000000000000000000000000000000000000000000000000000000000 Warnings: -Error 1655 Got overflow when converting '' to DECIMAL. Value truncated. +Error 1657 Got overflow when converting '' to DECIMAL. Value truncated. select 0.190287977636363637 + 0.040372670 * 0 - 0; 0.190287977636363637 + 0.040372670 * 0 - 0 0.190287977636363637 @@ -1380,15 +1380,15 @@ create table t1 (c1 decimal(64)); insert into t1 values( 89000000000000000000000000000000000000000000000000000000000000000000000000000000000000000); Warnings: -Error 1655 Got overflow when converting '' to DECIMAL. Value truncated. +Error 1657 Got overflow when converting '' to DECIMAL. Value truncated. Warning 1264 Out of range value for column 'c1' at row 1 insert into t1 values( 99999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999 * 99999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999); Warnings: -Error 1655 Got overflow when converting '' to DECIMAL. Value truncated. -Error 1655 Got overflow when converting '' to DECIMAL. Value truncated. -Error 1655 Got overflow when converting '' to DECIMAL. Value truncated. +Error 1657 Got overflow when converting '' to DECIMAL. Value truncated. +Error 1657 Got overflow when converting '' to DECIMAL. Value truncated. +Error 1657 Got overflow when converting '' to DECIMAL. Value truncated. Warning 1264 Out of range value for column 'c1' at row 1 insert into t1 values(1e100); Warnings: @@ -1432,7 +1432,7 @@ select cast(19999999999999999999 as unsigned); cast(19999999999999999999 as unsigned) 18446744073709551615 Warnings: -Error 1655 Got overflow when converting '19999999999999999999' to UNSIGNED INT. Value truncated. +Error 1657 Got overflow when converting '19999999999999999999' to UNSIGNED INT. Value truncated. create table t1(a decimal(18)); insert into t1 values(123456789012345678); alter table t1 modify column a decimal(19); @@ -1674,7 +1674,7 @@ CREATE TABLE t1 SELECT /* 82 */ 1000000000000000000000000000000000000000000000000000000000000000000000000000000001 AS c1; Warnings: -Error 1655 Got overflow when converting '' to DECIMAL. Value truncated. +Error 1657 Got overflow when converting '' to DECIMAL. Value truncated. DESC t1; Field Type Null Key Default Extra c1 decimal(65,0) NO 0 diff --git a/mysql-test/r/warnings.result b/mysql-test/r/warnings.result index 1c75e415b75..34eb4db00c7 100644 --- a/mysql-test/r/warnings.result +++ b/mysql-test/r/warnings.result @@ -324,7 +324,7 @@ select CAST(a AS DECIMAL(13,5)) FROM (SELECT '' as a) t; CAST(a AS DECIMAL(13,5)) 0.00000 Warnings: -Error 1657 Encountered illegal value '' when converting to DECIMAL +Error 1659 Encountered illegal value '' when converting to DECIMAL Warning 1292 Truncated incorrect DECIMAL value: '' create table t1 (a integer unsigned); insert into t1 values (1),(-1),(0),(-2); |