[MDEV-31719] Wrong result of: WHERE inet6_column IN ('','::1') - Jira

XML

Word

Printable

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL)
Fix Version/s: 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.2, 11.2.1
Component/s: Data types, Plugin - INET6
Labels:
None

This script erroneously treats '' as a correct INET6 value of '::' and returns one row:

CREATE OR REPLACE TABLE t1 (a INET6);

INSERT INTO t1 VALUES ('::');

SELECT * FROM t1 WHERE a IN ('','::1');

+------+

| a    |

+------+

| ::   |

+------+

1 row in set, 1 warning (0.000 sec)

The comparison operator works as expected on the contrary:

SELECT * FROM t1 WHERE a='';

Empty set, 2 warnings (0.001 sec)

relates to

MDEV-27207 Assertion `!m_null_value' failed in int FixedBinTypeBundle<FbtImpl>::cmp_item_fbt::compare or in cmp_item_inet6::compare

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