postgres-xc-bugs

[Postgres-xc-bugs] One more anomaly (RESENT)

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

Hi all,

I resend this report, because the previous one may not be delivered.

============================================================================
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.1.2


Description of problem:
==============================================
#### 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.1.2 20080704 (Red Hat 4.1.2-52), 64-bit
(1 row)
postgres=# CREATE TABLE test(test int);
CREATE TABLE
postgres=# INSERT INTO test VALUES (1);
INSERT 0 1
postgres=# CREATE TABLE test2 as select * from test;
INSERT 0 1

==============================================
#### PostgreSQL

postgres=# SELECT version();
                                                    version
---------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.1.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-52), 64-bit
(1 row)
postgres=# CREATE TABLE test(test int);
CREATE TABLE
postgres=# INSERT INTO test VALUES (1);
INSERT 0 1
postgres=# CREATE TABLE test2 as select * from test;
SELECT 1

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


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

Re: [Postgres-xc-bugs] One more anomaly (RESENT)

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

On Fri, Apr 27, 2012 at 3:35 PM, Hitoshi HEMMI
<hem...@la...>wrote:

> Hi all,
>
> I resend this report, because the previous one may not be delivered.
>
>
> ============================================================================
> 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.1.2
>
>
> Description of problem:
> ==============================================
> #### 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.1.2 20080704 (Red Hat 4.1.2-52), 64-bit
> (1 row)
> postgres=# CREATE TABLE test(test int);
> CREATE TABLE
> postgres=# INSERT INTO test VALUES (1);
> INSERT 0 1
> postgres=# CREATE TABLE test2 as select * from test;
> INSERT 0 1
>
> ==============================================
> #### PostgreSQL
>
> postgres=# SELECT version();
>                                                    version
>
> ---------------------------------------------------------------------------------------------------------------
>  PostgreSQL 9.1.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2
> 20080704 (Red Hat 4.1.2-52), 64-bit
> (1 row)
> postgres=# CREATE TABLE test(test int);
> CREATE TABLE
> postgres=# INSERT INTO test VALUES (1);
> INSERT 0 1
> postgres=# CREATE TABLE test2 as select * from test;
> SELECT 1
>
> ==============================================
>
Already registered as bug 3521825.
Put in bucket of 1.1, it has a low priority because Postgres-XC uses INSERT
SELECT as inner planner of CTAS so an INSERT result is returned.
Thanks,
-- 
Michael Paquier
http://michael.otacoo.com