Azuredatastudio: Copying query results to the clipboard does not always work

[sqlsauce]

Issue Type: Bug

Steps to repro:

1. On Windows 7, open SQL Operations Studio.
2. Run a SQL query (ad-hoc or stored procedure) that returns results.
3. Select and copy any part or all of the results using Ctrl-C or right-click and either Copy or Copy With Headers.

Expected result: query results are copied to the clipboard.

Actual result: query results are not copied to the clipboard and cannot be pasted.

SQL Operations Studio version: sqlops 0.29.3 (7099922c35bc3b3e223228c972cc03cee5abbe25, 2018-05-04T05:46:24.032Z)
OS version: Windows_NT x64 6.1.7601

System Info

|Item|Value|
|---|---|
|CPUs|Intel(R) Core(TM) i7-4810MQ CPU @ 2.80GHz (8 x 2793)|
|Memory (System)|7.88GB (1.07GB free)|
|Process Argv|C:\Program Files\SQL Operations Studio\sqlops.exe|
|Screen Reader|no|
|VM|0%|

Extensions (3)

Extension|Author (truncated)|Version
---|---|---
agent|Mic|0.29.0
server-report|Mic|0.1.2
whoisactive|Mic|0.1.1

Reproduces without extensions

[tigerhawkvok]

This has become more prevalent in the most recent release; I see it happen most of the time now, whereas it was previously "sometimes".

SQL Operations Studio version: sqlops 0.32.8 (efd470b3c771ef7473ba3cf108a33b6579c96a53, 2018-08-30T19:40:40.895Z)
OS version: Windows_NT x64 10.0.16299

System Info

|Item|Value|
|---|---|
|CPUs|Intel(R) Core(TM) i7-6700 CPU @ 3.40GHz (8 x 3408)|
|GPU Status|2d_canvas: enabled
flash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
native_gpu_memory_buffers: disabled_software
rasterization: disabled_software
video_decode: enabled
video_encode: enabled
vpx_decode: enabled
webgl: enabled
webgl2: enabled|
|Memory (System)|31.91GB (11.61GB free)|
|Process Argv|C:\Program Files\SQL Operations Studio\sqlops.exe|
|Screen Reader|no|
|VM|0%|

Extensions (6)

Extension|Author (truncated)|Version
---|---|---
bracket-pair-colorizer|Coe|1.0.59
vscode-emacs-friendly|lfs|0.8.2
agent|Mic|0.32.7
profiler|Mic|0.1.5
server-report|Mic|0.1.3
whoisactive|Mic|0.1.1

[nilamo]

I wish I knew how to describe this better. But it's like one out of four attempts to copy to the clipboard actually do as expected. Most of the time, it seems like nothing happened at all.

Version 0.32.8
Commit efd470b3c771ef7473ba3cf108a33b6579c96a53
Date 2018-08-30T19:40:40.895Z
VS Code 1.23.1
Shell 1.7.16
Renderer 58.0.3029.110
Node 7.9.0
Architecture x64

[aaomidi]

Can someone confirm that they're noticing this recently too? There's been a lot of changes made to the way copy/paste works and would be interested to see if this problem still exists.

[aaomidi]

Since there hasn't been any updates recently, I'll close this issue.

Please update or create a new issue with any specific issues you're seeing with the clipboard.

[marcselman]

I am still seeing this issue.

What I notice is that the data gets copied, but sometimes it takes seconds.
So if I copy then paste immediately I sometimes paste my old clipboard value.
If I then wait a couple of seconds the new value is available in the clipboard.

I know there has been a fix released but even with the latest version I'm still experiencing this.

[aaomidi]

Is the data larger than normal by any chance? Curious to see if there is some latency in copying to clipboard.

Also, out of curiosity what OS is it? For some features of the application, the way "copy" works is that it sends a JSON RPC call to a C# component, so I'm curious if there could be some latency in that call.

[marcselman]

No, just an integer from a single cell for example.

Windows 10, up-to-date.

[chengkiang]

I am getting this randomly on the Mac version. Sometimes, the copy would work, other times, it wouldn't. E.g. If I copy row 3 column 2, I can paste. Now, if I need row 5 col 6, I'd highlight that, Cmd-C, and when I Cmd-V, I am still getting the earlier piece that I copied (Row 3 Col 2). It's very annoying.

[jelitter]

Why was this closed when it's clearly not fixed ?

• When selecting a cell in results and pressing Ctrl + A, results lose focus and query gets selected instead.
• Ctrl + C does not copy selected cells.
• Right Click in results does not show a context menu.

---

Version: 1.24.0 (user setup)
Commit: eb3c0f5d9df86b9490606aab7fffaa253b0aca4d
Date: 2020-11-10T23:38:09.705Z
VS Code: 1.48.0
Electron: 9.3.0
Chrome: 83.0.4103.122
Node.js: 12.14.1
V8: 8.3.110.13-electron.0
OS: Windows_NT x64 10.0.19041

[dnaren]

• When selecting a cell in results and pressing Ctrl + A, results lose focus and query gets selected instead.
• Ctrl + C does not copy selected cells.
• Right Click in results does not show a context menu.

I was running into similar issues, even with the latest version of ADS. I was able to resolve my issues by deleting the %AppData%\azuredatastudio folder (effectively a factory reset of ADS).

PS: You'll need to re-configure your connections & any preferences you had before.

[jelitter]

• When selecting a cell in results and pressing Ctrl + A, results lose focus and query gets selected instead.
• Ctrl + C does not copy selected cells.
• Right Click in results does not show a context menu.

I was running into similar issues, even with the latest version of ADS. I was able to resolve my issues by deleting the %AppData%\azuredatastudio folder (effectively a factory reset of ADS).

PS: You'll need to re-configure your connections & any preferences you had before.

Thanks very much @dnaren , that worked 👍