[pgpool-general: 5619] unable to parse statements with connect by prior

[Madhusudan, Dhanya]

Hi Team,

We are using postgres 9.5 and pgpool 3.4.3.
We get the below messages in the pgpool logs:
2017-07-10 08:04:26: pid 29429: LOG: Unable to parse the query: "select id from DEVICE_PROFILE_XML where id in (select distinct dpid from deviceProfile_group_map where groupid in (SELECT GROUP_ID FROM GROUPS START WITH GROUP_ID=$1 CONNECT BY PRIOR GROUP_ID = PARENT_GROUP_ID))" from client 30.208.213.28(41637)
2017-07-10 08:04:27: pid 7933: LOG: Unable to parse the query: "select id from DEVICE_PROFILE_XML where id in (select distinct dpid from deviceProfile_group_map where groupid in (SELECT GROUP_ID FROM GROUPS START WITH GROUP_ID=$1 CONNECT BY PRIOR GROUP_ID = PARENT_GROUP_ID))" from client 30.208.213.28(41629)
2017-07-10 08:04:28: pid 27836: LOG: Unable to parse the query: "select id from DEVICE_PROFILE_XML where id in (select distinct dpid from deviceProfile_group_map where groupid in (SELECT GROUP_ID FROM GROUPS START WITH GROUP_ID=$1 CONNECT BY PRIOR GROUP_ID = PARENT_GROUP_ID))" from client 30.208.213.28(41664)
2017-07-10 08:04:28: pid 29429: LOG: Unable to parse the query: "select id from DEVICE_PROFILE_XML where id in (select distinct dpid from deviceProfile_group_map where groupid in (SELECT GROUP_ID FROM GROUPS START WITH GROUP_ID=$1 CONNECT BY PRIOR GROUP_ID = PARENT_GROUP_ID))" from client 30.208.213.28(41637)
2017-07-10 08:04:34: pid 29429: LOG: Unable to parse the query: "select id from DEVICE_PROFILE_XML where id in (select distinct dpid from deviceProfile_group_map where groupid in (SELECT GROUP_ID FROM GROUPS START WITH GROUP_ID=$1 CONNECT BY PRIOR GROUP_ID = PARENT_GROUP_ID))" from client 30.208.213.28(41637)
2017-07-10 08:04:35: pid 27836: LOG: Unable to parse the query: "select id from DEVICE_PROFILE_XML where id in (select distinct dpid from deviceProfile_group_map where groupid in (SELECT GROUP_ID FROM GROUPS START WITH GROUP_ID=$1 CONNECT BY PRIOR GROUP_ID = PARENT_GROUP_ID))" from client 30.208.213.28(41664)
2017-07-10 08:04:35: pid 29429: LOG: Unable to parse the query: "select id from DEVICE_PROFILE_XML where id in (select distinct dpid from deviceProfile_group_map where groupid in (SELECT GROUP_ID FROM GROUPS START WITH GROUP_ID=$1 CONNECT BY PRIOR GROUP_ID = PARENT_GROUP_ID))" from client 30.208.213.28(41637)
2017-07-10 08:04:39: pid 29429: LOG: Unable to parse the query: "select id from DEVICE_PROFILE_XML where id in (select distinct dpid from deviceProfile_group_map where groupid in (SELECT GROUP_ID FROM GROUPS START WITH GROUP_ID=$1 CONNECT BY PRIOR GROUP_ID = PARENT_GROUP_ID))" from client 30.208.213.28(41637)
2017-07-10 08:04:41: pid 29429: LOG: Unable to parse the query: "select id from DEVICE_PROFILE_XML where id in (select distinct dpid from deviceProfile_group_map where groupid in (SELECT GROUP_ID FROM GROUPS START WITH GROUP_ID=$1 CONNECT BY PRIOR GROUP_ID = PARENT_GROUP_ID))" from client 30.208.213.28(41637)

Question: It is not being logged as an error, does this mean it gets executed successfully in the DB, or is it being ignored by pgpool?

Regards,
Dhanya
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170712/e70a87fa/attachment.html>