[ https://issues.apache.org/jira/browse/HIVE-21316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16776865#comment-16776865 ]
Zoltan Haindrich edited comment on HIVE-21316 at 2/25/19 3:16 PM: ------------------------------------------------------------------ sqll2011 ; 6.13.12.a.ii cast specification: {code} If the length in octets of SV is larger than LTD, then TV is the first LTD octets of SV and a completion condition is raised: warning — string data, right truncation. {code} the existing behaviour is truncate without warning and "return null" if the string was not within the design specifications ; for example in case length>255 for char was (Author: kgyrtkirk): sqll2011 ; 6.13.12.a.ii cast specification: {code} If the length in octets of SV is larger than LTD, then TV is the first LTD octets of SV and a completion condition is raised: warning — string data, right truncation. {code} the existing behaviour to "return null" if the string was not fit into the {{char\(n\)}} type was incorrect. > Comparision of varchar column and string literal should happen in varchar > ------------------------------------------------------------------------- > > Key: HIVE-21316 > URL: https://issues.apache.org/jira/browse/HIVE-21316 > Project: Hive > Issue Type: Improvement > Reporter: Zoltan Haindrich > Assignee: Zoltan Haindrich > Priority: Major > > this is most probably the root cause behind HIVE-21310 as well -- This message was sent by Atlassian JIRA (v7.6.3#76005)