[MDEV-17517] Issue in converting Pivot table from MariaDB Server from version 10.3 to 10.1 Created: 2018-10-22 Updated: 2018-10-23 Resolved: 2018-10-23 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Server |
| Affects Version/s: | 10.1.36 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Nishanth | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Converting the SQL From TO MariaDB Server from version 10.1 or MySQL 5.6 |
| Comments |
| Comment by Elena Stepanova [ 2018-10-22 ] |
|
Please describe the issue properly: what you do, what result you are getting, what result you expect, and why you think the actual result is incorrect. |
| Comment by Nishanth [ 2018-10-23 ] |
|
Window functions (ROW_NUMBER() OVER(...)) where introduced to MariaDB with version 10.2 and to MySQL with version 8.0. They were simply not available in earlier versions of MariaDB with version 10.1 Is there any alternative solution in order to fix this issue and implement this in earlier versions? |
| Comment by Elena Stepanova [ 2018-10-23 ] |
|
JIRA is a bug reporting and feature request tracking system, it is not the right palce for seeking advice. Please use public mailing lists, forums and other community resources. You might also consider acquiring a support contract. If you have one already, please open a support ticket. |