Zoltan Haindrich created HIVE-20881: ---------------------------------------
Summary: Constant propagation oversimplifies projections Key: HIVE-20881 URL: https://issues.apache.org/jira/browse/HIVE-20881 Project: Hive Issue Type: Bug Reporter: Zoltan Haindrich Assignee: Zoltan Haindrich {code:java} create table cx2(bool1 boolean); insert into cx2 values (true),(false),(null); set hive.cbo.enable=true; select bool1 IS TRUE OR (cast(NULL as boolean) AND bool1 IS NOT TRUE AND bool1 IS NOT FALSE) from cx2; +--------+ | _c0 | +--------+ | true | | false | | NULL | +--------+ set hive.cbo.enable=false; select bool1 IS TRUE OR (cast(NULL as boolean) AND bool1 IS NOT TRUE AND bool1 IS NOT FALSE) from cx2; +-------+ | _c0 | +-------+ | true | | NULL | | NULL | +-------+ {code} from explain it seems the expression was simplified to: {{(_col0 is true or null)}} -- This message was sent by Atlassian JIRA (v7.6.3#76005)