sql: support ALTER TABLE ... ALTER COLUMN ... RESTART

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.

https://www.cockroachlabs.com

Other

30.11k stars 3.81k forks source link

sql: support ALTER TABLE ... ALTER COLUMN ... RESTART #109956

Open giangpham712 opened 1 year ago

giangpham712 commented 1 year ago

Support RESTART [WITH] in ALTER TABLE

RESTART These forms alter the sequence that underlies an existing identity column. sequence_option is an option supported by ALTER SEQUENCE such as INCREMENT BY.

Additional context This affects efcore.pg tests

Jira issue: CRDB-31182

blathers-crl[bot] commented 1 year ago

Hello, I am Blathers. I am here to help you get the issue triaged.

It looks like you have not filled out the issue in the format of any of our templates. To best assist you, we advise you to use one of these templates.

I have CC'd a few people who may be able to assist you:

@cockroachdb/sql-foundations (found keywords: ALTER TABLE)

If we have not gotten back to your issue within a few business days, you can try the following:

Join our community slack channel and ask on #cockroachdb.
Try find someone from here if you know they worked closely on the area and CC them.

_{:owl: Hoot! I am a Blathers, a bot for CockroachDB. My owner is dev-inf.}

aashish2057 commented 1 year ago

Hi I would like to attempt this any help I could get on where to get started?

rafiss commented 11 months ago

@aashish2057 sure, feel free. check out some guidelines here: https://cockroachlabs.atlassian.net/wiki/spaces/CRDB/pages/73072641/What+is+a+Good+CockroachDB+PR

andrew-delph commented 11 months ago

@rafiss , I have a Pr for this but I'm in the process of cleaning it up.

andrew-delph commented 9 months ago

https://github.com/cockroachdb/cockroach/issues/110010