diff options
| author | Alexander Barkov <bar@mariadb.com> | 2019-12-16 12:57:08 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2019-12-16 12:57:08 +0400 |
| commit | fc860d3fa3bc854fbe6aab9179d7a4aaf6eb9edf (patch) | |
| tree | 0d7a45f7faa9748af710ede26d04aa27da2c2d5a /mysql-test/r | |
| parent | 794911a27a14ea83eda054cf34d94b43191aa19e (diff) | |
| download | mariadb-git-fc860d3fa3bc854fbe6aab9179d7a4aaf6eb9edf.tar.gz | |
MDEV-21065 UNIQUE constraint causes a query with string comparison to omit a row in the result set
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/type_int.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/type_int.result b/mysql-test/r/type_int.result index aaf35690306..c8b77490102 100644 --- a/mysql-test/r/type_int.result +++ b/mysql-test/r/type_int.result @@ -20,5 +20,18 @@ COALESCE(@a) 1 DROP TABLE t1; # +# MDEV-21065 UNIQUE constraint causes a query with string comparison to omit a row in the result set +# +CREATE TABLE t1 (c0 INT UNIQUE); +INSERT INTO t1 VALUES (NULL), (NULL), (NULL), (NULL), (1), (0); +SELECT * FROM t1 WHERE c0 < '\n2'; +c0 +0 +1 +DROP TABLE t1; +SELECT CAST('\n2' AS INT); +CAST('\n2' AS INT) +2 +# # End of 5.5 tests # |