The hash join does not support inequality yet. Try nested loop join by setting:
alter system set `planner.enable_nljoin_for_scalar_only` = false;
And change the LEFT to a regular join followed by an inequality predicate:
```
SELECT m.startdate as monthdate, COUNT(distinct
Using a calendar table with monthly start and end dates, I am attempting
to count records in another table that has cycle start and end dates.
In PostgreSQL I would either use a date range type, or in standard SQL
do something like:
```
SELECT m.startdate as monthdate, COUNT(distinct