INTERVAL 1 WEEK in SQL is wrong interval

[JRobTS]

The INTERVAL 1 WEEK syntax in SQL is resolving to PT1H.

Affected Version

Found in Apache Druid 33.0.0

Description

Most easily detected by running this SQL query in Unified Console Workbench:

SELECT 
  MILLIS_TO_TIMESTAMP(0) + INTERVAL 1 WEEK,
  MILLIS_TO_TIMESTAMP(0) + INTERVAL 2 WEEK

Expected Results:

EXPR$0,EXPR$1
1970-01-08T00:00:00.000Z,1970-01-15T00:00:00.000Z

Actual Results:

EXPR$0,EXPR$1
1970-01-01T01:00:00.000Z,1970-01-01T02:00:00.000Z