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"`
 }

Reply via email to