Zhiyong Liu created DRILL-871:
---------------------------------
Summary: Drill fails to detect syntax errors
Key: DRILL-871
URL: https://issues.apache.org/jira/browse/DRILL-871
Project: Apache Drill
Issue Type: Bug
Components: Functions - Hive
Reporter: Zhiyong Liu
Accidentally had a typo in a query, such as
select o.O_TOTALPRICE, c.C_NAME
from orders o, customer c
where o.C_CUSTKEY = c.C_CUSTKEY and o.O_TOTALPRICE > 400000.00
order by o.O_TOTALPRICE;
The typo is o.C_CUSTKEY, which should be o.O_CUSTKEY. Drill executes the query
with no error detected:
0: jdbc:drill:schema=dfs.TpcHMulti> select o.O_TOTALPRICE, c.C_NAME
. . . . . . . . . . . . . . . . . > from orders o, customer c
. . . . . . . . . . . . . . . . . > where o.C_CUSTKEY = c.C_CUSTKEY and
o.O_TOTALPRICE > 400000.00
. . . . . . . . . . . . . . . . . > order by o.O_TOTALPRICE;
+--+
| |
+--+
+--+
No rows selected (1.161 seconds)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
