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.58k stars 908 forks source link

Azure data studio is setting the identify column +1000 on its own #26004

Open bfinnegan7675 opened 3 weeks ago

bfinnegan7675 commented 3 weeks ago

Type: Bug

Several times I've seen my tables in azure data studio updating the identity column from the single digits to over 1000, without any explanation.

I have never seen this in sql server manager. This is very bizarre, this is a newer database that we are just starting to put data into. But all the tables decided to increment the identity seeds simultaneously by 1000.Image Image Image Image

Azure Data Studio version: azuredatastudio 1.49.1 (2f696aa95a13ccabd7e0a4431d1d759e3a7b8cfd, 2024-08-13T18:12:38.831Z) OS version: Windows_NT x64 10.0.19045 Restricted Mode: No Preview Features: Disabled Modes:

System Info |Item|Value| |---|---| |CPUs|Intel(R) Xeon(R) Gold 6248R CPU @ 3.00GHz (4 x 3000)| |GPU Status|2d_canvas: unavailable_software
canvas_oop_rasterization: disabled_off
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: disabled_software
multiple_raster_threads: enabled_on
opengl: disabled_off
rasterization: disabled_software
raw_draw: disabled_off_ok
video_decode: disabled_software
video_encode: disabled_software
vulkan: disabled_off
webgl: unavailable_software
webgl2: unavailable_software
webgpu: unavailable_software| |Load (avg)|undefined| |Memory (System)|16.00GB (2.88GB free)| |Process Argv|| |Screen Reader|no| |VM|100%|
Extensions: none
kburtram commented 3 weeks ago

@bfinnegan7675 Thanks for bringing this up.

This behavior seems unusual, as the Azure Data Studio (ADS) query editor only executes the queries explicitly provided in the editor window (along with some standard SET options based on your query execution settings). Given the way query execution is implemented, it’s not immediately clear how this issue could specifically be caused by ADS.

Could you please provide additional reproduction steps or more detailed information to help us recreate the error? This will allow us to better investigate the problem.