Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5353

TPC-H: correlated subquery : Query #2 :

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • None
    • 23.02.1
    • ExeMgr
    • None

    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.

      Attachments

        Issue Links

          Activity

            People

              denis0x0D Denis Khalikov
              denis0x0D Denis Khalikov
              Daniel Lee Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.