I'm not entirely certain what your expected input/output is. Notice in the tutorial the "expand" function was used. http://orientdb.com/docs/last/SQL-Functions.html#expand
so select expand(in()) from Restaurant where name = 'Dante' instead of select in() from Restaurant where name = 'Dante' orientdb> select in() from Restaurant where name = 'Dante' +-------+----------------+ | @RID | in | +-------+----------------+ | #-2:1 | [#11:0, #11:1] | +-------+----------------+ the [2] in your screenshots is a shorted version of the [#11:0, #11:1] above. so try: orientdb> select expand( in() ) from Restaurant where name = 'Dante' +-------+-------------+-------------+---------+ | @RID | @CLASS | Name | out_Eat | +-------+-------------+-------------+---------+ | #11:0 | Person | Luca | #12:0 | | #11:1 | Person | Bill | #12:0 | +-------+-------------+-------------+---------+ hope that is helpful! On Wednesday, April 15, 2015 at 3:12:19 AM UTC-7, KY wrote: > > Hi, > > Here all the details. > - installed orientdb-2.0.6 on my windows 7-64bit > - followed the tutorial: > http://orientdb.com/docs/last/Tutorial-Using-schema-with-graphs.html > and created a new db: create database > plocal:../databases/WorkingWithGraphs admin admin plocal > - connected to the new db: connect plocal:../databases/WorkingWithGraphs > admin admin > > - created Person, Restaurant and Eat classes: > create class Person extends V > create class Restaurant extends V > create class Eat extends E > > - populated the db as described (create vertex, create edge) > > - executed two queries: > select from Restaurant => select-restaurant-in_Eat screenshot > select in() from Restaurant where name = 'Dante' => select-in-restaurant > screenshot > > Thanks! > > On Wednesday, April 15, 2015 at 10:30:17 AM UTC+2, [email protected] > wrote: >> >> Hi, >> >> I've created the schema with Restaurant/Person/Eat and populated the base >> as described in the tutorial with release 2.0.6. >> >> I don't see any columns in Restaurant or Person called in_Eat or out_Eat. >> >> *select in() from Restaurant where name = 'Dante'* returns a list of >> Person as expected. >> >> Where do you see @class = null and what is this in/out = 0/1 ? >> >> Regards. >> > -- --- 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.
