xorm icon indicating copy to clipboard operation
xorm copied to clipboard

Published 20 hours ago • verified publisher icon go-xorm

MariaDB数据表字段默认值有问题

Open richardchey opened this issue 5 years ago • 3 comments

MySQL： default

MariaDB： default

导致使用MariaDB时，DBMetas的返回结果，列的默认值(Column.Default)多了一层单引号。另外在调用Sync时会产生不符实际的告警信息。

richardchey avatar Jan 23 '19 06:01 richardchey

也不是所有的MariaDB都会这样，我试了下，10.1.37没有问题，但是10.3.12会出问题。

richardchey avatar Jan 24 '19 02:01 richardchey

同样发现这个问题 默认值不对应

zxysilent avatar May 12 '19 05:05 zxysilent

[xorm] [warn] 2019/06/06 15:54:03.911124 Table article Column addr db default is '''', struct default is '' [xorm] [warn] 2019/06/06 15:54:03.912121 Table article Column area db default is '''', struct default is '' [xorm] [warn] 2019/06/06 15:54:03.913118 Table article Column utime db default is 'NULL', struct default is NULL [xorm] [warn] 2019/06/06 15:54:03.914116 Table article Column ctime db default is 'NULL', struct default is NULL

image

zxysilent avatar Jun 06 '19 07:06 zxysilent