This might be an issue with v1.7.9? See below. You can test this on a blank 
DB.

*USING VERSION 1.7.8 (STABLE):*
orientdb {tempdel002}> select expand( $c ) LET $a = (select from #5:2), $b 
= (select from #5:2), $c = UNIONALL($a,$b)

----+----+------+-------------------------------------------------------------------------+------+-----
#   |@RID|name  |password                                                   
              |status|roles
----+----+------+-------------------------------------------------------------------------+------+-----
0   
|#5:2|writer|{SHA-256}B93006774CBDD4B299389A03AC3D88C3A76B460D538795BC12718011A909FBA5|ACTIVE|[1]
 
 
1   
|#5:2|writer|{SHA-256}B93006774CBDD4B299389A03AC3D88C3A76B460D538795BC12718011A909FBA5|ACTIVE|[1]
 
 
----+----+------+-------------------------------------------------------------------------+------+-----

2 item(s) found. Query executed in 0.003 sec(s).


*USING FRESH, BLANK DB ON VERSION 1.7.9-SNAPSHOT*
orientdb {tempdel02}> select from OUser                                     
                                         

----+----+------+-------------------------------------------------------------------------+------+-----
#   |@RID|name  |password                                                   
              |status|roles
----+----+------+-------------------------------------------------------------------------+------+-----
0   |#5:0|admin 
|{SHA-256}8C6976E5B5410415BDE908BD4DEE15DFB167A9C873FC4BB8A81F6F2AB448A918|ACTIVE|[1]
 
 
1   
|#5:1|reader|{SHA-256}3D0941964AA3EBDCB00CCEF58B1BB399F9F898465E9886D5AEC7F31090A0FB30|ACTIVE|[1]
 
 
2   
|#5:2|writer|{SHA-256}B93006774CBDD4B299389A03AC3D88C3A76B460D538795BC12718011A909FBA5|ACTIVE|[1]
 
 
----+----+------+-------------------------------------------------------------------------+------+-----

3 item(s) found. Query executed in 0.006 sec(s).
orientdb {tempdel02}> select expand( $c ) LET $a = (select from #5:2), $b = 
(select from #5:2), $c = UNIONALL($a,$b)


0 item(s) found. Query executed in 0.001 sec(s).
orientdb {tempdel02}> 

-- 

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

Reply via email to