Description:
Test case generated with SQLancer
Given a table with an index on a text column.
CREATE TABLE t0(c0 MEDIUMTEXT);
CREATE INDEX i0 USING BTREE ON t0(c0(1) DESC);
INSERT INTO t0(c0) VALUES (1);
The result size for a simple select query is 1.
SELECT t0.c0 AS ref0 FROM t0; -- size 1
With the predicate '̏D' > (t0.c0) where '̏ (a quote and a combining double grave symbol (U+030F)) is used. Selects with the predicate and negated predicates both do not return any records.
SELECT ALL t0.c0 AS ref0 FROM t0 WHERE ('̏D') > (t0.c0); -- size 0
SELECT ALL t0.c0 AS ref0 FROM t0 WHERE (! (('̏D') > (t0.c0))); -- size 0
How to repeat:
DROP DATABASE IF EXISTS database0;
CREATE DATABASE database0;
USE database0;
CREATE TABLE t0(c0 MEDIUMTEXT);
CREATE INDEX i0 USING BTREE ON t0(c0(1) DESC);
INSERT INTO t0(c0) VALUES (1), (NULL);
SELECT t0.c0 AS ref0 FROM t0; -- size 2
SELECT ALL t0.c0 AS ref0 FROM t0 WHERE ('̏D') > (t0.c0); -- size 0
SELECT ALL t0.c0 AS ref0 FROM t0 WHERE (! (('̏D') > (t0.c0))); -- size 0
SELECT ALL t0.c0 AS ref0 FROM t0 WHERE (('̏D') > (t0.c0)) IS UNKNOWN; -- size 1