Skip to content

[BUG] Oracle INTERVAL DAY TO HOUR incorrectly parsed as DAY TO MONTH #6405

Open
@chengxvyuanoom

Description

@chengxvyuanoom

Description:
When parsing Oracle SQL containing INTERVAL DAY TO HOUR, the parser incorrectly recognizes it as DAY TO MONTH, which is not a valid Oracle INTERVAL type.

Example:

-- Original SQL with DAY TO HOUR
INSERT INTO "TEST_TABLE" ("COL1") VALUES (INTERVAL '-''2 7' DAY(2) TO HOUR);

-- After parsing (incorrectly becomes DAY TO MONTH)
INSERT INTO "TEST_TABLE" ("COL1") VALUES (INTERVAL -'02 07' DAY(2) TO MONTH);

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions