Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SQL Syntax Error due to Three Backticks and 'sql' Keyword in generated response. #151

Closed
sinjup opened this issue Jan 16, 2024 · 1 comment · Fixed by #157
Closed

SQL Syntax Error due to Three Backticks and 'sql' Keyword in generated response. #151

sinjup opened this issue Jan 16, 2024 · 1 comment · Fixed by #157
Assignees
@zainhoda

Comments

@sinjup
Copy link

sinjup commented Jan 16, 2024

Some SQL generated contain three backticks along with the 'SQL' keyword, resulting in an error when executing the SQL query.

Error details:
image

These additional contents in the response need to be eliminated.
@zainhoda
Copy link
Contributor

Thanks -- we'll add validation for this

@zainhoda zainhoda self-assigned this Jan 17, 2024
@zainhoda zainhoda linked a pull request Jan 17, 2024 that will close this issue
Parse out sql from code block #157
Merged
@github-project-automation github-project-automation bot moved this from Todo to Done in Vanna AI Project Status Jan 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@zainhoda zainhoda

Labels
None yet
Projects
Vanna AI Project Status
Status: Done
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Parse out sql from code block vanna-ai/vanna
2 participants
@zainhoda @sinjup