[MCOL-896] Function or Operator with sub query on the SELECT Created: 2017-08-29 Updated: 2023-11-21 Resolved: 2022-11-05 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MariaDB Server |
| Affects Version/s: | 1.0.10 |
| Fix Version/s: | Icebox |
| Type: | New Feature | Priority: | Minor |
| Reporter: | patrice | Assignee: | Todd Stoffel (Inactive) |
| Resolution: | Won't Do | Votes: | 1 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Epic Link: | ColumnStore Compatibility Improvements | ||||||||
| Description |
|
The following query gives : The storage engine for the table doesn't support IDB-3016: Function or Operator with sub query on the SELECT clause is currently not supported. select a as fi,(select fi)+2 as g from table; This simplify sql code with long nested formulas. |
| Comments |
| Comment by David Thompson (Inactive) [ 2017-08-30 ] |
|
This is a known limitation but i could not find an existing jira for this so thanks for reporting. Utilizing a subquery in the select list is not supported as columnstore maps this to a select on the temporary results table and so we don't currently have the ability to trigger a subquery execution for each result column. similarly referencing a prior column alias in the select list is not supported, you must duplicate the expression currently. |
| Comment by Todd Stoffel (Inactive) [ 2022-11-05 ] |
|
This item is being closed because it was well passed the expiration date with no activity. If you suspect this was done in error please create a new ticket. |