Commit graph

12 commits

Author SHA1 Message Date
pokeeffe-molecula
c620aae350
implement CREATE/ALTER/DROP VIEW (fb-1592) (#2408)
* implement CREATE/ALTER/DROP VIEW

* fixed failing test

* another failing test

* fixed some broken serverless tests
2023-01-13 18:57:31 -06:00
pokeeffe-molecula
af475a27f2
fix sum aggregate (fb-1874) (#2404)
* handle sum aggregates with ints; handle escaped quotes in blob literals

* added test ceoverage

* skip subquery test for dax
2023-01-11 15:46:41 -06:00
pokeeffe-molecula
f030d58d95
implemented DISTINCT (fb-1562) (#2388)
* implemented distinct

* implemented distinct
* uses first cut of a buffer pool, and extendible hashing with thresholded spill to disk
* tests
* cleaned up some stuff around query plan output to make developing tooling easier
* added optimization to call PQL Distinct()

* fixed test

* fix for passing wrong index name in orchestrator

* back out change to DistinctTimestamp

* fix other instance of wrong table name being passed

* use full index name instead of abbreviated one for translation. sigh.

* removed some unused code

Co-authored-by: Matthew Jaffee <jaffee@pilosa.com>
2023-01-03 22:13:31 -06:00
pokeeffe-molecula
021219935f
Implement DELETE (fb 1557) (#2382)
* delete implementation with test coverage

* optimize IN expressions; stop linter complaining

* fixed some uncovered query cases

* skip test in DAX for now
2022-12-19 16:34:28 -06:00
pokeeffe-molecula
eca3168d63
implement having; create view experiment (#2357) 2022-12-13 17:43:37 -06:00
rachithrr
d33bf4811f
FB-1795: Implement REVERSE() scalar string function (#2335) 2022-12-08 04:01:30 +05:30
pokeeffe-molecula
1ce3a1c103
produce a better error when a user tries to sort something unsortable (#2324) 2022-12-01 12:49:40 -06:00
pokeeffe-molecula
3c2c8c6011
fixed error messages for alter table add and drop; added test coverage (#2322)
* fixed error messages for alter table add and drop; added test coverage
* Removed two CI tests that are failing intermittently for no known reason.
2022-12-01 09:28:14 -06:00
pokeeffe-molecula
df829c592f
handle filters on _id columns (fb-1765) (#2313)
* handle filters on _id columns using ConstRow
* handle keyed and un-keyed _id columns
* tests!
2022-11-23 15:26:04 -06:00
pokeeffe-molecula
d3f10be743
fixed top(x) where top cannot be pushed down into pql query (#2311)
* fixed top(x) where top cannot be pushed down into pql query

* review feedback
2022-11-22 19:21:47 -06:00
pokeeffe-molecula
cca319fbe5
Fb 1767 (#2308)
* identifiers can now have the '-' character
* skip some integration tests
2022-11-21 15:58:00 -06:00
Travis Turner
eec278893a
Move SQL3 test definitions into sql3/test/defs package (#2289)
This so other packages can import and use them in their own tests.
2022-11-11 13:20:40 -06:00