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));