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 (7099922, 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 (efd470b, 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 efd470b
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: eb3c0f5
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 👍

[bbirtle]

I'm having the issue described, with exactly the same steps to reproduce. It seems intermittent, but very frequent. In some (all?) cases, the clipboard finally does get the expected contents only after a long delay (and no progress/activity indication).

I tried also saving to Excel and in that case, a popup window appears and takes ages to finally save the file.

Perhaps is this related to the other very major issue that connections to SQL Server take an insanely long time (also very frequently)? Although I haven't ruled out that issue could be something to do with my particular server and unrelated to the Azure client software.

If you need further details or I should open a new bug report please let me know. I'm using the latest version of macOS and connecting in this case to a server running on Windows Server 2019 and SQL Server 2019, with encryption enabled, Trust Server Certificate enabled, and SQL Login (via a private VPN relay to avoid man in middle attacks under this configuration).

I will in the meantime try @jelitter 's solution (and other workarounds).

TIA! 🙏 😃

[plmosqueda]

Hi, im having this issue on Linux Debian and Fedora too :-(

[Charles-Gagnon]

@plmosqueda Can you try the latest insiders build? We recently fixed an issue with copy on Linux which will be included in the next release - #24341

[plmosqueda]

@Charles-Gagnon Thank you man. Works really good on Debian 12. I will try later o Fedora.