Skip to content

Unable to work with month intervals #2796

@avantgardnerio

Description

@avantgardnerio

Describe the bug
When performing queries such as:

select date '1994-01-01' + interval '1' month as date;

I observe the following error:

`Err` value: "Execution(\"DateIntervalExpr does not support IntervalYearMonth\") at Optimizing logical plan for...

To Reproduce
Run the above query.

Expected behavior
1994-02-01

Additional context
Impact: Missing the month & year intervals are causing the TPC-H benchmarks to fail.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions