cockroachdb / cockroachdb/cockroach
SHOW CREATE SEQUENCE should show NO CYCLE if it was used to create a sequence
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Currently `NO CYCLE` is the default for sequences, but when `NO CYCLE` is specified when creating the sequence it would be nice if users could see that option in the output of `SHOW CREATE SEQUENCE`. Today we output:
```
CREATE SEQUENCE s NO CYCLE;
SHOW CREATE SEQUENCE s;
table_name | create_statement
-------------+---------------------------------------------------------------------------------------
s | CREATE SEQUENCE public.s MINVALUE 1 MAXVALUE 9223372036854775807 INCREMENT 1 START 1
```
But it would be nice if `NO CYCLE` were included.
Epic: CRDB-28692
Contributor guide
Assessment
This issue has not been assessed yet.