JRobTS opened a new issue, #18665:
URL: https://github.com/apache/druid/issues/18665
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 HOUR,
MILLIS_TO_TIMESTAMP(0) + INTERVAL 1 DAY,
MILLIS_TO_TIMESTAMP(0) + INTERVAL 7 DAY,
MILLIS_TO_TIMESTAMP(0) + INTERVAL 14 DAY,
MILLIS_TO_TIMESTAMP(0) + INTERVAL 1 WEEK,
MILLIS_TO_TIMESTAMP(0) + INTERVAL 2 WEEK
```
Expected Results:
```
EXPR$0,EXPR$1,EXPR$2,EXPR$3,EXPR$4,EXPR$5
1970-01-01T01:00:00.000Z,1970-01-02T00:00:00.000Z,1970-01-08T00:00:00.000Z,1970-01-15T00:00:00.000Z,1970-01-08T00:00:00.000Z,1970-01-15T00:00:00.000Z
```
Actual Results:
```
EXPR$0,EXPR$1,EXPR$2,EXPR$3,EXPR$4,EXPR$5
1970-01-01T01:00:00.000Z,1970-01-02T00:00:00.000Z,1970-01-08T00:00:00.000Z,1970-01-15T00:00:00.000Z,1970-01-01T01:00:00.000Z,1970-01-01T02:00:00.000Z
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
