TODO list of enterprise engine changes to port

[rcaudy]

To-do:

1. Push down predicates
   • DH-12664, DH-12633, DH-11547
2. Fishlib changes
   • https://gitlab.deephaven.io/fishlib/fishlib/merge_requests/197/diffs
   • TODO: exhaust this list
3. DH-14683: ClockFilter dependency bug in Replay queries

In Progress:

1. DH-11168: Indexing enhancements (Port DH-11168: Indexing enhancements to Community. #3851)

In Review:

Completed:

1. Symbol table aggregation - (Port Symbol table aggregation improvements from DHE #3955)
2. DH-13118: udpateBy Delta Operator: Added Delta to UpdateBy operators #3656
3. LTM single update queue removal
4. Parallel update
5. DH-11271: Port DH-11271: Rearchitect Static Cross Join to Deal with Rehash More Efficiently #3222
6. DH-11635: Correct notification queue race in dependency satisfaction
   • Mostly ported in Bug fixes and PartitionedTable constituent optimization work #2455
   • Mark vars as volatile in Port DH-11635: Correct notification queue race in dependency satisfaction #3234
7. DH-11736: Port DH-11736: Be more Parsimonious with Chunks during Cross Join #3226
8. DH-11964: Port DH-12049: Improve and Refactor TestColumnSources and TestDataGeneration #3269
9. DH-11944: Port DH-11944: Add support for leftOuterJoin #3294
10. DH-8170, DH-12658: Port DH-8170: OuterJoinTools including bugfix DH-12658 #3309
11. DH-11558: Port DH-11558: QueryTable#selectOrUpdate do not Redirect Flat Tables #3313
12. DH-11580: Port DH-11580: Fix Incorrect JoinListener Descriptions #3312
13. DH-12666: Fix modified row set for QueryTable.snapshot when rows have been added, and correct row set cleanup when not notifying. Also port some DHE fixes. #2921
14. DH-11649: Port DH-11649: Improve Memory Usage of Sparse Static Table update()s #3316
15. DH-11625: Port DH-11625: Improve Would Match Filtering #3318
16. DH-12807: Port DH-12807: WindowCheck Should not Allocate Queue Based on Table Size #3320
17. DH-11933: Port DH-11933: Constant Formulas Should use SingleValueColumnSources #3326
18. DH-12201, DH-12310: RowKey-Agnostic ColumnSource Optimizations #3329
19. DH-12686: Add support for seek row through JS API #3086
20. DH-11656: Port DH-11656: More efficiently null sparse array sources #3352
21. DH-11692: Port DH-11692: Add native support for java.time types #3385
22. DH-12148, DH-12030, DH-12199, DH-12273: Port DH-12148: Formula Array Access #3346
23. DH-12458: Port DH-12458: ColumnSources That Wrap Native Apache Arrow #3420
24. Parallel where: Port DH-11185: Parallel Where #3679
    • DH-11185, DH-11369, DH-11457
25. DH-14392: Use current values for satisfied swap listener instantiation.
26. Multijoin (and fixes to fillchunk from missing regions in array-backed sources)
    • (DH-7960, DH-11929, DH-11930, DH-12088, + fillchunk fixes)
    • Add Multijoin feature to community #4170

Not to be ported (deleted or irrelevant):

1. DH-11506: current only index on static by conflicts with DbArray getPrev.
2. https://gitlab.deephaven.io/fishlib/fishlib/merge_requests/196/diffs
3. DH-11438: TableMapProxy with right hand side table does not respect rhs dependency.