Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Critical
-
Resolution: Unresolved
-
5.5, 10.0, 10.1, 10.3.11, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11
-
Redhat el6
Description
With the same select statement, it produces different results with optimizer_switch='derived_merge=ON'; and optimizer_switch='derived_merge=OFF';
Reproduce test case:
1. Follow the test_case.rtf attached, create table t1 and insert data into t1; create table t2 and insert data to t2.
2. Set optimizer_switch='derived_merge=ON'; and run the select statement. It has empty set result.
3. Set optimizer_switch='derived_merge=OFF'; and run the same select statement. It has result set:
+--------------------+------------+ |
| T_FP | Test_Value |
|
+--------------------+------------+ |
| 731834939448428685 | 22 |
|
+--------------------+------------+ |
Thanks,
KT Chow