POSITION() overflow (RESOLVED)

[kuonirat]

Hi!

Take a look at this:

drop table t;
create table t (
    c varchar(255) not null
) with structure = vectorwise;

insert into t values('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxa');

select 
position('a', c) as p,
position('a', c) + 1 as pa,
locate(c, 'a') as l,
locate(c, 'a') + 1 as la
from t

\g

This is the output:

┌─────────────┬──────────────────────┬─────────────┬──────────────────────┐
│p            │pa                    │l            │la                    │
├─────────────┼──────────────────────┼─────────────┼──────────────────────┤
│          127│                  -128│          127│                   128│
└─────────────┴──────────────────────┴─────────────┴──────────────────────┘

So the POSITION function returns a signed byte, which overflows within the +1 expression. There is no such problem with standard ingres table or when LOCATE function is used instead of POSITION.

Best regards!

[marcin]

Thanks Konrad, this one is actually improved in the dev trunk, but we'll try to fix it for 1.0 as well.

Mantis #933 for people tracking this.

[marcin]

Btw, did I mention this is fixed? But, unfortunately, the latest build did not pick it up yet, so it will come in the following one.

[zelaine]

This issue is fixed in the now available 1.0/11402 build.