[Feature] modify column first not throws exception when column is first.
- 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