BasicSyntaxTest::testConcatFields fails with contrib driver

Problem/Motivation

The 'test' table in the database test module is created with the 'name' column defined as type 'varchar_ascii', while the table collation used is 'utf8mb4_general_ci'. This results in the 'name' column to use a 'ascii_bin' collation, different than the rest of the columns.

When BasicSyntaxTest::testConcatFields is concatenating db fields and literal constants under a driver that implements a mysqli statement, the following exception is thrown:

Drupal\Core\Database\DatabaseExceptionWrapper: Illegal mix of collations (ascii_bin,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'concat': SELECT CONCAT(:a1, CONCAT(name, CONCAT(:a2, CONCAT(age, :a3)))) FROM {test} WHERE age = :age; Array
(
    [:a1] => The age of 
    [:a2] =>  is 
    [:a3] => .
    [:age] => 25
)

Apparently, mysqli is stricter than PDO in this case.

Proposed resolution

The simplest proposal is to just replace 'name' with 'job' in the test: 'job' has the same collation of the rest of the fields/literals at that point.

Remaining tasks

review

User interface changes

none

API changes

none

Data model changes

none