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

Wrong result for SELECT..WHERE varchar_column=' 1' AND (varchar_column XOR '1')

        Details

          Description

          This script:

          DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a VARCHAR(10) CHARACTER SET cp1251 COLLATE cp1251_ukrainian_ci);
INSERT INTO t1 VALUES (' 1'),('`1'); 
SELECT * FROM t1 WHERE (a XOR '0');

          returns one row:

          +------+
| a    |
+------+
|  1   |
+------+

          Now if I make the WHERE condition even stricter:

          SELECT * FROM t1 WHERE a=' 1' AND (a XOR '0');

          it erroneously returns two rows:

          +------+
| a    |
+------+
|  1   |
| `1   |
+------+

            Gliffy Diagrams

              Attachments

                Issue Links

                blocks

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8728 Fix a number of problems in equal field and equal expression propagation

                • Critical - Crashes, loss of data, severe memory leak.
                • Closed

                  Activity

                  There are no comments yet on this issue.

                    People

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

                      Dates

                      • Created:
                        Updated:
                        Resolved: