Skip to content

[ 问题咨询 ] mysql的查询改写逻辑是什么? #739

@phantomsoul

Description

@phantomsoul

在提交 issue 前,请查阅以下资源,请先进行搜索来保证没有类似的 issue。
文档 | FAQ

重现步骤

select `id` as `site_id`, `nick_name` from `kbd_site_info` where `nick_name` like '%丸子%' order by `created_at` desc limit 10
执行结果有数据
select `id` as `site_id`, `nick_name` from `kbd_site_info` where `nick_name` like '%丸子%' order by `created_at` desc limit 10 offset 0
执行结果没数据
select `id` as `site_id`, `nick_name` from `kbd_site_info` where `nick_name` like '%丸子%' order by `created_at` desc limit 10 offset 1
执行结果只有一条数据

期待结果和实际结果

期待结果:
根据正常SQL语法的到数据
实际结果:
无法获取数据

截图

微信截图_20200514095218
微信截图_20200514095234
微信截图_20200514095202

错误日志

版本信息

应用版本/分支:

部署方式:Docker、手工部署

Metadata

Metadata

Assignees

No one assigned

    Labels

    duplicateThis issue or pull request already exists

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions