[D7] NodeCreationTestCase fails on PostgreSQL

Problem/Motivation

There is a test failure in Node creation test on PostgreSQL.

The issue is that PostgreSQL doesn't support bytea LIKE queries, so we need to unserialize first to check for the rollback exception message.

Problematic code:

testFailedPageCreation()

  $records = db_query("SELECT wid FROM {watchdog} WHERE variables LIKE '%Test exception for rollback.%'")->fetchAll();
  $this->assertTrue(count($records) > 0, 'Rollback explanatory error logged to watchdog.');

This was fixed in Drupal8 7 years ago, see: #2443665: PostgreSQL: Fix node\Tests\NodeCreationTest

Steps to reproduce

Run Node / Node creation tests.

Proposed resolution

Backport #2443665: PostgreSQL: Fix node\Tests\NodeCreationTest

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet