You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Robert Hou (JIRA)" <ji...@apache.org> on 2016/10/27 01:56:00 UTC
[jira] [Commented] (DRILL-4971) query encounters system error:
Statement "break AndOP3" is not enclosed by a breakable statement with
label "AndOP3"
[ https://issues.apache.org/jira/browse/DRILL-4971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15610345#comment-15610345 ]
Robert Hou commented on DRILL-4971:
-----------------------------------
Put the two files into a directory called "test".
> query encounters system error: Statement "break AndOP3" is not enclosed by a breakable statement with label "AndOP3"
> --------------------------------------------------------------------------------------------------------------------
>
> Key: DRILL-4971
> URL: https://issues.apache.org/jira/browse/DRILL-4971
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow
> Reporter: Robert Hou
> Attachments: low_table, medium_table
>
>
> This query returns an error:
> select count(\*) from test where ((int_id > 3060 and int_id < 6002) or (int_id > 9025 and int_id < 11976)) and ((int_id > 9025 and int_id < 11976) or (int_id > 3060 and int_id < 6002)) and (int_id > 3060 and int_id < 6002);
> Error: SYSTEM ERROR: CompileException: Line 232, Column 30: Statement "break AndOP3" is not enclosed by a breakable statement with label "AndOP3"
> There are two partitions to the test table. One covers the range 3061 - 6001 and the other covers the range 9026 - 11975.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)