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 900 forks source link

Table Designer Error #24123

Open mfwatson opened 1 year ago

mfwatson commented 1 year ago

Type: Bug

Any edit of a table in table designer generates the following error:

Table schema validation failed with error: One or more errors occured during validation.1. The element dfa_data_3 is not supported in Microsoft Azure SQL Database v12.

Azure Data Studio version: azuredatastudio 1.45.1 (88c21b1725a3e79440027bdb7b5a55fb036be0e2, 2023-08-03T00:42:37.945Z) OS version: Windows_NT x64 10.0.22621 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|11th Gen Intel(R) Core(TM) i9-11900K @ 3.50GHz (16 x 3504)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: disabled_off
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.61GB (31.23GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions: none
mfwatson commented 1 year ago

Is there a workaround?

cheenamalhotra commented 1 year ago

@mfwatson

Can you provide your table schema for analysis to reproduce error? Also please let us know what is the database version SELECT @@VERSION where this table belongs to? (I couldn't reproduce this error in a dummy Azure SQL database table)

mfwatson commented 1 year ago

I'm a complete newbie. Is this what you want?

CREATE TABLE [AMI_DATA].[AMI_Test] ( [meterNo] NUMERIC (18) NULL, [accountNumber] NUMERIC (18) NULL, [servLoc] NUMERIC (18) NULL, [intervalStartDTTM] DATETIME NULL, [UOM] VARCHAR (100) NULL, [intervalvalue] NUMERIC (19, 4) NULL );

Microsoft SQL Azure (RTM) - 12.0.2000.8 Jul 17 2023 18:40:52 Copyright (C) 2022 Microsoft Corporation

cheenamalhotra commented 1 year ago

Hi @mfwatson

What is "dfa_data_3" element in your scenario? Are you trying to add a new column in designer? Can you provide table definition from generated script by selecting "Generate Script" in the dialog when trying to publish changes?

mfwatson commented 1 year ago

dfa_data_3 means nothing to me, I assume Azure generated it as an interim step.

All I did was uncheck the allow nulls checkbox and hit publish changes.

kisantia commented 1 year ago

@maur1ce-m @mfwatson does generate script work? Or does the error show even before the "Preview Database Updates" shows? I was also not able to repro this when trying to add a new table (same one as in #24494) to a general purpose serverless db.

kisantia commented 1 year ago

Another thing to try to help narrow down the problem - can you try creating a sql project and creating a project from the database, add the new table to the project, then publish/generate script and see if that works?

DanielSaager commented 2 weeks ago

I've got the same error. Fresh created database server, database and table. Comp Level 160. Just want to add a column. But it doesn't matter what you try: Change column name, add index. image

Azure Data Studio 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.22631