Skip to content
Build_Unit_Test

Fix typos #143

Sign in to view logs

Fix typos

Fix typos #143

GitHub Actions / Unit Test Result failed Jun 18, 2024 in 0s

48039 tests run, 40 skipped, 13 failed.

Annotations

Check failure on line 181 in polardbx-common/src/test/java/com/alibaba/polardbx/common/charset/CharsetNameTest.java

See this annotation in the file changed.

@github-actions github-actions / Unit Test Result

CharsetNameTest.testDefaultCollationMySQL57 

java.lang.AssertionError
	at com.alibaba.polardbx.common.charset.CharsetNameTest.testDefaultCollationMySQL57(CharsetNameTest.java:181)
Raw output 
java.lang.AssertionError
	at com.alibaba.polardbx.common.charset.CharsetNameTest.testDefaultCollationMySQL57(CharsetNameTest.java:181)

Check failure on line 243 in polardbx-executor/src/test/java/com/alibaba/polardbx/executor/gms/ColumnarManagerTest.java

See this annotation in the file changed.

@github-actions github-actions / Unit Test Result

ColumnarManagerTest.testPurgeWithMultiVersionSchema 

expected:<ERR-CODE: [[TDDL]-12005][ERR_COLUMNAR...> but was:<ERR-CODE: [[PXC]-12005][ERR_COLUMNAR...>
Raw output 
org.junit.ComparisonFailure: expected:<ERR-CODE: [[TDDL]-12005][ERR_COLUMNAR...> but was:<ERR-CODE: [[PXC]-12005][ERR_COLUMNAR...>
	at com.alibaba.polardbx.executor.gms.ColumnarManagerTest.testPurgeWithMultiVersionSchema(ColumnarManagerTest.java:243)

Check failure on line 97 in polardbx-executor/src/test/java/com/alibaba/polardbx/executor/handler/LogicalShowCreateTablesForPartitionDatabaseHandlerTest.java

See this annotation in the file changed.

@github-actions github-actions / Unit Test Result

LogicalShowCreateTablesForPartitionDatabaseHandlerTest.showWithMySqlIndentTest 

ERR-CODE: [PXC-9001][ERR_GMS_GENERIC] acquire meta db error.
Raw output 
com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-9001][ERR_GMS_GENERIC] acquire meta db error. 
	at com.alibaba.polardbx.executor.handler.LogicalShowCreateTablesForPartitionDatabaseHandlerTest.showWithMySqlIndentTest(LogicalShowCreateTablesForPartitionDatabaseHandlerTest.java:97)

Check failure on line 101 in polardbx-executor/src/test/java/com/alibaba/polardbx/executor/handler/LogicalShowCreateTablesForShardingDatabaseHandlerTest.java

See this annotation in the file changed.

@github-actions github-actions / Unit Test Result

LogicalShowCreateTablesForShardingDatabaseHandlerTest.showWithMySqlIndentTest 

ERR-CODE: [PXC-9001][ERR_GMS_GENERIC] acquire meta db error.
Raw output 
com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-9001][ERR_GMS_GENERIC] acquire meta db error. 
	at com.alibaba.polardbx.executor.handler.LogicalShowCreateTablesForShardingDatabaseHandlerTest.showWithMySqlIndentTest(LogicalShowCreateTablesForShardingDatabaseHandlerTest.java:101)

Check failure on line 17 in polardbx-executor/src/test/java/com/alibaba/polardbx/executor/mpp/operator/AntiJoinRFTest.java

See this annotation in the file changed.

@github-actions github-actions / Unit Test Result

AntiJoinRFTest.testSql[AntiJoinRFTest.yml:0] 

Failed to create table
Raw output 
java.lang.RuntimeException: Failed to create table
	at com.alibaba.polardbx.executor.mpp.operator.AntiJoinRFTest.<init>(AntiJoinRFTest.java:17)
Caused by: com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-4601][ERR_EXECUTOR] Failed to create partition tables on db[optest] with mode='drds' 
	at com.alibaba.polardbx.executor.mpp.operator.AntiJoinRFTest.<init>(AntiJoinRFTest.java:17)

Check failure on line 14 in polardbx-executor/src/test/java/com/alibaba/polardbx/executor/mpp/operator/ParallelHashJoinFactoryTest.java

See this annotation in the file changed.

@github-actions github-actions / Unit Test Result

ParallelHashJoinFactoryTest.test[ParallelHashJoinFactoryTest.yml:0] 

Failed to create table
Raw output 
java.lang.RuntimeException: Failed to create table
	at com.alibaba.polardbx.executor.mpp.operator.ParallelHashJoinFactoryTest.<init>(ParallelHashJoinFactoryTest.java:14)
Caused by: com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-4601][ERR_EXECUTOR] Failed to create partition tables on db[optest] with mode='drds' 
	at com.alibaba.polardbx.executor.mpp.operator.ParallelHashJoinFactoryTest.<init>(ParallelHashJoinFactoryTest.java:14)

Check failure on line 14 in polardbx-executor/src/test/java/com/alibaba/polardbx/executor/mpp/operator/ParallelHashJoinFactoryTest.java

See this annotation in the file changed.

@github-actions github-actions / Unit Test Result

ParallelHashJoinFactoryTest.testSql[ParallelHashJoinFactoryTest.yml:0] 

Failed to create table
Raw output 
java.lang.RuntimeException: Failed to create table
	at com.alibaba.polardbx.executor.mpp.operator.ParallelHashJoinFactoryTest.<init>(ParallelHashJoinFactoryTest.java:14)
Caused by: com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-4601][ERR_EXECUTOR] Failed to create partition tables on db[optest] with mode='drds' 
	at com.alibaba.polardbx.executor.mpp.operator.ParallelHashJoinFactoryTest.<init>(ParallelHashJoinFactoryTest.java:14)

Check failure on line 21 in polardbx-executor/src/test/java/com/alibaba/polardbx/executor/mpp/operator/ReversedAntiJoinRFTest.java

See this annotation in the file changed.

@github-actions github-actions / Unit Test Result

ReversedAntiJoinRFTest.test[ReversedAntiJoinRFTest.yml:0] 

Failed to create table
Raw output 
java.lang.RuntimeException: Failed to create table
	at com.alibaba.polardbx.executor.mpp.operator.ReversedAntiJoinRFTest.<init>(ReversedAntiJoinRFTest.java:21)
Caused by: com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-4601][ERR_EXECUTOR] Failed to create partition tables on db[optest] with mode='drds' 
	at com.alibaba.polardbx.executor.mpp.operator.ReversedAntiJoinRFTest.<init>(ReversedAntiJoinRFTest.java:21)

Check failure on line 21 in polardbx-executor/src/test/java/com/alibaba/polardbx/executor/mpp/operator/ReversedAntiJoinRFTest.java

See this annotation in the file changed.

@github-actions github-actions / Unit Test Result

ReversedAntiJoinRFTest.testSql[ReversedAntiJoinRFTest.yml:0] 

Failed to create table
Raw output 
java.lang.RuntimeException: Failed to create table
	at com.alibaba.polardbx.executor.mpp.operator.ReversedAntiJoinRFTest.<init>(ReversedAntiJoinRFTest.java:21)
Caused by: com.alibaba.polardbx.common.exception.TddlRuntimeException: ERR-CODE: [PXC-4601][ERR_EXECUTOR] Failed to create partition tables on db[optest] with mode='drds' 
	at com.alibaba.polardbx.executor.mpp.operator.ReversedAntiJoinRFTest.<init>(ReversedAntiJoinRFTest.java:21)

Check failure on line 21 in polardbx-executor/src/test/java/com/alibaba/polardbx/executor/statistics/SkewColumnBuildTest.java

See this annotation in the file changed.

@github-actions github-actions / Unit Test Result

SkewColumnBuildTest.testSql[0] 

Failed to create table
Raw output 
java.lang.RuntimeException: Failed to create table
	at com.alibaba.polardbx.executor.statistics.SkewColumnBuildTest.<init>(SkewColumnBuildTest.java:21)
Caused by: java.lang.NullPointerException
	at com.alibaba.polardbx.executor.statistics.SkewColumnBuildTest.<init>(SkewColumnBuildTest.java:21)

Check failure on line 1 in polardbx-optimizer/src/test/java/com/alibaba/polardbx/planner/dml/SimpleDmlTest.java

