LET statement does not work in a basic scenario

[Hung Tran]

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]

Hi Hung,

Can you post your schema? 

Bye, Giulia

[Hung Tran]

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]

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]

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