[MCOL-5316] Subselect sorting is single-threaded always - Jira

Details

Type: Task
Status: Stalled (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 22.08.4
Fix Version/s: 23.10
Component/s: PrimProc
Labels:
None

Sprint:
2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11, 2023-12, 2024-1, 2024-2, 2025-2

Description

The recent external sorting project reveals that subquery has thread factor set to 1 no matter what is a value of columnstore_orderby_threads.

Attachments

Activity

Ascending order - Click to sort in descending order

Roman created issue - 2022-11-18 22:51

alexey vorovich (Inactive) made changes - 2022-11-28 21:20

Field	Original Value	New Value
Fix Version/s		23.02 [ 28209 ]
Fix Version/s	23.03.1 [ 28458 ]

Todd Stoffel (Inactive) made changes - 2022-12-06 22:00

Rank

Ranked higher

Todd Stoffel (Inactive) made changes - 2022-12-27 07:02

Sprint

2022-22 [ 672 ]

2022-22, 2022-23 [ 672, 686 ]

Todd Stoffel (Inactive) made changes - 2023-02-07 20:23

Fix Version/s		23.08 [ 28540 ]
Fix Version/s	23.02 [ 28209 ]

Todd Stoffel (Inactive) made changes - 2023-02-17 20:58

Sprint

2022-22, 2022-23 [ 672, 686 ]

2022-22, 2022-23, 2022-24 [ 672, 686, 698 ]

Todd Stoffel (Inactive) made changes - 2023-03-16 18:22

Sprint

2022-22, 2022-23, 2023-4 [ 672, 686, 698 ]

2022-22, 2022-23, 2023-4, 2023-5 [ 672, 686, 698, 702 ]

Todd Stoffel (Inactive) made changes - 2023-04-06 05:19

Sprint

2022-22, 2022-23, 2023-4, 2023-5 [ 672, 686, 698, 702 ]

2022-22, 2022-23, 2023-4, 2023-5, 2023-6 [ 672, 686, 698, 702, 706 ]

Todd Stoffel (Inactive) made changes - 2023-07-01 20:18

Sprint

2022-22, 2022-23, 2023-4, 2023-5, 2023-6 [ 672, 686, 698, 702, 706 ]

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7 [ 672, 686, 698, 702, 706, 726 ]

Todd Stoffel (Inactive) made changes - 2023-07-01 20:41

Rank

Ranked lower

Todd Stoffel (Inactive) made changes - 2023-07-17 07:06

Sprint

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7 [ 672, 686, 698, 702, 706, 726 ]

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8 [ 672, 686, 698, 702, 706, 726, 728 ]

Roman made changes - 2023-07-25 16:14

Status

Open [ 1 ]

In Progress [ 3 ]

alexey vorovich (Inactive) made changes - 2023-07-26 15:41

Summary

Subselect sorting is single-threaded whatsoever

Subselect sorting is single-threaded always

Todd Stoffel (Inactive) made changes - 2023-08-25 22:55

Sprint

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8 [ 672, 686, 698, 702, 706, 726, 728 ]

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-9 [ 672, 686, 698, 702, 706, 726, 728, 733 ]

Todd Stoffel (Inactive) made changes - 2023-08-25 22:55

Sprint

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-9 [ 672, 686, 698, 702, 706, 726, 728, 733 ]

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10 [ 672, 686, 698, 702, 706, 726, 728, 734 ]

Todd Stoffel (Inactive) made changes - 2023-09-13 19:50

Sprint

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10 [ 672, 686, 698, 702, 706, 726, 728, 734 ]

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11 [ 672, 686, 698, 702, 706, 726, 728, 734, 737 ]

Julien Fritsch made changes - 2023-12-15 08:52

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Julien Fritsch made changes - 2023-12-15 08:54

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Julien Fritsch made changes - 2023-12-15 08:54

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Leonid Fedorov made changes - 2023-12-18 12:35

Assignee

Roman [ drrtuy ]

Leonid Fedorov [ JIRAUSER48443 ]

Leonid Fedorov made changes - 2023-12-21 14:53

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Leonid Fedorov made changes - 2023-12-21 15:15

Sprint

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11 [ 672, 686, 698, 702, 706, 726, 728, 734, 737 ]

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11, 2023-13 [ 672, 686, 698, 702, 706, 726, 728, 734, 737, 748 ]

JiraAutomate made changes - 2024-02-04 10:20

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Julien Fritsch made changes - 2024-03-19 12:43

Sprint

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11, 2023-12 [ 672, 686, 698, 702, 706, 726, 728, 734, 737, 748 ]

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11, 2023-12, 2023-13 [ 672, 686, 698, 702, 706, 726, 728, 734, 737, 748, 755 ]

Leonid Fedorov made changes - 2024-07-03 14:14

Component/s		PrimProc [ 13700 ]
Component/s	MDB Plugin [ 13801 ]

Julien Fritsch made changes - 2024-07-31 13:30

Sprint

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11, 2023-12, 2024-1 [ 672, 686, 698, 702, 706, 726, 728, 734, 737, 748, 755 ]

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11, 2023-12, 2024-1, 2024-2 [ 672, 686, 698, 702, 706, 726, 728, 734, 737, 748, 755, 764 ]

Leonid Fedorov made changes - 2024-07-31 13:50

Fix Version/s		23.10.3 [ 29862 ]
Fix Version/s	23.10 [ 28540 ]

Leonid Fedorov made changes - 2024-07-31 13:50

Status

Stalled [ 10000 ]

In Progress [ 3 ]

Leonid Fedorov made changes - 2024-07-31 13:50

Status

In Progress [ 3 ]

In Testing [ 10301 ]

Leonid Fedorov made changes - 2025-01-09 15:02

Fix Version/s		23.10 [ 28540 ]
Fix Version/s	23.10.3 [ 29862 ]

Julien Fritsch made changes - 2025-02-03 15:34

Sprint

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11, 2023-12, 2024-1, 2024-2 [ 672, 686, 698, 702, 706, 726, 728, 734, 737, 748, 755, 764 ]

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11, 2023-12, 2024-1, 2024-2, 2024-3 [ 672, 686, 698, 702, 706, 726, 728, 734, 737, 748, 755, 764, 784 ]

Allen Herrera made changes - 2025-03-11 14:14

Sprint

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11, 2023-12, 2024-1, 2024-2, 2025-1 [ 672, 686, 698, 702, 706, 726, 728, 734, 737, 748, 755, 764, 784 ]

2022-22, 2022-23, 2023-4, 2023-5, 2023-6, 2023-7, 2023-8, 2023-10, 2023-11, 2023-12, 2024-1, 2024-2, 2025-2 [ 672, 686, 698, 702, 706, 726, 728, 734, 737, 748, 755, 764, 788 ]

Roman made changes - 2025-03-14 11:25

Resolution		Fixed [ 1 ]
Status	In Testing [ 10301 ]	Closed [ 6 ]