Back to pull request #51224

[Enhancement] enable adaptive partition hash join by default #25209

Triggered via pull request September 20, 2024 11:42

stdpain

synchronize #51224

Status Success

Total duration 27s

Artifacts –

ci-proto-checker.yml

on: pull_request_target

PROTO FILTER

ADD PROTO REVIEW LABEL

Annotations

51 errors and 3 warnings

ADD PROTO REVIEW LABEL

Error: failed to remove labels: PROTO-REVIEW

TestSQLCases.test: TestSQLCases#L1

Element counts were not equal: First has 1, Second has 0: '3' First has 0, Second has 1: '4' : sql result not match: - [SQL]: select count(*) as c from lineitem l1 where l1.l_orderkey not in ( select l3.l_orderkey from lineitem l3 where l3.l_suppkey <> l1.l_suppkey ); - [exp]: ['3'] - [act]: ['4'] ---

TestSQLCases.test_basic_window_function: TestSQLCases#L1

Element counts were not equal: First has 1, Second has 0: 'None\tNone\tNone\tNone' First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.191.173 alive: true inBlacklist: false] [172.26.191.172 alive: true inBlacklist: true] [172.26.191.171 alive: true inBlacklist: false] ')" : sql result not match: - [SQL]: SELECT SUM(wv), AVG(wv), MIN(wv), MAX(wv) FROM (SELECT LAG(v4 IGNORE NULLS, 3) OVER(ORDER BY v5) AS wv FROM t1) a; - [exp]: ['None\tNone\tNone\tNone'] - [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.191.173 alive: true inBlacklist: false] [172.26.191.172 alive: true inBlacklist: true] [172.26.191.171 alive: true inBlacklist: false] ')"] ---

TestSQLCases.test_jit_cast: TestSQLCases#L1

Element counts were not equal: Diff is 934 characters long. Set self.maxDiff to None to see it. : sql result not match: - [SQL]: SELECT v1 + v2 - v3 + v4 + v5 - v6 as result FROM jit_cast ORDER BY result, k1, k2,v1; - [exp]: ['None', 'None', 'None', 'None', 'None', 'None', 'None', 'None', 'None', 'None', 'None', '-2147483649', '-18576', '-2', '-2', '0', '2', '21', '150', '151', '308', '490', '575', '1482', '123441222', '2147418184', '9223372034707292160', '9223372036854742912', '9223372036854765307'] - [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.191.173 alive: true inBlacklist: false] [172.26.191.172 alive: true inBlacklist: true] [172.26.191.171 alive: true inBlacklist: false] ')"] ---

TestSQLCases.test_join_array: TestSQLCases#L1

Element counts were not equal: First has 1, Second has 0: '[1,null]\t[1.0000000000000000000,null]' First has 1, Second has 0: '[1,2]\t[1.0000000000000000000,2.0000000000000000000]' First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.191.173 alive: true inBlacklist: false] [172.26.191.172 alive: true inBlacklist: true] [172.26.191.171 alive: true inBlacklist: false] ')" : sql result not match: - [SQL]: select s.i_1, t.d_3 from array_test s join array_test t on s.i_1 = t.d_3 order by 1, 2; - [exp]: ['[1,null]\t[1.0000000000000000000,null]', '[1,2]\t[1.0000000000000000000,2.0000000000000000000]'] - [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.191.173 alive: true inBlacklist: false] [172.26.191.172 alive: true inBlacklist: true] [172.26.191.171 alive: true inBlacklist: false] ')"] ---

TestSQLCases.test_join_map: TestSQLCases#L1

Element counts were not equal: First has 1, Second has 0: '{null:null}\t{null:null}' First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.191.173 alive: true inBlacklist: false] [172.26.191.172 alive: true inBlacklist: true] [172.26.191.171 alive: true inBlacklist: true] ')" : sql result not match: - [SQL]: select t.map0, s.map4 from map_test t join map_test s where s.map0 = t.map4 order by t.pk; - [exp]: ['{null:null}\t{null:null}'] - [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.191.173 alive: true inBlacklist: false] [172.26.191.172 alive: true inBlacklist: true] [172.26.191.171 alive: true inBlacklist: true] ')"] ---

TestSQLCases.test_jit_fpe: TestSQLCases#L1

Element counts were not equal: First has 2, Second has 0: 'None' First has 1, Second has 0: '-1481.52612783528' First has 3, Second has 0: '2892.193' First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.191.173 alive: true inBlacklist: false] [172.26.191.172 alive: true inBlacklist: true] [172.26.191.171 alive: true inBlacklist: true] ')" : sql result not match: - [SQL]: SELECT v2 % v5 + 2892.193 as result FROM jit_fpe ORDER BY result; - [exp]: ['None', 'None', '-1481.52612783528', '2892.193', '2892.193', '2892.193'] - [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.191.173 alive: true inBlacklist: false] [172.26.191.172 alive: true inBlacklist: true] [172.26.191.171 alive: true inBlacklist: true] ')"] ---

TestSQLCases.test_join_struct: TestSQLCases#L1

Element counts were not equal: First has 1, Second has 0: '{"c0":0,"c1":"ab"}\t{"c0":0,"c1":"ab"}' First has 1, Second has 0: '{"c0":1,"c1":null}\t{"c0":1,"c1":null}' First has 1, Second has 0: '{"c0":null,"c1":null}\t{"c0":null,"c1":null}' First has 1, Second has 0: '{"c0":3,"c1":""}\t{"c0":3,"c1":""}' First has 0, Second has 1: "E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.191.173 alive: true inBlacklist: false] [172.26.191.172 alive: true inBlacklist: true] [172.26.191.171 alive: true inBlacklist: true] ')" : sql result not match: - [SQL]: select t.s0, s.s0 from struct_test t join struct_test s where s.s0 = t.s0 order by t.pk; - [exp]: ['{"c0":0,"c1":"ab"}\t{"c0":0,"c1":"ab"}', '{"c0":1,"c1":null}\t{"c0":1,"c1":null}', '{"c0":null,"c1":null}\t{"c0":null,"c1":null}', '{"c0":3,"c1":""}\t{"c0":3,"c1":""}'] - [act]: ["E: (1064, 'Backend node not found. Check if any backend node is down.backend: [172.26.191.173 alive: true inBlacklist: false] [172.26.191.172 alive: true inBlacklist: true] [172.26.191.171 alive: true inBlacklist: true] ')"] ---

TestSQLCases.test_join_with_other_predicate: TestSQLCases#L1

True is not false : sql result not match: actual with E(E: (5025, '[E111]Fail to connect Socket{id=34359738572 addr=172.26.191.172:8060:8060} (0x0x7f72c52a2540): Connection refused [R1][E112]Not connected to 172.26.191.172:8060 yet, server_id=34359738572 [R2][E112]Not connected to 172.26.191.172:8060 yet, server_id=34359738572 [R3][E112]Not connected to 172.26.191.172:8060 yet, server_id=34359738572: be:172.26.191.172'))

TestSQLCases.test_json_check_number_overflow: TestSQLCases#L1