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

Wrong result for BETWEEN 0 AND 18446744073709551615

    XMLWordPrintable

    Details

      Description

      CREATE OR REPLACE TABLE t1 (
        c1 bigint(20) unsigned NOT NULL
      );
      INSERT INTO t1 VALUES (0),(101),(255);
      SELECT * FROM t1 WHERE c1 BETWEEN 0 AND 18446744073709551615 ORDER BY c1;
      

      Empty set (0.00 sec)
      

      Looks wrong. The expected result is to return all 3 records.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              bar Alexander Barkov
              Reporter:
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: