Showing no results while it should have a lot

[ansitan]

Type: Bug

When I put the below part into my main query, it shows nothing, whereas it should show error of "Divided by zero" or just return outputs

CAST((DUTY_COST/ FIRST_COST) AS DECIMAL(10,2)) AS TARIFF_PERCENTAGE

Please help investigate this in SQL Server extension

Extension version: 1.29.0
VS Code version: Code 1.97.2 (e54c774e0add60467559eb0d1e229c6452cf8447, 2025-02-12T23:20:35.343Z)
OS version: Windows_NT x64 10.0.22621
Modes:

System Info

Item	Value
CPUs	12th Gen Intel(R) Core(TM) i7-1270P (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 skia_graphite: disabled_off video_decode: enabled video_encode: enabled vulkan: disabled_off webgl: enabled webgl2: enabled webgpu: enabled webnn: disabled_off
Load (avg)	undefined
Memory (System)	15.24GB (0.88GB free)
Process Argv	--crash-reporter-id 0ac3381e-3999-4a55-aed8-21a028f37ead
Screen Reader	no
VM	0%

A/B Experiments

vsliv368:30146709
vspor879:30202332
vspor708:30202333
vspor363:30204092
vscod805:30301674
binariesv615:30325510
py29gd2263:31024239
c4g48928:30535728
azure-dev_surveyone:30548225
962ge761:30959799
2e7ec940:31000449
pythontbext0:30879054
cppperfnew:31000557
dwnewjupyter:31046869
nativerepl2:31139839
pythonrstrctxt:31112756
nativeloc2:31192216
iacca1:31171482
5fd0e150:31155592
dwcopilot:31170013
6074i472:31201624
dwoutputs:31242946
customenabled:31248079
9064b325:31222308
copilot_c_ci:31222729
jda6j935:31233686
copilothoveron:31248524
4d2d8976:31247581

[cssuh]

Closing this since it seems to be a duplicate of #18702. Please feel free to re-open and clarify if this is not the case.