diff options
| author | Marko Mäkelä <marko.makela@mariadb.com> | 2022-08-29 14:02:29 +0300 |
|---|---|---|
| committer | Marko Mäkelä <marko.makela@mariadb.com> | 2022-08-29 14:02:29 +0300 |
| commit | d3099985fbd4b5e85564cc15de58a88916c16091 (patch) | |
| tree | fa7674085dc00c5af85358a58ac0ae0376382178 /plugin | |
| parent | 8cb75b9863a7043ebf2545158b3d2e634bca1831 (diff) | |
| parent | 2bddc5d045b40e64fd2e08cf8e3666370c69ff2b (diff) | |
| download | mariadb-git-d3099985fbd4b5e85564cc15de58a88916c16091.tar.gz | |
Merge 10.8 into 10.9
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 c4506380ffc..c1074e9e44d 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 cdfad92f69f..857a08e7cd1 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 # |