databend icon indicating copy to clipboard operation
databend copied to clipboard

bug: window function out of bounds access panic

Open b41sh opened this issue 1 year ago • 0 comments

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!

b41sh avatar Jan 26 '24 08:01 b41sh