Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.5
-
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
- duplicates
-
MDEV-31007 Assertion `item->type() == Item::FIELD_ITEM || (item->type() == Item::REF_ITEM && ((Item_ref *) item)->ref_type() == Item_ref::VIEW_REF)' failed in find_producing_item
- Confirmed