[CLOUDSTACK-1948] users can no longer set global limits to -1 (e.g. pagesize)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.1.0, 4.2.0
• Fix Version/s: 4.2.0
• Component/s: Management Server
• Security Level: Public (Anyone can view this level - this is the default.)
• Assignee: Alena Prokharchyk
• Reporter: Marcus Sorensen
• Created: 05/Apr/13 00:42
• Updated: 25/Jul/13 05:29
• Resolved: 15/Jul/13 18:52

Description

Just installed 4.1 over a 4.0 install, and ran into an issue where the max pagesize global parameter was set to -1, which worked to effectively disable paging in 4.0, but 4.1 passes the -1 right on to the SQL query, which mysql hates.

management server log shows "LIMIT 0, -1" in mysql statements. I'm assuming that a non-positive integer used to just remove the limit clause, since it worked in 4.0