readyset icon indicating copy to clipboard operation
readyset copied to clipboard

Parse Hexadecimal values

Open altmannmarcelo opened this issue 8 months ago • 0 comments

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

altmannmarcelo avatar Jun 13 '24 20:06 altmannmarcelo