summaryrefslogtreecommitdiff
path: root/mysql-test/r/subselect_mat.result
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2015-09-28 12:51:02 +0400
committerAlexander Barkov <bar@mariadb.org>2015-09-28 12:51:02 +0400
commit3cc6e5b7f235cc8ca9c274f848702cdc0ea14ed9 (patch)
tree1361a6ec9e671785fc47059aec09aeabf8e7b997 /mysql-test/r/subselect_mat.result
parent54db387410b2a4f2bd6a1eacd5979a974b4f5389 (diff)
downloadmariadb-git-3cc6e5b7f235cc8ca9c274f848702cdc0ea14ed9.tar.gz
MDEV-8852 Implicit or explicit CAST from MAX(string) to INT,DOUBLE,DECIMAL does not produce warnings
Diffstat (limited to 'mysql-test/r/subselect_mat.result')
-rw-r--r--mysql-test/r/subselect_mat.result4
1 files changed, 4 insertions, 0 deletions
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);