Hi,
I recantly upgraded from 3.22.32 to 3.23.35 using an rpm from
www.mysql.com.
My platform: Redhat Linux 2.2.14 i686
The problem is now that UPDATE do not always succed. I get a query OK
but no
update is done unless the same query is issued once again.
This problem is not constant but rather comes and go.
Case 1: Failure
mysql> select * from test;
+----+-------+
| id | value |
+----+-------+
| 1 | xx |
+----+-------+
1 row in set (0.00 sec)
mysql> update test set value='yy' where id=1;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from test;
+----+-------+
| id | value |
+----+-------+
| 1 | xx |
+----+-------+
1 row in set (0.00 sec)
Case 2: Failure first time, but second time the update is done
mysql> select * from test;
+----+-------+
| id | value |
+----+-------+
| 1 | xx |
+----+-------+
1 row in set (0.00 sec)
mysql> update test set value='yy' where id=1;
Query OK, 0 rows affected (0.00 sec)
mysql> update test set value='yy' where id=1;
Query OK, 1 row affected (0.00 sec)
mysql> select * from test;
+----+-------+
| id | value |
+----+-------+
| 1 | yy |
+----+-------+
1 row in set (0.00 sec)
Does anyone understand this ? becouse I am lost !
regards
Petter
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php