SQLAnywherePlatformTest.php 39.1 KB
Newer Older
1 2 3 4
<?php

namespace Doctrine\Tests\DBAL\Platforms;

Sergei Morozov's avatar
Sergei Morozov committed
5
use Doctrine\DBAL\DBALException;
6 7 8
use Doctrine\DBAL\LockMode;
use Doctrine\DBAL\Platforms\AbstractPlatform;
use Doctrine\DBAL\Platforms\SQLAnywherePlatform;
9
use Doctrine\DBAL\Platforms\TrimMode;
10 11
use Doctrine\DBAL\Schema\Column;
use Doctrine\DBAL\Schema\ColumnDiff;
12
use Doctrine\DBAL\Schema\Comparator;
Sergei Morozov's avatar
Sergei Morozov committed
13
use Doctrine\DBAL\Schema\Constraint;
14 15 16 17
use Doctrine\DBAL\Schema\ForeignKeyConstraint;
use Doctrine\DBAL\Schema\Index;
use Doctrine\DBAL\Schema\Table;
use Doctrine\DBAL\Schema\TableDiff;
18
use Doctrine\DBAL\TransactionIsolationLevel;
19
use Doctrine\DBAL\Types\Type;
Sergei Morozov's avatar
Sergei Morozov committed
20
use InvalidArgumentException;
21 22 23
use function mt_rand;
use function strlen;
use function substr;
24 25 26

class SQLAnywherePlatformTest extends AbstractPlatformTestCase
{
Sergei Morozov's avatar
Sergei Morozov committed
27
    /** @var SQLAnywherePlatform */
Sergei Morozov's avatar
Sergei Morozov committed
28
    protected $platform;
29 30 31

    public function createPlatform()
    {
Sergei Morozov's avatar
Sergei Morozov committed
32
        return new SQLAnywherePlatform();
33 34 35 36
    }

    public function getGenerateAlterTableSql()
    {
Sergei Morozov's avatar
Sergei Morozov committed
37
        return [
38
            "ALTER TABLE mytable ADD quota INT DEFAULT NULL, DROP foo, ALTER baz VARCHAR(1) DEFAULT 'def' NOT NULL, ALTER bloo BIT DEFAULT '0' NOT NULL",
Sergei Morozov's avatar
Sergei Morozov committed
39 40
            'ALTER TABLE mytable RENAME userlist',
        ];
41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59
    }

    public function getGenerateForeignKeySql()
    {
        return 'ALTER TABLE test ADD FOREIGN KEY (fk_name_id) REFERENCES other_table (id)';
    }

    public function getGenerateIndexSql()
    {
        return 'CREATE INDEX my_idx ON mytable (user_name, last_login)';
    }

    public function getGenerateTableSql()
    {
        return 'CREATE TABLE test (id INT IDENTITY NOT NULL, test VARCHAR(255) DEFAULT NULL, PRIMARY KEY (id))';
    }

    public function getGenerateTableWithMultiColumnUniqueIndexSql()
    {
Sergei Morozov's avatar
Sergei Morozov committed
60
        return [
61
            'CREATE TABLE test (foo VARCHAR(255) DEFAULT NULL, bar VARCHAR(255) DEFAULT NULL)',
Sergei Morozov's avatar
Sergei Morozov committed
62 63
            'CREATE UNIQUE INDEX UNIQ_D87F7E0C8C73652176FF8CAA ON test (foo, bar)',
        ];
64 65 66 67 68 69 70
    }

    public function getGenerateUniqueIndexSql()
    {
        return 'CREATE UNIQUE INDEX index_name ON test (test, test2)';
    }

71 72
    protected function getQuotedColumnInForeignKeySQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
73
        return ['CREATE TABLE "quoted" ("create" VARCHAR(255) NOT NULL, foo VARCHAR(255) NOT NULL, "bar" VARCHAR(255) NOT NULL, CONSTRAINT FK_WITH_RESERVED_KEYWORD FOREIGN KEY ("create", foo, "bar") REFERENCES "foreign" ("create", bar, "foo-bar"), CONSTRAINT FK_WITH_NON_RESERVED_KEYWORD FOREIGN KEY ("create", foo, "bar") REFERENCES foo ("create", bar, "foo-bar"), CONSTRAINT FK_WITH_INTENDED_QUOTATION FOREIGN KEY ("create", foo, "bar") REFERENCES "foo-bar" ("create", bar, "foo-bar"))'];
74 75
    }

76 77
    protected function getQuotedColumnInIndexSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
78
        return [
79
            'CREATE TABLE "quoted" ("create" VARCHAR(255) NOT NULL)',
Sergei Morozov's avatar
Sergei Morozov committed
80 81
            'CREATE INDEX IDX_22660D028FD6E0FB ON "quoted" ("create")',
        ];
82 83
    }

Markus Fasselt's avatar
Markus Fasselt committed
84 85
    protected function getQuotedNameInIndexSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
86
        return [
Markus Fasselt's avatar
Markus Fasselt committed
87 88
            'CREATE TABLE test (column1 VARCHAR(255) NOT NULL)',
            'CREATE INDEX "key" ON test (column1)',
Sergei Morozov's avatar
Sergei Morozov committed
89
        ];
Markus Fasselt's avatar
Markus Fasselt committed
90 91
    }

92 93
    protected function getQuotedColumnInPrimaryKeySQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
94
        return ['CREATE TABLE "quoted" ("create" VARCHAR(255) NOT NULL, PRIMARY KEY ("create"))'];
95 96 97 98
    }

    public function getCreateTableColumnCommentsSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
99 100
        return [
            'CREATE TABLE test (id INT NOT NULL, PRIMARY KEY (id))',
101
            "COMMENT ON COLUMN test.id IS 'This is a comment'",
Sergei Morozov's avatar
Sergei Morozov committed
102
        ];
103 104 105 106
    }

    public function getAlterTableColumnCommentsSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
107 108
        return [
            'ALTER TABLE mytable ADD quota INT NOT NULL',
109
            "COMMENT ON COLUMN mytable.quota IS 'A comment'",
Sergei Morozov's avatar
Sergei Morozov committed
110
            'COMMENT ON COLUMN mytable.foo IS NULL',
111
            "COMMENT ON COLUMN mytable.baz IS 'B comment'",
Sergei Morozov's avatar
Sergei Morozov committed
112
        ];
113 114 115 116
    }

    public function getCreateTableColumnTypeCommentsSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
117 118 119 120
        return [
            'CREATE TABLE test (id INT NOT NULL, data TEXT NOT NULL, PRIMARY KEY (id))',
            "COMMENT ON COLUMN test.data IS '(DC2Type:array)'",
        ];
121 122 123 124
    }

    public function testHasCorrectPlatformName()
    {
Sergei Morozov's avatar
Sergei Morozov committed
125
        self::assertEquals('sqlanywhere', $this->platform->getName());
126 127 128 129 130 131
    }

    public function testGeneratesCreateTableSQLWithCommonIndexes()
    {
        $table = new Table('test');
        $table->addColumn('id', 'integer');
Sergei Morozov's avatar
Sergei Morozov committed
132 133 134 135
        $table->addColumn('name', 'string', ['length' => 50]);
        $table->setPrimaryKey(['id']);
        $table->addIndex(['name']);
        $table->addIndex(['id', 'name'], 'composite_idx');
136

137
        self::assertEquals(
Sergei Morozov's avatar
Sergei Morozov committed
138
            [
139 140
                'CREATE TABLE test (id INT NOT NULL, name VARCHAR(50) NOT NULL, PRIMARY KEY (id))',
                'CREATE INDEX IDX_D87F7E0C5E237E06 ON test (name)',
Sergei Morozov's avatar
Sergei Morozov committed
141 142
                'CREATE INDEX composite_idx ON test (id, name)',
            ],
Sergei Morozov's avatar
Sergei Morozov committed
143
            $this->platform->getCreateTableSQL($table)
144 145 146 147 148 149 150 151 152
        );
    }

    public function testGeneratesCreateTableSQLWithForeignKeyConstraints()
    {
        $table = new Table('test');
        $table->addColumn('id', 'integer');
        $table->addColumn('fk_1', 'integer');
        $table->addColumn('fk_2', 'integer');
Sergei Morozov's avatar
Sergei Morozov committed
153 154
        $table->setPrimaryKey(['id']);
        $table->addForeignKeyConstraint('foreign_table', ['fk_1', 'fk_2'], ['pk_1', 'pk_2']);
155 156
        $table->addForeignKeyConstraint(
            'foreign_table2',
Sergei Morozov's avatar
Sergei Morozov committed
157 158 159
            ['fk_1', 'fk_2'],
            ['pk_1', 'pk_2'],
            [],
160 161 162
            'named_fk'
        );

163
        self::assertEquals(
Sergei Morozov's avatar
Sergei Morozov committed
164
            ['CREATE TABLE test (id INT NOT NULL, fk_1 INT NOT NULL, fk_2 INT NOT NULL, ' .
165
                'CONSTRAINT FK_D87F7E0C177612A38E7F4319 FOREIGN KEY (fk_1, fk_2) REFERENCES foreign_table (pk_1, pk_2), ' .
Sergei Morozov's avatar
Sergei Morozov committed
166 167
                'CONSTRAINT named_fk FOREIGN KEY (fk_1, fk_2) REFERENCES foreign_table2 (pk_1, pk_2))',
            ],
Sergei Morozov's avatar
Sergei Morozov committed
168
            $this->platform->getCreateTableSQL($table, AbstractPlatform::CREATE_FOREIGNKEYS)
169 170 171 172 173 174 175
        );
    }

    public function testGeneratesCreateTableSQLWithCheckConstraints()
    {
        $table = new Table('test');
        $table->addColumn('id', 'integer');
Sergei Morozov's avatar
Sergei Morozov committed
176 177 178
        $table->addColumn('check_max', 'integer', ['platformOptions' => ['max' => 10]]);
        $table->addColumn('check_min', 'integer', ['platformOptions' => ['min' => 10]]);
        $table->setPrimaryKey(['id']);
179

180
        self::assertEquals(
Sergei Morozov's avatar
Sergei Morozov committed
181
            ['CREATE TABLE test (id INT NOT NULL, check_max INT NOT NULL, check_min INT NOT NULL, PRIMARY KEY (id), CHECK (check_max <= 10), CHECK (check_min >= 10))'],
Sergei Morozov's avatar
Sergei Morozov committed
182
            $this->platform->getCreateTableSQL($table)
183 184 185 186 187 188
        );
    }

    public function testGeneratesTableAlterationWithRemovedColumnCommentSql()
    {
        $table = new Table('mytable');
Sergei Morozov's avatar
Sergei Morozov committed
189
        $table->addColumn('foo', 'string', ['comment' => 'foo comment']);
190

Sergei Morozov's avatar
Sergei Morozov committed
191 192
        $tableDiff                        = new TableDiff('mytable');
        $tableDiff->fromTable             = $table;
193 194 195
        $tableDiff->changedColumns['foo'] = new ColumnDiff(
            'foo',
            new Column('foo', Type::getType('string')),
Sergei Morozov's avatar
Sergei Morozov committed
196
            ['comment']
197 198
        );

199
        self::assertEquals(
Sergei Morozov's avatar
Sergei Morozov committed
200
            ['COMMENT ON COLUMN mytable.foo IS NULL'],
Sergei Morozov's avatar
Sergei Morozov committed
201
            $this->platform->getAlterTableSQL($tableDiff)
202 203 204
        );
    }

205 206 207 208
    /**
     * @dataProvider getLockHints
     */
    public function testAppendsLockHint($lockMode, $lockHint)
209
    {
Sergei Morozov's avatar
Sergei Morozov committed
210
        $fromClause     = 'FROM users';
211
        $expectedResult = $fromClause . $lockHint;
212

Sergei Morozov's avatar
Sergei Morozov committed
213
        self::assertSame($expectedResult, $this->platform->appendLockHint($fromClause, $lockMode));
214 215
    }

216
    public function getLockHints()
217
    {
Sergei Morozov's avatar
Sergei Morozov committed
218 219 220 221 222 223 224 225 226
        return [
            [null, ''],
            [false, ''],
            [true, ''],
            [LockMode::NONE, ' WITH (NOLOCK)'],
            [LockMode::OPTIMISTIC, ''],
            [LockMode::PESSIMISTIC_READ, ' WITH (UPDLOCK)'],
            [LockMode::PESSIMISTIC_WRITE, ' WITH (XLOCK)'],
        ];
227 228 229 230
    }

    public function testHasCorrectMaxIdentifierLength()
    {
Sergei Morozov's avatar
Sergei Morozov committed
231
        self::assertEquals(128, $this->platform->getMaxIdentifierLength());
232 233 234 235
    }

    public function testFixesSchemaElementNames()
    {
Sergei Morozov's avatar
Sergei Morozov committed
236
        $maxIdentifierLength = $this->platform->getMaxIdentifierLength();
Sergei Morozov's avatar
Sergei Morozov committed
237 238
        $characters          = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
        $schemaElementName   = '';
239 240 241 242 243 244 245

        for ($i = 0; $i < $maxIdentifierLength + 100; $i++) {
            $schemaElementName .= $characters[mt_rand(0, strlen($characters) - 1)];
        }

        $fixedSchemaElementName = substr($schemaElementName, 0, $maxIdentifierLength);

246
        self::assertEquals(
247
            $fixedSchemaElementName,
Sergei Morozov's avatar
Sergei Morozov committed
248
            $this->platform->fixSchemaElementName($schemaElementName)
249
        );
250
        self::assertEquals(
251
            $fixedSchemaElementName,
Sergei Morozov's avatar
Sergei Morozov committed
252
            $this->platform->fixSchemaElementName($fixedSchemaElementName)
253 254 255 256 257
        );
    }

    public function testGeneratesColumnTypesDeclarationSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
258
        $fullColumnDef = [
259 260 261
            'length' => 10,
            'fixed' => true,
            'unsigned' => true,
Sergei Morozov's avatar
Sergei Morozov committed
262 263
            'autoincrement' => true,
        ];
264

