diff options
author | Alexander Barkov <bar@mariadb.com> | 2019-10-11 23:16:01 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2019-10-12 07:25:53 +0400 |
commit | 530f3f7cfc912ce9ff8282c520aa055b768cbe2a (patch) | |
tree | 62a578b80fa42079d1a362475210c5aecbd51e88 /mysql-test/suite/federated | |
parent | a0d3a351b8c5c2eb757270f31f9741b94f88ff1d (diff) | |
download | mariadb-git-530f3f7cfc912ce9ff8282c520aa055b768cbe2a.tar.gz |
MDEV-20806 Federated does not work with INET6, returns NULL with warning ER_TRUNCATED_WRONG_VALUE
Diffstat (limited to 'mysql-test/suite/federated')
-rw-r--r-- | mysql-test/suite/federated/federated_type_inet6.result | 24 | ||||
-rw-r--r-- | mysql-test/suite/federated/federated_type_inet6.test | 17 |
2 files changed, 41 insertions, 0 deletions
diff --git a/mysql-test/suite/federated/federated_type_inet6.result b/mysql-test/suite/federated/federated_type_inet6.result new file mode 100644 index 00000000000..625a7f3353f --- /dev/null +++ b/mysql-test/suite/federated/federated_type_inet6.result @@ -0,0 +1,24 @@ +connect master,127.0.0.1,root,,test,$MASTER_MYPORT,; +connect slave,127.0.0.1,root,,test,$SLAVE_MYPORT,; +connection master; +CREATE DATABASE federated; +connection slave; +CREATE DATABASE federated; +# +# MDEV-20806 Federated does not work with INET6, returns NULL with warning ER_TRUNCATED_WRONG_VALUE +# +connection master; +CREATE TABLE t1 (a INET6); +INSERT INTO t1 VALUES ('::'),('f::f'); +CREATE TABLE t2 (a INET6) ENGINE=Federated CONNECTION='mysql://root@127.0.0.1:MASTER_PORT/test/t1'; +SELECT * FROM t2; +a +:: +f::f +DROP TABLE t1, t2; +connection master; +DROP TABLE IF EXISTS federated.t1; +DROP DATABASE IF EXISTS federated; +connection slave; +DROP TABLE IF EXISTS federated.t1; +DROP DATABASE IF EXISTS federated; diff --git a/mysql-test/suite/federated/federated_type_inet6.test b/mysql-test/suite/federated/federated_type_inet6.test new file mode 100644 index 00000000000..857f0726689 --- /dev/null +++ b/mysql-test/suite/federated/federated_type_inet6.test @@ -0,0 +1,17 @@ +source include/federated.inc; + +--echo # +--echo # MDEV-20806 Federated does not work with INET6, returns NULL with warning ER_TRUNCATED_WRONG_VALUE +--echo # + +connection master; + +CREATE TABLE t1 (a INET6); +INSERT INTO t1 VALUES ('::'),('f::f'); + +--replace_result $MASTER_MYPORT MASTER_PORT +eval CREATE TABLE t2 (a INET6) ENGINE=Federated CONNECTION='mysql://root@127.0.0.1:$MASTER_MYPORT/test/t1'; +SELECT * FROM t2; +DROP TABLE t1, t2; + +source include/federated_cleanup.inc; |