codefori / codefori/vscode-db2i

Delay system response after using the CSV: feature in DB2 for IBM i queries

Open
#437 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
TypeScript
Stars
76
Forks
54
Avg merge
17m
Merged PRs (30d)
1

Description

I have been noticing a problem not necessarily caused by the DB2 for IBM i extension, where actions like Run SQL Statement command (Ctrl+R) to run the query statement does not seem to be working. I at times think I did not press the key sequence. Many things VS Code slow down also, which is why I don't specifically thinks its just this extension.

There is no indication that anything is happening. Nothing obvious in the VS Code process explorer. Then after around a minute or two the Run SQL Statement will start up. If I think I did not properly press Ctrl+R then I press it again and after a minute or two I get a results tab for each time I pressed Ctrl+R.

If I don't press Ctrl+R to produce a CSV results for a few minutes then the system works as expected but will stop working as described above.

I only noticed this with CSV and not with the results in the output channel. I don't see this with the JSON results output as I don't use that form.

**To Reproduce**

Steps to reproduce the behavior:
1. Build a query
2. Prepend `CSV:` to the statement
3. Press Ctrl+R
4. Close the opened tab when done.
5. Repeat until you notice Ctrl+R does not seem to be doing anything.

**Expected behavior**

VS Code to perform the Run SQL Statement command.
I think

**Screenshots**

Too difficult to capture this in this form.

**Environment**

- OS: Windows 11
- Extension Version 1.14.0

**Additional context**

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the delay using the Run SQL Statement command (Ctrl+R) with a query prefixed by CSV:, repeating the steps until the response is delayed. Compare CSV behavior with the output channel and JSON results, and consider the issue resolved when repeated CSV runs respond promptly without duplicate result tabs.

Written by the indexing model from the issue text.

Assessment

Tech stack
typescript, vscode
Domain
databases, devtools
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.