Sergei Morozov's avatar
Sergei Morozov committed
265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283
        self::assertEquals('SMALLINT', $this->platform->getSmallIntTypeDeclarationSQL([]));
        self::assertEquals('UNSIGNED SMALLINT', $this->platform->getSmallIntTypeDeclarationSQL(['unsigned' => true]));
        self::assertEquals('UNSIGNED SMALLINT IDENTITY', $this->platform->getSmallIntTypeDeclarationSQL($fullColumnDef));
        self::assertEquals('INT', $this->platform->getIntegerTypeDeclarationSQL([]));
        self::assertEquals('UNSIGNED INT', $this->platform->getIntegerTypeDeclarationSQL(['unsigned' => true]));
        self::assertEquals('UNSIGNED INT IDENTITY', $this->platform->getIntegerTypeDeclarationSQL($fullColumnDef));
        self::assertEquals('BIGINT', $this->platform->getBigIntTypeDeclarationSQL([]));
        self::assertEquals('UNSIGNED BIGINT', $this->platform->getBigIntTypeDeclarationSQL(['unsigned' => true]));
        self::assertEquals('UNSIGNED BIGINT IDENTITY', $this->platform->getBigIntTypeDeclarationSQL($fullColumnDef));
        self::assertEquals('LONG BINARY', $this->platform->getBlobTypeDeclarationSQL($fullColumnDef));
        self::assertEquals('BIT', $this->platform->getBooleanTypeDeclarationSQL($fullColumnDef));
        self::assertEquals('TEXT', $this->platform->getClobTypeDeclarationSQL($fullColumnDef));
        self::assertEquals('DATE', $this->platform->getDateTypeDeclarationSQL($fullColumnDef));
        self::assertEquals('DATETIME', $this->platform->getDateTimeTypeDeclarationSQL($fullColumnDef));
        self::assertEquals('TIME', $this->platform->getTimeTypeDeclarationSQL($fullColumnDef));
        self::assertEquals('UNIQUEIDENTIFIER', $this->platform->getGuidTypeDeclarationSQL($fullColumnDef));

        self::assertEquals(1, $this->platform->getVarcharDefaultLength());
        self::assertEquals(32767, $this->platform->getVarcharMaxLength());
284 285 286 287
    }

    public function testHasNativeGuidType()
    {
Sergei Morozov's avatar
Sergei Morozov committed
288
        self::assertTrue($this->platform->hasNativeGuidType());
289 290 291 292
    }

    public function testGeneratesDDLSnippets()
    {
Sergei Morozov's avatar
Sergei Morozov committed
293 294 295 296 297 298 299 300 301 302 303 304 305 306 307
        self::assertEquals("CREATE DATABASE 'foobar'", $this->platform->getCreateDatabaseSQL('foobar'));
        self::assertEquals("CREATE DATABASE 'foobar'", $this->platform->getCreateDatabaseSQL('"foobar"'));
        self::assertEquals("CREATE DATABASE 'create'", $this->platform->getCreateDatabaseSQL('create'));
        self::assertEquals("DROP DATABASE 'foobar'", $this->platform->getDropDatabaseSQL('foobar'));
        self::assertEquals("DROP DATABASE 'foobar'", $this->platform->getDropDatabaseSQL('"foobar"'));
        self::assertEquals("DROP DATABASE 'create'", $this->platform->getDropDatabaseSQL('create'));
        self::assertEquals('CREATE GLOBAL TEMPORARY TABLE', $this->platform->getCreateTemporaryTableSnippetSQL());
        self::assertEquals("START DATABASE 'foobar' AUTOSTOP OFF", $this->platform->getStartDatabaseSQL('foobar'));
        self::assertEquals("START DATABASE 'foobar' AUTOSTOP OFF", $this->platform->getStartDatabaseSQL('"foobar"'));
        self::assertEquals("START DATABASE 'create' AUTOSTOP OFF", $this->platform->getStartDatabaseSQL('create'));
        self::assertEquals('STOP DATABASE "foobar" UNCONDITIONALLY', $this->platform->getStopDatabaseSQL('foobar'));
        self::assertEquals('STOP DATABASE "foobar" UNCONDITIONALLY', $this->platform->getStopDatabaseSQL('"foobar"'));
        self::assertEquals('STOP DATABASE "create" UNCONDITIONALLY', $this->platform->getStopDatabaseSQL('create'));
        self::assertEquals('TRUNCATE TABLE foobar', $this->platform->getTruncateTableSQL('foobar'));
        self::assertEquals('TRUNCATE TABLE foobar', $this->platform->getTruncateTableSQL('foobar'), true);
308 309

        $viewSql = 'SELECT * FROM footable';
Sergei Morozov's avatar
Sergei Morozov committed
310 311
        self::assertEquals('CREATE VIEW fooview AS ' . $viewSql, $this->platform->getCreateViewSQL('fooview', $viewSql));
        self::assertEquals('DROP VIEW fooview', $this->platform->getDropViewSQL('fooview'));
312 313 314 315
    }

    public function testGeneratesPrimaryKeyDeclarationSQL()
    {
316
        self::assertEquals(
317
            'CONSTRAINT pk PRIMARY KEY CLUSTERED (a, b)',
Sergei Morozov's avatar
Sergei Morozov committed
318
            $this->platform->getPrimaryKeyDeclarationSQL(
Sergei Morozov's avatar
Sergei Morozov committed
319
                new Index(null, ['a', 'b'], true, true, ['clustered']),
320 321 322
                'pk'
            )
        );
323
        self::assertEquals(
324
            'PRIMARY KEY (a, b)',
Sergei Morozov's avatar
Sergei Morozov committed
325
            $this->platform->getPrimaryKeyDeclarationSQL(
Sergei Morozov's avatar
Sergei Morozov committed
326
                new Index(null, ['a', 'b'], true, true)
327 328 329 330 331 332
            )
        );
    }

    public function testCannotGeneratePrimaryKeyDeclarationSQLWithEmptyColumns()
    {
Sergei Morozov's avatar
Sergei Morozov committed
333
        $this->expectException(InvalidArgumentException::class);
334

Sergei Morozov's avatar
Sergei Morozov committed
335
        $this->platform->getPrimaryKeyDeclarationSQL(new Index('pk', [], true, true));
336 337 338 339
    }

    public function testGeneratesCreateUnnamedPrimaryKeySQL()
    {
340
        self::assertEquals(
341
            'ALTER TABLE foo ADD PRIMARY KEY CLUSTERED (a, b)',
Sergei Morozov's avatar
Sergei Morozov committed
342
            $this->platform->getCreatePrimaryKeySQL(
Sergei Morozov's avatar
Sergei Morozov committed
343
                new Index('pk', ['a', 'b'], true, true, ['clustered']),
344 345 346
                'foo'
            )
        );
347
        self::assertEquals(
348
            'ALTER TABLE foo ADD PRIMARY KEY (a, b)',
Sergei Morozov's avatar
Sergei Morozov committed
349
            $this->platform->getCreatePrimaryKeySQL(
Sergei Morozov's avatar
Sergei Morozov committed
350
                new Index('any_pk_name', ['a', 'b'], true, true),
351 352 353 354 355 356 357
                new Table('foo')
            )
        );
    }

    public function testGeneratesUniqueConstraintDeclarationSQL()
    {
358
        self::assertEquals(
359
            'CONSTRAINT unique_constraint UNIQUE CLUSTERED (a, b)',
Sergei Morozov's avatar
Sergei Morozov committed
360
            $this->platform->getUniqueConstraintDeclarationSQL(
361
                'unique_constraint',
Sergei Morozov's avatar
Sergei Morozov committed
362
                new Index(null, ['a', 'b'], true, false, ['clustered'])
363 364
            )
        );
365
        self::assertEquals(
366
            'UNIQUE (a, b)',
Sergei Morozov's avatar
Sergei Morozov committed
367
            $this->platform->getUniqueConstraintDeclarationSQL(null, new Index(null, ['a', 'b'], true, false))
368 369 370 371 372
        );
    }

    public function testCannotGenerateUniqueConstraintDeclarationSQLWithEmptyColumns()
    {
Sergei Morozov's avatar
Sergei Morozov committed
373
        $this->expectException(InvalidArgumentException::class);
374

Sergei Morozov's avatar
Sergei Morozov committed
375
        $this->platform->getUniqueConstraintDeclarationSQL('constr', new Index('constr', [], true));
376 377 378 379
    }

    public function testGeneratesForeignKeyConstraintsWithAdvancedPlatformOptionsSQL()
    {
380
        self::assertEquals(
381 382 383 384
            'CONSTRAINT fk ' .
                'NOT NULL FOREIGN KEY (a, b) ' .
                'REFERENCES foreign_table (c, d) ' .
                'MATCH UNIQUE SIMPLE ON UPDATE CASCADE ON DELETE SET NULL CHECK ON COMMIT CLUSTERED FOR OLAP WORKLOAD',
Sergei Morozov's avatar
Sergei Morozov committed
385
            $this->platform->getForeignKeyDeclarationSQL(
Sergei Morozov's avatar
Sergei Morozov committed
386
                new ForeignKeyConstraint(['a', 'b'], 'foreign_table', ['c', 'd'], 'fk', [
387 388 389 390 391 392
                    'notnull' => true,
                    'match' => SQLAnywherePlatform::FOREIGN_KEY_MATCH_SIMPLE_UNIQUE,
                    'onUpdate' => 'CASCADE',
                    'onDelete' => 'SET NULL',
                    'check_on_commit' => true,
                    'clustered' => true,
Sergei Morozov's avatar
Sergei Morozov committed
393 394
                    'for_olap_workload' => true,
                ])
395 396
            )
        );
397
        self::assertEquals(
398
            'FOREIGN KEY (a, b) REFERENCES foreign_table (c, d)',
Sergei Morozov's avatar
Sergei Morozov committed
399
            $this->platform->getForeignKeyDeclarationSQL(
Sergei Morozov's avatar
Sergei Morozov committed
400
                new ForeignKeyConstraint(['a', 'b'], 'foreign_table', ['c', 'd'])
401 402 403 404 405 406
            )
        );
    }

    public function testGeneratesForeignKeyMatchClausesSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
