diff options
| author | Alexander Barkov <bar@mariadb.com> | 2022-07-06 15:42:21 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2022-07-06 15:42:21 +0400 |
| commit | 57f5c319af85b645f144425af285d117aeebd47a (patch) | |
| tree | c50a0a7726171fdf2f1b71e053a83875ca1c21d1 /mysql-test/suite/maria | |
| parent | bdc1134deabb741d5b62a992d7478101adc617b3 (diff) | |
| download | mariadb-git-57f5c319af85b645f144425af285d117aeebd47a.tar.gz | |
MDEV-21445 Strange/inconsistent behavior of IN condition when mixing numbers and strings
Diffstat (limited to 'mysql-test/suite/maria')
| -rw-r--r-- | mysql-test/suite/maria/lock.result | 4 | ||||
| -rw-r--r-- | mysql-test/suite/maria/mrr.result | 8 |
2 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/suite/maria/lock.result b/mysql-test/suite/maria/lock.result index de24b987524..d081b6165d5 100644 --- a/mysql-test/suite/maria/lock.result +++ b/mysql-test/suite/maria/lock.result @@ -158,8 +158,8 @@ test.t1 optimize status OK connection default; DELETE FROM t2 WHERE c < 1; Warnings: -Warning 1292 Truncated incorrect DOUBLE value: 'a' -Warning 1292 Truncated incorrect DOUBLE value: 'b' +Warning 1292 Truncated incorrect DECIMAL value: 'a' +Warning 1292 Truncated incorrect DECIMAL value: 'b' connection con1; OPTIMIZE TABLE t1; Table Op Msg_type Msg_text diff --git a/mysql-test/suite/maria/mrr.result b/mysql-test/suite/maria/mrr.result index 5f9fcb4f937..aa8034e0bb7 100644 --- a/mysql-test/suite/maria/mrr.result +++ b/mysql-test/suite/maria/mrr.result @@ -326,10 +326,10 @@ SELECT table2 .`col_datetime_key` FROM t2 JOIN ( t1 table2 JOIN t2 table3 ON table3 .`col_varchar_key` < table2 .`col_varchar_key` ) ON table3 .`col_varchar_nokey` ; col_datetime_key Warnings: -Warning 1292 Truncated incorrect DOUBLE value: 'd' -Warning 1292 Truncated incorrect DOUBLE value: 'd' -Warning 1292 Truncated incorrect DOUBLE value: 'd' -Warning 1292 Truncated incorrect DOUBLE value: 'd' +Warning 1292 Truncated incorrect DECIMAL value: 'd' +Warning 1292 Truncated incorrect DECIMAL value: 'd' +Warning 1292 Truncated incorrect DECIMAL value: 'd' +Warning 1292 Truncated incorrect DECIMAL value: 'd' drop table t1, t2; set join_cache_level=@save_join_cache_level; CREATE TABLE t1( |