Chat2DB icon indicating copy to clipboard operation
Chat2DB copied to clipboard

Bug: sql table name does not exist

Open yegetables opened this issue 2 years ago • 0 comments

Chat2DB Version

2.0.1

Describe the bug

When converting natural language to sql to do multi-table association query, the most suitable name cannot be automatically found based on the existing table name, and a table name that does not exist is generated. For example, in the figure below, the relational table of the database is role_permission_ref, and the relational tables in the generated SQL are named role_permission and permissionio_role.

image

Suggested solution: The prompt word requires the use of existing indications to find the table that best matches the description.

yegetables avatar Jul 10 '23 12:07 yegetables