Jackie-Jiang opened a new issue, #13595: URL: https://github.com/apache/pinot/issues/13595
With the dataset in the integration test: V1 query returns 129: ``` SELECT COUNT(*) FROM mytable WHERE DivWheelsOffs < 1416 AND DivWheelsOffs >= 2344 ``` V2 query returns 0: ``` SELECT COUNT(*) FROM mytable WHERE ARRAY_TO_MV(DivWheelsOffs) < 1416 AND ARRAY_TO_MV(DivWheelsOffs) >= 2344 ``` The reason is that V2 planner directly detect `ARRAY_TO_MV(DivWheelsOffs) < 1416 AND ARRAY_TO_MV(DivWheelsOffs) >= 2344` as `false`, but it might not be `false` with MV semantic. If one value matches `< 1416` and another value matches `>= 2344` we count it as match. -- 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: commits-unsubscr...@pinot.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
