Merged PRs

dolt

go-mysql-server

• 3212: Wrap right side in Distinct when converting semi-joins to inner joins
  Fixes #9797
  Distinct flag wasn't getting propagated through join replanning so instead, we're explicitly wrapping the right side in a Distinct.
• 3211: Do not return EOF in existsIter when right iter is empty
  fixes #9828
  Returning EOF was causing us to terminate the existsIter early
  Added tests for #9797
• 3210: Copy parent row in lateralJoinIterator.buildRow
  fixes #9820
  Also rename left and right to primary and secondary to follow the same pattern as other join iterators

Closed Issues

• 9797: EXISTS subquery returns duplicate rows with PRIMARY KEY
• 9828: LEFT JOIN with empty CTE returns different row count than equivalent UNION ALL query
• 9817: Bitwise operations with negative numbers always return 9223372036854775807