Bug #26780 patch to add auto vertical output option to the cli.
Submitted: 2 Mar 2007 3:53 Modified: 17 Mar 2008 19:56
Reporter: Eric Bergen (SCA)
Status: Closed
Category:Client Severity:S4 (Feature request)
Version:5.0.33 OS:Any
Assigned to: Chad MILLER Target Version:5.1+
Tags: auto vertical display, Contribution
Triage: D5 (Feature request)

[2 Mar 2007 3:53] Eric Bergen 
Description:
This patch adds --auto-vertical-output to the command client. When queries are executed
with \g or ; and this option is enabled the client will switch to vertical mode if the
result set is going to be wider than the terminal. \G forces vertical. 

The patch is available at http://ebergen.net/patches/auto_vertical.patch

How to repeat:
Execute a select with a result wider than the screen and watch it wrap.

Suggested fix:
Apply the patch and set the option in my.cnf :)
[29 Apr 2007 15:04] Valeriy Kravchuk 
Thank you for the patch.
[12 Jun 2007 22:30] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/28609

ChangeSet@1.2475, 2007-06-12 16:29:21-04:00, cmiller@zippy.cornsilk.net +4 -0
  Bug#26780: automatic vertical output for wide results
  
  Feature from Eric Bergen, CLA signed 2007-06-27.
  
  Adds new mysql client option "--auto-vertical-output", which causes
  the client to test whether a result table is too wide for the current
  window (where available) and emit vertical results in that case. 
  Otherwise, it sends normal tabular results.
[26 Jun 2007 22:53] Timothy Smith 
Patch looks OK; minor style comment and a few additional tests requested, but no need for
re-review.
[28 Jun 2007 13:55] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/29843

ChangeSet@1.2515, 2007-06-28 07:54:33-04:00, cmiller@calliope.near.cmiller.mysql.com +4 -0
  Bug#26780: automatic vertical output for wide results
  
  Feature from Eric Bergen, CLA signed 2007-06-27.
  
  Adds new mysql client option "--auto-vertical-output", which causes
  the client to test whether a result table is too wide for the current
  window (where available) and emit vertical results in that case.
  Otherwise, it sends normal tabular results.
[4 Mar 2008 18:49] Chad MILLER 
This slipped by me unnoticed somehow.  It's been in 6.0 since (probably) November.
[4 Mar 2008 20:28] Paul DuBois 
The version for this feature is 6.0.4.
[17 Mar 2008 19:56] Paul DuBois 
Noted in 6.0.4 changelog. Also added option description to mysql section.