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

TPC-H : correlated subquery : Query #17

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

          is blocked by

          Task - A task that needs to be done. MCOL-5195 Correlated subquery for equi/non-equi scalar filter and join condition (TPC-H q2, q17)

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            drrtuy Roman added a comment -

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

            drrtuy Roman added a comment - The patch has been merged and will be available in the develop nightly build.
            dleeyh Daniel Lee (Inactive) added a comment -

            Build verified: 23.02 (Drone build: 6532)

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

            dleeyh Daniel Lee (Inactive) added a comment - Build verified: 23.02 (Drone build: 6532) Verified with 1g database. Also check require result against that from MariaDB server. Matched.

            People

              denis0x0D Denis Khalikov (Inactive)
              denis0x0D Denis Khalikov (Inactive)
              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.