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

[Hung Tran]

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]

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]

Hi Luigi,

An issue is created.

https://github.com/orientechnologies/orientdb/issues/5573

My Best,

Hung Tran