When the require_interval_qualifier dialect option was added (#1398), the main concern was PostgreSQL. Modern clickhouse supports all of:
unquoted intervals
SELECT INTERVAL 1 DAY;
┌─toIntervalDay(1)─┐
1. │ 1 │
└──────────────────┘
quoted intervals
SELECT INTERVAL '1 d';
┌─toIntervalDay(1)─┐
1. │ 1 │
└──────────────────┘
Mixed intervals
SELECT INTERVAL '1 2:3:4' DAY TO SECOND;
┌─(toIntervalDay(1), toIntervalHour(2), toIntervalMinute(3), toIntervalSecond(4))─┐
1. │ (1,2,3,4) │
└─────────────────────────────────────────────────────────────────────────────────┘
The fix should be as simple as flipping one boolean here
When the
require_interval_qualifierdialect option was added (#1398), the main concern was PostgreSQL. Modern clickhouse supports all of:unquoted intervals
quoted intervals
Mixed intervals
The fix should be as simple as flipping one boolean here