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

Details

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

Description

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)

Attachments

Issue Links

relates to

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

Closed

Activity

Ascending order - Click to sort in descending order

Alexander Barkov added a comment - 2023-07-17 10:03

The same problem is repeatable with UUID stating from 10.9.

The IN operator returns a wrong row:

CREATE OR REPLACE TABLE t1 (a UUID);

INSERT INTO t1 VALUES ('00000000-0000-0000-0000-000000000000');

SELECT * FROM t1 WHERE a IN ('','00000000-0000-0000-0000-000000000001');

+--------------------------------------+

| a                                    |

+--------------------------------------+

| 00000000-0000-0000-0000-000000000000 |

+--------------------------------------+

The comparison operator works fine:

SELECT * FROM t1 WHERE a='';

Empty set, 2 warnings (0.001 sec)

Alexander Barkov added a comment - 2023-07-17 10:03 The same problem is repeatable with UUID stating from 10.9. The IN operator returns a wrong row: CREATE OR REPLACE TABLE t1 (a UUID); INSERT INTO t1 VALUES ( '00000000-0000-0000-0000-000000000000' ); SELECT * FROM t1 WHERE a IN ( '' , '00000000-0000-0000-0000-000000000001' ); +--------------------------------------+ | a | +--------------------------------------+ | 00000000-0000-0000-0000-000000000000 | +--------------------------------------+ The comparison operator works fine: SELECT * FROM t1 WHERE a= '' ; Empty set, 2 warnings (0.001 sec)

Alexander Barkov added a comment - 2023-07-20 02:10

Pushed to 10.5 in a single patch with ~~MDEV-27207~~.
Waiting for a merge to 10.9 to add UUID tests.

Alexander Barkov added a comment - 2023-07-20 02:10 Pushed to 10.5 in a single patch with MDEV-27207 . Waiting for a merge to 10.9 to add UUID tests.

Alexander Barkov added a comment - 2023-08-16 08:26

The merge 10.5->10.6 for this patch went wrong.
Pushed an after-merge cleanup:
https://github.com/MariaDB/server/commit/88dd50b80ad9624d05b72751fd6e4a2cfdb6a3fe

Waiting for it to propagate to 10.9.

Alexander Barkov added a comment - 2023-08-16 08:26 The merge 10.5->10.6 for this patch went wrong. Pushed an after-merge cleanup: https://github.com/MariaDB/server/commit/88dd50b80ad9624d05b72751fd6e4a2cfdb6a3fe Waiting for it to propagate to 10.9.

People

Assignee:: Alexander Barkov

Reporter:: Alexander Barkov

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2023-07-17 07:42

Updated:: 2023-08-18 06:09

Resolved:: 2023-08-18 06:09

Git Integration

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

MariaDB Server