Hi, Trying to understand the unexpected behavior with following query -
select mid, path, sz, created FROM (select * from Media ORDER BY created DESC LIMIT 20 SKIP 1) Scenario: I’ve 5 records in the db. This query ‘select * from Media ORDER BY created DESC LIMIT 20 SKIP 1’ skips first record and returns 4 records, which I intend to do. But when I combine it like this ‘select mid, path, created FROM (select * from Media ORDER BY created DESC LIMIT 20 SKIP 1)’ it doesn’t skip the records. I would expect it to get details for only filtered results (4 records) but returns details for 5. Is it a bug or something wrong with the query. The above query is simple version of the complex query. Please can someone comment on it? OS - Mac Orientdb - 2.2.6 ~Ruitu -- --- 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.
