zed
zed copied to clipboard
brimdata
A novel data lake based on super-structured data
Repro is with super commit 9449896. This was found via a query from [a sqllogictest](https://github.com/duckdb/duckdb/blob/0cbb56d14cc1464d945a06cb8bac051485fa2ef7/test/sql/aggregate/group/test_group_by.test#L167-L174). With the following input data `integers2.sup`: ``` {i:1(int32)} {i:2(int32)} {i:3(int32)} {i:null(int32)} ``` The output of...
As of when this issue is being opened, super is at commit 9449896. This was found via a query from [a sqllogictest](https://github.com/duckdb/duckdb/blob/0cbb56d14cc1464d945a06cb8bac051485fa2ef7/test/sql/aggregate/group/test_group_by.test#L192-L197). In Postgres for example, using a simplified version...
SuperSQL does not yet support duplicate column names in query results as is supported in standard SQL. ## Details Repro is with super commit 8f4cd56. This was found via a...
Repro is with super commit 9449896. This was found via a query from [a sqllogictest](https://github.com/duckdb/duckdb/blob/0cbb56d14cc1464d945a06cb8bac051485fa2ef7/test/sql/aggregate/group/test_group_by.test#L144-L149). Repro with test data: ``` $ cat integers.sup {i:3(int32),j:4(int32)} {i:3(int32),j:4(int32)} {i:2(int32),j:4(int32)} $ super -version Version:...
## tl;dr The following query works in Postgres but not SuperDB. ``` SELECT i, i + 10 FROM integers GROUP BY i ORDER BY i; ``` ## Details Repro is...
The following query works in Postgres but not SuperDB. ``` SELECT b, SUM(a) FROM test GROUP BY b ORDER BY COUNT(a); ``` ## Details Repro is with super commit e75dfda....
SuperSQL is currently accepting nested aggregate functions, but it looks like they're not supposed to be permitted in SQL. Therefore it seems we should either stop supporting them or document...
SQL clients often have a user config knob that can be used to specify how `NULL` values are presented. For formats with a well-defined spec like JSON or SUP it...
In CSV output, right now SuperDB represents null values and empty strings the same. Other systems render these differently, and we might want to think about doing something similar. ##...
Many SQL databases have the concept of a numeric "row identifier" that is always available on persistent tables as a pseudo/hidden column. It comes with caveats so it may not...