Editor Incorrectly Interprets Backslashes As Escape Sequences

[sivan-koren]

Type: Bug

Example:

SET @sheetname = (SELECT RTRIM(REPLACE(RIGHT([file], CHARINDEX('\', REVERSE([file])) - 1), '.xlsx', '')) FROM @files WHERE [file] = @file)

In the above example CHARINDEX('\' is correctly interpreted by GitHub's tsql code block parsing, and by SSMS. However, ADS Editor pane appears to incorrectly interpret the backslash as an escape character and misses the end of the quoted string leaving the rest of the text in the editor pane displayed as a quoted string.

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

System Info

Item	Value
CPUs	AMD Ryzen 9 5900 12-Core Processor (24 x 2994)
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)	31.92GB (20.70GB free)
Process Argv
Screen Reader	no
VM	0%

Extensions (12)

Extension	Author (truncated)	Version
admin-pack	Mic	0.0.2
admin-tool-ext-win	Mic	0.1.3
agent	Mic	0.49.0
azuredatastudio-mysql	Mic	1.0.0
dacpac	Mic	1.14.0
import	Mic	1.6.1
powershell	ms-	2022.12.1
profiler	Mic	0.14.0
query-history	Mic	0.5.3
sql-assessment	Mic	0.6.4
azdata-sanddance	msr	4.1.1
code-settings-sync	Sha	3.4.3