Incorrect fixed-length character string values

drop table if exists test;
create table test (col1 char(5));
insert into test values ('abc');

declare v char(5);
set v = 'abc';

select
col1,
char_length(col1) length_1,
char_length(v) length_2,
char_length(cast('abc' as char(5))) length_3
from test;

The values derived from the variable v and the expression cast('abc' as
char(5)) are obviously wrong (length 3 instead of 5). The value derived from
the test.col1 column is correct (length 5).

Ole

> The values derived from the variable v and the expression cast('abc'
> as char(5)) are obviously wrong (length 3 instead of 5). The value
> derived from the test.col1 column is correct (length 5).

collected in #2301 (ditto for the cast... concatenation in the where
clause).

--

Eivind Bakkestuen
Nexus Database Systems Pty Ltd

Eivind Bakkestuen [NDD] wrote:

> > The values derived from the variable v and the expression cast('abc'
> > as char(5)) are obviously wrong (length 3 instead of 5). The value
> > derived from the test.col1 column is correct (length 5).
>
> collected in #2301 (ditto for the cast... concatenation in the where clause).

fixed

--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm