sqlite test (1.19 in ubuntu:latest) : table xxx has more than one primary key

[zhtiyissr]

GORM PR Link

#6627

Description

i want to make PR to add some config for migrator, it has only minimal code changes. But the checks failed, here is details: https://github.com/go-gorm/gorm/actions/runs/6448509357/job/17505845740?pr=6627

I don't think this is caused by me, because when I comment out my changes, the problem still occurs.
here is the other test details: https://github.com/go-gorm/gorm/actions/runs/6448558597/job/17505952191?pr=6627

who can fix it?

[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 ✨

[mykbas]

It seems that there is a problem with v1.5.4 of gorm.io/driver/sqlite.
I suppose after these changes go-gorm/sqlite@139bd30

Try gorm.io/driver/sqlite v1.5.3 or github.com/glebarez/sqlite - both worked well.

[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 ✨

[zhtiyissr]

@mykbas
the test file use gorm.io/driver/sqlite v1.5.3, the problem still occurs.

see https://github.com/go-gorm/gorm/blob/master/tests/go.mod line11

[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 ✨

[JacksonRGB]

same, v1.5.3 run ok

[zhtiyissr]

same, v1.5.3 run ok

@minchenzz look my PR file changed, i changed nothing, but test failed. hhhhh...

https://github.com/go-gorm/gorm/pull/6627/files

[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 ✨

[sluedecke]

Error disappears after downgrading to gorm.io/driver/sqlite v1.5.3.

go.mod now has:

	gorm.io/driver/sqlite v1.5.3
	gorm.io/gorm v1.25.4

[saltyfishyu]

测试在这个版本时未报错

gorm.io/driver/sqlite v1.5.4
gorm.io/gorm v1.25.3

当gorm.io/gorm v1.25.4 出现报错

[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 ✨

[jinzhu]

how about gorm v1.25.5?

[zhtiyissr]

how about gorm v1.25.5?

@jinzhu use gorm v1.25.5, mysql, mariadb, tidb all have other problems.

[zhtiyissr]

测试在这个版本时未报错

gorm.io/driver/sqlite v1.5.4
gorm.io/gorm v1.25.3

当gorm.io/gorm v1.25.4 出现报错

@saltyfishyu you are right, but when i use gorm v1.25.3, mysql, mariadb have other problems. sqllite is ok.

#6627

[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 ✨

[zhtiyissr]

The conclusion is when you only use sqlite , using gorm.io/driver/sqlite v1.5.3 or gorm.io/gorm v1.25.3 may solve the problem.

But I think there are unstable test cases in https://github.com/go-gorm/gorm/tree/master/tests. Because my PR changed nothing, but the test failed. Moreover, the test results are different at different times. Now I do not encounter the problem of sqlite test failure, but mysql, tidb, mariadb test failure.

Even if I use the same version number in the current master branch https://github.com/go-gorm/gorm/tree/master/tests/go.mod, the test still failed. I don’t know how other PRs are merged. Hope someone can fix these issues.