Richard Chien

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

[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...

> 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...

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

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...

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

Maybe related: ```sql CREATE FUNCTION array_flatten(arrs character varying[][]) RETURNS character varying[] LANGUAGE SQL RETURN ARRAY(SELECT unnest(arrs)); create table t (x varchar[]); select array_flatten(array_agg(x)) from t; -- this will panic ```

I'm just kouhaiing, but may be possible/useful. Cc @tabVersion @BugenZhao @xxchan for insights.

> We could definitely update the output of `format_type` for `2249` to be `record` - but not sure whether this is enough for your specific use case. I think that...

IIUC, if we introduce something like a `MaterializedProject` to do UDFs, we get the following benefits right? 1. For updates, we only need to call UDF for the `UpdateInsert`. 2....