[ASTERIXDB-3015] avg() returns incorrect result if first value is not a number

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.6
• Fix Version/s: 0.9.8
• Component/s: FUN - Functions
• Assignee: Dmitry Lychagin
• Reporter: Dmitry Lychagin
• Created: 15/Feb/22 18:10
• Updated: 26/Feb/22 00:51
• Resolved: 26/Feb/22 00:51

Description

avg() function returns incorrect result if it receives a first value of a non-numeric type.

select value avg(x) from ["a", 1, 2, 3] x;

returns NULL, while it should return 2.

Issue Links

• links to: Code review