[MCOL-428] Implement OR correlated subquery Created: 2016-12-02 Updated: 2023-07-03 Resolved: 2023-07-02 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | N/A |
| Affects Version/s: | None |
| Fix Version/s: | Icebox |
| Type: | New Feature | Priority: | Major |
| Reporter: | Andrew Hutchings (Inactive) | Assignee: | Gagan Goel (Inactive) |
| Resolution: | Won't Do | Votes: | 5 |
| Labels: | community | ||
| Issue Links: |
|
||||
| Epic Link: | ColumnStore Compatibility Improvements | ||||
| Sprint: | 2020-4, 2020-5 | ||||
| Description |
|
From the Google Groups, this query fails:
With the error "Correlated subquery within OR operator is currently not supported". |
| Comments |
| Comment by Kleyson Rios [ 2017-06-11 ] | |||||||||||||||||||||||
|
Facing the same issue:
| |||||||||||||||||||||||
| Comment by GUIDI [ 2018-08-29 ] | |||||||||||||||||||||||
|
How to reproduce it in 1.1.5 version of Columnstore CREATE TABLE `sollicitations` ( SELECT cp.id_unique ERROR 1815 (HY000): Internal error: IDB-3033: Correlated subquery within OR operator is currently not supported. | |||||||||||||||||||||||
| Comment by Matias Sánchez [ 2019-12-26 ] | |||||||||||||||||||||||
|
Hi Guys? Any update on this compatibility issue supporting correlated subquery within or operator? | |||||||||||||||||||||||
| Comment by Roman [ 2020-04-09 ] | |||||||||||||||||||||||
|
Greetings, | |||||||||||||||||||||||
| Comment by Todd Stoffel (Inactive) [ 2020-08-27 ] | |||||||||||||||||||||||
|
Since a subquery "OR" operator is not currently supported, would a union satisfy the request here?
You could even use GROUP BY to dedup
| |||||||||||||||||||||||
| Comment by Todd Stoffel (Inactive) [ 2023-07-02 ] | |||||||||||||||||||||||
|
The "create date" on this ticket is pre-convergence with MariaDB server. If the issue still exists in a modern version of the engine/plugin please submit a new ticket. |