Skip to content

[DAT-17952] Add support for ARRAY, MAP and Struct datatypes #416

[DAT-17952] Add support for ARRAY, MAP and Struct datatypes

[DAT-17952] Add support for ARRAY, MAP and Struct datatypes #416

GitHub Actions / Liquibase Test Harness - Contributed Reports succeeded Sep 9, 2024 in 0s

40 passed, 1 failed and 32 skipped

Tests failed

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

73 tests were completed in 1723s with 40 passed, 1 failed and 32 skipped.

Test suite Passed Failed Skipped Time
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite 40✅ 1❌ 32⚪ 1723s

❌ 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
  ✅ apply analyzeTable against databricks 3.1
  ✅ apply createClusteredTable against databricks 3.1
  ✅ apply createClusteredTableNew against databricks 3.1
  ❌ apply createComplexTypesTable 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
  ⚪ apply createProcedure against databricks 3.1
  ⚪ apply createProcedureFromFile against databricks 3.1
  ⚪ apply createSequence against databricks 3.1
  ✅ apply createTable against databricks 3.1
  ✅ 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
  ⚪ 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
  ⚪ 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
  ⚪ apply modifyDataType against databricks 3.1
  ✅ apply modifySql against databricks 3.1
  ✅ 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 createComplexTypesTable 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.filipe.test_table_complex_types (my_arrs ARRAY<STRING>, my_arrbi ARRAY<BIGINT>, my_map MAP<STRING, BIGINT>, my_struct STRUCT<FIELD1: STRING NOT NULL, FIELD2: INT>) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true)
|            false
|            22 differences (52% similarity) (comparing subset start: 7, end1: 53, end2: 34)
|            TABLE main.(l)i(qu)i(bas)e(_harness_test_ds).test_tabl
|            TABLE main.(f)i(l-)i(p--)e(----------------).test_tabl
CREATE TABLE main.liquibase_harness_test_ds.test_table_complex_types (my_arrs ARRAY<STRING>, my_arrbi ARRAY<BIGINT>, my_map MAP<STRING, BIGINT>, my_struct STRUCT<FIELD1: STRING NOT NULL, FIELD2: INT>) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true)

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