Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5.28a, 5.3.9, 5.2.13, 5.1.66
-
None
Description
The following query:
UPDATE part RIGHT JOIN partsupp ON ( p_partkey = ps_partkey ) RIGHT JOIN supplier |
ON ( ps_suppkey = s_suppkey ) RIGHT JOIN nation ON ( s_nationkey = n_nationkey ) JOIN |
region ON ( n_regionkey = r_regionkey ) SET s_name = DEFAULT , r_comment = DEFAULT |
WHERE r_comment IS NOT NULL OR ps_suppkey BETWEEN 10 AND 14; |
updates one row in supplier with table_elimination=on and no rows with table_elimination=off .
Test case:
PREPARE p1 FROM " |
UPDATE part RIGHT JOIN partsupp ON ( p_partkey = ps_partkey ) RIGHT JOIN supplier
|
ON ( ps_suppkey = s_suppkey ) RIGHT JOIN nation ON ( s_nationkey = n_nationkey ) JOIN
|
region ON ( n_regionkey = r_regionkey ) SET s_name = DEFAULT , r_comment = DEFAULT
|
WHERE r_comment IS NOT NULL OR ps_suppkey BETWEEN 10 AND 14;"; |
SET AUTOCOMMIT=OFF; |
SET SESSION optimizer_switch = 'table_elimination=on'; |
START TRANSACTION; |
EXECUTE p1; |
SELECT s_name FROM supplier; |
ROLLBACK; |
SET SESSION optimizer_switch = 'table_elimination=off'; |
START TRANSACTION; |
EXECUTE p1; |
SELECT s_name FROM supplier; |
ROLLBACK; |
dataset (load with storage-engine=InnoDB):