vanna icon indicating copy to clipboard operation
vanna copied to clipboard

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

Open lixiaojiee opened this issue 8 months ago • 0 comments

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):

  • 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.

lixiaojiee avatar Jun 25 '24 03:06 lixiaojiee