当更新了sqlite3以后,首页展示数据发生错误
saxisuer opened this issue · 0 comments
saxisuer commented
更新了sqlite3以后 首页展示数据发生错误.
sqlite3更新到3.24以后
首页展示数据通过
select * from info where platform='ios' group by bundleID order by uploadTime desc limit 0,5
这条语句无法正确执行.
根据代码观察
应该替换成如下sql
select *
from (select id,
guid,
bundleID,
version,
build,
name,
uploadTime,
platform,
changelog,
row_number() over (partition by bundleID order by uploadTime desc) number
from info
where platform = ?) t
where number between ? and ?