[MDEV-34498] Applying NOT twice on an integer results in wrong result in WHERE condition - Jira

XML

Word

Printable

CREATE TABLE t0(c0 INT);

INSERT INTO t0(c0) VALUES(1);

SELECT * FROM t0 WHERE 123 != (NOT (NOT 123));

--  Empty set

Here is an equivalent execution. The results are inconsistent.

CREATE TABLE t0(c0 INT);

INSERT INTO t0(c0) VALUES(1);

SELECT (NOT (NOT 123));

-- 1

SELECT * FROM t0 WHERE 123 != 1;

--1

is duplicated by

MDEV-33801 Applying NOT twice on an integer in WHERE condition leads to incorrect results.

relates to

MDEV-34189 Unexpected error on `WHERE inet6col`

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