Hi,

I need more help with mysqltest syntax ;)

I would to execute the following script :

connect (con1, localhost, root,,); let $2=10; while ($2) { connect (con$2, localhost, root,,); dec $2; }

let $2=10; while ($2) { connection con$2; use presence; let $1=100; while ($1) { @./res SELECT citation,icq,homepage,signature_forum,configuration FROM inscrit2 WHERE pseudo='@nge'; @./res SELECT citation,icq,homepage,signature_forum,configuration FROM inscrit2 WHERE pseudo='Homertrix'; @./res SELECT citation,icq,homepage,signature_forum,configuration FROM inscrit2 WHERE pseudo='jey'; @./res SELECT citation,icq,homepage,signature_forum,configuration FROM inscrit2 WHERE pseudo='Homertrix'; @./res SELECT citation,icq,homepage,signature_forum,configuration FROM inscrit2 WHERE pseudo='ronaldozebestRZB'; @./res SELECT citation,icq,homepage,signature_forum,configuration FROM inscrit2 WHERE pseudo='Homertrix'; @./res SELECT citation,icq,homepage,signature_forum,configuration FROM inscrit2 WHERE pseudo='-Freeman-'; dec $1; } dec $2; }

connection con1; use presence; @./alt ALTER TABLE inscrit2 DROP flag, ADD flag TINYINT DEFAULT '0' NOT NULL;

let $2=10; while ($2) { connection con$2; --send reap; dec $2; }

connection con1; --send reap;

Unfortunaltely, it doesn't work ;) How can I use the variable $2 to make change the connection number ?

(one day I will succeed in making a testcase for this annoying bug :D)

BTW I've got a funny thing which occurs during my test :

mysql> ALTER TABLE forum.inscrit DROP flag, ADD flag TINYINT DEFAULT '0' NOT NULL;

Query OK, 13683 rows affected (1.30 sec)

Records: 13683 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE forum.inscrit DROP flag, ADD flag TINYINT DEFAULT '0' NOT NULL;

Query OK, 8014 rows affected (0.74 sec)

Records: 8014 Duplicates: 0 Warnings: 0

Where are the 5669 missing records :D

Fortunately, I made a backup of the table just before ;) (but once again the table wasn't corrupted in any way)