Phil Rzewski

Verified in super commit 69d0499. The `ORDER BY` now has the expected impact, producing a query result that matches the one from Postgres. ``` $ super -version Version: 69d049968 $...

In reviewing this issue, @mccanne spotted that this is likely a problem with the the variable reference to `c` not making it through `sort`. He acknowledged this is a bug...

Verified in super commit f016b90. The replacement of the prior `over` functionality with new `unnest` functionality as added in #6021 removed the dependency on variables and so this bug no...

Building further off what was shown previously, in the absence of the proposed purpose-built `search_replace` function written in Go as a core part of the Zed language, it could be...

Also related: The original user later expressed an interest in being able to pull the search/replace pairings from a pool rather than defining them in a `const`. I was able...

Here's another example that may benefit from the availability of window functions. There's an existing community zync user that has been using pipe-based queries in the language since before SQL...

#5295 shows an example of how defaulting to representing fractional values as `float` vs. `decimal` creates an effect that may look like a bug to a user.

This become even more relevant in the SuperSQL era since `DECIMAL` and `NUMERIC` are part of standard SQL and appear in implementations such as Postgres.

@chrismo and I had a detailed offline discussion on this one, but I'll summarize here as I morph this issue into something we can circle back to in the future....

It was noted we could potentially work around this in the short term by running the query with a `-I` included set of [named types](https://superdb.org/docs/language/data-types/#named-types), but it looks like these...