A query gets a parsing error with LIMIT statement

[Hung Tran]

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

[user.w...@gmail.com]

Hi Hung,

Try this:

SELECT first(eval('$TotalListsQuery[0].Count')) AS TotalLists

LET $TotalListsQuery = (SELECT Count(1) AS Count FROM ContactList WHERE Account=#20:1 AND EntityInfo.State=0)

Regards,

Michela

[Luigi Dell'Aquila]

It seems to be a bug, 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/5589

My Best,

Hung Tran