[no-jira] added missing jsonAssert #633
GitHub Actions / Liquibase Test Harness - Contributed Reports
succeeded
Aug 5, 2024 in 1s
0 passed, 27 failed and 37 skipped
❌ target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml
64 tests were completed in 1345s with 0 passed, 27 failed and 37 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| liquibase.ext.bigquery.ContributedHarnessSuiteIT | 27❌ | 37⚪ | 1345s |
❌ liquibase.ext.bigquery.ContributedHarnessSuiteIT
liquibase.harness.change.ChangeObjectTests
❌ apply 1initScript against bigquery 1.5
Condition not satisfied:
⚪ apply addAutoIncrement against bigquery 1.5
⚪ apply addCheckConstraint against bigquery 1.5
❌ apply addColumn against bigquery 1.5
Condition failed with Exception:
⚪ apply addDefaultValue against bigquery 1.5
⚪ apply addDefaultValueBoolean against bigquery 1.5
⚪ apply addDefaultValueComputed against bigquery 1.5
⚪ apply addDefaultValueDate against bigquery 1.5
⚪ apply addDefaultValueNumeric against bigquery 1.5
⚪ apply addDefaultValueSequenceNext against bigquery 1.5
❌ apply addForeignKey against bigquery 1.5
java.lang.AssertionError:
❌ apply addLookupTable against bigquery 1.5
Condition failed with Exception:
⚪ apply addNotNullConstraint against bigquery 1.5
❌ apply addPrimaryKey against bigquery 1.5
Condition failed with Exception:
⚪ apply addUniqueConstraint against bigquery 1.5
⚪ apply alterSequence against bigquery 1.5
⚪ apply createFunction against bigquery 1.5
⚪ apply createIndex against bigquery 1.5
⚪ apply createPackage against bigquery 1.5
⚪ apply createPackageBody against bigquery 1.5
⚪ apply createProcedure against bigquery 1.5
⚪ apply createProcedureFromFile against bigquery 1.5
⚪ apply createSequence against bigquery 1.5
❌ apply createTable against bigquery 1.5
Condition failed with Exception:
❌ apply createTableDataTypeText against bigquery 1.5
Condition failed with Exception:
❌ apply createTableTimestamp against bigquery 1.5
Condition failed with Exception:
⚪ apply createTrigger against bigquery 1.5
❌ apply createView against bigquery 1.5
Condition failed with Exception:
⚪ apply disableCheckConstraint against bigquery 1.5
⚪ apply disableTrigger against bigquery 1.5
❌ apply dropAllForeignKeyConstraints against bigquery 1.5
java.lang.AssertionError:
⚪ apply dropCheckConstraint against bigquery 1.5
❌ apply dropColumn against bigquery 1.5
Condition failed with Exception:
⚪ apply dropDefaultValue against bigquery 1.5
❌ apply dropForeignKey against bigquery 1.5
java.lang.AssertionError:
⚪ apply dropFunction against bigquery 1.5
⚪ apply dropIndex against bigquery 1.5
⚪ apply dropNotNullConstraint against bigquery 1.5
❌ apply dropPrimaryKey against bigquery 1.5
Condition failed with Exception:
❌ apply dropProcedure against bigquery 1.5
Condition failed with Exception:
⚪ apply dropSequence against bigquery 1.5
❌ apply dropTable against bigquery 1.5
Condition failed with Exception:
⚪ apply dropTrigger against bigquery 1.5
⚪ apply dropUniqueConstraint against bigquery 1.5
❌ apply dropView against bigquery 1.5
Condition failed with Exception:
⚪ apply enableCheckConstraint against bigquery 1.5
⚪ apply enableTrigger against bigquery 1.5
⚪ apply executeCommand against bigquery 1.5
❌ apply mergeColumns against bigquery 1.5
Condition failed with Exception:
❌ apply modifyDataType against bigquery 1.5
Condition failed with Exception:
❌ apply modifySql against bigquery 1.5
Condition failed with Exception:
❌ apply renameColumn against bigquery 1.5
Condition failed with Exception:
⚪ apply renameSequence against bigquery 1.5
❌ apply renameTable against bigquery 1.5
Condition failed with Exception:
⚪ apply renameTrigger against bigquery 1.5
⚪ apply renameView against bigquery 1.5
⚪ apply setColumnRemarks against bigquery 1.5
⚪ apply setTableRemarks against bigquery 1.5
❌ apply sql against bigquery 1.5
Condition failed with Exception:
❌ apply sqlFile against bigquery 1.5
Condition failed with Exception:
liquibase.harness.data.ChangeDataTests
❌ apply delete against bigquery 1.5
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONCompareMode
❌ apply insert against bigquery 1.5
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONCompareMode
❌ apply loadData against bigquery 1.5
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONCompareMode
❌ apply loadUpdateData against bigquery 1.5
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONCompareMode
Annotations
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.bigquery.ContributedHarnessSuiteIT ► liquibase.harness.change.ChangeObjectTests ► apply 1initScript against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml
Error:
Condition not satisfied:
Raw output
Condition not satisfied:
generatedSql == expectedSql
| | |
| | DROP TABLE IF EXISTS authors
| | CREATE TABLE authors (
| | id INTEGER NOT NULL,
| | first_name STRING NOT NULL,
| | last_name STRING NOT NULL,
| | email STRING NOT NULL,
| | birthdate DATE NOT NULL,
| | added TIMESTAMP NOT NULL
| | )
| | INSERT INTO authors VALUES (1,'Eileen','Lubowitz','[email protected]','1991-03-04','2004-05-30 02:08:25')
| | INSERT INTO authors VALUES (2,'Tamia','Mayert','[email protected]','2016-03-27','2014-03-21 02:52:00')
| | DROP TABLE IF EXISTS posts
| | CREATE TABLE posts (
| | id INTEGER NOT NULL,
| | author_id INTEGER NOT NULL,
| | title STRING NOT NULL,
| | description STRING NOT NULL,
| | content STRING NOT NULL,
| | inserted_date DATE
| | )
| | INSERT INTO posts VALUES (1,1,'temporibus','voluptatum','Fugit non et doloribus repudiandae.','2015-11-18')
| | INSERT INTO posts VALUES (2,2,'ea','aut','Tempora molestias maiores provident molestiae sint possimus quasi.','1975-06-08')
| false
| 31 differences (40% similarity) (comparing subset start: 189, end1: 241, end2: 210)
| MP NOT NULL(,)\n(PRIMARY KEY (id))( NOT ENFORCED)\n()\n)INSERT
| MP NOT NULL(-)\n(---------------))(-------------)\n(--~)INSERT
DROP TABLE IF EXISTS authors
CREATE TABLE authors (
id INTEGER NOT NULL,
first_name STRING NOT NULL,
last_name STRING NOT NULL,
email STRING NOT NULL,
birthdate DATE NOT NULL,
added TIMESTAMP NOT NULL,
PRIMARY KEY (id) NOT ENFORCED
)
INSERT INTO authors VALUES (1,'Eileen','Lubowitz','[email protected]','1991-03-04','2004-05-30 02:08:25')
INSERT INTO authors VALUES (2,'Tamia','Mayert','[email protected]','2016-03-27','2014-03-21 02:52:00')
DROP TABLE IF EXISTS posts
CREATE TABLE posts (
id INTEGER NOT NULL,
author_id INTEGER NOT NULL,
title STRING NOT NULL,
description STRING NOT NULL,
content STRING NOT NULL,
inserted_date DATE
)
INSERT INTO posts VALUES (1,1,'temporibus','voluptatum','Fugit non et doloribus repudiandae.','2015-11-18')
INSERT INTO posts VALUES (2,2,'ea','aut','Tempora molestias maiores provident molestiae sint possimus quasi.','1975-06-08')
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:68)
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.bigquery.ContributedHarnessSuiteIT ► liquibase.harness.change.ChangeObjectTests ► apply addColumn against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-05T14:35:13.068",
| | "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": "613d145"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d147",
| | "snapshotId": "613d149",
| | "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#613d147",
| | "snapshotId": "613d156",
| | "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#613d147",
| | "snapshotId": "613d159",
| | "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#613d147",
| | "snapshotId": "613d151",
| | "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#613d147",
| | "snapshotId": "613d161",
| | "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#613d147",
| | "snapshotId": "613d155",
| | "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#613d147",
| | "snapshotId": "613d153",
| | "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#613d147",
| | "snapshotId": "613d150",
| | "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#613d147",
| | "snapshotId": "613d148",
| | "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#613d162",
| | "snapshotId": "613d163",
| | "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#613d147",
| | "snapshotId": "613d160",
| | "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#613d147",
| | "snapshotId": "613d158",
| | "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#613d162",
| | "snapshotId": "613d164",
| | "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#613d162",
| | "snapshotId": "613d166",
| | "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#613d162",
| | "snapshotId": "613d165",
| | "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#613d147",
| | "snapshotId": "613d154",
| | "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#613d147",
| | "snapshotId": "613d152",
| | "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#613d147",
| | "snapshotId": "613d157",
| | "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#613d167",
| | "snapshotId": "613d173",
| | "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#613d177",
| | "snapshotId": "613d179",
| | "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#613d167",
| | "snapshotId": "613d172",
| | "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#613d177",
| | "snapshotId": "613d182",
| | "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": "9!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d167",
| | "snapshotId": "613d176",
| | "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#613d177",
| | "snapshotId": "613d181",
| | "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#613d167",
| | "snapshotId": "613d171",
| | "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#613d167",
| | "snapshotId": "613d169",
| | "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#613d167",
| | "snapshotId": "613d168",
| | "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#613d177",
| | "snapshotId": "613d178",
| | "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#613d177",
| | "snapshotId": "613d183",
| | "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": "8!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d167",
| | "snapshotId": "613d175",
| | "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#613d167",
| | "snapshotId": "613d170",
| | "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#613d177",
| | "snapshotId": "613d180",
| | "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": "7!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d167",
| | "snapshotId": "613d174",
| | "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#613d145",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "613d146"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d148",
| | "liquibase.structure.core.Column#613d149",
| | "liquibase.structure.core.Column#613d150",
| | "liquibase.structure.core.Column#613d151",
| | "liquibase.structure.core.Column#613d152",
| | "liquibase.structure.core.Column#613d153",
| | "liquibase.structure.core.Column#613d154",
| | "liquibase.structure.core.Column#613d155",
| | "liquibase.structure.core.Column#613d156",
| | "liquibase.structure.core.Column#613d157",
| | "liquibase.structure.core.Column#613d158",
| | "liquibase.structure.core.Column#613d159",
| | "liquibase.structure.core.Column#613d160",
| | "liquibase.structure.core.Column#613d161"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#613d146",
| | "snapshotId": "613d147"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d163",
| | "liquibase.structure.core.Column#613d164",
| | "liquibase.structure.core.Column#613d165",
| | "liquibase.structure.core.Column#613d166"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#613d146",
| | "snapshotId": "613d162"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d168",
| | "liquibase.structure.core.Column#613d169",
| | "liquibase.structure.core.Column#613d170",
| | "liquibase.structure.core.Column#613d171",
| | "liquibase.structure.core.Column#613d172",
| | "liquibase.structure.core.Column#613d173",
| | "liquibase.structure.core.Column#613d174",
| | "liquibase.structure.core.Column#613d175",
| | "liquibase.structure.core.Column#613d176"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#613d146",
| | "snapshotId": "613d167"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d178",
| | "liquibase.structure.core.Column#613d179",
| | "liquibase.structure.core.Column#613d180",
| | "liquibase.structure.core.Column#613d181",
| | "liquibase.structure.core.Column#613d182",
| | "liquibase.structure.core.Column#613d183"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#613d146",
| | "snapshotId": "613d177"
| | }
| | }
| | ]
| |
| | },
| | "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": "authors"
| }
| }
| ],
| "liquibase.structure.core.Column": [
| {
| "column": {
| "name": "varcharColumn"
| }
| },
| {
| "column": {
| "name": "intColumn"
| }
| },
| {
| "column": {
| "name": "dateColumn"
| }
| }
| ]
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
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.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
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 - Contributed Reports
liquibase.ext.bigquery.ContributedHarnessSuiteIT ► liquibase.harness.change.ChangeObjectTests ► apply addForeignKey against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml
Error:
java.lang.AssertionError:
Raw output
java.lang.AssertionError:
liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset liquibase/harness/change/changelogs/bigquery/addForeignKey.xml::1::oleh:
Reason: liquibase.exception.DatabaseException: [Simba][BigQueryJDBCDriver](100032) Error executing query job. Message: Table harness_test_ds.authors does not have Primary Key constraints [Failed SQL: (100032) ALTER TABLE harness_test_ds.posts ADD CONSTRAINT fk_posts_authors_test FOREIGN KEY (author_id) REFERENCES harness_test_ds.authors (id) NOT ENFORCED]
at org.junit.Assert.fail(Assert.java:89)
at liquibase.harness.util.TestUtils.executeCommandScope(TestUtils.groovy:65)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:76)
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.bigquery.ContributedHarnessSuiteIT ► liquibase.harness.change.ChangeObjectTests ► apply addLookupTable against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-05T14:36:49.397",
| | "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": "613d274"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d276",
| | "snapshotId": "613d278",
| | "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#613d276",
| | "snapshotId": "613d285",
| | "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#613d276",
| | "snapshotId": "613d288",
| | "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#613d276",
| | "snapshotId": "613d280",
| | "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#613d276",
| | "snapshotId": "613d290",
| | "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#613d276",
| | "snapshotId": "613d284",
| | "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#613d276",
| | "snapshotId": "613d282",
| | "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#613d276",
| | "snapshotId": "613d279",
| | "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#613d276",
| | "snapshotId": "613d277",
| | "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#613d291",
| | "snapshotId": "613d292",
| | "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#613d276",
| | "snapshotId": "613d289",
| | "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#613d276",
| | "snapshotId": "613d287",
| | "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#613d291",
| | "snapshotId": "613d293",
| | "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#613d291",
| | "snapshotId": "613d295",
| | "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#613d291",
| | "snapshotId": "613d294",
| | "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#613d276",
| | "snapshotId": "613d283",
| | "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#613d276",
| | "snapshotId": "613d281",
| | "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#613d276",
| | "snapshotId": "613d286",
| | "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#613d296",
| | "snapshotId": "613d302",
| | "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#613d307",
| | "snapshotId": "613d309",
| | "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": "authors_email",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d305",
| | "snapshotId": "613d304",
| | "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": "birthdate",
| | "nullable": false,
| | "order": "5!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d296",
| | "snapshotId": "613d301",
| | "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#613d307",
| | "snapshotId": "613d312",
| | "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#613d307",
| | "snapshotId": "613d311",
| | "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#613d296",
| | "snapshotId": "613d300",
| | "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#613d296",
| | "snapshotId": "613d298",
| | "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#613d296",
| | "snapshotId": "613d297",
| | "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#613d307",
| | "snapshotId": "613d308",
| | "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#613d307",
| | "snapshotId": "613d313",
| | "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#613d296",
| | "snapshotId": "613d299",
| | "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#613d307",
| | "snapshotId": "613d310",
| | "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.ForeignKey": [
| | {
| | "foreignKey": {
| | "foreignKeyColumns": [
| | "liquibase.structure.core.Column#613d300"
| | ]
| | ,
| | "foreignKeyTable": "liquibase.structure.core.Table#613d296",
| | "name": "FK_AUTHORS_AUTHORS_DATA",
| | "primaryKeyColumns": [
| | "liquibase.structure.core.Column#613d304"
| | ]
| | ,
| | "primaryKeyTable": "liquibase.structure.core.Table#613d305",
| | "snapshotId": "613d303"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.PrimaryKey": [
| | {
| | "primaryKey": {
| | "columns": [
| | "liquibase.structure.core.Column#613d304"
| | ]
| | ,
| | "name": "authors_data.pk$",
| | "snapshotId": "613d306",
| | "table": "liquibase.structure.core.Table#613d305"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#613d274",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "613d275"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d277",
| | "liquibase.structure.core.Column#613d278",
| | "liquibase.structure.core.Column#613d279",
| | "liquibase.structure.core.Column#613d280",
| | "liquibase.structure.core.Column#613d281",
| | "liquibase.structure.core.Column#613d282",
| | "liquibase.structure.core.Column#613d283",
| | "liquibase.structure.core.Column#613d284",
| | "liquibase.structure.core.Column#613d285",
| | "liquibase.structure.core.Column#613d286",
| | "liquibase.structure.core.Column#613d287",
| | "liquibase.structure.core.Column#613d288",
| | "liquibase.structure.core.Column#613d289",
| | "liquibase.structure.core.Column#613d290"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#613d275",
| | "snapshotId": "613d276"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d292",
| | "liquibase.structure.core.Column#613d293",
| | "liquibase.structure.core.Column#613d294",
| | "liquibase.structure.core.Column#613d295"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#613d275",
| | "snapshotId": "613d291"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d297",
| | "liquibase.structure.core.Column#613d298",
| | "liquibase.structure.core.Column#613d299",
| | "liquibase.structure.core.Column#613d300",
| | "liquibase.structure.core.Column#613d301",
| | "liquibase.structure.core.Column#613d302"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "outgoingForeignKeys": [
| | "liquibase.structure.core.ForeignKey#613d303"
| | ]
| | ,
| | "schema": "liquibase.structure.core.Schema#613d275",
| | "snapshotId": "613d296"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d304"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors_data",
| | "primaryKey": "liquibase.structure.core.PrimaryKey#613d306",
| | "schema": "liquibase.structure.core.Schema#613d275",
| | "snapshotId": "613d305"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d308",
| | "liquibase.structure.core.Column#613d309",
| | "liquibase.structure.core.Column#613d310",
| | "liquibase.structure.core.Column#613d311",
| | "liquibase.structure.core.Column#613d312",
| | "liquibase.structure.core.Column#613d313"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#613d275",
| | "snapshotId": "613d307"
| | }
| | }
| | ]
| |
| | },
| | "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": "authors_data"
| }
| }
| ],
| "liquibase.structure.core.Column": [
| {
| "column": {
| "name": "authors_email"
| }
| }
| ]
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
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 - Contributed Reports
liquibase.ext.bigquery.ContributedHarnessSuiteIT ► liquibase.harness.change.ChangeObjectTests ► apply addPrimaryKey against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-05T14:37:47.737",
| | "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": "613d359"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d361",
| | "snapshotId": "613d363",
| | "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#613d361",
| | "snapshotId": "613d370",
| | "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#613d361",
| | "snapshotId": "613d373",
| | "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#613d361",
| | "snapshotId": "613d365",
| | "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#613d361",
| | "snapshotId": "613d375",
| | "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#613d361",
| | "snapshotId": "613d369",
| | "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#613d361",
| | "snapshotId": "613d367",
| | "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#613d361",
| | "snapshotId": "613d364",
| | "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#613d361",
| | "snapshotId": "613d362",
| | "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#613d376",
| | "snapshotId": "613d377",
| | "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#613d361",
| | "snapshotId": "613d374",
| | "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#613d361",
| | "snapshotId": "613d372",
| | "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#613d376",
| | "snapshotId": "613d378",
| | "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#613d376",
| | "snapshotId": "613d380",
| | "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#613d376",
| | "snapshotId": "613d379",
| | "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#613d361",
| | "snapshotId": "613d368",
| | "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#613d361",
| | "snapshotId": "613d366",
| | "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#613d361",
| | "snapshotId": "613d371",
| | "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#613d381",
| | "snapshotId": "613d387",
| | "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#613d388",
| | "snapshotId": "613d390",
| | "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#613d381",
| | "snapshotId": "613d386",
| | "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#613d388",
| | "snapshotId": "613d393",
| | "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#613d388",
| | "snapshotId": "613d392",
| | "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#613d381",
| | "snapshotId": "613d385",
| | "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#613d381",
| | "snapshotId": "613d383",
| | "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#613d381",
| | "snapshotId": "613d382",
| | "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#613d388",
| | "snapshotId": "613d389",
| | "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#613d388",
| | "snapshotId": "613d394",
| | "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#613d381",
| | "snapshotId": "613d384",
| | "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#613d388",
| | "snapshotId": "613d391",
| | "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#613d389"
| | ]
| | ,
| | "name": "posts.pk$",
| | "snapshotId": "613d395",
| | "table": "liquibase.structure.core.Table#613d388"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#613d359",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "613d360"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d362",
| | "liquibase.structure.core.Column#613d363",
| | "liquibase.structure.core.Column#613d364",
| | "liquibase.structure.core.Column#613d365",
| | "liquibase.structure.core.Column#613d366",
| | "liquibase.structure.core.Column#613d367",
| | "liquibase.structure.core.Column#613d368",
| | "liquibase.structure.core.Column#613d369",
| | "liquibase.structure.core.Column#613d370",
| | "liquibase.structure.core.Column#613d371",
| | "liquibase.structure.core.Column#613d372",
| | "liquibase.structure.core.Column#613d373",
| | "liquibase.structure.core.Column#613d374",
| | "liquibase.structure.core.Column#613d375"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#613d360",
| | "snapshotId": "613d361"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d377",
| | "liquibase.structure.core.Column#613d378",
| | "liquibase.structure.core.Column#613d379",
| | "liquibase.structure.core.Column#613d380"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#613d360",
| | "snapshotId": "613d376"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d382",
| | "liquibase.structure.core.Column#613d383",
| | "liquibase.structure.core.Column#613d384",
| | "liquibase.structure.core.Column#613d385",
| | "liquibase.structure.core.Column#613d386",
| | "liquibase.structure.core.Column#613d387"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#613d360",
| | "snapshotId": "613d381"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d389",
| | "liquibase.structure.core.Column#613d390",
| | "liquibase.structure.core.Column#613d391",
| | "liquibase.structure.core.Column#613d392",
| | "liquibase.structure.core.Column#613d393",
| | "liquibase.structure.core.Column#613d394"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "primaryKey": "liquibase.structure.core.PrimaryKey#613d395",
| | "schema": "liquibase.structure.core.Schema#613d360",
| | "snapshotId": "613d388"
| | }
| | }
| | ]
| |
| | },
| | "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": "posts",
| "primaryKey": "liquibase.structure.core.PrimaryKey.*"
| }
| }
| ]
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
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 - Contributed Reports
liquibase.ext.bigquery.ContributedHarnessSuiteIT ► liquibase.harness.change.ChangeObjectTests ► apply createTable against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-05T14:38:47.136",
| | "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": "613d441"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d456",
| | "snapshotId": "613d458",
| | "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#613d456",
| | "snapshotId": "613d465",
| | "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#613d456",
| | "snapshotId": "613d468",
| | "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#613d456",
| | "snapshotId": "613d460",
| | "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#613d456",
| | "snapshotId": "613d470",
| | "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#613d456",
| | "snapshotId": "613d464",
| | "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#613d456",
| | "snapshotId": "613d462",
| | "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#613d456",
| | "snapshotId": "613d459",
| | "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#613d456",
| | "snapshotId": "613d457",
| | "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#613d471",
| | "snapshotId": "613d472",
| | "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#613d456",
| | "snapshotId": "613d469",
| | "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#613d456",
| | "snapshotId": "613d467",
| | "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#613d471",
| | "snapshotId": "613d473",
| | "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#613d471",
| | "snapshotId": "613d475",
| | "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#613d471",
| | "snapshotId": "613d474",
| | "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#613d456",
| | "snapshotId": "613d463",
| | "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#613d456",
| | "snapshotId": "613d461",
| | "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#613d456",
| | "snapshotId": "613d466",
| | "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#613d448",
| | "snapshotId": "613d453",
| | "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#613d476",
| | "snapshotId": "613d478",
| | "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#613d448",
| | "snapshotId": "613d452",
| | "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#613d476",
| | "snapshotId": "613d481",
| | "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#613d476",
| | "snapshotId": "613d480",
| | "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#613d448",
| | "snapshotId": "613d451",
| | "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#613d448",
| | "snapshotId": "613d449",
| | "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#613d448",
| | "snapshotId": "613d447",
| | "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#613d476",
| | "snapshotId": "613d477",
| | "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#613d476",
| | "snapshotId": "613d482",
| | "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#613d448",
| | "snapshotId": "613d450",
| | "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_FK_column",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d443",
| | "snapshotId": "613d445",
| | "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_id",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d443",
| | "snapshotId": "613d444",
| | "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#613d476",
| | "snapshotId": "613d479",
| | "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.ForeignKey": [
| | {
| | "foreignKey": {
| | "foreignKeyColumns": [
| | "liquibase.structure.core.Column#613d445"
| | ]
| | ,
| | "foreignKeyTable": "liquibase.structure.core.Table#613d443",
| | "name": "fk_test",
| | "primaryKeyColumns": [
| | "liquibase.structure.core.Column#613d447"
| | ]
| | ,
| | "primaryKeyTable": "liquibase.structure.core.Table#613d448",
| | "snapshotId": "613d446"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.PrimaryKey": [
| | {
| | "primaryKey": {
| | "columns": [
| | "liquibase.structure.core.Column#613d447"
| | ]
| | ,
| | "name": "authors.pk$",
| | "snapshotId": "613d454",
| | "table": "liquibase.structure.core.Table#613d448"
| | }
| | },
| | {
| | "primaryKey": {
| | "columns": [
| | "liquibase.structure.core.Column#613d444"
| | ]
| | ,
| | "name": "test_table.pk$",
| | "snapshotId": "613d455",
| | "table": "liquibase.structure.core.Table#613d443"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#613d441",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "613d442"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d457",
| | "liquibase.structure.core.Column#613d458",
| | "liquibase.structure.core.Column#613d459",
| | "liquibase.structure.core.Column#613d460",
| | "liquibase.structure.core.Column#613d461",
| | "liquibase.structure.core.Column#613d462",
| | "liquibase.structure.core.Column#613d463",
| | "liquibase.structure.core.Column#613d464",
| | "liquibase.structure.core.Column#613d465",
| | "liquibase.structure.core.Column#613d466",
| | "liquibase.structure.core.Column#613d467",
| | "liquibase.structure.core.Column#613d468",
| | "liquibase.structure.core.Column#613d469",
| | "liquibase.structure.core.Column#613d470"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#613d442",
| | "snapshotId": "613d456"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d472",
| | "liquibase.structure.core.Column#613d473",
| | "liquibase.structure.core.Column#613d474",
| | "liquibase.structure.core.Column#613d475"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#613d442",
| | "snapshotId": "613d471"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d447",
| | "liquibase.structure.core.Column#613d449",
| | "liquibase.structure.core.Column#613d450",
| | "liquibase.structure.core.Column#613d451",
| | "liquibase.structure.core.Column#613d452",
| | "liquibase.structure.core.Column#613d453"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "primaryKey": "liquibase.structure.core.PrimaryKey#613d454",
| | "schema": "liquibase.structure.core.Schema#613d442",
| | "snapshotId": "613d448"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d477",
| | "liquibase.structure.core.Column#613d478",
| | "liquibase.structure.core.Column#613d479",
| | "liquibase.structure.core.Column#613d480",
| | "liquibase.structure.core.Column#613d481",
| | "liquibase.structure.core.Column#613d482"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#613d442",
| | "snapshotId": "613d476"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d444",
| | "liquibase.structure.core.Column#613d445"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "test_table",
| | "outgoingForeignKeys": [
| | "liquibase.structure.core.ForeignKey#613d446"
| | ]
| | ,
| | "primaryKey": "liquibase.structure.core.PrimaryKey#613d455",
| | "schema": "liquibase.structure.core.Schema#613d442",
| | "snapshotId": "613d443"
| | }
| | }
| | ]
| |
| | },
| | "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_id"
| }
| },
| {
| "column": {
| "name": "test_FK_column"
| }
| }
| ],
| "liquibase.structure.core.ForeignKey": [
| {
| "foreignKey": {
| "name": "fk_test"
| }
| }
| ]
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
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 - Contributed Reports
liquibase.ext.bigquery.ContributedHarnessSuiteIT ► liquibase.harness.change.ChangeObjectTests ► apply createTableDataTypeText against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-05T14:39:42.307",
| | "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": "613d528"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d530",
| | "snapshotId": "613d532",
| | "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#613d530",
| | "snapshotId": "613d539",
| | "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#613d530",
| | "snapshotId": "613d542",
| | "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#613d530",
| | "snapshotId": "613d534",
| | "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#613d530",
| | "snapshotId": "613d544",
| | "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#613d530",
| | "snapshotId": "613d538",
| | "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#613d530",
| | "snapshotId": "613d536",
| | "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#613d530",
| | "snapshotId": "613d533",
| | "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#613d530",
| | "snapshotId": "613d531",
| | "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#613d547",
| | "snapshotId": "613d548",
| | "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#613d530",
| | "snapshotId": "613d543",
| | "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#613d530",
| | "snapshotId": "613d541",
| | "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#613d547",
| | "snapshotId": "613d549",
| | "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#613d547",
| | "snapshotId": "613d551",
| | "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#613d547",
| | "snapshotId": "613d550",
| | "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#613d530",
| | "snapshotId": "613d537",
| | "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#613d530",
| | "snapshotId": "613d535",
| | "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#613d530",
| | "snapshotId": "613d540",
| | "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#613d552",
| | "snapshotId": "613d558",
| | "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#613d559",
| | "snapshotId": "613d561",
| | "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#613d552",
| | "snapshotId": "613d557",
| | "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#613d559",
| | "snapshotId": "613d564",
| | "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#613d559",
| | "snapshotId": "613d563",
| | "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#613d552",
| | "snapshotId": "613d556",
| | "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#613d552",
| | "snapshotId": "613d554",
| | "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#613d552",
| | "snapshotId": "613d553",
| | "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#613d559",
| | "snapshotId": "613d560",
| | "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#613d559",
| | "snapshotId": "613d565",
| | "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#613d552",
| | "snapshotId": "613d555",
| | "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": "textCol",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d545",
| | "snapshotId": "613d546",
| | "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#613d559",
| | "snapshotId": "613d562",
| | "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#613d528",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "613d529"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d531",
| | "liquibase.structure.core.Column#613d532",
| | "liquibase.structure.core.Column#613d533",
| | "liquibase.structure.core.Column#613d534",
| | "liquibase.structure.core.Column#613d535",
| | "liquibase.structure.core.Column#613d536",
| | "liquibase.structure.core.Column#613d537",
| | "liquibase.structure.core.Column#613d538",
| | "liquibase.structure.core.Column#613d539",
| | "liquibase.structure.core.Column#613d540",
| | "liquibase.structure.core.Column#613d541",
| | "liquibase.structure.core.Column#613d542",
| | "liquibase.structure.core.Column#613d543",
| | "liquibase.structure.core.Column#613d544"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#613d529",
| | "snapshotId": "613d530"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d548",
| | "liquibase.structure.core.Column#613d549",
| | "liquibase.structure.core.Column#613d550",
| | "liquibase.structure.core.Column#613d551"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#613d529",
| | "snapshotId": "613d547"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d553",
| | "liquibase.structure.core.Column#613d554",
| | "liquibase.structure.core.Column#613d555",
| | "liquibase.structure.core.Column#613d556",
| | "liquibase.structure.core.Column#613d557",
| | "liquibase.structure.core.Column#613d558"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#613d529",
| | "snapshotId": "613d552"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d546"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "createTableDataTypeText",
| | "schema": "liquibase.structure.core.Schema#613d529",
| | "snapshotId": "613d545"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d560",
| | "liquibase.structure.core.Column#613d561",
| | "liquibase.structure.core.Column#613d562",
| | "liquibase.structure.core.Column#613d563",
| | "liquibase.structure.core.Column#613d564",
| | "liquibase.structure.core.Column#613d565"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#613d529",
| | "snapshotId": "613d559"
| | }
| | }
| | ]
| |
| | },
| | "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": "createTableDataTypeText"
| }
| }
| ],
| "liquibase.structure.core.Column": [
| {
| "column": {
| "name": "textCol"
| }
| }
| ]
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
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 - Contributed Reports
liquibase.ext.bigquery.ContributedHarnessSuiteIT ► liquibase.harness.change.ChangeObjectTests ► apply createTableTimestamp against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-05T14:40:34.66",
| | "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": "613d611"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d613",
| | "snapshotId": "613d615",
| | "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#613d613",
| | "snapshotId": "613d622",
| | "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#613d613",
| | "snapshotId": "613d625",
| | "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#613d613",
| | "snapshotId": "613d617",
| | "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#613d613",
| | "snapshotId": "613d627",
| | "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#613d613",
| | "snapshotId": "613d621",
| | "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#613d613",
| | "snapshotId": "613d619",
| | "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#613d613",
| | "snapshotId": "613d616",
| | "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#613d613",
| | "snapshotId": "613d614",
| | "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#613d628",
| | "snapshotId": "613d629",
| | "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#613d613",
| | "snapshotId": "613d626",
| | "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#613d613",
| | "snapshotId": "613d624",
| | "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#613d628",
| | "snapshotId": "613d630",
| | "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#613d628",
| | "snapshotId": "613d632",
| | "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#613d628",
| | "snapshotId": "613d631",
| | "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#613d613",
| | "snapshotId": "613d620",
| | "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#613d613",
| | "snapshotId": "613d618",
| | "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#613d613",
| | "snapshotId": "613d623",
| | "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#613d633",
| | "snapshotId": "613d639",
| | "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#613d643",
| | "snapshotId": "613d645",
| | "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#613d633",
| | "snapshotId": "613d638",
| | "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#613d643",
| | "snapshotId": "613d648",
| | "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#613d643",
| | "snapshotId": "613d647",
| | "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#613d633",
| | "snapshotId": "613d637",
| | "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#613d633",
| | "snapshotId": "613d635",
| | "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#613d633",
| | "snapshotId": "613d634",
| | "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#613d643",
| | "snapshotId": "613d644",
| | "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#613d643",
| | "snapshotId": "613d649",
| | "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#613d633",
| | "snapshotId": "613d636",
| | "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": "lms_test_id",
| | "nullable": true,
| | "order": "1!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d640",
| | "snapshotId": "613d641",
| | "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": "lms_test_timestamp",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d640",
| | "snapshotId": "613d642",
| | "type": {
| | "columnSizeUnit": "BYTE!{liquibase.structure.core.DataType$ColumnSizeUnit}",
| | "dataTypeId": "93!{java.lang.Integer}",
| | "typeName": "TIMESTAMP"
| | }
| | }
| | },
| | {
| | "column": {
| | "name": "title",
| | "nullable": false,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d643",
| | "snapshotId": "613d646",
| | "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#613d611",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "613d612"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d614",
| | "liquibase.structure.core.Column#613d615",
| | "liquibase.structure.core.Column#613d616",
| | "liquibase.structure.core.Column#613d617",
| | "liquibase.structure.core.Column#613d618",
| | "liquibase.structure.core.Column#613d619",
| | "liquibase.structure.core.Column#613d620",
| | "liquibase.structure.core.Column#613d621",
| | "liquibase.structure.core.Column#613d622",
| | "liquibase.structure.core.Column#613d623",
| | "liquibase.structure.core.Column#613d624",
| | "liquibase.structure.core.Column#613d625",
| | "liquibase.structure.core.Column#613d626",
| | "liquibase.structure.core.Column#613d627"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#613d612",
| | "snapshotId": "613d613"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d629",
| | "liquibase.structure.core.Column#613d630",
| | "liquibase.structure.core.Column#613d631",
| | "liquibase.structure.core.Column#613d632"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#613d612",
| | "snapshotId": "613d628"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d634",
| | "liquibase.structure.core.Column#613d635",
| | "liquibase.structure.core.Column#613d636",
| | "liquibase.structure.core.Column#613d637",
| | "liquibase.structure.core.Column#613d638",
| | "liquibase.structure.core.Column#613d639"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#613d612",
| | "snapshotId": "613d633"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d641",
| | "liquibase.structure.core.Column#613d642"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "lms_create_table_test",
| | "schema": "liquibase.structure.core.Schema#613d612",
| | "snapshotId": "613d640"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d644",
| | "liquibase.structure.core.Column#613d645",
| | "liquibase.structure.core.Column#613d646",
| | "liquibase.structure.core.Column#613d647",
| | "liquibase.structure.core.Column#613d648",
| | "liquibase.structure.core.Column#613d649"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#613d612",
| | "snapshotId": "613d643"
| | }
| | }
| | ]
| |
| | },
| | "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": "lms_create_table_test"
| }
| }
| ],
| "liquibase.structure.core.Column": [
| {
| "column": {
| "name": "lms_test_id"
| }
| },
| {
| "column": {
| "name": "lms_test_timestamp",
| "type": {
| "typeName": "timestamp"
| }
| }
| }
| ]
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
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 - Contributed Reports
liquibase.ext.bigquery.ContributedHarnessSuiteIT ► liquibase.harness.change.ChangeObjectTests ► apply createView against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-05T14:41:23.486",
| | "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": "613d695"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d702",
| | "snapshotId": "613d704",
| | "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#613d702",
| | "snapshotId": "613d711",
| | "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#613d702",
| | "snapshotId": "613d714",
| | "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#613d702",
| | "snapshotId": "613d706",
| | "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#613d702",
| | "snapshotId": "613d716",
| | "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#613d702",
| | "snapshotId": "613d710",
| | "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#613d702",
| | "snapshotId": "613d708",
| | "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#613d702",
| | "snapshotId": "613d705",
| | "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#613d702",
| | "snapshotId": "613d703",
| | "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#613d717",
| | "snapshotId": "613d718",
| | "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#613d702",
| | "snapshotId": "613d715",
| | "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#613d702",
| | "snapshotId": "613d713",
| | "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#613d717",
| | "snapshotId": "613d719",
| | "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#613d717",
| | "snapshotId": "613d721",
| | "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#613d717",
| | "snapshotId": "613d720",
| | "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#613d702",
| | "snapshotId": "613d709",
| | "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#613d702",
| | "snapshotId": "613d707",
| | "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#613d702",
| | "snapshotId": "613d712",
| | "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#613d722",
| | "snapshotId": "613d728",
| | "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#613d729",
| | "snapshotId": "613d731",
| | "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#613d722",
| | "snapshotId": "613d727",
| | "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#613d729",
| | "snapshotId": "613d734",
| | "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#613d729",
| | "snapshotId": "613d733",
| | "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#613d722",
| | "snapshotId": "613d726",
| | "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": true,
| | "order": "4!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.View#613d697",
| | "snapshotId": "613d701",
| | "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#613d722",
| | "snapshotId": "613d724",
| | "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": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.View#613d697",
| | "snapshotId": "613d699",
| | "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#613d722",
| | "snapshotId": "613d723",
| | "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#613d729",
| | "snapshotId": "613d730",
| | "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.View#613d697",
| | "snapshotId": "613d698",
| | "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#613d729",
| | "snapshotId": "613d735",
| | "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#613d722",
| | "snapshotId": "613d725",
| | "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": "last_name",
| | "nullable": true,
| | "order": "3!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.View#613d697",
| | "snapshotId": "613d700",
| | "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#613d729",
| | "snapshotId": "613d732",
| | "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#613d695",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "613d696"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d703",
| | "liquibase.structure.core.Column#613d704",
| | "liquibase.structure.core.Column#613d705",
| | "liquibase.structure.core.Column#613d706",
| | "liquibase.structure.core.Column#613d707",
| | "liquibase.structure.core.Column#613d708",
| | "liquibase.structure.core.Column#613d709",
| | "liquibase.structure.core.Column#613d710",
| | "liquibase.structure.core.Column#613d711",
| | "liquibase.structure.core.Column#613d712",
| | "liquibase.structure.core.Column#613d713",
| | "liquibase.structure.core.Column#613d714",
| | "liquibase.structure.core.Column#613d715",
| | "liquibase.structure.core.Column#613d716"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#613d696",
| | "snapshotId": "613d702"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d718",
| | "liquibase.structure.core.Column#613d719",
| | "liquibase.structure.core.Column#613d720",
| | "liquibase.structure.core.Column#613d721"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#613d696",
| | "snapshotId": "613d717"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d723",
| | "liquibase.structure.core.Column#613d724",
| | "liquibase.structure.core.Column#613d725",
| | "liquibase.structure.core.Column#613d726",
| | "liquibase.structure.core.Column#613d727",
| | "liquibase.structure.core.Column#613d728"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#613d696",
| | "snapshotId": "613d722"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d730",
| | "liquibase.structure.core.Column#613d731",
| | "liquibase.structure.core.Column#613d732",
| | "liquibase.structure.core.Column#613d733",
| | "liquibase.structure.core.Column#613d734",
| | "liquibase.structure.core.Column#613d735"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#613d696",
| | "snapshotId": "613d729"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.View": [
| | {
| | "view": {
| | "columns": [
| | "liquibase.structure.core.Column#613d698",
| | "liquibase.structure.core.Column#613d699",
| | "liquibase.structure.core.Column#613d700",
| | "liquibase.structure.core.Column#613d701"
| | ]
| | ,
| | "definition": "select id, first_name, last_name, email from authors",
| | "name": "test_view",
| | "schema": "liquibase.structure.core.Schema#613d696",
| | "snapshotId": "613d697"
| | }
| | }
| | ]
| |
| | },
| | "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.View": [
| {
| "view": {
| "definition": "SELECT id, first_name, last_name, email FROM authors",
| "name": "test_view"
| }
| }]
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
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 - Contributed Reports
liquibase.ext.bigquery.ContributedHarnessSuiteIT ► liquibase.harness.change.ChangeObjectTests ► apply dropAllForeignKeyConstraints against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml
Error:
java.lang.AssertionError:
Raw output
java.lang.AssertionError:
liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset liquibase/harness/change/changelogs/bigquery/dropAllForeignKeyConstraints.xml::1::oleh:
Reason: liquibase.exception.DatabaseException: [Simba][BigQueryJDBCDriver](100032) Error executing query job. Message: Table harness_test_ds.authors does not have Primary Key constraints [Failed SQL: (100032) ALTER TABLE harness_test_ds.posts ADD CONSTRAINT fk_posts_authors_test FOREIGN KEY (author_id) REFERENCES harness_test_ds.authors (id) NOT ENFORCED]
at org.junit.Assert.fail(Assert.java:89)
at liquibase.harness.util.TestUtils.executeCommandScope(TestUtils.groovy:65)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:76)
github-actions / Liquibase Test Harness - Contributed Reports
liquibase.ext.bigquery.ContributedHarnessSuiteIT ► liquibase.harness.change.ChangeObjectTests ► apply dropColumn against bigquery 1.5
Failed test found in:
target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml
Error:
Condition failed with Exception:
Raw output
Condition failed with Exception:
snapshotMatchesSpecifiedStructure(expectedSnapshot, generatedSnapshot)
| | |
| | {
| | "snapshot": {
| | "created": "2024-08-05T14:42:45.029",
| | "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": "613d828"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#613d830",
| | "snapshotId": "613d832",
| | "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#613d830",
| | "snapshotId": "613d839",
| | "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#613d830",
| | "snapshotId": "613d842",
| | "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#613d830",
| | "snapshotId": "613d834",
| | "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#613d830",
| | "snapshotId": "613d844",
| | "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#613d830",
| | "snapshotId": "613d838",
| | "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#613d830",
| | "snapshotId": "613d836",
| | "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#613d830",
| | "snapshotId": "613d833",
| | "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#613d830",
| | "snapshotId": "613d831",
| | "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#613d845",
| | "snapshotId": "613d846",
| | "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#613d830",
| | "snapshotId": "613d843",
| | "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#613d830",
| | "snapshotId": "613d841",
| | "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#613d845",
| | "snapshotId": "613d847",
| | "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#613d845",
| | "snapshotId": "613d849",
| | "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#613d845",
| | "snapshotId": "613d848",
| | "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#613d830",
| | "snapshotId": "613d837",
| | "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#613d830",
| | "snapshotId": "613d835",
| | "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#613d830",
| | "snapshotId": "613d840",
| | "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#613d850",
| | "snapshotId": "613d856",
| | "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#613d857",
| | "snapshotId": "613d859",
| | "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#613d850",
| | "snapshotId": "613d855",
| | "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#613d857",
| | "snapshotId": "613d862",
| | "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#613d857",
| | "snapshotId": "613d861",
| | "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#613d850",
| | "snapshotId": "613d854",
| | "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#613d850",
| | "snapshotId": "613d852",
| | "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#613d850",
| | "snapshotId": "613d851",
| | "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#613d857",
| | "snapshotId": "613d858",
| | "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#613d857",
| | "snapshotId": "613d863",
| | "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#613d850",
| | "snapshotId": "613d853",
| | "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#613d857",
| | "snapshotId": "613d860",
| | "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#613d828",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "613d829"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d831",
| | "liquibase.structure.core.Column#613d832",
| | "liquibase.structure.core.Column#613d833",
| | "liquibase.structure.core.Column#613d834",
| | "liquibase.structure.core.Column#613d835",
| | "liquibase.structure.core.Column#613d836",
| | "liquibase.structure.core.Column#613d837",
| | "liquibase.structure.core.Column#613d838",
| | "liquibase.structure.core.Column#613d839",
| | "liquibase.structure.core.Column#613d840",
| | "liquibase.structure.core.Column#613d841",
| | "liquibase.structure.core.Column#613d842",
| | "liquibase.structure.core.Column#613d843",
| | "liquibase.structure.core.Column#613d844"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#613d829",
| | "snapshotId": "613d830"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d846",
| | "liquibase.structure.core.Column#613d847",
| | "liquibase.structure.core.Column#613d848",
| | "liquibase.structure.core.Column#613d849"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#613d829",
| | "snapshotId": "613d845"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d851",
| | "liquibase.structure.core.Column#613d852",
| | "liquibase.structure.core.Column#613d853",
| | "liquibase.structure.core.Column#613d854",
| | "liquibase.structure.core.Column#613d855",
| | "liquibase.structure.core.Column#613d856"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#613d829",
| | "snapshotId": "613d850"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#613d858",
| | "liquibase.structure.core.Column#613d859",
| | "liquibase.structure.core.Column#613d860",
| | "liquibase.structure.core.Column#613d861",
| | "liquibase.structure.core.Column#613d862",
| | "liquibase.structure.core.Column#613d863"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#613d829",
| | "snapshotId": "613d857"
| | }
| | }
| | ]
| |
| | },
| | "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": {
| "_noMatch": true,
| "liquibase.structure.core.Column": [
| {
| "column": {
| "name": "varcharColumn"
| }
| }
| ]
| }
| }
| }
java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
at liquibase.harness.change.ChangeObjectTests.apply #testInput.changeObject against #testInput.databaseName #testInput.version(ChangeObjectTests.groovy:80)
Caused by: java.lang.NoClassDefFoundError: org/skyscreamer/jsonassert/JSONAssert
at liquibase.harness.util.SnapshotHelpers.snapshotMatchesSpecifiedStructure(SnapshotHelpers.groovy:22)
... 1 more
Loading