mysql查询问题

[卿久久丶]

SELECT * FROM (SELECT
obj.userId,
obj.allAsset,
CASE
WHEN @rowtotal = obj.allAsset THEN
@rownum
WHEN @rowtotal := obj.allAsset THEN
@rownum := @rownum + 1
WHEN @rowtotal = 0 THEN
@rownum := @rownum + 1
END AS rownum
FROM
(
SELECT
userId,
allAsset
FROM
`UserAsset` ORDER BY allAsset DESC
) AS obj ,
(SELECT @rownum := 0 ,@rowtotal := NULL) r) AS R
5.5.56版本通过此查询查询出来的数据不正确，5.7查询出来的数据是正确的
下边是数据库表信息

[卿久久丶]

找到原因啦，因为mariadb跟mysql的order by策略不一样，mariadb需要加一个limit才能保证子查询的order by被执行