Non-Existent File Display Issue with Wildcard Pattern in .sqlproj
Author: OzzianCreated Jul 10, 2024Updated Nov 4, 2025
Type: Bug
- Create a new SQL project (.sqlproj) with post-deployment scripts.
- Include post-deployment scripts in a separate folder.
- Use the wildcard pattern *.sql in the .sqlproj file to include the post-deployment scripts.
- Open the project in Azure Data Studio.
- Observe that the Data Studio shows a non-existent file "*.sql" in the UI under the folder
The relevant part in the .sqlproj file:
<ItemGroup>
<PostDeploy Include="Script.PostDeployment.sql" />
<None Include="PostDeployment\*.sql">
<CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
</None>
</ItemGroup>Extension version: 1.4.2 Azure Data Studio version: azuredatastudio 1.48.1 (8825ec21e67a34ede00e4f02a4afc692eb6cab61, 2024-06-13T21:07:19.253Z) OS version: Windows_NT x64 10.0.22631 Restricted Mode: No Preview Features: Enabled Modes:
System Info| Item | Value |
|---|---|
| CPUs | 11th Gen Intel(R) Core(TM) i7-11850H @ 2.50GHz (16 x 2496) |
| 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) | 63.71GB (44.46GB free) |
| Process Argv | |
| Screen Reader | no |
| VM | 0% |
Source: microsoft/azuredatastudio