Limit on Index select not working, 1.7rc2s

[Shishya]

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

[Shishya]

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

[Shishya]

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

[Luca Garulli]

Hi,

this problem has been reported by Luigi today. Luigi, is it the same right?

Lvc@

--

---
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 orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[prabhat]

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

--

---
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 orient-databa...@googlegroups.com.

[Andrey Lomakin]

Hi guys,

Could you create bug on this problem.

--

---

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 orient-databa...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

Best regards,
Andrey Lomakin.

Orient Technologies
the Company behind OrientDB

[Shishya]

https://github.com/orientechnologies/orientdb/issues/2093

[Andrey Lomakin]

Hi,

I would really appreciate if you provide sample database for this issue.

среда, 5 марта 2014 г., 16:58:02 UTC+2 пользователь Shishya написал: