双 blob 字段 purge/rollback 导致表空间 fseg not full list 损坏

SELECT
    t1.TABLE_SCHEMA,
    t1.TABLE_NAME,
    t1.COLUMN_NAME,
    t1.DATA_TYPE
FROM
    INFORMATION_SCHEMA.COLUMNS t1
INNER JOIN (
    -- 子查询：先找出符合条件（特定类型列数 >= 2）的表
    SELECT
        TABLE_SCHEMA,
        TABLE_NAME
    FROM
        INFORMATION_SCHEMA.COLUMNS
    WHERE
        DATA_TYPE IN ('blob', 'mediumblob', 'longblob', 'json', 'text', 'MEDIUMTEXT', 'LONGTEXT', 'geometry')
        AND TABLE_SCHEMA IN ('xxx', 'xxxx') -- 请替换为实际库名
    GROUP BY
        TABLE_SCHEMA,
        TABLE_NAME
    HAVING
        COUNT(*) >= 2
) t2 ON t1.TABLE_SCHEMA = t2.TABLE_SCHEMA AND t1.TABLE_NAME = t2.TABLE_NAME
WHERE
    -- 外层再次过滤类型，确保只列出造成风险的列
    t1.DATA_TYPE IN ('blob', 'mediumblob', 'longblob', 'json', 'text', 'MEDIUMTEXT', 'LONGTEXT', 'geometry');

SELECT
    TABLE_SCHEMA,
    TABLE_NAME,
    COUNT(*) as risky_column_count,
    GROUP_CONCAT(COLUMN_NAME) as risky_columns -- 可选：将列名合并显示在一行
FROM
    INFORMATION_SCHEMA.COLUMNS
WHERE
    DATA_TYPE IN ('blob', 'mediumblob', 'longblob', 'json', 'text', 'MEDIUMTEXT', 'LONGTEXT', 'geometry')
    AND TABLE_SCHEMA IN ('xxx', 'xxxx')
GROUP BY
    TABLE_SCHEMA,
    TABLE_NAME
HAVING
    COUNT(*) >= 2;