[
https://issues.apache.org/jira/browse/HIVE-28722?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17916387#comment-17916387
]
Stamatis Zampetakis commented on HIVE-28722:
--------------------------------------------
All improvements/fixes in the non-CBO path have low priority and may never get
fixed. Disabling CBO is not recommended and the property will disappear in the
near future (HIVE-27830).
> Missing implicit string to date cast leads to data correctness issue when CBO
> is off
> ------------------------------------------------------------------------------------
>
> Key: HIVE-28722
> URL: https://issues.apache.org/jira/browse/HIVE-28722
> Project: Hive
> Issue Type: Bug
> Reporter: Krisztian Kasa
> Priority: Minor
>
> Repro
> {code}
> create table t1 (a string, b int);
> insert into t1 values ('2014-03-14 10:10:12', 10);
> set hive.cbo.enable=false;
> select * from t1 where a between date_add('2014-03-14', -1) and '2014-03-14';
> {code}
> The query does not return any row but it should return
> {code}
> 2014-03-14 10:10:12 10
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
