• Home
• org.liquibase
• liquibase-test-harness
• 1.0.5
• source code
• addLookupTable.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

liquibase.harness.change.expectedSql.percona-xtradb-cluster.addLookupTable.sql Maven / Gradle / Ivy

INVALID TEST

Percona-XtraDB-Cluster prohibits use of CREATE TABLE AS SELECT with pxc_strict_mode = ENFORCING or MASTER [Failed SQL: (1105) CREATE TABLE lbcat.authors_data AS SELECT DISTINCT email AS authors_email FROM lbcat.authors WHERE email IS NOT NULL]

--CREATE TABLE lbcat.authors_data AS SELECT DISTINCT email AS authors_email FROM lbcat.authors WHERE email IS NOT NULL
--ALTER TABLE lbcat.authors_data MODIFY authors_email VARCHAR(100) COLLATE utf8_unicode_ci NOT NULL
--ALTER TABLE lbcat.authors_data ADD PRIMARY KEY (authors_email)
--ALTER TABLE lbcat.authors ADD CONSTRAINT FK_AUTHORS_AUTHORS_DATA FOREIGN KEY (email) REFERENCES lbcat.authors_data (authors_email)