Merged PRs

dolt

• 3326: Option for sysbench perf tests to clone big repo
• 3320: Add Support for new Transaction Query Plans
  This PR integrates new GMS changes to ensure that the new TransactionCommittingNode works. As a result it addresses #3240
• 3319: Add perf runner test
• 3318: Display schema and data for created and dropped tables in dolt diff command
  Fixes: #3300
  The dolt diff command was previously omitting schema and data diffs if tables were created or dropped within the commit range, and only outputting diff summary information with tabular output. This change causes the schema changes and data changes to be included in tabular output.
  Old behavior:

  ❯ dolt diff mhgva1kfcljign82ntcmr6ftmpbmemko j6n5727at9652tri8ncsa02v794h1fi4
  diff --dolt a/a b/a
  added table
  ❯ dolt diff mhgva1kfcljign82ntcmr6ftmpbmemko ccm9bfiv6jhft1tmeu1cqd0ghduhg4v7
  diff --dolt a/a b/a
  added table
  ❯ dolt diff qd507o2jjlckjgmn2polsmiifk62vo8n js1bb2cvdr7h4tdj2d3m33jhp9rc9ee9
  diff --dolt a/a b/a
  deleted table
  

  New behavior:

  ❯ dolt diff mhgva1kfcljign82ntcmr6ftmpbmemko j6n5727at9652tri8ncsa02v794h1fi4
  diff --dolt a/a b/a
  added table
  +CREATE TABLE `a` (
  +  `n` int NOT NULL,
  +  PRIMARY KEY (`n`)
  +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  +-----+---+
  |     | n |
  +-----+---+
  +-----+---+
  ❯ dolt diff mhgva1kfcljign82ntcmr6ftmpbmemko ccm9bfiv6jhft1tmeu1cqd0ghduhg4v7
  diff --dolt a/a b/a
  added table
  +CREATE TABLE `a` (
  +  `n` int NOT NULL,
  +  PRIMARY KEY (`n`)
  +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  +-----+---+
  |     | n |
  +-----+---+
  |  +  | 1 |
  |  +  | 2 |
  +-----+---+
  ❯ dolt diff qd507o2jjlckjgmn2polsmiifk62vo8n js1bb2cvdr7h4tdj2d3m33jhp9rc9ee9
  diff --dolt a/a b/a
  deleted table
  -CREATE TABLE `a` (
  -  `n` int NOT NULL,
  -  PRIMARY KEY (`n`)
  -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  +-----+---+
  |     | n |
  +-----+---+
  |  -  | 1 |
  |  -  | 2 |
  |  -  | 3 |
  +-----+---+
  

• 3316: Max/fix nightly
• 3291: Use Transactional Logic to Revert Triggers
  Fix for: #2613
  Note: can't roll back in GMS / in-memory tables as they don't have any transactional logic, so we don't test there

go-mysql-server

• 986: support XOR logic operator
  Added XOR MySQL logic operator
• 985: Fix Handler queries when Prepared Statements are Disabled
  Fix for: #3305
• 983: Change Autocommit Query Plan
  This PR adds a new analyzer rule and query Node for autocommit. This fixes an issue where previously a query process was being killed (via a cancelCtx function) before a transaction committed.
• 982: adding flag options 2 and 4 for st_asgeojson
  fix for: #3280
• 978: Use transactional logic to rollback bad triggers, also tests
  Added a new rule that wraps everything in a TriggerRollback node if there is a trigger present. This new node will make a savepoint right before execution, and will return to normal if something breaks.

vitess

• 154: move CURRENT to non-reserved-keyword-list
  CURRENT is non reserved keyword, it fixes issue of SELECT * FROM current query failing
  Fixes #3224

Closed Issues

• 3240: Potential Compatibility issue with Knex
• 2613: Changes, made by "before insert" trigger do not rollback when insert fails
• 3300: dolt diff doesn't show data diff when table was added within the commit range
• 3305: DISABLE_PREPARED_STATEMENTS errors
• 3309: dolt pull fails when other branch exists in the repo