Post your full complex query. Il giorno domenica 25 settembre 2016 17:25:32 UTC+2, Ruituraj Gandhi (Knowledge Explosion) ha scritto: > > 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.
