[jira] [Commented] (DRILL-1089) SUBSTRING(string, from) function fails

["Krystal (JIRA)" <ji...@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.<init>(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)