SQL arithmetic operations return the wrong value in Phoenix

[#1]

Problem: Certain arithmetic operations return the wrong result in Phoenix.

For example:

0: jdbc:phoenix:> select 2/4 ;
+----+
| 0  |
+----+
| 0  |
+----+
1 row selected (0.014 seconds)

Cause: This is because the result is returned as an int rather than a decimal

See PHOENIX-3312

Workaround: Provide decimal values within the SQL

e.g.

0: jdbc:phoenix:> select 2.0/4.0 ;
+------+
| 0.5  |
+------+
| 0.5  |
+------+
1 row selected (0.011 seconds)