Hello,
I seem to run into a wall while trying to figure the LET statement which is
just failing on me, Here are 2 classes where one has link to another. I
need to use the LET statement to get the linked class by provided id, but
the result never returns any records. Sub query does return the result
correctly, but not the query with the LET statement.
My classes:
create class A extends V
create property A.id INTEGER (NOTNULL TRUE, MANDATORY TRUE)
create class B extends V
create property B.a LINK A (NOTNULL TRUE, MANDATORY TRUE)
insert into A (id) values (1)
insert into B set a = (select from A where id = 1)
select from B let $aa = (select from A where id = 1) where a = $aa
select from B let $aa = (select from A where id = 1) where a = $aa.@rid
Here is the data
orientdb {db=Customers}> select from A
+----+------+------+----+
|# |@RID |@CLASS|id |
+----+------+------+----+
|0 |#185:0|A |1 |
+----+------+------+----+
1 item(s) found. Query executed in 0.002 sec(s).
orientdb {db=Customers}> insert into B set a = (select from A where id = 1)
Inserted record 'B#189:0{a:#185:0} v1' in 0.004000 sec(s).
orientdb {db=Customers}> select from B
+----+------+------+------+
|# |@RID |@CLASS|a |
+----+------+------+------+
|0 |#189:0|B |#185:0|
+----+------+------+------+
As you can see from above, class B has a link to class A. In my
understanding the query below must work, but it returns nothing. I tried 2
combinations of the query and both don't work.
orientdb {db=Customers}> select from B let $aa = (select from A where id =
1) where a = $aa
0 item(s) found. Query executed in 0.003 sec(s).
orientdb {db=Customers}> select from B let $aa = (select from A where id =
1) where a = $aa.@rid
0 item(s) found. Query executed in 0.003 sec(s).
Am I doing something wrong or is it a bug?
--
---
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
