Details
-
Sub-Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
2025-5, 2025-6, 2025-7, 2025-9
Description
--- /usr/share/mariadb-test/plugin/columnstore/columnstore/oracle/func_concat_oracle.result 2025-05-30 22:58:22.000000000 +0200
|
+++ /usr/share/mariadb-test/plugin/columnstore/columnstore/oracle/func_concat_oracle.reject 2025-05-31 02:18:54.860702256 +0200
|
@@ -354,7 +354,7 @@
|
id select_type table type possible_keys key key_len ref rows filtered Extra
|
1 PUSHED SELECT NULL NULL NULL NULL NULL NULL NULL NULL NULL
|
Warnings:
|
-Note 1003 select "test"."t1"."c1" AS "c1" from "test"."t1" where "test"."t1"."c1" like convert(concat('%','b') using utf8mb3) order by "test"."t1"."ord"
|
+Note 1003 select "test"."t1"."c1" AS "c1" from "test"."t1" where "test"."t1"."c1" like convert(concat('%','b') using utf8mb4) order by "test"."t1"."ord"
|
SELECT c1 FROM t1 WHERE c1 LIKE c2||'%'||'c' ORDER BY ord;
|
c1
|
abc
|
 |
Result content mismatch
|
The reason is the default charset in 11.8 is utf8mb4