Re: FW: BUG #17258: Unexpected results in CHAR(1) data type

I disagree about it being a feature request.

I was only using substr to demonstrate the problem.

Here is the problem without using any functions:

 

create table x (a char(1));

insert into x values ('x');

insert into x values (' ');

select length(a) from x;

1

0