[Postgres-xc-developers] error in "insert...select "

[黄秋华 <ra...@16...>]

hi
there is still error in "insert...select"


create 3 tables:

CREATE TABLE INT4_TBL(f1 int4);
CREATE TABLE FLOAT8_TBL(f1 float8);
CREATE TABLE TEMP_GROUP (f1 INT4, f2 INT4, f3 FLOAT8);


insert records
insert into INT4_TBL values(1);
insert into FLOAT8_TBL values(1.0);


INSERT INTO TEMP_GROUP
  SELECT 1, (- i.f1), (- f.f1)
  FROM INT4_TBL i, FLOAT8_TBL f;


now:  
select * from TEMP_GROUP;
result is 0 row