Merged PRs

dolt

• 6957: Avoid deserializing value on FK check
• 6956: fix sql_mode column access of dolt_schemas table
  The databases that were created before sql_mode column was added to dolt_schemas table does not have this column, so access this column needs to be check beforehand.
• 6933: store GEOMETRY types as BLOBs
  To get around the 65k limit on our fields, we should store GEOMETRY types as BLOBs.
  Additionally, MySQL stores these as out of band BLOBs.
  This will also probably worsen the performance of GEOMETRY types as it just takes longer to reference.
  Fixes #6927

go-mysql-server

• 2133: Add query plans for index/join sysbench queries
• 2132: ReferenceChecker interface
  re: #6957 It is expensive and unnecessary to deserialize blobs during FK reference check lookups.
• 2130: More TPC-C tests, fix the slow HASH_JOIN
  The randIO parameter for LOOKUP_JOIN costing was perhaps too strict, since that cost is already stacked on top of the sequential cost. This isn't a replacement for better costing, but boosts TPC-C perf a bit and isn't less correct than the previous version.
  This was the motivating query, executed as a HASH_JOIN before:

  sbt> explain SELECT COUNT(DISTINCT (s_i_id)) FROM order_line3, stock3 WHERE ol_w_id = 1 AND ol_d_id = 5 AND ol_o_id < 3003 AND ol_o_id >= 2983 AND s_w_id= 1 AND s_i_id=ol_i_id AND s_quantity < 18;
  +------------------------------------------------------------------------------------------------------------+
  | plan                                                                                                       |
  +------------------------------------------------------------------------------------------------------------+
  | Project                                                                                                    |
  |  ├─ columns: [countdistinct([stock3.s_i_id])]                                                              |
  |  └─ GroupBy                                                                                                |
  |      ├─ SelectedExprs(COUNTDISTINCT([stock3.s_i_id]))                                                      |
  |      ├─ Grouping()                                                                                         |
  |      └─ LookupJoin                                                                                         |
  |          ├─ IndexedTableAccess(order_line3)                                                                |
  |          │   ├─ index: [order_line3.ol_w_id,order_line3.ol_d_id,order_line3.ol_o_id,order_line3.ol_number] |
  |          │   ├─ filters: [{[1, 1], [5, 5], [2983, 3003), [NULL, ∞)}]                                       |
  |          │   └─ columns: [ol_o_id ol_d_id ol_w_id ol_i_id]                                                 |
  |          └─ Filter                                                                                         |
  |              ├─ ((stock3.s_w_id = 1) AND (stock3.s_quantity < 18))                                         |
  |              └─ IndexedTableAccess(stock3)                                                                 |
  |                  ├─ index: [stock3.s_w_id,stock3.s_i_id]                                                   |
  |                  ├─ columns: [s_i_id s_w_id s_quantity]                                                    |
  |                  └─ keys: 1, order_line3.ol_i_id                                                           |
  +------------------------------------------------------------------------------------------------------------+
  

• 2121: fix panic when calling ST_POINTFROMWKB() with no arguments

vitess

• 288: allow unquoted non reserved keywords for drop and rename column ddl
  fixes #6950
• 287: support int1,int2,int3,int4,int8 aliases
  fixes #6900
• 286: Logging improvements
  Logging a couple more error handling spots. Changing the Handler interface to pass mysql.PrepareData into the ComPrepare function so that GMS can log the params count at a debug level.
  Related GMS PR: dolthub/go-mysql-server#2098

Closed Issues

• 6950: Cannot DROP column if it's named geometry
• 6927: "value exceeded max field size of 65kb" when inserting large geometry
• 6910: No value for column when attempting to insert a record without providing a value for a column with a default
• 6946: Error when running large dump
• 6951: Slow merge when new index was added (re-indexing every merge?)

Latency