mysql传limit句柄错误

[wtx-cynthia]

errmsg[Error 5007: prepare handle error] dnslookup[0] reuse[0] sql[/* {"log_id":"3230830605","xdb_comment":"1"} */ SELECT * FROM file_meta WHERE (isdelete=? AND server_filename=? AND user_id=?) LIMIT ?,?] sql_args[[0,"relay_expect",122050,0,100]]

[caibirdme]

1. Show me your code
2. your mysql version

[wtx-cynthia]

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的

[wtx-cynthia]

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

[wtx-cynthia]

辛苦有空帮忙看下

[wtx-cynthia]

还请有空看下我最新的回答，谢谢～

| | @.*** | | @.*** |

---- 回复的原邮件 ---- | 发件人 | @.> | | 日期 | 2022年11月25日 00:55 | | 收件人 | @.> | | 抄送至 | @.>@.> | | 主题 | Re: [didi/gendry] mysql传limit句柄错误 (Issue #134) |

Show me your code your mysql version

— Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: @.***>

[caibirdme]

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

[wtx-cynthia]

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

[wtx-cynthia]

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

[twz915]

现在这个也已经支持，可以使用 builder.Raw("unhex(e69da5e887aaefbc9a7669766f2058706c617936)")