Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.6.1
-
Component/s: PrimProc
-
Labels:None
-
Sprint: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.