#30 WITH Insert yields "unrecognized node type: 118"

[mason_s]

create database sandbox;
\c sandbox
create schema client;
reate table client.sales( storeid int not null, productid int not null, revenue numeric not null) with(oids = false) distribute by hash(storeid);

insert some data into the table

with client_data as (select (100 * random())::int as storeid, (10000 * random())::int as productid, round((random() * 100)::numeric,2) as revenue from generate_series(1,100)) insert into client.sales select * from client_data;
ERROR: unrecognized node type: 118

[Pavan Deolasee]

Patch committed

[knienart]

Was the patch commited to the master?
It still fails for me with the same error.

[Pavan Deolasee]

On Thursday, November 6, 2014, yazun yazuna@users.sf.net wrote:

Was the patch commited to the master?
It still fails for me with the same error.

I'm sorry. I think I fixed it but later saw some regressions, so revered
the patch. I should have reopend the ticket as well. Will look into it again

Thanks,
Pavan

---

• [tickets:#30] http://sourceforge.net/p/postgres-xl/tickets/30 WITH
  Insert yields "unrecognized node type: 118"*

Status: closed
Milestone: 9.2rc
Created: Tue Sep 23, 2014 06:09 PM UTC by mason_s
Last Updated: Mon Oct 06, 2014 07:03 AM UTC
Owner: mason_s

create database sandbox;
\c sandbox
create schema client;
reate table client.sales( storeid int not null, productid int not null,
revenue numeric not null) with(oids = false) distribute by hash(storeid);
insert some data into the table

with client_data as (select (100 * random())::int as storeid, (10000 *
random())::int as productid, round((random() * 100)::numeric,2) as revenue
from generate_series(1,100)) insert into client.sales select * from
client_data;
ERROR: unrecognized node type: 118

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/postgres-xl/tickets/30/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

--
Pavan Deolasee
http://www.linkedin.com/in/pavandeolasee

[Pavan Deolasee]

Opened again since the patch showed regression. Patch reverted for now.