| Bug #45734 | Query browser adds extra padding | ||
|---|---|---|---|
| Submitted: | 24 Jun 2009 23:47 | Modified: | 27 Jun 2009 10:04 |
| Reporter: | Adam Dixon | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Query Browser | Severity: | S3 (Non-critical) |
| Version: | 1.2.12 | OS: | Any (Linux & Windows) |
| Assigned to: | CPU Architecture: | Any | |
[26 Jun 2009 12:50]
MySQL Verification Team
query browser runs "set names utf8" and that causes the extra padding.
Description: When running SELET INTO OUTFILE whilst using rpad, Query browser seems to double the padding, whilst the mysql.exe provides the correct result; Tested on XP, 2003 64bit and Linux, all behave the same. How to repeat: Repeat using; select rpad('ssn',19,' '), rpad('acctnum',24,' ') into outfile 'c:\\test.in' fields terminated by '' enclosed by '' lines terminated by '\r\n' from dual Suggested fix: Pad correctly when using query browser ?