diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-08-29 14:04:25 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-08-29 14:04:25 +0300 |
| commit | 259050f864f5417fd047d16a793933e34941f1b4 (patch) | |
| tree | 9ca7e632212084fb89a0817e03bd341ef1f1e575 /plugin | |
| parent | 87e8463e0454a04c2bbaa38d44227c491fb07dc1 (diff) | |
| parent | d3099985fbd4b5e85564cc15de58a88916c16091 (diff) | |
| download | mariadb-git-259050f864f5417fd047d16a793933e34941f1b4.tar.gz | |
Merge 10.9 into 10.10
Diffstat (limited to 'plugin')
| -rw-r--r-- | plugin/type_inet/mysql-test/type_inet/type_inet6.result | 16 | ||||
| -rw-r--r-- | plugin/type_inet/mysql-test/type_inet/type_inet6.test | 11 |
2 files changed, 27 insertions, 0 deletions
diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet6.result b/plugin/type_inet/mysql-test/type_inet/type_inet6.result index 6304116ae23..39385088b40 100644 --- a/plugin/type_inet/mysql-test/type_inet/type_inet6.result +++ b/plugin/type_inet/mysql-test/type_inet/type_inet6.result @@ -2214,6 +2214,22 @@ id name DROP TABLE divisions; DROP TABLE companies; # +# MDEV-27099 Subquery using the ALL keyword on INET6 columns produces a wrong result +# +CREATE TABLE t1 (d INET6); +INSERT INTO t1 VALUES ('1::0'), ('12::0'); +SELECT * FROM t1 ORDER BY d; +d +1:: +12:: +SELECT * FROM t1 WHERE d <= ALL (SELECT * FROM t1); +d +1:: +SELECT * FROM t1 WHERE d >= ALL (SELECT * FROM t1); +d +12:: +DROP TABLE t1; +# # MDEV-27015 Assertion `!is_null()' failed in FixedBinTypeBundle<FbtImpl>::Fbt FixedBinTypeBundle<FbtImpl>::Field_fbt::to_fbt() # CREATE TABLE t1 (id int NOT NULL PRIMARY KEY, a INET6(6) DEFAULT '::10'); diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet6.test b/plugin/type_inet/mysql-test/type_inet/type_inet6.test index 9c618d0c21a..97370c37ea0 100644 --- a/plugin/type_inet/mysql-test/type_inet/type_inet6.test +++ b/plugin/type_inet/mysql-test/type_inet/type_inet6.test @@ -1631,6 +1631,17 @@ DROP TABLE divisions; DROP TABLE companies; --echo # +--echo # MDEV-27099 Subquery using the ALL keyword on INET6 columns produces a wrong result +--echo # + +CREATE TABLE t1 (d INET6); +INSERT INTO t1 VALUES ('1::0'), ('12::0'); +SELECT * FROM t1 ORDER BY d; +SELECT * FROM t1 WHERE d <= ALL (SELECT * FROM t1); +SELECT * FROM t1 WHERE d >= ALL (SELECT * FROM t1); +DROP TABLE t1; + +--echo # --echo # MDEV-27015 Assertion `!is_null()' failed in FixedBinTypeBundle<FbtImpl>::Fbt FixedBinTypeBundle<FbtImpl>::Field_fbt::to_fbt() --echo # |