LET statement does not work in a basic scenario

69 views
Skip to first unread message

Hung Tran

unread,
Jun 17, 2015, 4:26:34 PM6/17/15
to orient-...@googlegroups.com
Hi,

I am using OrientDB v1.7.


The 1st SQL with LET returns 3 rows, but it only returns 1 row without LET that is the correct response.



Another photo,




Any idea will be very appreciated!

Thanks,
Hung Tran

Giulia Brignoli

unread,
Jun 18, 2015, 3:13:25 AM6/18/15
to orient-...@googlegroups.com
Hi Hung,

Can you post your schema? 

Bye, Giulia

Hung Tran

unread,
Jun 18, 2015, 11:22:50 AM6/18/15
to orient-...@googlegroups.com
Hi Giulia Brignoli,

I don't know how to extract the schema only, but the schema is very simple.

There is a Plan class with EntityInfo property, the property type is a EntityInfo class configured as an embedded type.

{"name":"EntityInfo","type":"EMBEDDED","linked-class":"EntityInfo","collate":"default"}

Thanks,
Hung Tran

Luigi Dell'Aquila

unread,
Jun 19, 2015, 1:20:45 AM6/19/15
to orient-...@googlegroups.com
Hi,

Do you have any constraints in using 1.7? I'd suggest to update to 2.0.10 and try it there

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

unread,
Jun 19, 2015, 2:43:13 AM6/19/15
to orient-...@googlegroups.com
Hi Luigi,

I have tried to upgrade to v2.0 on Jan 22, however I have failed due to some breaking changes. I will surely do that soon when I have time, but now I have to stay at v1.7.

In fact, LET statement is working well in many scenarios, but I don't know what stop it working on this scenario that makes me a serious worry on other scenarios.

Any help will be very appreciated!

Thanks,
Hung Tran
Reply all
Reply to author
Forward
0 new messages