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/main/distinct.result | |
| 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/main/distinct.result')
| -rw-r--r-- | mysql-test/main/distinct.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/main/distinct.result b/mysql-test/main/distinct.result index 237638468fa..d8f304a2da2 100644 --- a/mysql-test/main/distinct.result +++ b/mysql-test/main/distinct.result @@ -677,13 +677,13 @@ a A 0 Warnings: -Warning 1292 Truncated incorrect DOUBLE value: 'A' +Warning 1292 Truncated incorrect DECIMAL value: 'A' SELECT DISTINCT a FROM t1 WHERE a=0; a A 0 Warnings: -Warning 1292 Truncated incorrect DOUBLE value: 'A' +Warning 1292 Truncated incorrect DECIMAL value: 'A' DROP TABLE t1; CREATE TABLE t1 (a DATE); INSERT INTO t1 VALUES ('1972-07-29'), ('1972-02-06'); |