readyset icon indicating copy to clipboard operation
readyset copied to clipboard

Panic with `LITERAL != COLUMN`

Open jscheid opened this issue 1 year ago • 1 comments

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

Famous last words? 😺

jscheid avatar Oct 16 '24 09:10 jscheid

We did not in fact check 'op.is_ordering_comparison()' in this code path. Thank you for the report!

gvsg-rs avatar Oct 18 '24 04:10 gvsg-rs

The issue has been fixed and merged into main branch.

vassili-zarouba avatar Oct 30 '24 18:10 vassili-zarouba