diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2019-12-27 21:17:16 +0200 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2019-12-27 21:17:16 +0200 |
| commit | 8cc15c036dbc5fefb025eb957f4d312d41659163 (patch) | |
| tree | 6c4d67d677e6bb9bc90b7e3f08d18c8a798680b6 /mysql-test/main/type_int.test | |
| parent | cc28947315887f55814cb8bc4e68d4e2fe6c65e6 (diff) | |
| parent | b86e0f25f896285a34c999515ad50e50d879f3e7 (diff) | |
| download | mariadb-git-8cc15c036dbc5fefb025eb957f4d312d41659163.tar.gz | |
Merge 10.4 into 10.5
Diffstat (limited to 'mysql-test/main/type_int.test')
| -rw-r--r-- | mysql-test/main/type_int.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/main/type_int.test b/mysql-test/main/type_int.test index 77c532ff4ac..5d961724e59 100644 --- a/mysql-test/main/type_int.test +++ b/mysql-test/main/type_int.test @@ -15,6 +15,18 @@ SELECT COALESCE(@a) FROM t1 ORDER BY STRCMP(STDDEV_SAMP(a), 'bar'); DROP TABLE t1; --echo # +--echo # MDEV-21065 UNIQUE constraint causes a query with string comparison to omit a row in the result set +--echo # + +CREATE TABLE t1 (c0 INT UNIQUE); +INSERT INTO t1 VALUES (NULL), (NULL), (NULL), (NULL), (1), (0); +SELECT * FROM t1 WHERE c0 < '\n2'; +DROP TABLE t1; + +SELECT CAST('\n2' AS INT); + + +--echo # --echo # End of 5.5 tests --echo # |