Chat2DB
Chat2DB copied to clipboard
Bug: sql table name does not exist
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.
Suggested solution: The prompt word requires the use of existing indications to find the table that best matches the description.