Bump org.sonarsource.scanner.maven:sonar-maven-plugin from 3.11.0.3922 to 4.0.0.4121 #298
GitHub Actions / Liquibase Test Harness - Advanced Reports
succeeded
Jul 17, 2024 in 0s
8 passed, 1 failed and 0 skipped
❌ target/surefire-reports/TEST-liquibase.ext.databricks.AdvancedExtensionHarnessTestSuite.xml
9 tests were completed in 508s with 8 passed, 1 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| liquibase.ext.databricks.AdvancedExtensionHarnessTestSuite | 8✅ | 1❌ | 508s |
❌ 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-07-17T11:13:19.904",
| | "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/382e29d97d466bd3;AuthMech=3;ConnCatalog=main;ConnSchema=liquibase_harness_test_ds;EnableArrow=0;"
| | },
| | "objects": {
| | "liquibase.structure.core.Catalog": [
| | {
| | "catalog": {
| | "default": true,
| | "name": "main",
| | "snapshotId": "7d94335"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94342",
| | "snapshotId": "7d94344",
| | "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": "VARCHAR"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "COMMENTS",
| | "nullable": true,
| | "order": "9!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94342",
| | "snapshotId": "7d94351",
| | "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": "VARCHAR"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "CONTEXTS",
| | "nullable": true,
| | "order": "12!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94342",
| | "snapshotId": "7d94354",
| | "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": "VARCHAR"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DATEEXECUTED",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94342",
| | "snapshotId": "7d94346",
| | "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#7d94342",
| | "snapshotId": "7d94356",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "VARCHAR"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DESCRIPTION",
| | "nullable": true,
| | "order": "8!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94342",
| | "snapshotId": "7d94350",
| | "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": "VARCHAR"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "EXECTYPE",
| | "nullable": false,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94342",
| | "snapshotId": "7d94348",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "VARCHAR"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "FILENAME",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94342",
| | "snapshotId": "7d94345",
| | "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": "VARCHAR"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94342",
| | "snapshotId": "7d94343",
| | "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": "VARCHAR"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94357",
| | "snapshotId": "7d94358",
| | "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#7d94342",
| | "snapshotId": "7d94355",
| | "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": "VARCHAR"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LIQUIBASE",
| | "nullable": true,
| | "order": "11!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94342",
| | "snapshotId": "7d94353",
| | "type": {
| | "characterOctetLength": "20!{java.lang.Integer}",
| | "columnSize": "20!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "VARCHAR"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKED",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94357",
| | "snapshotId": "7d94359",
| | "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#7d94357",
| | "snapshotId": "7d94361",
| | "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": "VARCHAR"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKGRANTED",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94357",
| | "snapshotId": "7d94360",
| | "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#7d94342",
| | "snapshotId": "7d94349",
| | "type": {
| | "characterOctetLength": "35!{java.lang.Integer}",
| | "columnSize": "35!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "VARCHAR"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ORDEREXECUTED",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94342",
| | "snapshotId": "7d94347",
| | "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#7d94342",
| | "snapshotId": "7d94352",
| | "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": "VARCHAR"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "dateColumn",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#7d94337",
| | "snapshotId": "7d94341",
| | "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#7d94337",
| | "snapshotId": "7d94340",
| | "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#7d94337",
| | "snapshotId": "7d94338",
| | "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#7d94337",
| | "snapshotId": "7d94339",
| | "type": {
| | "characterOctetLength": "25!{java.lang.Integer}",
| | "columnSize": "25!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "radix": "0!{java.lang.Integer}",
| | "typeName": "VARCHAR"
| | }
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.PrimaryKey": [
| | {
| | "primaryKey": {
| | "columns": [
| | "liquibase.structure.core.Column#7d94358"
| | ]
| | ,
| | "name": "pk_databasechangeloglock",
| | "snapshotId": "7d94362",
| | "table": "liquibase.structure.core.Table#7d94357"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#7d94335",
| | "default": true,
| | "name": "liquibase_harness_test_ds",
| | "snapshotId": "7d94336"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#7d94343",
| | "liquibase.structure.core.Column#7d94344",
| | "liquibase.structure.core.Column#7d94345",
| | "liquibase.structure.core.Column#7d94346",
| | "liquibase.structure.core.Column#7d94347",
| | "liquibase.structure.core.Column#7d94348",
| | "liquibase.structure.core.Column#7d94349",
| | "liquibase.structure.core.Column#7d94350",
| | "liquibase.structure.core.Column#7d94351",
| | "liquibase.structure.core.Column#7d94352",
| | "liquibase.structure.core.Column#7d94353",
| | "liquibase.structure.core.Column#7d94354",
| | "liquibase.structure.core.Column#7d94355",
| | "liquibase.structure.core.Column#7d94356"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "databasechangelog",
| | "schema": "liquibase.structure.core.Schema#7d94336",
| | "snapshotId": "7d94342"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#7d94358",
| | "liquibase.structure.core.Column#7d94359",
| | "liquibase.structure.core.Column#7d94360",
| | "liquibase.structure.core.Column#7d94361"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "databasechangeloglock",
| | "primaryKey": "liquibase.structure.core.PrimaryKey#7d94362",
| | "schema": "liquibase.structure.core.Schema#7d94336",
| | "snapshotId": "7d94357"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#7d94338",
| | "liquibase.structure.core.Column#7d94339",
| | "liquibase.structure.core.Column#7d94340",
| | "liquibase.structure.core.Column#7d94341"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "test_table",
| | "schema": "liquibase.structure.core.Schema#7d94336",
| | "snapshotId": "7d94337"
| | }
| | }
| | ]
| |
| | },
| | "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": "STRING"
| }
| }
| },
| {
| "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":"STRING"}}}
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":"STRING"}}}
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