Skip to content
This repository has been archived by the owner on May 22, 2023. It is now read-only.

"SELECT FOR UPDATE" queries incompatable with CRDB v19 and lower #69

Open
ruteben opened this issue Jul 31, 2020 · 0 comments
Open

"SELECT FOR UPDATE" queries incompatable with CRDB v19 and lower #69

ruteben opened this issue Jul 31, 2020 · 0 comments

Comments

@ruteben
Copy link

ruteben commented Jul 31, 2020

I was running the TPCC benchmark on CRDB v2.1.9 and ran into an issue with two NewOrder queries using "SELECT FOR UPDATE", which CockroachDB only supports since version 20.1 (released May this year). Besides TPCC's NewOrder, this kind of query is also used in YCSB's ReadModifyWrite.

I'm aware that this project provides the necessary docker files to run the latest version of CockroachDB, but it is sometimes preferred to use older versions for the sake of stability or comparison.

Do you intend to support version v19 and older? If you do, an alternate query that does not use the "SELECT FOR UPDATE" would be required for the older versions. If you don't, then it might be a good idea to include the required minimum version in the readme.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Development

No branches or pull requests

1 participant