ciscozhou opened a new issue #2714:
URL: https://github.com/apache/incubator-inlong/issues/2714
### What happened
When I execute the `apache_inlong_manager.sql` file,
```
CREATE TABLE `stream_source2`
(
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`inlong_group_id` varchar(256) NOT NULL COMMENT 'Inlong group id',
`inlong_stream_id` varchar(256) NOT NULL COMMENT 'Inlong stream id',
`source_type` varchar(20) DEFAULT '0' COMMENT 'Source type,
including: FILE, DB, etc',
`agent_ip` varchar(40) DEFAULT NULL COMMENT 'Ip of the
agent running the task',
`uuid` varchar(30) DEFAULT NULL COMMENT 'Mac uuid of
the agent running the task',
`server_id` int(11) DEFAULT NULL COMMENT 'Id of the
source server',
`server_name` varchar(50) DEFAULT '' COMMENT 'Name of the
source server',
`cluster_id` int(11) DEFAULT NULL COMMENT 'Id of the
cluster that collected this source',
`cluster_name` varchar(50) DEFAULT '' COMMENT 'Name of the
cluster that collected this source',
`snapshot` text DEFAULT NULL COMMENT 'Snapshot of
this source task',
`report_time` timestamp DEFAULT NULL COMMENT 'Snapshot
time',
`ext_params` text DEFAULT NULL COMMENT 'Another
fields will saved as JSON string, such as filePath, dbName, tableName, etc',
`status` int(4) DEFAULT '0' COMMENT 'Data source
status',
`previous_status` int(4) DEFAULT '0' COMMENT 'Previous
status',
`is_deleted` int(11) DEFAULT '0' COMMENT 'Whether to
delete, 0: not deleted, > 0: deleted',
`creator` varchar(64) NOT NULL COMMENT 'Creator name',
`modifier` varchar(64) DEFAULT NULL COMMENT 'Modifier
name',
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT
'Create time',
`modify_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP COMMENT 'Modify time',
PRIMARY KEY (`id`)
);
```
there was some error:
```
Error Code: 1067. Invalid default value for 'report_time'
```
### What you expected to happen
It's should no error and the table create success.
### How to reproduce
Just re-execute the above SQL.
### Environment
_No response_
### InLong version
master
### InLong Component
InLong Manager
### Are you willing to submit PR?
- [X] Yes, I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of
Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
