all-project/backend/sql/test_fix_result.sql

-- ================================================================
-- 测试 teacher_name 字段修复结果
-- 文件: test_fix_result.sql
-- 功能: 验证修复是否成功
-- ================================================================

USE hzdyjs_xg;

-- 1. 检查表结构
SELECT '=== 检查表结构 ===' AS message;
SHOW CREATE TABLE jcbt_poverty_application;

-- 2. 检查关键字段属性
SELECT '=== 检查关键字段属性 ===' AS message;
SELECT
    COLUMN_NAME AS '字段名',
    DATA_TYPE AS '数据类型',
    IS_NULLABLE AS '允许NULL',
    COLUMN_DEFAULT AS '默认值',
    COLUMN_COMMENT AS '注释'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'hzdyjs_xg'
  AND TABLE_NAME = 'jcbt_poverty_application'
  AND COLUMN_NAME IN ('teacher_id', 'teacher_name')
ORDER BY ORDINAL_POSITION;

-- 3. 测试插入记录（不包含teacher_name）
SELECT '=== 测试插入记录 ===' AS message;

INSERT INTO jcbt_poverty_application (
    id, application_no, academic_year, term, student_id, student_no, student_name,
    gender, college_id, college_name, major_id, major_name, class_id, class_name,
    recognition_group, recognition_type_id, recognition_type_name, assistance_types,
    status, create_by, create_time, tenant_id
) VALUES (
    999999999, 'TEST001', '2024-2025', 1, 1001, '202401001', '测试学生',
    '1', 101, '计算机学院', 10101, '计算机科学', 1010101, '测试班级',
    '特殊群体', 1, '特困生', '助学金',
    'DRAFT', 103, NOW(), '000000'
);

-- 4. 查询测试记录
SELECT '=== 查询测试记录 ===' AS message;
SELECT
    id, student_name, teacher_id, teacher_name, status
FROM jcbt_poverty_application
WHERE id = 999999999;

-- 5. 清理测试数据
DELETE FROM jcbt_poverty_application WHERE id = 999999999;

SELECT '✅ 测试完成！如果没有错误，说明修复成功！' AS result;