Abhishek Girish created DRILL-5579: -------------------------------------- Summary: Nested cast to boolean fails for integer values greater than 1 Key: DRILL-5579 URL: https://issues.apache.org/jira/browse/DRILL-5579 Project: Apache Drill Issue Type: Bug Components: Execution - Data Types, Query Planning & Optimization Affects Versions: 1.11.0 Reporter: Abhishek Girish Assignee: Chunhui Shi
As per Drill's casting rules, integer value 0 when casted to Boolean returns false. All other integers when casted to Boolean should return true. The following query fails: {code} > select cast(cast(345 as int) as boolean) as a from (values(1)); Error: SYSTEM ERROR: IllegalArgumentException: Invalid value for boolean: 345 (java.lang.IllegalArgumentException) Invalid value for boolean: 345 org.apache.drill.exec.expr.BooleanType.get():74 org.apache.drill.exec.test.generated.ProjectorGen10.doSetup():88 org.apache.drill.exec.test.generated.ProjectorGen10.setup():101 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.setupNewSchema():492 org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():78 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():135 org.apache.drill.exec.record.AbstractRecordBatch.next():162 org.apache.drill.exec.physical.impl.BaseRootExec.next():104 org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext():81 org.apache.drill.exec.physical.impl.BaseRootExec.next():94 org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():232 org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():226 java.security.AccessController.doPrivileged():-2 javax.security.auth.Subject.doAs():422 org.apache.hadoop.security.UserGroupInformation.doAs():1595 org.apache.drill.exec.work.fragment.FragmentExecutor.run():226 org.apache.drill.common.SelfCleaningRunnable.run():38 java.util.concurrent.ThreadPoolExecutor.runWorker():1142 java.util.concurrent.ThreadPoolExecutor$Worker.run():617 java.lang.Thread.run():745 (state=,code=0) {code} The following query works as expected: {code} > select cast(t.a as boolean) from (select cast(345 as int) as a from > (values(1)) )t; +---------+ | EXPR$0 | +---------+ | true | +---------+ 1 row selected (0.244 seconds) {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)