Re: [Postgres-xc-bugs] Two possible xc bugs

[Michael P. <mic...@gm...>]

On Fri, Apr 27, 2012 at 10:23 AM, Hitoshi HEMMI <hem...@la...
> wrote:

> 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
>
Bug 1 has already been fixed in master, RETURNING clause is not supported.
postgres=# CREATE TABLE test(test int);
CREATE TABLE
postgres=# CREATE TABLE test_old(test int);
CREATE TABLE
postgres=# INSERT INTO test VALUES (1);
INSERT 1 1
postgres=# WITH deleted as(delete from test where test=1 returning test)
postgres-# insert INTO test_old SELECT * from deleted;
ERROR:  RETURNING clause not yet supported

#### (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.
>
This is indeed a bug. I registed it here with id 3521810 assigned to me.
https://sourceforge.net/tracker/?func=detail&aid=3521810&group_id=311227&atid=1310232
This will be fixed.
-- 
Michael Paquier
http://michael.otacoo.com