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

Wrong filter ordering for query with sub select

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 23.02.8
    • 23.02.8
    • MDB Plugin
    • None
    • 2024-1

    Description

      CS applies filters in wrong order for some type of query with sub select.
      For example:

      select * from (select func(a) from t1) as s1 where s1.a = value;

      The filter "where s1.a= values" is applied for "a" column early than "func(a)" which cause a wrong result for some type of queries.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5237 MariaDB Columnstore: Views with null-replaced timestamps yield incorrect query results

          • Major - Major loss of function.
          • Closed

          Activity

            People

              denis0x0D Denis Khalikov
              denis0x0D Denis Khalikov
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.