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.

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

Prettier error report #1380

Open
4 tasks
cmtheit opened this issue Sep 23, 2024 · 0 comments
Open
4 tasks

Prettier error report #1380

cmtheit opened this issue Sep 23, 2024 · 0 comments
Labels

Comments

@cmtheit
Copy link

cmtheit commented Sep 23, 2024

nclear bug reporting when excuting sql query.

A clear and concise description of what the bug is.

I always write wrong sql code when developing. Such as this code:

select dept_name from from dept;

The 'from' here is undoubtable an error. But with offitial Postgresql driver, I just get this error:
ScreenShot-2024-09-23_11-44-28
When it's a small query I can exactly find where it locates. But when query statement get larger, it's hard to locate the issue reported with only issue position such as "at character 199".

To Reproduce
Steps to reproduce the behavior:

  1. Connect to any database with postgresql official driver.
  2. Open vscode command panel and run "SQLTools: Run Query"
  3. Write a obvious wrong sql query such as the one shown above.
  4. See the shown error

Expected behavior
I try to connect to manually by psql -U user dbname and run command by typing. It give me the error position which can help a lot for me to locating the issue of my code:

ERROR:  syntax error at or near "from"
LINE 1: select dept_name from from dept;

So I think if the error report just copy the output of the naitive connector, what's wrong with it?

Screenshots
ScreenShot-2024-09-23_11-55-00

Desktop (please complete the following information):

  • SQLTools Version v0.28.3
  • VS Code Version: 1.93
  • OS: Windows docker: Linux dev container
  • Driver:
    • [ *] PostgreSQL/Redshift
    • MySQL/MariaDB
    • MSSQL/Azure
    • SQLite
    • Other? Which...
  • Database version: Postgresql 16.2

Additional context
I have no deep in it if it is because of driver's issue. If it is, I would transfer this issue to the driver vscode plugin.
Thank you.

@cmtheit cmtheit added the triage label Sep 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant