[MDEV-20753] Sequence with limit 0 crashes server - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Duplicate
Affects Version/s: 10.3.18, 10.4.8
Fix Version/s: 10.3.19, 10.4.9
Component/s: Optimizer
Labels:
None

Attachments

Activity

Ascending order - Click to sort in descending order

Oleksandr Byelkin created issue - 2019-10-04 13:51

Oleksandr Byelkin made changes - 2019-10-04 14:17

Field	Original Value	New Value
Status	Open [ 1 ]	In Progress [ 3 ]

Oleksandr Byelkin added a comment - 2019-10-04 14:40

Problem is that query resolved without JOIN (limit 0) but we still trying to push it down to engine (which is not needed any more)

Oleksandr Byelkin added a comment - 2019-10-04 14:40 Problem is that query resolved without JOIN (limit 0) but we still trying to push it down to engine (which is not needed any more)

Oleksandr Byelkin added a comment - 2019-10-05 07:19

Fix is still come with this bug and test cases from the duplicated added.

Oleksandr Byelkin added a comment - 2019-10-05 07:19 Fix is still come with this bug and test cases from the duplicated added.

Oleksandr Byelkin made changes - 2019-10-05 07:19

Component/s		Optimizer [ 10200 ]
Component/s	OTHER [ 10125 ]
Fix Version/s		10.3.19 [ 23908 ]
Fix Version/s		10.4.9 [ 23906 ]
Fix Version/s	10.3 [ 22126 ]
Fix Version/s	10.4 [ 22408 ]
Resolution		Duplicate [ 3 ]
Status	In Progress [ 3 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:50

Workflow

MariaDB v3 [ 100187 ]

MariaDB v4 [ 156822 ]

People

Assignee:: Oleksandr Byelkin

Reporter:: Oleksandr Byelkin

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 2019-10-04 13:51

Updated:: 2019-10-09 06:55

Resolved:: 2019-10-05 07:19

Git Integration

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

MariaDB Server