Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.6.2, 11.7.2, 11.8
-
docker
Description
CREATE TABLE t0(c1 TEXT);
|
CREATE TABLE t1 LIKE t0;
|
CREATE INDEX i1 ON t1(c1(1)) VISIBLE;
|
INSERT INTO t0(c1) VALUES('29'), ('30');
|
INSERT INTO t1(c1) VALUES("⅗");
|
|
SELECT t0.c1 AS t0c1, t1.c1 AS t1c1 FROM t1 STRAIGHT_JOIN t0 ON t1.c1 < t0.c1;
|
+------+------+
|
| t0c1 | t1c1 |
|
+------+------+
|
| 30 | ⅗ |
|
+------+------+
|
1 row in set (0.00 sec)
|
SELECT t0.c1 AS t0c1, t1.c1 AS t1c1 FROM t0 STRAIGHT_JOIN t1 ON t1.c1 < t0.c1;
|
Empty set (0.00 sec)
|