(shardingsphere) branch master updated: fix CreateTableSQLGeneratorIT error. (#30938)

[chengzhang]

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

chengzhang 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 7ba3b4bdef9 fix CreateTableSQLGeneratorIT error. (#30938)
7ba3b4bdef9 is described below

commit 7ba3b4bdef92c9c697e07a0ee75e0105d161de74
Author: Chuxin Chen <chuxinche...@qq.com>
AuthorDate: Wed Apr 17 15:22:10 2024 +0800

    fix CreateTableSQLGeneratorIT error. (#30938)
---
 .../create-table-generator/mysql/create-table-sql-generator.xml   | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

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 b819b68e261..f62dedca026 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
@@ -37,9 +37,9 @@
                 CREATE TABLE `t_order` (
                 `order_id` int NOT NULL,
                 `user_id` int NOT NULL,
-                `status` varchar(45) DEFAULT NULL,
+                `status` varchar(45) COLLATE utf8mb4_general_ci DEFAULT NULL,
                 PRIMARY KEY (`order_id`)
-                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 
COLLATE=utf8mb4_0900_ai_ci
+                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 
COLLATE=utf8mb4_general_ci
             </sql>
         </output>
     </create-table-generator-assertion>
@@ -68,10 +68,10 @@
                 `item_id` int NOT NULL,
                 `order_id` int NOT NULL,
                 `user_id` int NOT NULL,
-                `status` varchar(45) DEFAULT NULL,
+                `status` varchar(45) COLLATE utf8mb4_general_ci DEFAULT NULL,
                 `creation_date` date DEFAULT NULL,
                 PRIMARY KEY (`item_id`)
-                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 
COLLATE=utf8mb4_0900_ai_ci
+                ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 
COLLATE=utf8mb4_general_ci
             </sql>
         </output>
     </create-table-generator-assertion>