Bump org.liquibase:liquibase-maven-plugin from 4.28.0 to 4.29.1 #627
GitHub Actions / Liquibase Test Harness - Contributed Reports
succeeded
Jul 31, 2024 in 0s
0 passed, 27 failed and 37 skipped
❌ target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml
64 tests were completed in 1454s with 0 passed, 27 failed and 37 skipped.
| Test suite | Passed | Failed | Skipped | Time |
|---|---|---|---|---|
| liquibase.ext.bigquery.ContributedHarnessSuiteIT | 27❌ | 37⚪ | 1454s |
❌ 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-07-31T20:24:29.452",
| | "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": "5314145"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#5314147",
| | "snapshotId": "5314149",
| | "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#5314147",
| | "snapshotId": "5314156",
| | "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#5314147",
| | "snapshotId": "5314159",
| | "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#5314147",
| | "snapshotId": "5314151",
| | "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#5314147",
| | "snapshotId": "5314161",
| | "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#5314147",
| | "snapshotId": "5314155",
| | "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#5314147",
| | "snapshotId": "5314153",
| | "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#5314147",
| | "snapshotId": "5314150",
| | "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#5314147",
| | "snapshotId": "5314148",
| | "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#5314162",
| | "snapshotId": "5314163",
| | "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#5314147",
| | "snapshotId": "5314160",
| | "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#5314147",
| | "snapshotId": "5314158",
| | "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#5314162",
| | "snapshotId": "5314164",
| | "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#5314162",
| | "snapshotId": "5314166",
| | "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#5314162",
| | "snapshotId": "5314165",
| | "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#5314147",
| | "snapshotId": "5314154",
| | "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#5314147",
| | "snapshotId": "5314152",
| | "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#5314147",
| | "snapshotId": "5314157",
| | "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#5314167",
| | "snapshotId": "5314173",
| | "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#5314177",
| | "snapshotId": "5314179",
| | "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#5314167",
| | "snapshotId": "5314172",
| | "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#5314177",
| | "snapshotId": "5314182",
| | "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#5314167",
| | "snapshotId": "5314176",
| | "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#5314177",
| | "snapshotId": "5314181",
| | "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#5314167",
| | "snapshotId": "5314171",
| | "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#5314167",
| | "snapshotId": "5314169",
| | "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#5314167",
| | "snapshotId": "5314168",
| | "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#5314177",
| | "snapshotId": "5314178",
| | "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#5314177",
| | "snapshotId": "5314183",
| | "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#5314167",
| | "snapshotId": "5314175",
| | "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#5314167",
| | "snapshotId": "5314170",
| | "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#5314177",
| | "snapshotId": "5314180",
| | "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#5314167",
| | "snapshotId": "5314174",
| | "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#5314145",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "5314146"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314148",
| | "liquibase.structure.core.Column#5314149",
| | "liquibase.structure.core.Column#5314150",
| | "liquibase.structure.core.Column#5314151",
| | "liquibase.structure.core.Column#5314152",
| | "liquibase.structure.core.Column#5314153",
| | "liquibase.structure.core.Column#5314154",
| | "liquibase.structure.core.Column#5314155",
| | "liquibase.structure.core.Column#5314156",
| | "liquibase.structure.core.Column#5314157",
| | "liquibase.structure.core.Column#5314158",
| | "liquibase.structure.core.Column#5314159",
| | "liquibase.structure.core.Column#5314160",
| | "liquibase.structure.core.Column#5314161"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#5314146",
| | "snapshotId": "5314147"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314163",
| | "liquibase.structure.core.Column#5314164",
| | "liquibase.structure.core.Column#5314165",
| | "liquibase.structure.core.Column#5314166"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#5314146",
| | "snapshotId": "5314162"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314168",
| | "liquibase.structure.core.Column#5314169",
| | "liquibase.structure.core.Column#5314170",
| | "liquibase.structure.core.Column#5314171",
| | "liquibase.structure.core.Column#5314172",
| | "liquibase.structure.core.Column#5314173",
| | "liquibase.structure.core.Column#5314174",
| | "liquibase.structure.core.Column#5314175",
| | "liquibase.structure.core.Column#5314176"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#5314146",
| | "snapshotId": "5314167"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314178",
| | "liquibase.structure.core.Column#5314179",
| | "liquibase.structure.core.Column#5314180",
| | "liquibase.structure.core.Column#5314181",
| | "liquibase.structure.core.Column#5314182",
| | "liquibase.structure.core.Column#5314183"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#5314146",
| | "snapshotId": "5314177"
| | }
| | }
| | ]
| |
| | },
| | "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-07-31T20:26:11.714",
| | "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": "5314274"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#5314276",
| | "snapshotId": "5314278",
| | "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#5314276",
| | "snapshotId": "5314285",
| | "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#5314276",
| | "snapshotId": "5314288",
| | "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#5314276",
| | "snapshotId": "5314280",
| | "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#5314276",
| | "snapshotId": "5314290",
| | "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#5314276",
| | "snapshotId": "5314284",
| | "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#5314276",
| | "snapshotId": "5314282",
| | "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#5314276",
| | "snapshotId": "5314279",
| | "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#5314276",
| | "snapshotId": "5314277",
| | "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#5314291",
| | "snapshotId": "5314292",
| | "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#5314276",
| | "snapshotId": "5314289",
| | "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#5314276",
| | "snapshotId": "5314287",
| | "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#5314291",
| | "snapshotId": "5314293",
| | "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#5314291",
| | "snapshotId": "5314295",
| | "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#5314291",
| | "snapshotId": "5314294",
| | "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#5314276",
| | "snapshotId": "5314283",
| | "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#5314276",
| | "snapshotId": "5314281",
| | "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#5314276",
| | "snapshotId": "5314286",
| | "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#5314296",
| | "snapshotId": "5314302",
| | "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#5314307",
| | "snapshotId": "5314309",
| | "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#5314305",
| | "snapshotId": "5314304",
| | "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#5314296",
| | "snapshotId": "5314301",
| | "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#5314307",
| | "snapshotId": "5314312",
| | "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#5314307",
| | "snapshotId": "5314311",
| | "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#5314296",
| | "snapshotId": "5314300",
| | "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#5314296",
| | "snapshotId": "5314298",
| | "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#5314296",
| | "snapshotId": "5314297",
| | "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#5314307",
| | "snapshotId": "5314308",
| | "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#5314307",
| | "snapshotId": "5314313",
| | "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#5314296",
| | "snapshotId": "5314299",
| | "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#5314307",
| | "snapshotId": "5314310",
| | "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#5314300"
| | ]
| | ,
| | "foreignKeyTable": "liquibase.structure.core.Table#5314296",
| | "name": "FK_AUTHORS_AUTHORS_DATA",
| | "primaryKeyColumns": [
| | "liquibase.structure.core.Column#5314304"
| | ]
| | ,
| | "primaryKeyTable": "liquibase.structure.core.Table#5314305",
| | "snapshotId": "5314303"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.PrimaryKey": [
| | {
| | "primaryKey": {
| | "columns": [
| | "liquibase.structure.core.Column#5314304"
| | ]
| | ,
| | "name": "authors_data.pk$",
| | "snapshotId": "5314306",
| | "table": "liquibase.structure.core.Table#5314305"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#5314274",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "5314275"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314277",
| | "liquibase.structure.core.Column#5314278",
| | "liquibase.structure.core.Column#5314279",
| | "liquibase.structure.core.Column#5314280",
| | "liquibase.structure.core.Column#5314281",
| | "liquibase.structure.core.Column#5314282",
| | "liquibase.structure.core.Column#5314283",
| | "liquibase.structure.core.Column#5314284",
| | "liquibase.structure.core.Column#5314285",
| | "liquibase.structure.core.Column#5314286",
| | "liquibase.structure.core.Column#5314287",
| | "liquibase.structure.core.Column#5314288",
| | "liquibase.structure.core.Column#5314289",
| | "liquibase.structure.core.Column#5314290"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#5314275",
| | "snapshotId": "5314276"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314292",
| | "liquibase.structure.core.Column#5314293",
| | "liquibase.structure.core.Column#5314294",
| | "liquibase.structure.core.Column#5314295"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#5314275",
| | "snapshotId": "5314291"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314297",
| | "liquibase.structure.core.Column#5314298",
| | "liquibase.structure.core.Column#5314299",
| | "liquibase.structure.core.Column#5314300",
| | "liquibase.structure.core.Column#5314301",
| | "liquibase.structure.core.Column#5314302"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "outgoingForeignKeys": [
| | "liquibase.structure.core.ForeignKey#5314303"
| | ]
| | ,
| | "schema": "liquibase.structure.core.Schema#5314275",
| | "snapshotId": "5314296"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314304"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors_data",
| | "primaryKey": "liquibase.structure.core.PrimaryKey#5314306",
| | "schema": "liquibase.structure.core.Schema#5314275",
| | "snapshotId": "5314305"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314308",
| | "liquibase.structure.core.Column#5314309",
| | "liquibase.structure.core.Column#5314310",
| | "liquibase.structure.core.Column#5314311",
| | "liquibase.structure.core.Column#5314312",
| | "liquibase.structure.core.Column#5314313"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#5314275",
| | "snapshotId": "5314307"
| | }
| | }
| | ]
| |
| | },
| | "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-07-31T20:27:09.485",
| | "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": "5314359"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#5314361",
| | "snapshotId": "5314363",
| | "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#5314361",
| | "snapshotId": "5314370",
| | "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#5314361",
| | "snapshotId": "5314373",
| | "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#5314361",
| | "snapshotId": "5314365",
| | "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#5314361",
| | "snapshotId": "5314375",
| | "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#5314361",
| | "snapshotId": "5314369",
| | "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#5314361",
| | "snapshotId": "5314367",
| | "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#5314361",
| | "snapshotId": "5314364",
| | "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#5314361",
| | "snapshotId": "5314362",
| | "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#5314376",
| | "snapshotId": "5314377",
| | "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#5314361",
| | "snapshotId": "5314374",
| | "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#5314361",
| | "snapshotId": "5314372",
| | "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#5314376",
| | "snapshotId": "5314378",
| | "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#5314376",
| | "snapshotId": "5314380",
| | "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#5314376",
| | "snapshotId": "5314379",
| | "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#5314361",
| | "snapshotId": "5314368",
| | "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#5314361",
| | "snapshotId": "5314366",
| | "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#5314361",
| | "snapshotId": "5314371",
| | "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#5314381",
| | "snapshotId": "5314387",
| | "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#5314388",
| | "snapshotId": "5314390",
| | "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#5314381",
| | "snapshotId": "5314386",
| | "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#5314388",
| | "snapshotId": "5314393",
| | "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#5314388",
| | "snapshotId": "5314392",
| | "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#5314381",
| | "snapshotId": "5314385",
| | "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#5314381",
| | "snapshotId": "5314383",
| | "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#5314381",
| | "snapshotId": "5314382",
| | "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#5314388",
| | "snapshotId": "5314389",
| | "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#5314388",
| | "snapshotId": "5314394",
| | "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#5314381",
| | "snapshotId": "5314384",
| | "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#5314388",
| | "snapshotId": "5314391",
| | "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#5314389"
| | ]
| | ,
| | "name": "posts.pk$",
| | "snapshotId": "5314395",
| | "table": "liquibase.structure.core.Table#5314388"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#5314359",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "5314360"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314362",
| | "liquibase.structure.core.Column#5314363",
| | "liquibase.structure.core.Column#5314364",
| | "liquibase.structure.core.Column#5314365",
| | "liquibase.structure.core.Column#5314366",
| | "liquibase.structure.core.Column#5314367",
| | "liquibase.structure.core.Column#5314368",
| | "liquibase.structure.core.Column#5314369",
| | "liquibase.structure.core.Column#5314370",
| | "liquibase.structure.core.Column#5314371",
| | "liquibase.structure.core.Column#5314372",
| | "liquibase.structure.core.Column#5314373",
| | "liquibase.structure.core.Column#5314374",
| | "liquibase.structure.core.Column#5314375"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#5314360",
| | "snapshotId": "5314361"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314377",
| | "liquibase.structure.core.Column#5314378",
| | "liquibase.structure.core.Column#5314379",
| | "liquibase.structure.core.Column#5314380"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#5314360",
| | "snapshotId": "5314376"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314382",
| | "liquibase.structure.core.Column#5314383",
| | "liquibase.structure.core.Column#5314384",
| | "liquibase.structure.core.Column#5314385",
| | "liquibase.structure.core.Column#5314386",
| | "liquibase.structure.core.Column#5314387"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#5314360",
| | "snapshotId": "5314381"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314389",
| | "liquibase.structure.core.Column#5314390",
| | "liquibase.structure.core.Column#5314391",
| | "liquibase.structure.core.Column#5314392",
| | "liquibase.structure.core.Column#5314393",
| | "liquibase.structure.core.Column#5314394"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "primaryKey": "liquibase.structure.core.PrimaryKey#5314395",
| | "schema": "liquibase.structure.core.Schema#5314360",
| | "snapshotId": "5314388"
| | }
| | }
| | ]
| |
| | },
| | "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-07-31T20:28:12.95",
| | "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": "5314441"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#5314456",
| | "snapshotId": "5314458",
| | "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#5314456",
| | "snapshotId": "5314465",
| | "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#5314456",
| | "snapshotId": "5314468",
| | "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#5314456",
| | "snapshotId": "5314460",
| | "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#5314456",
| | "snapshotId": "5314470",
| | "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#5314456",
| | "snapshotId": "5314464",
| | "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#5314456",
| | "snapshotId": "5314462",
| | "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#5314456",
| | "snapshotId": "5314459",
| | "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#5314456",
| | "snapshotId": "5314457",
| | "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#5314471",
| | "snapshotId": "5314472",
| | "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#5314456",
| | "snapshotId": "5314469",
| | "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#5314456",
| | "snapshotId": "5314467",
| | "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#5314471",
| | "snapshotId": "5314473",
| | "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#5314471",
| | "snapshotId": "5314475",
| | "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#5314471",
| | "snapshotId": "5314474",
| | "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#5314456",
| | "snapshotId": "5314463",
| | "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#5314456",
| | "snapshotId": "5314461",
| | "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#5314456",
| | "snapshotId": "5314466",
| | "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#5314448",
| | "snapshotId": "5314453",
| | "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#5314476",
| | "snapshotId": "5314478",
| | "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#5314448",
| | "snapshotId": "5314452",
| | "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#5314476",
| | "snapshotId": "5314481",
| | "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#5314476",
| | "snapshotId": "5314480",
| | "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#5314448",
| | "snapshotId": "5314451",
| | "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#5314448",
| | "snapshotId": "5314449",
| | "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#5314448",
| | "snapshotId": "5314447",
| | "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#5314476",
| | "snapshotId": "5314477",
| | "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#5314476",
| | "snapshotId": "5314482",
| | "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#5314448",
| | "snapshotId": "5314450",
| | "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#5314443",
| | "snapshotId": "5314445",
| | "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#5314443",
| | "snapshotId": "5314444",
| | "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#5314476",
| | "snapshotId": "5314479",
| | "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#5314445"
| | ]
| | ,
| | "foreignKeyTable": "liquibase.structure.core.Table#5314443",
| | "name": "fk_test",
| | "primaryKeyColumns": [
| | "liquibase.structure.core.Column#5314447"
| | ]
| | ,
| | "primaryKeyTable": "liquibase.structure.core.Table#5314448",
| | "snapshotId": "5314446"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.PrimaryKey": [
| | {
| | "primaryKey": {
| | "columns": [
| | "liquibase.structure.core.Column#5314447"
| | ]
| | ,
| | "name": "authors.pk$",
| | "snapshotId": "5314454",
| | "table": "liquibase.structure.core.Table#5314448"
| | }
| | },
| | {
| | "primaryKey": {
| | "columns": [
| | "liquibase.structure.core.Column#5314444"
| | ]
| | ,
| | "name": "test_table.pk$",
| | "snapshotId": "5314455",
| | "table": "liquibase.structure.core.Table#5314443"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Schema": [
| | {
| | "schema": {
| | "catalog": "liquibase.structure.core.Catalog#5314441",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "5314442"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314457",
| | "liquibase.structure.core.Column#5314458",
| | "liquibase.structure.core.Column#5314459",
| | "liquibase.structure.core.Column#5314460",
| | "liquibase.structure.core.Column#5314461",
| | "liquibase.structure.core.Column#5314462",
| | "liquibase.structure.core.Column#5314463",
| | "liquibase.structure.core.Column#5314464",
| | "liquibase.structure.core.Column#5314465",
| | "liquibase.structure.core.Column#5314466",
| | "liquibase.structure.core.Column#5314467",
| | "liquibase.structure.core.Column#5314468",
| | "liquibase.structure.core.Column#5314469",
| | "liquibase.structure.core.Column#5314470"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#5314442",
| | "snapshotId": "5314456"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314472",
| | "liquibase.structure.core.Column#5314473",
| | "liquibase.structure.core.Column#5314474",
| | "liquibase.structure.core.Column#5314475"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#5314442",
| | "snapshotId": "5314471"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314447",
| | "liquibase.structure.core.Column#5314449",
| | "liquibase.structure.core.Column#5314450",
| | "liquibase.structure.core.Column#5314451",
| | "liquibase.structure.core.Column#5314452",
| | "liquibase.structure.core.Column#5314453"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "primaryKey": "liquibase.structure.core.PrimaryKey#5314454",
| | "schema": "liquibase.structure.core.Schema#5314442",
| | "snapshotId": "5314448"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314477",
| | "liquibase.structure.core.Column#5314478",
| | "liquibase.structure.core.Column#5314479",
| | "liquibase.structure.core.Column#5314480",
| | "liquibase.structure.core.Column#5314481",
| | "liquibase.structure.core.Column#5314482"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#5314442",
| | "snapshotId": "5314476"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314444",
| | "liquibase.structure.core.Column#5314445"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "test_table",
| | "outgoingForeignKeys": [
| | "liquibase.structure.core.ForeignKey#5314446"
| | ]
| | ,
| | "primaryKey": "liquibase.structure.core.PrimaryKey#5314455",
| | "schema": "liquibase.structure.core.Schema#5314442",
| | "snapshotId": "5314443"
| | }
| | }
| | ]
| |
| | },
| | "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-07-31T20:29:12.823",
| | "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": "5314528"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#5314530",
| | "snapshotId": "5314532",
| | "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#5314530",
| | "snapshotId": "5314539",
| | "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#5314530",
| | "snapshotId": "5314542",
| | "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#5314530",
| | "snapshotId": "5314534",
| | "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#5314530",
| | "snapshotId": "5314544",
| | "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#5314530",
| | "snapshotId": "5314538",
| | "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#5314530",
| | "snapshotId": "5314536",
| | "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#5314530",
| | "snapshotId": "5314533",
| | "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#5314530",
| | "snapshotId": "5314531",
| | "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#5314547",
| | "snapshotId": "5314548",
| | "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#5314530",
| | "snapshotId": "5314543",
| | "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#5314530",
| | "snapshotId": "5314541",
| | "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#5314547",
| | "snapshotId": "5314549",
| | "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#5314547",
| | "snapshotId": "5314551",
| | "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#5314547",
| | "snapshotId": "5314550",
| | "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#5314530",
| | "snapshotId": "5314537",
| | "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#5314530",
| | "snapshotId": "5314535",
| | "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#5314530",
| | "snapshotId": "5314540",
| | "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#5314552",
| | "snapshotId": "5314558",
| | "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#5314559",
| | "snapshotId": "5314561",
| | "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#5314552",
| | "snapshotId": "5314557",
| | "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#5314559",
| | "snapshotId": "5314564",
| | "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#5314559",
| | "snapshotId": "5314563",
| | "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#5314552",
| | "snapshotId": "5314556",
| | "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#5314552",
| | "snapshotId": "5314554",
| | "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#5314552",
| | "snapshotId": "5314553",
| | "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#5314559",
| | "snapshotId": "5314560",
| | "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#5314559",
| | "snapshotId": "5314565",
| | "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#5314552",
| | "snapshotId": "5314555",
| | "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#5314545",
| | "snapshotId": "5314546",
| | "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#5314559",
| | "snapshotId": "5314562",
| | "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#5314528",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "5314529"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314531",
| | "liquibase.structure.core.Column#5314532",
| | "liquibase.structure.core.Column#5314533",
| | "liquibase.structure.core.Column#5314534",
| | "liquibase.structure.core.Column#5314535",
| | "liquibase.structure.core.Column#5314536",
| | "liquibase.structure.core.Column#5314537",
| | "liquibase.structure.core.Column#5314538",
| | "liquibase.structure.core.Column#5314539",
| | "liquibase.structure.core.Column#5314540",
| | "liquibase.structure.core.Column#5314541",
| | "liquibase.structure.core.Column#5314542",
| | "liquibase.structure.core.Column#5314543",
| | "liquibase.structure.core.Column#5314544"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#5314529",
| | "snapshotId": "5314530"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314548",
| | "liquibase.structure.core.Column#5314549",
| | "liquibase.structure.core.Column#5314550",
| | "liquibase.structure.core.Column#5314551"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#5314529",
| | "snapshotId": "5314547"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314553",
| | "liquibase.structure.core.Column#5314554",
| | "liquibase.structure.core.Column#5314555",
| | "liquibase.structure.core.Column#5314556",
| | "liquibase.structure.core.Column#5314557",
| | "liquibase.structure.core.Column#5314558"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#5314529",
| | "snapshotId": "5314552"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314546"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "createTableDataTypeText",
| | "schema": "liquibase.structure.core.Schema#5314529",
| | "snapshotId": "5314545"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314560",
| | "liquibase.structure.core.Column#5314561",
| | "liquibase.structure.core.Column#5314562",
| | "liquibase.structure.core.Column#5314563",
| | "liquibase.structure.core.Column#5314564",
| | "liquibase.structure.core.Column#5314565"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#5314529",
| | "snapshotId": "5314559"
| | }
| | }
| | ]
| |
| | },
| | "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-07-31T20:30:11.466",
| | "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": "5314611"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#5314613",
| | "snapshotId": "5314615",
| | "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#5314613",
| | "snapshotId": "5314622",
| | "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#5314613",
| | "snapshotId": "5314625",
| | "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#5314613",
| | "snapshotId": "5314617",
| | "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#5314613",
| | "snapshotId": "5314627",
| | "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#5314613",
| | "snapshotId": "5314621",
| | "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#5314613",
| | "snapshotId": "5314619",
| | "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#5314613",
| | "snapshotId": "5314616",
| | "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#5314613",
| | "snapshotId": "5314614",
| | "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#5314628",
| | "snapshotId": "5314629",
| | "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#5314613",
| | "snapshotId": "5314626",
| | "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#5314613",
| | "snapshotId": "5314624",
| | "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#5314628",
| | "snapshotId": "5314630",
| | "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#5314628",
| | "snapshotId": "5314632",
| | "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#5314628",
| | "snapshotId": "5314631",
| | "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#5314613",
| | "snapshotId": "5314620",
| | "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#5314613",
| | "snapshotId": "5314618",
| | "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#5314613",
| | "snapshotId": "5314623",
| | "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#5314633",
| | "snapshotId": "5314639",
| | "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#5314643",
| | "snapshotId": "5314645",
| | "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#5314633",
| | "snapshotId": "5314638",
| | "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#5314643",
| | "snapshotId": "5314648",
| | "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#5314643",
| | "snapshotId": "5314647",
| | "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#5314633",
| | "snapshotId": "5314637",
| | "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#5314633",
| | "snapshotId": "5314635",
| | "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#5314633",
| | "snapshotId": "5314634",
| | "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#5314643",
| | "snapshotId": "5314644",
| | "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#5314643",
| | "snapshotId": "5314649",
| | "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#5314633",
| | "snapshotId": "5314636",
| | "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#5314640",
| | "snapshotId": "5314641",
| | "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#5314640",
| | "snapshotId": "5314642",
| | "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#5314643",
| | "snapshotId": "5314646",
| | "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#5314611",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "5314612"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314614",
| | "liquibase.structure.core.Column#5314615",
| | "liquibase.structure.core.Column#5314616",
| | "liquibase.structure.core.Column#5314617",
| | "liquibase.structure.core.Column#5314618",
| | "liquibase.structure.core.Column#5314619",
| | "liquibase.structure.core.Column#5314620",
| | "liquibase.structure.core.Column#5314621",
| | "liquibase.structure.core.Column#5314622",
| | "liquibase.structure.core.Column#5314623",
| | "liquibase.structure.core.Column#5314624",
| | "liquibase.structure.core.Column#5314625",
| | "liquibase.structure.core.Column#5314626",
| | "liquibase.structure.core.Column#5314627"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#5314612",
| | "snapshotId": "5314613"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314629",
| | "liquibase.structure.core.Column#5314630",
| | "liquibase.structure.core.Column#5314631",
| | "liquibase.structure.core.Column#5314632"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#5314612",
| | "snapshotId": "5314628"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314634",
| | "liquibase.structure.core.Column#5314635",
| | "liquibase.structure.core.Column#5314636",
| | "liquibase.structure.core.Column#5314637",
| | "liquibase.structure.core.Column#5314638",
| | "liquibase.structure.core.Column#5314639"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#5314612",
| | "snapshotId": "5314633"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314641",
| | "liquibase.structure.core.Column#5314642"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "lms_create_table_test",
| | "schema": "liquibase.structure.core.Schema#5314612",
| | "snapshotId": "5314640"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314644",
| | "liquibase.structure.core.Column#5314645",
| | "liquibase.structure.core.Column#5314646",
| | "liquibase.structure.core.Column#5314647",
| | "liquibase.structure.core.Column#5314648",
| | "liquibase.structure.core.Column#5314649"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#5314612",
| | "snapshotId": "5314643"
| | }
| | }
| | ]
| |
| | },
| | "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-07-31T20:31:06.753",
| | "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": "5314695"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#5314702",
| | "snapshotId": "5314704",
| | "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#5314702",
| | "snapshotId": "5314711",
| | "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#5314702",
| | "snapshotId": "5314714",
| | "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#5314702",
| | "snapshotId": "5314706",
| | "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#5314702",
| | "snapshotId": "5314716",
| | "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#5314702",
| | "snapshotId": "5314710",
| | "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#5314702",
| | "snapshotId": "5314708",
| | "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#5314702",
| | "snapshotId": "5314705",
| | "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#5314702",
| | "snapshotId": "5314703",
| | "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#5314717",
| | "snapshotId": "5314718",
| | "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#5314702",
| | "snapshotId": "5314715",
| | "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#5314702",
| | "snapshotId": "5314713",
| | "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#5314717",
| | "snapshotId": "5314719",
| | "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#5314717",
| | "snapshotId": "5314721",
| | "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#5314717",
| | "snapshotId": "5314720",
| | "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#5314702",
| | "snapshotId": "5314709",
| | "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#5314702",
| | "snapshotId": "5314707",
| | "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#5314702",
| | "snapshotId": "5314712",
| | "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#5314722",
| | "snapshotId": "5314728",
| | "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#5314729",
| | "snapshotId": "5314731",
| | "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#5314722",
| | "snapshotId": "5314727",
| | "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#5314729",
| | "snapshotId": "5314734",
| | "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#5314729",
| | "snapshotId": "5314733",
| | "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#5314722",
| | "snapshotId": "5314726",
| | "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#5314697",
| | "snapshotId": "5314701",
| | "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#5314722",
| | "snapshotId": "5314724",
| | "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#5314697",
| | "snapshotId": "5314699",
| | "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#5314722",
| | "snapshotId": "5314723",
| | "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#5314729",
| | "snapshotId": "5314730",
| | "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#5314697",
| | "snapshotId": "5314698",
| | "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#5314729",
| | "snapshotId": "5314735",
| | "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#5314722",
| | "snapshotId": "5314725",
| | "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#5314697",
| | "snapshotId": "5314700",
| | "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#5314729",
| | "snapshotId": "5314732",
| | "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#5314695",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "5314696"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314703",
| | "liquibase.structure.core.Column#5314704",
| | "liquibase.structure.core.Column#5314705",
| | "liquibase.structure.core.Column#5314706",
| | "liquibase.structure.core.Column#5314707",
| | "liquibase.structure.core.Column#5314708",
| | "liquibase.structure.core.Column#5314709",
| | "liquibase.structure.core.Column#5314710",
| | "liquibase.structure.core.Column#5314711",
| | "liquibase.structure.core.Column#5314712",
| | "liquibase.structure.core.Column#5314713",
| | "liquibase.structure.core.Column#5314714",
| | "liquibase.structure.core.Column#5314715",
| | "liquibase.structure.core.Column#5314716"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#5314696",
| | "snapshotId": "5314702"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314718",
| | "liquibase.structure.core.Column#5314719",
| | "liquibase.structure.core.Column#5314720",
| | "liquibase.structure.core.Column#5314721"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#5314696",
| | "snapshotId": "5314717"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314723",
| | "liquibase.structure.core.Column#5314724",
| | "liquibase.structure.core.Column#5314725",
| | "liquibase.structure.core.Column#5314726",
| | "liquibase.structure.core.Column#5314727",
| | "liquibase.structure.core.Column#5314728"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#5314696",
| | "snapshotId": "5314722"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314730",
| | "liquibase.structure.core.Column#5314731",
| | "liquibase.structure.core.Column#5314732",
| | "liquibase.structure.core.Column#5314733",
| | "liquibase.structure.core.Column#5314734",
| | "liquibase.structure.core.Column#5314735"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#5314696",
| | "snapshotId": "5314729"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.View": [
| | {
| | "view": {
| | "columns": [
| | "liquibase.structure.core.Column#5314698",
| | "liquibase.structure.core.Column#5314699",
| | "liquibase.structure.core.Column#5314700",
| | "liquibase.structure.core.Column#5314701"
| | ]
| | ,
| | "definition": "select id, first_name, last_name, email from authors",
| | "name": "test_view",
| | "schema": "liquibase.structure.core.Schema#5314696",
| | "snapshotId": "5314697"
| | }
| | }
| | ]
| |
| | },
| | "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-07-31T20:32:40.29",
| | "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": "5314828"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Column": [
| | {
| | "column": {
| | "name": "AUTHOR",
| | "nullable": true,
| | "order": "2!{java.lang.Integer}",
| | "relation": "liquibase.structure.core.Table#5314830",
| | "snapshotId": "5314832",
| | "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#5314830",
| | "snapshotId": "5314839",
| | "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#5314830",
| | "snapshotId": "5314842",
| | "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#5314830",
| | "snapshotId": "5314834",
| | "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#5314830",
| | "snapshotId": "5314844",
| | "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#5314830",
| | "snapshotId": "5314838",
| | "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#5314830",
| | "snapshotId": "5314836",
| | "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#5314830",
| | "snapshotId": "5314833",
| | "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#5314830",
| | "snapshotId": "5314831",
| | "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#5314845",
| | "snapshotId": "5314846",
| | "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#5314830",
| | "snapshotId": "5314843",
| | "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#5314830",
| | "snapshotId": "5314841",
| | "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#5314845",
| | "snapshotId": "5314847",
| | "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#5314845",
| | "snapshotId": "5314849",
| | "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#5314845",
| | "snapshotId": "5314848",
| | "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#5314830",
| | "snapshotId": "5314837",
| | "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#5314830",
| | "snapshotId": "5314835",
| | "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#5314830",
| | "snapshotId": "5314840",
| | "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#5314850",
| | "snapshotId": "5314856",
| | "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#5314857",
| | "snapshotId": "5314859",
| | "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#5314850",
| | "snapshotId": "5314855",
| | "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#5314857",
| | "snapshotId": "5314862",
| | "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#5314857",
| | "snapshotId": "5314861",
| | "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#5314850",
| | "snapshotId": "5314854",
| | "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#5314850",
| | "snapshotId": "5314852",
| | "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#5314850",
| | "snapshotId": "5314851",
| | "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#5314857",
| | "snapshotId": "5314858",
| | "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#5314857",
| | "snapshotId": "5314863",
| | "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#5314850",
| | "snapshotId": "5314853",
| | "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#5314857",
| | "snapshotId": "5314860",
| | "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#5314828",
| | "default": true,
| | "name": "harness_test_ds",
| | "snapshotId": "5314829"
| | }
| | }
| | ]
| | ,
| | "liquibase.structure.core.Table": [
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314831",
| | "liquibase.structure.core.Column#5314832",
| | "liquibase.structure.core.Column#5314833",
| | "liquibase.structure.core.Column#5314834",
| | "liquibase.structure.core.Column#5314835",
| | "liquibase.structure.core.Column#5314836",
| | "liquibase.structure.core.Column#5314837",
| | "liquibase.structure.core.Column#5314838",
| | "liquibase.structure.core.Column#5314839",
| | "liquibase.structure.core.Column#5314840",
| | "liquibase.structure.core.Column#5314841",
| | "liquibase.structure.core.Column#5314842",
| | "liquibase.structure.core.Column#5314843",
| | "liquibase.structure.core.Column#5314844"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOG",
| | "schema": "liquibase.structure.core.Schema#5314829",
| | "snapshotId": "5314830"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314846",
| | "liquibase.structure.core.Column#5314847",
| | "liquibase.structure.core.Column#5314848",
| | "liquibase.structure.core.Column#5314849"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "DATABASECHANGELOGLOCK",
| | "schema": "liquibase.structure.core.Schema#5314829",
| | "snapshotId": "5314845"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314851",
| | "liquibase.structure.core.Column#5314852",
| | "liquibase.structure.core.Column#5314853",
| | "liquibase.structure.core.Column#5314854",
| | "liquibase.structure.core.Column#5314855",
| | "liquibase.structure.core.Column#5314856"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "authors",
| | "schema": "liquibase.structure.core.Schema#5314829",
| | "snapshotId": "5314850"
| | }
| | },
| | {
| | "table": {
| | "columns": [
| | "liquibase.structure.core.Column#5314858",
| | "liquibase.structure.core.Column#5314859",
| | "liquibase.structure.core.Column#5314860",
| | "liquibase.structure.core.Column#5314861",
| | "liquibase.structure.core.Column#5314862",
| | "liquibase.structure.core.Column#5314863"
| | ]
| | ,
| | "default_tablespace": false,
| | "name": "posts",
| | "schema": "liquibase.structure.core.Schema#5314829",
| | "snapshotId": "5314857"
| | }
| | }
| | ]
| |
| | },
| | "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