This is an automated email from the ASF dual-hosted git repository.
klesh pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/incubator-devlake.git
The following commit(s) were added to refs/heads/main by this push:
new bfebec36d fix(asana): use float8 instead of double for PostgreSQL
compatibility (#8837)
bfebec36d is described below
commit bfebec36d11dd07242a3d0aa61eaae202d02e024
Author: TT <[email protected]>
AuthorDate: Sat Apr 18 03:59:04 2026 +0200
fix(asana): use float8 instead of double for PostgreSQL compatibility
(#8837)
The migration used gorm:"type:double" which is MySQL-specific.
PostgreSQL does not have a "double" type and fails with:
ERROR: type "double" does not exist (SQLSTATE 42704)
Changed to float8 which works on both MySQL (alias for double) and
PostgreSQL (alias for double precision).
Closes #8835
Co-authored-by: tengtian <tengtianmoemoe@gamil,com>
---
.../models/migrationscripts/20250212_add_task_transformation_fields.go | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git
a/backend/plugins/asana/models/migrationscripts/20250212_add_task_transformation_fields.go
b/backend/plugins/asana/models/migrationscripts/20250212_add_task_transformation_fields.go
index 7af140448..690a04923 100644
---
a/backend/plugins/asana/models/migrationscripts/20250212_add_task_transformation_fields.go
+++
b/backend/plugins/asana/models/migrationscripts/20250212_add_task_transformation_fields.go
@@ -32,7 +32,7 @@ type asanaTask20250212 struct {
StdType string `gorm:"type:varchar(255)"`
StdStatus string `gorm:"type:varchar(255)"`
Priority string `gorm:"type:varchar(255)"`
- StoryPoint *float64 `gorm:"type:double"`
+ StoryPoint *float64 `gorm:"type:float8"`
Severity string `gorm:"type:varchar(255)"`
LeadTimeMinutes *uint `gorm:"type:int unsigned"`
}