Hi, I am migrating from version 1.7.8 to version 2.1.8, the SQL below does not working any more
SELECT eval('$TotalListsQuery[0].Count') AS TotalLists LET $TotalListsQuery = ( SELECT Count(1) AS Count FROM ContactList WHERE Account=#20:1 AND EntityInfo.State=0) LIMIT 1 It is working if remove "LIMIT 1" My Best, Hung Tran -- --- 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-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.