Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.
CREATE TABLE t (name VARCHAR(10));
INSERT INTO t VALUES (0x6D617263656C6F);
readyset> SELECT * FROM t WHERE name = 0x6D617263656C6F;
+---------+
| name |
+---------+
| marcelo |
+---------+
1 row in set (0,00 sec)
readyset> CREATE CACHE FROM SELECT * FROM t WHERE name = 0x6D617263656C6F;
ERROR 1105 (HY000): Query failed to parse: SELECT * FROM t WHERE name = 0x6D617263656C6F
Description
We currently fail to parse HEX values:
Change in user-visible behavior
Requires documentation change