[MDEV-31945] Incorrect query results for NOT BETWEEN AND Created: 2023-08-18  Updated: 2023-09-05  Resolved: 2023-09-05

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 11.0.3
Fix Version/s: N/A

Type: Bug Priority: Critical
Reporter: John Jove Assignee: Sergei Golubchik
Resolution: Cannot Reproduce Votes: 0
Labels: None
Environment:

Docker images 11.0.3



 Description   

The following statements return an incorrect query result.

    DROP TABLE IF EXISTS t1;
    CREATE TABLE t1 (c1 CHAR(100));
    INSERT INTO t1 VALUES ('0');
    SELECT c1 FROM t1 WHERE (1 NOT BETWEEN (c1 + ~ 'a') AND 7); -- actual: {}, expected: {0}



 Comments   
Comment by Sergei Golubchik [ 2023-09-05 ]

It returns 0 for me

CREATE TABLE t1 (c1 CHAR(100));
INSERT INTO t1 VALUES ('0');
SELECT c1 FROM t1 WHERE (1 NOT BETWEEN (c1 + ~ 'a') AND 7);
c1
0

Generated at Thu Feb 08 10:27:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.