$ /cygdrive/c/mysql-4.1.10-win32/bin/mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 35 to server version: 4.1.10-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create database foobar;
Query OK, 1 row affected (0.01 sec)

mysql> \q
Bye

klas@PC320572325321 /cygdrive/c/bugs/4408
$ /cygdrive/c/mysql-4.1.10-win32/bin/mysql foobar < initbugdb.sql

klas@PC320572325321 /cygdrive/c/bugs/4408
$ /cygdrive/c/mysql-4.1.10-win32/bin/mysql foobar < queryCorrect.sql
apid_   apid    COUNT(DISTINCT(sid))    SUM(IFNULL(amistd,0))   SUM(IFNULL(amiio
d,0)+IFNULL(amiiod,0))  COUNT(DISTINCT(un))
apid_   NULL    1       0       0       1
apid_   lh      6       803     360204  1
apid_   lp1     5       2004    3519560 2
apid_   TH_L001 1       150     640     1

klas@PC320572325321 /cygdrive/c/bugs/4408
$ /cygdrive/c/mysql-4.1.10-win32/bin/mysql foobar < queryWithWrongResult.sql
apid    apid    COUNT(DISTINCT(sid))    SUM(IFNULL(amistd,0))   SUM(IFNULL(amiio
d,0)+IFNULL(amiiod,0))  COUNT(DISTINCT(un))
apid    lh      13      2957    3880404 5

klas@PC320572325321 /cygdrive/c/bugs/4408
$ diff queryCorrect.sql queryWithWrongResult.sql
1c1
< SELECT 'apid_', apid,
---
> SELECT 'apid', apid,

klas@PC320572325321 /cygdrive/c/bugs/4408
$