databend
databend copied to clipboard
bug: window function out of bounds access panic
Search before asking
- [X] I had searched in the issues and found no similar issues.
Version
v1.2.314-nightly
What's Wrong?
window function out of bounds access panic
panicked at src/query/service/src/pipelines/processors/transforms/window/transform_window.rs:157:21:
Out of bounds access
How to Reproduce?
mysql> SELECT DISTINCT lead((861, FALSE, FALSE), 9, (849, TRUE, TRUE)) OVER (PARTITION BY 15560425903542832284, 965871850213131579 ORDER BY 13746504519650342222, 5897530378272856518 ASC NULLS FIRST) from range(100, 12000000, 467);
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| lead((861, false, false), 9, (849, true, true)) over (partition by 15560425903542832284, 965871850213131579 order by 13746504519650342222, 5897530378272856518 asc nulls first) |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| (861,0,0) |
| (849,1,1) |
+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.11 sec)
Read 25696 rows, 200.75 KiB in 0.072 sec., 354.9 thousand rows/sec., 2.71 MiB/sec.
mysql> SELECT DISTINCT lead((861, FALSE, FALSE), 9, (849, TRUE, TRUE)) OVER (PARTITION BY 15560425903542832284, 965871850213131579 ORDER BY 13746504519650342222, 5897530378272856518 ASC NULLS FIRST) from range(100, 120000000, 467);
ERROR 1105 (HY000): PanicError. Code: 1104, Text = Out of bounds access.
Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!