mysql传limit句柄错误 about gendry HOT 9 OPEN

1. Show me your code
2. your mysql version

from gendry.

where := map[string]interface{}{
"user_id": User_id,
"server_filename": Server_Filename,
"isdelete": 0,
}
where["_limit"] = []uint{3}
// where["_orderby"] = "fs_id desc"
fields := []string{"*"}
err := dao.BaseSelectConvert(ctx, where, fields, &tabRes)
_orderby是可用的，_limit传入后就会报错。mysql是5.6的

from gendry.

mysql版本
| innodb_version | 5.6.23 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.6.23-baidu-trunk-2.2.4.3-log |
| version_comment | Source distribution |
| version_compile_machine | x86_64 |
| version_compile_os | Linux

from gendry.

辛苦有空帮忙看下

from gendry.

from gendry.

这样直接看不出问题，你可以开启mysql driver的interpolateParams试试看，打印下最后的结果

from gendry.

还得辛苦帮忙看下 sql中unhex该怎么传

from gendry.

SELECT * FROM file_meta WHERE (isdelete=? AND server_filename=? AND user_id=?)] sql_args[[0,"unhex(e69da5e887aaefbc9a7669766f2058706c617936)",3941040758 这样报错

from gendry.