@testing.requires.mysql_ngram_fulltext
@testing.provide_metadata
def test_reflect_fulltext_comment(self):
    mt = Table('mytable', self.metadata, Column('id', Integer, primary_key=True), Column('textdata', String(50)), mysql_engine='InnoDB')
    Index('textdata_ix', mt.c.textdata, mysql_prefix='FULLTEXT', mysql_with_parser='ngram')
    self.metadata.create_all(testing.db)
    mt = Table('mytable', MetaData(), autoload_with=testing.db)
    idx = list(mt.indexes)[0]
    eq_(idx.name, 'textdata_ix')
    eq_(idx.dialect_options['mysql']['prefix'], 'FULLTEXT')
    eq_(idx.dialect_options['mysql']['with_parser'], 'ngram')
    self.assert_compile(CreateIndex(idx), 'CREATE FULLTEXT INDEX textdata_ix ON mytable (textdata) WITH PARSER ngram')
@testing.requires.mysql_ngram_fulltext
@testing.provide_metadata
def test_reflect_fulltext_comment(self):
    mt = Table('mytable', self.metadata, Column('id', Integer, primary_key=True), Column('textdata', String(50)), mysql_engine='InnoDB')
    Index('textdata_ix', mt.c.textdata, mysql_prefix='FULLTEXT', mysql_with_parser='ngram')
    self.metadata.create_all(testing.db)
    mt = Table('mytable', MetaData(), autoload_with=testing.db)
    idx = list(mt.indexes)[0]
    eq_(idx.name, 'textdata_ix')
    eq_(idx.dialect_options['mysql']['prefix'], 'FULLTEXT')
    eq_(idx.dialect_options['mysql']['with_parser'], 'ngram')
    self.assert_compile(CreateIndex(idx), 'CREATE FULLTEXT INDEX textdata_ix ON mytable (textdata) WITH PARSER ngram')