Merged PRs

dolt

• 9780: Factor out ResolveDataConflictsForTable helper function for dolthubapi

go-mysql-server

• 3195: Initialize newChildren with node.Children to avoid nil child during replaceIdxSort
  fixes #9789
  continue in JoinNode case was resulting in nil child in newChildren array. This would later cause a panic when child would be referenced.
• 3194: Group by validation for aggregated queries
  Fixes #9761
• 3193: Left and right joins should not be optimized into cross joins
  fixes #9782

Closed Issues

• 9789: Dolt crashes when executing cartesian join with ORDER BY on table with PRIMARY KEY
• 9761: validate aggregated query without GROUP BY when sql_mode=only_full_group_by
• 9777: Incorrect Hash Join on condition with '%'
• 9782: Incorrect Left/Right Join with subquery an empty table