Thread: BUG #1200: VACUUM ANALYZE bug

BUG #1200: VACUUM ANALYZE bug

From
"PostgreSQL Bugs List"
Date:
The following bug has been logged online:

Bug reference:      1200
Logged by:          André Otero

Email address:      andre@iee.usp.br

PostgreSQL version: 7.4

Operating system:   Debian Linux on Alpha

Description:        VACUUM ANALYZE bug

Details:

Before I run the VACUUM ANALYZE command all query that use JOIN command
return the error: ERROR invalid typeLen: 0.
However the data of tables are unbroken.

Example:
create table departaments
( dp-id int,
name varchar(30),
primary key(dp-id) );

create table requests
( rq-id int,
dp-id int references departaments(dp-id),
description varchar(30),
primary key(dp-id) );

insert into departaments values (1,'Informatica');
insert into departaments values (2,'Recurcos Humanos');
insert into departaments values (3,'Compras');
insert into departaments values (4,'Marketing');
insert into departaments values (5,'Diretoria');
insert into departaments values (6,'Ensino');

insert into requests values (1,1,'nothing');
insert into requests values (2,1,'nothing');
insert into requests values (3,2,'nothing');
insert into requests values (4,3'nothing');
insert into requests values (5,4,'nothing');
insert into requests values (6,4'nothing');

select rq-id,name from requests left join departaments on requests.dp-id =
departaments.dp.id;

this result in:
rq-id | name
1      |  Informatica
2      | Informatica
3      | Recursos Humanos
4      | Compras
5      | Marketing
6      | Marketing

now execute VACUUM ANALYZE.... the query dont work...

Re: BUG #1200: VACUUM ANALYZE bug

From
Tom Lane
Date:
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
> Before I run the VACUUM ANALYZE command all query that use JOIN command
> return the error: ERROR invalid typeLen: 0.

You seem to have a rather badly broken copy of Postgres :-(  Does it
pass the regression tests?  (I'd bet not.)

PG 7.4 is known to run on Linux/Alpha, and since the report in the
"supported platforms" table is from someone at debian.org, I would
imagine that test was specifically on Debian.  So it ought to work
for you.  Perhaps you got a corrupted download, or used a buggy
compiler to build it, or some such.

            regards, tom lane