[MCOL-1414] Function or Operator with sub query on the SELECT clause Created: 2018-05-15 Updated: 2022-11-05 Resolved: 2022-11-05 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | N/A |
| Affects Version/s: | 1.1.4 |
| Fix Version/s: | Icebox |
| Type: | New Feature | Priority: | Major |
| Reporter: | patrice | Assignee: | Todd Stoffel (Inactive) |
| Resolution: | Won't Do | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
SQL Error [1178] [42000]: (conn:4401) 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. Query is: select (select count(distinct x) from a) -(select count(distinct x) from b) Is this not valid sql ? |
| Comments |
| Comment by David Hall (Inactive) [ 2018-05-15 ] |
|
This is legal SQL, but columnstore doesn't handle it. |
| Comment by Todd Stoffel (Inactive) [ 2022-11-05 ] |
|
Item is out of date. Closing due to inactivity. If you feel this was done in error please open a new ticket. |