zed
zed copied to clipboard
brimdata
A novel data lake based on super-structured data
Based on black box testing, `zq` (commit a7522c2 at the moment) currently only seems to treat the `#empty_field (empty)` as indicative of empty `set` & `vector` types. But it looks...
With the current `join` implementation, there's currently no way to reference the second order predicate paths when inside a User Op. ## Details Repro is with super commit f86de86. Let's...
As of super commit b8311a3, type checking in SuperDB is all dynamic. This prevents us from being able to deliver some functionality, such as error messages at parse time about...
While the SQL `NOT IN` support added in #5992 seems to work correctly for the general case, according to SQL conventions, there should have been no rows returned here. ```...
Consider: ``` $ super -c "SELECT;" error("missing") ``` Between the SQL standard, Postgres, and other SQL implementations, there's varying takes on how this should behave. ## Details Repro is with...
Postgres has a [`generate_series` function](https://www.postgresql.org/docs/current/functions-srf.html#FUNCTIONS-SRF) that's handy for use in testing. Users may appreciate having it for other reasons, so we may want to add it to SuperSQL. ``` $...
This fails in SuperDB but works in Postgres. ``` $ super -version Version: 7f23f6560 $ super -c "SELECT * FROM (VALUES (NULL, NULL), (3, 4), (3, 7)) v1;" values clause...
SQL subqueries come in several varieties, but as of super commit 7f23f65, we have yet to add support for even the simplest, e.g., ``` $ super -version Version: 7f23f6560 $...
The following query currently fails in SuperDB but works in Postgres. ``` $ super -version Version: 7f23f6560 $ super -c "SELECT * FROM (VALUES (3), ('42')) v1;" values clause must...
The following error message could likely be improved to something more like the one from Postgres. ``` $ super -version Version: 7f23f6560 $ super -c "SELECT * FROM (VALUES (1,...