Failed to analyze trim function for integer as parameter

[MajeedB]

Hello Team,
Unable validate below expression.

Select trim(5)

Expected : Tool should catch exception. It should throw exception like parameter is incorrect.

Actual : simply validating as correct expression

Please resolve this issue.

[dion-ricky]

Tested working on my setup:

As you can see the analyzer raises a SqlException with message saying No matching signature for function TRIM for argument types: INT64. ...

The analyzed query is exactly as you've provided, here's the watcher from my debugger showing the value of analyzed query:

Is there something that i'm missing? Please let me know.

[MajeedB]

I am trying catch the error using below code

analyzer. analyzeStatements(myQuery, this.Catlog, true)

Unable to catch the error msg.