Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5
-
None
-
None
Description
CREATE TABLE t1 (c1 INT);
|
INSERT INTO t1 VALUES (1);
|
CREATE TABLE t2 (c2 INT);
|
INSERT INTO t2 VALUES (1);
|
|
SET optimizer_switch='derived_merge=off';
|
|
EXPLAIN EXTENDED
|
SELECT dt1_c1 FROM
|
(SELECT c1 AS dt1_c1 FROM t1) AS dt1
|
JOIN
|
(SELECT 1 AS dt2_c2 FROM t2) AS dt2
|
ON DEFAULT(dt2_c2) BETWEEN dt1_c1 AND dt1_c1;
|
Attachments
Issue Links
- relates to
-
MDEV-25012 Server crash in find_field_in_tables, Assertion `name' failed in find_field_in_table_ref
- Confirmed
-
MDEV-33010 Condition with CHARSET()/COERCIBILITY() erroneously pushed into derived table
- Stalled