From 3cc6e5b7f235cc8ca9c274f848702cdc0ea14ed9 Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Mon, 28 Sep 2015 12:51:02 +0400 Subject: MDEV-8852 Implicit or explicit CAST from MAX(string) to INT,DOUBLE,DECIMAL does not produce warnings --- mysql-test/r/subselect_mat.result | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'mysql-test/r/subselect_mat.result') diff --git a/mysql-test/r/subselect_mat.result b/mysql-test/r/subselect_mat.result index b201ac6a44c..976d03946e6 100644 --- a/mysql-test/r/subselect_mat.result +++ b/mysql-test/r/subselect_mat.result @@ -545,6 +545,10 @@ Note 1003 select `test`.`t1`.`a1` AS `a1`,`test`.`t1`.`a2` AS `a2` from `test`.` select * from t1 group by (a1 in (select col from columns)); a1 a2 1 - 00 2 - 00 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1 - 00' +Warning 1292 Truncated incorrect DOUBLE value: '1 - 01' +Warning 1292 Truncated incorrect DOUBLE value: '1 - 02' /* ORDER BY clause */ explain extended select * from t1 order by (select col from columns limit 1); -- cgit v1.2.1