search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.55k stars 898 forks source link

Editing data in one column affects the cell content in another column #25531

Open rmoldwin opened 6 months ago

rmoldwin commented 6 months ago

Type: Bug

I am using an edit-data window for a query on a sql server table. I modify the sql in the edit window sql pane in various ways to filter the rows retrieved. When I edit data in column 9, the UI also overwrites the data in column 13. Fortunately, the overwritten data is not saved to the database when I move to another row. I am not able to reproduce this in a new test table, but the bug is persistent in my existing table, over several editing sessions.

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

System Info |Item|Value| |---|---| |CPUs|12th Gen Intel(R) Core(TM) i9-12900HK (20 x 2918)| |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)|63.69GB (15.75GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (6) Extension|Author (truncated)|Version ---|---|--- admin-pack|Mic|0.0.2 agent|Mic|0.49.0 dacpac|Mic|1.14.0 import|Mic|1.6.1 profiler|Mic|0.14.0 azdata-sanddance|msr|4.1.1
smartguest commented 5 months ago

So far, creating a simple test table with data, using a where filter for different names and numerical values, the table edits were consistent with where I wanted them to be.

Can you please tell us what the affected column names are, what sort of filter conditions are used in your query, how many entries are currently in the table and if it has been edited by previous ADS versions?

Also, does this bug also reproduce in SSMS as well?

Just interested to see how I can reproduce this issue closely. @rmoldwin