[DRILL-1937] Throw exception and give error message when Non-scalar sub-query used in an expression

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 0.8.0
• Component/s: SQL Parser
• Assignee: Aman Sinha
• Reporter: Victoria Markman
• Created: 06/Jan/15 19:05
• Updated: 07/Aug/17 16:47
• Resolved: 14/Feb/15 00:40

Description

#Fri Jan 02 21:20:47 EST 2015
git.commit.id.abbrev=b491cdb

It is dangerous to have an internal function be exposed to users.
What if one day user decided to write a UDF with the same signature ?

0: jdbc:drill:schema=dfs> select SINGLE_VALUE(1) from `t.json`;
+--+
|  |
+--+
+--+
No rows selected (0.111 seconds)

Issue Links

• is duplicated by: DRILL-1936 Throw an error if subquery in the where clause does not return scalar result
• relates to: DRILL-3258 Add support for non-scalar subqueries in expressions within HAVING clause