Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.2.2
-
None
-
2018-20, 2018-21, 2019-01, 2019-02, 2019-03, 2019-04, 2019-05, 2019-06
Description
ATM GROUP by failes to process the query:
MariaDB [test]> select sum(i) from cs2 where cs2.i in ( select i from cs3 );
|
ERROR 1815 (HY000): Internal error: IDB-1000: 'cs2' and 'cs3' are not joined.
|
Internally optimizer sends a number of filter predicates that I asked an optimizer team about:
(gdb) p query->where
|
$1 = (Item_int *) 0x7f4570019af8
|
(gdb) p query->where->next
|
$2 = (Item_equal *) 0x7f4570017970
|
(gdb) p query->where->next->next
|
$3 = (Item_cond_and *) 0x7f4570017838
|
(gdb) p query->from->select_lex->cond_count
|
$4 = 2
|
