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
Restoring DB with computed index on computed field provides wrong index and wrong select results [CORE2440] #2855
Comments
Modified by: @cincuranetAttachment: bak.bak [ 11444 ] |
Modified by: @hvladsecurity: Developers [ 10012 ] |
Commented by: @cincuranet Please keep the ticket restricted, the database isn't for public. |
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Commented by: @hvlad At restore, indices are activated before the commit of transaction within which computed fields are updated with its BLR. Therefore expression index not see correct BLR of computed field on which index is depends. As result such expression index is built using empty key values. Fix is to commit computed fields transaction before activation of indices. |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 RC1 [ 10300 ] |
Commented by: @dyemanov The ticket is reopened because: |
Modified by: @dyemanovFix Version: 2.5 Beta 2 [ 10300 ] => |
Modified by: @dyemanovsecurity: Developers [ 10012 ] => |
Modified by: @dyemanovassignee: Vlad Khorsun [ hvlad ] => Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovstatus: Reopened [ 4 ] => In Progress [ 3 ] |
Modified by: @dyemanovstatus: In Progress [ 3 ] => Open [ 1 ] |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 4.0 Beta 1 [ 10750 ] Fix Version: 2.5.9 [ 10862 ] Fix Version: 3.0.5 [ 10885 ] |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: Covered by another test(s) Test Details: See test for CORE5118. |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Closed [ 6 ] |
Submitted by: @cincuranet
Jira_subtask_outward CORE2448
Is duplicated by CORE5118
Is duplicated by CORE5800
Attachments:
bak.bak
Attached is backup of database. If you restore it and run "select id from prislusenstvi order by upper(title)" you get wrong result. If you look at the index IDX_PRISLUSENSTVI_UPPER_TITLE it's wrong. After recreating the index, everything is OK.
Commits: dfc0259 fea7c61 a741300 ebd0bcf 98aafa7
====== Test Details ======
See test for CORE5118.
Bug was fixed, ticket CORE2440 can be closed.
The text was updated successfully, but these errors were encountered: