[teiid-issues] [JBoss JIRA] (TEIID-2992) MongoDB: Offset clause causes MongoDB to crash

[RH Bugzilla Integration (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2992?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12978599#comment-12978599 ] 

RH Bugzilla Integration commented on TEIID-2992:
------------------------------------------------

Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1105473|https://bugzilla.redhat.com/show_bug.cgi?id=1105473] from NEW to MODIFIED

> MongoDB: Offset clause causes MongoDB to crash
> ----------------------------------------------
>
>                 Key: TEIID-2992
>                 URL: https://issues.jboss.org/browse/TEIID-2992
>             Project: Teiid
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Misc. Connectors
>    Affects Versions: 8.4.1
>         Environment: MongoDB < 2.5.2
>            Reporter: Filip Elias
>            Assignee: Ramesh Reddy
>              Labels: Beta1
>             Fix For: 8.7.1, 8.8
>
>
> MongoDB(version < 2.5.2) will crash when offset clause is used in SQL query.
> Althought the bug[1] is in MongoDB (Adding big number into $limit causes Mongodb to shutdown), it is also caused by teiid because it adds max integer into $limit which seems to be unnecessary. 
> Sample query: 
> {code}
> SELECT INTKEY FROM bqt1.smalla ORDER BY INTKEY OFFSET 45 ROWS
> {code}
> Generated mongo command:
> {code}
> { aggregate: "smalla", pipeline: [ { $project: { c_0: "$INTKEY" } }, { $sort: { c_0: 1 } }, { $skip: 45 }, { $limit: 2147483647 } ] }
> {code}
> [1] https://jira.mongodb.org/browse/SERVER-10136



--
This message was sent by Atlassian JIRA
(v6.2.6#6264)