Sort out more driver specific database kernel tests

Problem/Motivation

Follow-up to #3315604: Move remaining database specific kernel tests to the driver modules with additional opportunities identified while testing with a custom driver.

Points:

• DriverSpecificSchemaTestBase::testSchema() has the following code
  

      // Use database specific data type and ensure that table is created.
      $table_specification = [
        'description' => 'Schema table description.',
        'fields' => [
          'timestamp'  => [
            'mysql_type' => 'timestamp',
            'pgsql_type' => 'timestamp',
            'sqlite_type' => 'datetime',
            'not null' => FALSE,
            'default' => NULL,
          ],
        ],
      ];
      try {
        $this->schema->createTable('test_timestamp', $table_specification);
      }
      catch (\Exception $e) {
      }
      $this->assertTrue($this->schema->tableExists('test_timestamp'), 'Table with database specific datatype was created.');
  

  that makes hard for contrib to test their own type --> extract in a separate abstract method that each diver implements

• Drupal\KernelTests\Core\Cache\EndOfTransactionQueriesTest requires a driver specific \Drupal\database_statement_monitoring_test\{driver}\Connection class --> change the entire test class to an abstract base one extending DriverSpecificKernelTestBase, re-implement in modules
• Drupal\KernelTests\Core\Database\TransactionTest::testTransactionWithDdlStatement
  Rolling back a transaction containing DDL should produce a warning, but not all drivers can handle that (i.e. mysqli, oracle). --> change the entire test class to an abstract base one extending DriverSpecificKernelTestBase, re-implement in modules
• Drupal\KernelTests\Core\Database\BasicSyntaxTest::testAllowSquareBrackets in Oracle, this produces an error ORA-00904: "NAME": invalid identifier: select name from "test18855128test" where name = '[square]' --> extract the testAllowSquareBrackets() test to an abstract base one extending DriverSpecificKernelTestBase, implement in modules

Proposed resolution

See above.

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet