Bug #38892 SELECT with LIMIT formatted incorrectly
Submitted: 19 Aug 2008 14:16 Modified: 1 Dec 2009 14:47
Reporter: Kay Roepke Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Web Severity:S3 (Non-critical)
Version:2.0 OS:Any
Assigned to: Kay Roepke CPU Architecture:Any
Tags: formatter, sqlparser

[19 Aug 2008 14:16] Kay Roepke 
Description:
below select is missing LIMIT in formatted version.

How to repeat:
SELECT DISTINCT meetings . id , meetings . status , meetings . name , meetings . duration_hours , meetings . duration_minutes , meetings . date_start , meetings . assigned_user_id FROM meetings INNER JOIN meetings_users ON meetings . id = meetings_users . meeting_id WHERE ( ( meetings . status IN ( ? ) ) ) AND meetings . deleted = ? AND meetings_users . deleted = ? AND ( meetings . assigned_user_id = ? OR meetings_users . user_id = ? ) LIMIT ? , ?

Suggested fix:
.
[17 Sep 2009 16:57] Enterprise Tools JIRA Robot 
Kay Roepke writes: 
the limit highlighter did not allow value placeholders ('?') but was requiring numbers.
since we allow parsing of "normalized" queries, this was wrong (even though it was correct when strictly looking at SQL).
[17 Sep 2009 16:57] Enterprise Tools JIRA Robot 
Kay Roepke writes: 
trivial test case is:
SELECT 1 from dual LIMIT ? , ?
[23 Nov 2009 22:03] Enterprise Tools JIRA Robot 
Andy Bang writes: 
This is in build 2.2.0.1547.
[24 Nov 2009 19:22] Enterprise Tools JIRA Robot 
Diego Medina writes: 
Verified fixed on 2.2.0.1547
[1 Dec 2009 14:47] MC Brown 
A note has been added to the 2.2.0 changelog.