kgyrtkirk commented on issue #15739:
URL: https://github.com/apache/druid/issues/15739#issuecomment-1911751261
some testcases which should start working if this is fixed:
```
type: "operatorValidation"
sql: |
SELECT
m1,
FLOOR(m1/3),
-- incorrect range frames https://github.com/apache/druid/issues/15739
1 >= COUNT(1) OVER (ORDER BY m1 ROWS BETWEEN 1 PRECEDING AND 1
PRECEDING),
1 >= COUNT(1) OVER (ORDER BY m1 ROWS BETWEEN 1 FOLLOWING AND 1
FOLLOWING),
1 >= COUNT(1) OVER (ORDER BY m1 RANGE BETWEEN 1 PRECEDING AND 1
PRECEDING),
1 >= COUNT(1) OVER (ORDER BY m1 RANGE BETWEEN 1 FOLLOWING AND 1
FOLLOWING),
-- not sure if this should be allowed or not; but if its allowed it
should be 0
0 = COUNT(1) OVER (ORDER BY FLOOR(m1/3) ROWS BETWEEN 2 FOLLOWING AND 1
FOLLOWING),
FROM foo
expectedResults:
- [1.0,0.0,true,true,true,true,true]
- [2.0,0.0,true,true,true,true,true]
- [3.0,1.0,true,true,true,true,true]
- [4.0,1.0,true,true,true,true,true]
- [5.0,1.0,true,true,true,true,true]
- [6.0,2.0,true,true,true,true,true]
```
--
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]
