Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-31945

Incorrect query results for NOT BETWEEN AND

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Cannot Reproduce
    • 11.0.3
    • N/A
    • Server
    • None
    • 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}
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            John Jove John Jove
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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