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已放款人数"
}