407 408 409 410
        self::assertEquals('SIMPLE', $this->platform->getForeignKeyMatchClauseSQL(1));
        self::assertEquals('FULL', $this->platform->getForeignKeyMatchClauseSQL(2));
        self::assertEquals('UNIQUE SIMPLE', $this->platform->getForeignKeyMatchClauseSQL(129));
        self::assertEquals('UNIQUE FULL', $this->platform->getForeignKeyMatchClauseSQL(130));
411 412 413 414
    }

    public function testCannotGenerateInvalidForeignKeyMatchClauseSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
415
        $this->expectException(InvalidArgumentException::class);
416

Sergei Morozov's avatar
Sergei Morozov committed
417
        $this->platform->getForeignKeyMatchCLauseSQL(3);
418 419 420 421
    }

    public function testCannotGenerateForeignKeyConstraintSQLWithEmptyLocalColumns()
    {
Sergei Morozov's avatar
Sergei Morozov committed
422 423
        $this->expectException(InvalidArgumentException::class);
        $this->platform->getForeignKeyDeclarationSQL(new ForeignKeyConstraint([], 'foreign_tbl', ['c', 'd']));
424 425 426 427
    }

    public function testCannotGenerateForeignKeyConstraintSQLWithEmptyForeignColumns()
    {
Sergei Morozov's avatar
Sergei Morozov committed
428 429
        $this->expectException(InvalidArgumentException::class);
        $this->platform->getForeignKeyDeclarationSQL(new ForeignKeyConstraint(['a', 'b'], 'foreign_tbl', []));
430 431 432 433
    }

    public function testCannotGenerateForeignKeyConstraintSQLWithEmptyForeignTableName()
    {
Sergei Morozov's avatar
Sergei Morozov committed
434 435
        $this->expectException(InvalidArgumentException::class);
        $this->platform->getForeignKeyDeclarationSQL(new ForeignKeyConstraint(['a', 'b'], '', ['c', 'd']));
436 437 438 439
    }

    public function testCannotGenerateCommonIndexWithCreateConstraintSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
440
        $this->expectException(InvalidArgumentException::class);
441

Sergei Morozov's avatar
Sergei Morozov committed
442
        $this->platform->getCreateConstraintSQL(new Index('fooindex', []), new Table('footable'));
443 444 445 446
    }

    public function testCannotGenerateCustomConstraintWithCreateConstraintSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
447
        $this->expectException(InvalidArgumentException::class);
448

Sergei Morozov's avatar
Sergei Morozov committed
449
        $this->platform->getCreateConstraintSQL($this->createMock(Constraint::class), 'footable');
450 451 452 453
    }

    public function testGeneratesCreateIndexWithAdvancedPlatformOptionsSQL()
    {
454
        self::assertEquals(
455
            'CREATE VIRTUAL UNIQUE CLUSTERED INDEX fooindex ON footable (a, b) FOR OLAP WORKLOAD',
Sergei Morozov's avatar
Sergei Morozov committed
456
            $this->platform->getCreateIndexSQL(
457 458
                new Index(
                    'fooindex',
Sergei Morozov's avatar
Sergei Morozov committed
459
                    ['a', 'b'],
460 461
                    true,
                    false,
Sergei Morozov's avatar
Sergei Morozov committed
462
                    ['virtual', 'clustered', 'for_olap_workload']
463 464 465 466 467 468 469 470
                ),
                'footable'
            )
        );
    }

    public function testDoesNotSupportIndexDeclarationInCreateAlterTableStatements()
    {
Sergei Morozov's avatar
Sergei Morozov committed
471
        $this->expectException(DBALException::class);
472

Sergei Morozov's avatar
Sergei Morozov committed
473
        $this->platform->getIndexDeclarationSQL('index', new Index('index', []));
474 475 476 477
    }

    public function testGeneratesDropIndexSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
478
        $index = new Index('fooindex', []);
479

