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

@saxisuer

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 ?

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