AndyA

Suboptimal join query plan for TPC-C "new order" transaction

2

[TPC-C](https://www.tpc.org/tpc_documents_current_versions/pdf/tpc-c_v5.11.0.pdf) is composed of 5 transaction types. The "new order" transaction contains a join query on the `customer` and `warehouse` tables: ``` SELECT c_discount, c_last, c_credit, w_tax FROM customer1, warehouse1...

In Dolt, this increases out TPC-C throughput by 2x for the new NBF.

proposal: Refactor Indexed Table Access

5

This is a design proposal to refactor the way indexed table access works and what abstractions are exposed to Integrators: The core change comes to `sql.IndexLookup` which will now be...

`dolt diff --summary` with cell-wise statistics

4

calculate edits in a cell-wise method, rather than the current row-wise method

error: 'table not found: dcim_rackgroup, maybe you mean dcim_rackgroup?' for query: ``` SELECT COUNT(*) FROM ( SELECT ( SELECT count(*) FROM ( SELECT U0.`id` FROM `dcim_rack` U0 INNER JOIN `dcim_rackgroup`...

Cleans up chunk journal life cycle to facilitate push/pull/close paths. Prior work: - initial implementation of chunk journal: https://github.com/dolthub/dolt/pull/4878 - enforce single in-process NBS per directory: https://github.com/dolthub/dolt/pull/4848 - enforce uniqueness...

merge operation succeeds and takes the correct schema modifications, but the data in the destination branch is not correctly modified ``` % dolt sql # Welcome to the DoltSQL shell....

validate all import args before reading import rows

1

This error occurred ~5min after execution, not immediately ``` PS C:\Users\timse\dolthub\dolt\us-federal-election-precinct-results> dolt table import -c --pks="year,state_fips,county_fips,precinct,candidate" precinct_results .\2016-precinct-local.csv Error determining the output schema. cause: provided primary key not found When...

fixes https://github.com/nautobot/nautobot-plugin-version-control/issues/55