From: Date: March 19 1999 1:11pm Subject: delete returns incorect number of deleted rows. List-Archive: http://lists.mysql.com/mysql/595 Message-Id: <199903191311.OAA04359@piff.dc.luth.se> MIME-Version: 1.0 Content-Type: text/plain; charset=unknown-8bit Content-Transfer-Encoding: 8bit >Description: delete from table returns 0 rows affected when all the rows are affected. >How-To-Repeat: First make a table that has some data (in this case was called CATEGORY_MEMBERS. Then execute as follows. mysql> select * from CATEGORY_MEMBERS; +----+--------+--------+ | ID | REC_ID | CAT_ID | +----+--------+--------+ | 1 | 1 | 1 | | 2 | 2 | 2 | +----+--------+--------+ 2 rows in set (0.00 sec) mysql> delete from CATEGORY_MEMBERS where ID = 2; Query OK, 1 row affected (0.00 sec) mysql> select * from CATEGORY_MEMBERS; +----+--------+--------+ | ID | REC_ID | CAT_ID | +----+--------+--------+ | 1 | 1 | 1 | +----+--------+--------+ 1 row in set (0.01 sec) mysql> delete from CATEGORY_MEMBERS; Query OK, 0 rows affected (0.01 sec) mysql> select * from CATEGORY_MEMBERS; Empty set (0.01 sec) >Fix: >Submitter-Id: >Originator: Piff Super-User >Organization: Luleå University. >MySQL support: none >Synopsis: delete from returns incorrect # of affected rows if deleting all rows. >Severity: non-critical >Priority: medium >Category: mysql >Class: sw-bug >Release: mysql-3.22.20a (TCX binary) >Environment: System: SunOS piff 5.7 Generic sun4u sparc SUNW,Ultra-5_10 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/local/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.8.1/specs gcc version 2.8.1 Compilation info: CC='gcc' CFLAGS='-O3 -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=TCX binary' --with-low-memory --disable-shared Perl: This is perl, version 5.004_04 built for sun4-solaris