cockroachdb / cockroachdb/cockroach

SHOW CREATE SEQUENCE should show NO CYCLE if it was used to create a sequence

Open
#104,733 0 comments 0 reactions 0 assignees View on GitHub
C-enhancement T-sql-queries
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.