[MCOL-5353] TPC-H: correlated subquery : Query #2 : 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
	s_acctbal,
	s_name,
	n_name,
	p_partkey,
	p_mfgr,
	s_address,
	s_phone,
	s_comment
from
	part,
	supplier,
	partsupp,
	nation,
	region
where
	p_partkey = ps_partkey
	and s_suppkey = ps_suppkey
	and p_size = 5
	and p_type like '%STEEL'
	and s_nationkey = n_nationkey
	and n_regionkey = r_regionkey
	and r_name = 'ASIA'
	and ps_supplycost = (
		select
			min(ps_supplycost)
		from
			partsupp,
			supplier,
			nation,
			region
		where
			p_partkey = ps_partkey
			and s_suppkey = ps_suppkey
			and s_nationkey = n_nationkey
			and n_regionkey = r_regionkey
			and r_name = 'ASIA'
	)
order by
	s_acctbal desc,
	n_name,
	s_name,
	p_partkey
limit 100;

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



 Comments   
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.