vanna-ai / vanna

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

“ intermediate_sql” is included in the extracted sql #588

Open ihorizons2022 opened 3 months ago

ihorizons2022 commented 3 months ago

Describe the bug question: list all brand having social buy in 2024-07 model: gpt-4o-mini error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'intermediate_sql: select distinct brand from posts where brand_category l' at line 1")

To Reproduce Steps to reproduce the behavior:

  1. Go to '...'
  2. Click on '....'
  3. Scroll down to '....'
  4. See error

Expected behavior A clear and concise description of what you expected to happen.

Error logs/Screenshots If applicable, add logs/screenshots to give more information about the issue.

Desktop (please complete the following information where):

Additional context Add any other context about the problem here.