[DAT-17950] Add Alter Table Properties change #342
GitHub Actions / Liquibase Test Harness - Advanced Reports
succeeded
Aug 1, 2024 in 1s
8 passed, 1 failed and 0 skipped
❌ target/surefire-reports/TEST-liquibase.ext.databricks.AdvancedExtensionHarnessTestSuite.xml
9 tests were completed in 530s with 8 passed, 1 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| liquibase.ext.databricks.AdvancedExtensionHarnessTestSuite | 8✅ | 1❌ | 530s |
❌ liquibase.ext.databricks.AdvancedExtensionHarnessTestSuite
liquibase.harness.generateChangelog.GenerateChangelogTest
✅ apply generateChangelog test for createTable against databricks 3.1
liquibase.harness.snapshot.SnapshotObjectTests
❌ apply addColumn against databricks 3.1
Condition failed with Exception:
✅ apply addForeignKeyConstraint against databricks 3.1
✅ apply addPrimaryKey against databricks 3.1
✅ apply addUniqueConstraint against databricks 3.1
✅ apply createIndex against databricks 3.1
✅ apply createTable against databricks 3.1
✅ apply createView against databricks 3.1
✅ apply snapshotCaalogAndSchema against databricks 3.1
Annotations
github-actions / Liquibase Test Harness - Advanced Reports
liquibase.ext.databricks.AdvancedExtensionHarnessTestSuite ► liquibase.harness.snapshot.SnapshotObjectTests ► apply addColumn against databricks 3.1
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.databricks.AdvancedExtensionHarnessTestSuite.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-01T12:52:02.457",
| | "database": {
| | "productVersion": "3.1.1",
| | "shortName": "databricks",
| | "majorVersion": "3",
| | "minorVersion": "1",
| | "user": "User",
| | "productName": "SparkSQL",
| | "url": "jdbc:databricks://dbc-3602f6c7-ea60.cloud.databricks.com:443/default;transportMode=http;ssl=1;httpPath=/sql/1.0/warehouses/8995fa4e163a8254;AuthMech=3;ConnCatalog=main;ConnSchema=liquibase_harness_test_ds;EnableArrow=0;"
| | },
| | "objects": {
| | "liquibase.structure.core.Catalog": [
| | {
| | "catalog": {
| | "default": true,
| | "name": "main",
| | "snapshotId": "7ebf335"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf344",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "COMMENTS",
| | "nullable": true,
| | "order": "9!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf351",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "CONTEXTS",
| | "nullable": true,
| | "order": "12!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf354",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DATEEXECUTED",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf346",
| | "type": {
| | "columnSize": "9!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "TIMESTAMP"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DEPLOYMENT_ID",
| | "nullable": true,
| | "order": "14!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf356",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DESCRIPTION",
| | "nullable": true,
| | "order": "8!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf350",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "EXECTYPE",
| | "nullable": false,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf348",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "FILENAME",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf345",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf343",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf357",
| | "snapshotId": "7ebf358",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "4!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LABELS",
| | "nullable": true,
| | "order": "13!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf355",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LIQUIBASE",
| | "nullable": true,
| | "order": "11!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf353",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKED",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf357",
| | "snapshotId": "7ebf359",
| | "type": {
| | "columnSize": "1!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "16!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "BOOLEAN"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKEDBY",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf357",
| | "snapshotId": "7ebf361",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKGRANTED",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf357",
| | "snapshotId": "7ebf360",
| | "type": {
| | "columnSize": "9!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "TIMESTAMP"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "MD5SUM",
| | "nullable": true,
| | "order": "7!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf349",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ORDEREXECUTED",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf347",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "4!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "TAG",
| | "nullable": true,
| | "order": "10!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf342",
| | "snapshotId": "7ebf352",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "dateColumn",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf337",
| | "snapshotId": "7ebf341",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "intColumn",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf337",
| | "snapshotId": "7ebf340",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "4!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "test_column",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf337",
| | "snapshotId": "7ebf338",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "4!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "varcharColumn",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7ebf337",
| | "snapshotId": "7ebf339",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.PrimaryKey": [
| | {
| | "primaryKey": {
| | "columns": [
| | "liquibase.structure.core.Column#7ebf358"
| | ]
| | ,
| | "name": "pk_databasechangeloglock",
| | "snapshotId": "7ebf362",
| | "table": "liquibase.structure.core.Table#7ebf357"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#7ebf335",
| | "default": true,
| | "name": "liquibase_harness_test_ds",
| | "snapshotId": "7ebf336"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#7ebf343",
| | "liquibase.structure.core.Column#7ebf344",
| | "liquibase.structure.core.Column#7ebf345",
| | "liquibase.structure.core.Column#7ebf346",
| | "liquibase.structure.core.Column#7ebf347",
| | "liquibase.structure.core.Column#7ebf348",
| | "liquibase.structure.core.Column#7ebf349",
| | "liquibase.structure.core.Column#7ebf350",
| | "liquibase.structure.core.Column#7ebf351",
| | "liquibase.structure.core.Column#7ebf352",
| | "liquibase.structure.core.Column#7ebf353",
| | "liquibase.structure.core.Column#7ebf354",
| | "liquibase.structure.core.Column#7ebf355",
| | "liquibase.structure.core.Column#7ebf356"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "databasechangelog",
| | "schema": "liquibase.structure.core.Schema#7ebf336",
| | "snapshotId": "7ebf342"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#7ebf358",
| | "liquibase.structure.core.Column#7ebf359",
| | "liquibase.structure.core.Column#7ebf360",
| | "liquibase.structure.core.Column#7ebf361"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "databasechangeloglock",
| | "primaryKey": "liquibase.structure.core.PrimaryKey#7ebf362",
| | "schema": "liquibase.structure.core.Schema#7ebf336",
| | "snapshotId": "7ebf357"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#7ebf338",
| | "liquibase.structure.core.Column#7ebf339",
| | "liquibase.structure.core.Column#7ebf340",
| | "liquibase.structure.core.Column#7ebf341"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "test_table",
| | "schema": "liquibase.structure.core.Schema#7ebf336",
| | "snapshotId": "7ebf337"
| | }
| | }
| | ]
| |
| | },
| | "snapshotControl": {
| | "snapshotControl": {
| | "includedType": [
| | "liquibase.structure.core.Catalog",
| | "liquibase.structure.core.Column",
| | "liquibase.structure.core.ForeignKey",
| | "liquibase.structure.core.Index",
| | "liquibase.structure.core.PrimaryKey",
| | "liquibase.structure.core.Schema",
| | "liquibase.structure.core.Table",
| | "liquibase.structure.core.UniqueConstraint",
| | "liquibase.structure.core.View"
| | ]
| |
| | }
| | }
| | }
| | }
| {
| "snapshot": {
| "objects": {
| "liquibase.structure.core.Table": [
| {
| "table": {
| "name": "test_table"
| }
| }
| ],
| "liquibase.structure.core.Column": [
| {
| "column": {
| "name": "test_column",
| "nullable": true,
| "type": {
| "typeName": "INT"
| }
| }
| },
| {
| "column": {
| "name": "varcharColumn",
| "nullable": true,
| "type": {
| "typeName": "VARCHAR"
| }
| }
| },
| {
| "column": {
| "name": "intColumn",
| "nullable": true,
| "type": {
| "typeName": "INT"
| }
| }
| },
| {
| "column": {
| "name": "dateColumn",
| "nullable": true,
| "type": {
| "typeName": "DATE"
| }
| }
| }
| ]
| }
| }
| }
java.lang.AssertionError: snapshot.objects.liquibase.structure.core.Column[1] Could not find match for element {"column":{"nullable":true,"name":"varcharColumn","type":{"typeName":"VARCHAR"}}}
at org.skyscreamer.jsonassert.JSONAssert.assertEquals(JSONAssert.java:482)
at org.skyscreamer.jsonassert.JSONAssert.assertEquals(JSONAssert.java:464)
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
at liquibase.harness.snapshot.SnapshotObjectTests.apply #testInput.snapshotObject against #testInput.databaseName #testInput.databaseVersion(SnapshotObjectTests.groovy:60)
at liquibase.harness.snapshot.SnapshotObjectTests.apply #testInput.snapshotObject against #testInput.databaseName #testInput.databaseVersion(SnapshotObjectTests.groovy:60)
Caused by: java.lang.AssertionError: snapshot.objects.liquibase.structure.core.Column[1] Could not find match for element {"column":{"nullable":true,"name":"varcharColumn","type":{"typeName":"VARCHAR"}}}
at org.skyscreamer.jsonassert.JSONAssert.assertEquals(JSONAssert.java:482)
at org.skyscreamer.jsonassert.JSONAssert.assertEquals(JSONAssert.java:464)
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
... 1 more
Loading