Nonmatching column tags in an index can cause index to be removed in merge
- Dominant language
- Go
- Stars
- 24.4k
- Forks
- 873
- Avg merge
- 1d 8h
- Merged PRs (30d)
- 120
Description
If a table is being merged and has different column tags on each branch, an index definition can be silently dropped during the merge if the column tags for the columns covered by the index do not match.
A [skipped test in `dolt_queries_merge.go`](https://github.com/dolthub/dolt/blob/766335e120d74b3e3653381fc133ea1468e7d7c8/go/libraries/doltcore/sqle/enginetest/dolt_queries_merge.go#L2925) repros this issue.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start with the skipped test in go/libraries/doltcore/sqle/enginetest/dolt_queries_merge.go around line 2925 and run it to reproduce the merge behavior. Trace the merge handling for indexes when column tags differ between branches. Done means the test is enabled and confirms that the index definition is not silently dropped.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- go, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 50/100