Possible index corruption with multiply updates of the same record in the same transaction and using of savepoints [CORE1830] #2259
Labels
affect-version: 1.0.3
affect-version: 1.5.4
affect-version: 1.5.5
affect-version: 2.0.0
affect-version: 2.0.1
affect-version: 2.0.2
affect-version: 2.0.3
affect-version: 2.0.4
affect-version: 2.1.0
component: engine
fix-version: 1.5.6
fix-version: 2.0.5
fix-version: 2.1.1
fix-version: 2.5 Alpha 1
priority: critical
qa: done successfully
type: bug
Submitted by: @hvlad
Is related to QA214
CREATE TABLE A
(
ID CHAR(1), NAME VARCHAR(255)
);
CREATE INDEX IDX_A ON A (ID);
CREATE EXCEPTION EX_PERM 'AAA';
COMMIT ;
INSERT INTO A (ID) VALUES ('1');
SELECT * FROM A WHERE ID = '1'
-- record is present
EXECUTE BLOCK AS
BEGIN
UPDATE A SET NAME = 'xxx';
UPDATE A SET ID = '2';
EXCEPTION EX_PERM;
END
SELECT * FROM A -- record with ID = 1 is present
SELECT * FROM A WHERE ID = '1' -- no record is returned
COMMIT; -- corruption - index is missed entries
I tested it with HEAD only but i think this is very old bug
Commits: c89987f c0cbd0f 3156def b04aa77
The text was updated successfully, but these errors were encountered: