MySQL Bugs: #28547: Query Browser only displays the 1st 3 lines of a query

Bug #28547	Query Browser only displays the 1st 3 lines of a query
Submitted:	21 May 2007 6:24	Modified:	21 Jun 2007 8:44
Reporter:	Daniel Kasak (Candidate Quality Contributor)	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S3 (Non-critical)
Version:	All	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	qc

Description:
Query browser only displays the 1st 3 lines of a query. This makes it useless for anything but the most basic queries.

About a year ago I posted a patch to the glade file that allowed the textview where the query was displayed to be resized. This bug received precisely no attention, yet the bug still exists.

How to repeat:
Type a query into query browser, and note how you can only see 10% of it. Here's a query you can try:

---

select
 ClientID,
 TAP.DanPK,
 to_days(ServiceTo)-to_days(ServiceFrom) as Days,
 sum(TLP.Service) as Service,
 sum(if(LineType<3,0,Local)) as Local,
 sum(if(LineType<3,0,National)) as National,
 sum(if(LineType<3,0,International)) as International,
 sum(if(LineType<3,0,TLP.Mobile)) as Mobile,
 sum(if(LineType<3,0,TLP.Data)) as Data,
 sum(if(LineType<3,Local+National+International+TLP.Mobile+TLP.Data,0)) as 1x00, sum(OtherCalls+TLP.OtherCharges) as 
OtherCallsAndCharges,
 sum(TLP.Service+Local+National+International+TLP.Mobile+TLP.Data+OtherCalls+TLP.OtherCharges+Discount) as Total

from
 TLocations TL inner join TelecomAccountPosting TAP
  on TL.DanPK=TAP.LocID
 inner join TelecomLinePosting TLP
  on TAP.DanPK=TLP.TelecomLinePostingID

where
 to_days(ServiceTo)-to_days(ServiceFrom)>0 and LastThree=1 and ( LineType=29 or LineType=48 ) and TL.Active!=0

group by
TAP.DanPK,
 ServiceFrom,
 ServiceTo

---

See how it doesn't fit, and you can only see 3 lines at a time?

Suggested fix:
As per my patch from ages ago, the textview should be inside a pane, so the user can increase the size of it somewhat.

Thank you for a problem report. Please, try to repeat with a latest version of QB, 1.2.12. In case of the same problem (I can not repeat it), please, send a screenshot that demonstrates it (+ URL to your patch, if you still want it to be considered).

Could you please state which OS your are on?

E.g. on Windows there is the View -> Maximize Query Edit (F11) feature that gives you a regular edit control for the SQL text. And you can scaled that as large as you want with the vertical splitter below that control.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".