[MDEV-14116] INET6_NTOA output is set as null to varchar(39) variable - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.1.25, 10.0.32, 10.2.7, 10.0(EOL), 10.1(EOL), 10.2(EOL)
Fix Version/s: 10.0.34, 10.1.29, 10.2.11, 10.3.3
Component/s: Data types, Stored routines
Labels:
- datatype
Environment:
Centos 7

Sprint:
10.2.11

Description

The following code snippet was working for me in version 10.2.6. But I saw issues in version 10.2.9, where the variable "ip_full_addr" is returning null instead of expected value 2000::

 DECLARE ip_full_addr varchar(39) DEFAULT "";

 SELECT INET6_NTOA(UNHEX('20000000000000000000000000000000')) into ip_full_addr;

 SELECT ip_full_addr;

Attachments

Activity

People

Assignee:: Alexander Barkov

Reporter:: Vijay

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2017-10-24 10:12

Updated:: 2017-11-08 10:49

Resolved:: 2017-11-07 17:58

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.