Bug #56638 (Still) no "pager" support in client on Windows
Submitted: 8 Sep 2010 9:47 Modified: 14 Sep 2010 11:47
Reporter: Joerg Bruehe Email Updates:
Status: Patch queued Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.5.6-rc OS:Microsoft Windows
Assigned to: Assigned Account CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[8 Sep 2010 9:47] Joerg Bruehe
Description:
Now that the "echo" bug 56547 is fixed,
test "mysql" fails in the release build of 5.5.6-rc because of "pager":
.../mysql-5.5.6-rc-winx64/bin/mysql.exe: unknown option '--pager'

=====
main.mysql                               [ retry-fail ]
        Test ended at YYYY-MM-DD HH:MM:SS

CURRENT_TEST: main.mysql
ERROR 1050 (42S01) at line 1: Table 't2' already exists
G:/pb2/test/sb_1-2245869-1283876337.83/mysql-5.5.6-rc-winx64/bin/mysql.exe: unknown option '--pager'
mysqltest: At line NNN: command "$MYSQL --pager test -e "select 1 as a"" failed

Output from before failure:
exec of '/PATH/bin/mysql.exe --defaults-file=/PATH/mysql-test/var/my.cnf --pager test -e "select 1 as a"' failed, error: 2, status: 2, errno: 2

The result from queries just before the failure was:
< snip >
+------+
|  b   |
+------+
*************************** 1. row ***************************
a:  b
<TABLE BORDER=1><TR><TH>a</TH></TR><TR><TD> b </TD></TR></TABLE><?xml version="1.0"?>

<resultset statement="select a from t1
" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <row>
        <field name="a"> b </field>
  </row>
</resultset>
drop table t1;

Bug #47147: mysql client option --skip-column-names does not apply to vertical output

*************************** 1. row ***************************
1
Bug #54466 client 5.5 built from source lacks "pager" support

More results from queries before failure can be found in /PATH/mysql-test/var/log/mysql.log
=====

The fix for bug#54466 *is* contained in this build,
but its comment explicitly reads

  client/mysql.cc
    Bug#54466      client 5.5 built from source lacks "pager" support
    now we have USE_POPEN always if not __WIN__

How to repeat:
Run the test on Windows.

PB2 shows this test failure (on Windows) since that fix was pushed on August 20.

Suggested fix:
I don't know whether we want to support "--pager" on Windows,
so the "fix" may be to move this test snippet into a test that is skipped on Windows.
[14 Sep 2010 11:47] Alexey Botchkov
This problem was introduced by my fix to #54466. After that i already pushed the additional fix to the mysql-5.5-bugfixing, but it probably didn't make it to the 5.5.6 in time.
So closed since the 5.5.7.