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/frontend/src/handler/create_secret.rs b/src/frontend/src/handler/create_secret.rs
index 6d5a6283e3288..27a6b37fca277 100644
--- a/src/frontend/src/handler/create_secret.rs
+++ b/src/frontend/src/handler/create_secret.rs
@@ -58,7 +58,7 @@ pub async fn handle_create_secret(
     let catalog_writer = session.catalog_writer()?;
     catalog_writer
         .create_secret(
-            stmt.secret_name.real_value(),
+            secret_name,
             database_id,
             schema_id,
             session.user_id(),


Test patch:
diff --git a/e2e_test/ddl/secret.slt b/e2e_test/ddl/secret.slt
index cf9d16214da38..493fba90283c5 100644
--- a/e2e_test/ddl/secret.slt
+++ b/e2e_test/ddl/secret.slt
@@ -73,3 +73,11 @@ secret_1
 
 statement ok
 drop secret secret_1;
+
+statement ok
+create secret public.secret_1 with (
+  backend = 'meta'
+) as 'demo_secret';
+
+statement ok
+drop secret secret_1;
\ No newline at end of file