Skip to content

[DAT-18263] alterViewProperties changetype added #449

[DAT-18263] alterViewProperties changetype added

[DAT-18263] alterViewProperties changetype added #449

GitHub Actions / Liquibase Test Harness - Contributed Reports succeeded Sep 27, 2024 in 1s

44 passed, 1 failed and 32 skipped

Tests failed

Report Passed Failed Skipped Time
target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml 1779s
target/surefire-reports/TEST-liquibase.harness.change.ChangeObjectTests.xml 39✅ 1❌ 32⚪ 1622s
target/surefire-reports/TEST-liquibase.harness.data.ChangeDataTests.xml 5✅ 157s

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

No tests found

Test suite Passed Failed Skipped Time
liquibase.ext.databricks.ContributedExtensionHarnessTestSuite 1779s

❌ target/surefire-reports/TEST-liquibase.harness.change.ChangeObjectTests.xml

72 tests were completed in 1622s with 39 passed, 1 failed and 32 skipped.

Test suite Passed Failed Skipped Time
liquibase.harness.change.ChangeObjectTests 39✅ 1❌ 32⚪ 1622s

❌ 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 alterViewProperties 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
⚪ 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 createTableWithDefaultValues against databricks 3.1
	Condition not satisfied:
⚪ 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
✅ apply #testInput.changeObject against #testInput.databaseName #testInput.version

✅ target/surefire-reports/TEST-liquibase.harness.data.ChangeDataTests.xml

5 tests were completed in 157s with 5 passed, 0 failed and 0 skipped.

Test suite Passed Failed Skipped Time
liquibase.harness.data.ChangeDataTests 5✅ 157s

✅ 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
✅ apply #testInput.changeData against #testInput.databaseName #testInput.version

Annotations

Check failure on line 0 in target/surefire-reports/TEST-liquibase.harness.change.ChangeObjectTests.xml

See this annotation in the file changed.

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

liquibase.harness.change.ChangeObjectTests ► apply createTableWithDefaultValues against databricks 3.1

Failed test found in:
  target/surefire-reports/TEST-liquibase.harness.change.ChangeObjectTests.xml
Error:
  Condition not satisfied:
Raw output
Condition not satisfied:

generatedSql == expectedSql
|            |  |
|            |  CREATE TABLE main.liquibase_harness_test_ds.tableWithDefaultValues (longcolumn LONG GENERATED BY DEFAULT AS IDENTITY (START WITH 1 INCREMENT BY 1), eventTime TIMESTAMP, year INT GENERATED ALWAYS AS (YEAR(eventTime)), eventDate date GENERATED ALWAYS AS (CAST(eventTime AS DATE)), eventDescription STRING NOT NULL, eventShortDescription STRING GENERATED ALWAYS AS (SUBSTRING(eventDescription, 0, 1))) USING delta TBLPROPERTIES('delta.feature.allowColumnDefaults' = 'supported', 'delta.columnMapping.mode' = 'name', 'delta.enableDeletionVectors' = true)
|            false
|            24 differences (88% similarity) (comparing subset start: 167, end1: 375, end2: 351)
|            , year INT (DEFAULT )GENERATED ALWAYS AS (YEAR(eventTime)), eventDate date (DEFAULT )GENERATED ALWAYS AS (CAST(eventTime AS DATE)), eventDescription STRING NOT NULL, eventShortDescription STRING (DEFAULT )GENERATED
|            , year INT (--------)GENERATED ALWAYS AS (YEAR(eventTime)), eventDate date (--------)GENERATED ALWAYS AS (CAST(eventTime AS DATE)), eventDescription STRING NOT NULL, eventShortDescription STRING (--------)GENERATED
CREATE TABLE main.liquibase_harness_test_ds.tableWithDefaultValues (longcolumn LONG GENERATED BY DEFAULT AS IDENTITY (START WITH 1 INCREMENT BY 1), eventTime TIMESTAMP, year INT DEFAULT GENERATED ALWAYS AS (YEAR(eventTime)), eventDate date DEFAULT GENERATED ALWAYS AS (CAST(eventTime AS DATE)), eventDescription STRING NOT NULL, eventShortDescription STRING DEFAULT GENERATED ALWAYS AS (SUBSTRING(eventDescription, 0, 1))) 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)