plainblack.com
Username Password
search
Bookmark and Share
View All Tickets
SQL queriy is improper for MySQL compliant query  (#10746)
Issue

WebGUI::DatabaseLink disallows SQL statements beginning with an open parenthesis.  By preventing this through keyword detection, the following command structure is not handled by WebGUI.  MySQL has no problem with it when entered directly:

(SELECT <unique criteria>) UNION (SELECT <unique criteria) ORDER BY myField;

This directly affects SQL Report query construction.

Solution Summary
Changed how the first word is detected.
Comments
perlDreamer
0
8/10/2009 7:13 pm
Fixed in 7.7.17 and 7.6.35
Resolved by perlDreamer
Details
Ticket Status Resolved  
Rating0.0 
Submitted Bysno 
Date Submitted2009-08-10 
Assigned To unassigned  
Date Assigned2010-09-02 
Assigned By 
Severity Critical (mostly not working)  
What's the bug in? WebGUI Stable  
WebGUI / WRE Version Core  
URLuse/bugs/tracker/10746
Keywords
SQL Report improper
Ticket History
8/10/2009
7:13 PM
Resolved perlDreamer
8/10/2009
2:11 PM
Ticket created sno
© 2010 Plain Black Corporation | All Rights Reserved