doctrine / dbal

     * @link https://mariadb.com/kb/en/library/information-schema-columns-table/

     * @link https://dev.mysql.com/doc/refman/5.5/en/string-literals.html

     */

    public function testColumnDefaultValuesDoubleQuoted(): void

    {

        $table = new Table("test_column_default_values_double_quoted");

        $table->addColumn('string_nullable_quoted', 'string', ['notnull' => false, 'default' => 'NULL']);

        $table->addColumn('string_nullable_double_quoted', 'string', ['notnull' => false, 'default' => "'NULL'"]);

        $table->addColumn('string_notnull_quoted', 'string', ['notnull' => true, 'default' => 'NULL']);

        //$table->addColumn('string_notnull_double_quoted', 'string', ['notnull' => true, 'default' => "\\'NULL\\'"]);

        $this->_sm->dropAndCreateTable($table);

        $onlineTable = $this->_sm->listTableDetails("test_column_default_values_double_quoted");

        self::assertSame('NULL', $onlineTable->getColumn('string_nullable_quoted')->getDefault());

        self::assertSame("'NULL'", $onlineTable->getColumn('string_nullable_double_quoted')->getDefault());

        self::assertSame("NULL", $onlineTable->getColumn('string_notnull_quoted')->getDefault());

        //self::assertSame("'NULL'", $onlineTable->getColumn('string_notnull_double_quoted')->getDefault());

        $comparator = new Comparator();

        $diff = $comparator->diffTable($table, $onlineTable);

        $this->assertFalse($diff, "Tables should be identical with double quoted literals.");

    }

    public function testColumnDefaultCurrentTimestamp(): void

     *

     * @link https://mariadb.com/kb/en/library/string-literals

     */

    public function testColumnDefaultValuesEscaping(): void

    {

        $table = new Table("test_column_default_values_escaping");

        $table->addColumn('no_quotes', 'string', ['notnull' => false, 'default' => 'az']);

        $table->addColumn('backslash', 'string', ['notnull' => false, 'default' => 'a\\\z']);

        $table->addColumn('repeated_single_quotes', 'string', ['notnull' => false, 'default' => "a''z"]);

        $this->_sm->dropAndCreateTable($table);

        $onlineTable = $this->_sm->listTableDetails("test_column_default_values_escaping");

        self::assertSame("az", $onlineTable->getColumn('no_quotes')->getDefault());

        self::assertSame('a\\\z', $onlineTable->getColumn('backslash')->getDefault());

        self::assertSame("a''z", $onlineTable->getColumn('repeated_single_quotes')->getDefault());

        $comparator = new Comparator();

        $diff = $comparator->diffTable($table, $onlineTable);

        $this->assertFalse($diff, "Tables should be identical with values escape sequences.");

    }

    public function testColumnDefaultsUsingDoctrineTable(): void

    {