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

TPC-H : correlated subquery : Query #17

    XMLWordPrintable

Details

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

    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.

      Attachments

        Issue Links

          Activity

            People

              denis0x0D Denis Khalikov
              denis0x0D Denis Khalikov
              Daniel Lee Daniel Lee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.