Skip to content

[BUG] 内置系统Prompt内SQL示例缺失GROUP BY子句,语法非法,误导模型生成错误SQL #1187

@Fit111

Description

@Fit111

SQLBot Version
1.9.0 专业版

Run Mode
安装包部署

Describe the bug

在 生成SQL阶段 的系统提示词中,出现 SQL 示例错误的问题,会影响模型生成 SQL 的准确性
把 订单ID、金额 和 COUNT(...) 写在一起,却没有 GROUP BY

  SELECT 
    "t1"."订单ID" AS "order_id",
    "t1"."金额" AS "amount",
    COUNT("t1"."订单ID") AS "total_orders",
    ROUND("t1"."折扣率" * 100, 2) || '%' AS "discount_percent"
  FROM "TEST"."ORDERS" "t1"
  LIMIT 100
Image

Metadata

Metadata

Labels

bugSomething isn't working

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions