执行make test失败

[dabao1990]

安装
1、spack install --overwrite --keep-stage --no-checksum -y [email protected] [email protected]
2、cd [email protected]

系统
[root@localhost parse]#cat /etc/os-release
NAME="CentOS Linux"
VERSION="8 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="8"
PLATFORM_ID="platform:el8"
PRETTY_NAME="CentOS Linux 8 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:8"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

执行mvn test有以下报错

[INFO] Running com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest
CREATE TABLE parent (
id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
created_at timestamp NULL DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 BLOCK_FORMAT = ENCRYPTED
CREATE TABLE test1 (
id int(11) NOT NULL AUTO_INCREMENT,
cluster_id int(11) NOT NULL COMMENT '??id',
component_id int(11) NOT NULL COMMENT '??id',
component_type_code tinyint(1) NOT NULL COMMENT '????',
type varchar(128) COLLATE utf8_bin NOT NULL COMMENT '????',
required tinyint(1) NOT NULL COMMENT 'true/false',
key varchar(256) COLLATE utf8_bin NOT NULL COMMENT '???',
value text COLLATE utf8_bin COMMENT '?????',
values varchar(512) COLLATE utf8_bin DEFAULT NULL COMMENT '????',
dependencyKey varchar(256) COLLATE utf8_bin DEFAULT NULL COMMENT '???',
dependencyValue varchar(256) COLLATE utf8_bin DEFAULT NULL COMMENT '???',
desc varchar(512) COLLATE utf8_bin DEFAULT NULL COMMENT '??',
gmt_create datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '????',
gmt_modified datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '????',
is_deleted tinyint(1) NOT NULL DEFAULT '0' COMMENT '0?? 1????',
PRIMARY KEY (id),
KEY index_cluster_id (cluster_id),
KEY index_componentId (component_id)
) ENGINE = InnoDB AUTO_INCREMENT = 1140 DEFAULT CHARSET = utf8 DEFAULT COLLATE = utf8_bin;

CREATE TABLE test1 (
id int(11) NOT NULL AUTO_INCREMENT,
uid int(11) NOT NULL DEFAULT '0' COMMENT '??ID',
from tinyint(3) NOT NULL DEFAULT '0' COMMENT '?? 1QQ 2?? 3??',
access_code varchar(20) NOT NULL DEFAULT '' COMMENT '??code',
access_token varchar(200) NOT NULL DEFAULT '' COMMENT '??token',
expires_in int(11) NOT NULL DEFAULT '0' COMMENT '????',
refresh_token varchar(200) NOT NULL DEFAULT '' COMMENT '??token',
openid varchar(255) NOT NULL DEFAULT '' COMMENT '????????',
scope varchar(60) NOT NULL COMMENT '????',
status tinyint(3) NOT NULL DEFAULT '1' COMMENT '1 ',
json_info text NOT NULL COMMENT '????',
create_time timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '????',
unionid varchar(128) NOT NULL DEFAULT '' COMMENT 'UnionID',
session_key varchar(128) NOT NULL DEFAULT '' COMMENT '???session_key',
PRIMARY KEY (id),
KEY uid (uid),
KEY idx_openid_from_status (openid, from, status),
KEY idx_access_token (access_token),
KEY idx_uid_from_status (uid, from, status),
KEY idx_unionid_from_status (unionid, from, status)
) ENGINE = InnoDB AUTO_INCREMENT = 7831300 DEFAULT CHARSET = utf8 COMMENT '????????';

16:17:02.174 [pool-1-thread-6] DEBUG com.alibaba.polardbx.druid.sql.repository.SchemaRepository - replaced table 'table_x1'
CREATE TABLE IF NOT EXISTS table_x1 (
id bigint(20) NOT NULL AUTO_INCREMENT,
key1 longtext NOT NULL COMMENT 'key1',
PRIMARY KEY (id)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4

16:17:02.188 [pool-1-thread-6] DEBUG com.alibaba.polardbx.druid.sql.repository.SchemaRepository - replaced table 'test'
[ERROR] Tests run: 12, Failures: 1, Errors: 5, Skipped: 0, Time elapsed: 0.529 s <<< FAILURE! - in com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest
[ERROR] test_invisible(com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest) Time elapsed: 0.004 s <<< ERROR!
com.alibaba.polardbx.druid.sql.parser.ParserException: syntax error, error in :'at`) /*!80000 INVISIBLE */) ENGINE=', expect ), actual null, pos 207, line 1, column 187, token HINT
at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest.test_invisible(FastsqlSchemaTest.java:67)

[ERROR] test_mariadb_aria(com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest) Time elapsed: 0.005 s <<< ERROR!
com.alibaba.polardbx.druid.sql.parser.ParserException: syntax error, error in :'_bin PAGE_CHECKSUM=1 TRANSACTIONAL=, pos 641, line 14, column 54, token IDENTIFIER PAGE_CHECKSUM
at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest.test_mariadb_aria(FastsqlSchemaTest.java:140)

[ERROR] test_persistent(com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest) Time elapsed: 0.002 s <<< ERROR!
com.alibaba.polardbx.druid.sql.parser.ParserException: syntax error, error in :')))) PERSISTENT)', expect ), actual null, pos 184, line 1, column 175, token IDENTIFIER PERSISTENT
at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest.test_persistent(FastsqlSchemaTest.java:80)

[ERROR] test_json_index(com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest) Time elapsed: 0.003 s <<< ERROR!
com.alibaba.polardbx.druid.sql.parser.ParserException: syntax error, expect ), actual IDENTIFIER pos 206, line 1, column 202, token IDENTIFIER array
at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest.test_json_index(FastsqlSchemaTest.java:53)

[ERROR] test_partition_table(com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest) Time elapsed: 0.001 s <<< ERROR!
com.alibaba.polardbx.druid.sql.parser.ParserException: illegal name, pos 44, line 1, column 44, token LITERAL_INT
at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest.test_partition_table(FastsqlSchemaTest.java:122)

[ERROR] testSimple(com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest) Time elapsed: 0.001 s <<< FAILURE!
java.lang.AssertionError
at com.alibaba.otter.canal.parse.inbound.mysql.tsdb.FastsqlSchemaTest.testSimple(FastsqlSchemaTest.java:30)
........

[INFO]
[INFO] Results:
[INFO]
[ERROR] Failures:
[ERROR] FastsqlSchemaTest.testSimple:30
[ERROR] Errors:
[ERROR] FastsqlSchemaTest.test_invisible:67 ? Parser syntax error, error in :'at`) /*!...
[ERROR] FastsqlSchemaTest.test_json_index:53 ? Parser syntax error, expect ), actual I...
[ERROR] FastsqlSchemaTest.test_mariadb_aria:140 ? Parser syntax error, error in :'_bin...
[ERROR] FastsqlSchemaTest.test_partition_table:122 ? Parser illegal name, pos 44, line...
[ERROR] FastsqlSchemaTest.test_persistent:80 ? Parser syntax error, error in :')))) PE...
[INFO]
[ERROR] Tests run: 67, Failures: 1, Errors: 5, Skipped: 22
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 7.317 s
[INFO] Finished at: 2025-02-18T16:17:04+08:00
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.22.1:test (default-test) on project canal.parse: There are test failures.
[ERROR]
[ERROR] Please refer to /home/stage/root/spack-stage-canal-1.1.8-s4ia4pbq4vozcpt6csisqx5vgyfa2doy/spack-src/parse/target/surefire-reports for the individual test results.
[ERROR] Please refer to dump files (if any exist) [date].dump, [date]-jvmRun[N].dump and [date].dumpstream.
[ERROR] -> [Help 1]

[nakeiven]

文件乱码，先把文件编码改为uft-8 ，再执行mvn test试试