[MCOL-1963] GROUP BY doesn't process IN + correlate subquery. Created: 2018-11-26  Updated: 2020-03-13  Resolved: 2020-02-19

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: 1.2.2
Fix Version/s: 1.4.3

Type: Bug Priority: Minor
Reporter: Roman Assignee: Roman
Resolution: Fixed Votes: 1
Labels: None

Issue Links:
Relates
relates to MCOL-2147 Semi-join with correllated subquery c... Closed
relates to MCOL-1716 GROUP BY handler incorrectly process ... Closed
relates to MCOL-2165 Autoswitch broken in some cases in 1.2.2 Closed
Sprint: 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



 Comments   
Comment by Roman [ 2019-02-23 ]

The temporary workaround was introduced by MCOL-2165.

Generated at Thu Feb 08 02:32:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.