New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Wrong field position after ALTER POSITION [CORE2932] #3315
Comments
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandessummary: Ugly field position after ALTER POSITION => Wrong field position after ALTER POSITION |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Alpha 1 [ 10331 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: @pavel-zotov It seems that new position can be evaluated wrong in case when field is "moved" to the end of field list after some manipulations.
|
Commented by: @pavel-zotov PS. Tested on WI-T3.0.0.31773 |
Commented by: @pavel-zotov One more sample, shorter than previous: SQL> recreate table t(f01 int, f02 int, f03 int); SQL> alter table t alter f03 position 3; SQL> show table t; SQL> alter table t alter f03 position 2; SQL> show table t; |
Modified by: @asfernandesstatus: Closed [ 6 ] => Reopened [ 4 ] resolution: Fixed [ 1 ] => Fix Version: 3.0 Alpha 1 [ 10331 ] => |
Commented by: @asfernandes Pavel, I think this is wrong: -- move field f10 to the "end" of DDL: exchange positions of n05 and f10 It must be: F05 INTEGER Nullable I'm changing for this. Please retest. |
Modified by: @asfernandesstatus: Reopened [ 4 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Beta 2 [ 10586 ] |
Commented by: @pavel-zotov > I think this is wrong You're right, it was my mistake. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: Gabor Boros (gaborboros)
I got ugly(random?) field position after an ALTER TABLE ... ALTER ... POSITION statement.
Described on firebird-devel in "Strange ALTER POSITION result" thread.
Commits: 119d1e1 a1d62c1 FirebirdSQL/fbt-repository@063d5b6
The text was updated successfully, but these errors were encountered: