diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-08-24 09:22:34 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-08-24 09:22:34 +0300 |
| commit | bdd80e3fb1cb653c367099639bec46840eca86e1 (patch) | |
| tree | ab3d208ab5102d7f7db1b222a7a4531012a0ebcd /plugin | |
| parent | dc11fd07fdaf7316d340569f97a84fa0fd2d307e (diff) | |
| parent | 5b4c832c7ebd59d9f5a5e7feef570568e20e5b86 (diff) | |
| download | mariadb-git-bdd80e3fb1cb653c367099639bec46840eca86e1.tar.gz | |
Merge 10.6 into 10.7
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 cfb9189ea28..6d00e1771cc 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 f7453d2d67e..0f587a75a7d 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 # |