[PHOENIX-2052] Division Bug In Group By SQL The result turn to NULL

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Cannot Reproduce
• Affects Version/s: 4.3.0
• Fix Version/s: 4.7.0
• Labels: verify

Environment

hbase 0.98 phoenix 4.3

• Assignee: Sergey Soldatov
• Reporter: PeiLiping
• Created: 18/Jun/15 08:40
• Updated: 05/Feb/16 19:28
• Resolved: 05/Feb/16 19:27

Description

when use division in group by sql the result turn to null

select a , floor( b/4 ) as t from test group by a, t
123 null
123 null

select a , floor( b * 0.25 ) as t from test group by a, t
123 1
123 2