function SchemaTest::testGeneratedInvisiblePrimaryKey

Tests adding a primary key when sql_generate_invisible_primary_key is on.

File

core/modules/mysql/tests/src/Kernel/mysql/SchemaTest.php, line 320

Class

SchemaTest

Tests schema API for the MySQL driver.

Namespace

Code

public function testGeneratedInvisiblePrimaryKey() : void {
    $is_maria = method_exists($this->connection, 'isMariaDb') && $this->connection
        ->isMariaDb();
    if ($this->connection
        ->databaseType() !== 'mysql' || $is_maria || version_compare($this->connection
        ->version(), '8.0.30', '<')) {
        $this->markTestSkipped('This test only runs on MySQL 8.0.30 and above');
    }
    try {
        $this->connection
            ->query("SET sql_generate_invisible_primary_key = 1;")
            ->execute();
    } catch (DatabaseExceptionWrapper) {
        $this->markTestSkipped('This test requires the SESSION_VARIABLES_ADMIN privilege.');
    }
    $this->schema
        ->createTable('test_primary_key', [
        'fields' => [
            'foo' => [
                'type' => 'varchar',
                'length' => 1,
            ],
        ],
    ]);
    $this->schema
        ->addField('test_primary_key', 'id', [
        'type' => 'serial',
        'not null' => TRUE,
    ], [
        'primary key' => [
            'id',
        ],
    ]);
    $this->assertTrue($this->schema
        ->fieldExists('test_primary_key', 'id'));
}