Description
Is there an existing issue for the same bug?
- I have checked the existing issues.
RAGFlow workspace code commit ID
123
RAGFlow image version
123
Other environment information
Actual behavior
[{'role': 'system', 'content': "You are a Database Administrator. You need to check the fields of the following tabl ... es based on the user's list of questions and write the SQL corresponding to the last question."}, {'role': 'user', ' ... content': '\nTable name: ragflow_6aeebce0f3fb11ef9d060242ac120004;\nTable of database fields are as follows:\ndan_we ... i_,xing_ming,shou_ji_hao,\r_tks: 单位,姓名,手机号,\r\n\nQuestion are as follows:\n赵婷是哪个单位的\nPlease write ... the SQL, only SQL, without any other explanations or text.\n'}] "You are a Database Administrator. You need to chec ... k the fields of the following tables based on the user's list of questions and write the SQL corresponding to the la ... st question."
这是通过chat 去生成 sql
select doc_id,docnm_kwd, dan_wei_, xing_ming_ from ragflow_6aeebce0f3fb11ef9d060242ac120004 where xing_ming_ = '赵婷'
xing_ming 变成了 xing_ming_ 导致 es Unknown column [xing_ming_]')
尝试过其他比如 gpt deepseek 都会把_xing_ming_ 改成 xing_ming_
Expected behavior
No response
Steps to reproduce
和ai 对话 [{'role': 'system', 'content': "You are a Database Administrator. You need to check the fields of the following tabl ... es based on the user's list of questions and write the SQL corresponding to the last question."}, {'role': 'user', ' ... content': '\nTable name: ragflow_6aeebce0f3fb11ef9d060242ac120004;\nTable of database fields are as follows:\ndan_we ... i_,_xing_ming_,_shou_ji_hao_,\r_tks: 单位,姓名,手机号,\r\n\nQuestion are as follows:\n赵婷是哪个单位的\nPlease write ... the SQL, only SQL, without any other explanations or text.\n'}] "You are a Database Administrator. You need to chec ... k the fields of the following tables based on the user's list of questions and write the SQL corresponding to the la ... st question."Additional information
No response