Maximilian Hoffman

Detect and deduplicate self-joins on unique keys

1

A table that joins itself on a unique key can be deduplicated: ```sql select * from mytable a join mytable b on a.i = b.i; => select i, s, i,...

[prolly] Writing a node skips writing internal addr references

10

AFAICT the previous implementation writes every internal address for a prolly node on every write. This is unnecessary when the chunker already puts every new node. This disproportionately affects large...

type coercion

1

Our sql engine lacks (1) type safety and (2) type visibility. Both of these things are best done after plan building, during semantic resolution, before transformation rules. This would also...

[sort] index build streams sorted edits

5

Use sorting to skip more steps building a prolly map. Shaves maybe 20-25% off of external index rebuilds. This also fixes a bug where we were incorrectly using only the...

[nbs] background thread writes index records

25

This uses a buffered channel to avoid blocking on indexLookup writes. The main side effect is that lookups can be out of order.