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

Incorrect query result

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Cannot Reproduce
    • 11.0.3
    • N/A
    • Server
    • None
    • Ubuntu 22.04LTS

    Description

      In the following case, the SELECT statement returns an incorrect result {-1}, which is expected to be empty.

      DROP TABLE IF EXISTS t1;
      		 
      CREATE TABLE t1 (c0 double unsigned, c1 bigint,UNIQUE KEY c0 (c0));
      		 
      INSERT INTO t1 VALUES (NULL, -1);
      		 
      SELECT c1 FROM t1 WHERE c1 NOT IN (SELECT `c0` FROM t1); -- actual: {-1}, expected: {}

      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.