WAIT_STATS_CAPTURE_MODE error

[deej79]

Type: Bug

Script to recreate db, tables and data, generated from ADS or SSMS, includes and ALTER statement ending in WAIT_STATS_CAPTURE_MODE = ON which both ADS and SSMS report as incorrect syntax. Full line (from the script) is:

ALTER DATABASE [vsmanager] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 30), DATA_FLUSH_INTERVAL_SECONDS = 900, INTERVAL_LENGTH_MINUTES = 60, MAX_STORAGE_SIZE_MB = 1000, QUERY_CAPTURE_MODE = AUTO, SIZE_BASED_CLEANUP_MODE = AUTO, MAX_PLANS_PER_QUERY = 200, WAIT_STATS_CAPTURE_MODE = ON)

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	Intel(R) Xeon(R) CPU E3-1230 v5 @ 3.40GHz (8 x 3408)
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.92GB (6.24GB free)
Process Argv
Screen Reader	no
VM	0%

Extensions (14)

Extension	Author (truncated)	Version
newdatabase	kev	1.0.0
admin-pack	Mic	0.0.2
admin-tool-ext-win	Mic	0.1.3
agent	Mic	0.49.0
import	Mic	1.6.1
powershell	ms-	2022.7.2
profiler	Mic	0.14.0
query-history	Mic	0.5.3
schema-compare	Mic	1.21.0
sql-database-projects	Mic	1.4.2
schema-visualization	R0t	0.9.1
db-snapshot-creator	sea	0.1.0
simple-data-scripter	sea	0.1.6
vscodeintellicode	Vis	1.2.1