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

IN clause wrong results -add error msg

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 5.5.2, 5.6.5, 6.2.1
    • 22.08.1
    • None
    • None
    • 2021-17

    Description

      When specifying 100,000 values ​​in SELECT WHERE IN(1,2,10,), only 34,464 rows are returned. If the table does not specify Engine = Columnstore, it returns 100,000 rows correctly.

      Is there a limit to the number of IN() in ColumnStore?　

      (MAX 65,535?) MariaDB Version is 10.5.11.

      Attachments

        Activity

          People

            David.Hall David Hall (Inactive)
            toddstoffel Todd Stoffel (Inactive)
            Roman Roman
            Daniel Lee Daniel Lee (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            8 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.