[DAT-18260] Add tblProperties to createView #431
GitHub Actions / Liquibase Test Harness - Contributed Reports
succeeded
Sep 12, 2024 in 0s
42 passed, 1 failed and 32 skipped
| Report | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml | 1681s | |||
| target/surefire-reports/TEST-liquibase.harness.change.ChangeObjectTests.xml | 37✅ | 1❌ | 32⚪ | 1528s |
| target/surefire-reports/TEST-liquibase.harness.data.ChangeDataTests.xml | 5✅ | 152s |
✅ target/surefire-reports/TEST-liquibase.ext.databricks.ContributedExtensionHarnessTestSuite.xml
No tests found
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| liquibase.ext.databricks.ContributedExtensionHarnessTestSuite | 1681s |
❌ target/surefire-reports/TEST-liquibase.harness.change.ChangeObjectTests.xml
70 tests were completed in 1528s with 37 passed, 1 failed and 32 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| liquibase.harness.change.ChangeObjectTests | 37✅ | 1❌ | 32⚪ | 1528s |
❌ 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 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 152s with 5 passed, 0 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| liquibase.harness.data.ChangeDataTests | 5✅ | 152s |
✅ 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
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)
Loading