Skip to content
Liquibase Test Harness

[DAT-17951] Add AlterCluster change #352

Sign in to view logs

[DAT-17951] Add AlterCluster change

[DAT-17951] Add AlterCluster change #352

GitHub Actions / Liquibase Test Harness - Contributed Reports succeeded Aug 5, 2024 in 1s

30 passed, 8 failed and 33 skipped

Tests failed

❌ target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml

71 tests were completed in 1466s with 30 passed, 8 failed and 33 skipped.

Test suite Passed Failed Skipped Time
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite 30✅ 8❌ 33⚪ 1466s

❌ liquibase.ext.databricks.ContributedExtensionHarnessTestSuite

liquibase.harness.change.ChangeObjectTests
  ✅ apply 1initScript against databricks 3.1
  ⚪ apply addAutoIncrement against databricks 3.1
  ✅ apply addCheckConstraint against databricks 3.1
  ✅ apply addColumn against databricks 3.1
  ⚪ apply addDefaultValue against databricks 3.1
  ⚪ apply addDefaultValueBoolean against databricks 3.1
  ⚪ apply addDefaultValueComputed against databricks 3.1
  ⚪ apply addDefaultValueDate against databricks 3.1
  ⚪ apply addDefaultValueNumeric against databricks 3.1
  ⚪ apply addDefaultValueSequenceNext against databricks 3.1
  ✅ apply addForeignKey against databricks 3.1
  ✅ apply addLookupTable against databricks 3.1
  ✅ apply addNotNullConstraint against databricks 3.1
  ✅ apply addPrimaryKey against databricks 3.1
  ⚪ apply addUniqueConstraint against databricks 3.1
  ✅ apply alterCluster against databricks 3.1
  ⚪ apply alterSequence against databricks 3.1
  ❌ apply alterTableProperties against databricks 3.1
	Condition not satisfied:
  ✅ apply analyzeTable against databricks 3.1
  ❌ apply createClusteredTable against databricks 3.1
	Condition not satisfied:
  ⚪ apply createFunction against databricks 3.1
  ⚪ apply createIndex against databricks 3.1
  ⚪ apply createPackage against databricks 3.1
  ⚪ apply createPackageBody against databricks 3.1
  ❌ apply createPartitionedTable against databricks 3.1
	Condition not satisfied:
  ⚪ apply createProcedure against databricks 3.1
  ⚪ apply createProcedureFromFile against databricks 3.1
  ⚪ apply createSequence against databricks 3.1
  ❌ apply createTable against databricks 3.1
	Condition not satisfied:
  ✅ apply createTableDataTypeText against databricks 3.1
  ✅ apply createTableTimestamp against databricks 3.1
  ⚪ apply createTrigger against databricks 3.1
  ✅ apply createView against databricks 3.1
  ⚪ apply disableCheckConstraint against databricks 3.1
  ⚪ apply disableTrigger against databricks 3.1
  ✅ apply dropAllForeignKeyConstraints against databricks 3.1
  ⚪ apply dropCheckConstraint against databricks 3.1
  ❌ apply dropColumn against databricks 3.1
	Condition not satisfied:
  ⚪ apply dropDefaultValue against databricks 3.1
  ✅ apply dropForeignKey against databricks 3.1
  ⚪ apply dropFunction against databricks 3.1
  ⚪ apply dropIndex against databricks 3.1
  ✅ apply dropNotNullConstraint against databricks 3.1
  ✅ apply dropPrimaryKey against databricks 3.1
  ⚪ apply dropProcedure against databricks 3.1
  ⚪ apply dropSequence against databricks 3.1
  ❌ apply dropTable against databricks 3.1
	Condition not satisfied:
  ⚪ apply dropTrigger against databricks 3.1
  ⚪ apply dropUniqueConstraint against databricks 3.1
  ✅ apply dropView against databricks 3.1
  ⚪ apply enableCheckConstraint against databricks 3.1
  ⚪ apply enableTrigger against databricks 3.1
  ✅ apply executeCommand against databricks 3.1
  ❌ apply mergeColumns against databricks 3.1
	Condition not satisfied:
  ⚪ apply modifyDataType against databricks 3.1
  ❌ apply modifySql against databricks 3.1
	Condition not satisfied:
  ✅ apply optimizeTable against databricks 3.1
  ✅ apply renameColumn against databricks 3.1
  ⚪ apply renameSequence against databricks 3.1
  ⚪ apply renameTable against databricks 3.1
  ⚪ apply renameTrigger against databricks 3.1
  ✅ apply renameView against databricks 3.1
  ✅ apply setColumnRemarks against databricks 3.1
  ✅ apply setTableRemarks against databricks 3.1
  ✅ apply sql against databricks 3.1
  ✅ apply sqlFile against databricks 3.1
  ✅ apply vacuumTable against databricks 3.1
liquibase.harness.data.ChangeDataTests
  ✅ apply delete against databricks 3.1
  ✅ apply insert against databricks 3.1
  ✅ apply loadData against databricks 3.1
  ✅ apply loadUpdateData against databricks 3.1

