Bug 1105473 - MongoDB: Offset clause causes MongoDB to crash
Summary: MongoDB: Offset clause causes MongoDB to crash
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.0.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ER1
: 6.1.0
Assignee: Van Halbert
QA Contact:
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-06-06 08:50 UTC by Filip Elias
Modified: 2016-02-10 08:55 UTC (History)
3 users (show)

Fixed In Version:
Clone Of:
Environment:
DV6 + rollup MongoDB < 2.5.2
Last Closed: 2016-02-10 08:55:40 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-2992 0 Major Closed MongoDB: Offset clause causes MongoDB to crash 2015-08-05 05:53:20 UTC

Description Filip Elias 2014-06-06 08:50:14 UTC
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: 
SELECT INTKEY FROM bqt1.smalla ORDER BY INTKEY OFFSET 45 ROWS

Generated mongo command:
{ aggregate: "smalla", pipeline: [ { $project: { c_0: "$INTKEY" } }, { $sort: { c_0: 1 } }, { $skip: 45 }, { $limit: 2147483647 } ] }

[1] https://jira.mongodb.org/browse/SERVER-10136

Comment 1 JBoss JIRA Server 2014-06-06 14:30:16 UTC
Ramesh Reddy <rareddy> updated the status of jira TEIID-2992 to Resolved

Comment 2 JBoss JIRA Server 2015-04-07 13:35:10 UTC
Steven Hawkins <shawkins> updated the status of jira TEIID-2992 to Closed


Note You need to log in before you can comment on or make changes to this bug.