readyset
readyset copied to clipboard
Parse Hexadecimal values
Description
We currently fail to parse HEX values:
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
Change in user-visible behavior
Requires documentation change