Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
Description
The CONNECT engine support PIVOT.
https://mariadb.com/kb/en/mariadb/connect-table-types-pivot-table-type/
This task is to add native support for PIVOT.
https://technet.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx
Syntax:
SELECT <non-pivoted column>, |
[first pivoted column] AS <column name>, |
[second pivoted column] AS <column name>, |
...
|
[last pivoted column] AS <column name> |
FROM
|
(<SELECT query that produces the data>) |
AS <alias> |
PIVOT
|
(
|
<aggregation function>(<column being aggregated>) |
FOR
|
[<column that contains the values that will become column headers>] |
IN ( [first pivoted column], [second pivoted column], |
... [last pivoted column]) |
) AS <alias for the pivot table> |
<optional ORDER BY clause>; |
Attachments
Issue Links
- duplicates
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Epic Link | MDEV-10137 [ 56868 ] |
| Description |
The CONNECT engine support PIVOT.
https://mariadb.com/kb/en/mariadb/connect-table-types-pivot-table-type/ This task is to add native support for PIVOT. https://technet.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx |
The CONNECT engine support PIVOT.
https://mariadb.com/kb/en/mariadb/connect-table-types-pivot-table-type/ This task is to add native support for PIVOT. https://technet.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx Syntax: SELECT <non-pivoted column>, [first pivoted column] AS <column name>, [second pivoted column] AS <column name>, ... [last pivoted column] AS <column name> FROM (<SELECT query that produces the data>) AS <alias> PIVOT ( <aggregation function>(<column being aggregated>) FOR [<column that contains the values that will become column headers>] IN ( [first pivoted column], [second pivoted column], ... [last pivoted column]) ) AS <alias for the pivot table> <optional ORDER BY clause>; |
| Description |
The CONNECT engine support PIVOT.
https://mariadb.com/kb/en/mariadb/connect-table-types-pivot-table-type/ This task is to add native support for PIVOT. https://technet.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx Syntax: SELECT <non-pivoted column>, [first pivoted column] AS <column name>, [second pivoted column] AS <column name>, ... [last pivoted column] AS <column name> FROM (<SELECT query that produces the data>) AS <alias> PIVOT ( <aggregation function>(<column being aggregated>) FOR [<column that contains the values that will become column headers>] IN ( [first pivoted column], [second pivoted column], ... [last pivoted column]) ) AS <alias for the pivot table> <optional ORDER BY clause>; |
The CONNECT engine support PIVOT.
https://mariadb.com/kb/en/mariadb/connect-table-types-pivot-table-type/ This task is to add native support for PIVOT. https://technet.microsoft.com/en-us/library/ms177410%28v=sql.105%29.aspx Syntax: {code:sql} SELECT <non-pivoted column>, [first pivoted column] AS <column name>, [second pivoted column] AS <column name>, ... [last pivoted column] AS <column name> FROM (<SELECT query that produces the data>) AS <alias> PIVOT ( <aggregation function>(<column being aggregated>) FOR [<column that contains the values that will become column headers>] IN ( [first pivoted column], [second pivoted column], ... [last pivoted column]) ) AS <alias for the pivot table> <optional ORDER BY clause>; {code} |
| Labels | Compatibility |
| Epic Link | MDEV-10137 [ 56868 ] | MDEV-10872 [ 58182 ] |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.2 [ 14601 ] |
| Labels | Compatibility | Compatibility NRE-307517 |
| NRE Projects | NRE-307517 |
| Labels | Compatibility NRE-307517 | Compatibility |
| Link |
This issue duplicates |
| Fix Version/s | 10.3 [ 22126 ] |
| Support case ID | not-26307 |
| NRE Projects | AC-2610/DEFERRED |
| Workflow | MariaDB v3 [ 75814 ] | MariaDB v4 [ 130486 ] |
Does this include support for UNPIVOT?
The duplicate MDEV-12228 and the Microsoft link explicitly mention unpiviot, but the MariaDB link to to the CONNECT engine does not, and there is no syntax suggestion as there is for PIVOT.
Would be good to clarify.
I would really appreciate this feature, I think it would be useful to many many people.
Thanks,
T.
Is it expected for MariaDB 10.3.6 RC?
Thank you.
Juan