search

vanna-ai / vanna

🤖 Chat with your SQL database 📊. Accurate Text-to-SQL Generation via LLMs using RAG 🔄.
https://vanna.ai/docs/
MIT License
9.12k stars 673 forks source link

Vanna can't retrieve the updated data that was just submitted #516

Open lixiaojiee opened 1 week ago

lixiaojiee commented 1 week ago

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:

  1. Ask a question: 'Please query all mails that are at risk', then the result is 7.
  2. Update the table Emails's column 'is_risk' to 1, and then commit this transaction.
  3. Ask the same question again, then the result is still 7.
  4. 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):

Additional context No addition context.