Skip to content
Liquibase Test Harness for BigQuery

[no-jira] added missing jsonAssert #636

Sign in to view logs

[no-jira] added missing jsonAssert

[no-jira] added missing jsonAssert #636

GitHub Actions / Liquibase Test Harness - Contributed Reports succeeded Aug 6, 2024 in 0s

23 passed, 4 failed and 37 skipped

Tests failed

❌ target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml

64 tests were completed in 1361s with 23 passed, 4 failed and 37 skipped.

Test suite Passed Failed Skipped Time
liquibase.ext.bigquery.ContributedHarnessSuiteIT 23✅ 4❌ 37⚪ 1361s

❌ 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
  ⚪ 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
  ⚪ apply addNotNullConstraint against bigquery 1.5
  ✅ apply addPrimaryKey against bigquery 1.5
  ⚪ 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
  ✅ apply createTableDataTypeText against bigquery 1.5
  ✅ apply createTableTimestamp against bigquery 1.5
  ⚪ apply createTrigger against bigquery 1.5
  ✅ apply createView against bigquery 1.5
  ⚪ 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
  ⚪ 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
  ✅ apply dropProcedure against bigquery 1.5
  ⚪ apply dropSequence against bigquery 1.5
  ✅ apply dropTable against bigquery 1.5
  ⚪ apply dropTrigger against bigquery 1.5
  ⚪ apply dropUniqueConstraint against bigquery 1.5
  ✅ apply dropView against bigquery 1.5
  ⚪ apply enableCheckConstraint against bigquery 1.5
  ⚪ apply enableTrigger against bigquery 1.5
  ⚪ apply executeCommand against bigquery 1.5
  ✅ apply mergeColumns against bigquery 1.5
  ✅ apply modifyDataType against bigquery 1.5
  ✅ apply modifySql against bigquery 1.5
  ✅ apply renameColumn against bigquery 1.5
  ⚪ apply renameSequence against bigquery 1.5
  ✅ apply renameTable against bigquery 1.5
  ⚪ 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
  ✅ apply sqlFile against bigquery 1.5
liquibase.harness.data.ChangeDataTests
  ✅ apply delete against bigquery 1.5
  ✅ apply insert against bigquery 1.5
  ✅ apply loadData against bigquery 1.5
  ✅ apply loadUpdateData against bigquery 1.5

Annotations

Check failure on line 0 in target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml

See this annotation in the file changed.

@github-actions 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)

Check failure on line 0 in target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml

See this annotation in the file changed.

@github-actions 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)

Check failure on line 0 in target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml

See this annotation in the file changed.

@github-actions 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)

Check failure on line 0 in target/surefire-reports/TEST-liquibase.ext.bigquery.ContributedHarnessSuiteIT.xml

See this annotation in the file changed.

@github-actions github-actions / Liquibase Test Harness - Contributed Reports

liquibase.ext.bigquery.ContributedHarnessSuiteIT ► liquibase.harness.change.ChangeObjectTests ► apply dropForeignKey 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/dropForeignKey.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)
View more details on GitHub Actions