Context
Slack thread: https://slack.com/archives/C034XCYJPSN/p1770630289319789
Problem
Users looking for the basic "CREATE SUBSCRIPTION" command in the DDL command section cannot find it. The information exists on the Subscription page, but it is not linked from the DDL command area, making it hard to discover.
Suggested Fix
Add a DDL command entry/link for "CREATE SUBSCRIPTION" that points directly to the existing section on the Subscription page: https://docs.risingwave.com/serve/subscription#create-subscription. If there is a DDL commands index page, add the link there as well and ensure the label matches other DDL command entries.
Existing Documentation
- https://github.com/risingwavelabs/risingwave-docs/blob/f2c9267a4f86e94164809db7374cda7da217fffb/serve/subscription.mdx
- https://github.com/risingwavelabs/risingwave-docs/blob/f2c9267a4f86e94164809db7374cda7da217fffb/sql/commands/sql-alter-subscription.mdx
- https://github.com/risingwavelabs/risingwave-docs/blob/f2c9267a4f86e94164809db7374cda7da217fffb/sql/commands/sql-show-subscriptions.mdx
- https://github.com/risingwavelabs/risingwave-docs/blob/f2c9267a4f86e94164809db7374cda7da217fffb/sql/commands/sql-show-subscription-cursors.mdx
- https://github.com/risingwavelabs/risingwave-docs/blob/f2c9267a4f86e94164809db7374cda7da217fffb/sql/commands/sql-alter-swap.mdx
- https://github.com/risingwavelabs/risingwave-docs/blob/f2c9267a4f86e94164809db7374cda7da217fffb/operate/workload-isolation-interaction.mdx
Codebase References
- https://github.com/risingwavelabs/risingwave/pull/24706
- https://github.com/risingwavelabs/risingwave/pull/24297
- https://github.com/risingwavelabs/risingwave/pull/24316
- https://github.com/risingwavelabs/risingwave/pull/24318
- https://github.com/risingwavelabs/risingwave/pull/19967
- https://github.com/risingwavelabs/risingwave/blob/dbc4229c844427121cd194fe35a4290c77f5ade5/src/sqlparser/src/ast/mod.rs
- https://github.com/risingwavelabs/risingwave/blob/dbc4229c844427121cd194fe35a4290c77f5ade5/src/sqlparser/src/ast/statement.rs
- https://github.com/risingwavelabs/risingwave/blob/dbc4229c844427121cd194fe35a4290c77f5ade5/integration_tests/client-library/java/src/test/java/com/risingwave/TestSubscription.java
- https://github.com/risingwavelabs/risingwave/blob/dbc4229c844427121cd194fe35a4290c77f5ade5/src/tests/regress/data/sql/object_address.sql
- https://github.com/risingwavelabs/risingwave/blob/dbc4229c844427121cd194fe35a4290c77f5ade5/src/tests/regress/data/expected/object_address.out
