Skip to content

implement orderedmap to all tools to preserve column order in SQL restults #1492

@feng-1985

Description

@feng-1985

Prerequisites

Question

I am using the ToolboxClient (with mysql), and notice that the sql statement's column order is not the same with the result of sql.

Such as: sql statement in the yaml
"select start_time, end_time, course_date from course"

when check the input of llm (the result of sql) or run tool using toolbox ui:
{"course_date":"2025-09-15", "end_time":"2025-09-15 10:10:00", "start_time":"2025-09-15 11:30:00"}

It seems very subtle, but sometime confuse the llm the understanding when the order is meaningful.

Code

No response

Additional Details

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    priority: p2Moderately-important priority. Fix may not be included in next release.status: help wantedStatus: Unplanned work open to contributions from the community.type: questionRequest for information or clarification.

    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