Sergei Morozov's avatar
Sergei Morozov committed
480 481 482
        self::assertEquals('DROP INDEX fooindex', $this->platform->getDropIndexSQL($index));
        self::assertEquals('DROP INDEX footable.fooindex', $this->platform->getDropIndexSQL($index, 'footable'));
        self::assertEquals('DROP INDEX footable.fooindex', $this->platform->getDropIndexSQL(
483 484 485 486 487 488 489
            $index,
            new Table('footable')
        ));
    }

    public function testCannotGenerateDropIndexSQLWithInvalidIndexParameter()
    {
Sergei Morozov's avatar
Sergei Morozov committed
490
        $this->expectException(InvalidArgumentException::class);
491

Sergei Morozov's avatar
Sergei Morozov committed
492
        $this->platform->getDropIndexSQL(['index'], 'table');
493 494 495 496
    }

    public function testCannotGenerateDropIndexSQLWithInvalidTableParameter()
    {
Sergei Morozov's avatar
Sergei Morozov committed
497
        $this->expectException(InvalidArgumentException::class);
498

Sergei Morozov's avatar
Sergei Morozov committed
499
        $this->platform->getDropIndexSQL('index', ['table']);
500 501 502 503
    }

    public function testGeneratesSQLSnippets()
    {
Sergei Morozov's avatar
Sergei Morozov committed
504
        self::assertEquals('STRING(column1, "string1", column2, "string2")', $this->platform->getConcatExpression(
505 506 507 508 509
            'column1',
            '"string1"',
            'column2',
            '"string2"'
        ));
Sergei Morozov's avatar
Sergei Morozov committed
510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539
        self::assertEquals('CURRENT DATE', $this->platform->getCurrentDateSQL());
        self::assertEquals('CURRENT TIME', $this->platform->getCurrentTimeSQL());
        self::assertEquals('CURRENT TIMESTAMP', $this->platform->getCurrentTimestampSQL());
        self::assertEquals("DATEADD(DAY, 4, '1987/05/02')", $this->platform->getDateAddDaysExpression("'1987/05/02'", 4));
        self::assertEquals("DATEADD(HOUR, 12, '1987/05/02')", $this->platform->getDateAddHourExpression("'1987/05/02'", 12));
        self::assertEquals("DATEADD(MINUTE, 2, '1987/05/02')", $this->platform->getDateAddMinutesExpression("'1987/05/02'", 2));
        self::assertEquals("DATEADD(MONTH, 102, '1987/05/02')", $this->platform->getDateAddMonthExpression("'1987/05/02'", 102));
        self::assertEquals("DATEADD(QUARTER, 5, '1987/05/02')", $this->platform->getDateAddQuartersExpression("'1987/05/02'", 5));
        self::assertEquals("DATEADD(SECOND, 1, '1987/05/02')", $this->platform->getDateAddSecondsExpression("'1987/05/02'", 1));
        self::assertEquals("DATEADD(WEEK, 3, '1987/05/02')", $this->platform->getDateAddWeeksExpression("'1987/05/02'", 3));
        self::assertEquals("DATEADD(YEAR, 10, '1987/05/02')", $this->platform->getDateAddYearsExpression("'1987/05/02'", 10));
        self::assertEquals("DATEDIFF(day, '1987/04/01', '1987/05/02')", $this->platform->getDateDiffExpression("'1987/05/02'", "'1987/04/01'"));
        self::assertEquals("DATEADD(DAY, -1 * 4, '1987/05/02')", $this->platform->getDateSubDaysExpression("'1987/05/02'", 4));
        self::assertEquals("DATEADD(HOUR, -1 * 12, '1987/05/02')", $this->platform->getDateSubHourExpression("'1987/05/02'", 12));
        self::assertEquals("DATEADD(MINUTE, -1 * 2, '1987/05/02')", $this->platform->getDateSubMinutesExpression("'1987/05/02'", 2));
        self::assertEquals("DATEADD(MONTH, -1 * 102, '1987/05/02')", $this->platform->getDateSubMonthExpression("'1987/05/02'", 102));
        self::assertEquals("DATEADD(QUARTER, -1 * 5, '1987/05/02')", $this->platform->getDateSubQuartersExpression("'1987/05/02'", 5));
        self::assertEquals("DATEADD(SECOND, -1 * 1, '1987/05/02')", $this->platform->getDateSubSecondsExpression("'1987/05/02'", 1));
        self::assertEquals("DATEADD(WEEK, -1 * 3, '1987/05/02')", $this->platform->getDateSubWeeksExpression("'1987/05/02'", 3));
        self::assertEquals("DATEADD(YEAR, -1 * 10, '1987/05/02')", $this->platform->getDateSubYearsExpression("'1987/05/02'", 10));
        self::assertEquals('Y-m-d H:i:s.u', $this->platform->getDateTimeFormatString());
        self::assertEquals('H:i:s.u', $this->platform->getTimeFormatString());
        self::assertEquals('', $this->platform->getForUpdateSQL());
        self::assertEquals('NEWID()', $this->platform->getGuidExpression());
        self::assertEquals('LOCATE(string_column, substring_column)', $this->platform->getLocateExpression('string_column', 'substring_column'));
        self::assertEquals('LOCATE(string_column, substring_column, 1)', $this->platform->getLocateExpression('string_column', 'substring_column', 1));
        self::assertEquals("HASH(column, 'MD5')", $this->platform->getMd5Expression('column'));
        self::assertEquals('SUBSTRING(column, 5)', $this->platform->getSubstringExpression('column', 5));
        self::assertEquals('SUBSTRING(column, 5, 2)', $this->platform->getSubstringExpression('column', 5, 2));
        self::assertEquals('GLOBAL TEMPORARY', $this->platform->getTemporaryTableSQL());
540
        self::assertEquals(
541
            'LTRIM(column)',
Sergei Morozov's avatar
Sergei Morozov committed
542
            $this->platform->getTrimExpression('column', TrimMode::LEADING)
543
        );
544
        self::assertEquals(
545
            'RTRIM(column)',
Sergei Morozov's avatar
Sergei Morozov committed
546
            $this->platform->getTrimExpression('column', TrimMode::TRAILING)
547
        );
548
        self::assertEquals(
549
            'TRIM(column)',
Sergei Morozov's avatar
Sergei Morozov committed
550
            $this->platform->getTrimExpression('column')
551
        );
552
        self::assertEquals(
553
            'TRIM(column)',
Sergei Morozov's avatar
Sergei Morozov committed
554
            $this->platform->getTrimExpression('column', TrimMode::UNSPECIFIED)
555
        );
556
        self::assertEquals(
Steve Müller's avatar
Steve Müller committed
557
            "SUBSTR(column, PATINDEX('%[^' + c + ']%', column))",
Sergei Morozov's avatar
Sergei Morozov committed
558
            $this->platform->getTrimExpression('column', TrimMode::LEADING, 'c')
559
        );
560
        self::assertEquals(
Steve Müller's avatar
Steve Müller committed
561
            "REVERSE(SUBSTR(REVERSE(column), PATINDEX('%[^' + c + ']%', REVERSE(column))))",
Sergei Morozov's avatar
Sergei Morozov committed
562
            $this->platform->getTrimExpression('column', TrimMode::TRAILING, 'c')
563
        );
564
        self::assertEquals(
Steve Müller's avatar
Steve Müller committed
565 566
            "REVERSE(SUBSTR(REVERSE(SUBSTR(column, PATINDEX('%[^' + c + ']%', column))), PATINDEX('%[^' + c + ']%', " .
            "REVERSE(SUBSTR(column, PATINDEX('%[^' + c + ']%', column))))))",
Sergei Morozov's avatar
Sergei Morozov committed
567
            $this->platform->getTrimExpression('column', null, 'c')
568
        );
569
        self::assertEquals(
Steve Müller's avatar
Steve Müller committed
570 571
            "REVERSE(SUBSTR(REVERSE(SUBSTR(column, PATINDEX('%[^' + c + ']%', column))), PATINDEX('%[^' + c + ']%', " .
            "REVERSE(SUBSTR(column, PATINDEX('%[^' + c + ']%', column))))))",
Sergei Morozov's avatar
Sergei Morozov committed
572
            $this->platform->getTrimExpression('column', TrimMode::UNSPECIFIED, 'c')
573 574 575 576 577
        );
    }

    public function testDoesNotSupportRegexp()
    {
Sergei Morozov's avatar
Sergei Morozov committed
578
        $this->expectException(DBALException::class);
579

Sergei Morozov's avatar
Sergei Morozov committed
580
        $this->platform->getRegexpExpression();
581 582
    }

583 584 585 586 587
    public function testHasCorrectDateTimeTzFormatString()
    {
        // Date time type with timezone is not supported before version 12.
        // For versions before we have to ensure that the date time with timezone format
        // equals the normal date time format so that it corresponds to the declaration SQL equality (datetimetz -> datetime).
Sergei Morozov's avatar
Sergei Morozov committed
588
        self::assertEquals($this->platform->getDateTimeFormatString(), $this->platform->getDateTimeTzFormatString());
589 590
    }

591 592
    public function testHasCorrectDefaultTransactionIsolationLevel()
    {
593
        self::assertEquals(
594
            TransactionIsolationLevel::READ_UNCOMMITTED,
Sergei Morozov's avatar
Sergei Morozov committed
595
            $this->platform->getDefaultTransactionIsolationLevel()
596 597 598 599 600
        );
    }

    public function testGeneratesTransactionsCommands()
    {
601
        self::assertEquals(
602
            'SET TEMPORARY OPTION isolation_level = 0',
Sergei Morozov's avatar
Sergei Morozov committed
603
            $this->platform->getSetTransactionIsolationSQL(TransactionIsolationLevel::READ_UNCOMMITTED)
604
        );
605
        self::assertEquals(
606
            'SET TEMPORARY OPTION isolation_level = 1',
Sergei Morozov's avatar
Sergei Morozov committed
607
            $this->platform->getSetTransactionIsolationSQL(TransactionIsolationLevel::READ_COMMITTED)
608
        );
609
        self::assertEquals(
610
            'SET TEMPORARY OPTION isolation_level = 2',
Sergei Morozov's avatar
Sergei Morozov committed
611
            $this->platform->getSetTransactionIsolationSQL(TransactionIsolationLevel::REPEATABLE_READ)
612
        );
613
        self::assertEquals(
614
            'SET TEMPORARY OPTION isolation_level = 3',
Sergei Morozov's avatar
Sergei Morozov committed
615
            $this->platform->getSetTransactionIsolationSQL(TransactionIsolationLevel::SERIALIZABLE)
616 617 618 619 620
        );
    }

    public function testCannotGenerateTransactionCommandWithInvalidIsolationLevel()
    {
Sergei Morozov's avatar
Sergei Morozov committed
621
        $this->expectException(InvalidArgumentException::class);
622

Sergei Morozov's avatar
Sergei Morozov committed
623
        $this->platform->getSetTransactionIsolationSQL('invalid_transaction_isolation_level');
624 625 626 627
    }

    public function testModifiesLimitQuery()
    {
628
        self::assertEquals(
629
            'SELECT TOP 10 * FROM user',
Sergei Morozov's avatar
Sergei Morozov committed
630
            $this->platform->modifyLimitQuery('SELECT * FROM user', 10, 0)
631 632 633 634 635
        );
    }

    public function testModifiesLimitQueryWithEmptyOffset()
    {
636
        self::assertEquals(
637
            'SELECT TOP 10 * FROM user',
Sergei Morozov's avatar
Sergei Morozov committed
638
            $this->platform->modifyLimitQuery('SELECT * FROM user', 10)
639 640 641 642 643
        );
    }

    public function testModifiesLimitQueryWithOffset()
    {
644
        self::assertEquals(
645
            'SELECT TOP 10 START AT 6 * FROM user',
Sergei Morozov's avatar
Sergei Morozov committed
646
            $this->platform->modifyLimitQuery('SELECT * FROM user', 10, 5)
647
        );
648
        self::assertEquals(
649
            'SELECT TOP ALL START AT 6 * FROM user',
Sergei Morozov's avatar
Sergei Morozov committed
650
            $this->platform->modifyLimitQuery('SELECT * FROM user', 0, 5)
651 652 653 654 655
        );
    }

    public function testModifiesLimitQueryWithSubSelect()
    {
656
        self::assertEquals(
657
            'SELECT TOP 10 * FROM (SELECT u.id as uid, u.name as uname FROM user) AS doctrine_tbl',
Sergei Morozov's avatar
Sergei Morozov committed
658
            $this->platform->modifyLimitQuery('SELECT * FROM (SELECT u.id as uid, u.name as uname FROM user) AS doctrine_tbl', 10)
659 660 661 662 663
        );
    }

    public function testPrefersIdentityColumns()
    {
Sergei Morozov's avatar
Sergei Morozov committed
664
        self::assertTrue($this->platform->prefersIdentityColumns());
665 666 667 668
    }

    public function testDoesNotPreferSequences()
    {
Sergei Morozov's avatar
Sergei Morozov committed
669
        self::assertFalse($this->platform->prefersSequences());
670 671 672 673
    }

    public function testSupportsIdentityColumns()
    {
Sergei Morozov's avatar
Sergei Morozov committed
674
        self::assertTrue($this->platform->supportsIdentityColumns());
675 676 677 678
    }

    public function testSupportsPrimaryConstraints()
    {
Sergei Morozov's avatar
Sergei Morozov committed
679
        self::assertTrue($this->platform->supportsPrimaryConstraints());
680 681 682 683
    }

    public function testSupportsForeignKeyConstraints()
    {
Sergei Morozov's avatar
Sergei Morozov committed
684
        self::assertTrue($this->platform->supportsForeignKeyConstraints());
685 686 687 688
    }

    public function testSupportsForeignKeyOnUpdate()
    {
Sergei Morozov's avatar
Sergei Morozov committed
689
        self::assertTrue($this->platform->supportsForeignKeyOnUpdate());
690 691 692 693
    }

    public function testSupportsAlterTable()
    {
Sergei Morozov's avatar
Sergei Morozov committed
694
        self::assertTrue($this->platform->supportsAlterTable());
695 696 697 698
    }

    public function testSupportsTransactions()
    {
Sergei Morozov's avatar
Sergei Morozov committed
699
        self::assertTrue($this->platform->supportsTransactions());
700 701 702 703
    }

    public function testSupportsSchemas()
    {
Sergei Morozov's avatar
Sergei Morozov committed
704
        self::assertFalse($this->platform->supportsSchemas());
705 706 707 708
    }

    public function testSupportsIndexes()
    {
Sergei Morozov's avatar
Sergei Morozov committed
709
        self::assertTrue($this->platform->supportsIndexes());
710 711 712 713
    }

    public function testSupportsCommentOnStatement()
    {
Sergei Morozov's avatar
Sergei Morozov committed
714
        self::assertTrue($this->platform->supportsCommentOnStatement());
715 716 717 718
    }

    public function testSupportsSavePoints()
    {
Sergei Morozov's avatar
Sergei Morozov committed
719
        self::assertTrue($this->platform->supportsSavepoints());
720 721 722 723
    }

    public function testSupportsReleasePoints()
    {
Sergei Morozov's avatar
Sergei Morozov committed
724
        self::assertTrue($this->platform->supportsReleaseSavepoints());
725 726 727 728
    }

    public function testSupportsCreateDropDatabase()
    {
Sergei Morozov's avatar
Sergei Morozov committed
729
        self::assertTrue($this->platform->supportsCreateDropDatabase());
730 731 732 733
    }

    public function testSupportsGettingAffectedRows()
    {
Sergei Morozov's avatar
Sergei Morozov committed
734
        self::assertTrue($this->platform->supportsGettingAffectedRows());
735 736 737 738
    }

    public function testDoesNotSupportSequences()
    {
Sergei Morozov's avatar
Sergei Morozov committed
739
        self::assertFalse($this->platform->supportsSequences());
740 741 742 743
    }

    public function testDoesNotSupportInlineColumnComments()
    {
Sergei Morozov's avatar
Sergei Morozov committed
744
        self::assertFalse($this->platform->supportsInlineColumnComments());
745 746 747 748
    }

    public function testCannotEmulateSchemas()
    {
Sergei Morozov's avatar
Sergei Morozov committed
749
        self::assertFalse($this->platform->canEmulateSchemas());
750
    }
