google / google/googlesql

Failed to analyze trim function INT as argument

Open
#156 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
2.6k
Forks
260
PR merge metrics
No merged PRs in 30d

Description

Failed to analyze Big Query Trim function if INT passed as argument.
Select trim(5) is an incorrect statement because integer is not supported here as argument it should through an error.

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the GoogleSQL analyzer result for the expression `SELECT TRIM(5)`. Trace the trim function analysis path and its existing argument validation, then confirm that an integer argument produces an error rather than being accepted.

Written by the indexing model from the issue text.

Assessment

Tech stack
cpp, sql
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.