summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_misc.test
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2017-11-09 14:05:53 +0400
committerAlexander Barkov <bar@mariadb.org>2017-11-09 14:05:53 +0400
commit0fdb0bdf2769dc4e69d46b342200d3fd333fa3a5 (patch)
tree542689300b4ebd90eed162a54870fc1a57261eca /mysql-test/t/func_misc.test
parent644ffdeb9290a5fc861ecd286a5af4388b4339ad (diff)
parentc2c93fc6e460fd32b6ef179686c2b3b2045f75eb (diff)
downloadmariadb-git-0fdb0bdf2769dc4e69d46b342200d3fd333fa3a5.tar.gz
Merge remote-tracking branch 'origin/10.0' into 10.1
Diffstat (limited to 'mysql-test/t/func_misc.test')
-rw-r--r--mysql-test/t/func_misc.test16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/func_misc.test b/mysql-test/t/func_misc.test
index 497ebf44e69..ffb7838ee78 100644
--- a/mysql-test/t/func_misc.test
+++ b/mysql-test/t/func_misc.test
@@ -1118,3 +1118,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;