long window: count where op with a rows bucket based pre-agg table may produce incorrect result

**Describe the feature you'd like**

```sql
deploy dp options (long_windows = 'w1:3')
select count_where(.....
```

`3` as a rows based bucket size, since there is a extra filter key for pre-agg table added, rows in pre-agg table, where their
ts_begin and ts_end value, are not aligned.

currently, this op (`*_where with rows bucket`) is turned off in #2255 -> compile time error

**Additional context**

Add any other context or screenshots about the feature request here.