Errors when updating any table with Azure Data Studio

[shipht2d]

Type: Bug

I'm getting varied errors when trying to use azure data studio to update tables. e.g. when trying to update a column name.

The errors occur on publish/save.

The following are the latest errors:

Table schema validation failed with error: One or more errors occured during validation. 1. Trigger: [dbo].[trg_LogStatusOnChange] has an unresolved reference to object [inserted]. 2. Trigger: [dbol. [trg_LogStatusOnChange] has an unresolved reference to object [deleted]. 3. Trigger: [dbo].[trg_LogStatusOnAssignmentOrderCreation] has an unresolved reference to object [inserted]. 4. The element data_1 is not supported in Microsoft Azure SQL Database v12. 5. The element data_2 is not supported in Microsoft Azure SQL Database V12.

When i use scripts or the windows version of SQL Management Studio v19, I do not get this errors.

Azure Data Studio version: azuredatastudio 1.48.0 (4970733324ef8254b7c22a5dc55af7f8a1dea93f, 2024-02-26T20:59:15.629Z) OS version: Darwin arm64 23.3.0 Restricted Mode: No Preview Features: Enabled Modes:

System Info

Item	Value
CPUs	Apple M2 (8 x 24)
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)	3, 3, 3
Memory (System)	24.00GB (0.07GB free)
Process Argv
Screen Reader	no
VM	0%

Extensions (9)

Extension	Author (truncated)	Version
admin-pack	Mic	0.0.2
agent	Mic	0.49.0
dacpac	Mic	1.14.0
datavirtualization	Mic	1.14.0
import	Mic	1.6.1
profiler	Mic	0.14.0
schema-compare	Mic	1.21.0
sql-database-projects	Mic	1.4.2
schema-visualization	R0t	0.9.1

(1 theme extensions excluded)

[marcodeiulio]

Same problem here. I get similar errors whenever i try to update a table using ADS, but I don't get any using SSMS 19. My colleagues experience the same problem, too.

Version: 1.48.0 (system setup) Commit: 4970733324ef8254b7c22a5dc55af7f8a1dea93f Date: 2024-02-27T00:05:08.293Z VS Code: 1.82.0 Electron: 25.9.8 Chromium: 114.0.5735.289 Node.js: 18.15.0 V8: 11.4.183.29-electron.0 OS: Windows_NT x64 10.0.22631

[EwenH]

Likewise as per @shipht2d and @marcodeiulio.

I have a simple table with an underlying view retrieving one column on that table. In Azure Data Studio

1. Click on table and select Design
2. Append a new field called ratio, float
3. Save <<< Error as below

Table schema validation failed with error: One or more errors occured during validation.1. View: [dbo].[vwMyView] has an unresolved reference to object [dbo].[DimMyTable].

In SSMS 20

1. Edit the same table as above
2. Append a new field called ratio, float
3. Save <<< Success

** ADS Details ** Version: 1.49.1 (system setup) Commit: 2f696aa95a13ccabd7e0a4431d1d759e3a7b8cfd Date: 2024-08-13T18:12:38.831Z VS Code: 1.82.0 Electron: 25.9.8 Chromium: 114.0.5735.289 Node.js: 18.15.0 V8: 11.4.183.29-electron.0 OS: Windows_NT x64 10.0.17763