it silently return no record without telling the error (PC) or it says the object (my function) does not exist (in fact it does, just because of error)

[wsusys]

• MSSQL Extension Version: not sure as cloud hosting. But it is totally OK with SSMS or Datagrip
• VSCode Version: Latest, 1.97.2
• mssql extension: latest release 1.29.0 27Feb25
• OS Version: win 11 home single language, build 26100.3194 and MacOS 15.3

I am moving to using Mac and thus have to quit SMSS and first I used ADS then I found that it is phasing out soon, so I move to mssql for VS Code as any is new for me and don't want to get used with ADS and sooner have to move again. It also explains why I have both PC and Mac above

Steps to Reproduce:

1. I have a very simple table valued function. I define the result table and then insert from a table with some conditions/filter (but dont focus on this)
2. the field length in the result table is shorter than the data being inserted
3. I select * from function and it returns no records which is impossible WITHOUT any error message. After cluelessly investigation I found that because of the filed length.
4. I ran it on DataGrip, it tells me the error. And of cause on SMSS too.
5. on my Mac (mini M2, macos 15.3) with the same function it says that the object (function) not exists.

please fix or help me how to hot fix.

[cssuh]

@wsusys this issue is fixed in the most recent release, 1.30 so I will close this.

[kburtram]

Copies from #19061

Re: [microsoft/vscode-mssql] it silently return no record without telling the error (PC) or it says the object (my function) does not exist (in fact it does, just because of error) (Issue #18898)

thank you for paying attention to this issue, however, the problem is still there. Attached file is the screenshot of my vs code extention version and simulation

Thank you

Untitled document.pdf

[kburtram]

@cssuh could you please follow up to confirm what's happening here and whether the intended fix is working as expected?