Skip to content

database when add time column,internal error #2502

@tangxqa

Description

@tangxqa
Image

Add a new column in database type time, error occurs.

error log:

2025/11/21 15:17:37.188543 mysql.go:217: [Info] [log-id: fea2598e-3d9d-4a9f-adef-20e856be7121] [AlterTable] execute sql is ALTER TABLE `table_7575069489549541376` ADD COLUMN `f_3` TIMESTAMP, MODIFY COLUMN `f_1` BOOLEAN, MODIFY COLUMN `f_2` TEXT, req is &{table_7575069489549541376 [0xc00312b840 0xc00312b880 0xc00312b8c0]}
2025/11/21 15:17:37.189194 error_resp.go:48: [Error] [log-id: fea2598e-3d9d-4a9f-adef-20e856be7121] [InternalError] error: update draft physical table failed: failed to alter table: Error 1067 (42000): Invalid default value for 'f_3'
2025/11/21 15:17:37 /app/infra/impl/rdb/mysql.go:219 Error 1067 (42000): **Invalid default value for 'f_3'**

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions