大模型使用本地部署的Qwen2.5-72B-Instruct功能好使,使用本地部署的qwen2.5-coder:7b时生成SQL报错。

SQLBot部署的1.9社区版。本地两个大模型,使用qwen2.5-coder:7b时不能完整输出约定 JSON 结构。在数据库custom_prompt表中增加全局 Prompt 不好使。
正常的返回是:

{
  "success": true,
  "sql": "SELECT COUNT(DISTINCT AAC001) AS LOANED_PEOPLE_COUNT FROM LEMIS_HBJY.DC94 WHERE ADC944 BETWEEN TO_DATE('2025-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2025-12-31 23:59:59', 'YYYY-MM-DD HH24:MI:SS') AND ROWNUM <= 1000",
  "tables": ["DC94"],
  "chart-type": "table"
}

错误的返回是:

{
  "sql": "SELECT COUNT(DISTINCT AAC001) AS LOANED_PEOPLE_COUNT FROM DC94 WHERE TO_CHAR(ADC944, 'yyyy') = '2025'",
  "chart_type": "bar",
  "dialog_title": "2025已放款人数"
}