[MDEV-31645] Spider doesn't recognize semi JOIN - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5, 10.6, 10.11, 10.5.11, 10.5.19, 10.4(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL)
Fix Version/s: 10.4.33, 10.5.24, 10.6.17, 10.11.7, 11.0.5, 11.1.4, 11.2.3
Component/s: Storage Engine - Spider
Labels:
- spider-gbh
Environment:
Windows x64

Description

Have to disable semijoin optimizer switch due to Spider not recognizing the optimized query

Attachments

Attachments

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

SpiderSemiJoin-1.sql
1 kB
2023-07-07 16:15

Issue Links

is blocked by

MDEV-26247 Spider: Valid LEFT JOIN results in ERROR 1064

Closed

is part of

MDEV-26247 Spider: Valid LEFT JOIN results in ERROR 1064

Closed

relates to

MDEV-32238 Add a switch to disable spider group by handler

Closed

Activity

People

Assignee:: Yuchen Pei

Reporter:: Rob G

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2023-07-07 16:58

Updated:: 2023-11-22 02:53

Resolved:: 2023-11-17 00:43

Git Integration

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