MariaDB 和 Mysql 的一个很奇怪的区别，怎么破？ - V2EX

Home Sign Up Sign In

This topic created in 4246 days ago, the information mentioned may be changed or developed.

select * from (select id from xx order by id desc) as abc

这句子查询

mysql 返回的是降序的id
MariaDB 返回的却是升序的，非要把 order by 放在子查询外面。这是MariaDB的特性还是有什么开关可以让它兼容在子查询里排序？

3 replies • 2014-10-21 18:47:45 +08:00

1

woshixiaomao

Oct 21, 2014

版本问题,旧版的是不支持自查询的,.

2

Mac

OP

Oct 21, 2014 via Android

@woshixiaomao 用的是版本10，应该不是版本问题，和子查询无关啊，只是order by有点问题

3

Automan

Oct 21, 2014

1

https://mariadb.com/kb/en/mariadb/faq/general-faq/why-is-order-by-in-a-from-subquery-ignored/

About · Help · Advertise · Blog · API · FAQ · Solana · 2563 Online Highest 6679 ·

Select Language

创意工作者们的社区

World is powered by solitude

VERSION: 3.9.8.5 · 41ms · UTC 01:40 · PVG 09:40 · LAX 18:40 · JFK 21:40
♥ Do have faith in what you're doing.