Incorrect SIZE() result (RESOLVED)

[kuonirat]

Hi!

Take a look at this:

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

insert into tvw values('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxa');
insert into ti values('xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxa');

select size(c) as s from tvw;
select size(c) as s from ti;

\g

The result is:

* * * * * * * * * * * * Executing . . .

(1 row)
(1 row)

┌─────────────┐
│s            │
├─────────────┤
│           -1│
└─────────────┘
(1 row)

┌─────────────┐
│s            │
├─────────────┤
│          255│
└─────────────┘
(1 row)

which is correct for standard Ingres tables, but incorrect for VW.

Best regards!

[marcin]

Thanks, Konrad, I think we should establish a rule: for every bug we get you a beer in "Spiz" (at least!). Then all your Fridays are happy days

Filed as Mantis #934, and almost resolved already.

[marcin]

... and fixed/commited/tested, should be available in the next 1.0 build

[kuonirat]

I also recommend "Koźlak" beer e. g. in "Academus", if You'd like to have a dark beer in Wrocław You can get "thin" beer in "Spiż" sometimes

[marcin]

Always new forums are a good method of exchanging useful information

[zelaine]

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