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

Copy Results mixing up column order #8323

Closed
maracucho1997 opened this issue Nov 13, 2019 · 2 comments
Closed

Copy Results mixing up column order #8323

maracucho1997 opened this issue Nov 13, 2019 · 2 comments

Comments

@maracucho1997
Copy link

Issue Type: Bug

When copying Results, the columns are not getting put in the clipboard in the same order as the output in the Results. Using Copy With Headers brings the headers in the right order, but the data in the columns does not belong to the same header. This doesn't happen every time, but I can reproduce it with certain queries.

Azure Data Studio version: azuredatastudio 1.13.0 (cacd481, 2019-11-02T00:40:05.147Z)
OS version: Windows_NT x64 10.0.18363

For example, using this query and copying to excel or notepad the third field when pasting is a number field from the 11th column.

Query:

SELECT IdNum = 10701, CaseStatus = 'Closed', DateTimeField = '2019-03-20 16:23:00.000', DateField = '2019-03-28'
, DateField2 = '2019-04-01'
, DateFieldNULL = NULL, DateField3 = '2019-06-06'
, IntNull = NULL, Int1 = 1, Int2 = 2, Int3 = 3, IntNull2 = NULL; 

Results from Copy With Headers:
IdNum CaseStatus DateTimeField DateField DateField2 DateFieldNULL DateField3 IntNull Int1 Int2 Int3 IntNull2
10701 Closed 3 NULL 2019-03-20 16:23:00.000 2019-03-28 2019-04-01 NULL 2019-06-06 NULL 1 2

image

@adsbot
Copy link

adsbot bot commented Nov 13, 2019

Thanks for submitting this issue. Please also check if it is already covered by an existing one, like:

@Charles-Gagnon
Copy link
Contributor

Closing as a duplicate of #8210

This has been fixed on the insiders build that you can install now - otherwise it'll be available in the next stable release. Sorry about the inconvenience!

@adsbot adsbot bot locked and limited conversation to collaborators Dec 28, 2019
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

3 participants