Getting Unsupported filter scalar: int32(3) while executing query which filters dayofweek
- Dominant language
- Rust
- Stars
- 20.8k
- Forks
- 2.1k
- Avg merge
- 1d 2h
- Merged PRs (30d)
- 181
Description
**Failed SQL**
```sql
select
'b2c_orders' as metric_name,
measure(b2c_orders) as metric_value,
date_trunc('week', time) as time
from product_revenue
where dayofweek <= EXTRACT(DOW from current_date)
GROUP by 1,3
```
**Logical Plan**
Not able to get the logical plan, getting the same error while appending "explain" keyword to the query.
**Error**
postgresql error: Error during rewrite: Unexpected panic. Reason: Unsupported filter scalar: Int32(4). Please check logs for additional information.
**Version:**
0.34.36
**Additional context**
1. dayofweek is a simple dimension of type number in the cube 'product_revenue'
2. If I use a constant value on the either side of the filter, for eg: '2 <= EXTRACT(DOW from current_date)', or 'dayofweek <= 2', it works just fine.
Contributor guide
Assessment
This issue has not been assessed yet.