diff options
Diffstat (limited to 'plugin/type_inet/mysql-test/type_inet/type_inet6.test')
| -rw-r--r-- | plugin/type_inet/mysql-test/type_inet/type_inet6.test | 9 |
1 files changed, 9 insertions, 0 deletions
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 875aaa0b7e9..8559748c7dd 100644 --- a/plugin/type_inet/mysql-test/type_inet/type_inet6.test +++ b/plugin/type_inet/mysql-test/type_inet/type_inet6.test @@ -1436,3 +1436,12 @@ SELECT FROM t1; --disable_metadata DROP TABLE t1; + +--echo # +--echo # MDEV-20826 Wrong result of MIN(inet6) with GROUP BY +--echo # + +CREATE TABLE t1 (id INT, a INET6) ENGINE=MyISAM; +INSERT INTO t1 VALUES (1, 'fff::'),(1, '8888::'); +SELECT MIN(a), MAX(a) FROM t1 GROUP BY id; +DROP TABLE t1; |