[ https://issues.apache.org/jira/browse/HIVE-20520?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16609898#comment-16609898 ]
Hive QA commented on HIVE-20520: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12939143/HIVE-20520.02.patch {color:green}SUCCESS:{color} +1 due to 2 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 6 failed/errored test(s), 14933 tests executed *Failed tests:* {noformat} org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerCustomCreatedDynamicPartitions (batchId=251) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerCustomCreatedDynamicPartitionsUnionAll (batchId=251) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerCustomNonExistent (batchId=251) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerHighBytesRead (batchId=251) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerHighShuffleBytes (batchId=251) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerSlowQueryExecutionTime (batchId=251) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/13705/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/13705/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-13705/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 6 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12939143 - PreCommit-HIVE-Build > length(CHAR) doesn't consider trailing space > -------------------------------------------- > > Key: HIVE-20520 > URL: https://issues.apache.org/jira/browse/HIVE-20520 > Project: Hive > Issue Type: Bug > Components: UDF > Reporter: Naresh P R > Assignee: Jesus Camacho Rodriguez > Priority: Major > Attachments: HIVE-20520.01.patch, HIVE-20520.02.patch, > HIVE-20520.02.patch, HIVE-20520.patch > > > Reproduce steps: > {code:java} > create table test(a char(2), b varchar(2)); > insert into test values('L ', 'L '); > select length(a),length(b) from test; > +------+------+ > | _c0 | _c1 | > +------+------+ > | 1 | 2 | > +------+------+ > 1 row selected (0.185 seconds) > {code} > Here char with trailing spaces are trimmed, whereas leading spaces are not > trimmed. -- This message was sent by Atlassian JIRA (v7.6.3#76005)