search

go-gorm / gorm

The fantastic ORM library for Golang, aims to be developer friendly
https://gorm.io
MIT License
36.67k stars 3.92k forks source link

MariaDB database batch insert incompatibility issue #7203

Open Heir-o opened 1 week ago

Heir-o commented 1 week ago

MariaDB database is fully compatible with MySQL sql, but there will be problems when doing batch insert Create. It seems that sql will splice RETURNING primary key after sql. It will not appear in MySQL database, but will report an error in MariaDB database. By default, there is RETURNING primary key

Heir-o commented 1 week ago

PixPin_2024-09-23_20-23-13 PixPin_2024-09-23_20-24-07

github-actions[bot] commented 1 week ago

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 ✨

ivila commented 1 week ago

@Heir-o Try updating the version of your mariadb server, the returning phase was added in MariaDB 10.5.0

github-actions[bot] commented 1 week ago

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 ✨