microsoft / microsoft/vscode-pgsql

MySQL query is using pgsql

Open
#181 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug
Dominant language
No language data
Stars
395
Forks
33
Avg merge
1h 46m
Merged PRs (30d)
3

Description

Type: Bug

🔴 Disconnected! To interact with the database, open a query editor with an active connection. Even I specify that this is Mysql 8.0 syntax

Extension version: 1.10.0
VS Code version: Code 1.105.1 (Universal) (7d842fb85a0275a4a8e4d7e040d2625abbf7f084, 2025-10-14T22:33:36.618Z)
OS version: Darwin arm64 23.5.0
Modes:

System Info
Item Value
CPUs Apple M1 Pro (10 x 2400)
GPU Status 2d_canvas: enabled
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
skia_graphite: enabled_on
trees_in_viz: disabled_off
video_decode: enabled
video_encode: enabled
webgl: enabled
webgl2: enabled
webgpu: enabled
webnn: disabled_off
Load (avg) 17, 12, 11
Memory (System) 16.00GB (0.19GB free)
Process Argv --crash-reporter-id 09da03d7-38dc-4145-9bd6-3af378ce4f32
Screen Reader no
VM 0%
A/B Experiments
vsliv368cf:30146710
binariesv615:30325510
nativeloc1:31344060
dwcopilot:31170013
dwoutputs:31242946
copilot_t_ci:31333650
e5gg6876:31282496
pythonrdcb7:31342333
6518g693:31334701
aj953862:31281341
nes-set-on:31351930
6abeh943:31336334
aa_t:31379598
gendocstringt:31405074
gaj49834:31404438
cloudbuttont:31379625
todos-1:31405332
v66_all_req:31402695
treatment_gpt5applypatchexclusively:31398171
3efgi100_wstrepl:31403338
trigger-command-fix:31379601
auto_model_enabled:31385282
use-responses-api:31390855
applesignin:31399435
9i271672:31399627
je187915:31401257
control_gfa0i828:31406506
3i15c187:31405349
ff8f5884:31411053

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

The report names no source files, tests, or entry points. Reproduce the issue in VS Code 1.105.1 with the PostgreSQL extension at 1.10.0 and a MySQL 8.0 syntax selection, then trace how the query editor chooses the SQL dialect and handles the disconnected state. Done means the selected MySQL syntax is respected and the reported query-editor behavior is corrected.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql, postgresql, sql, vscode
Domain
databases, devtools
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.