Return-Path: X-Original-To: apmail-tajo-issues-archive@minotaur.apache.org Delivered-To: apmail-tajo-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A8C58185EC for ; Fri, 23 Oct 2015 04:25:31 +0000 (UTC) Received: (qmail 67941 invoked by uid 500); 23 Oct 2015 04:25:31 -0000 Delivered-To: apmail-tajo-issues-archive@tajo.apache.org Received: (qmail 67901 invoked by uid 500); 23 Oct 2015 04:25:31 -0000 Mailing-List: contact issues-help@tajo.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@tajo.apache.org Delivered-To: mailing list issues@tajo.apache.org Received: (qmail 67892 invoked by uid 99); 23 Oct 2015 04:25:31 -0000 Received: from Unknown (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Oct 2015 04:25:31 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 0CA931809B9 for ; Fri, 23 Oct 2015 04:25:31 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.97 X-Spam-Level: X-Spam-Status: No, score=0.97 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, T_RP_MATCHES_RCVD=-0.01] autolearn=disabled Received: from mx1-eu-west.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id 8DelsIkcLDYc for ; Fri, 23 Oct 2015 04:25:29 +0000 (UTC) Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx1-eu-west.apache.org (ASF Mail Server at mx1-eu-west.apache.org) with SMTP id D6E6B2074F for ; Fri, 23 Oct 2015 04:25:28 +0000 (UTC) Received: (qmail 67213 invoked by uid 99); 23 Oct 2015 04:25:28 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Oct 2015 04:25:28 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id D6F7E2C033A for ; Fri, 23 Oct 2015 04:25:27 +0000 (UTC) Date: Fri, 23 Oct 2015 04:25:27 +0000 (UTC) From: "Hudson (JIRA)" To: issues@tajo.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (TAJO-1643) SQLParse can't parse parentheses table clause MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/TAJO-1643?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14970409#comment-14970409 ] Hudson commented on TAJO-1643: ------------------------------ SUCCESS: Integrated in Tajo-master-build #947 (See [https://builds.apache.org/job/Tajo-master-build/947/]) TAJO-1643: SQLParse can't parse table alias in in brackets. (hyunsik: rev a89b52337ef7d7c728e071766ccee6436ccde6a5) * tajo-sql-parser/src/main/antlr4/org/apache/tajo/parser/sql/SQLParser.g4 * tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/parentheses_table_2.sql * tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/parentheses_table_1.sql * CHANGES * tajo-core-tests/src/test/resources/queries/TestSQLAnalyzer/positive/parentheses_table_3.sql > SQLParse can't parse parentheses table clause > --------------------------------------------- > > Key: TAJO-1643 > URL: https://issues.apache.org/jira/browse/TAJO-1643 > Project: Tajo > Issue Type: Bug > Components: SQL Parser > Reporter: Jaehwa Jung > Assignee: Hyunsik Choi > Fix For: 0.12.0, 0.11.1 > > > SQLParser can't parse table alias in brackets as following: > {code:xml} > tpch> select c.* > > from (customer as c) > > ; > ERROR: syntax error at or near '(' > LINE 2:5 from (customer as c) > {code} > Above case, I found error logs as follows. > {code:xml} > Caused by: org.apache.tajo.engine.parser.SQLParseError: ERROR: syntax error at or near '(' > LINE 2:5 from (customer as c) > ^ > at org.apache.tajo.engine.parser.SQLErrorListener.syntaxError(SQLErrorListener.java:36) > at org.antlr.v4.runtime.ProxyErrorListener.syntaxError(ProxyErrorListener.java:65) > at org.antlr.v4.runtime.Parser.notifyErrorListeners(Parser.java:473) > at org.apache.tajo.engine.parser.SQLErrorStrategy.reportNoViableAltException(SQLErrorStrategy.java:57) > at org.apache.tajo.engine.parser.SQLErrorStrategy.reportError(SQLErrorStrategy.java:35) > at org.apache.tajo.engine.parser.SQLParser.table_reference(SQLParser.java:10002) > at org.apache.tajo.engine.parser.SQLParser.table_reference_list(SQLParser.java:9925) > at org.apache.tajo.engine.parser.SQLParser.from_clause(SQLParser.java:9874) > at org.apache.tajo.engine.parser.SQLParser.table_expression(SQLParser.java:9781) > at org.apache.tajo.engine.parser.SQLParser.query_specification(SQLParser.java:13541) > at org.apache.tajo.engine.parser.SQLParser.simple_table(SQLParser.java:13251) > at org.apache.tajo.engine.parser.SQLParser.non_join_query_primary(SQLParser.java:13190) > at org.apache.tajo.engine.parser.SQLParser.non_join_query_term(SQLParser.java:13029) > at org.apache.tajo.engine.parser.SQLParser.non_join_query_expression(SQLParser.java:12841) > at org.apache.tajo.engine.parser.SQLParser.query_expression_body(SQLParser.java:12759) > at org.apache.tajo.engine.parser.SQLParser.query_expression(SQLParser.java:12710) > at org.apache.tajo.engine.parser.SQLParser.data_statement(SQLParser.java:669) > at org.apache.tajo.engine.parser.SQLParser.statement(SQLParser.java:422) > at org.apache.tajo.engine.parser.SQLParser.sql(SQLParser.java:307) > at org.apache.tajo.engine.parser.SQLAnalyzer.parse(SQLAnalyzer.java:65) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)