Merged PRs

dolt

• 5624: Fix dolt_gc for repositories newly using chunk journal.
  When a repository was created with < 0.75.0, or if it was created and used with DOLT_DISABLE_CHUNK_JOURNAL=true, it does not have a chunk journal. If it then runs dolt in a mode where it uses the chunk journal, the journal will not be bootstrapped until a write is done against the database. In the state where dolt is using the chunk journal but the chunk journal is not bootstrapped, dolt gc and call dolt_gc() were broken. They would fail with the message: concurrent manifest edit during GC, before swapTables. GC failed..
  This fixes that by making the chunk journal forward UpdateGCGen manifest update calls in its non-bootstrapped state, the same way it forwards Update manifest calls.
• 5615: Allow logging base64-encoded queries, instead of replacing bad chars.
• 5602: Added test for avoiding multiple parens issue.
  #5478

go-mysql-server

• 1667: Allow logging base64-encoded queries, instead of replacing bad chars.
• 1666: join operator hints
  Join order (JOIN_ORDER(a,b)) and operator hints (LOOKUP_JOIN(a,b)) play nice together when there is a plan that satisfies all hints. If order and operator hints are are incompatible, no hints are applied.
  Example:

  > explain
  select /*+ JOIN_ORDER(a,b,c,d) LOOKUP_JOIN(d,c) MERGE_JOIN(b,a) HASH_JOIN(c,a)*/ 1
  from xy a
  join uv b on a.x = b.u
  join xy c on a.x = c.x
  join uv d on d.u = c.x;
  QueryProcess
  └─ Project
  ├─ columns: [1 (tinyint)]
  └─ HashJoin
  ├─ Eq
  │   ├─ a.x:0!null
  │   └─ c.x:2!null
  ├─ MergeJoin
  │   ├─ cmp: Eq
  │   │   ├─ a.x:0!null
  │   │   └─ b.u:1!null
  │   ├─ TableAlias(a)
  │   │   └─ IndexedTableAccess(xy)
  │   │       ├─ index: [xy.x]
  │   │       ├─ static: [{[NULL, ∞)}]
  │   │       └─ columns: [x]
  │   └─ TableAlias(b)
  │       └─ IndexedTableAccess(uv)
  │           ├─ index: [uv.u]
  │           ├─ static: [{[NULL, ∞)}]
  │           └─ columns: [u]
  └─ HashLookup
  ├─ source: TUPLE(a.x:0!null)
  ├─ target: TUPLE(c.x:0!null)
  └─ CachedResults
  └─ LookupJoin
  ├─ Eq
  │   ├─ d.u:3!null
  │   └─ c.x:2!null
  ├─ TableAlias(c)
  │   └─ Table
  │       ├─ name: xy
  │       └─ columns: [x]
  └─ TableAlias(d)
  └─ IndexedTableAccess(uv)
  ├─ index: [uv.u]
  └─ columns: [u]

• 1665: Fix filter hoisting issue
  Before hoisting a filter condition inside a subquery, check if the condition is using any of the subquery tables.
  This also includes a minor renaming change: when hoisting a table and there's a possibility of a name collision, we now add an unambiguous table alias.
  Fixes: #5342
• 1661: AlterIndex completely resolves column defaults
  #5478

Closed Issues

Latency