5app / dare / 4be3ba1f-5d4d-4b59-a5e3-ccb26977ac84

100%

master: 100%

push

circleci

perf(cte): subquery optimisation, fixes #413 (#416)

* perf(cte): subquery optimisation, fixes #413

* feat(CTE): support CTE's WITH to optimise SELECT queries with subqueries, fixes #413

* test(CTE): upgrade unit tests to base around  mysql:8, fixes #413

* fix(CTE): _rowid is rejected because it's not recognised in the schema

* fix(cte): disable repeating the offset

* fix(cte): disable repeating the start (offset)

* fix(cte): accept groupby=id | [id]

* perf(cte): add configurable rules, default 10_000 limit applying CTE, fixes #413

* docs(applyCTELimitFiltering): overwrite default handling of CTE, #413

935 of 935 branches covered (100.0%)

Branch coverage included in aggregate %.

151 of 151 new or added lines in 5 files covered. (100.0%)

4615 of 4615 relevant lines covered (100.0%)

123.56 hits per line