[
https://issues.apache.org/jira/browse/DRILL-794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chun Chang updated DRILL-794:
-----------------------------
Component/s: Functions - Drill
> decimal addition involving boundary numbers caused foreman setup assertion
> --------------------------------------------------------------------------
>
> Key: DRILL-794
> URL: https://issues.apache.org/jira/browse/DRILL-794
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Reporter: Chun Chang
> Assignee: Mehant Baid
>
> The following decimal operation caused the assertion:
> 0: jdbc:drill:schema=dfs> select cast('999999999999999999' as decimal(18,0))
> + cast('-0.0000000000000000000000000000000000001' as decimal(38,38)) from
> data limit 1;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
> running query.[error_id: "7b386343-2573-4f7b-b7fe-be9bfdf35237"
> endpoint {
> address: "qa-node119.qa.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while setting up Foreman. < AssertionError"
> ]
> Error: exception while executing query (state=,code=0)
> Here is the stack trace:
> 17:36:40.565 [WorkManager Event Thread] DEBUG
> o.apache.drill.exec.work.WorkManager - Starting pending task
> org.apache.drill.exec.work.foreman.Foreman@eb155db
> 17:36:40.575 [ba6d37ab-c589-4bd2-974e-2e3854988100:foreman] ERROR
> o.a.drill.exec.work.foreman.Foreman - Error
> 7b386343-2573-4f7b-b7fe-be9bfdf35237: Failure while setting up Foreman.
> java.lang.AssertionError: null
> at
> org.eigenbase.sql.type.ReturnTypes$7.inferReturnType(ReturnTypes.java:473)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.type.SqlTypeTransformCascade.inferReturnType(SqlTypeTransformCascade.java:55)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.type.SqlReturnTypeInferenceChain.inferReturnType(SqlReturnTypeInferenceChain.java:57)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.SqlOperator.inferReturnType(SqlOperator.java:451)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.SqlOperator.validateOperands(SqlOperator.java:418)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at org.eigenbase.sql.SqlOperator.deriveType(SqlOperator.java:480)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.SqlBinaryOperator.deriveType(SqlBinaryOperator.java:143)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:3870)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:3857)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at org.eigenbase.sql.SqlCall.accept(SqlCall.java:133)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.deriveTypeImpl(SqlValidatorImpl.java:1322)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.deriveType(SqlValidatorImpl.java:1305)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.expandSelectItem(SqlValidatorImpl.java:418)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateSelectList(SqlValidatorImpl.java:3019)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2772)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:80)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:747)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:736)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:209)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:710)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:426)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:175)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:99)
>
> ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:84)
>
> ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:134)
>
> ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:338)
> ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:186)
> ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> [na:1.7.0_45]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> [na:1.7.0_45]
> at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
--
This message was sent by Atlassian JIRA
(v6.2#6252)
