Richard Chien comments

Results 86 comments of


                                            Richard Chien

The default framing option for over window with order by is different from PG

This is a known limitation, and we emphasized this in our doc https://docs.risingwave.com/docs/current/window-functions/#syntax. Will align with PG after implementing https://github.com/risingwavelabs/risingwave/issues/11109

Doc: clarify SQLite usage as backend option

[This page](https://docs.risingwave.com/deploy/risingwave-docker-compose#customize-meta-store) also have SQLite related content. Actually IMO we don't need to remove this from doc, we can move MySQL to above SQLite, and explictly emphasize that SQLite is...

Fuzz test panic: `Option::unwrap()` on a `None` value in `generic/agg.rs:354:46`

> CREATE TABLE supplier (s_suppkey INT, s_name CHARACTER VARYING, s_address CHARACTER VARYING, s_nationkey INT, s_phone CHARACTER VARYING, s_acctbal NUMERIC, s_comment CHARACTER VARYING, PRIMARY KEY (s_suppkey)); > CREATE TABLE part (p_partkey...

perf(over window): skip remaining affected rows when rank is not changed

* **#18950** 👈 * **#19056** * **#19036** * **#19081** * `main` This stack of pull requests is managed by Graphite. Learn more about stacking. Join @stdrc and the rest of...

perf(over window): skip remaining affected rows when rank is not changed

After some loose benchmark based on a custom query on nexmark datagen, I found that this PR doesn't help much, but still better than nothing. Query (no much rationale, just...

perf(over window): avoid recompute information about window frames

* **#18950** * **#19056** * **#19036** 👈 * **#19081** * `main` This stack of pull requests is managed by Graphite. Learn more about stacking. Join @stdrc and the rest of...