DIFF TABLE does not support HEAP-organized tables
Open
Nobody has claimed this yet.
dima
- Dominant language
- C++
- Stars
- 2.9k
- Forks
- 339
- Avg merge
- 1d 19h
- Merged PRs (30d)
- 52
Description
Description
The DIFF TABLE statement fails when executed on a table created with ORGANIZATION = HEAP.
Steps to Reproduce
- Create a source table with
ORGANIZATION = HEAP:create table t_heap_src ( id int, name varchar(50), score int ) ORGANIZATION = HEAP; - Attempt to execute a
DIFF TABLEstatement (the specificfork t...command from the original report is incomplete). - The operation fails with an error.
Impact
Users cannot use the DIFF TABLE feature to compare or merge data for tables using the HEAP storage organization.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No source file, test, or entry point is named. Start by reproducing the failure with the provided HEAP table and a complete DIFF TABLE statement, then trace the database implementation and existing DIFF TABLE tests; done means DIFF TABLE works for HEAP-organized tables and the regression is covered.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100