Skip to content
This repository was archived by the owner on Mar 25, 2022. It is now read-only.
This repository was archived by the owner on Mar 25, 2022. It is now read-only.

当更新了sqlite3以后,首页展示数据发生错误 #30

Description

@saxisuer

更新了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 ?

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions