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