A Sub-query in FROM clause does not work any more

43 views
Skip to first unread message

Hung Tran

unread,
Jan 8, 2016, 11:52:40 AM1/8/16
to OrientDB
Hi,

I am migrating from version 1.7.8 to version 2.1.8, I get an error with such query in version 2.1.8

SELECT referredBy.size() FROM (FIND REFERENCES #15:4)

the error is

com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #0: Error parsing query: SELECT referredBy.size() FROM (FIND REFERENCES #15:4) Encountered " <FROM> "FROM "" at line 1, column 26.
 Was expecting one of:
 <EOF> 
 <TIMEOUT> ...
 <AS> ...
 <FETCHPLAN> ...
 <LOCK> ...
 <LET> ...
 <NOCACHE> ...
 <PARALLEL> ...
 <UNWIND> ...
 ";" ...
 "," ...
 <AS> ...
 "," ...

Remarks, the query is only working if strictSQL is unset. What's the correct syntax in this case when strictSQL is set?

My Best,
Hung Tran

Luigi Dell'Aquila

unread,
Jan 8, 2016, 12:02:47 PM1/8/16
to orient-...@googlegroups.com
Hi,

Yes, this happens because FIND REFERENCES is not implemented yet in the new parser. 
The fix is not complex, could you please open an issue about this?

Thanks

Luigi


--

---
You received this message because you are subscribed to the Google Groups "OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Hung Tran

unread,
Jan 8, 2016, 1:01:05 PM1/8/16
to OrientDB
Hi Luigi,

An issue is created.


My Best,
Hung Tran
Reply all
Reply to author
Forward
0 new messages