google / google/googlesql

Unexpected INTERVAL expression

Open
#127 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

Hello,

I am getting an `Unexpected INTERVAL expression` error while using the `analyzeStatement()` method on the following:

```sql
select timestamp_col - interval 1 day from `table_name`
```

How should I approach this query?

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the reported query with analyzeStatement() and inspect how the analyzer handles the INTERVAL expression. The issue does not name a source file or test; done would require determining whether this query should be accepted and capturing the expected behavior in an appropriate regression test or documented resolution.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.