when use "select count(*) from foregin_table_name" will cause "CypherSyntaxError"

[222momo]

when use "select count(*) from foregin_table_name" will cause "CypherSyntaxError"

• Postgres version: 10.9
• Neo4j version : 3.5
• Steps to reproduce
• 1.create a foreign table of neo4j in pg, e.g.
• CREATE FOREIGN TABLE neo2.dwf_node_location( state character varying NULL COLLATE pg_catalog."default", city character varying NULL COLLATE pg_catalog."default" ) SERVER neo2 OPTIONS (cypher 'MATCH (n:Location) RETURN n.state AS state,n.city AS city');
• 2.excute sql
• select count(*) from dwf_node_location
• Expected behavior
• result is 4
• Actual behavior
• but it causes "CypherSyntaxError" .The debug info is as follows.
  

Reason

I found these codes cause the bug
the file is neo4jPg/neo4jfdw.py
in line 169
if(needUpdateProjection and len(columns) < len(self.columns)):
I rewrite the code.
if(needUpdateProjection and len(columns) > 0 and len(columns) < len(self.columns)):
The CypherSyntaxError disappeared.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[sim51]

Thanks stale bot, I forgot this issue :D
Sorry for the lag momo.

[sim51]

A new unit test has been added for this use-case (ie. a count(*) without a here clause).

The fix is part of the release 4.3.2