apache / apache/paimon

[Feature] modify column first not throws exception when column is first.

Open
#3,443 0 comments 0 reactions 0 assignees View on GitHub
enhancement
Dominant language
Java
Stars
3.4k
Forks
1.4k
Avg merge
1d 11h
Merged PRs (30d)
396

Description

### Search before asking

- [X] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar.

### Motivation

Moving a field to its original position should not be considered an exceptional behavior. Therefore, when user_id is already the first column, MODIFY COLUMN user_id int FIRST should not throw an exception (MySQL does not throw an error).

### Solution

_No response_

### Anything else?

_No response_

### Are you willing to submit a PR?

- [X] I'm willing to submit a PR!

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by locating the Java implementation and tests for MODIFY COLUMN, especially handling of the FIRST position. Reproduce MODIFY COLUMN user_id int FIRST when user_id is already the first column, then add coverage showing that this no-op completes without an exception.

Written by the indexing model from the issue text.

Assessment

Tech stack
java
Domain
database
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.