unsigned int column has incorrect type and tag #29

New Issue

weakptr · 2021-06-15T02:31:12Z

weakptr commented

2021-06-15 02:31:12 +00:00

what I expected:

	ID          uint32 `xorm:"'id' not null pk autoincr INT(10)"`

what I got:

	ID          string `xorm:"'id' not null pk autoincr UNSIGNED INT(10)"`

xorm 不支持 unsigned int 姑且不提，reverse 逆向出来的结果避开 unsigned 的tag，给正确的 uint 类型应该是可以的。

比较担心的是数据库实际类型是 unsigned int，但 xorm tag 只写了 INT ，Go 类型又是 uint32 会不会导致反序列化结果出问题。

what I expected: ```golang ID uint32 `xorm:"'id' not null pk autoincr INT(10)"` ``` what I got: ```golang ID string `xorm:"'id' not null pk autoincr UNSIGNED INT(10)"` ``` xorm 不支持 unsigned int 姑且不提，reverse 逆向出来的结果避开 unsigned 的tag，给正确的 uint 类型应该是可以的。比较担心的是数据库实际类型是 unsigned int，但 xorm tag 只写了 INT ，Go 类型又是 uint32 会不会导致反序列化结果出问题。

lunny commented

2021-06-15 10:02:08 +00:00

convert unsigned int to string is safe. But we actually should use uint32.

convert `unsigned int` to `string` is safe. But we actually should use `uint32`.

lunny added the

bug

label 2021-06-15 10:02:12 +00:00

zhenxxin commented

2021-08-30 09:45:24 +00:00

同样问题 +1