cockroachdb / cockroachdb/cockroach
sql/schemachanger: remove fallbacks for TRUNCATE in declarative schema changer
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Currently, the initial implementation for TRUNCATE inside the declarative schema changer has the following limitations:
- [ ] No ability to truncate table with index references from views / stored procedures / triggers. This will require the ability to recreate these references with updated references.
- [ ] Truncate is presently blocked within complex transactions where the primary key is being modified
Jira issue: CRDB-54503
Epic CRDB-31472
Contributor guide
Research direction
Start by reading the declarative schema changer's existing TRUNCATE implementation, then consult Jira issue CRDB-54503 and epic CRDB-31472. Define completion around removing the listed fallbacks: support references from views, stored procedures, and triggers, and support complex transactions where the primary key changes.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100