CodePhiliaX / Chat2DB

🔥🔥🔥AI-driven database tool and SQL client, The hottest GUI client, supporting MySQL, Oracle, PostgreSQL, DB2, SQL Server, DB2, SQLite, H2, ClickHouse, and more.
http://chat2db.ai
Apache License 2.0
16.91k stars 1.89k forks source link

Bug: mysql生成的语句存在不符预期 #243

Closed weiwangchina closed 1 year ago

weiwangchina commented 1 year ago

Chat2DB Version

Windows Current Env:desktop Current Version:v2.0.2 build20230712082201

Describe the bug

查询dws_doctor_detail表的总数量,条件是 办事处编码 字段包含 "acccd", "bffg", 并且 删除状态为0,根据医生主键进行去重复

SELECT COUNT(DISTINCT doctor_id) FROM dws_doctor_detail WHERE office_code LIKE '%acccd%' AND office_code LIKE '%bffg%' AND delete_flag = 0

具体日志如: SQL input: 查询dws_doctor_detail表的总数量,条件是 办事处编码 字段包含 "acccd", "bffg", 并且 删除状态为0,根据医生主键进行去重复 2023-07-14 13:29:10.341 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.37 : | OpenAI建立sse连接... 2023-07-14 13:29:10.341 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"role":"assistant","content":""},"finish_reason":null}]} 2023-07-14 13:29:10.341 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"SELECT"},"finish_reason":null}]} 2023-07-14 13:29:10.362 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" COUNT"},"finish_reason":null}]} 2023-07-14 13:29:10.375 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"(D"},"finish_reason":null}]} 2023-07-14 13:29:10.443 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"IST"},"finish_reason":null}]} 2023-07-14 13:29:10.444 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"INCT"},"finish_reason":null}]} 2023-07-14 13:29:10.472 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" doctor"},"finish_reason":null}]} 2023-07-14 13:29:10.502 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"_id"},"finish_reason":null}]} 2023-07-14 13:29:10.520 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":")"},"finish_reason":null}]} 2023-07-14 13:29:10.551 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" \n"},"finish_reason":null}]} 2023-07-14 13:29:10.588 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"FROM"},"finish_reason":null}]} 2023-07-14 13:29:10.624 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" d"},"finish_reason":null}]} 2023-07-14 13:29:10.643 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"ws"},"finish_reason":null}]} 2023-07-14 13:29:10.670 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"_do"},"finish_reason":null}]} 2023-07-14 13:29:10.694 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"ctor"},"finish_reason":null}]} 2023-07-14 13:29:10.723 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"_detail"},"finish_reason":null}]} 2023-07-14 13:29:10.751 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" \n"},"finish_reason":null}]} 2023-07-14 13:29:10.775 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"WHERE"},"finish_reason":null}]} 2023-07-14 13:29:10.808 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" office"},"finish_reason":null}]} 2023-07-14 13:29:10.839 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"_code"},"finish_reason":null}]} 2023-07-14 13:29:10.861 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" LIKE"},"finish_reason":null}]} 2023-07-14 13:29:10.899 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" '%"},"finish_reason":null}]} 2023-07-14 13:29:10.921 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"ac"},"finish_reason":null}]} 2023-07-14 13:29:10.949 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"ccd"},"finish_reason":null}]} 2023-07-14 13:29:10.976 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"%'"},"finish_reason":null}]} 2023-07-14 13:29:11.005 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" \n"},"finish_reason":null}]} 2023-07-14 13:29:11.031 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" "},"finish_reason":null}]} 2023-07-14 13:29:11.074 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" AND"},"finish_reason":null}]} 2023-07-14 13:29:11.085 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" office"},"finish_reason":null}]} 2023-07-14 13:29:11.266 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"_code"},"finish_reason":null}]} 2023-07-14 13:29:11.286 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" LIKE"},"finish_reason":null}]} 2023-07-14 13:29:11.288 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" '%"},"finish_reason":null}]} 2023-07-14 13:29:11.290 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"bff"},"finish_reason":null}]} 2023-07-14 13:29:11.294 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"g"},"finish_reason":null}]} 2023-07-14 13:29:11.296 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"%'"},"finish_reason":null}]} 2023-07-14 13:29:11.297 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" \n"},"finish_reason":null}]} 2023-07-14 13:29:11.325 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" "},"finish_reason":null}]} 2023-07-14 13:29:11.366 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" AND"},"finish_reason":null}]} 2023-07-14 13:29:11.388 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" delete"},"finish_reason":null}]} 2023-07-14 13:29:11.429 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"_flag"},"finish_reason":null}]} 2023-07-14 13:29:11.446 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" ="},"finish_reason":null}]} 2023-07-14 13:29:11.475 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":" "},"finish_reason":null}]} 2023-07-14 13:29:11.505 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{"content":"0"},"finish_reason":null}]} 2023-07-14 13:29:11.531 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:{"id":"chatcmpl-7c5eYe6YL1kwMTmZYlWyrbxAimacs","object":"chat.completion.chunk","created":1689312550,"model":"gpt-3.5-turbo-0613","choices":[{"index":0,"delta":{},"finish_reason":"stop"}]} 2023-07-14 13:29:11.533 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.46 : | OpenAI返回数据:[DONE] 2023-07-14 13:29:11.533 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.48 : | OpenAI返回数据结束了 2023-07-14 13:29:11.535 INFO 20240 --- [OkHttp http://test.sqlgpt.cn/...] .c.s.w.a.c.a.l.OpenAIEventSourceListener.75 : | OpenAI关闭sse连接... 2023-07-14 13:29:11.536 INFO 20240 --- [http-nio-127.0.0.1-10824-exec-4] a.chat2db.server.start.log.EasyLogSink .67 : | http : GET|/api/ai/chat?message=%E6%9F%A5%E8%AF%A2dws_doctor_detail%E8%A1%A8%E7%9A%84%E6%80%BB%E6%95%B0%E9%87%8F%EF%BC%8C%E6%9D%A1%E4%BB%B6%E6%98%AF+%E5%8A%9E%E4%BA%8B%E5%A4%84%E7%BC%96%E7%A0%81+%E5%AD%97%E6%AE%B5%E5%8C%85%E5%90%AB+%22acccd%22%2C+%22bffg%22%2C+%E5%B9%B6%E4%B8%94+%E5%88%A0%E9%99%A4%E7%8A%B6%E6%80%81%E4%B8%BA0%EF%BC%8C%E6%A0%B9%E6%8D%AE%E5%8C%BB%E7%94%9F%E4%B8%BB%E9%94%AE%E8%BF%9B%E8%A1%8C%E5%8E%BB%E9%87%8D%E5%A4%8D&promptType=NL_2_SQL&dataSourceId=3&databaseName=crm&tableNames=bpc_grass_root_sales_income&tableNames=crm_apply_config_audit_route&tableNames=crm_apply_config_audit_route_log&tableNames=crm_apply_config_depart_data&tableNames=crm_apply_config_depart_person_type&tableNames=crm_apply_depart_rela_org_type&tableNames=crm_apply_depart_rela_org_type_copy&tableNames=crm_apply_depart_rela_sub_category|7774|| 2023-07-14 13:29:11.538 INFO 20240 --- [http-nio-127.0.0.1-10824-exec-4] a.c.s.w.a.controller.ai.ChatController .405 : | 2023-07-14T13:29:11.538528200, uid#9c1bc8da-9fe0-4656-8ae8-324541df3d5c, on completion 2023-07-14 13:29:11.546 INFO 20240 --- [http-nio-127.0.0.1-10824-exec-1] c.d.forest.logging.DefaultLogHandler .21 : fc14a582-7469-422c-8e0e-3eb6690a6681 | [Forest] Request (okhttp3): GET http://test.sqlgpt.cn/gateway/api/client/remaininguses/7daafdd488b04769a1477c35f11996308mp0TihMguA0pqJgR6swzsuXKn7UV19qwOisXfxU7ApjtUwaUPa8NM5A HTTP Headers: User-Agent: forest/1.5.32 2023-07-14 13:29:13.617 INFO 20240 --- [http-nio-127.0.0.1-10824-exec-1] c.d.forest.logging.DefaultLogHandler .21 : fc14a582-7469-422c-8e0e-3eb6690a6681 | [Forest] Response: Status = 200, Time = 2069ms 2023-07-14 13:29:13.617 INFO 20240 --- [http-nio-127.0.0.1-10824-exec-1] c.d.forest.logging.DefaultLogHandler .21 : fc14a582-7469-422c-8e0e-3eb6690a6681 | [Forest] Response Content: {"success":true,"errorCode":null,"errorMessage":null,"data":{"key":"7daafdd488b04769a1477c35f11996308mp0TihMguA0pqJgR6swzsuXKn7UV19qwOisXfxU7ApjtUwaUPa8NM5A","expiry":4799711893949,"remainingUses":23,"wechatMpUrl":"https://oss-chat2db.alibaba.com/static/wechat.webp"},"traceId":null} 2023-07-14 13:29:13.619 INFO 20240 --- [http-nio-127.0.0.1-10824-exec-1] a.chat2db.server.start.log.EasyLogSink .67 : fc14a582-7469-422c-8e0e-3eb6690a6681 | http : GET|/api/ai/config/remaininguses|2075||{"success":true,"errorCode":null,"errorMessage":null,"errorDetail":null,"solutionLink":null,"data":{"key":"7daafdd488b04769a1477c35f11996308mp0TihMguA0pqJgR6swzsuXKn7UV19qwOisXfxU7ApjtUwaUPa8NM5A","expiry":4799711893949,"remainingUses":23,"wechatMpUrl":"https://oss-chat2db.alibaba.com/static/wechat.webp"},"traceId":null}

weiwangchina commented 1 year ago

image

字段,预期应当使用对应数据库表结构中存在的 is_deleted 字段; 而不是生成的 delete_flag 字段

chenxian01 commented 1 year ago

I don't get your question. Do you mean that the ai return the wrong statement with delete_flag but not is_delete?

chenxian01 commented 1 year ago

By the way, the data returned by ai cannot guarantee 100% accuracy which is well known.

chenxian01 commented 1 year ago

Closed as not updated for a long time.