doctrine / dbal

     * @group 2782

     * @group 6654

     */

    public function testComparatorShouldReturnFalseWhenLegacyJsonArrayColumnHasComment()

    {

        if ( ! $this->_sm->getDatabasePlatform()->hasNativeJsonType()) {

            $this->markTestSkipped('This test is only supported on platforms that have native JSON type.');

        }

        $table = new Table('json_array_test');

        $table->addColumn('id', 'integer');

        $table->addColumn('parameters', 'json_array');

        $table->setPrimaryKey(['id']);

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

        $comparator = new Comparator();

        $tableDiff  = $comparator->diffTable($this->_sm->listTableDetails('json_array_test'), $table);

        self::assertFalse($tableDiff);

        $this->_sm->dropTable('json_array_test');

    }

    /**

     * @group 2782

     * @group 2782

     * @group 6654

     */

    public function testComparatorShouldNotAddCommentToJsonTypeSinceItIsTheDefaultNow()

    {

        if ( ! $this->_sm->getDatabasePlatform()->hasNativeJsonType()) {

            $this->markTestSkipped('This test is only supported on platforms that have native JSON type.');

        }

        $this->_conn->executeQuery(

            'CREATE TABLE json_test (id INT NOT NULL, parameters JSON NOT NULL, PRIMARY KEY(id))'

        );

        $table = new Table('json_test');

        $table->addColumn('id', 'integer');

        $table->addColumn('parameters', 'json');

        $table->setPrimaryKey(['id']);

        $comparator = new Comparator();

        $tableDiff  = $comparator->diffTable($this->_sm->listTableDetails('json_test'), $table);

        $this->_sm->dropTable('json_test');

        self::assertFalse($tableDiff);

    }

}