5.4.19-20240428_17142882 release #209
pzxpolarAnnotations
13 errors and 2 warnings
|
CharsetNameTest.testDefaultCollationMySQL57:
polardbx-common/src/test/java/com/alibaba/polardbx/common/charset/CharsetNameTest.java#L181
java.lang.AssertionError
at com.alibaba.polardbx.common.charset.CharsetNameTest.testDefaultCollationMySQL57(CharsetNameTest.java:181)
|
|
ColumnarManagerTest.testPurgeWithMultiVersionSchema:
polardbx-executor/src/test/java/com/alibaba/polardbx/executor/gms/ColumnarManagerTest.java#L243
expected:<ERR-CODE: [[TDDL]-12005][ERR_COLUMNAR...> but was:<ERR-CODE: [[PXC]-12005][ERR_COLUMNAR...>
|
|
LogicalShowCreateTablesForPartitionDatabaseHandlerTest.showWithMySqlIndentTest:
polardbx-executor/src/test/java/com/alibaba/polardbx/executor/handler/LogicalShowCreateTablesForPartitionDatabaseHandlerTest.java#L97
ERR-CODE: [PXC-9001][ERR_GMS_GENERIC] acquire meta db error.
|
|
LogicalShowCreateTablesForShardingDatabaseHandlerTest.showWithMySqlIndentTest:
polardbx-executor/src/test/java/com/alibaba/polardbx/executor/handler/LogicalShowCreateTablesForShardingDatabaseHandlerTest.java#L101
ERR-CODE: [PXC-9001][ERR_GMS_GENERIC] acquire meta db error.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
SimpleDmlTest.testSql[SimpleDmlTest.insert.yml:14]:
polardbx-optimizer/src/test/java/com/alibaba/polardbx/planner/dml/SimpleDmlTest.java#L1
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...>
|
|
SimpleDmlTest.testSql[SimpleDmlTest.insert.yml:15]:
polardbx-optimizer/src/test/java/com/alibaba/polardbx/planner/dml/SimpleDmlTest.java#L1
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...>
|
|
ConstantFoldRuleTest.testSql[ConstantFoldRuleTest.yml:7]:
polardbx-optimizer/src/test/java/com/alibaba/polardbx/planner/rewriter/ConstantFoldRuleTest.java#L1
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]>
|
|
build
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v2, actions/setup-java@v1, actions/cache@v2. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
|
|
build
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/checkout@v2, actions/setup-java@v1, actions/cache@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
|