Annotations

Check failure on line 0 in target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml

See this annotation in the file changed.

@github-actions github-actions / Liquibase Test Harness - Contributed Reports

liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply alterTableProperties against databricks 3.1 

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_alter_table_properties (test_id INT NOT NULL, test_column VARCHAR(50) NOT NULL, CONSTRAINT PK_TEST_ALTER_TABLE_PROPERTIES PRIMARY KEY (test_id)) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true)
|            |  ALTER TABLE main.liquibase_harness_test_ds.test_alter_table_properties SET TBLPROPERTIES ('external.location'='s3://mybucket/mytable','this.is.my.key'=12,'this.is.my.key2'=true)
|            false
|            10 differences (68% similarity) (comparing subset start: 96, end1: 123, end2: 128)
|            est_column (ST)R(ING-----) NOT NULL,
|            est_column (VA)R(CHAR(50)) NOT NULL,
CREATE TABLE main.liquibase_harness_test_ds.test_alter_table_properties (test_id INT NOT NULL, test_column STRING NOT NULL, CONSTRAINT PK_TEST_ALTER_TABLE_PROPERTIES PRIMARY KEY (test_id)) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true)
ALTER TABLE main.liquibase_harness_test_ds.test_alter_table_properties SET TBLPROPERTIES ('external.location'='s3://mybucket/mytable','this.is.my.key'=12,'this.is.my.key2'=true)

	at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)

Check failure on line 0 in target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml

See this annotation in the file changed.

@github-actions github-actions / Liquibase Test Harness - Contributed Reports

liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply createClusteredTable against databricks 3.1 

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_clustered (test_id INT NOT NULL, test_column VARCHAR(50) NOT NULL, CONSTRAINT PK_TEST_TABLE_CLUSTERED PRIMARY KEY (test_id)) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true) CLUSTER BY (test_id)
|            false
|            10 differences (68% similarity) (comparing subset start: 89, end1: 116, end2: 121)
|            est_column (ST)R(ING-----) NOT NULL,
|            est_column (VA)R(CHAR(50)) NOT NULL,
CREATE TABLE main.liquibase_harness_test_ds.test_table_clustered (test_id INT NOT NULL, test_column STRING NOT NULL, CONSTRAINT PK_TEST_TABLE_CLUSTERED PRIMARY KEY (test_id)) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true) CLUSTER BY (test_id)

	at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)

Check failure on line 0 in target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml

See this annotation in the file changed.

@github-actions github-actions / Liquibase Test Harness - Contributed Reports

liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply createPartitionedTable against databricks 3.1 

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_partitioned (test_id INT NOT NULL, test_column VARCHAR(50) NOT NULL, partition_column STRING NOT NULL, CONSTRAINT PK_TEST_TABLE_PARTITIONED PRIMARY KEY (test_id)) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true) PARTITIONED BY (partition_column)
|            false
|            10 differences (68% similarity) (comparing subset start: 91, end1: 118, end2: 123)
|            est_column (ST)R(ING-----) NOT NULL,
|            est_column (VA)R(CHAR(50)) NOT NULL,
CREATE TABLE main.liquibase_harness_test_ds.test_table_partitioned (test_id INT NOT NULL, test_column STRING NOT NULL, partition_column STRING NOT NULL, CONSTRAINT PK_TEST_TABLE_PARTITIONED PRIMARY KEY (test_id)) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true) PARTITIONED BY (partition_column)

	at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)

Check failure on line 0 in target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml

See this annotation in the file changed.

@github-actions github-actions / Liquibase Test Harness - Contributed Reports

liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply createTable against databricks 3.1 

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', 'delta.enableDeletionVectors' = true)
|            |  CREATE TABLE main.liquibase_harness_test_ds.test_table_properties (test_id INT NOT NULL, CONSTRAINT PK_TEST_TABLE_PROPERTIES PRIMARY KEY (test_id)) TBLPROPERTIES ('external.location'='s3://mybucket/mytable','this.is.my.key'=12,'this.is.my.key2'=true)
|            false
|            10 differences (68% similarity) (comparing subset start: 79, end1: 106, end2: 111)
|            est_column (ST)R(ING-----) NOT NULL,
|            est_column (VA)R(CHAR(50)) NOT NULL,
CREATE TABLE main.liquibase_harness_test_ds.test_table (test_id INT NOT NULL, test_column STRING NOT NULL, CONSTRAINT PK_TEST_TABLE PRIMARY KEY (test_id)) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true)
CREATE TABLE main.liquibase_harness_test_ds.test_table_properties (test_id INT NOT NULL, CONSTRAINT PK_TEST_TABLE_PROPERTIES PRIMARY KEY (test_id)) TBLPROPERTIES ('external.location'='s3://mybucket/mytable','this.is.my.key'=12,'this.is.my.key2'=true)

	at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)

Check failure on line 0 in target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml

See this annotation in the file changed.

@github-actions github-actions / Liquibase Test Harness - Contributed Reports

liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply dropColumn against databricks 3.1 

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
|            10 differences (68% similarity) (comparing subset start: 63, end1: 90, end2: 95)
|            charColumn (ST)R(ING-----)\nUPDATE ma
|            charColumn (VA)R(CHAR(25))\nUPDATE ma
ALTER TABLE main.liquibase_harness_test_ds.posts ADD COLUMN varcharColumn STRING
UPDATE main.liquibase_harness_test_ds.posts SET varcharColumn = 'INITIAL_VALUE'
ALTER TABLE main.liquibase_harness_test_ds.posts DROP COLUMN varcharColumn

	at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)

Check failure on line 0 in target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml

See this annotation in the file changed.

@github-actions github-actions / Liquibase Test Harness - Contributed Reports

liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply dropTable against databricks 3.1 

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', 'delta.enableDeletionVectors' = true)
|            |  DROP TABLE main.liquibase_harness_test_ds.test_table
|            false
|            10 differences (68% similarity) (comparing subset start: 79, end1: 106, end2: 111)
|            est_column (ST)R(ING-----) NOT NULL,
|            est_column (VA)R(CHAR(50)) NOT NULL,
CREATE TABLE main.liquibase_harness_test_ds.test_table (test_id INT NOT NULL, test_column STRING NOT NULL, CONSTRAINT PK_TEST_TABLE PRIMARY KEY (test_id)) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true)
DROP TABLE main.liquibase_harness_test_ds.test_table

	at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)

Check failure on line 0 in target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml

See this annotation in the file changed.

@github-actions github-actions / Liquibase Test Harness - Contributed Reports

liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply mergeColumns against databricks 3.1 

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.full_name_table (first_name VARCHAR(50), last_name VARCHAR(50)) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true)
|            |  INSERT INTO main.liquibase_harness_test_ds.full_name_table (first_name) VALUES ('John')
|            |  UPDATE main.liquibase_harness_test_ds.full_name_table SET last_name = 'Doe' WHERE first_name='John'
|            |  INSERT INTO main.liquibase_harness_test_ds.full_name_table (first_name) VALUES ('Jane')
|            |  UPDATE main.liquibase_harness_test_ds.full_name_table SET last_name = 'Doe' WHERE first_name='Jane'
|            |  ALTER TABLE main.liquibase_harness_test_ds.full_name_table ADD COLUMN full_name VARCHAR(255)
|            |  UPDATE main.liquibase_harness_test_ds.full_name_table SET full_name = first_name || ' ' || last_name
|            |  ALTER TABLE main.liquibase_harness_test_ds.full_name_table DROP COLUMN first_name
|            |  ALTER TABLE main.liquibase_harness_test_ds.full_name_table DROP COLUMN last_name
|            false
|            Strings too large to calculate edit distance.
CREATE TABLE main.liquibase_harness_test_ds.full_name_table (first_name STRING, last_name STRING) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true)
INSERT INTO main.liquibase_harness_test_ds.full_name_table (first_name) VALUES ('John')
UPDATE main.liquibase_harness_test_ds.full_name_table SET last_name = 'Doe' WHERE first_name='John'
INSERT INTO main.liquibase_harness_test_ds.full_name_table (first_name) VALUES ('Jane')
UPDATE main.liquibase_harness_test_ds.full_name_table SET last_name = 'Doe' WHERE first_name='Jane'
ALTER TABLE main.liquibase_harness_test_ds.full_name_table ADD COLUMN full_name STRING
UPDATE main.liquibase_harness_test_ds.full_name_table SET full_name = first_name || ' ' || last_name
ALTER TABLE main.liquibase_harness_test_ds.full_name_table DROP COLUMN first_name
ALTER TABLE main.liquibase_harness_test_ds.full_name_table DROP COLUMN last_name

	at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)

Check failure on line 0 in target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml

See this annotation in the file changed.

@github-actions github-actions / Liquibase Test Harness - Contributed Reports

liquibase.ext.databricks.ContributedExtensionHarnessTestSuite ► liquibase.harness.change.ChangeObjectTests ► apply modifySql against databricks 3.1 

Failed test found in:
  target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
Error:
  Condition not satisfied:
Raw output 
Condition not satisfied:

generatedSql == expectedSql
|            |  |
|            |  /* prepend comment */ CREATE TABLE main.liquibase_harness_test_ds.test_table (test_id INT NOT NULL, test_column VARCHAR(50) NOT NULL, CONSTRAINT PK_cs_guaranteed_delivery PRIMARY KEY (test_id)) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true) -- append comment
|            false
|            10 differences (68% similarity) (comparing subset start: 101, end1: 128, end2: 133)
|            est_column (ST)R(ING-----) NOT NULL,
|            est_column (VA)R(CHAR(50)) NOT NULL,
/* prepend comment */ CREATE TABLE main.liquibase_harness_test_ds.test_table (test_id INT NOT NULL, test_column STRING NOT NULL, CONSTRAINT PK_cs_guaranteed_delivery PRIMARY KEY (test_id)) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true) -- append comment

	at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)
View more details on GitHub Actions