MySQL Bugs: #17478: mysqlslap not issuing any queries

Bug #17478	mysqlslap not issuing any queries
Submitted:	16 Feb 2006 16:06	Modified:	18 Apr 2006 7:54
Reporter:	Robin Schumacher	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	5.1.6	OS:	Linux (Fedora core 4)
Assigned to:	Magnus Blåudd	CPU Architecture:	Any

Description:
mysqlslap does not appear to be issuing SELECT statements when the -a option is used.  

How to repeat:
Running this command: /usr/local/mysql516/bin/mysqlslap -a -c 10 -e myisam -x 5 -y 5 -i 1000 -ppword -P3306 --socket=/usr/local/mysql516/mysql5.sock -uroot

The tables are built, but no SELECT statements appear to be issued:

Running for engine myisam
>         Average number of seconds to run all queries: 0.004 seconds
>         Minimum number of seconds to run all queries: 0.004 seconds
>         Maximum number of seconds to run all queries: 0.006 seconds
>         Number of clients running queries: 10
>         Average number of queries per client: 1

same problem on Redhat AS 4.0 

$ mysqlslap -vvv -c 5 -a --socket=/tmp/mysql.sock --number-of-queries=10

just DDL no DML.  same effect when specifying --query,  --only-print does
print the DML this is not being executed.  Its as if --silent gets turned on.  --print-defautls does not include --silent and I tried specifying --silent=0 but no difference.  non-execution was verified by looking in general log, when DDL can be seen.

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/4817

This problem does not exist in our latest mysql-5.1 version, made some changes on the way to make it easier to diagnose what could be wrong.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html