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

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

Ascending order - Click to sort in descending order

Elena Stepanova added a comment - 2017-10-30 16:39

Thanks for the report.
MTR-friendly test case:

--delimiter $$

CREATE PROCEDURE pr()

BEGIN

  DECLARE ip_full_addr varchar(39) DEFAULT "";

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

  SELECT ip_full_addr;

END$$

--delimiter ;

CALL pr();

# Cleanup

DROP PROCEDURE pr;

Expected result
ip_full_addr
2000::

Actual result
ip_full_addr
NULL

The behavior changed with this commit in 10.0 branch and up:

commit 3a37afec293e36e51b83a9bd338ad5f74e7f63c0

Author: Alexander Barkov <bar@mariadb.org>

Date:   Mon Jun 19 12:45:32 2017 +0400

    MDEV-10306 Wrong results with combination of CONCAT, SUBSTR and CONVERT in subquery

Elena Stepanova added a comment - 2017-10-30 16:39 Thanks for the report. MTR-friendly test case: --delimiter $$ CREATE PROCEDURE pr() BEGIN DECLARE ip_full_addr varchar (39) DEFAULT "" ; SELECT INET6_NTOA(UNHEX( '20000000000000000000000000000000' )) into ip_full_addr; SELECT ip_full_addr; END $$ --delimiter ; CALL pr(); # Cleanup DROP PROCEDURE pr; Expected result ip_full_addr 2000:: Actual result ip_full_addr NULL The behavior changed with this commit in 10.0 branch and up: commit 3a37afec293e36e51b83a9bd338ad5f74e7f63c0 Author: Alexander Barkov <bar@mariadb.org> Date: Mon Jun 19 12:45:32 2017 +0400 MDEV-10306 Wrong results with combination of CONCAT, SUBSTR and CONVERT in subquery

Alexander Barkov added a comment - 2017-11-07 17:57

"commit 3a37afec293e36e51b83a9bd338ad5f74e7f63c0" did not introduce the bug. It only revealed the bug.

Alexander Barkov added a comment - 2017-11-07 17:57 "commit 3a37afec293e36e51b83a9bd338ad5f74e7f63c0" did not introduce the bug. It only revealed the bug.

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.

MariaDB Server