Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
-
None
Description
This script demonstrates the problem:
SET NAMES latin1; |
CREATE OR REPLACE TABLE t1(a INT) ENGINE=MYISAM; |
INSERT INTO t1 VALUES (1); |
CREATE OR REPLACE TABLE t2(a VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci) ENGINE=MYISAM; |
INSERT INTO t2 VALUES ('1'); |
|
-- These queries returns one row as expected
|
SELECT * FROM t1 WHERE (SELECT CONCAT(a) FROM t1) = (SELECT CONCAT(a) FROM t2); |
SELECT * FROM t1 WHERE (SELECT 1,CONCAT(a) FROM t1) = (SELECT 1,CONCAT(a) FROM t2); |
|
-- This returns TRUE as expected (Unicode Character 'NO-BREAK SPACE' (U+00A0) is on the both sides)
|
SELECT _latin1 0xA0 = _utf8 0xC2A0; |
|
-- This returns one row as expected
|
SELECT * FROM t1 WHERE (SELECT CONCAT(a, _latin1 0xA0) FROM t1) = (SELECT CONCAT(a,_utf8 0xC2A0) FROM t2); |
|
-- This returns no rows. One row is expected!
|
SELECT * FROM t1 WHERE (SELECT 1,CONCAT(a, _latin1 0xA0) FROM t1) = (SELECT 1,CONCAT(a,_utf8 0xC2A0) FROM t2); |
Attachments
Issue Links
- relates to
-
MDEV-23535 SIGSEGV, SIGABRT and SIGILL in typeinfo for Item_func_set_collation (on optimized builds)
- Closed