A query in binary protocol returns empty array while studio is not

[Hung Tran]

Hi,

I am using OrientDB version 2.1.8, just wonder if it's a bug in binary protocol or not.

My query is, 

 

  SELECT Status, $v1 FROM CampaignMailTask

     LET $v1 = (SELECT FROM CampaignMailTask WHERE Status = $parent.$current.Status AND Campaign = #47:3 LIMIT 5)
   WHERE Status in [255,30] AND Campaign = #47:3

GROUP BY Status

In Studio,

In Java code, $v1 is an empty array.

Any idea is very appreciated!

My Best,

Hung Tran

[Luigi Dell'Aquila]

Hi Hung,

It's quite strange, can you post a sample dataset to reproduce che problem?

Thanks

Luigi

2016-02-05 6:23 GMT+01:00 Hung Tran <tdhu...@gmail.com>:

Hi,

I am using OrientDB version 2.1.8, just wonder if it's a bug in binary protocol or not.

My query is, 

 

SELECT Status, $v1
    FROM CampaignMailTask

       LET $v1 = (SELECT FROM CampaignMailTask WHERE Status = $parent.$current.Status AND Campaign = #47:3 AND StatsUpdated = false LIMIT 5)
 WHERE Status in [255,30] AND StatsUpdated = false AND Campaign = #47:3 GROUP BY Status

In Studio,

In Java code, $v1 is an empty array.

Any idea is very appreciated!

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-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Hung Tran]

Hi Luigi,

I have enclosed the database file in attachment. Thank you for your concern.

This is not urgent, I did a workaround by fetching them and do grouping in Java code. It's strange this solution is faster than grouping by SQL.

My Best,

Hung Tran