Hi, Now that hash index support write-ahead logging, it will be great if we add support for predicate locking to it. Implementation of predicate locking in hash index seems very simple. I have already made changes in the code. I am currently working on testing.
Here is my approach 1) PredicateLockPage() ->_hash_first() During a scan operation, acquire a predicate lock on the primary page of a bucket. 2) CheckForSerializableConflictIn() ->_hash_doinsert() During an insert operation, check if there is any predicate lock on the primary page of a bucket. 3) PredicateLockPageSplit() In case of a bucket split, copy predicate lock from the primary page of an old bucket to the primary page of a new bucket. Any suggestions or corrections will be appreciated. Regards, Shubham <https://mailtrack.io/> Sent with Mailtrack <https://mailtrack.io/install?source=signature&lang=en&[email protected]&idSignature=22>
