This is the continuation of IMPALA-4810 to finish the remaining cases:
See IMPALA-4810 for more background.
Make DECIMAL_V2 the default mode
Different results from power() with cast decimal expression vs. the equivalent literal value as base parameter
Rounding should be done instead of truncating when casting DECIMAL to DECIMAL, FLOAT/DOUBLE to DECIMAL, DECIMAL to INT