[ASTERIXDB-1256] Invalid queries returning some results

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Component/s: *DB - AsterixDB
• Assignee: Murtadha Makki Al Hubail
• Reporter: Murtadha Makki Al Hubail
• Created: 09/Jan/16 22:46
• Updated: 11/Jan/16 17:40
• Resolved: 11/Jan/16 17:27

Description

I was investigating a sporadic failure in the test case aggregate/avg_mixed which does nothing but executes the below query and makes sure that an exception with the message "Unexpected type STRING in aggregation input stream. Expected type FLOAT. [AlgebricksException]" is thrown:

avg(
for $x in [float("2.0"), "hello world", 93847382783847382, date("2013-01-01")]
return $x
)

However, if you execute the query few times, sometimes it will return the error message as well as some results!!
The output looks something like this:
Error:
Results:
2.0d

Message:
Unexpected type STRING in aggregation input stream. Expected type FLOAT. [AlgebricksException]

Issue Links

• relates to: ASTERIXDB-1241 Aggregate functions min_mixed test case fails