Sorry, I mean a sample dataset ;-) Ah, if you open an issue on our issue tracker it will be easier to track its resolution
Luigi 2015-09-15 8:11 GMT+02:00 Luigi Dell'Aquila <[email protected]>: > Hi, > > could you provide a sample result-set to reproduce the problem? > I guess it will not be hard to fix > > Thanks > > Luigi > > > 2015-09-14 16:34 GMT+02:00 bougyman <[email protected]>: > >> I am missing something in trying to construct a query with subqueries. >> Building in small iterations, I have a query which returns the proper >> result for 'Organizations a user is a member of, and Organizations that are >> members of that Organization' >> >> >> User -> Member Of -> Organization >> Organization -> Member Of -> Organization >> >> this query is: >> >> select from (traverse in(member_of) from (traverse out(member_of) from >> #51:24 while $depth <= 1)) where @class instanceof 'Organization' >> >> Now I want to add 'all things owned by the organizations in this set', so >> I try: >> >> select from (traverse out(owns) from (select from (traverse in(member_of) >> from (traverse out(member_of) from #51:24 while $depth <= 1)) where @class >> instanceof 'Organization') while $depth <= 1) >> >> This is where it falls apart. Adding the out(owns) traversal somehow >> expands the set of Organizations to include organizations not returned by >> the subquery. This is easily visible with the result set of the first query >> versus the second query (adding a where for @class instanceof Organization >> to the second) >> >> orientdb {db=Corganizations}> select from (traverse in(member_of) from >> (traverse out(member_of) from #51:24 while $depth <= 1)) where @class >> instanceof 'Organization' >> >> >> ----+-------+---------+----+----+-----+-----+------+------+-------+-------+-------+--------+--------+--------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+--------- >> # |@RID |@CLASS |lft |rgt |state|zip |city |rental|country|status >> |onshore|beast_id|category|oilfield|red_days|offshore|parent_id|show_data|short_key|address2 >> |out_owns |delete_fl|yellow_da|default_u|remote_na|show_asse|phone >> >> |show_devi|abbreviat|reference|in_member|contact_e|show_comm|asset_id_|show_disp|out_membe|contact_n|asset_typ|show_help|billing_s|map_base_|default_l|show_disp|asset_nam|show_flee|timezone >> |show_basi|show_shel|show_main|share_com|map_overl|show_qual|show_eng_|show_cust|auto_acce|rfid_time|allow_ass|show_filt|last_seen|allow_map|filter_pr|user_time|show_adva|enable_fi|show_unas|rental_da|allow_edi|last_seen|remote_ac|show_last|image >> >> >> |show_map_|asset_pro|created_a|logout_ur|share_ass|history_d|rental_sy|address1 >> |name >> |share_not|show_last|remote_ac|default_m|remote_ac|remote_ac|show_last|allow_mul|remote_ac|history_d|autocreat|integrati|descripti >> >> ----+-------+---------+----+----+-----+-----+------+------+-------+-------+-------+--------+--------+--------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+--------- >> 0 |#22:12 |Organi...|12 |25 |TX |75039|Irving|false |USA |enable >> |false |6 |2 |false |14 |false |1 |false | >> |Suite ...|[size=59]|0 |28 |/map | |true >> |972-76...|true |GF | |[size=8] | |false | >> |false |[size=1] | |1,2 |true |non bi...| >> |en |false | |false |Americ...|false |false |true >> |true | |false |false |false |false |4.0 >> |true |true |21 |false | |15 |false >> |true |true | |false |10 | |false >> |6_Geof...|true |--- [] >> |2008-0...|https:...|false |7 | |222 >> We...|Geofor...|false |false | |false | | >> |false |false | |1 |false |false |Ops po... >> 1 |#22:33 |Organi...|15 |16 | | | |null | >> |disable|null |43 |1 |false |14 |null |6 >> |false |null | |null |1 |28 |/map >> |null |true | |true |TEST ACC | |null | >> |false |null |null |[size=1] |Brando...|1,2 |true >> |non bi...|null |null |null |null |null >> |Americ...|false |false |false |false |null |false >> |false |false |true |4.0 |true |true |21 >> |null |null |0 |false |true |false |null >> |false |10 |null |false |null |false |--- [] >> >> |2008-1...|null |false |null |null | |test >> a...|false |null |null |false |null |null |false >> |false |null |null |null |null |test >> 2 |#22:100|Organi...|17 |18 | | | |null | >> |disable|null |117 |1 |false |14 |null |6 >> |false |null | |[size=4] |1 |28 |/map | >> |true | |true |GF-SAL | |null | >> |false | |null |[size=1] | |1,2 |true |non >> bi...|null |null |null | |null |Americ...|false >> |false |false |false |null |false |false |false >> |false |4.0 |true |true |21 |null | |10 >> |false |true |false |null |false |10 |null >> |false |null |false |--- [] >> >> |2009-0...| |false |null |null | >> |Geofor...|false |null |null |false |null |null >> |false |false |null |null |null |null | >> 3 |#22:137|Organi...|19 |20 | | | |false | |enable >> |false |166 |1 |false |14 |false |6 |false | >> | |[size=1] |0 |28 |/map | |true >> | |true |GFINV-NEW| |null | |false | >> |false |[size=1] | |1,2 |true |billing | >> |en |false | |false |Americ...|false |false >> |false |false |null |false |false |false |false |4.0 >> |true |true |21 |false | |0 |false >> |true |false | |false |10 | |false >> |null |false |--- [] >> |2009-0...| |false |7 | | >> |Geofor...|false |false | |false | | >> |false |false | |1 |false |false | >> 4 |#22:171|Organi...|21 |22 | | | |null | >> |disable|null |207 |1 |false |14 |null |6 >> |false |null | |[size=5] |0 |28 |/map | >> |true | |true |GF-XFER | |null | >> |false | |null |[size=1] | |1,2 |true >> |billing |null |null |null | |null >> |Americ...|false |false |false |false |null |false >> |false |false |false |4.0 |true |true |21 >> |null | |0 |false |true |false |null >> |false |10 |null |false |null |true |--- [] >> >> |2009-0...| |false |null |null | >> |Geofor...|false |null |null |false |null |null >> |false |false |null |null |null |null | >> 5 |#22:177|Organi...|23 |24 | | | |false | |enable >> |false |213 |1 |false |14 |false |6 |false | >> | |[size=...|0 |28 |/map | |true >> | |true |GF-TEST | |[size=2] | |true | >> |false |[size=1] | |1,2 |true |billing | >> |en |false | |false |Americ...|false |false |true >> |true |null |false |false |false |true |4.0 >> |true |true |21 |false | |0 |true >> |true |false | |true |10 | |true |null >> |true |--- [] >> |2009-0...| |true |7 | | >> |Geofor...|false |false | |false | | |true >> |false | |1 |false |false | >> >> ----+-------+---------+----+----+-----+-----+------+------+-------+-------+-------+--------+--------+--------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+--------- >> >> 6 item(s) found. Query executed in 0.029 sec(s). >> >> Versus >> >> orientdb {db=Corganizations}> select from (traverse out(owns) from >> (select from (traverse in(member_of) from (traverse out(member_of) from >> #51:24 while $depth <= 1)) where @class instanceof 'Organization') while >> $depth <= 1) where @class instanceof 'Organization' >> >> ----+-------+---------+----+----+-----+-----+------+------+-------+-------+-------+--------+--------+--------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+--------- >> >> # |@RID |@CLASS |lft |rgt |state|zip |city |rental|country|status >> |onshore|beast_id|category|oilfield|red_days|offshore|parent_id|show_data|short_key|address2 >> |out_owns |delete_fl|yellow_da|default_u|remote_na|show_asse|phone >> |show_devi|abbreviat|reference|in_member|fax >> >> |show_comm|asset_id_|show_disp|out_membe|contact_n|asset_typ|show_help|billing_s|map_base_|default_l|show_disp|asset_nam|show_flee|timezone >> |contact_e|show_basi|show_shel|show_main|share_com|map_overl|show_qual|show_eng_|show_cust|auto_acce|rfid_time|allow_ass|show_filt|last_seen|allow_map|filter_pr|user_time|show_adva|enable_fi|show_unas|rental_da|allow_edi|last_seen|remote_ac|show_last|image >> >> >> |show_map_|asset_pro|created_a|logout_ur|share_ass|history_d|rental_sy|updated_a|address1 >> |name >> |share_not|show_last|remote_ac|default_m|remote_ac|remote_ac|show_last|allow_mul|remote_ac|history_d|autocreat|integrati|descripti >> >> ----+-------+---------+----+----+-----+-----+------+------+-------+-------+-------+--------+--------+--------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+--------- >> >> 0 |#22:12 |Organi...|12 |25 |TX |75039|Irving|false |USA |enable >> |false |6 |2 |false |14 |false |1 |false | >> |Suite ...|[size=59]|0 |28 |/map | |true >> |972-76...|true |GF | |[size=8] |null |false | >> |false |[size=1] | |1,2 |true |non bi...| >> |en |false | |false |Americ...| |false >> |false |true |true | |false |false |false >> |false |4.0 |true |true |21 |false | |15 >> |false |true |true | |false |10 | >> |false |6_Geof...|true |--- [] >> |2008-0...|https:...|false |7 | |null |222 >> We...|Geofor...|false |false | |false | | >> |false |false | |1 |false |false |Ops po... >> 1 |#22:10 |Organi...|1 |6432|ca |12345|ns |false |us |enable >> |false |1 |2 |false |14 |false |0 |true | >> |canada |[size=1] |0 |28 |/map | |true >> |123-45...|true |SYSROOT | |[size=...|123-45...|false >> |null |false |null |Georg |1,2 |true |billing | >> |en |true |null |true |US/Cen...|ramsay...|false >> |false |false |false |null |false |false |true >> |false |4.0 |true |true |21 |false | |0 >> |false |true |false | |false |10 | >> |false |null |false |--- [] >> |2008-0...|https:...|false |7 | |2008-0...|ns >> |System...|false |false | |false | | >> |false |false | |1 |false |false |Root A... >> 2 |#22:33 |Organi...|15 |16 | | | |null | >> |disable|null |43 |1 |false |14 |null |6 >> |false |null | |null |1 |28 |/map >> |null |true | |true |TEST ACC | |null |null >> |false |null |null |[size=1] |Brando...|1,2 |true >> |non bi...|null |null |null |null |null |Americ...| >> |false |false |false |false |null |false |false >> |false |true |4.0 |true |true |21 |null >> |null |0 |false |true |false |null |false |10 >> |null |false |null |false |--- [] >> >> |2008-1...|null |false |null |null |null | >> |test a...|false |null |null |false |null |null >> |false |false |null |null |null |null |test >> 3 |#22:100|Organi...|17 |18 | | | |null | >> |disable|null |117 |1 |false |14 |null |6 >> |false |null | |[size=4] |1 |28 |/map | >> |true | |true |GF-SAL | |null |null >> |false | |null |[size=1] | |1,2 |true |non >> bi...|null |null |null | |null |Americ...| >> |false |false |false |false |null |false |false >> |false |false |4.0 |true |true |21 |null | >> |10 |false |true |false |null |false |10 >> |null |false |null |false |--- [] >> >> |2009-0...| |false |null |null |null | >> |Geofor...|false |null |null |false |null |null >> |false |false |null |null |null |null | >> 4 |#22:137|Organi...|19 |20 | | | |false | |enable >> |false |166 |1 |false |14 |false |6 |false | >> | |[size=1] |0 |28 |/map | |true >> | |true |GFINV-NEW| |null |null |false | >> |false |[size=1] | |1,2 |true |billing | >> |en |false | |false |Americ...| |false >> |false |false |false |null |false |false |false >> |false |4.0 |true |true |21 |false | |0 >> |false |true |false | |false |10 | >> |false |null |false |--- [] >> |2009-0...| |false |7 | |null | >> |Geofor...|false |false | |false | | >> |false |false | |1 |false |false | >> 5 |#22:171|Organi...|21 |22 | | | |null | >> |disable|null |207 |1 |false |14 |null |6 >> |false |null | |[size=5] |0 |28 |/map | >> |true | |true |GF-XFER | |null |null >> |false | |null |[size=1] | |1,2 |true >> |billing |null |null |null | |null |Americ...| >> |false |false |false |false |null |false |false >> |false |false |4.0 |true |true |21 |null | >> |0 |false |true |false |null |false |10 >> |null |false |null |true |--- [] >> >> |2009-0...| |false |null |null |null | >> |Geofor...|false |null |null |false |null |null >> |false |false |null |null |null |null | >> 6 |#22:177|Organi...|23 |24 | | | |false | |enable >> |false |213 |1 |false |14 |false |6 |false | >> | |[size=...|0 |28 |/map | |true >> | |true |GF-TEST | |[size=2] |null |true | >> |false |[size=1] | |1,2 |true |billing | >> |en |false | |false |Americ...| |false >> |false |true |true |null |false |false |false >> |true |4.0 |true |true |21 |false | |0 >> |true |true |false | |true |10 | >> |true |null |true |--- [] >> |2009-0...| |true |7 | |null | >> |Geofor...|false |false | |false | | |true >> |false | |1 |false |false | >> >> ----+-------+---------+----+----+-----+-----+------+------+-------+-------+-------+--------+--------+--------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+---------+--------- >> >> 7 item(s) found. Query executed in 0.022 sec(s). >> >> Note that #22:10, the Organization that doesn't belong in the second set, >> has an in(member_of) edge from #22:12 (which has an in(member_of) from >> #51:24, but that shouldn't expand from doing an out(owns) traversal on the >> set of 6 organizations returned by in inner subquery, unless I'm completely >> misunderstanding how subqueries work. An explanation of my failure would be >> greatly appreciated. >> >> bougyman >> >> >> -- >> >> --- >> 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. >> > > -- --- 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.
