You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by su...@apache.org on 2024/09/10 10:19:02 UTC

(shardingsphere) branch master updated: Set default character set of mysql5 to utf8mb4 for pipeline E2E (#32826)

This is an automated email from the ASF dual-hosted git repository.

sunnianjun pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git


The following commit(s) were added to refs/heads/master by this push:
     new b3dabf73993 Set default character set of mysql5 to utf8mb4 for pipeline E2E (#32826)
b3dabf73993 is described below

commit b3dabf7399370a7d2d440de42d590bd14241ffa4
Author: Haoran Meng <me...@gmail.com>
AuthorDate: Tue Sep 10 18:18:55 2024 +0800

    Set default character set of mysql5 to utf8mb4 for pipeline E2E (#32826)
---
 .../e2e/operation/pipeline/src/test/resources/env/mysql/mysql5/my.cnf | 2 ++
 .../create-table-generator/mysql/create-table-sql-generator.xml       | 4 ++--
 2 files changed, 4 insertions(+), 2 deletions(-)

diff --git a/test/e2e/operation/pipeline/src/test/resources/env/mysql/mysql5/my.cnf b/test/e2e/operation/pipeline/src/test/resources/env/mysql/mysql5/my.cnf
index 50c3e13821b..5e0461558dd 100644
--- a/test/e2e/operation/pipeline/src/test/resources/env/mysql/mysql5/my.cnf
+++ b/test/e2e/operation/pipeline/src/test/resources/env/mysql/mysql5/my.cnf
@@ -18,6 +18,8 @@
 [mysql]
 
 [mysqld]
+character-set-server=utf8mb4
+collation-server=utf8mb4_general_ci
 log-bin=mysql-bin
 binlog-format=row
 binlog-row-image=full
diff --git a/test/e2e/operation/pipeline/src/test/resources/env/scenario/create-table-generator/mysql/create-table-sql-generator.xml b/test/e2e/operation/pipeline/src/test/resources/env/scenario/create-table-generator/mysql/create-table-sql-generator.xml
index f62dedca026..c9a97a4a1be 100644
--- a/test/e2e/operation/pipeline/src/test/resources/env/scenario/create-table-generator/mysql/create-table-sql-generator.xml
+++ b/test/e2e/operation/pipeline/src/test/resources/env/scenario/create-table-generator/mysql/create-table-sql-generator.xml
@@ -29,7 +29,7 @@
                 `user_id` int(11) NOT NULL,
                 `status` varchar(45) DEFAULT NULL,
                 PRIMARY KEY (`order_id`)
-                ) ENGINE=InnoDB DEFAULT CHARSET=latin1
+                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
             </sql>
         </output>
         <output version="8">
@@ -59,7 +59,7 @@
                 `status` varchar(45) DEFAULT NULL,
                 `creation_date` date DEFAULT NULL,
                 PRIMARY KEY (`item_id`)
-                ) ENGINE=InnoDB DEFAULT CHARSET=latin1
+                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
             </sql>
         </output>
         <output version="8">