Here is the list of the failed tests on my machine that needs to be researched:

working_tpch1_compareLogOnly/sub/bug3780.sql

working_tpch1_compareLogOnly/regr/regr_r2.sql

Compare failed - working_tpch1_compareLogOnly/misc/3a-xlou.sql

Compare failed - working_tpch1_compareLogOnly/misc/3b-xlou.sql

Compare failed - working_tpch1_compareLogOnly/misc/bug2891_negative.sql

Compare failed - working_tpch1_compareLogOnly/misc/bug3691.sql

Compare failed - working_tpch1_compareLogOnly/misc/bug5715.sql

Compare failed - working_tpch1_compareLogOnly/misc/sumavgoverflow.sql

Compare failed - working_tpch1/qa_fe_cnxFunctions/bug3334_ceil.sql

Compare failed - working_tpch1/qa_fe_cnxFunctions/bug3334_overflow_error.negative.sql

Othere failed tests are known and described(floor/ceil, bit ops, timezone dependant functions).
The list produced by CI is bigger. There are number of issues not listed here.

I used the solution from this commit to fix working_tpch1_compareLogOnly/sub/bug3780.sql.

There is a floating error that occasionally happens in unsigned tests:
Compare failed - working_tpch1_compareLogOnly/unsigned/unsigned_greatest.sql
Compare failed - working_tpch1_compareLogOnly/unsigned/unsigned_joins.sql
Compare failed - working_tpch1_compareLogOnly/unsigned/unsigned_least.sql
For details see MCOL-4519