Can you please share the versions you are using?
Am 01.05.2014 um 11:03 schrieb Yu Gene Loh <[email protected]>: > Some queries are returning intermittent InvalidSyntax (Unknown identifier) > errors, even though they work most of the time and return correct results > without any errors. > > Can anyone shed some light? Thanks! > > > gene. > > > > The query... > > MATCH (d:Workgroup), (b:Activity), > (d)<-[:ACTIVITY_OF]-(b)<-[r:ASSET_INPUT_OF|ASSET_OUTPUT_OF]-(a:Asset)<-[:ASSET_TYPE_OF]-(aa:AssetType) > > WHERE aa.name IN ['Document'] > > OPTIONAL MATCH (:Activity)<-[subs:SUBSCRIBED_BY]-(a) > > OPTIONAL MATCH (a)-[sel:SELECTED_BY]->(:Person {username: 'testuser'}) > > OPTIONAL MATCH (a)-[:BELONGS_TO]->(dd:Workgroup) > > RETURN ID(b), ID(a), a.name, > > CASE TYPE(r) > > WHEN 'ASSET_INPUT_OF' THEN 'Input' > > WHEN 'ASSET_OUTPUT_OF' THEN 'Output' > > END AS inputoutput, > > a.category, a.owner, a.location, aa.name, COUNT(subs), COUNT(sel), d.code + ' > ' + ID(b) + '/A' + ID(a) as asset_code, COLLECT(dd.code) + a.owner AS owner > ORDER BY ID(a); > > > sometimes returns the following error... > > > > Unknown identifier `d`. > Unknown identifier ` UNNAMED8428111205143288671`. > Unknown identifier ` UNNAMED-1827321063839507775`. > Unknown identifier ` INTERNAL_AGGREGATE478402e2-0455-48f0-a95f-29c36c56a8d6`. > Unknown identifier ` INTERNAL_AGGREGATE71e3c595-93c6-4a57-a4b3-3a02b2143747`. > Unknown identifier ` UNNAMED7958746158675052802`. > Unknown identifier ` UNNAMED2430603467466026493`. > Unknown identifier ` UNNAMED6198074590133770465`. > Unknown identifier ` UNNAMED-2526645446754961735`. > Unknown identifier ` UNNAMED-6102135876980975330`. > Unknown identifier ` UNNAMED-8703169606424011663`. > Unknown identifier ` INTERNAL_AGGREGATE69db5735-293e-4bf1-adce-dd084c69c741`. > > Neo.ClientError.Statement.InvalidSyntax > > > > -- > You received this message because you are subscribed to the Google Groups > "Neo4j" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Neo4j" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
