diff options
Diffstat (limited to 'plugin/type_inet/mysql-test/type_inet/type_inet4_myisam.test')
-rw-r--r-- | plugin/type_inet/mysql-test/type_inet/type_inet4_myisam.test | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet4_myisam.test b/plugin/type_inet/mysql-test/type_inet/type_inet4_myisam.test new file mode 100644 index 00000000000..a877d992646 --- /dev/null +++ b/plugin/type_inet/mysql-test/type_inet/type_inet4_myisam.test @@ -0,0 +1,28 @@ +--echo # +--echo # Start of 10.10 tests +--echo # + +--echo # +--echo # MDEV-23287 The INET4 data type +--echo # + + +SET default_storage_engine=MyISAM; +--source type_inet4_engines.inc + +--echo # +--echo # MDEV-26742 Assertion `field->type_handler() == this' failed in FixedBinTypeBundle<NATIVE_LEN, MAX_CHAR_LEN>::Type_handler_fbt::stored_field_cmp_to_item +--echo # + +CREATE TABLE t1 (c varchar(64), key(c)) engine=myisam; +INSERT INTO t1 VALUES ('0.0.0.1'),('0.0.0.1'),('0.0.0.2'); +SELECT * FROM t1 WHERE c>CAST('0.0.0.1' AS INET4); +EXPLAIN SELECT * FROM t1 WHERE c>CAST('0.0.0.1' AS INET4); +SELECT * FROM t1 WHERE c=CAST('0.0.0.1' AS INET4); +EXPLAIN SELECT * FROM t1 WHERE c=CAST('0.0.0.1' AS INET4); +DROP TABLE t1; + + +--echo # +--echo # End of 10.10 tests +--echo # |