mysqltest vector_index.vector_index_alter_table: SHOW CREATE TABLE omits backticks for partition key column in partition clause
Nobody has claimed this yet.
- 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
- Set up the test environment as described in the Environment section.
- Execute the
mysqltestcasevector_index.vector_index_alter_table. - Observe the output of the
SHOW CREATE TABLEcommand 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
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
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