Tags: trucnguyenlam/cockroach
Tags
Merge cockroachdb#32774 32774: opt: Add Update support to CBO r=andy-kimball a=andy-kimball Add a new Update operator to the CBO which is used to optimize the UPDATE SQL statement. As part of compiling the UPDATE statement, the optbuilder constructs an expression that outputs the existing values for all rows from the target table that match the WHERE clause. Additional column(s) that provide updated values are projected for each of the SET expressions, as well as for any computed columns. For example: ``` CREATE TABLE abc (a INT PRIMARY KEY, b INT, c INT) UPDATE abc SET b=1 WHERE a=2 ``` This would create an input expression similar to this SQL: ``` SELECT a AS oa, b AS ob, c AS oc, 1 AS nb FROM abc WHERE a=2 ``` The execution engine evaluates this relational expression and uses the resulting values to form the KV keys and values. Co-authored-by: Andrew Kimball <andyk@cockroachlabs.com>
Merge pull request cockroachdb#32853 from nvanbenschoten/backport2.1-… …32773 release-2.1: storage: don't clear lastTxnMeta on WriteIntentError to different key
Merge pull request cockroachdb#32507 from knz/20181120-fix-32505 sql: catch invalid functions in the UPDATE SET RHS (v2.0.x)
Merge pull request cockroachdb#32318 from bdarnell/backport-disable-t… …imebound backport-2.1: batcheval: Disable time-bound iterators in KV commands
Merge cockroachdb#32211 32211: batcheval: Work around time-bound iterator bug in RefreshRange r=benesch a=bdarnell Updates cockroachdb#28358 Fixes cockroachdb#31823 Release note (bug fix): Fix long stalls that can occur in contended transactions. Co-authored-by: Ben Darnell <ben@bendarnell.com>
Merge pull request cockroachdb#31841 from nvanbenschoten/backport2.1-… …31837 release-2.1: closedts: bump kv.closed_timestamp.target_duration default
Merge pull request cockroachdb#31841 from nvanbenschoten/backport2.1-… …31837 release-2.1: closedts: bump kv.closed_timestamp.target_duration default
Merge pull request cockroachdb#31520 from benesch/backport2.1-31516 release-2.1: c-deps: bump CryptoPP to avoid SIGTRAP on macOS
Merge pull request cockroachdb#31091 from solongordon/backport2.1-30216 release-2.1: distsql: eagerly evaluate constant expressions
Merge pull request cockroachdb#30808 from a-robinson/backport2.1-30747 release-2.1: cli: Mark zone command deprecated so it doesn't show up in help text