diff options
author | Alexander Barkov <bar@mariadb.com> | 2021-10-14 08:37:23 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2021-10-14 08:37:23 +0400 |
commit | df383043427fb22b0735fe31968db860f4cdb7a0 (patch) | |
tree | 570ba7b6afad8b97e4d4fc03d555df9bcecc0dd7 /plugin/type_inet/mysql-test/type_inet/type_inet6_innodb.test | |
parent | bd1573b0f332d4c7c08aab2974aadd544dbc24e3 (diff) | |
download | mariadb-git-bb-10.5-bar-MDEV-26742.tar.gz |
MDEV-26742 Assertion `field->type_handler() == this' failed in FixedBinTypeBundle<NATIVE_LEN, MAX_CHAR_LEN>::Type_handler_fbt::stored_field_cmp_to_itembb-10.5-bar-MDEV-26742
Diffstat (limited to 'plugin/type_inet/mysql-test/type_inet/type_inet6_innodb.test')
-rw-r--r-- | plugin/type_inet/mysql-test/type_inet/type_inet6_innodb.test | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet6_innodb.test b/plugin/type_inet/mysql-test/type_inet/type_inet6_innodb.test index dd6049abbf3..55826cc3e3f 100644 --- a/plugin/type_inet/mysql-test/type_inet/type_inet6_innodb.test +++ b/plugin/type_inet/mysql-test/type_inet/type_inet6_innodb.test @@ -12,6 +12,24 @@ SET default_storage_engine=InnoDB; --source type_inet6_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 inet6, c text) engine=myisam; +INSERT INTO t1 VALUES ('::',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.5 tests |