← Back to branch summary

~drizzle-trunk/drizzle/development

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;