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

Count with view is incorrect

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.4.3
    • 1.4.5, 1.5.1
    • MDB Plugin
    • None

    Description

      queries/working_tpch1_compareLogOnly/misc/bug5764.sql should return 2 for count, yet returns 10.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          jrojas Jose Rojas (Inactive) added a comment -

          This is not actually an issue with count, however, it is an issue that pertains to a view used in subquery.

          Previously a fix for MCOL-1349 reinstated some code for fix outer joins with views being processed twice. There is a case where a view inside a subquery was not processing it's outer join at all. Added a fix here to allow view in subquery to process outerjoin.

          Reinstated regression test that was broken and added a separate regression test related to MCOL-1349 as well

          jrojas Jose Rojas (Inactive) added a comment - This is not actually an issue with count, however, it is an issue that pertains to a view used in subquery. Previously a fix for MCOL-1349 reinstated some code for fix outer joins with views being processed twice. There is a case where a view inside a subquery was not processing it's outer join at all. Added a fix here to allow view in subquery to process outerjoin. Reinstated regression test that was broken and added a separate regression test related to MCOL-1349 as well
          dleeyh Daniel Lee (Inactive) added a comment -

          Build verified: 1.5.0-1 (drone 20200602)

          Verified count() returned 2.

          dleeyh Daniel Lee (Inactive) added a comment - Build verified: 1.5.0-1 (drone 20200602) Verified count() returned 2.
          dleeyh Daniel Lee (Inactive) added a comment -

          Build verified: 1.4.5-1 (drone 20200603, engine commit: 89b7e0ad)

          dleeyh Daniel Lee (Inactive) added a comment - Build verified: 1.4.5-1 (drone 20200603, engine commit: 89b7e0ad)

          People

            dleeyh Daniel Lee (Inactive)
            David.Hall David Hall (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.