Save to CSV corrupts data (in CSV)

[RobvanB]

Type: Bug

• Run a query that generates a large set of data (40K rows, 5 columns)
• click the icon to 'save to csv' from the result grid
• File is saved, but in some (many) scenarios the data in the file is mixed up (single column value repeated in all columns)

Azure Data Studio version: azuredatastudio 1.48.0 (4970733, 2024-02-27T00:05:08.293Z)
OS version: Windows_NT x64 10.0.19045
Restricted Mode: No
Preview Features: Enabled
Modes:

System Info

Item	Value
CPUs	13th Gen Intel(R) Core(TM) i7-1370P (20 x 2189)
GPU Status	2d_canvas: enabled canvas_oop_rasterization: enabled_on 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 video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: enabled
Load (avg)	undefined
Memory (System)	15.64GB (4.64GB free)
Process Argv
Screen Reader	no
VM	0%

Extensions: none

[cssuh]

Hi @RobvanB, can you share a sample of the data set where you're seeing this issue? I'm trying to reproduce on my end but not able to so far

[kburtram]

@lewis-sanchez could you please try to reproduce this issue and fix as needed?

[lewis-sanchez]

Hi @RobvanB, I haven't been able to repro this issue. Is it possible for you to attach console or application logs to help identify what the cause of this is? Thanks!

[github-actions]

We need more info to debug your particular issue. If you could attach your logs to the issue (ensure no private data is in them), it would help us fix the issue much faster.

1. First open the Settings page, find the Mssql: Tracing Level setting and change that to All then restart Azure Data Studio.
2. Open command palette (Click View -> Command Palette) and run the command Developer: Set Log Level... and set the level to Trace.
3. Run the repro scenarios.
4. Collect the following logs:

Console Logs

• Open Developer Tools (Help -> Toggle Developer Tools)
• Click the Console tab
• Click in the log area and select all text (CTRL+A)
• Save this text into a file named console.log and attach it to this issue.
• Developer Tools can be closed via Help -> Toggle Developer Tools

Application Logs

• Open command palette (Click View -> Command Palette)
• Run the command: Developer: Open Logs Folder
• This will open the log folder locally. Please zip up this folder and attach it to the issue.

5. Now you can revert the Log/Tracing levels changes made in step 1 and step 2.