SELECT
       TABLE_SCHEMA
     , TABLE_NAME
     , CONCAT('Table `', TABLE_SCHEMA, '.', TABLE_NAME, '` contains dangling FULLTEXT index. Kindly recreate the table before upgrade.') AS RESULT
FROM
       (
              SELECT
                     replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(substring_index(ist.NAME,'/',1),'@0040','@'),'@0025','%'),'@0023','#'),'@0024','$'),'@0021','!'),'@005e','^'),'@002a','*'),'@003f','?'),'@002e','.'),'@003e','>'),'@003c','<'),'@007c','|'),'@002d','-'),'@002b','+'),'@002c',','),'@0020',' ')                          AS TABLE_SCHEMA
                   , replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(substring_index(substring_index(ist.NAME,'/',-1),'#P',1),'@0040','@'),'@0025','%'),'@0023','#'),'@0024','$'),'@0021','!'),'@005e','^'),'@002a','*'),'@003f','?'),'@002e','.'),'@003e','>'),'@003c','<'),'@007c','|'),'@002d','-'),'@002b','+'),'@002c',','),'@0020',' ') AS TABLE_NAME
              FROM
                     INFORMATION_SCHEMA.INNODB_SYS_TABLES ist
                     JOIN
                            INFORMATION_SCHEMA.INNODB_SYS_COLUMNS isc
                            ON
                                   ist.TABLE_ID = isc.TABLE_ID
              WHERE
                     isc.NAME = 'FTS_DOC_ID'
                     AND ist.TABLE_ID NOT IN
                     (
                            SELECT DISTINCT
                                   TABLE_ID
                            FROM
                                   INFORMATION_SCHEMA.INNODB_SYS_INDEXES
                            WHERE
                                   TYPE = 32
                     )
       )
       AS R