[no-jira] added missing jsonAssert #629
GitHub Actions / Liquibase Test Harness - Advanced Reports
succeeded
Aug 1, 2024 in 0s
1 passed, 8 failed and 0 skipped
❌ target/surefire-reports/TEST-liquibase.ext.bigquery.AdvancedHarnessSuiteIT.xml
9 tests were completed in 544s with 1 passed, 8 failed and 0 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| liquibase.ext.bigquery.AdvancedHarnessSuiteIT | 1✅ | 8❌ | 544s |
❌ liquibase.ext.bigquery.AdvancedHarnessSuiteIT
liquibase.harness.generateChangelog.GenerateChangelogTest
✅ apply generateChangelog test for createTable against bigquery 1.5
liquibase.harness.snapshot.SnapshotObjectTests
❌ apply addColumn against bigquery 1.5
Condition failed with Exception:
❌ apply addForeignKeyConstraint against bigquery 1.5
Condition failed with Exception:
❌ apply addPrimaryKey against bigquery 1.5
Condition failed with Exception:
❌ apply addUniqueConstraint against bigquery 1.5
Condition failed with Exception:
❌ apply createIndex against bigquery 1.5
Condition failed with Exception:
❌ apply createTable against bigquery 1.5
Condition failed with Exception:
❌ apply createView against bigquery 1.5
Condition failed with Exception:
❌ apply snapshotCaalogAndSchema against bigquery 1.5
Condition failed with Exception:
Annotations
github-actions / Liquibase Test Harness - Advanced Reports
liquibase.ext.bigquery.AdvancedHarnessSuiteIT ► liquibase.harness.snapshot.SnapshotObjectTests ► apply addColumn against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.AdvancedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-01T16:27:11.892",
| | "database": {
| | "productVersion": "1.5",
| | "shortName": "bigquery",
| | "majorVersion": "1",
| | "minorVersion": "5",
| | "user": "",
| | "productName": "Google BigQuery",
| | "url": "jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=testharnesstests;DefaultDataset=harness_test_ds;OAuthType=3;timeout=3600;"
| | },
| | "objects": {
| | "liquibase.structure.core.Catalog": [
| | {
| | "catalog": {
| | "default": true,
| | "name": "testharnesstests",
| | "snapshotId": "50a5346"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5355",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "COMMENTS",
| | "nullable": true,
| | "order": "9!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5362",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "CONTEXTS",
| | "nullable": true,
| | "order": "12!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5365",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DATEEXECUTED",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5357",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DEPLOYMENT_ID",
| | "nullable": true,
| | "order": "14!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5367",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DESCRIPTION",
| | "nullable": true,
| | "order": "8!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5361",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "EXECTYPE",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5359",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "FILENAME",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5356",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5354",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5368",
| | "snapshotId": "50a5369",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LABELS",
| | "nullable": true,
| | "order": "13!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5366",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LIQUIBASE",
| | "nullable": true,
| | "order": "11!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5364",
| | "type": {
| | "characterOctetLength": "20!{java.lang.Integer}",
| | "columnSize": "20!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKED",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5368",
| | "snapshotId": "50a5370",
| | "type": {
| | "columnSize": "1!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "16!{java.lang.Integer}",
| | "typeName": "BOOLEAN"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKEDBY",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5368",
| | "snapshotId": "50a5372",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKGRANTED",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5368",
| | "snapshotId": "50a5371",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "MD5SUM",
| | "nullable": true,
| | "order": "7!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5360",
| | "type": {
| | "characterOctetLength": "35!{java.lang.Integer}",
| | "columnSize": "35!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ORDEREXECUTED",
| | "nullable": true,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5358",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "TAG",
| | "nullable": true,
| | "order": "10!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5353",
| | "snapshotId": "50a5363",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "added",
| | "nullable": false,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5373",
| | "snapshotId": "50a5379",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "TIMESTAMP"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "author_id",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5380",
| | "snapshotId": "50a5382",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "birthdate",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5373",
| | "snapshotId": "50a5378",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "content",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5380",
| | "snapshotId": "50a5385",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "dateColumn",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5348",
| | "snapshotId": "50a5352",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "description",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5380",
| | "snapshotId": "50a5384",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "email",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5373",
| | "snapshotId": "50a5377",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "first_name",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5373",
| | "snapshotId": "50a5375",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5373",
| | "snapshotId": "50a5374",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5380",
| | "snapshotId": "50a5381",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "inserted_date",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5380",
| | "snapshotId": "50a5386",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "intColumn",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5348",
| | "snapshotId": "50a5351",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "last_name",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5373",
| | "snapshotId": "50a5376",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "test_column",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5348",
| | "snapshotId": "50a5349",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "title",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5380",
| | "snapshotId": "50a5383",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "varcharColumn",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5348",
| | "snapshotId": "50a5350",
| | "type": {
| | "characterOctetLength": "25!{java.lang.Integer}",
| | "columnSize": "25!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#50a5346",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "50a5347"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5354",
| | "liquibase.structure.core.Column#50a5355",
| | "liquibase.structure.core.Column#50a5356",
| | "liquibase.structure.core.Column#50a5357",
| | "liquibase.structure.core.Column#50a5358",
| | "liquibase.structure.core.Column#50a5359",
| | "liquibase.structure.core.Column#50a5360",
| | "liquibase.structure.core.Column#50a5361",
| | "liquibase.structure.core.Column#50a5362",
| | "liquibase.structure.core.Column#50a5363",
| | "liquibase.structure.core.Column#50a5364",
| | "liquibase.structure.core.Column#50a5365",
| | "liquibase.structure.core.Column#50a5366",
| | "liquibase.structure.core.Column#50a5367"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#50a5347",
| | "snapshotId": "50a5353"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5369",
| | "liquibase.structure.core.Column#50a5370",
| | "liquibase.structure.core.Column#50a5371",
| | "liquibase.structure.core.Column#50a5372"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#50a5347",
| | "snapshotId": "50a5368"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5374",
| | "liquibase.structure.core.Column#50a5375",
| | "liquibase.structure.core.Column#50a5376",
| | "liquibase.structure.core.Column#50a5377",
| | "liquibase.structure.core.Column#50a5378",
| | "liquibase.structure.core.Column#50a5379"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#50a5347",
| | "snapshotId": "50a5373"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5381",
| | "liquibase.structure.core.Column#50a5382",
| | "liquibase.structure.core.Column#50a5383",
| | "liquibase.structure.core.Column#50a5384",
| | "liquibase.structure.core.Column#50a5385",
| | "liquibase.structure.core.Column#50a5386"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#50a5347",
| | "snapshotId": "50a5380"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5349",
| | "liquibase.structure.core.Column#50a5350",
| | "liquibase.structure.core.Column#50a5351",
| | "liquibase.structure.core.Column#50a5352"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "test_table",
| | "schema": "liquibase.structure.core.Schema#50a5347",
| | "snapshotId": "50a5348"
| | }
| | }
| | ]
| |
| | },
| | "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": "INT64"
| }
| }
| },
| {
| "column": {
| "name": "varcharColumn",
| "nullable": true,
| "type": {
| "typeName": "STRING"
| }
| }
| },
| {
| "column": {
| "name": "intColumn",
| "nullable": true,
| "type": {
| "typeName": "INT64"
| }
| }
| },
| {
| "column": {
| "name": "dateColumn",
| "nullable": true,
| "type": {
| "typeName": "DATE"
| }
| }
| }
| ]
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
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)
Caused by: java.lang.ClassNotFoundException: org.skyscreamer.jsonassert.JSONAssert
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:527)
... 2 more
at liquibase.harness.snapshot.SnapshotObjectTests.apply #testInput.snapshotObject against #testInput.databaseName #testInput.databaseVersion(SnapshotObjectTests.groovy:60)
Caused by: java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
... 1 more
Caused by: java.lang.ClassNotFoundException: org.skyscreamer.jsonassert.JSONAssert
at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)
at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)
at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:527)
... 2 more
github-actions / Liquibase Test Harness - Advanced Reports
liquibase.ext.bigquery.AdvancedHarnessSuiteIT ► liquibase.harness.snapshot.SnapshotObjectTests ► apply addForeignKeyConstraint against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.AdvancedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-01T16:27:50.996",
| | "database": {
| | "productVersion": "1.5",
| | "shortName": "bigquery",
| | "majorVersion": "1",
| | "minorVersion": "5",
| | "user": "",
| | "productName": "Google BigQuery",
| | "url": "jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=testharnesstests;DefaultDataset=harness_test_ds;OAuthType=3;timeout=3600;"
| | },
| | "objects": {
| | "liquibase.structure.core.Catalog": [
| | {
| | "catalog": {
| | "default": true,
| | "name": "testharnesstests",
| | "snapshotId": "50a5417"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5421",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "COMMENTS",
| | "nullable": true,
| | "order": "9!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5428",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "CONTEXTS",
| | "nullable": true,
| | "order": "12!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5431",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DATEEXECUTED",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5423",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DEPLOYMENT_ID",
| | "nullable": true,
| | "order": "14!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5433",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DESCRIPTION",
| | "nullable": true,
| | "order": "8!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5427",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "EXECTYPE",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5425",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "FILENAME",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5422",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5420",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5434",
| | "snapshotId": "50a5435",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LABELS",
| | "nullable": true,
| | "order": "13!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5432",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LIQUIBASE",
| | "nullable": true,
| | "order": "11!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5430",
| | "type": {
| | "characterOctetLength": "20!{java.lang.Integer}",
| | "columnSize": "20!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKED",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5434",
| | "snapshotId": "50a5436",
| | "type": {
| | "columnSize": "1!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "16!{java.lang.Integer}",
| | "typeName": "BOOLEAN"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKEDBY",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5434",
| | "snapshotId": "50a5438",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKGRANTED",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5434",
| | "snapshotId": "50a5437",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "MD5SUM",
| | "nullable": true,
| | "order": "7!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5426",
| | "type": {
| | "characterOctetLength": "35!{java.lang.Integer}",
| | "columnSize": "35!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ORDEREXECUTED",
| | "nullable": true,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5424",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "TAG",
| | "nullable": true,
| | "order": "10!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5419",
| | "snapshotId": "50a5429",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "added",
| | "nullable": false,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5439",
| | "snapshotId": "50a5445",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "TIMESTAMP"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "author_id",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5446",
| | "snapshotId": "50a5448",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "birthdate",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5439",
| | "snapshotId": "50a5444",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "content",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5446",
| | "snapshotId": "50a5451",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "description",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5446",
| | "snapshotId": "50a5450",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "email",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5439",
| | "snapshotId": "50a5443",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "first_name",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5439",
| | "snapshotId": "50a5441",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5439",
| | "snapshotId": "50a5440",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5446",
| | "snapshotId": "50a5447",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "inserted_date",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5446",
| | "snapshotId": "50a5452",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "last_name",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5439",
| | "snapshotId": "50a5442",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "title",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5446",
| | "snapshotId": "50a5449",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#50a5417",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "50a5418"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5420",
| | "liquibase.structure.core.Column#50a5421",
| | "liquibase.structure.core.Column#50a5422",
| | "liquibase.structure.core.Column#50a5423",
| | "liquibase.structure.core.Column#50a5424",
| | "liquibase.structure.core.Column#50a5425",
| | "liquibase.structure.core.Column#50a5426",
| | "liquibase.structure.core.Column#50a5427",
| | "liquibase.structure.core.Column#50a5428",
| | "liquibase.structure.core.Column#50a5429",
| | "liquibase.structure.core.Column#50a5430",
| | "liquibase.structure.core.Column#50a5431",
| | "liquibase.structure.core.Column#50a5432",
| | "liquibase.structure.core.Column#50a5433"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#50a5418",
| | "snapshotId": "50a5419"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5435",
| | "liquibase.structure.core.Column#50a5436",
| | "liquibase.structure.core.Column#50a5437",
| | "liquibase.structure.core.Column#50a5438"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#50a5418",
| | "snapshotId": "50a5434"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5440",
| | "liquibase.structure.core.Column#50a5441",
| | "liquibase.structure.core.Column#50a5442",
| | "liquibase.structure.core.Column#50a5443",
| | "liquibase.structure.core.Column#50a5444",
| | "liquibase.structure.core.Column#50a5445"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#50a5418",
| | "snapshotId": "50a5439"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5447",
| | "liquibase.structure.core.Column#50a5448",
| | "liquibase.structure.core.Column#50a5449",
| | "liquibase.structure.core.Column#50a5450",
| | "liquibase.structure.core.Column#50a5451",
| | "liquibase.structure.core.Column#50a5452"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#50a5418",
| | "snapshotId": "50a5446"
| | }
| | }
| | ]
| |
| | },
| | "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": {
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
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.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
... 1 more
github-actions / Liquibase Test Harness - Advanced Reports
liquibase.ext.bigquery.AdvancedHarnessSuiteIT ► liquibase.harness.snapshot.SnapshotObjectTests ► apply addPrimaryKey against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.AdvancedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-01T16:28:35.908",
| | "database": {
| | "productVersion": "1.5",
| | "shortName": "bigquery",
| | "majorVersion": "1",
| | "minorVersion": "5",
| | "user": "",
| | "productName": "Google BigQuery",
| | "url": "jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=testharnesstests;DefaultDataset=harness_test_ds;OAuthType=3;timeout=3600;"
| | },
| | "objects": {
| | "liquibase.structure.core.Catalog": [
| | {
| | "catalog": {
| | "default": true,
| | "name": "testharnesstests",
| | "snapshotId": "50a5483"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5490",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "COMMENTS",
| | "nullable": true,
| | "order": "9!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5497",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "CONTEXTS",
| | "nullable": true,
| | "order": "12!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5500",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DATEEXECUTED",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5492",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DEPLOYMENT_ID",
| | "nullable": true,
| | "order": "14!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5502",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DESCRIPTION",
| | "nullable": true,
| | "order": "8!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5496",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "EXECTYPE",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5494",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "FILENAME",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5491",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5489",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5503",
| | "snapshotId": "50a5504",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LABELS",
| | "nullable": true,
| | "order": "13!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5501",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LIQUIBASE",
| | "nullable": true,
| | "order": "11!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5499",
| | "type": {
| | "characterOctetLength": "20!{java.lang.Integer}",
| | "columnSize": "20!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKED",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5503",
| | "snapshotId": "50a5505",
| | "type": {
| | "columnSize": "1!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "16!{java.lang.Integer}",
| | "typeName": "BOOLEAN"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKEDBY",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5503",
| | "snapshotId": "50a5507",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKGRANTED",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5503",
| | "snapshotId": "50a5506",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "MD5SUM",
| | "nullable": true,
| | "order": "7!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5495",
| | "type": {
| | "characterOctetLength": "35!{java.lang.Integer}",
| | "columnSize": "35!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ORDEREXECUTED",
| | "nullable": true,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5493",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "TAG",
| | "nullable": true,
| | "order": "10!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5488",
| | "snapshotId": "50a5498",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "added",
| | "nullable": false,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5508",
| | "snapshotId": "50a5514",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "TIMESTAMP"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "author_id",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5515",
| | "snapshotId": "50a5517",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "birthdate",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5508",
| | "snapshotId": "50a5513",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "content",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5515",
| | "snapshotId": "50a5520",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "description",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5515",
| | "snapshotId": "50a5519",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "email",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5508",
| | "snapshotId": "50a5512",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "first_name",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5508",
| | "snapshotId": "50a5510",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5508",
| | "snapshotId": "50a5509",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5515",
| | "snapshotId": "50a5516",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5485",
| | "snapshotId": "50a5486",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "inserted_date",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5515",
| | "snapshotId": "50a5521",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "last_name",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5508",
| | "snapshotId": "50a5511",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "title",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5515",
| | "snapshotId": "50a5518",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.PrimaryKey": [
| | {
| | "primaryKey": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5486"
| | ]
| | ,
| | "name": "test_table.pk$",
| | "snapshotId": "50a5487",
| | "table": "liquibase.structure.core.Table#50a5485"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#50a5483",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "50a5484"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5489",
| | "liquibase.structure.core.Column#50a5490",
| | "liquibase.structure.core.Column#50a5491",
| | "liquibase.structure.core.Column#50a5492",
| | "liquibase.structure.core.Column#50a5493",
| | "liquibase.structure.core.Column#50a5494",
| | "liquibase.structure.core.Column#50a5495",
| | "liquibase.structure.core.Column#50a5496",
| | "liquibase.structure.core.Column#50a5497",
| | "liquibase.structure.core.Column#50a5498",
| | "liquibase.structure.core.Column#50a5499",
| | "liquibase.structure.core.Column#50a5500",
| | "liquibase.structure.core.Column#50a5501",
| | "liquibase.structure.core.Column#50a5502"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#50a5484",
| | "snapshotId": "50a5488"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5504",
| | "liquibase.structure.core.Column#50a5505",
| | "liquibase.structure.core.Column#50a5506",
| | "liquibase.structure.core.Column#50a5507"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#50a5484",
| | "snapshotId": "50a5503"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5509",
| | "liquibase.structure.core.Column#50a5510",
| | "liquibase.structure.core.Column#50a5511",
| | "liquibase.structure.core.Column#50a5512",
| | "liquibase.structure.core.Column#50a5513",
| | "liquibase.structure.core.Column#50a5514"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#50a5484",
| | "snapshotId": "50a5508"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5516",
| | "liquibase.structure.core.Column#50a5517",
| | "liquibase.structure.core.Column#50a5518",
| | "liquibase.structure.core.Column#50a5519",
| | "liquibase.structure.core.Column#50a5520",
| | "liquibase.structure.core.Column#50a5521"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#50a5484",
| | "snapshotId": "50a5515"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5486"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "test_table",
| | "primaryKey": "liquibase.structure.core.PrimaryKey#50a5487",
| | "schema": "liquibase.structure.core.Schema#50a5484",
| | "snapshotId": "50a5485"
| | }
| | }
| | ]
| |
| | },
| | "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",
| "primaryKey": "liquibase.structure.core.PrimaryKey.*"
| }
| }
| ],
| "liquibase.structure.core.PrimaryKey": [
| {
| "primaryKey": {
| "name": "test_table.pk$"
| }
| }
| ]
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
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.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
... 1 more
github-actions / Liquibase Test Harness - Advanced Reports
liquibase.ext.bigquery.AdvancedHarnessSuiteIT ► liquibase.harness.snapshot.SnapshotObjectTests ► apply addUniqueConstraint against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.AdvancedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-01T16:29:14.806",
| | "database": {
| | "productVersion": "1.5",
| | "shortName": "bigquery",
| | "majorVersion": "1",
| | "minorVersion": "5",
| | "user": "",
| | "productName": "Google BigQuery",
| | "url": "jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=testharnesstests;DefaultDataset=harness_test_ds;OAuthType=3;timeout=3600;"
| | },
| | "objects": {
| | "liquibase.structure.core.Catalog": [
| | {
| | "catalog": {
| | "default": true,
| | "name": "testharnesstests",
| | "snapshotId": "50a5552"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5556",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "COMMENTS",
| | "nullable": true,
| | "order": "9!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5563",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "CONTEXTS",
| | "nullable": true,
| | "order": "12!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5566",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DATEEXECUTED",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5558",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DEPLOYMENT_ID",
| | "nullable": true,
| | "order": "14!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5568",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DESCRIPTION",
| | "nullable": true,
| | "order": "8!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5562",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "EXECTYPE",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5560",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "FILENAME",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5557",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5555",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5569",
| | "snapshotId": "50a5570",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LABELS",
| | "nullable": true,
| | "order": "13!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5567",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LIQUIBASE",
| | "nullable": true,
| | "order": "11!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5565",
| | "type": {
| | "characterOctetLength": "20!{java.lang.Integer}",
| | "columnSize": "20!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKED",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5569",
| | "snapshotId": "50a5571",
| | "type": {
| | "columnSize": "1!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "16!{java.lang.Integer}",
| | "typeName": "BOOLEAN"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKEDBY",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5569",
| | "snapshotId": "50a5573",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKGRANTED",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5569",
| | "snapshotId": "50a5572",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "MD5SUM",
| | "nullable": true,
| | "order": "7!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5561",
| | "type": {
| | "characterOctetLength": "35!{java.lang.Integer}",
| | "columnSize": "35!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ORDEREXECUTED",
| | "nullable": true,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5559",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "TAG",
| | "nullable": true,
| | "order": "10!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5554",
| | "snapshotId": "50a5564",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "added",
| | "nullable": false,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5574",
| | "snapshotId": "50a5580",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "TIMESTAMP"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "author_id",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5581",
| | "snapshotId": "50a5583",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "birthdate",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5574",
| | "snapshotId": "50a5579",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "content",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5581",
| | "snapshotId": "50a5586",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "description",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5581",
| | "snapshotId": "50a5585",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "email",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5574",
| | "snapshotId": "50a5578",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "first_name",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5574",
| | "snapshotId": "50a5576",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5574",
| | "snapshotId": "50a5575",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5581",
| | "snapshotId": "50a5582",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "inserted_date",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5581",
| | "snapshotId": "50a5587",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "last_name",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5574",
| | "snapshotId": "50a5577",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "title",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5581",
| | "snapshotId": "50a5584",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#50a5552",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "50a5553"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5555",
| | "liquibase.structure.core.Column#50a5556",
| | "liquibase.structure.core.Column#50a5557",
| | "liquibase.structure.core.Column#50a5558",
| | "liquibase.structure.core.Column#50a5559",
| | "liquibase.structure.core.Column#50a5560",
| | "liquibase.structure.core.Column#50a5561",
| | "liquibase.structure.core.Column#50a5562",
| | "liquibase.structure.core.Column#50a5563",
| | "liquibase.structure.core.Column#50a5564",
| | "liquibase.structure.core.Column#50a5565",
| | "liquibase.structure.core.Column#50a5566",
| | "liquibase.structure.core.Column#50a5567",
| | "liquibase.structure.core.Column#50a5568"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#50a5553",
| | "snapshotId": "50a5554"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5570",
| | "liquibase.structure.core.Column#50a5571",
| | "liquibase.structure.core.Column#50a5572",
| | "liquibase.structure.core.Column#50a5573"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#50a5553",
| | "snapshotId": "50a5569"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5575",
| | "liquibase.structure.core.Column#50a5576",
| | "liquibase.structure.core.Column#50a5577",
| | "liquibase.structure.core.Column#50a5578",
| | "liquibase.structure.core.Column#50a5579",
| | "liquibase.structure.core.Column#50a5580"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#50a5553",
| | "snapshotId": "50a5574"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5582",
| | "liquibase.structure.core.Column#50a5583",
| | "liquibase.structure.core.Column#50a5584",
| | "liquibase.structure.core.Column#50a5585",
| | "liquibase.structure.core.Column#50a5586",
| | "liquibase.structure.core.Column#50a5587"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#50a5553",
| | "snapshotId": "50a5581"
| | }
| | }
| | ]
| |
| | },
| | "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": {
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
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.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
... 1 more
github-actions / Liquibase Test Harness - Advanced Reports
liquibase.ext.bigquery.AdvancedHarnessSuiteIT ► liquibase.harness.snapshot.SnapshotObjectTests ► apply createIndex against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.AdvancedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-01T16:29:46.683",
| | "database": {
| | "productVersion": "1.5",
| | "shortName": "bigquery",
| | "majorVersion": "1",
| | "minorVersion": "5",
| | "user": "",
| | "productName": "Google BigQuery",
| | "url": "jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=testharnesstests;DefaultDataset=harness_test_ds;OAuthType=3;timeout=3600;"
| | },
| | "objects": {
| | "liquibase.structure.core.Catalog": [
| | {
| | "catalog": {
| | "default": true,
| | "name": "testharnesstests",
| | "snapshotId": "50a5618"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5622",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "COMMENTS",
| | "nullable": true,
| | "order": "9!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5629",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "CONTEXTS",
| | "nullable": true,
| | "order": "12!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5632",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DATEEXECUTED",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5624",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DEPLOYMENT_ID",
| | "nullable": true,
| | "order": "14!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5634",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DESCRIPTION",
| | "nullable": true,
| | "order": "8!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5628",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "EXECTYPE",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5626",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "FILENAME",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5623",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5621",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5635",
| | "snapshotId": "50a5636",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LABELS",
| | "nullable": true,
| | "order": "13!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5633",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LIQUIBASE",
| | "nullable": true,
| | "order": "11!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5631",
| | "type": {
| | "characterOctetLength": "20!{java.lang.Integer}",
| | "columnSize": "20!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKED",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5635",
| | "snapshotId": "50a5637",
| | "type": {
| | "columnSize": "1!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "16!{java.lang.Integer}",
| | "typeName": "BOOLEAN"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKEDBY",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5635",
| | "snapshotId": "50a5639",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKGRANTED",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5635",
| | "snapshotId": "50a5638",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "MD5SUM",
| | "nullable": true,
| | "order": "7!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5627",
| | "type": {
| | "characterOctetLength": "35!{java.lang.Integer}",
| | "columnSize": "35!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ORDEREXECUTED",
| | "nullable": true,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5625",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "TAG",
| | "nullable": true,
| | "order": "10!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5620",
| | "snapshotId": "50a5630",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "added",
| | "nullable": false,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5640",
| | "snapshotId": "50a5646",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "TIMESTAMP"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "author_id",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5647",
| | "snapshotId": "50a5649",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "birthdate",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5640",
| | "snapshotId": "50a5645",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "content",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5647",
| | "snapshotId": "50a5652",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "description",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5647",
| | "snapshotId": "50a5651",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "email",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5640",
| | "snapshotId": "50a5644",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "first_name",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5640",
| | "snapshotId": "50a5642",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5640",
| | "snapshotId": "50a5641",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5647",
| | "snapshotId": "50a5648",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "inserted_date",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5647",
| | "snapshotId": "50a5653",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "last_name",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5640",
| | "snapshotId": "50a5643",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "title",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5647",
| | "snapshotId": "50a5650",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#50a5618",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "50a5619"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5621",
| | "liquibase.structure.core.Column#50a5622",
| | "liquibase.structure.core.Column#50a5623",
| | "liquibase.structure.core.Column#50a5624",
| | "liquibase.structure.core.Column#50a5625",
| | "liquibase.structure.core.Column#50a5626",
| | "liquibase.structure.core.Column#50a5627",
| | "liquibase.structure.core.Column#50a5628",
| | "liquibase.structure.core.Column#50a5629",
| | "liquibase.structure.core.Column#50a5630",
| | "liquibase.structure.core.Column#50a5631",
| | "liquibase.structure.core.Column#50a5632",
| | "liquibase.structure.core.Column#50a5633",
| | "liquibase.structure.core.Column#50a5634"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#50a5619",
| | "snapshotId": "50a5620"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5636",
| | "liquibase.structure.core.Column#50a5637",
| | "liquibase.structure.core.Column#50a5638",
| | "liquibase.structure.core.Column#50a5639"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#50a5619",
| | "snapshotId": "50a5635"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5641",
| | "liquibase.structure.core.Column#50a5642",
| | "liquibase.structure.core.Column#50a5643",
| | "liquibase.structure.core.Column#50a5644",
| | "liquibase.structure.core.Column#50a5645",
| | "liquibase.structure.core.Column#50a5646"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#50a5619",
| | "snapshotId": "50a5640"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5648",
| | "liquibase.structure.core.Column#50a5649",
| | "liquibase.structure.core.Column#50a5650",
| | "liquibase.structure.core.Column#50a5651",
| | "liquibase.structure.core.Column#50a5652",
| | "liquibase.structure.core.Column#50a5653"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#50a5619",
| | "snapshotId": "50a5647"
| | }
| | }
| | ]
| |
| | },
| | "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": {
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
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.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
... 1 more
github-actions / Liquibase Test Harness - Advanced Reports
liquibase.ext.bigquery.AdvancedHarnessSuiteIT ► liquibase.harness.snapshot.SnapshotObjectTests ► apply createTable against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.AdvancedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-01T16:30:27.99",
| | "database": {
| | "productVersion": "1.5",
| | "shortName": "bigquery",
| | "majorVersion": "1",
| | "minorVersion": "5",
| | "user": "",
| | "productName": "Google BigQuery",
| | "url": "jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=testharnesstests;DefaultDataset=harness_test_ds;OAuthType=3;timeout=3600;"
| | },
| | "objects": {
| | "liquibase.structure.core.Catalog": [
| | {
| | "catalog": {
| | "default": true,
| | "name": "testharnesstests",
| | "snapshotId": "50a5684"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5688",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "COMMENTS",
| | "nullable": true,
| | "order": "9!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5695",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "CONTEXTS",
| | "nullable": true,
| | "order": "12!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5698",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DATEEXECUTED",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5690",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DEPLOYMENT_ID",
| | "nullable": true,
| | "order": "14!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5700",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DESCRIPTION",
| | "nullable": true,
| | "order": "8!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5694",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "EXECTYPE",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5692",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "FILENAME",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5689",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5687",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5703",
| | "snapshotId": "50a5704",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LABELS",
| | "nullable": true,
| | "order": "13!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5699",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LIQUIBASE",
| | "nullable": true,
| | "order": "11!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5697",
| | "type": {
| | "characterOctetLength": "20!{java.lang.Integer}",
| | "columnSize": "20!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKED",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5703",
| | "snapshotId": "50a5705",
| | "type": {
| | "columnSize": "1!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "16!{java.lang.Integer}",
| | "typeName": "BOOLEAN"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKEDBY",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5703",
| | "snapshotId": "50a5707",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKGRANTED",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5703",
| | "snapshotId": "50a5706",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "MD5SUM",
| | "nullable": true,
| | "order": "7!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5693",
| | "type": {
| | "characterOctetLength": "35!{java.lang.Integer}",
| | "columnSize": "35!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ORDEREXECUTED",
| | "nullable": true,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5691",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "TAG",
| | "nullable": true,
| | "order": "10!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5686",
| | "snapshotId": "50a5696",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "added",
| | "nullable": false,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5708",
| | "snapshotId": "50a5714",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "TIMESTAMP"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "author_id",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5715",
| | "snapshotId": "50a5717",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "birthdate",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5708",
| | "snapshotId": "50a5713",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "content",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5715",
| | "snapshotId": "50a5720",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "description",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5715",
| | "snapshotId": "50a5719",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "email",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5708",
| | "snapshotId": "50a5712",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "first_name",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5708",
| | "snapshotId": "50a5710",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5708",
| | "snapshotId": "50a5709",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5715",
| | "snapshotId": "50a5716",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "inserted_date",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5715",
| | "snapshotId": "50a5721",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "last_name",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5708",
| | "snapshotId": "50a5711",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "snapshot_test_column",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5701",
| | "snapshotId": "50a5702",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "title",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5715",
| | "snapshotId": "50a5718",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#50a5684",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "50a5685"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5687",
| | "liquibase.structure.core.Column#50a5688",
| | "liquibase.structure.core.Column#50a5689",
| | "liquibase.structure.core.Column#50a5690",
| | "liquibase.structure.core.Column#50a5691",
| | "liquibase.structure.core.Column#50a5692",
| | "liquibase.structure.core.Column#50a5693",
| | "liquibase.structure.core.Column#50a5694",
| | "liquibase.structure.core.Column#50a5695",
| | "liquibase.structure.core.Column#50a5696",
| | "liquibase.structure.core.Column#50a5697",
| | "liquibase.structure.core.Column#50a5698",
| | "liquibase.structure.core.Column#50a5699",
| | "liquibase.structure.core.Column#50a5700"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#50a5685",
| | "snapshotId": "50a5686"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5704",
| | "liquibase.structure.core.Column#50a5705",
| | "liquibase.structure.core.Column#50a5706",
| | "liquibase.structure.core.Column#50a5707"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#50a5685",
| | "snapshotId": "50a5703"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5709",
| | "liquibase.structure.core.Column#50a5710",
| | "liquibase.structure.core.Column#50a5711",
| | "liquibase.structure.core.Column#50a5712",
| | "liquibase.structure.core.Column#50a5713",
| | "liquibase.structure.core.Column#50a5714"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#50a5685",
| | "snapshotId": "50a5708"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5716",
| | "liquibase.structure.core.Column#50a5717",
| | "liquibase.structure.core.Column#50a5718",
| | "liquibase.structure.core.Column#50a5719",
| | "liquibase.structure.core.Column#50a5720",
| | "liquibase.structure.core.Column#50a5721"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#50a5685",
| | "snapshotId": "50a5715"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5702"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "snapshot_test_table",
| | "schema": "liquibase.structure.core.Schema#50a5685",
| | "snapshotId": "50a5701"
| | }
| | }
| | ]
| |
| | },
| | "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": "snapshot_test_table"
| }
| }
| ],
| "liquibase.structure.core.Column": [
| {
| "column": {
| "name": "snapshot_test_column",
| "type": {
| "typeName": "INT64"
| }
| }
| }
| ]
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
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.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
... 1 more
github-actions / Liquibase Test Harness - Advanced Reports
liquibase.ext.bigquery.AdvancedHarnessSuiteIT ► liquibase.harness.snapshot.SnapshotObjectTests ► apply createView against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.AdvancedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-01T16:31:18.719",
| | "database": {
| | "productVersion": "1.5",
| | "shortName": "bigquery",
| | "majorVersion": "1",
| | "minorVersion": "5",
| | "user": "",
| | "productName": "Google BigQuery",
| | "url": "jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=testharnesstests;DefaultDataset=harness_test_ds;OAuthType=3;timeout=3600;"
| | },
| | "objects": {
| | "liquibase.structure.core.Catalog": [
| | {
| | "catalog": {
| | "default": true,
| | "name": "testharnesstests",
| | "snapshotId": "50a5752"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5758",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "COMMENTS",
| | "nullable": true,
| | "order": "9!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5765",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "CONTEXTS",
| | "nullable": true,
| | "order": "12!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5768",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DATEEXECUTED",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5760",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DEPLOYMENT_ID",
| | "nullable": true,
| | "order": "14!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5770",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DESCRIPTION",
| | "nullable": true,
| | "order": "8!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5764",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "EXECTYPE",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5762",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "FILENAME",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5759",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5757",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5771",
| | "snapshotId": "50a5772",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LABELS",
| | "nullable": true,
| | "order": "13!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5769",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LIQUIBASE",
| | "nullable": true,
| | "order": "11!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5767",
| | "type": {
| | "characterOctetLength": "20!{java.lang.Integer}",
| | "columnSize": "20!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKED",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5771",
| | "snapshotId": "50a5773",
| | "type": {
| | "columnSize": "1!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "16!{java.lang.Integer}",
| | "typeName": "BOOLEAN"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKEDBY",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5771",
| | "snapshotId": "50a5775",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKGRANTED",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5771",
| | "snapshotId": "50a5774",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "MD5SUM",
| | "nullable": true,
| | "order": "7!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5763",
| | "type": {
| | "characterOctetLength": "35!{java.lang.Integer}",
| | "columnSize": "35!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ORDEREXECUTED",
| | "nullable": true,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5761",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "TAG",
| | "nullable": true,
| | "order": "10!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5756",
| | "snapshotId": "50a5766",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "added",
| | "nullable": false,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5776",
| | "snapshotId": "50a5782",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "TIMESTAMP"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "author_id",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5785",
| | "snapshotId": "50a5787",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "birthdate",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5776",
| | "snapshotId": "50a5781",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "content",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5785",
| | "snapshotId": "50a5790",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "description",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5785",
| | "snapshotId": "50a5789",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "email",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5776",
| | "snapshotId": "50a5780",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "first_name",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5776",
| | "snapshotId": "50a5778",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5776",
| | "snapshotId": "50a5777",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5785",
| | "snapshotId": "50a5786",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "inserted_date",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5785",
| | "snapshotId": "50a5791",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "last_name",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5776",
| | "snapshotId": "50a5779",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "test_column",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.View#50a5754",
| | "snapshotId": "50a5755",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "test_column",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5783",
| | "snapshotId": "50a5784",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "title",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5785",
| | "snapshotId": "50a5788",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#50a5752",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "50a5753"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5757",
| | "liquibase.structure.core.Column#50a5758",
| | "liquibase.structure.core.Column#50a5759",
| | "liquibase.structure.core.Column#50a5760",
| | "liquibase.structure.core.Column#50a5761",
| | "liquibase.structure.core.Column#50a5762",
| | "liquibase.structure.core.Column#50a5763",
| | "liquibase.structure.core.Column#50a5764",
| | "liquibase.structure.core.Column#50a5765",
| | "liquibase.structure.core.Column#50a5766",
| | "liquibase.structure.core.Column#50a5767",
| | "liquibase.structure.core.Column#50a5768",
| | "liquibase.structure.core.Column#50a5769",
| | "liquibase.structure.core.Column#50a5770"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#50a5753",
| | "snapshotId": "50a5756"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5772",
| | "liquibase.structure.core.Column#50a5773",
| | "liquibase.structure.core.Column#50a5774",
| | "liquibase.structure.core.Column#50a5775"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#50a5753",
| | "snapshotId": "50a5771"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5777",
| | "liquibase.structure.core.Column#50a5778",
| | "liquibase.structure.core.Column#50a5779",
| | "liquibase.structure.core.Column#50a5780",
| | "liquibase.structure.core.Column#50a5781",
| | "liquibase.structure.core.Column#50a5782"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#50a5753",
| | "snapshotId": "50a5776"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5786",
| | "liquibase.structure.core.Column#50a5787",
| | "liquibase.structure.core.Column#50a5788",
| | "liquibase.structure.core.Column#50a5789",
| | "liquibase.structure.core.Column#50a5790",
| | "liquibase.structure.core.Column#50a5791"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#50a5753",
| | "snapshotId": "50a5785"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5784"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "view_table",
| | "schema": "liquibase.structure.core.Schema#50a5753",
| | "snapshotId": "50a5783"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.View": [
| | {
| | "view": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5755"
| | ]
| | ,
| | "definition": "select test_column from view_table",
| | "name": "test_view",
| | "schema": "liquibase.structure.core.Schema#50a5753",
| | "snapshotId": "50a5754"
| | }
| | }
| | ]
| |
| | },
| | "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": "view_table"
| }
| }
| ],
| "liquibase.structure.core.View": [
| {
| "view": {
| "definition": "select test_column from view_table",
| "name": "test_view"
| }
| }
| ]
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
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.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
... 1 more
github-actions / Liquibase Test Harness - Advanced Reports
liquibase.ext.bigquery.AdvancedHarnessSuiteIT ► liquibase.harness.snapshot.SnapshotObjectTests ► apply snapshotCaalogAndSchema against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.AdvancedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-01T16:32:08.097",
| | "database": {
| | "productVersion": "1.5",
| | "shortName": "bigquery",
| | "majorVersion": "1",
| | "minorVersion": "5",
| | "user": "",
| | "productName": "Google BigQuery",
| | "url": "jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=testharnesstests;DefaultDataset=harness_test_ds;OAuthType=3;timeout=3600;"
| | },
| | "objects": {
| | "liquibase.structure.core.Catalog": [
| | {
| | "catalog": {
| | "default": true,
| | "name": "testharnesstests",
| | "snapshotId": "50a5822"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5826",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "COMMENTS",
| | "nullable": true,
| | "order": "9!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5833",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "CONTEXTS",
| | "nullable": true,
| | "order": "12!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5836",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DATEEXECUTED",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5828",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DEPLOYMENT_ID",
| | "nullable": true,
| | "order": "14!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5838",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "DESCRIPTION",
| | "nullable": true,
| | "order": "8!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5832",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "EXECTYPE",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5830",
| | "type": {
| | "characterOctetLength": "10!{java.lang.Integer}",
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "FILENAME",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5827",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5825",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ID",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5841",
| | "snapshotId": "50a5842",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LABELS",
| | "nullable": true,
| | "order": "13!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5837",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LIQUIBASE",
| | "nullable": true,
| | "order": "11!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5835",
| | "type": {
| | "characterOctetLength": "20!{java.lang.Integer}",
| | "columnSize": "20!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKED",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5841",
| | "snapshotId": "50a5843",
| | "type": {
| | "columnSize": "1!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "16!{java.lang.Integer}",
| | "typeName": "BOOLEAN"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKEDBY",
| | "nullable": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5841",
| | "snapshotId": "50a5845",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "LOCKGRANTED",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5841",
| | "snapshotId": "50a5844",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "DATETIME"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "MD5SUM",
| | "nullable": true,
| | "order": "7!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5831",
| | "type": {
| | "characterOctetLength": "35!{java.lang.Integer}",
| | "columnSize": "35!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "ORDEREXECUTED",
| | "nullable": true,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5829",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "TAG",
| | "nullable": true,
| | "order": "10!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5824",
| | "snapshotId": "50a5834",
| | "type": {
| | "characterOctetLength": "255!{java.lang.Integer}",
| | "columnSize": "255!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "added",
| | "nullable": false,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5846",
| | "snapshotId": "50a5852",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "TIMESTAMP"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "author_id",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5853",
| | "snapshotId": "50a5855",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "birthdate",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5846",
| | "snapshotId": "50a5851",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "content",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5853",
| | "snapshotId": "50a5858",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "description",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5853",
| | "snapshotId": "50a5857",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "email",
| | "nullable": false,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5846",
| | "snapshotId": "50a5850",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "first_name",
| | "nullable": false,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5846",
| | "snapshotId": "50a5848",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5846",
| | "snapshotId": "50a5847",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "id",
| | "nullable": false,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5853",
| | "snapshotId": "50a5854",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "inserted_date",
| | "nullable": true,
| | "order": "6!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5853",
| | "snapshotId": "50a5859",
| | "type": {
| | "columnSize": "10!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "91!{java.lang.Integer}",
| | "typeName": "DATE"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "last_name",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5846",
| | "snapshotId": "50a5849",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "snapshot_test_column",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5839",
| | "snapshotId": "50a5840",
| | "type": {
| | "columnSize": "19!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "-5!{java.lang.Integer}",
| | "radix": "10!{java.lang.Integer}",
| | "typeName": "INT64"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "title",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#50a5853",
| | "snapshotId": "50a5856",
| | "type": {
| | "characterOctetLength": "65535!{java.lang.Integer}",
| | "columnSize": "65535!{java.lang.Integer}",
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "12!{java.lang.Integer}",
| | "typeName": "STRING"
| | }
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#50a5822",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "50a5823"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5825",
| | "liquibase.structure.core.Column#50a5826",
| | "liquibase.structure.core.Column#50a5827",
| | "liquibase.structure.core.Column#50a5828",
| | "liquibase.structure.core.Column#50a5829",
| | "liquibase.structure.core.Column#50a5830",
| | "liquibase.structure.core.Column#50a5831",
| | "liquibase.structure.core.Column#50a5832",
| | "liquibase.structure.core.Column#50a5833",
| | "liquibase.structure.core.Column#50a5834",
| | "liquibase.structure.core.Column#50a5835",
| | "liquibase.structure.core.Column#50a5836",
| | "liquibase.structure.core.Column#50a5837",
| | "liquibase.structure.core.Column#50a5838"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#50a5823",
| | "snapshotId": "50a5824"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5842",
| | "liquibase.structure.core.Column#50a5843",
| | "liquibase.structure.core.Column#50a5844",
| | "liquibase.structure.core.Column#50a5845"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#50a5823",
| | "snapshotId": "50a5841"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5847",
| | "liquibase.structure.core.Column#50a5848",
| | "liquibase.structure.core.Column#50a5849",
| | "liquibase.structure.core.Column#50a5850",
| | "liquibase.structure.core.Column#50a5851",
| | "liquibase.structure.core.Column#50a5852"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#50a5823",
| | "snapshotId": "50a5846"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5854",
| | "liquibase.structure.core.Column#50a5855",
| | "liquibase.structure.core.Column#50a5856",
| | "liquibase.structure.core.Column#50a5857",
| | "liquibase.structure.core.Column#50a5858",
| | "liquibase.structure.core.Column#50a5859"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#50a5823",
| | "snapshotId": "50a5853"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#50a5840"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "snapshot_test_table",
| | "schema": "liquibase.structure.core.Schema#50a5823",
| | "snapshotId": "50a5839"
| | }
| | }
| | ]
| |
| | },
| | "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.Catalog": [
| {
| "catalog": {
| "name": "testharnesstests"
| }
| }
| ],
| "liquibase.structure.core.Schema": [
| {
| "schema": {
| "name": "harness_test_ds"
| }
| }
| ]
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
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.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
... 1 more
Loading