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 fc2c9dc #6912, support keyword table name for PostgreSQL (#6914)
fc2c9dc is described below
commit fc2c9dc0a9a0da562bb3927b715f8fe877969b6b
Author: Zhang Yonglun <[email protected]>
AuthorDate: Tue Aug 18 17:54:44 2020 +0800
#6912, support keyword table name for PostgreSQL (#6914)
* #6912, support keyword table name for PostgreSQL
---
.../cases/dql/dql-integrate-test-cases.xml | 6 ++--
.../test/resources/integrate/env/db/dataset.xml | 22 ++++++------
.../src/test/resources/integrate/env/db/schema.xml | 4 +--
.../env/dbtbl_with_masterslave/dataset.xml | 42 +++++++++++-----------
.../env/dbtbl_with_masterslave/schema.xml | 4 +--
.../integrate/env/masterslave/dataset.xml | 8 ++---
.../resources/integrate/env/masterslave/schema.xml | 4 +--
.../test/resources/integrate/env/shadow/schema.xml | 4 +--
.../test/resources/integrate/env/tbl/dataset.xml | 4 +--
.../test/resources/integrate/env/tbl/schema.xml | 4 +--
10 files changed, 51 insertions(+), 51 deletions(-)
diff --git
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/dql/dql-integrate-test-cases.xml
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/dql/dql-integrate-test-cases.xml
index 83daaa0..64a364b 100644
---
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/dql/dql-integrate-test-cases.xml
+++
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/cases/dql/dql-integrate-test-cases.xml
@@ -95,17 +95,17 @@
<assertion parameters="10:int, 11:int, 1009:int, 1108:int,
none:String" expected-data-file="empty_order_item.xml" />
</dql-test-case>
- <dql-test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON
o.user_id = i.user_id AND o.order_id = i.order_id JOIN `select` c ON o.status =
c.status WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ? AND o.status
= ? ORDER BY i.item_id" db-types="MySQL">
+ <dql-test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON
o.user_id = i.user_id AND o.order_id = i.order_id JOIN `key_word` c ON o.status
= c.status WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ? AND
o.status = ? ORDER BY i.item_id" db-types="MySQL">
<assertion parameters="10:int, 11:int, 1001:int, 1100:int,
init:String"
expected-data-file="select_sharding_route_with_broadcast_table.xml" />
<assertion parameters="10:int, 11:int, 1009:int, 1108:int,
none:String" expected-data-file="empty_order_item.xml" />
</dql-test-case>
- <dql-test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON
o.user_id = i.user_id AND o.order_id = i.order_id JOIN "select" c ON
o.status = c.status WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ?
AND c.status = ? ORDER BY i.item_id" db-types="PostgreSQL,Oracle">
+ <dql-test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON
o.user_id = i.user_id AND o.order_id = i.order_id JOIN "key_word" c
ON o.status = c.status WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ?
AND c.status = ? ORDER BY i.item_id" db-types="PostgreSQL,Oracle">
<assertion parameters="10:int, 11:int, 1001:int, 1100:int,
init:String"
expected-data-file="select_sharding_route_with_broadcast_table.xml" />
<assertion parameters="10:int, 11:int, 1009:int, 1108:int,
none:String" expected-data-file="empty_order_item.xml" />
</dql-test-case>
- <dql-test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON
o.user_id = i.user_id AND o.order_id = i.order_id JOIN [select] c ON o.status =
c.status WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ? AND c.status
= ? ORDER BY i.item_id" db-types="SQLServer">
+ <dql-test-case sql="SELECT i.* FROM t_order o JOIN t_order_item i ON
o.user_id = i.user_id AND o.order_id = i.order_id JOIN [key_word] c ON o.status
= c.status WHERE o.user_id IN (?, ?) AND o.order_id BETWEEN ? AND ? AND
c.status = ? ORDER BY i.item_id" db-types="SQLServer">
<assertion parameters="10:int, 11:int, 1001:int, 1100:int,
init:String"
expected-data-file="select_sharding_route_with_broadcast_table.xml" />
<assertion parameters="10:int, 11:int, 1009:int, 1108:int,
none:String" expected-data-file="empty_order_item.xml" />
</dql-test-case>
diff --git
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/db/dataset.xml
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/db/dataset.xml
index b634a05..5c65950 100644
---
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/db/dataset.xml
+++
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/db/dataset.xml
@@ -32,7 +32,7 @@
<column name="id" type="numeric" />
<column name="status" type="varchar" />
</metadata>
- <metadata data-nodes="db_${0..9}.select">
+ <metadata data-nodes="db_${0..9}.key_word">
<column name="id" type="numeric" />
<column name="status" type="varchar" />
</metadata>
@@ -166,14 +166,14 @@
<row data-node="db_7.t_broadcast_table" values="1, init" />
<row data-node="db_8.t_broadcast_table" values="1, init" />
<row data-node="db_9.t_broadcast_table" values="1, init" />
- <row data-node="db_0.select" values="1, init" />
- <row data-node="db_1.select" values="1, init" />
- <row data-node="db_2.select" values="1, init" />
- <row data-node="db_3.select" values="1, init" />
- <row data-node="db_4.select" values="1, init" />
- <row data-node="db_5.select" values="1, init" />
- <row data-node="db_6.select" values="1, init" />
- <row data-node="db_7.select" values="1, init" />
- <row data-node="db_8.select" values="1, init" />
- <row data-node="db_9.select" values="1, init" />
+ <row data-node="db_0.key_word" values="1, init" />
+ <row data-node="db_1.key_word" values="1, init" />
+ <row data-node="db_2.key_word" values="1, init" />
+ <row data-node="db_3.key_word" values="1, init" />
+ <row data-node="db_4.key_word" values="1, init" />
+ <row data-node="db_5.key_word" values="1, init" />
+ <row data-node="db_6.key_word" values="1, init" />
+ <row data-node="db_7.key_word" values="1, init" />
+ <row data-node="db_8.key_word" values="1, init" />
+ <row data-node="db_9.key_word" values="1, init" />
</dataset>
diff --git
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/db/schema.xml
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/db/schema.xml
index e29c6f8..5c26669 100644
---
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/db/schema.xml
+++
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/db/schema.xml
@@ -34,12 +34,12 @@
<sql>CREATE INDEX order_index_t_order ON t_order (order_id)</sql>
<sql>CREATE TABLE t_order_item (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id))</sql>
<sql>CREATE TABLE t_broadcast_table (id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (id))</sql>
- <sql>CREATE TABLE `select` (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id))</sql>
+ <sql>CREATE TABLE key_word (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id))</sql>
</table-create>
<table-drop>
<sql>DROP TABLE t_order</sql>
<sql>DROP TABLE t_order_item</sql>
<sql>DROP TABLE t_broadcast_table</sql>
- <sql>DROP TABLE `select`</sql>
+ <sql>DROP TABLE key_word</sql>
</table-drop>
</schema>
diff --git
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/dbtbl_with_masterslave/dataset.xml
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/dbtbl_with_masterslave/dataset.xml
index adb3ff2..d8ee00e 100644
---
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/dbtbl_with_masterslave/dataset.xml
+++
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/dbtbl_with_masterslave/dataset.xml
@@ -36,7 +36,7 @@
<column name="id" type="numeric" />
<column name="status" type="varchar" />
</metadata>
- <metadata data-nodes="master_db_${0..9}.select,slave_db_${0..9}.select">
+ <metadata
data-nodes="master_db_${0..9}.key_word,slave_db_${0..9}.key_word">
<column name="id" type="numeric" />
<column name="status" type="varchar" />
</metadata>
@@ -350,16 +350,16 @@
<row data-node="master_db_7.t_broadcast_table" values="1, init" />
<row data-node="master_db_8.t_broadcast_table" values="1, init" />
<row data-node="master_db_9.t_broadcast_table" values="1, init" />
- <row data-node="master_db_0.select" values="1, init" />
- <row data-node="master_db_1.select" values="1, init" />
- <row data-node="master_db_2.select" values="1, init" />
- <row data-node="master_db_3.select" values="1, init" />
- <row data-node="master_db_4.select" values="1, init" />
- <row data-node="master_db_5.select" values="1, init" />
- <row data-node="master_db_6.select" values="1, init" />
- <row data-node="master_db_7.select" values="1, init" />
- <row data-node="master_db_8.select" values="1, init" />
- <row data-node="master_db_9.select" values="1, init" />
+ <row data-node="master_db_0.key_word" values="1, init" />
+ <row data-node="master_db_1.key_word" values="1, init" />
+ <row data-node="master_db_2.key_word" values="1, init" />
+ <row data-node="master_db_3.key_word" values="1, init" />
+ <row data-node="master_db_4.key_word" values="1, init" />
+ <row data-node="master_db_5.key_word" values="1, init" />
+ <row data-node="master_db_6.key_word" values="1, init" />
+ <row data-node="master_db_7.key_word" values="1, init" />
+ <row data-node="master_db_8.key_word" values="1, init" />
+ <row data-node="master_db_9.key_word" values="1, init" />
<row data-node="master_db_0.t_global" values="1, global_master" />
<row data-node="slave_db_0.t_order_0" values="1000, 10, init_slave" />
<row data-node="slave_db_0.t_order_1" values="1001, 10, init_slave" />
@@ -671,15 +671,15 @@
<row data-node="slave_db_7.t_broadcast_table" values="1, init_slave" />
<row data-node="slave_db_8.t_broadcast_table" values="1, init_slave" />
<row data-node="slave_db_9.t_broadcast_table" values="1, init_slave" />
- <row data-node="slave_db_0.select" values="1, init_slave" />
- <row data-node="slave_db_1.select" values="1, init_slave" />
- <row data-node="slave_db_2.select" values="1, init_slave" />
- <row data-node="slave_db_3.select" values="1, init_slave" />
- <row data-node="slave_db_4.select" values="1, init_slave" />
- <row data-node="slave_db_5.select" values="1, init_slave" />
- <row data-node="slave_db_6.select" values="1, init_slave" />
- <row data-node="slave_db_7.select" values="1, init_slave" />
- <row data-node="slave_db_8.select" values="1, init_slave" />
- <row data-node="slave_db_9.select" values="1, init_slave" />
+ <row data-node="slave_db_0.key_word" values="1, init_slave" />
+ <row data-node="slave_db_1.key_word" values="1, init_slave" />
+ <row data-node="slave_db_2.key_word" values="1, init_slave" />
+ <row data-node="slave_db_3.key_word" values="1, init_slave" />
+ <row data-node="slave_db_4.key_word" values="1, init_slave" />
+ <row data-node="slave_db_5.key_word" values="1, init_slave" />
+ <row data-node="slave_db_6.key_word" values="1, init_slave" />
+ <row data-node="slave_db_7.key_word" values="1, init_slave" />
+ <row data-node="slave_db_8.key_word" values="1, init_slave" />
+ <row data-node="slave_db_9.key_word" values="1, init_slave" />
<row data-node="slave_db_0.t_global" values="1, global_slave" />
</dataset>
diff --git
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/dbtbl_with_masterslave/schema.xml
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/dbtbl_with_masterslave/schema.xml
index 8e1e0c8..857c8a9 100644
---
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/dbtbl_with_masterslave/schema.xml
+++
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/dbtbl_with_masterslave/schema.xml
@@ -72,7 +72,7 @@
<sql>CREATE TABLE t_order_item_9 (item_id INT NOT NULL, order_id INT
NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id))</sql>
<sql>CREATE TABLE t_broadcast_table (id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (id))</sql>
<sql>CREATE TABLE t_global (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id))</sql>
- <sql>CREATE TABLE `select` (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id))</sql>
+ <sql>CREATE TABLE key_word (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id))</sql>
</table-create>
<table-drop>
<sql>DROP TABLE t_order_0</sql>
@@ -97,6 +97,6 @@
<sql>DROP TABLE t_order_item_9</sql>
<sql>DROP TABLE t_broadcast_table</sql>
<sql>DROP TABLE t_global</sql>
- <sql>DROP TABLE `select`</sql>
+ <sql>DROP TABLE key_word</sql>
</table-drop>
</schema>
diff --git
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/masterslave/dataset.xml
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/masterslave/dataset.xml
index 224e4ae..41483bc 100644
---
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/masterslave/dataset.xml
+++
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/masterslave/dataset.xml
@@ -36,7 +36,7 @@
<column name="id" type="numeric" />
<column name="status" type="varchar" />
</metadata>
- <metadata data-nodes="master.select,slave_${0..1}.select">
+ <metadata data-nodes="master.key_word,slave_${0..1}.key_word">
<column name="id" type="numeric" />
<column name="status" type="varchar" />
</metadata>
@@ -161,7 +161,7 @@
<row data-node="master.t_order_item" values="290101, 2901, 29, init,
2017-08-08" />
<row data-node="master.t_order_item" values="290102, 2901, 29, init,
2017-08-08" />
<row data-node="master.t_broadcast_table" values="1, init" />
- <row data-node="master.select" values="1, init" />
+ <row data-node="master.key_word" values="1, init" />
<row data-node="master.t_global" values="1, global_master" />
<row data-node="slave_0.t_order" values="1000, 10, init_slave" />
<row data-node="slave_0.t_order" values="1001, 10, init_slave" />
@@ -284,7 +284,7 @@
<row data-node="slave_0.t_order_item" values="290101, 2901, 29,
init_slave, 2017-08-08" />
<row data-node="slave_0.t_order_item" values="290102, 2901, 29,
init_slave, 2017-08-08" />
<row data-node="slave_0.t_broadcast_table" values="1, init_slave" />
- <row data-node="slave_0.select" values="1, init_slave" />
+ <row data-node="slave_0.key_word" values="1, init_slave" />
<row data-node="slave_0.t_global" values="1, global_slave_0" />
<row data-node="slave_1.t_order" values="1000, 10, init_slave" />
<row data-node="slave_1.t_order" values="1001, 10, init_slave" />
@@ -407,6 +407,6 @@
<row data-node="slave_1.t_order_item" values="290101, 2901, 29,
init_slave, 2017-08-08" />
<row data-node="slave_1.t_order_item" values="290102, 2901, 29,
init_slave, 2017-08-08" />
<row data-node="slave_1.t_broadcast_table" values="1, init_slave" />
- <row data-node="slave_1.select" values="1, init_slave" />
+ <row data-node="slave_1.key_word" values="1, init_slave" />
<row data-node="slave_1.t_global" values="1, global_slave_1" />
</dataset>
diff --git
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/masterslave/schema.xml
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/masterslave/schema.xml
index b1d0f7c..710cadc 100644
---
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/masterslave/schema.xml
+++
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/masterslave/schema.xml
@@ -28,13 +28,13 @@
<sql>CREATE TABLE t_order_item (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id))</sql>
<sql>CREATE TABLE t_broadcast_table (id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (id))</sql>
<sql>CREATE TABLE t_global (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id))</sql>
- <sql>CREATE TABLE `select` (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id))</sql>
+ <sql>CREATE TABLE key_word (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id))</sql>
</table-create>
<table-drop>
<sql>DROP TABLE t_order</sql>
<sql>DROP TABLE t_order_item</sql>
<sql>DROP TABLE t_broadcast_table</sql>
<sql>DROP TABLE t_global</sql>
- <sql>DROP TABLE `select`</sql>
+ <sql>DROP TABLE key_word</sql>
</table-drop>
</schema>
diff --git
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/shadow/schema.xml
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/shadow/schema.xml
index 8429390..3ea3787 100644
---
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/shadow/schema.xml
+++
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/shadow/schema.xml
@@ -26,12 +26,12 @@
<sql>CREATE INDEX order_index_t_order ON t_order (order_id)</sql>
<sql>CREATE TABLE t_order_item (item_id INT NOT NULL, order_id INT NOT
NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id))</sql>
<sql>CREATE TABLE t_broadcast_table (id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (id))</sql>
- <sql>CREATE TABLE `select` (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id))</sql>
+ <sql>CREATE TABLE key_word (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id))</sql>
</table-create>
<table-drop>
<sql>DROP TABLE t_order</sql>
<sql>DROP TABLE t_order_item</sql>
<sql>DROP TABLE t_broadcast_table</sql>
- <sql>DROP TABLE `select`</sql>
+ <sql>DROP TABLE key_word</sql>
</table-drop>
</schema>
diff --git
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/tbl/dataset.xml
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/tbl/dataset.xml
index 5bf761b..0ad8438 100644
---
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/tbl/dataset.xml
+++
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/tbl/dataset.xml
@@ -32,7 +32,7 @@
<column name="id" type="numeric" />
<column name="status" type="varchar" />
</metadata>
- <metadata data-nodes="tbl.select">
+ <metadata data-nodes="tbl.key_word">
<column name="id" type="numeric" />
<column name="status" type="varchar" />
</metadata>
@@ -97,5 +97,5 @@
<row data-node="tbl.t_order_item_9" values="110900, 1109, 11, init,
2017-08-19" />
<row data-node="tbl.t_order_item_9" values="110901, 1109, 11, init,
2017-08-19" />
<row data-node="tbl.t_broadcast_table" values="1, init" />
- <row data-node="tbl.select" values="1, init" />
+ <row data-node="tbl.key_word" values="1, init" />
</dataset>
diff --git
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/tbl/schema.xml
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/tbl/schema.xml
index e640d44..ef1cc08 100644
---
a/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/tbl/schema.xml
+++
b/shardingsphere-integration-test/shardingsphere-test-suite/src/test/resources/integrate/env/tbl/schema.xml
@@ -52,7 +52,7 @@
<sql>CREATE TABLE t_order_item_8 (item_id INT NOT NULL, order_id INT
NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id))</sql>
<sql>CREATE TABLE t_order_item_9 (item_id INT NOT NULL, order_id INT
NOT NULL, user_id INT NOT NULL, status VARCHAR(45) NULL, creation_date DATE,
PRIMARY KEY (item_id))</sql>
<sql>CREATE TABLE t_broadcast_table (id INT NOT NULL, status
VARCHAR(45) NULL, PRIMARY KEY (id))</sql>
- <sql>CREATE TABLE `select` (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id))</sql>
+ <sql>CREATE TABLE key_word (id INT NOT NULL, status VARCHAR(45) NULL,
PRIMARY KEY (id))</sql>
</table-create>
<table-drop>
<sql>DROP TABLE t_order_0</sql>
@@ -76,6 +76,6 @@
<sql>DROP TABLE t_order_item_8</sql>
<sql>DROP TABLE t_order_item_9</sql>
<sql>DROP TABLE t_broadcast_table</sql>
- <sql>DROP TABLE `select`</sql>
+ <sql>DROP TABLE key_word</sql>
</table-drop>
</schema>