UPDATE bug

2001-09-07 Thread nep
Description: Ok, I know I submitted an earlier bug report about this, but I've actually had it happen from the mysql monitor. Essentially, UPDATE queries are executing, but not actually updating, unless I SELECT data from the table first. How-To-Repeat: Simple as that. I have yet

Possible UPDATE bug

2001-05-22 Thread nep
Description: When updating a table after it has been selected with a LEFT JOIN, some UPDATE queries execute normally without actually updating the data, unless the data to be updated is selected normally first. This script is written in mod_perl, using DBI::mysql to connect to the