[MCOL-3544] insert into multiple common table expressions givens syntax error Created: 2019-10-07 Updated: 2023-03-06 Resolved: 2023-03-06 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | N/A |
| Affects Version/s: | 1.2.5 |
| Fix Version/s: | Icebox |
| Type: | Bug | Priority: | Major |
| Reporter: | David Hill (Inactive) | Assignee: | Unassigned |
| Resolution: | Won't Do | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Reported by customer. Not sure if this is a BUG or a query that is not supported. Here is the error that get: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '),ms2 as ( select subcategory, count Posting query in next comment that is available only to development. |
| Comments |
| Comment by David Hall (Inactive) [ 2019-10-10 ] |
|
This is confirmed for 1.2.5. The problem does not exist in 1.4 (not released) |
| Comment by David Hill (Inactive) [ 2019-10-10 ] |
|
I will let the customer know that its not supported in 1.2.5, but is in 1.4 |
as num_records from ms1 group by 1 ),mul' at line 1