oceanbase / oceanbase/seekdb

DIFF TABLE does not support HEAP-organized tables

Open
#332 0 comments 0 reactions 0 assignees View on GitHub

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

  1. Create a source table with ORGANIZATION = HEAP:
    create table t_heap_src (
      id int,
      name varchar(50),
      score int
    ) ORGANIZATION = HEAP;
    
  2. Attempt to execute a DIFF TABLE statement (the specific fork t... command from the original report is incomplete).
  3. 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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.