You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by ch...@apache.org on 2024/04/17 07:22:17 UTC
(shardingsphere) branch master updated: fix CreateTableSQLGeneratorIT error. (#30938)
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 <ch...@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>