Steve Müller's avatar
Steve Müller committed
751 752 753

    public function testInitializesDoctrineTypeMappings()
    {
Sergei Morozov's avatar
Sergei Morozov committed
754 755
        self::assertTrue($this->platform->hasDoctrineTypeMappingFor('integer'));
        self::assertSame('integer', $this->platform->getDoctrineTypeMapping('integer'));
756

Sergei Morozov's avatar
Sergei Morozov committed
757 758
        self::assertTrue($this->platform->hasDoctrineTypeMappingFor('binary'));
        self::assertSame('binary', $this->platform->getDoctrineTypeMapping('binary'));
Steve Müller's avatar
Steve Müller committed
759

Sergei Morozov's avatar
Sergei Morozov committed
760 761
        self::assertTrue($this->platform->hasDoctrineTypeMappingFor('varbinary'));
        self::assertSame('binary', $this->platform->getDoctrineTypeMapping('varbinary'));
Steve Müller's avatar
Steve Müller committed
762 763 764 765 766 767 768 769 770 771 772 773 774 775
    }

    protected function getBinaryDefaultLength()
    {
        return 1;
    }

    protected function getBinaryMaxLength()
    {
        return 32767;
    }

    public function testReturnsBinaryTypeDeclarationSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
776 777 778
        self::assertSame('VARBINARY(1)', $this->platform->getBinaryTypeDeclarationSQL([]));
        self::assertSame('VARBINARY(1)', $this->platform->getBinaryTypeDeclarationSQL(['length' => 0]));
        self::assertSame('VARBINARY(32767)', $this->platform->getBinaryTypeDeclarationSQL(['length' => 32767]));
Steve Müller's avatar
Steve Müller committed
779

Sergei Morozov's avatar
Sergei Morozov committed
780 781 782
        self::assertSame('BINARY(1)', $this->platform->getBinaryTypeDeclarationSQL(['fixed' => true]));
        self::assertSame('BINARY(1)', $this->platform->getBinaryTypeDeclarationSQL(['fixed' => true, 'length' => 0]));
        self::assertSame('BINARY(32767)', $this->platform->getBinaryTypeDeclarationSQL(['fixed' => true, 'length' => 32767]));
783 784 785 786
    }

    /**
     * @group legacy
787
     * @expectedDeprecation Binary field length 32768 is greater than supported by the platform (32767). Reduce the field length or use a BLOB field instead.
788 789 790
     */
    public function testReturnsBinaryTypeLongerThanMaxDeclarationSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
791 792
        self::assertSame('LONG BINARY', $this->platform->getBinaryTypeDeclarationSQL(['length' => 32768]));
        self::assertSame('LONG BINARY', $this->platform->getBinaryTypeDeclarationSQL(['fixed' => true, 'length' => 32768]));
Steve Müller's avatar
Steve Müller committed
793
    }
794 795 796 797 798 799

    /**
     * @group DBAL-234
     */
    protected function getAlterTableRenameIndexSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
800
        return ['ALTER INDEX idx_foo ON mytable RENAME TO idx_bar'];
801 802 803 804 805 806 807
    }

    /**
     * @group DBAL-234
     */
    protected function getQuotedAlterTableRenameIndexSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
808
        return [
809 810
            'ALTER INDEX "create" ON "table" RENAME TO "select"',
            'ALTER INDEX "foo" ON "table" RENAME TO "bar"',
Sergei Morozov's avatar
Sergei Morozov committed
811
        ];
812
    }
813 814 815 816 817 818

    /**
     * {@inheritdoc}
     */
    protected function getQuotedAlterTableRenameColumnSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
819
        return [
820 821 822 823 824 825 826 827 828
            'ALTER TABLE mytable RENAME unquoted1 TO unquoted',
            'ALTER TABLE mytable RENAME unquoted2 TO "where"',
            'ALTER TABLE mytable RENAME unquoted3 TO "foo"',
            'ALTER TABLE mytable RENAME "create" TO reserved_keyword',
            'ALTER TABLE mytable RENAME "table" TO "from"',
            'ALTER TABLE mytable RENAME "select" TO "bar"',
            'ALTER TABLE mytable RENAME quoted1 TO quoted',
            'ALTER TABLE mytable RENAME quoted2 TO "and"',
            'ALTER TABLE mytable RENAME quoted3 TO "baz"',
Sergei Morozov's avatar
Sergei Morozov committed
829
        ];
830
    }
831

832 833 834 835 836 837 838 839
    /**
     * {@inheritdoc}
     */
    protected function getQuotedAlterTableChangeColumnLengthSQL()
    {
        $this->markTestIncomplete('Not implemented yet');
    }

840 841 842 843 844
    /**
     * @group DBAL-807
     */
    protected function getAlterTableRenameIndexInSchemaSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
845
        return ['ALTER INDEX idx_foo ON myschema.mytable RENAME TO idx_bar'];
846 847 848 849 850 851 852
    }

    /**
     * @group DBAL-807
     */
    protected function getQuotedAlterTableRenameIndexInSchemaSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
853
        return [
854 855
            'ALTER INDEX "create" ON "schema"."table" RENAME TO "select"',
            'ALTER INDEX "foo" ON "schema"."table" RENAME TO "bar"',
Sergei Morozov's avatar
Sergei Morozov committed
856
        ];
857
    }
858 859 860 861 862 863

    /**
     * @group DBAL-423
     */
    public function testReturnsGuidTypeDeclarationSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
864
        self::assertSame('UNIQUEIDENTIFIER', $this->platform->getGuidTypeDeclarationSQL([]));
865
    }
866 867 868 869 870 871

    /**
     * {@inheritdoc}
     */
    public function getAlterTableRenameColumnSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
872
        return ['ALTER TABLE foo RENAME bar TO baz'];
