Bugs item #2950579, was opened at 2010-02-12 13:55 Message generated for change (Comment added) made by nielsnes You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2950579&group_id=56967
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: SQL/Core Group: SQL "stable" Status: Open >Resolution: Fixed Priority: 5 Private: No Submitted By: Roberto Cornacchia (cornuz) Assigned to: Niels Nes (nielsnes) Summary: SQL:OFFSET is limited to 32bit Initial Comment: In a SELECT .... OFFSET <N>; statement, N is limited to a 32bit positive integer (2147483647), regardless of whether the system is compiled 64bit or not. Moreover, there seem to be a problem with the last allowed value (2147483647): SELECT ... OFFSET 2147483647; -- never finishes SELECT ... OFFSET 2147483646; -- returns instantly ---------------------------------------------------------------------- >Comment By: Niels Nes (nielsnes) Date: 2010-04-25 15:21 Message: a fix for this problem exists in the head branch. ---------------------------------------------------------------------- Comment By: Niels Nes (nielsnes) Date: 2010-02-25 09:02 Message: added test to BugTracker-2010 offset_limited_32bit ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2950579&group_id=56967 ------------------------------------------------------------------------------ _______________________________________________ Monetdb-bugs mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
