diff options
Diffstat (limited to 'plugin/type_inet/mysql-test/type_inet/type_inet4_innodb.test')
-rw-r--r-- | plugin/type_inet/mysql-test/type_inet/type_inet4_innodb.test | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet4_innodb.test b/plugin/type_inet/mysql-test/type_inet/type_inet4_innodb.test new file mode 100644 index 00000000000..6e5a1640c83 --- /dev/null +++ b/plugin/type_inet/mysql-test/type_inet/type_inet4_innodb.test @@ -0,0 +1,36 @@ +--source include/have_innodb.inc + +--echo # +--echo # Start of 10.10 tests +--echo # + +--echo # +--echo # MDEV-23287 The INET4 data type +--echo # + + +SET default_storage_engine=InnoDB; +--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 (pk inet4, c text) engine=myisam; +INSERT INTO t1 VALUES ('0.0.0.0',1); +CREATE TABLE t2 (d text, KEY (d)) engine=innodb ; +INSERT INTO t2 VALUES (2); +SELECT * FROM t2 JOIN t1 ON ( t1.pk > t2.d); +--error ER_TRUNCATED_WRONG_VALUE +UPDATE t2 JOIN t1 ON ( t1.pk > t2.d) SET t1.c = 1; +SET sql_mode=''; +UPDATE t2 JOIN t1 ON ( t1.pk > t2.d) SET t1.c = 1; +SET sql_mode=DEFAULT; +SELECT * FROM t1; +SELECT * FROM t2; +DROP TABLE t1, t2; + + +--echo # +--echo # End of 10.10 tests +--echo # |