diff options
| author | Alexander Barkov <bar@mariadb.org> | 2017-11-07 21:57:42 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2017-11-07 21:57:42 +0400 |
| commit | ca695888e00a4bdace1bc2143d91a0a871f39a6b (patch) | |
| tree | 55682e8170e5c80805f0183aa652915ef8390cea /mysql-test/t | |
| parent | 6a524fcfdde539c6448aa4126ccb5ed79055b9ce (diff) | |
| download | mariadb-git-ca695888e00a4bdace1bc2143d91a0a871f39a6b.tar.gz | |
MDEV-14116 INET6_NTOA output is set as null to varchar(39) variable
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/func_misc.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/func_misc.test b/mysql-test/t/func_misc.test index ebd5675e031..dc7202268d6 100644 --- a/mysql-test/t/func_misc.test +++ b/mysql-test/t/func_misc.test @@ -1091,3 +1091,19 @@ SELECT COERCIBILITY(NAME_CONST('name',TIME'00:00:00')); SELECT COERCIBILITY(NAME_CONST('name',15)); SELECT CONCAT(NAME_CONST('name',15),'오'); SET NAMES latin1; + +--echo # +--echo # MDEV-14116 INET6_NTOA output is set as null to varchar(39) variable +--echo # + +DELIMITER $$; +CREATE PROCEDURE p1() +BEGIN + DECLARE ip_full_addr varchar(39) DEFAULT ""; + SELECT INET6_NTOA(UNHEX('20000000000000000000000000000000')) into ip_full_addr; + SELECT ip_full_addr; +END; +$$ +DELIMITER ;$$ +CALL p1(); +DROP PROCEDURE p1; |