Luke Osborne comments

Results 28 comments of


                                            Luke Osborne

Panic when using `ROUND` function with big numbers

Related: [REA-4249](https://linear.app/readyset/issue/REA-4249/postgres-correctness-testing)

Support create cache from postgres queryid

seems like it should be pretty easy and high ROI

Support create cache from postgres queryid

@neeBis Absolutely! 🙌🏻 Note for this one: to query `pg_stat_statements`, the upstream database will have to have run `CREATE EXTENSION pg_stat_statement` at some point, or it will return an error....

Support create cache from postgres queryid

I reached out to @neeBis about the status of this and haven't heard back, so I'll move this back into the backlog for now.

Fix cache alias handling

I was able to workaround this by getting the original name from `remove_query` and using that to pass to the authority to remove the associated `create cache` statement. It seems...

[spike] explain materializations/graphviz time out for large materializations

![image.png](https://uploads.linear.app/76d4be3b-10f5-452e-a0bd-5ce299bfcdf4/f5732fa2-9eaf-4add-9180-287f90dd3fba/a951dc64-f3f1-4d17-ae41-f5d3fa3db008)

`show caches` breaks after seeing cached query alias

It looks like with @ethan-readyset's recent changes to show caches, `show caches` no longer breaks. There is still a mis-routing of the alias `select a from t1 where a =...

Re-run stored CREATE CACHE statements after snapshotting if we dropped controller state

[https://gerrit.readyset.name/c/readyset/+/6326](https://gerrit.readyset.name/c/readyset/+/6326)

Ensure nom-sql Display round-trips with parsing for select statements

Will pick up this one, [https://gerrit.readyset.name/c/readyset/+/5986](https://gerrit.readyset.name/c/readyset/+/5986) is the starting point

Ensure nom-sql Display round-trips with parsing for select statements

Made some fixes, still more to uncover for full query coverage. Will come back to this after getting the basic functionality implemented. [https://gerrit.readyset.name/c/readyset/+/6044](https://gerrit.readyset.name/c/readyset/+/6044) nom-sql: Support parsing floats with no RHS...