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
Server locks up while attempting to commit a deletion of an expression index [CORE1145] #1567
Comments
Commented by: @pcisar Dmitry, could you provide a test case for this one please? I can't reproduce on 2.0.0. |
Commented by: @dyemanov create table expt1 (col1 int); create index iexpt1 on expt1 computed (col1 + 1); select * from expt1 where col1 + 1 = 0; drop index iexpt2; |
Commented by: @pcisar Fix verified, test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pcisarWorkflow: jira [ 11642 ] => Firebird [ 15325 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Submitted by: @dyemanov
Is related to QA41
The problem is related to LCK_expression locks. Index ID is not unique across database, so it shouldn't be used as a lock key.
Commits: a747534 2f1dc82
The text was updated successfully, but these errors were encountered: