[TRAFODION-3024] function lower() return null for varchar column when pcode is disabled.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: any
• Component/s: sql-general
• Assignee: Yang, Yongfeng
• Reporter: Yang, Yongfeng
• Created: 16/Apr/18 07:14
• Updated: 16/Apr/18 07:14

Description

create table d1(c1 char(10), c2 varchar(10));

insert into t1 values('sdf', 'abc'),('CDE','EFG');

cqd pcode_opt_level 'off';

>>select lower(c2) from d1;

(EXPR)
----------

 

— 2 row(s) selected.