I'm trying to diagnose this and not having much luck. I can't even
figure out where to even begin to look. I have two MySQL servers and
getting different results for the same query on both:
SERVER 1:
mysqladmin Ver 8.41 Distrib 5.0.37, for pc-linux-gnu on i686
SERVER 2:
mysqladmin Ver 8.42 Distrib 5.1.30, for pc-linux-gnu on i686
TABLE description:
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| name | varchar(40) | NO | PRI | | |
| value | varchar(255) | NO | | | |
+-------+--------------+------+-----+---------+-------+
Query run on both systems:
INSERT INTO $TABLE SET NAME='atest', value=now() ON DUPLICATE KEY
UPDATE value=now();
On SERVER 1 it fails to update, where on SERVER 2 it works just fine
and updates the record as I would expect it. Is this a problem with
that specific version (5.0.37) ? Or is there something else I should be
looking for here?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org