[Postgres-xc-bugs] Two possible xc bugs

[Hitoshi H. <hem...@la...>]

Hi there.

This is a report of two possible pg-xc bugs.

============================================================================
POSTGRES-XC BUG REPORT TEMPLATE
============================================================================

Your name : Hitoshi Hemmi
Your email address : hem...@la...


System Configuration:
---------------------
Architecture : x86_64

Operating System : RHEL 6.1

Postgres-XC version : Postgres-XC 1.0beta1

Compiler used : gcc 4.4.5


Description of problems:
==============================================

#### Operations on Postgres-XC

postgres=# SELECT version();
version
------------------------------------------------------------------------------------------------------------------------------------------------
Postgres-XC 1.0beta1 on x86_64-unknown-linux-gnu, based on PostgreSQL
9.1beta2, compiled by gcc (GCC) 4.4.5 20110214 (Red Hat 4.4.5-6), 64-bit
(1 row)

#### (Problem 1)

postgres=# CREATE TABLE test(test int);
CREATE TABLE
postgres=# CREATE TABLE test_old(test int);
CREATE TABLE
postgres=# INSERT INTO test VALUES (1);
INSERT 0 1
postgres=# WITH deleted as(delete from test where test=1 returning test)
insert INTO test_old SELECT * from deleted;
ERROR: could not read block 0 in file "base/12863/16521": read only 0 of
8192 bytes


#### (Problem 2)

postgres=# CREATE TABLE test(test int,test_date timestamp);
CREATE TABLE
postgres=# INSERT INTO test VALUES (1,now());
INSERT 0 1 ^
postgres=# DELETE FROM test where test_date < now();
ERROR: attribute 2 has wrong type
DETAIL: Table has type tid, but query expects timestamp without time zone.


==============================================

#### Same operations on PostgreSQL

postgres=# SELECT version();
version
--------------------------------------------------------------------------------------------------------------
PostgreSQL 9.1.0 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
4.4.5 20110214 (Red Hat 4.4.5-6), 64-bit
(1 row)


postgres=# CREATE TABLE test(test int);
CREATE TABLE
postgres=# CREATE TABLE test_old(test int);
CREATE TABLE
postgres=# INSERT INTO test VALUES (1);
INSERT 0 1
postgres=# WITH deleted as(delete from test where test=1 returning test)
insert INTO test_old SELECT * from deleted;
INSERT 0 1


postgres=# CREATE TABLE test(test int,test_date timestamp);
CREATE TABLE
postgres=# INSERT INTO test VALUES (1,now());
INSERT 0 1
postgres=# DELETE FROM test where test_date < now();
DELETE 1

==============================================

Tnks.

-- 
Hitoshi HEMMI
NTT Open Source Software Center
hem...@la...
(Please note that my address has changed.)
Tel:(03)5860-5115
Fax:(03)5463-5490