Column definition does not support 'DEFAULT NOW()' to set the defaul value?
describe:
my DDL sql:
```create table if not exists testdb.detail(
`created_time`DATETIME NOT NULL DEFAULT NOW()
,`name` VARCHAR(30) NOT NULL
.....
```
I get this Exception:
Error Failed to execute sql: org.apache.doris.common.AnalysisException: errCode 
= 2, detailMessage = Syntax error in line 2: `created` DATETIME NOT NULL 
DEFAULT NOW() ^ Encountered: IDENTIFIER Expected

Reply via email to