Cypher: Querying by @rid might be impossible

[tetious]

ArcadeDB Version: 21.10.2-SNAPSHOT (build ae608bf/1633588344745/main)

OS: docker

Expected behavior

One of these queries should return results:

1. MATCH (m:Movie{@rid:'#1:0'})<-[a:ACTED_IN]-(p:Person) RETURN *
2. MATCH (m:#1:0})<-[a:ACTED_IN]-(p:Person) RETURN * (not sure this will/should ever work, adapted from the SQL example)
3. MATCH (m:Movie)<-[a:ACTED_IN]-(p:Person) WHERE m.@rid = '#1:0' RETURN *

Actual behavior

1. org.opencypher.v9_0.util.SyntaxException: Invalid input '@' expected whitespace, a property key name, '}', an identifier or UnsignedDecimalInteger (line 1, column 16 (offset: 15))
2. org.opencypher.v9_0.util.SyntaxException: Invalid input '#': expected whitespace or a label name
3. Invalid input '@'

I tried several other less obvious variations (leaving off the @, using #1:0 without quotes, etc.) without success.
It's possible I just missed the correct way to do this in the docs or something. 😄

[tetious]

I figured it out! 🎆 MATCH (m:Movie)<-[a:ACTED_IN]-(p:Person) WHERE id(m) = '#1:0' RETURN works as expected.

Sorry for the noise! 😄

[lvca]

@tetious I think that query should be in the documentation because it's a common use case. I'm going to update it. thanks.

[lvca]

Ok, updated under Cypher chapter.