Found a non-elegant workout by adding a "where true" traverse out() from (select rid from (select from index:idx where key = 'term' ) where true limit 9)/Does work
On Tue, Mar 4, 2014 at 11:45 PM, Shishya <[email protected]> wrote: > Error is followin in studio > > com.orientechnologies.orient.core.exception.OQueryParsingException: Error > on parsing query Query: key = 'term ------^ --> > java.lang.IllegalStateException: Missing closed string character: ''', > position: 12 > > > On Tuesday, March 4, 2014 11:41:09 PM UTC+5:30, Shishya wrote: >> >> Though If I put a limit on an outer select it works but traverse on outer >> select doesnt work >> >> select rid from (select from index:idx where key = 'term' ) limit 9 >> //works >> >> traverse out() from (select rid from (select from index:idx where key = >> 'term' ) limit 9)/Doesnt work >> >> >> >> >> On Tuesday, March 4, 2014 11:30:35 PM UTC+5:30, Shishya wrote: >>> >>> hi, >>> >>> I am not sure if this has been answered before bt cant find in archive. >>> How to use select limit for indexes. following query returns all, while i >>> expect 9 >>> >>> select from index:idx where key = 'term' limit 9 >>> >>> regards >>> >>> -- > > --- > You received this message because you are subscribed to a topic in the > Google Groups "OrientDB" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/orient-database/zO-VdyXPtnc/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > -- --- 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/groups/opt_out.
