Noel Kwan

Several features are currently not fully supported, hence some parts of sqlsmith are disabled, or use workarounds. We should re-enable them when their dependent issues are fixed. Bugs: - [x]...

**Describe the bug** Invalid agg should be caught in frontend. **To Reproduce** ``` create table t (v int); create materialized view m1 as select sum(INTERVAL '938796') as e from t;...

Parse negative numbers for Postgres Dialect

1

Parser should parse negative numbers as is, rather than into a unary_op neg, wrapping an inner value, to be consistent with Postgres. Postgres behaviour using (pglast): ``` [nix-shell:~/projects/risingwave-nix]$ ./query_parser.py "select...

Update q3 accoridng to https://github.com/DataTalksClub/data-engineering-zoomcamp/pull/519#issuecomment-1967270010

I hereby agree to the terms of the [RisingWave Labs, Inc. Contributor License Agreement](https://gist.github.com/TennyZhuang/f00be7f16996ea48effb049aa7be4d66#file-rw_cla). ## What's changed and what's your intention? We need to include it in backwards compat tests...

test: add `single-node` binary tests

2

I hereby agree to the terms of the [RisingWave Labs, Inc. Contributor License Agreement](https://gist.github.com/TennyZhuang/f00be7f16996ea48effb049aa7be4d66#file-rw_cla). ## What's changed and what's your intention? Also tests sqlbackend, since that's used by single-node mode....

`test_backfill_tombstone` failed in `main-cron` backfill tests: `key UserKey { 1004, TableKey { 0000008558294d8b000000 } } epoch EpochWithGap(6017238017507328) >= prev epoch EpochWithGap(6017238017507328)`

1

buildkite: https://buildkite.com/risingwavelabs/main-cron/builds/1899#018deb4c-29e0-4ad8-a9a9-bc7c5ea713a4 Compute node logs: You can run the tests locally, see `ci/scripts/run-backfill-tests.sh`. The test which fails is: ``` e2e, test_backfill_tombstone ``` You can comment out the other tests at...

I hereby agree to the terms of the [RisingWave Labs, Inc. Contributor License Agreement](https://gist.github.com/TennyZhuang/f00be7f16996ea48effb049aa7be4d66#file-rw_cla). ## What's changed and what's your intention? Also decouple `single_node` and `standalone` mode. Subsequent PRs will...

I hereby agree to the terms of the [RisingWave Labs, Inc. Contributor License Agreement](https://gist.github.com/TennyZhuang/f00be7f16996ea48effb049aa7be4d66#file-rw_cla). ## What's changed and what's your intention? For `./risedev psql`, there's a few second latency to...

I hereby agree to the terms of the [RisingWave Labs, Inc. Contributor License Agreement](https://gist.github.com/TennyZhuang/f00be7f16996ea48effb049aa7be4d66#file-rw_cla). ## What's changed and what's your intention? Just trying out to see if we can catch...