Support "Advanced" level validation #70
Liquibase Test Harness - Contributed Reports ❌
❌ target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
64 tests were completed in 236s with 2 passed, 27 failed and 35 skipped.
Test suite | Passed | Failed | Skipped | Time |
---|---|---|---|---|
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite | 2✔️ | 27❌ | 35✖️ | 236s |
❌ liquibase.ext.databricks.ContributedExtensionHarnessTestSuite
liquibase.harness.change.ChangeObjectTests
✔️ apply 1initScript against databricks 3.5
✖️ apply addAutoIncrement against databricks 3.5
✖️ apply addCheckConstraint against databricks 3.5
❌ apply addColumn against databricks 3.5
Condition not satisfied:
✖️ apply addDefaultValue against databricks 3.5
✖️ apply addDefaultValueBoolean against databricks 3.5
✖️ apply addDefaultValueComputed against databricks 3.5
✖️ apply addDefaultValueDate against databricks 3.5
✖️ apply addDefaultValueNumeric against databricks 3.5
✖️ apply addDefaultValueSequenceNext against databricks 3.5
❌ apply addForeignKey against databricks 3.5
Condition not satisfied:
❌ apply addLookupTable against databricks 3.5
Condition not satisfied:
❌ apply addNotNullConstraint against databricks 3.5
Condition not satisfied:
❌ apply addPrimaryKey against databricks 3.5
Condition not satisfied:
✖️ apply addUniqueConstraint against databricks 3.5
✖️ apply alterSequence against databricks 3.5
✖️ apply createFunction against databricks 3.5
✖️ apply createIndex against databricks 3.5
✖️ apply createPackage against databricks 3.5
✖️ apply createPackageBody against databricks 3.5
✖️ apply createProcedure against databricks 3.5
✖️ apply createProcedureFromFile against databricks 3.5
✖️ apply createSequence against databricks 3.5
❌ apply createTable against databricks 3.5
Condition not satisfied:
❌ apply createTableDataTypeText against databricks 3.5
Condition not satisfied:
❌ apply createTableTimestamp against databricks 3.5
Condition not satisfied:
✖️ apply createTrigger against databricks 3.5
❌ apply createView against databricks 3.5
Condition not satisfied:
✖️ apply disableCheckConstraint against databricks 3.5
✖️ apply disableTrigger against databricks 3.5
❌ apply dropAllForeignKeyConstraints against databricks 3.5
Condition not satisfied:
✖️ apply dropCheckConstraint against databricks 3.5
❌ apply dropColumn against databricks 3.5
Condition not satisfied:
✖️ apply dropDefaultValue against databricks 3.5
❌ apply dropForeignKey against databricks 3.5
Condition not satisfied:
✖️ apply dropFunction against databricks 3.5
✖️ apply dropIndex against databricks 3.5
❌ apply dropNotNullConstraint against databricks 3.5
Condition not satisfied:
❌ apply dropPrimaryKey against databricks 3.5
Condition not satisfied:
✖️ apply dropProcedure against databricks 3.5
✖️ apply dropSequence against databricks 3.5
❌ apply dropTable against databricks 3.5
Condition not satisfied:
✖️ apply dropTrigger against databricks 3.5
✖️ apply dropUniqueConstraint against databricks 3.5
❌ apply dropView against databricks 3.5
Condition not satisfied:
✖️ apply enableCheckConstraint against databricks 3.5
✖️ apply enableTrigger against databricks 3.5
✔️ apply executeCommand against databricks 3.5
❌ apply mergeColumns against databricks 3.5
Condition not satisfied:
✖️ apply modifyDataType against databricks 3.5
❌ apply modifySql against databricks 3.5
Condition not satisfied:
❌ apply renameColumn against databricks 3.5
Condition not satisfied:
✖️ apply renameSequence against databricks 3.5
✖️ apply renameTable against databricks 3.5
✖️ apply renameTrigger against databricks 3.5
❌ apply renameView against databricks 3.5
Condition not satisfied:
❌ apply setColumnRemarks against databricks 3.5
Condition not satisfied:
✖️ apply setTableRemarks against databricks 3.5
❌ apply sql against databricks 3.5
Condition not satisfied:
❌ apply sqlFile against databricks 3.5
Condition not satisfied:
liquibase.harness.data.ChangeDataTests
❌ apply delete against databricks 3.5
Condition not satisfied:
❌ apply insert against databricks 3.5
Condition not satisfied:
❌ apply loadData against databricks 3.5
Condition not satisfied:
❌ apply loadUpdateData against databricks 3.5
Condition not satisfied:
Annotations
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply addColumn against databricks 3.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
Error:
Condition not satisfied:
Raw output
Condition not satisfied:
generatedSql == expectedSql
| | |
| | ALTER TABLE main.liquibase_harness_test_ds.authors ADD COLUMN varcharColumn STRING
| | ALTER TABLE main.liquibase_harness_test_ds.authors ADD COLUMN intColumn INT
| | ALTER TABLE main.liquibase_harness_test_ds.authors ADD COLUMN dateColumn date
| | UPDATE main.liquibase_harness_test_ds.authors SET varcharColumn = 'INITIAL_VALUE'
| | UPDATE main.liquibase_harness_test_ds.authors SET intColumn = 5
| | UPDATE main.liquibase_harness_test_ds.authors SET dateColumn = '2023-09-21'
| false
| Strings too large to calculate edit distance.
ALTER TABLE main.lb_test_harness.authors ADD COLUMN varcharColumn STRING
ALTER TABLE main.lb_test_harness.authors ADD COLUMN intColumn INT
ALTER TABLE main.lb_test_harness.authors ADD COLUMN dateColumn date
UPDATE main.lb_test_harness.authors SET varcharColumn = 'INITIAL_VALUE'
UPDATE main.lb_test_harness.authors SET intColumn = 5
UPDATE main.lb_test_harness.authors SET dateColumn = '2023-09-21'
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply addForeignKey against databricks 3.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
Error:
Condition not satisfied:
Raw output
Condition not satisfied:
generatedSql == expectedSql
| | |
| | ALTER TABLE main.liquibase_harness_test_ds.posts ADD CONSTRAINT fk_posts_authors_test FOREIGN KEY (author_id) REFERENCES main.liquibase_harness_test_ds.authors (id)
| false
| 30 differences (81% similarity)
| ALTER TABLE main.l(b_te--)s(t)_harness(--------).posts ADD CONSTRAINT fk_posts_authors_test FOREIGN KEY (author_id) REFERENCES main.l(b_te--)s(t)_harness(--------).authors (id)
| ALTER TABLE main.l(iquiba)s(e)_harness(_test_ds).posts ADD CONSTRAINT fk_posts_authors_test FOREIGN KEY (author_id) REFERENCES main.l(iquiba)s(e)_harness(_test_ds).authors (id)
ALTER TABLE main.lb_test_harness.posts ADD CONSTRAINT fk_posts_authors_test FOREIGN KEY (author_id) REFERENCES main.lb_test_harness.authors (id)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply addLookupTable against databricks 3.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
Error:
Condition not satisfied:
Raw output
Condition not satisfied:
generatedSql == expectedSql
| | |
| | CREATE TABLE main.liquibase_harness_test_ds.authors_data USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name') AS SELECT DISTINCT email AS authors_email FROM main.liquibase_harness_test_ds.authors WHERE email IS NOT NULL
| | ALTER TABLE main.liquibase_harness_test_ds.authors_data ALTER COLUMN authors_email SET NOT NULL
| | ALTER TABLE main.liquibase_harness_test_ds.authors_data ADD CONSTRAINT null PRIMARY KEY (authors_email)
| | ALTER TABLE main.liquibase_harness_test_ds.authors ADD CONSTRAINT fk_authors_authors_data FOREIGN KEY (email) REFERENCES main.liquibase_harness_test_ds.authors_data (authors_email)
| false
| Strings too large to calculate edit distance.
CREATE TABLE main.lb_test_harness.authors_data USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name') AS SELECT DISTINCT email AS authors_email FROM main.lb_test_harness.authors WHERE email IS NOT NULL
ALTER TABLE main.lb_test_harness.authors_data ALTER COLUMN authors_email SET NOT NULL
ALTER TABLE main.lb_test_harness.authors_data ADD CONSTRAINT null PRIMARY KEY (authors_email)
ALTER TABLE main.lb_test_harness.authors ADD CONSTRAINT fk_authors_authors_data FOREIGN KEY (email) REFERENCES main.lb_test_harness.authors_data (authors_email)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply addNotNullConstraint against databricks 3.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
Error:
Condition not satisfied:
Raw output
Condition not satisfied:
generatedSql == expectedSql
| | |
| | ALTER TABLE main.liquibase_harness_test_ds.posts ALTER COLUMN inserted_date SET NOT NULL
| false
| 15 differences (83% similarity)
| ALTER TABLE main.l(b_te--)s(t)_harness(--------).posts ALTER COLUMN inserted_date SET NOT NULL
| ALTER TABLE main.l(iquiba)s(e)_harness(_test_ds).posts ALTER COLUMN inserted_date SET NOT NULL
ALTER TABLE main.lb_test_harness.posts ALTER COLUMN inserted_date SET NOT NULL
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply addPrimaryKey against databricks 3.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
Error:
Condition not satisfied:
Raw output
Condition not satisfied:
generatedSql == expectedSql
| | |
| | ALTER TABLE main.liquibase_harness_test_ds.posts ADD CONSTRAINT pk_posts PRIMARY KEY (id)
| false
| 15 differences (83% similarity)
| ALTER TABLE main.l(b_te--)s(t)_harness(--------).posts ADD CONSTRAINT pk_posts PRIMARY KEY (id)
| ALTER TABLE main.l(iquiba)s(e)_harness(_test_ds).posts ADD CONSTRAINT pk_posts PRIMARY KEY (id)
ALTER TABLE main.lb_test_harness.posts ADD CONSTRAINT pk_posts PRIMARY KEY (id)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply createTable against databricks 3.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
Error:
Condition not satisfied:
Raw output
Condition not satisfied:
generatedSql == expectedSql
| | |
| | CREATE TABLE main.liquibase_harness_test_ds.test_table (test_id INT NOT NULL, test_column VARCHAR(50) NOT NULL, CONSTRAINT PK_TEST_TABLE PRIMARY KEY (test_id)) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name')
| false
| 15 differences (65% similarity) (comparing subset start: 8, end1: 42, end2: 52)
| ABLE main.l(b_te--)s(t)_harness(--------).test_tab
| ABLE main.l(iquiba)s(e)_harness(_test_ds).test_tab
CREATE TABLE main.lb_test_harness.test_table (test_id INT NOT NULL, test_column VARCHAR(50) NOT NULL, CONSTRAINT PK_TEST_TABLE PRIMARY KEY (test_id)) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name')
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply createTableDataTypeText against databricks 3.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
Error:
Condition not satisfied:
Raw output
Condition not satisfied:
generatedSql == expectedSql
| | |
| | CREATE TABLE main.liquibase_harness_test_ds.createTableDataTypeText (textCol STRING) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name')
| false
| 15 differences (92% similarity)
| CREATE TABLE main.l(b_te--)s(t)_harness(--------).createTableDataTypeText (textCol STRING) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name')
| CREATE TABLE main.l(iquiba)s(e)_harness(_test_ds).createTableDataTypeText (textCol STRING) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name')
CREATE TABLE main.lb_test_harness.createTableDataTypeText (textCol STRING) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name')
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply createTableTimestamp against databricks 3.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
Error:
Condition not satisfied:
Raw output
Condition not satisfied:
generatedSql == expectedSql
| | |
| | CREATE TABLE main.liquibase_harness_test_ds.lms_create_table_test (lms_test_id INT, lms_test_timestamp TIMESTAMP) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name')
| false
| 15 differences (93% similarity)
| CREATE TABLE main.l(b_te--)s(t)_harness(--------).lms_create_table_test (lms_test_id INT, lms_test_timestamp TIMESTAMP) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name')
| CREATE TABLE main.l(iquiba)s(e)_harness(_test_ds).lms_create_table_test (lms_test_id INT, lms_test_timestamp TIMESTAMP) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name')
CREATE TABLE main.lb_test_harness.lms_create_table_test (lms_test_id INT, lms_test_timestamp TIMESTAMP) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name')
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply createView against databricks 3.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
Error:
Condition not satisfied:
Raw output
Condition not satisfied:
generatedSql == expectedSql
| | |
| | CREATE VIEW main.liquibase_harness_test_ds.test_view AS select id, first_name, last_name, email from authors
| false
| 15 differences (86% similarity)
| CREATE VIEW main.l(b_te--)s(t)_harness(--------).test_view AS select id, first_name, last_name, email from authors
| CREATE VIEW main.l(iquiba)s(e)_harness(_test_ds).test_view AS select id, first_name, last_name, email from authors
CREATE VIEW main.lb_test_harness.test_view AS select id, first_name, last_name, email from authors
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply dropAllForeignKeyConstraints against databricks 3.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
Error:
Condition not satisfied:
Raw output
Condition not satisfied:
generatedSql == expectedSql
| | |
| | ALTER TABLE main.liquibase_harness_test_ds.posts ADD CONSTRAINT fk_posts_authors_test_1 FOREIGN KEY (author_id) REFERENCES main.liquibase_harness_test_ds.authors (id)
| | ALTER TABLE main.liquibase_harness_test_ds.posts ADD CONSTRAINT fk_posts_authors_test_2 FOREIGN KEY (id) REFERENCES main.liquibase_harness_test_ds.authors (id)
| false
| Strings too large to calculate edit distance.
ALTER TABLE main.lb_test_harness.posts ADD CONSTRAINT fk_posts_authors_test_1 FOREIGN KEY (author_id) REFERENCES main.lb_test_harness.authors (id)
ALTER TABLE main.lb_test_harness.posts ADD CONSTRAINT fk_posts_authors_test_2 FOREIGN KEY (id) REFERENCES main.lb_test_harness.authors (id)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply dropColumn against databricks 3.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
Error:
Condition not satisfied:
Raw output
Condition not satisfied:
generatedSql == expectedSql
| | |
| | ALTER TABLE main.liquibase_harness_test_ds.posts ADD COLUMN varcharColumn VARCHAR(25)
| | UPDATE main.liquibase_harness_test_ds.posts SET varcharColumn = 'INITIAL_VALUE'
| | ALTER TABLE main.liquibase_harness_test_ds.posts DROP COLUMN varcharColumn
| false
| 45 differences (81% similarity)
| ALTER TABLE main.l(b_te--)s(t)_harness(--------).posts ADD COLUMN varcharColumn VARCHAR(25)\nUPDATE main.l(b_te--)s(t)_harness(--------).posts SET varcharColumn = 'INITIAL_VALUE'\nALTER TABLE main.l(b_te--)s(t)_harness(--------).posts DROP COLUMN varcharColumn
| ALTER TABLE main.l(iquiba)s(e)_harness(_test_ds).posts ADD COLUMN varcharColumn VARCHAR(25)\nUPDATE main.l(iquiba)s(e)_harness(_test_ds).posts SET varcharColumn = 'INITIAL_VALUE'\nALTER TABLE main.l(iquiba)s(e)_harness(_test_ds).posts DROP COLUMN varcharColumn
ALTER TABLE main.lb_test_harness.posts ADD COLUMN varcharColumn VARCHAR(25)
UPDATE main.lb_test_harness.posts SET varcharColumn = 'INITIAL_VALUE'
ALTER TABLE main.lb_test_harness.posts DROP COLUMN varcharColumn
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)