[MCOL-5354] TPC-H : correlated subquery : Query #17 Created: 2022-12-15  Updated: 2023-02-14  Resolved: 2023-01-20

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: None
Fix Version/s: 23.02.1

Type: Bug Priority: Blocker
Reporter: Denis Khalikov Assignee: Denis Khalikov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
is blocked by MCOL-5195 Correlated subquery for equi/non-equi... Closed
Assigned for Testing: Daniel Lee Daniel Lee (Inactive)

 Description   

 
select
	sum(l_extendedprice) / 7.0 as avg_yearly
from
	lineitem,
	part
where
	p_partkey = l_partkey
	and p_brand = 'Brand#32'
	and p_container = 'LG PKG'
	and l_quantity < (
		select
			0.2 * avg(l_quantity)
		from
			lineitem
		where
			l_partkey = p_partkey
	);

Error:
IDB-3012: Scalar filter and semi join are not from the same pair of tables.



 Comments   
Comment by Roman [ 2023-01-19 ]

The patch has been merged and will be available in the develop nightly build.

Comment by Daniel Lee (Inactive) [ 2023-01-20 ]

Build verified: 23.02 (Drone build: 6532)

Verified with 1g database. Also check require result against that from MariaDB server. Matched.

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