[MCOL-4800] IN clause wrong results -add error msg - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5.2, 5.6.5, 6.2.1
Fix Version/s: 22.08.1
Component/s: None
Labels:
None

Sprint:
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

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

hourly_sample.tsv.gz
3.73 MB
2022-06-29 16:16

Issue Links

mentioned in: Page Loading...

Activity

People

Assignee:: David Hall (Inactive)

Reporter:: Todd Stoffel (Inactive)

Assigned for Review:: Roman

Assigned for Testing:: Daniel Lee (Inactive)

Votes:: 2 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2021-07-06 04:34

Updated:: 2024-04-08 15:58

Resolved:: 2022-08-10 18:23

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.