List:General Discussion« Previous MessageNext Message »
From:Gunter Leeb Date:October 27 2001 6:01pm
Subject:Bugreport: Incorrect rows affected number!
View as plain text  
Below sequence shows that MySQL returned 0 rows affected after it deleted 2 records.

Regards,

Gunter

Environment:
W2K,
mysql. 3.23.41-max-nt

mysql> select * from mmecounter;
+----------------------+----------------+-------------+--------------+---------+
----------+------------+-------------+----------+--------+--------+--------+
| ID                   | Modified       | Machine_ref | Category     | Name    |
 ValueNum | ValueFloat | ValueString | DataType | Spare1 | Spare2 | Spare3 |
+----------------------+----------------+-------------+--------------+---------+
----------+------------+-------------+----------+--------+--------+--------+
| -4636453695223307315 | 20011027125508 |           2 | TESTCategory | TestKey |
        0 |          0 | TestText    |        1 | NULL   | NULL   | NULL   |
| -4636453695223154567 | 20011027125508 |           2 | TESTCategory | TestKey |
        0 |          0 | TestText    |        1 | NULL   | NULL   | NULL   |
+----------------------+----------------+-------------+--------------+---------+
----------+------------+-------------+----------+--------+--------+--------+
2 rows in set (0.00 sec)

mysql> delete from mmecounter;
Query OK, 0 rows affected (0.00 sec)

mysql> delete from mmecounter where ValueNum=0;
Query OK, 0 rows affected (0.00 sec)

mysql> select * from mmecounter;
Empty set (0.00 sec)




Gunter Leeb
Director of Development
MachineGeneration Inc.
gleeb@stripped

Direct: (512) 266 2139
Main: (512) 266 9580


Thread
Bugreport: Incorrect rows affected number!Gunter Leeb27 Oct
  • Re: Bugreport: Incorrect rows affected number!Dan Nelson27 Oct