Details
Description
This problem is similar to MDEV-10306.
This script:
SET optimizer_switch=_utf8'derived_merge=on'; |
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (t VARCHAR(10) CHARSET latin1); |
INSERT INTO t1 VALUES('abcdefghi'); |
SELECT CONCAT(t2,'-',t2) c2 FROM (SELECT MAKE_SET(3,t,t) t2 FROM t1) sub; |
returns a wrong result:
+----------------------------------------+
|
| c2 |
|
+----------------------------------------+
|
| abcdefghi,abcdefghiabcdefghi,abcdefghi |
|
+----------------------------------------+
|
Notice, there is no the expected dash character in the result.
Attachments
Issue Links
- relates to
-
MDEV-13790 UNHEX() of a somewhat complicated CONCAT() returns NULL
- Closed
-
MDEV-10306 Wrong results with combination of CONCAT, SUBSTR and CONVERT in subquery
- Closed
-
MDEV-13119 Wrong results with CAST(AS CHAR) and subquery
- Closed