vanna
vanna copied to clipboard
Vanna can't retrieve the updated data that was just submitted
Describe the bug Using vanna to query the mysql database, it can't retrieve the updated record that was just submitted.
To Reproduce Steps to reproduce the behavior:
- Ask a question: 'Please query all mails that are at risk', then the result is 7.
- Update the table Emails's column 'is_risk' to 1, and then commit this transaction.
- Ask the same question again, then the result is still 7.
- When I execute the generated SQL statement in an IDE such as DataGrip, the result of the query is 8
Expected behavior The second question's result should be 8.
Error logs/Screenshots There has no error log.
Desktop (please complete the following information where):
- OS: [Ubuntu 22.04.4 LTS、MacOS 12.7.3]
- Version: [0.6.0]
- Python: [3.10]
- Vanna: [0.6.0]
Additional context No addition context.