Repository: risingwavelabs/risingwave (language: python)

Issue:
Sqlsmith: Sql feature generation
As we add more features, these should be tested via sqlsmith as well.

SQL Features:
- [ ] Generate other table functions: `generate_series`, `unnest`. See: https://github.com/singularity-data/risingwave/issues/4540
- [ ] Generate array_agg, jsonb_agg, jsonb_object_agg
- [ ] Generate select from System Tables
- [ ] Generate `NATURAL JOIN`
- [ ] Generate `JOIN` with `USING`
- [ ] Generate query w/o `GROUP BY`
- [ ] Randomly toggle session variables
- [ ] Generate `pow`/`exp`.
- [ ] Generate TopN by group: https://www.risingwave.dev/docs/current/sql-pattern-topn/
- [ ] Generate jsonb exprs, see: https://github.com/risingwavelabs/risingwave/issues/7714
- [ ] #7132
- [x] Generate order-by-clauses with `NULLS { FIRST | LAST }` (will be done in https://github.com/risingwavelabs/risingwave/pull/10864/commits/000cbc11cbc04f20abfd127b1bf4b3fd24e75c44)
- [ ] Generate `max`,`min`,`count` for `timestamptz`
- [ ] Generate `bit_and`, `bit_or` and `big_xor` in batch queries, and `bit_xor` in streaming queries.
- [ ] Generate array range access.
- [ ] https://github.com/risingwavelabs/risingwave/issues/10241
- [ ] Generate window functions other than `row_number`, `rank`.
- [ ] Generate `ALTER` DDL statements.\
- [ ] https://github.com/risingwavelabs/risingwave/issues/10516
- [ ] Generate temporal filter in sqlsmith


Discussion / hints:

Fix patch:
diff --git a/src/common/src/session_config/mod.rs b/src/common/src/session_config/mod.rs
index 3b9451bf55112..d452c51ad3539 100644
--- a/src/common/src/session_config/mod.rs
+++ b/src/common/src/session_config/mod.rs
@@ -77,7 +77,7 @@ pub struct SessionConfig {
     /// The default value is auto which means let the system decide to run batch queries in local
     /// or distributed mode automatically.
     #[serde_as(as = "DisplayFromStr")]
-    #[parameter(default = QueryMode::default(), flags = "NO_ALTER_SYS")]
+    #[parameter(default = QueryMode::default())]
     query_mode: QueryMode,
 
     /// Sets the number of digits displayed for floating-point values.


Test patch:
diff --git a/e2e_test/ddl/alter_session_params.slt b/e2e_test/ddl/alter_session_params.slt
index ecaf7f09ebad3..49968ded83245 100644
--- a/e2e_test/ddl/alter_session_params.slt
+++ b/e2e_test/ddl/alter_session_params.slt
@@ -26,9 +26,6 @@ set STREAMING_ENABLE_DELTA_JOIN to false;
 statement ok
 set RW_STREAMING_ENABLE_DELTA_JOIN to true;
 
-statement error session param query_mode cannot be altered system wide
-alter system set query_mode to auto;
-
 connection other1
 query T
 show RW_STREAMING_ENABLE_DELTA_JOIN;