using 1.7rc2 SNAPSHOT from 10 March, 2014 Either I am doing it wrong or FetchPlans seem to be ignored running embedded and plocal. If I disable all caching, I get only the local record, I use default caching, I get back the entire connected object tree
Tested using the schema and data from the Fetch Plan wiki page https://github.com/orientechnologies/orientdb/wiki/Fetching-Strategies with caching disabled, I always get this for fetch plans: *:-2 *:0 *:1 *:-1 and no fetch plan *Invoice#11:0{out_customers:#12:0,out_addresses:#13:0,out_orders:[size=3]} v7* with default caching I get for all records regardless of fetch plan: * Invoice#11:0{out_customers:#12:0,out_addresses:#13:0,out_orders:[LineItem#16:0{count:5,in_orders:#11:0,out_order_item:#17:0} v4, LineItem#16:1{count:3,in_orders:#11:0,out_order_item:#17:1} v4, LineItem#16:2{count:4,in_orders:#11:0,out_order_item:#17:2} v4]} v7* Also, using the debugger, with caching enabled, I can browse the entire object graph from the Invoice document -- which I would expect only for fetch plan *:-1. When I have caching disabled, all I can see are the RIDs of linked documents, which I would only expect for fetch plan *:0 or *:-2 this is my code 'select from Invoice' *static List<ODocument> query(OrientGraph pGraph, final String pSql, final String pFetchPlan) { final OQueryAbstract zQuery = new OSQLSynchQuery(pSql).setFetchPlan(pFetchPlan); return pGraph.getRawGraph().query(zQuery);}* This leaves me confuse about what the fetch plan does. I don't want my queries returning the whole graph. What am I doing wrong? -- --- 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.
