Skip to content

tdengien查询同一个ts时间,oder by desc 和asc的时候结果不同 #35127

@xiaobao16

Description

@xiaobao16
Image Image 如果所示,版本3.3.8.8,分别执行sql,1:select * from iot_xxx.`zhrbb_1` where ts = '2026-04-05T23:59:30.000+08:00' order by ts desc,2:select * from iot_xxx.`zhrbb_1` where ts = '2026-04-05T23:59:30.000+08:00' order by ts asc 发现zwsj字段在24和11之间变动,怀疑在这个ts时间积累了很多数据 本来是3.3.5.8有这个问题,升级后发现有同样的问题

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions