Comment 2 for bug 645780

Hi Kentoku,

I tested it today and it works :)

on node3 :
select * from trace_ejb6 limit 1;
----+---------------+---------------------+----------+-----------+-------+---------+------------+----------+--------------+-----------+------------+
| id | timestamp | timestamp2 | latitude | longitude | speed | heading | terminalID | mileage | creationtime | tracetype | customerID |
+----+---------------+---------------------+----------+-----------+-------+---------+------------+----------+--------------+-----------+------------+
| 16 | 1155292399058 | 2006-08-11 12:33:19 | 5085231 | 473206 | NULL | NULL | 0 | NULL | 0 | 0 | 0 |
+----+---------------+---------------------+----------+-----------+-------+---------+------------+----------+--------------+-----------+------------+

then on the spider node :

update trace_ejb6 set timestamp = unix_timestamp(now())*1000 where id=16;

on the same node (spider) :

select * from trace_ejb6 where id =16;+----+---------------+---------------------+----------+-----------+-------+---------+------------+---------+--------------+-----------+------------+
| id | timestamp | timestamp2 | latitude | longitude | speed | heading | terminalID | mileage | creationtime | tracetype | customerID |
+----+---------------+---------------------+----------+-----------+-------+---------+------------+---------+--------------+-----------+------------+
| 16 | 1286372530000 | 2006-08-11 12:33:19 | 5085231 | 473206 | NULL | NULL | 0 | NULL | 0 | 0 | 0 |
+----+---------------+---------------------+----------+-----------+-------+---------+------------+---------+--------------+-----------+------------+
1 row in set (0.00 sec)

the record is not more on node 3 but now it's on node 1 :

select * from trace_ejb6 where id =16;
+----+---------------+---------------------+----------+-----------+-------+---------+------------+---------+--------------+-----------+------------+
| id | timestamp | timestamp2 | latitude | longitude | speed | heading | terminalID | mileage | creationtime | tracetype | customerID |
+----+---------------+---------------------+----------+-----------+-------+---------+------------+---------+--------------+-----------+------------+
| 16 | 1286372530000 | 2006-08-11 12:33:19 | 5085231 | 473206 | NULL | NULL | 0 | NULL | 0 | 0 | 0 |
+----+---------------+---------------------+----------+-----------+-------+---------+------------+---------+--------------+-----------+------------+
1 row in set (0.00 sec)

Thank you for having fixed this bug

Fred.