tomsun28 commented on PR #1801: URL: https://github.com/apache/hertzbeat/pull/1801#issuecomment-2068957669
[EL Finest]: ddl: 2024-04-22 17:40:41.325--Thread(Thread[main,5,main])--The table (hzb_notice_template) could not be created due to exception: Internal Exception: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE hzb_notice_template (ID BIGINT [*]IDENTITY NOT NULL, CONTENT LONGVARCHAR, CREATOR VARCHAR, GMTCREATE TIMESTAMP, GMTUPDATE TIMESTAMP, MODIFIER VARCHAR, NAME VARCHAR, PRESET boolean default false, TYPE SMALLINT, PRIMARY KEY (ID))"; expected "UNSIGNED, ARRAY, INVISIBLE, VISIBLE, NOT NULL, DEFAULT, GENERATED, ON UPDATE, NOT NULL, DEFAULT ON NULL, SEQUENCE, SELECTIVITY, COMMENT, CONSTRAINT, COMMENT, PRIMARY KEY, UNIQUE, NOT NULL, CHECK, REFERENCES, ,, )"; SQL statement: CREATE TABLE hzb_notice_template (ID BIGINT IDENTITY NOT NULL, CONTENT LONGVARCHAR, CREATOR VARCHAR, GMTCREATE TIMESTAMP, GMTUPDATE TIMESTAMP, MODIFIER VARCHAR, NAME VARCHAR, PRESET boolean default false, TYPE SMALLINT, PRIMARY KEY (ID)) [42001-224] Error Code: 42001 Call: CREATE TABLE hzb_notice_template (ID BIGINT IDENTITY NOT NULL, CONTENT LONGVARCHAR, CREATOR VARCHAR, GMTCREATE TIMESTAMP, GMTUPDATE TIMESTAMP, MODIFIER VARCHAR, NAME VARCHAR, PRESET boolean default false, TYPE SMALLINT, PRIMARY KEY (ID)) Query: DataModifyQuery(sql="CREATE TABLE hzb_notice_template (ID BIGINT IDENTITY NOT NULL, CONTENT LONGVARCHAR, CREATOR VARCHAR, GMTCREATE TIMESTAMP, GMTUPDATE TIMESTAMP, MODIFIER VARCHAR, NAME VARCHAR, PRESET boolean default false, TYPE SMALLINT, PRIMARY KEY (ID))") -- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
