Hi Everybody,
The following is my scenario:
mysql> select mop_id, job_id, end_time, start_time,
end_time-start_time from bjs_stat where sol_id = '0000';
+--------+--------+---------------------+---------------------+---------------------+
| mop_id | job_id | end_time | start_time |
end_time-start_time |
+--------+--------+---------------------+---------------------+---------------------+
| ABH | CDCIK | 2004-09-01 21:29:07 | 2004-09-01 21:29:03 |
4 |
| ABH | DFILE | 2004-09-01 21:28:58 | 2004-09-01 21:28:58 |
0 |
| ABH | EODBA | 2004-09-01 21:28:59 | 2004-09-01 21:28:58 |
1 |
| ABH | EODDP | 2004-09-01 21:26:36 | 2004-09-01 20:58:23 |
6813 |
| ABH | FEDRP | 2004-09-01 21:29:02 | 2004-09-01 21:28:59 |
43 |
| ABH | FFDAC | 2004-09-01 20:58:20 | 2004-09-01 20:58:19 |
1 |
| ABH | FSLRP | 2004-09-01 21:28:57 | 2004-09-01 21:28:50 |
7 |
| ABH | LLIEN | 2004-09-01 21:26:41 | 2004-09-01 21:26:39 |
2 |
| ABH | RECSF | 2004-09-01 21:26:39 | 2004-09-01 21:26:36 |
3 |
| ABH | TDCHK | 2004-09-01 21:29:12 | 2004-09-01 21:29:07 |
5 |
| ABH | TODTD | 2004-09-01 21:29:03 | 2004-09-01 21:29:02 |
1 |
| ABH | TXOD | 2004-09-01 20:58:23 | 2004-09-01 20:58:20 |
3 |
| CBOD | EODAF | 2004-09-01 04:05:27 | 2004-09-01 04:05:11 |
16 |
| CBOD | EXCPD | 2004-09-01 04:04:51 | 2004-09-01 04:04:45 |
6 |
| CBOD | INOPR | 2004-09-01 04:05:30 | 2004-09-01 04:05:27 |
3 |
| CBOD | INTFC | 2004-09-01 04:04:54 | 2004-09-01 04:04:51 |
3 |
| CBOD | INTFD | 2004-09-01 04:04:55 | 2004-09-01 04:04:54 |
1 |
| CBOD | INTKD | 2004-09-01 04:04:56 | 2004-09-01 04:04:55 |
1 |
| CBOD | INTRD | 2004-09-01 04:04:57 | 2004-09-01 04:04:56 |
1 |
| CBOD | INTSB | 2004-09-01 04:09:33 | 2004-09-01 04:09:29 |
4 |
| CBOD | LADGF | 2004-09-01 04:09:21 | 2004-09-01 04:09:11 |
10 |
| CBOD | LADGN | 2004-09-01 04:09:11 | 2004-09-01 04:08:18 |
93 |
| CBOD | LADSP | 2004-09-01 04:09:29 | 2004-09-01 04:09:22 |
7 |
| CBOD | MISTD | 2004-09-01 04:08:18 | 2004-09-01 04:05:30 |
288 |
| CBOD | REGFL | 2004-09-01 04:05:11 | 2004-09-01 04:05:07 |
4 |
| CBOD | SSS | 2004-09-01 04:04:45 | 2004-09-01 04:04:40 |
5 |
| CBOD | TDS | 2004-09-01 04:05:06 | 2004-09-01 04:04:57 |
49 |
-------------------------------------------------------------------------------------------------------------------------
| ISOLOP | BGREP | 2004-09-01 07:37:51 | 2004-09-01 07:37:49 |
2 |
| ISOLOP | DEPRP | 2004-09-01 07:37:53 | 2004-09-01 07:37:51 |
2 |
| ISOLOP | DOCRP | 2004-09-01 07:37:55 | 2004-09-01 07:37:53 |
2 |
| ISOLOP | EXCPE | 2004-09-01 07:37:49 | 2004-09-01 07:37:47 |
2 |
| ISOLOP | FBDLK | 2004-09-01 07:37:57 | 2004-09-01 07:37:55 |
2 |
| ISOLOP | FFDAR | 2004-09-01 07:38:00 | 2004-09-01 07:37:58 |
42 |
-------------------------------------------------------------------------------------------------------------------------
| ISOLOP | FFDVR | 2004-09-01 07:38:03 | 2004-09-01 07:38:02 |
1 |
| ISOLOP | IDREP | 2004-09-01 07:37:58 | 2004-09-01 07:37:57 |
1 |
| ISOLOP | TODRP | 2004-09-01 07:38:02 | 2004-09-01 07:38:00 |
2 |
+--------+--------+---------------------+---------------------+---------------------+
36 rows in set (0.00 sec)
mysql> desc bjs_stat;
+------------+-------------+------+-----+------------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+------------+-------+
| sol_id | varchar(8) | | PRI | | |
| bod_date | date | | PRI | 0000-00-00 | |
| mop_id | varchar(10) | | PRI | | |
| job_id | varchar(5) | | PRI | | |
| start_time | datetime | YES | | NULL | |
| end_time | datetime | YES | | NULL | |
| user_id | varchar(15) | YES | | NULL | |
+------------+-------------+------+-----+------------+-------+
7 rows in set (0.00 sec)
While in the query when I am checking for the diff in time, records
shown just above the underlines are interesting. When the actual time
diff is less than 10 secs, result shows > 40 secs.
Is this a bug? My version is mysql-max 4.1.1
The table was created using "load data local inflie" at mysql prompt
from a plain text separated with '|'.
Can any patrons help me?
Thanking in Advance,
Eldo Skaria, Bangalore, India.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
