Engine.Exec()不支持传入Conversion对象？ #1803

New Issue

jacexh · 2020-09-27T06:36:24Z

jacexh commented

2020-09-27 06:36:24 +00:00

我执行以下SQL语句会报错：

db.Exec(
	"INSERT INTO snippet (id, name, description, type, details) VALUES(?, ?, ?, ?, ?) ON DUPLICATE KEY ...",
    do.ID, do.Name, do.Description, do.Type, do.Details,
    )

do.Details是一个结构体，并且实现了Conversion接口，但是执行时会报错：

sql: converting argument $5 type: unsupported type do.SpecificationDetail, a struct

我执行以下SQL语句会报错： ``` db.Exec( "INSERT INTO snippet (id, name, description, type, details) VALUES(?, ?, ?, ?, ?) ON DUPLICATE KEY ...", do.ID, do.Name, do.Description, do.Type, do.Details, ) ``` `do.Details`是一个结构体，并且实现了Conversion接口，但是执行时会报错： ``` sql: converting argument $5 type: unsupported type do.SpecificationDetail, a struct ```

lunny added the

kind

feature

label 2020-10-17 14:04:58 +00:00

lunny added this to the 1.2.0 milestone 2021-06-12 08:07:33 +00:00

lunny referenced a pull request that will close this issue

2021-07-06 15:18:58 +00:00

Exec support conversion data #1970

lunny removed this from the 1.2.0 milestone 2021-07-28 14:20:25 +00:00

lunny commented

2021-07-28 14:21:19 +00:00

It's better to implement driver.Valuer but not conversion. For mssql, something will always wrong.