PostgreSQL with recursive fail with union in the final query

[ohadpinch]

with recursive CHILDREN(UUID, PARENT_UUID) as
(
	(select GROUPING.GROUP_NODE.UUID, 
	 GROUPING.GROUP_NODE.PARENT_UUID
	 
	 from GROUPING.GROUP_NODE where GROUPING.GROUP_NODE.UUID = '1')

 union 
	(select op.UUID, op.PARENT_UUID
	 	 from GROUPING.GROUP_NODE as op join CHILDREN as c on op.PARENT_UUID = c.uuid)
)
(select * from CHILDREN )
union 
(select mn.UUID, mn.PARENT_UUID
 from GROUPING.MEMBER_NODE as mn, CHILDREN as c2 
 where (mn.parent_uuid = c2.uuid))

If we remove the parentheses ( ) from the "(select * from CHILDREN )" line it will WORK!

[grandinj]

Can we get a full standalone test case i.e. what are the table definitions

[ohadpinch]

CREATE TABLE grouping.group_node (
uuid VARCHAR(255) NOT NULL,
name VARCHAR(255) NOT NULL,
parent_uuid VARCHAR(255),
PRIMARY KEY(uuid)
);

CREATE TABLE grouping.member_node (
uuid VARCHAR(255) NOT NULL,
parent_uuid VARCHAR(255),
PRIMARY KEY(uuid)
);

CREATE UNIQUE INDEX idx_group_node_uuid ON grouping.group_node (uuid);
CREATE INDEX idx_group_node_parent_uuid ON grouping.group_node (parent_uuid);

[katzyn]

It looks like a duplicate of #918.

[ohadpinch]

Ok,
I am not sure, but I can check when it will be resolved.