doctrine / dbal

        self::assertFalse($diff, "no changes expected.");

    }

    public function testFulltextIndex()

    {

        $table = new Table('fulltext_index');

        $table->addColumn('text', 'text');

        $table->addIndex(array('text'), 'f_index');

        $table->addOption('engine', 'MyISAM');

        $index = $table->getIndex('f_index');

        $index->addFlag('fulltext');

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

        $indexes = $this->_sm->listTableIndexes('fulltext_index');

        self::assertArrayHasKey('f_index', $indexes);

        self::assertTrue($indexes['f_index']->hasFlag('fulltext'));

    }

    public function testSpatialIndex()

    {

        self::assertTrue($indexes['f_index']->hasFlag('fulltext'));

    }

    public function testSpatialIndex()

    {

        $table = new Table('spatial_index');

        $table->addColumn('point', 'point');

        $table->addIndex(array('point'), 's_index');

        $table->addOption('engine', 'MyISAM');

        $index = $table->getIndex('s_index');

        $index->addFlag('spatial');

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

        $indexes = $this->_sm->listTableIndexes('spatial_index');

        self::assertArrayHasKey('s_index', $indexes);

        self::assertTrue($indexes['s_index']->hasFlag('spatial'));

    }

    /**

     * @group DBAL-400