用tag指定数据库字段为int类型的字段默认值时，create函数生成的sql语句多了一列

[DearZL]

GORM Playground Link

go-gorm/playground#1

Description

[github-actions]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨

[labulakalia]

show your case!!!

[github-actions]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨

[DearZL]

实在很抱歉，我不知道如何正规的提交bug，简而言之，如果我将实体类中的id字段设为了int类型并用tag指明了默认值，那么gorm最后自动生成的sql语句会多出一个id字段，我将我的代码和数据库都在附件中提交给了您，劳烦您看一下，我用的依赖版本为 gorm.io/driver/mysql v1.5.0 gorm.io/gorm v1.25.0 我知道将id设为有默认值不合理，但是我想知道为什么会出现这种情况。谢谢您。 罗红霉素. ***@***.***  

…

------------------ 原始邮件 ------------------ 发件人: "go-gorm/gorm" ***@***.***>; 发送时间: 2023年4月23日(星期天) 下午4:18 ***@***.***>; ***@***.******@***.***>; 主题: Re: [go-gorm/gorm] 用tag指定数据库字段为int类型的字段默认值时，create函数生成的sql语句多了一列 (Issue #6247) show your case!!! — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>

[github-actions]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨

[DearZL]

ErrorPicture+Code.zip

[github-actions]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨

[philhuan]

你的结构体

type File struct {
Id int json:"id" gorm:"default:2"
Filename string json:"filename"
Location string json:"location"
}

[philhuan]

你试试加上 primarykey, 不加这个 gorm 不能识别这是一个主键

func TestDefault(t *testing.T) {
	type User struct {
		ID   uint `gorm:"primarykey,default:100"`
		Name string
		Age  uint
	}

	user := User{Name: "philhuan"}

	err := DB.Create(&user).Error
	assert.NoError(t, err)
	t.Log(user)
}

=== RUN   TestDefault

2023/05/15 23:46:40 /Users/philhuan/code/go/playground/main_test.go:109
[8.878ms] [rows:1] INSERT INTO `users` (`name`,`age`) VALUES ('philhuan',0)
    main_test.go:111: {6 philhuan 0}
--- PASS: TestDefault (0.01s)
PASS

[DearZL]

type User struct {
ID uint gorm:"primarykey,default:100"
Name string
Age uint
}
为什么primarykey和default:100要用，隔开，不是分号吗

[github-actions]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