[MCOL-1497] GROUP BY handler doesn't support outer join. Created: 2018-06-23  Updated: 2018-07-18  Resolved: 2018-07-18

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: 1.2
Fix Version/s: 1.2.0

Type: Bug Priority: Minor
Reporter: Roman Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2018-13, 2018-14

 Description    

MariaDB [tpch1c]> set infinidb_vtable_mode=0;
 
Query OK, 0 rows affected (0.00 sec)
 
 
 
MariaDB [tpch1c]>  SELECT C_COUNT, COUNT(*) AS CUSTDIST FROM ( SELECT C_CUSTKEY, COUNT(c_nationKEY) c_COUNT FROM  region left outer join customer on   c_nationkey = r_regionkey AND  r_comment not like '%%express%%requests%%' GROUP BY  C_CUSTKEY ) C_ORDERS GROUP BY C_COUNT ORDER BY  CUSTDIST DESC, C_COUNT DESC;
 
ERROR 1815 (HY000): Internal error: IDB-1000: 'region' and 'customer' are not joined.



 Comments   
Comment by Roman [ 2018-07-09 ]

Please review.

Comment by Daniel Lee (Inactive) [ 2018-07-18 ]

Build verified: 1.2.0-1 source

/root/columnstore/mariadb-columnstore-server
commit 3bfc3ad5f1e91e6f325b89fefaf62a6b38ca889a
Merge: 4334641 742af4d
Author: David.Hall <david.hall@mariadb.com>
Date: Thu May 31 09:40:12 2018 -0500

Merge pull request #119 from mariadb-corporation/1.1-merge-up-20180531

Merge develop-1.1 into develop

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 4a3f8b77c2e3fe2ec311150c79551900324e59e8
Merge: 6aedf1d a62a2e3
Author: Andrew Hutchings <andrew@linuxjedi.co.uk>
Date: Wed Jul 18 09:34:13 2018 +0100

Merge pull request #519 from drrtuy/MCOL-1510

MCOL-1510 GROUP BY handler doesn't support operations on aggregate functions when projecting columns.

MariaDB [tpch1]> SELECT C_COUNT, COUNT AS CUSTDIST FROM ( SELECT C_CUSTKEY, COUNT(c_nationKEY) c_COUNT FROM region left outer join customer on c_nationkey = r_regionkey AND r_comment not like '%%express%%requests%%' GROUP BY C_CUSTKEY ) C_ORDERS GROUP BY C_COUNT ORDER BY CUSTDIST DESC, C_COUNT DESC;
-----------------+

C_COUNT CUSTDIST

-----------------+

1 29914

-----------------+
1 row in set (0.49 sec)

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