Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-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 E87AB11B33 for ; Fri, 27 Jun 2014 19:10:53 +0000 (UTC) Received: (qmail 68460 invoked by uid 500); 27 Jun 2014 19:10:53 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 68436 invoked by uid 500); 27 Jun 2014 19:10:53 -0000 Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.incubator.apache.org Delivered-To: mailing list issues@drill.incubator.apache.org Received: (qmail 68427 invoked by uid 99); 27 Jun 2014 19:10:53 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Jun 2014 19:10:53 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 27 Jun 2014 19:10:52 +0000 Received: (qmail 67679 invoked by uid 99); 27 Jun 2014 19:10:27 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Jun 2014 19:10:27 +0000 Date: Fri, 27 Jun 2014 19:10:27 +0000 (UTC) From: "Krystal (JIRA)" To: issues@drill.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (DRILL-1089) SUBSTRING(string, from) function fails MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DRILL-1089?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14046295#comment-14046295 ] Krystal commented on DRILL-1089: -------------------------------- Server error: java.lang.AssertionError: typeName.allowsPrecScale(true, false) org.eigenbase.sql.type.BasicSqlType.(BasicSqlType.java:66) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.type.SqlTypeFactoryImpl.createSqlType(SqlTypeFactoryImpl.java:59) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.type.SqlTypeTransforms$4.transformType(SqlTypeTransforms.java:107) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.type.SqlTypeTransformCascade.inferReturnType(SqlTypeTransformCascade.java:62) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.SqlOperator.inferReturnType(SqlOperator.java:451) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.SqlOperator.validateOperands(SqlOperator.java:418) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.SqlFunction.deriveType(SqlFunction.java:290) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.SqlFunction.deriveType(SqlFunction.java:206) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:3870) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:1) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.SqlCall.accept(SqlCall.java:133) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.validate.SqlValidatorImpl.deriveTypeImpl(SqlValidatorImpl.java:1322) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.validate.SqlValidatorImpl.deriveType(SqlValidatorImpl.java:1305) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.validate.SqlValidatorImpl.expandSelectItem(SqlValidatorImpl.java:418) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.validate.SqlValidatorImpl.validateSelectList(SqlValidatorImpl.java:3019) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2773) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:80) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:747) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:736) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:209) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:710) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:426) ~[optiq-core-0.7-20140617.012959-7.jar:na] net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:175) ~[optiq-core-0.7-20140617.012959-7.jar:na] org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:128) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:113) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:129) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:400) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:216) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:242) [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT] java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_45] java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_45] java.lang.Thread.run(Thread.java:744) [na:1.7.0_45] > SUBSTRING(string, from) function fails > -------------------------------------- > > Key: DRILL-1089 > URL: https://issues.apache.org/jira/browse/DRILL-1089 > Project: Apache Drill > Issue Type: Bug > Components: Functions - Drill > Reporter: Krystal > > git.commit.id.abbrev=3ea8eb5 > git.build.time=26.06.2014 @ 14\:15\:29 PDT > The following query ran successfully in the last build; but failed in the latest build. > 0: jdbc:drill:schema=dfs> select substring(name, 5) from voter where age < 20; > message: "Failure while setting up Foreman. < AssertionError:[ typeName.allowsPrecScale(true, false) ]" > ] > If I use substr instead of substring, then the query succeeds. -- This message was sent by Atlassian JIRA (v6.2#6252)