Skip to content
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

Jump to bottom

Compound ALTER TABLE statement with ADD and DROP the same check constraint fails [CORE4947] #5238

Closed
firebird-automations opened this issue Sep 29, 2015 · 4 comments
Closed

Compound ALTER TABLE statement with ADD and DROP the same check constraint fails [CORE4947] #5238

firebird-automations opened this issue Sep 29, 2015 · 4 comments
Assignees
@asfernandes
Labels
affect-version: 3.0 Beta 2 component: engine fix-version: 3.0 RC1 priority: major qa: done successfully type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @asfernandes

Relate to CORE4878

This is a simplified version of CORE4878 that affects v3.

recreate table t(x int not null);

alter table t
add constraint cx check(x > 0),
drop constraint cx;

Commits: 1e9ab8c FirebirdSQL/fbt-repository@1380860
@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

Link: This issue relate to CORE4878 [ CORE4878 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 RC 1 [ 10584 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@asfernandes asfernandes

Labels
affect-version: 3.0 Beta 2 component: engine fix-version: 3.0 RC1 priority: major qa: done successfully type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@asfernandes @firebird-automations