This release introduces several improvements to the query analyzer:
- Tables can now be joined to subqueries using indexes
- Indexes and other optimizations now work in
INSERT ... SELECT
statements - Null-safe equals operator (
<=>
)
Merged PRs
- 1303: go/go.mod: Bump go-mysql-server
- 295: Changed analysis to isolate the values side of an INSERT statement
Also cleaned up create trigger analysis, which broke when I did this at first. Now catches more errors than before. - 294: Fixed a bug in join planning for Inserts.
Table reordering was leaving nodes above the join with incorrect field indexes. This was getting fixed by other analyzer steps for some top-level nodes, but not Inserts. - 293: Implement NullSafeEquals: The <=> operator in MySQL.
- 292: Make join planning work for insert statements
- 291: Consider SubqueryAlias nodes when planning indexed joins.