2187.7.4
by Brian Aker
Merge in change from REPLICATION to REPLICATE as keyword. |
1 |
CREATE SCHEMA A REPLICATE = TRUE; |
2168.3.1
by Brian Aker
Basic DDL working for replication. |
2 |
SHOW CREATE SCHEMA A; |
2187.7.6
by Brian Aker
This fixes the message such that the table inherits the no replication |
3 |
|
4 |
USE A; |
|
5 |
||
6 |
CREATE TABLE A (A SERIAL); |
|
7 |
SHOW CREATE TABLE A; |
|
8 |
||
9 |
CREATE TABLE B (A SERIAL) REPLICATE = FALSE; |
|
10 |
SHOW CREATE TABLE B; |
|
11 |
||
12 |
SELECT SCHEMA_NAME, IS_REPLICATED FROM DATA_DICTIONARY.SCHEMAS WHERE SCHEMA_NAME="A"; |
|
2192.1.2
by Brian Aker
Fix issue where we had the wrong command in a few of the test files. |
13 |
--sorted_result
|
2187.7.6
by Brian Aker
This fixes the message such that the table inherits the no replication |
14 |
SELECT TABLE_NAME, IS_REPLICATED FROM DATA_DICTIONARY.TABLES WHERE TABLE_SCHEMA="A"; |
15 |
||
2168.3.1
by Brian Aker
Basic DDL working for replication. |
16 |
DROP SCHEMA A; |
17 |
||
2187.7.6
by Brian Aker
This fixes the message such that the table inherits the no replication |
18 |
# Now we need to see if the table is inheriting the replication behavior |
19 |
# from the parent. |
|
2187.7.4
by Brian Aker
Merge in change from REPLICATION to REPLICATE as keyword. |
20 |
CREATE SCHEMA A REPLICATE = FALSE; |
2168.3.1
by Brian Aker
Basic DDL working for replication. |
21 |
SHOW CREATE SCHEMA A; |
2187.7.6
by Brian Aker
This fixes the message such that the table inherits the no replication |
22 |
|
23 |
USE A; |
|
24 |
||
25 |
CREATE TABLE A (A SERIAL); |
|
26 |
SHOW CREATE TABLE A; |
|
27 |
||
28 |
CREATE TABLE B (A SERIAL) REPLICATE = TRUE; |
|
29 |
SHOW CREATE TABLE B; |
|
30 |
||
31 |
SELECT SCHEMA_NAME, IS_REPLICATED FROM DATA_DICTIONARY.SCHEMAS WHERE SCHEMA_NAME="A"; |
|
2192.1.2
by Brian Aker
Fix issue where we had the wrong command in a few of the test files. |
32 |
--sorted_result
|
2187.7.6
by Brian Aker
This fixes the message such that the table inherits the no replication |
33 |
SELECT TABLE_NAME, IS_REPLICATED FROM DATA_DICTIONARY.TABLES WHERE TABLE_SCHEMA="A"; |
34 |
||
2168.3.1
by Brian Aker
Basic DDL working for replication. |
35 |
DROP SCHEMA A; |