[Python-Dev] Bug in the DELETE statement in sqlite3 module (original) (raw)

Piotr Duda duda.piotr at gmail.com
Wed Jun 15 11:25:53 EDT 2016

This is not a bug, this is correct behavior of any sql database.

2016-06-15 8:40 GMT+02:00 ninostephen mathew <ninosm12 at gmail.com>:

Respected Developer(s), while writing a database module for one of my applications in python I encountered something interesting. I had a username and password field in my table and only one entry which was "Admin" and "password". While debugging I purposefully deleted that record. Then I ran the same statement again. To my surprise, it got execute. Then I ran the statement to delete the user "admin" (lowercase 'a') which does not exist in the table. Surprisingly again is got executed even though the table was empty. What I expected was an error popping up. But nothing happened. I hope this error gets fixed soon. The code snippet is given below.

self.cursor.execute(''' DELETE FROM Users WHERE username = ?''',(self.username,))

Python-Dev mailing list Python-Dev at python.org https://mail.python.org/mailman/listinfo/python-dev Unsubscribe: https://mail.python.org/mailman/options/python-dev/duda.piotr%40gmail.com

-- 闇に隠れた黒い力 弱い心を操る

More information about the Python-Dev mailing list