Skip to content

使用原生sql语句配合Limit函数进行数据库分页查询出错 #109

@ly269nva

Description

@ly269nva

当我使用一下语句查询 Mysql 数据库表第一条数据时
r2, err2 := session.SQL("select dateValue FROM T_VL_ARTICLEINDD order by dateValue desc ").Limit(1).QueryValue()
拼接的sql语句limit参数错误,导致出错, limit参数为1,拼接参数为0xc000304578
[xorm] [info] 2022/06/01 20:00:23.472237 [SQL] select dateValue FROM T_VL_ARTICLEINDD order by dateValue desc LIMIT 0xc000304578 [] - 2.659ms
[] Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0xc000304578' at line 1

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