oceanbase / oceanbase/seekdb

mysqltest vector_index.vector_index_alter_table: SHOW CREATE TABLE omits backticks for partition key column in partition clause

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

Nobody has claimed this yet.

dima type: bug
Dominant language
C++
Stars
2.9k
Forks
342
Avg merge
2d 14h
Merged PRs (30d)
53

Description

Environment

  • Platform: Android (arm64)
  • Device: Android Studio emulator (emulator-5554)
  • Binary Path: /data/local/tmp/seekdb
  • Start Command: ./data/local/tmp/seekdb --nodaemon --base-dir /data/local/tmp/seekdb_data --port 5881
  • Listening Port: 5881

Description

During the execution of the mysqltest case vector_index.vector_index_alter_table, the output of SHOW CREATE TABLE for a partitioned table is incorrect. The partition clause in the displayed CREATE TABLE statement omits the required backticks (`) around the partition key column names.

Steps to Reproduce

  1. Set up the test environment as described in the Environment section.
  2. Execute the mysqltest case vector_index.vector_index_alter_table.
  3. Observe the output of the SHOW CREATE TABLE command within the test.

Expected Result: The SHOW CREATE TABLE output should show the partition clause with column names properly quoted in backticks (e.g., PARTITION BY KEY(column_name)).

Actual Result: The partition clause is displayed without backticks (e.g., PARTITION BY KEY(column_name)).

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

Start by running the mysqltest case vector_index.vector_index_alter_table and inspect the SHOW CREATE TABLE output for its partition clause. Trace the formatting path for partition key column names; done means the output includes backticks around those names and the test passes.

Written by the indexing model from the issue text.

Assessment

Tech stack
cpp, sql
Domain
databases, testing-qa
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Clearly specified
Newbie friendliness
68/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.