From 57f5c319af85b645f144425af285d117aeebd47a Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Wed, 6 Jul 2022 15:42:21 +0400 Subject: MDEV-21445 Strange/inconsistent behavior of IN condition when mixing numbers and strings --- mysql-test/main/subselect_sj_mat.result | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'mysql-test/main/subselect_sj_mat.result') diff --git a/mysql-test/main/subselect_sj_mat.result b/mysql-test/main/subselect_sj_mat.result index 8486d36c2ae..64f156ae03f 100644 --- a/mysql-test/main/subselect_sj_mat.result +++ b/mysql-test/main/subselect_sj_mat.result @@ -566,9 +566,9 @@ 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' +Warning 1292 Truncated incorrect DECIMAL value: '1 - 00' +Warning 1292 Truncated incorrect DECIMAL value: '1 - 01' +Warning 1292 Truncated incorrect DECIMAL value: '1 - 02' /* ORDER BY clause */ explain extended select * from t1 order by (select col from columns limit 1); -- cgit v1.2.1