all-project/backend/debug_compatibility_type.sql

-- 调试compatibility_type字段问题
-- 检查表结构
DESCRIBE jcbt_scholarship_type;

-- 检查字段是否存在
SHOW COLUMNS FROM jcbt_scholarship_type LIKE 'compatibility_type';

-- 查看具体数据
SELECT id, type_name, compatibility_type,
       CASE
         WHEN compatibility_type IS NULL THEN 'NULL值'
         WHEN compatibility_type = '' THEN '空字符串'
         ELSE CONCAT('有值:', compatibility_type)
       END as value_status
FROM jcbt_scholarship_type
WHERE deleted = 0
LIMIT 10;

-- 统计各种值的分布
SELECT
    compatibility_type,
    COUNT(*) as count,
    CASE
      WHEN compatibility_type IS NULL THEN 'NULL值'
      WHEN compatibility_type = '' THEN '空字符串'
      ELSE '有效值'
    END as value_type
FROM jcbt_scholarship_type
WHERE deleted = 0
GROUP BY compatibility_type;