[MDEV-13055] from select statement not normal result Created: 2017-06-12 Updated: 2017-06-12 Resolved: 2017-06-12 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Manipulation - Subquery |
| Affects Version/s: | 5.5.52-galera |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | michael chan | Assignee: | Sergei Golubchik |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Environment: |
CentOS7 |
||
| Issue Links: |
|
||||||||
| Description |
|
SELECT * FROM (SELECT * FROM table WHERE ORDER BY id DESC) AS table_name ORDER BY not work but add LIMIT key word is normal |
| Comments |
| Comment by Sergei Golubchik [ 2017-06-12 ] |
|
This is not bug, see https://mariadb.com/kb/en/mariadb/why-is-order-by-in-a-from-subquery-ignored/ |