readyset
readyset copied to clipboard
Panic with `LITERAL != COLUMN`
Describe the problem
psql> CREATE CACHE FROM SELECT SUM(val) FROM m WHERE 123 != foo_id;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
To Reproduce
See above. I don't think any special table layout is necessary to reproduce but let me know if you need more information.
Expected behavior
Should work as foo_id != 123 does, or as 123 = foo_id does.
Additional data / screenshots
See full backtrace
Environment
- ReadySet version [e.g., beta-2022-11-02]:
stable-240919 - ReadySet deployment method [e.g, local orchestrator, Helm chart, binaries]: binary built from source
- Upstream database and version [e.g., Postgres 14]: Postgres 14
- Client app [e.g.,
psql,mysql, SQLAlchemy, TypeORM]:psql
Additional context
We did not in fact check 'op.is_ordering_comparison()' in this code path. Thank you for the report!
The issue has been fixed and merged into main branch.