Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.6.1
-
None
-
2021-8
Description
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a CHAR(1) CHARACTER SET latin1) ENGINE=ColumnStore; |
INSERT INTO t1 VALUES ('a'),('Ã'); |
SELECT * FROM t1 WHERE a='A'; |
+------+
|
| a |
|
+------+
|
| a |
|
+------+
|
Looks wrong. It should return both rows.
Note, if I change the data type to CHAR(2), it returns two rows as expected.
Update
The problem is also repeatable with CHAR(2):
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a CHAR(2) CHARACTER SET latin1) ENGINE=ColumnStore; |
INSERT INTO t1 VALUES ('aa'),('ÃÃ'); |
SELECT * FROM t1 WHERE a='AA'; |
+------+
|
| a |
|
+------+
|
| aa |
|
+------+
|
The expected result should contain return two rows.