|
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.
|