This is an automated email from the ASF dual-hosted git repository.
zhangliang 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 72abbf4446f Remove useless init SQLs (#36603)
72abbf4446f is described below
commit 72abbf4446f59c0c32b6ef42ed7c7d7a0dcdd0ae
Author: Liang Zhang <[email protected]>
AuthorDate: Wed Sep 17 23:02:19 2025 +0800
Remove useless init SQLs (#36603)
---
.../sqlserver/60-scenario-expected-init.sql | 30 ----------------------
.../init-sql/h2/60-scenario-expected-init.sql | 22 ----------------
2 files changed, 52 deletions(-)
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/sqlserver/60-scenario-expected-init.sql
b/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/sqlserver/60-scenario-expected-init.sql
deleted file mode 100644
index 76b2b8b1f6b..00000000000
---
a/test/e2e/sql/src/test/resources/env/scenario/db/data/expected/init-sql/sqlserver/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,30 +0,0 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one or more
--- contributor license agreements. See the NOTICE file distributed with
--- this work for additional information regarding copyright ownership.
--- The ASF licenses this file to You under the Apache License, Version 2.0
--- (the "License"); you may not use this file except in compliance with
--- the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
-
-DROP DATABASE IF EXISTS expected_dataset;
-CREATE DATABASE expected_dataset;
-
-CREATE TABLE expected_dataset.t_order (order_id BIGINT PRIMARY KEY, user_id
INT NOT NULL, status VARCHAR(50) NOT NULL, merchant_id INT, remark VARCHAR(50)
NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE expected_dataset.t_order_item (item_id BIGINT PRIMARY KEY,
order_id BIGINT NOT NULL, user_id INT NOT NULL, product_id INT NOT NULL,
quantity INT NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE expected_dataset.t_user (user_id INT PRIMARY KEY, user_name
VARCHAR(50) NOT NULL, password VARCHAR(50) NOT NULL, email VARCHAR(50) NOT
NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE expected_dataset.t_merchant (merchant_id INT PRIMARY KEY,
country_id SMALLINT NOT NULL, merchant_name VARCHAR(50) NOT NULL, business_code
VARCHAR(50) NOT NULL, telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE expected_dataset.t_product (product_id INT PRIMARY KEY,
product_name VARCHAR(50) NOT NULL, category_id INT NOT NULL, price DECIMAL NOT
NULL, status VARCHAR(50) NOT NULL, creation_date DATE NOT NULL);
-CREATE TABLE expected_dataset.t_product_detail (detail_id INT PRIMARY KEY,
product_id INT NOT NULL, description VARCHAR(50) NOT NULL, creation_date DATE
NOT NULL);
-CREATE TABLE expected_dataset.t_product_category (category_id INT PRIMARY KEY,
category_name VARCHAR(50) NOT NULL, parent_id INT NOT NULL, level TINYINT NOT
NULL, creation_date DATE NOT NULL);
-CREATE TABLE expected_dataset.t_country (country_id SMALLINT PRIMARY KEY,
country_name VARCHAR(50), continent_name VARCHAR(50), creation_date DATE NOT
NULL);
-
-CREATE INDEX order_index ON expected_dataset.t_order (order_id);
diff --git
a/test/e2e/sql/src/test/resources/env/scenario/shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql
b/test/e2e/sql/src/test/resources/env/scenario/shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql
deleted file mode 100644
index f7470ffebf0..00000000000
---
a/test/e2e/sql/src/test/resources/env/scenario/shadow/data/expected/init-sql/h2/60-scenario-expected-init.sql
+++ /dev/null
@@ -1,22 +0,0 @@
---
--- Licensed to the Apache Software Foundation (ASF) under one or more
--- contributor license agreements. See the NOTICE file distributed with
--- this work for additional information regarding copyright ownership.
--- The ASF licenses this file to You under the Apache License, Version 2.0
--- (the "License"); you may not use this file except in compliance with
--- the License. You may obtain a copy of the License at
---
--- http://www.apache.org/licenses/LICENSE-2.0
---
--- Unless required by applicable law or agreed to in writing, software
--- distributed under the License is distributed on an "AS IS" BASIS,
--- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--- See the License for the specific language governing permissions and
--- limitations under the License.
---
-
-DROP TABLE IF EXISTS t_shadow;
-DROP TABLE IF EXISTS t_merchant;
-
-CREATE TABLE t_shadow (order_id BIGINT NOT NULL, user_id INT NOT NULL,
order_name VARCHAR(32) NOT NULL, type_char CHAR(1) NOT NULL, type_boolean
BOOLEAN NOT NULL, type_smallint SMALLINT NOT NULL, type_enum ENUM('spring',
'summer', 'autumn', 'winter'), type_decimal DECIMAL(18,2) NOT NULL, type_date
DATE NOT NULL, type_time TIME NOT NULL, type_timestamp TIMESTAMP NOT NULL,
PRIMARY KEY (order_id));
-CREATE TABLE t_merchant (merchant_id INT PRIMARY KEY, country_id SMALLINT NOT
NULL, merchant_name VARCHAR(50) NOT NULL, business_code VARCHAR(50) NOT NULL,
telephone CHAR(11) NOT NULL, creation_date DATE NOT NULL);
