function DatabaseReservedKeywordTestCase::testTableNameQuoting

File

modules/simpletest/tests/database_test.test, line 4513

Class

DatabaseReservedKeywordTestCase

Test reserved keyword handling (introduced for MySQL 8+)

Code

public function testTableNameQuoting() {
    // Test db_query with {table} pattern.
    $record = db_query('SELECT * FROM {system} LIMIT 1')->fetchObject();
    $this->assertTrue(isset($record->filename), 'Successfully queried the {system} table.');
    $connection = Database::getConnection()->getConnectionOptions();
    if ($connection['driver'] === 'sqlite') {
        // In SQLite simpletest's prefixed db tables exist in their own schema
        // (e.g. simpletest124904.system), so we cannot test the schema.{table}
        // syntax here as the table name will have the schema name prepended to it
        // when prefixes are processed.
        $this->assert(TRUE, 'Skipping schema.{system} test for SQLite.');
    }
    else {
        $database = $connection['database'];
        if ($connection['driver'] === 'pgsql') {
            // database.scheme.table for PostgreSQL
            // @see https://www.postgresql.org/docs/14/ddl-schemas.html
            $database .= '.public';
        }
        // Test db_query with schema.{table} pattern
        db_query('SELECT * FROM ' . $database . '.{system} LIMIT 1')->fetchObject();
        $this->assertTrue(isset($record->filename), 'Successfully queried the schema.{system} table.');
    }
}