Re: [orientdb] Re: A query gets a parsing error with LIMIT statement

[Hung Tran]

Hi Luigi,

An issue is created

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

My Best,
Hung Tran

On Tuesday, January 12, 2016 at 4:08:34 PM UTC+7, Luigi Dell'Aquila wrote:
>
> It seems to be a bug, could you please open an issue about this?
>
> Thanks
>
> Luigi
>
>
> 2016-01-12 10:06 GMT+01:00 :
>
>> 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
>>
>>
>> -- 
>>
>> --- 
>> 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.
>>
>
>

-- 

--- 
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.

Re: [orientdb] Re: A query gets a parsing error with LIMIT statement

[Luigi Dell'Aquila]

It seems to be a bug, could you please open an issue about this?

Thanks

Luigi


2016-01-12 10:06 GMT+01:00 :

> 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
>
>
> --
>
> ---
> 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.
>

-- 

--- 
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.