Bug #67057 alignment of columns with option '--skip-column-names

• Submitted: 2 Oct 2012 18:33
• Modified: 2 Oct 2012 19:28
• Reporter: Luuk V
• Status: Verified
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 5.5.25
• OS: Other (openSUSE 12.1)
• CPU Architecture: Any
• Tags: alignment, columns, skip-column-names

[2 Oct 2012 18:33] Luuk V

Description:
When slectin mutliple columns using the commandline client, the alignement is not correct.

How to repeat:
luuk@opensuse:~> mysql test -te "select text from t"
+------------+
| text       |
+------------+
| aap        |
| noot       |
| mies       |
| schilderij |
+------------+
luuk@opensuse:~> mysql test -te "select text, text from t"
+------------+------------+
| text       | text       |
+------------+------------+
| aap        | aap        |
| noot       | noot       |
| mies       | mies       |
| schilderij | schilderij |
+------------+------------+
luuk@opensuse:~> mysql test -Nte "select text, text from t"
+------------+------------+
|        aap |        aap |
|       noot |       noot |
|       mies |       mies |
| schilderij | schilderij |
+------------+------------+
luuk@opensuse:~> mysql test -Nte "select text from t"
+------------+
| aap        |
| noot       |
| mies       |
| schilderij |
+------------+
luuk@opensuse:~>

Suggested fix:
Always left-align text columns.

[2 Oct 2012 19:28] MySQL Verification Team

Thank you for the bug report.