1.44.1

Merged PRs

dolt

• 8653: Bug fix: replication fails when a branch is deleted and tag with same name is created
  Our logic to update refs in a read replica was tracking updated refs by path, so when branch b1 was deleted and tag b1 was added, the code was mixing them up and trying to update the branch with the tag ref.
  The fix is to track replicated refs by ID, instead of by path, to avoid collisions. This also changes the first return parameter of the pullBranches function, but none of the three places that call this function assign that first return param to a variable, so that change doesn't affect anything.
• 8643: Support for schema names in table renames
  Also support for changes in enginetest harness setup in GMS

go-mysql-server

• 2784: implement EXPLAIN and EXPLAIN PLAN
  Moving our current implementation of EXPLAIN to EXPLAIN PLAN, and replace EXPLAIN with a dummy implementation of MySQL's EXPLAIN
  Looks like this now:

  tmp2/main> explain select * from t;
  +----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+
  | id | select_type | table | partitions | type | possible_keys | key  | key_len | ref  | rows | filtered | Extra |
  +----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+
  | 1  | SELECT      | NULL  | NULL       | NULL | NULL          | NULL | NULL    | NULL | NULL | NULL     |       |
  +----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+
  1 row in set (0.00 sec)
  tmp2/main> explain plan select * from t;
  +------------------+
  | plan             |
  +------------------+
  | Table            |
  |  ├─ name: t      |
  |  └─ columns: [i] |
  +------------------+
  3 rows in set (0.00 sec)

  related: #8592

Closed Issues

Performance

Read Tests	MySQL	Dolt	Multiple
covering_index_scan	1.89	0.62	0.3
groupby_scan	13.22	16.71	1.3
index_join	1.47	2.3	1.6
index_join_scan	1.42	1.44	1.0
index_scan	34.33	52.89	1.5
oltp_point_select	0.18	0.27	1.5
oltp_read_only	3.49	5.47	1.6
select_random_points	0.34	0.65	1.9
select_random_ranges	0.37	0.65	1.8
table_scan	34.33	52.89	1.5
types_table_scan	75.82	142.39	1.9
reads_mean_multiplier			1.4

Write Tests	MySQL	Dolt	Multiple
oltp_delete_insert	9.06	6.21	0.7
oltp_insert	4.1	3.07	0.7
oltp_read_write	9.06	11.87	1.3
oltp_update_index	4.18	3.13	0.7
oltp_update_non_index	4.18	3.07	0.7
oltp_write_only	5.77	6.21	1.1
types_delete_insert	8.43	6.67	0.8
writes_mean_multiplier			0.9

TPC-C TPS Tests	MySQL	Dolt	Multiple
tpcc-scale-factor-1	96.27	40.66	2.4
tpcc_tps_multiplier			2.4

Overall Mean Multiple	1.57