873
    }
874 875 876 877 878 879

    /**
     * {@inheritdoc}
     */
    protected function getQuotesTableIdentifiersInAlterTableSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
880
        return [
881 882 883 884 885 886 887
            'ALTER TABLE "foo" DROP FOREIGN KEY fk1',
            'ALTER TABLE "foo" DROP FOREIGN KEY fk2',
            'ALTER TABLE "foo" RENAME id TO war',
            'ALTER TABLE "foo" ADD bloo INT NOT NULL, DROP baz, ALTER bar INT DEFAULT NULL',
            'ALTER TABLE "foo" RENAME "table"',
            'ALTER TABLE "table" ADD CONSTRAINT fk_add FOREIGN KEY (fk3) REFERENCES fk_table (id)',
            'ALTER TABLE "table" ADD CONSTRAINT fk2 FOREIGN KEY (fk2) REFERENCES fk_table2 (id)',
Sergei Morozov's avatar
Sergei Morozov committed
888
        ];
889
    }
890 891 892 893 894 895

    /**
     * {@inheritdoc}
     */
    protected function getCommentOnColumnSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
896
        return [
897 898 899
            'COMMENT ON COLUMN foo.bar IS \'comment\'',
            'COMMENT ON COLUMN "Foo"."BAR" IS \'comment\'',
            'COMMENT ON COLUMN "select"."from" IS \'comment\'',
Sergei Morozov's avatar
Sergei Morozov committed
900
        ];
901 902 903 904 905 906 907
    }

    /**
     * @group DBAL-1004
     */
    public function testAltersTableColumnCommentWithExplicitlyQuotedIdentifiers()
    {
Sergei Morozov's avatar
Sergei Morozov committed
908 909
        $table1 = new Table('"foo"', [new Column('"bar"', Type::getType('integer'))]);
        $table2 = new Table('"foo"', [new Column('"bar"', Type::getType('integer'), ['comment' => 'baz'])]);
910 911 912 913 914

        $comparator = new Comparator();

        $tableDiff = $comparator->diffTable($table1, $table2);

Sergei Morozov's avatar
Sergei Morozov committed
915
        self::assertInstanceOf(TableDiff::class, $tableDiff);
916
        self::assertSame(
Sergei Morozov's avatar
Sergei Morozov committed
917
            ['COMMENT ON COLUMN "foo"."bar" IS \'baz\''],
Sergei Morozov's avatar
Sergei Morozov committed
918
            $this->platform->getAlterTableSQL($tableDiff)
919 920
        );
    }
921 922 923 924 925 926

    /**
     * {@inheritdoc}
     */
    public function getReturnsForeignKeyReferentialActionSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
927 928 929 930 931 932 933 934
        return [
            ['CASCADE', 'CASCADE'],
            ['SET NULL', 'SET NULL'],
            ['NO ACTION', 'RESTRICT'],
            ['RESTRICT', 'RESTRICT'],
            ['SET DEFAULT', 'SET DEFAULT'],
            ['CaScAdE', 'CASCADE'],
        ];
935
    }
936 937 938 939 940 941 942 943 944 945 946 947 948 949 950 951 952

    /**
     * {@inheritdoc}
     */
    protected function getQuotesReservedKeywordInUniqueConstraintDeclarationSQL()
    {
        return 'CONSTRAINT "select" UNIQUE (foo)';
    }

    /**
     * {@inheritdoc}
     */
    protected function getQuotesReservedKeywordInIndexDeclarationSQL()
    {
        return ''; // not supported by this platform
    }

953 954 955 956 957 958 959 960
    /**
     * {@inheritdoc}
     */
    protected function getQuotesReservedKeywordInTruncateTableSQL()
    {
        return 'TRUNCATE TABLE "select"';
    }

961 962 963 964 965 966 967
    /**
     * {@inheritdoc}
     */
    protected function supportsInlineIndexDeclaration()
    {
        return false;
    }
968 969 970 971 972 973

    /**
     * {@inheritdoc}
     */
    protected function getAlterStringToFixedStringSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
974
        return ['ALTER TABLE mytable ALTER name CHAR(2) NOT NULL'];
975
    }
976 977 978 979 980 981

    /**
     * {@inheritdoc}
     */
    protected function getGeneratesAlterTableRenameIndexUsedByForeignKeySQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
982
        return ['ALTER INDEX idx_foo ON mytable RENAME TO idx_foo_renamed'];
983
    }
984 985 986 987 988 989

    /**
     * @group DBAL-2436
     */
    public function testQuotesSchemaNameInListTableColumnsSQL()
    {
990
        self::assertContains(
991
            "'Foo''Bar\\'",
Sergei Morozov's avatar
Sergei Morozov committed
992
            $this->platform->getListTableColumnsSQL("Foo'Bar\\.baz_table"),
993 994 995 996 997 998 999 1000 1001 1002
            '',
            true
        );
    }

    /**
     * @group DBAL-2436
     */
    public function testQuotesTableNameInListTableConstraintsSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
1003
        self::assertContains("'Foo''Bar\\'", $this->platform->getListTableConstraintsSQL("Foo'Bar\\"), '', true);
1004 1005 1006 1007 1008 1009 1010
    }

    /**
     * @group DBAL-2436
     */
    public function testQuotesSchemaNameInListTableConstraintsSQL()
    {
1011
        self::assertContains(
1012
            "'Foo''Bar\\'",
Sergei Morozov's avatar
Sergei Morozov committed
1013
            $this->platform->getListTableConstraintsSQL("Foo'Bar\\.baz_table"),
1014 1015 1016 1017 1018 1019 1020 1021 1022 1023
            '',
            true
        );
    }

    /**
     * @group DBAL-2436
     */
    public function testQuotesTableNameInListTableForeignKeysSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
1024
        self::assertContains("'Foo''Bar\\'", $this->platform->getListTableForeignKeysSQL("Foo'Bar\\"), '', true);
1025 1026 1027 1028 1029 1030 1031
    }

    /**
     * @group DBAL-2436
     */
    public function testQuotesSchemaNameInListTableForeignKeysSQL()
    {
1032
        self::assertContains(
1033
            "'Foo''Bar\\'",
Sergei Morozov's avatar
Sergei Morozov committed
1034
            $this->platform->getListTableForeignKeysSQL("Foo'Bar\\.baz_table"),
1035 1036 1037 1038 1039 1040 1041 1042 1043 1044
            '',
            true
        );
    }

    /**
     * @group DBAL-2436
     */
    public function testQuotesTableNameInListTableIndexesSQL()
    {
Sergei Morozov's avatar
Sergei Morozov committed
1045
        self::assertContains("'Foo''Bar\\'", $this->platform->getListTableIndexesSQL("Foo'Bar\\"), '', true);
1046 1047 1048 1049 1050 1051 1052
    }

    /**
     * @group DBAL-2436
     */
    public function testQuotesSchemaNameInListTableIndexesSQL()
    {
1053
        self::assertContains(
1054
            "'Foo''Bar\\'",
Sergei Morozov's avatar
Sergei Morozov committed
1055
            $this->platform->getListTableIndexesSQL("Foo'Bar\\.baz_table"),
1056 1057 1058 1059
            '',
            true
        );
    }
1060
}