See this annotation in the file changed.

@github-actions github-actions / Unit Test Result

SimpleDmlTest.testSql[SimpleDmlTest.insert.yml:14] 

targetSql = 
 insert into test_hash_tb(id, name,  name) values(1, 'a', 'a');

realPlanVal = 
err-code: [pxc-4501][err_optimizer] optimize error by column 'name' specified twice.
 targetPlanVal = 
err-code: [tddl-4501][err_optimizer] optimize error by column 'name' specified twice.
: arrays first differed at element [0]; expected:<...
plan:
err-code: [[tddl]-4501][err_optimizer...> but was:<...
plan:
err-code: [[pxc]-4501][err_optimizer...>
Raw output 
org.junit.internal.ArrayComparisonFailure: 
targetSql = 
 insert into test_hash_tb(id, name,  name) values(1, 'a', 'a');

realPlanVal = 
err-code: [pxc-4501][err_optimizer] optimize error by column 'name' specified twice.
 targetPlanVal = 
err-code: [tddl-4501][err_optimizer] optimize error by column 'name' specified twice.
: arrays first differed at element [0]; expected:<...
plan:
err-code: [[tddl]-4501][err_optimizer...> but was:<...
plan:
err-code: [[pxc]-4501][err_optimizer...>
Caused by: org.junit.ComparisonFailure: 
expected:<...
plan:
err-code: [[tddl]-4501][err_optimizer...> but was:<...
plan:
err-code: [[pxc]-4501][err_optimizer...>

Check failure on line 1 in polardbx-optimizer/src/test/java/com/alibaba/polardbx/planner/dml/SimpleDmlTest.java

See this annotation in the file changed.

@github-actions github-actions / Unit Test Result

SimpleDmlTest.testSql[SimpleDmlTest.insert.yml:15] 

targetSql = 
 insert into test_hash_tb(id, name,  name) values(1, 'a', 'a'), (2, 'b', 'b');

realPlanVal = 
err-code: [pxc-4501][err_optimizer] optimize error by column 'name' specified twice.
 targetPlanVal = 
err-code: [tddl-4501][err_optimizer] optimize error by column 'name' specified twice.
: arrays first differed at element [0]; expected:<...
plan:
err-code: [[tddl]-4501][err_optimizer...> but was:<...
plan:
err-code: [[pxc]-4501][err_optimizer...>
Raw output 
org.junit.internal.ArrayComparisonFailure: 
targetSql = 
 insert into test_hash_tb(id, name,  name) values(1, 'a', 'a'), (2, 'b', 'b');

realPlanVal = 
err-code: [pxc-4501][err_optimizer] optimize error by column 'name' specified twice.
 targetPlanVal = 
err-code: [tddl-4501][err_optimizer] optimize error by column 'name' specified twice.
: arrays first differed at element [0]; expected:<...
plan:
err-code: [[tddl]-4501][err_optimizer...> but was:<...
plan:
err-code: [[pxc]-4501][err_optimizer...>
Caused by: org.junit.ComparisonFailure: 
expected:<...
plan:
err-code: [[tddl]-4501][err_optimizer...> but was:<...
plan:
err-code: [[pxc]-4501][err_optimizer...>

Check failure on line 1 in polardbx-optimizer/src/test/java/com/alibaba/polardbx/planner/rewriter/ConstantFoldRuleTest.java

See this annotation in the file changed.

@github-actions github-actions / Unit Test Result

ConstantFoldRuleTest.testSql[ConstantFoldRuleTest.yml:7] 

targetSql = 
 select l_partkey, now(),sysdate(),curdate(),curtime(),utc_date(), utc_time(), utc_timestamp(),
date('2008-09-10 07:15:30.123456'),
time('2008-09-10 07:15:30.123456'),
year('2008-09-10 07:15:30.123456'),
quarter('2008-09-10 07:15:30.123456'),
month('2008-09-10 07:15:30.123456'),
week('2008-09-10 07:15:30.123456'),
day('2008-09-10 07:15:30.123456'),
hour('2008-09-10 07:15:30.123456'),
minute('2008-09-10 07:15:30.123456'),
second('2008-09-10 07:15:30.123456'),
microsecond('2008-09-10 07:15:30.123456'),
dayofweek('2008-09-10 07:15:30.123456'),
dayofyear('2008-09-10 07:15:30.123456'),
weekofyear('2008-09-10 07:15:30.123456'),
weekday('2008-09-10 07:15:30.123456'),
yearweek('2008-09-10 07:15:30.123456'),
dayname('2008-09-10 07:15:30.123456'),
monthname('2008-09-10 07:15:30.123456'),
last_day('2008-09-10 07:15:30.123456'),
date_add('2008-09-10 07:15:30.123456', interval 1 minute),
date_sub('2008-09-10 07:15:30.123456',interval '1 1:1:1' day_second),
timediff('2008-09-10 07:15:30.123456','2008-09-09 07:15:30.123456'),
datediff('2008-09-10 07:15:30.123456','2008-09-09 07:15:30.123456'),
to_days('2008-09-10 07:15:30.123456'),
from_days(733627),
1+2 +(CAST( -11 AS DECIMAL))
from lineitem;

realPlanVal = 
com.alibaba.polardbx.optimizer.core.datatype.intervaltype cannot be cast to java.lang.number
 targetPlanVal = 
project(l_partkey="l_partkey", now()="now()", sysdate()="sysdate()", curdate()="curdate()", curtime()="curtime()", utc_date()="utc_date()", utc_time()="utc_time()", utc_timestamp()="utc_timestamp()", date('2008-09-10 07:15:30.123456')="date('2008-09-10 07:15:30.123456')", time('2008-09-10 07:15:30.123456')="time('2008-09-10 07:15:30.123456')", year('2008-09-10 07:15:30.123456')="2008", quarter('2008-09-10 07:15:30.123456')="3", month('2008-09-10 07:15:30.123456')="9", week('2008-09-10 07:15:30.123456')="36", day('2008-09-10 07:15:30.123456')="10", hour('2008-09-10 07:15:30.123456')="7", minute('2008-09-10 07:15:30.123456')="15", second('2008-09-10 07:15:30.123456')="30", microsecond('2008-09-10 07:15:30.123456')="123456", dayofweek('2008-09-10 07:15:30.123456')="4", dayofyear('2008-09-10 07:15:30.123456')="254", weekofyear('2008-09-10 07:15:30.123456')="37", weekday('2008-09-10 07:15:30.123456')="2", yearweek('2008-09-10 07:15:30.123456')="200836", dayname('2008-09-10 07:15:30.123456')="dayname('2008-09-10 07:15:30.123456')", monthname('2008-09-10 07:15:30.123456')="monthname('2008-09-10 07:15:30.123456')", last_day('2008-09-10 07:15:30.123456')="last_day('2008-09-10 07:15:30.123456')", date_add('2008-09-10 07:15:30.123456', interval 1 minute)="date_add('2008-09-10 07:15:30.123456', interval_primary(1, minute))", date_sub('2008-09-10 07:15:30.123456', interval '1 1:1:1' day_second)="date_sub('2008-09-10 07:15:30.123456', interval_primary('1 1:1:1', day_second))", timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')", datediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="1", to_days('2008-09-10 07:15:30.123456')="733660", from_days(733627)="from_days(733627)", 1 + 2 + cast(-11 as decimal)="3 + cast(-11)")
  logicalview(tables="[0000-0003].lineitem_[00-15]", shardcount=16, sql="select `l_orderkey`, `l_partkey`, `l_suppkey`, `l_linenumber`, `l_quantity`, `l_extendedprice`, `l_discount`, `l_tax`, `l_returnflag`, `l_linestatus`, `l_shipdate`, `l_commitdate`, `l_receiptdate`, `l_shipinstruct`, `l_shipmode`, `l_comment` from `lineitem` as `lineitem`")
: arrays first differed at element [0]; expected:<... lineitem;

plan:
[project(l_partkey="l_partkey", now()="now()", sysdate()="sysdate()", curdate()="curdate()", curtime()="curtime()", utc_date()="utc_date()", utc_time()="utc_time()", utc_timestamp()="utc_timestamp()", date('2008-09-10 07:15:30.123456')="date('2008-09-10 07:15:30.123456')", time('2008-09-10 07:15:30.123456')="time('2008-09-10 07:15:30.123456')", year('2008-09-10 07:15:30.123456')="2008", quarter('2008-09-10 07:15:30.123456')="3", month('2008-09-10 07:15:30.123456')="9", week('2008-09-10 07:15:30.123456')="36", day('2008-09-10 07:15:30.123456')="10", hour('2008-09-10 07:15:30.123456')="7", minute('2008-09-10 07:15:30.123456')="15", second('2008-09-10 07:15:30.123456')="30", microsecond('2008-09-10 07:15:30.123456')="123456", dayofweek('2008-09-10 07:15:30.123456')="4", dayofyear('2008-09-10 07:15:30.123456')="254", weekofyear('2008-09-10 07:15:30.123456')="37", weekday('2008-09-10 07:15:30.123456')="2", yearweek('2008-09-10 07:15:30.123456')="200836", dayname('2008-09-10 07:15:30.123456')="dayname('2008-09-10 07:15:30.123456')", monthname('2008-09-10 07:15:30.123456')="monthname('2008-09-10 07:15:30.123456')", last_day('2008-09-10 07:15:30.123456')="last_day('2008-09-10 07:15:30.123456')", date_add('2008-09-10 07:15:30.123456', interval 1 minute)="date_add('2008-09-10 07:15:30.123456', interval_primary(1, minute))", date_sub('2008-09-10 07:15:30.123456', interval '1 1:1:1' day_second)="date_sub('2008-09-10 07:15:30.123456', interval_primary('1 1:1:1', day_second))", timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')", datediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="1", to_days('2008-09-10 07:15:30.123456')="733660", from_days(733627)="from_days(733627)", 1 + 2 + cast(-11 as decimal)="3 + cast(-11)")
  logicalview(tables="[0000-0003].lineitem_[00-15]", shardcount=16, sql="select `l_orderkey`, `l_partkey`, `l_suppkey`, `l_linenumber`, `l_quantity`, `l_extendedprice`, `l_discount`, `l_tax`, `l_returnflag`, `l_linestatus`, `l_shipdate`, `l_commitdate`, `l_receiptdate`, `l_shipinstruct`, `l_shipmode`, `l_comment` from `lineitem` as `lineitem`")]> but was:<... lineitem;

plan:
[com.alibaba.polardbx.optimizer.core.datatype.intervaltype cannot be cast to java.lang.number]>
Raw output 
org.junit.internal.ArrayComparisonFailure: 
targetSql = 
 select l_partkey, now(),sysdate(),curdate(),curtime(),utc_date(), utc_time(), utc_timestamp(),
date('2008-09-10 07:15:30.123456'),
time('2008-09-10 07:15:30.123456'),
year('2008-09-10 07:15:30.123456'),
quarter('2008-09-10 07:15:30.123456'),
month('2008-09-10 07:15:30.123456'),
week('2008-09-10 07:15:30.123456'),
day('2008-09-10 07:15:30.123456'),
hour('2008-09-10 07:15:30.123456'),
minute('2008-09-10 07:15:30.123456'),
second('2008-09-10 07:15:30.123456'),
microsecond('2008-09-10 07:15:30.123456'),
dayofweek('2008-09-10 07:15:30.123456'),
dayofyear('2008-09-10 07:15:30.123456'),
weekofyear('2008-09-10 07:15:30.123456'),
weekday('2008-09-10 07:15:30.123456'),
yearweek('2008-09-10 07:15:30.123456'),
dayname('2008-09-10 07:15:30.123456'),
monthname('2008-09-10 07:15:30.123456'),
last_day('2008-09-10 07:15:30.123456'),
date_add('2008-09-10 07:15:30.123456', interval 1 minute),
date_sub('2008-09-10 07:15:30.123456',interval '1 1:1:1' day_second),
timediff('2008-09-10 07:15:30.123456','2008-09-09 07:15:30.123456'),
datediff('2008-09-10 07:15:30.123456','2008-09-09 07:15:30.123456'),
to_days('2008-09-10 07:15:30.123456'),
from_days(733627),
1+2 +(CAST( -11 AS DECIMAL))
from lineitem;

realPlanVal = 
com.alibaba.polardbx.optimizer.core.datatype.intervaltype cannot be cast to java.lang.number
 targetPlanVal = 
project(l_partkey="l_partkey", now()="now()", sysdate()="sysdate()", curdate()="curdate()", curtime()="curtime()", utc_date()="utc_date()", utc_time()="utc_time()", utc_timestamp()="utc_timestamp()", date('2008-09-10 07:15:30.123456')="date('2008-09-10 07:15:30.123456')", time('2008-09-10 07:15:30.123456')="time('2008-09-10 07:15:30.123456')", year('2008-09-10 07:15:30.123456')="2008", quarter('2008-09-10 07:15:30.123456')="3", month('2008-09-10 07:15:30.123456')="9", week('2008-09-10 07:15:30.123456')="36", day('2008-09-10 07:15:30.123456')="10", hour('2008-09-10 07:15:30.123456')="7", minute('2008-09-10 07:15:30.123456')="15", second('2008-09-10 07:15:30.123456')="30", microsecond('2008-09-10 07:15:30.123456')="123456", dayofweek('2008-09-10 07:15:30.123456')="4", dayofyear('2008-09-10 07:15:30.123456')="254", weekofyear('2008-09-10 07:15:30.123456')="37", weekday('2008-09-10 07:15:30.123456')="2", yearweek('2008-09-10 07:15:30.123456')="200836", dayname('2008-09-10 07:15:30.123456')="dayname('2008-09-10 07:15:30.123456')", monthname('2008-09-10 07:15:30.123456')="monthname('2008-09-10 07:15:30.123456')", last_day('2008-09-10 07:15:30.123456')="last_day('2008-09-10 07:15:30.123456')", date_add('2008-09-10 07:15:30.123456', interval 1 minute)="date_add('2008-09-10 07:15:30.123456', interval_primary(1, minute))", date_sub('2008-09-10 07:15:30.123456', interval '1 1:1:1' day_second)="date_sub('2008-09-10 07:15:30.123456', interval_primary('1 1:1:1', day_second))", timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')", datediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="1", to_days('2008-09-10 07:15:30.123456')="733660", from_days(733627)="from_days(733627)", 1 + 2 + cast(-11 as decimal)="3 + cast(-11)")
  logicalview(tables="[0000-0003].lineitem_[00-15]", shardcount=16, sql="select `l_orderkey`, `l_partkey`, `l_suppkey`, `l_linenumber`, `l_quantity`, `l_extendedprice`, `l_discount`, `l_tax`, `l_returnflag`, `l_linestatus`, `l_shipdate`, `l_commitdate`, `l_receiptdate`, `l_shipinstruct`, `l_shipmode`, `l_comment` from `lineitem` as `lineitem`")
: arrays first differed at element [0]; expected:<... lineitem;

plan:
[project(l_partkey="l_partkey", now()="now()", sysdate()="sysdate()", curdate()="curdate()", curtime()="curtime()", utc_date()="utc_date()", utc_time()="utc_time()", utc_timestamp()="utc_timestamp()", date('2008-09-10 07:15:30.123456')="date('2008-09-10 07:15:30.123456')", time('2008-09-10 07:15:30.123456')="time('2008-09-10 07:15:30.123456')", year('2008-09-10 07:15:30.123456')="2008", quarter('2008-09-10 07:15:30.123456')="3", month('2008-09-10 07:15:30.123456')="9", week('2008-09-10 07:15:30.123456')="36", day('2008-09-10 07:15:30.123456')="10", hour('2008-09-10 07:15:30.123456')="7", minute('2008-09-10 07:15:30.123456')="15", second('2008-09-10 07:15:30.123456')="30", microsecond('2008-09-10 07:15:30.123456')="123456", dayofweek('2008-09-10 07:15:30.123456')="4", dayofyear('2008-09-10 07:15:30.123456')="254", weekofyear('2008-09-10 07:15:30.123456')="37", weekday('2008-09-10 07:15:30.123456')="2", yearweek('2008-09-10 07:15:30.123456')="200836", dayname('2008-09-10 07:15:30.123456')="dayname('2008-09-10 07:15:30.123456')", monthname('2008-09-10 07:15:30.123456')="monthname('2008-09-10 07:15:30.123456')", last_day('2008-09-10 07:15:30.123456')="last_day('2008-09-10 07:15:30.123456')", date_add('2008-09-10 07:15:30.123456', interval 1 minute)="date_add('2008-09-10 07:15:30.123456', interval_primary(1, minute))", date_sub('2008-09-10 07:15:30.123456', interval '1 1:1:1' day_second)="date_sub('2008-09-10 07:15:30.123456', interval_primary('1 1:1:1', day_second))", timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')", datediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="1", to_days('2008-09-10 07:15:30.123456')="733660", from_days(733627)="from_days(733627)", 1 + 2 + cast(-11 as decimal)="3 + cast(-11)")
  logicalview(tables="[0000-0003].lineitem_[00-15]", shardcount=16, sql="select `l_orderkey`, `l_partkey`, `l_suppkey`, `l_linenumber`, `l_quantity`, `l_extendedprice`, `l_discount`, `l_tax`, `l_returnflag`, `l_linestatus`, `l_shipdate`, `l_commitdate`, `l_receiptdate`, `l_shipinstruct`, `l_shipmode`, `l_comment` from `lineitem` as `lineitem`")]> but was:<... lineitem;

plan:
[com.alibaba.polardbx.optimizer.core.datatype.intervaltype cannot be cast to java.lang.number]>
Caused by: org.junit.ComparisonFailure: 
expected:<... lineitem;

plan:
[project(l_partkey="l_partkey", now()="now()", sysdate()="sysdate()", curdate()="curdate()", curtime()="curtime()", utc_date()="utc_date()", utc_time()="utc_time()", utc_timestamp()="utc_timestamp()", date('2008-09-10 07:15:30.123456')="date('2008-09-10 07:15:30.123456')", time('2008-09-10 07:15:30.123456')="time('2008-09-10 07:15:30.123456')", year('2008-09-10 07:15:30.123456')="2008", quarter('2008-09-10 07:15:30.123456')="3", month('2008-09-10 07:15:30.123456')="9", week('2008-09-10 07:15:30.123456')="36", day('2008-09-10 07:15:30.123456')="10", hour('2008-09-10 07:15:30.123456')="7", minute('2008-09-10 07:15:30.123456')="15", second('2008-09-10 07:15:30.123456')="30", microsecond('2008-09-10 07:15:30.123456')="123456", dayofweek('2008-09-10 07:15:30.123456')="4", dayofyear('2008-09-10 07:15:30.123456')="254", weekofyear('2008-09-10 07:15:30.123456')="37", weekday('2008-09-10 07:15:30.123456')="2", yearweek('2008-09-10 07:15:30.123456')="200836", dayname('2008-09-10 07:15:30.123456')="dayname('2008-09-10 07:15:30.123456')", monthname('2008-09-10 07:15:30.123456')="monthname('2008-09-10 07:15:30.123456')", last_day('2008-09-10 07:15:30.123456')="last_day('2008-09-10 07:15:30.123456')", date_add('2008-09-10 07:15:30.123456', interval 1 minute)="date_add('2008-09-10 07:15:30.123456', interval_primary(1, minute))", date_sub('2008-09-10 07:15:30.123456', interval '1 1:1:1' day_second)="date_sub('2008-09-10 07:15:30.123456', interval_primary('1 1:1:1', day_second))", timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="timediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')", datediff('2008-09-10 07:15:30.123456', '2008-09-09 07:15:30.123456')="1", to_days('2008-09-10 07:15:30.123456')="733660", from_days(733627)="from_days(733627)", 1 + 2 + cast(-11 as decimal)="3 + cast(-11)")
  logicalview(tables="[0000-0003].lineitem_[00-15]", shardcount=16, sql="select `l_orderkey`, `l_partkey`, `l_suppkey`, `l_linenumber`, `l_quantity`, `l_extendedprice`, `l_discount`, `l_tax`, `l_returnflag`, `l_linestatus`, `l_shipdate`, `l_commitdate`, `l_receiptdate`, `l_shipinstruct`, `l_shipmode`, `l_comment` from `lineitem` as `lineitem`")]> but was:<... lineitem;

plan:
[com.alibaba.polardbx.optimizer.core.datatype.intervaltype cannot be cast to java.lang.number]>
View more details on GitHub Actions