You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by zh...@apache.org on 2021/04/23 11:59:28 UTC
[shardingsphere] branch master updated: Issue#10151 SQL statement
in example failed to run because of missing create database statement
(#10157)
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 29622ee Issue#10151 SQL statement in example failed to run because of missing create database statement (#10157)
29622ee is described below
commit 29622eeb7c0f68d36e6183dc8414e82d80613109
Author: MingxingLAI <80...@users.noreply.github.com>
AuthorDate: Fri Apr 23 19:59:00 2021 +0800
Issue#10151 SQL statement in example failed to run because of missing create database statement (#10157)
---
examples/src/resources/manual_schema.sql | 6 ++++++
1 file changed, 6 insertions(+)
diff --git a/examples/src/resources/manual_schema.sql b/examples/src/resources/manual_schema.sql
index 70f70dd..b972e35 100644
--- a/examples/src/resources/manual_schema.sql
+++ b/examples/src/resources/manual_schema.sql
@@ -32,6 +32,9 @@ DROP SCHEMA IF EXISTS demo_primary_ds_1_replica_1;
DROP SCHEMA IF EXISTS shadow_demo_ds;
+DROP SCHEMA IF EXISTS demo_shadow_replica_ds;
+DROP SCHEMA IF EXISTS demo_replica_ds;
+
CREATE SCHEMA IF NOT EXISTS demo_ds;
CREATE SCHEMA IF NOT EXISTS demo_ds_0;
CREATE SCHEMA IF NOT EXISTS demo_ds_1;
@@ -49,6 +52,9 @@ CREATE SCHEMA IF NOT EXISTS demo_primary_ds_1_replica_1;
CREATE SCHEMA IF NOT EXISTS shadow_demo_ds;
+CREATE SCHEMA IF NOT EXISTS demo_shadow_replica_ds;
+CREATE SCHEMA IF NOT EXISTS demo_replica_ds;
+
-- Should sync from master-salve automatically
-- CREATE TABLE IF NOT EXISTS demo_replica_ds_0.t_order (order_id BIGINT NOT NULL AUTO_INCREMENT, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));
-- CREATE TABLE IF NOT EXISTS demo_replica_ds_1.t_order (order_id BIGINT NOT NULL AUTO_INCREMENT, user_id INT NOT NULL, status VARCHAR(50), PRIMARY KEY (order_id));