BUG #1200: VACUUM ANALYZE bug
От | PostgreSQL Bugs List |
---|---|
Тема | BUG #1200: VACUUM ANALYZE bug |
Дата | |
Msg-id | 20040726173518.2CE17CF4D38@www.postgresql.com обсуждение исходный текст |
Ответы |
Re: BUG #1200: VACUUM ANALYZE bug
|
Список | pgsql-bugs |
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...
В списке pgsql-bugs по дате отправления: