List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:November 26 1999 3:04am
Subject:Re[2]: Maybe a BUG in dates ordering ...
View as plain text  
>>>>> "BAUMEISTER" == BAUMEISTER Alexandre <alex@stripped>
> writes:

<cut>

BAUMEISTER>   It is Mysql 3.22.26a under Solaris 2.6 .

BAUMEISTER>   We tried a lot of things like order on date, order on unix_timestamp
BAUMEISTER>   ... but as soon as there are a lot of requests, Mysql results are no
BAUMEISTER>   more well ordered.


Can you verify if it's the value from unix_timestamp(date), the date
or the sort is wrong?

Could you please try:

mysql> select unix_timestamp(date),date from intraday_PAR where symbole='1rpfte' order
> by

and send me a couple of rows that is 'wrongly ordered'.

When this happens, are all following results wrong or will some be ok?
(In other words, is the table corrupted when this happens)

Regards,
Monty

PS: Sorry for the late reply;  I am still trying to catch up with the
    mails that piled up during my vacation.


>> Hi,
>> 
>> I have a problem with order on dates with Mysql 3.22.26a .
>> 
>> Below is the description of a table which contains about 80000 rows.
>> 
>> The table was created with :
>> 
>> create table intraday_PAR (
>> symbole char(20) NOT NULL,
>> date datetime NOT NULL,
>> first real(17,5) NOT NULL,
>> high real(17,5) NOT NULL,
>> low real(17,5) NOT NULL,
>> last real(17,5) NOT NULL,
>> volume int NOT NULL,
>> unique(symbole,date),
>> index idx_symbole (symbole),
>> index idx_date (date)
>> );
>> 
>> 
>> The table is doped an re-created each morning and filled with data
>> all day long (these are shares quotations informations).
>> 
>> Everything works quite well, but when the server on which is hosted
>> the database becomes a little loaded, the we have some strange
>> ordering results from Mysql.
>> 
>> Maybe a bug ? Any idea ?
>> 
mysql> desc intraday_PAR;
mysql> +---------+--------------+------+-----+---------------------+-------+
mysql> | Field   | Type         | Null | Key | Default             | Extra |
mysql> +---------+--------------+------+-----+---------------------+-------+
mysql> | symbole | char(20)     |      | PRI |                     |       |
mysql> | date    | datetime     |      | PRI | 0000-00-00 00:00:00 |       |
mysql> | first   | double(17,5) |      |     | 0.00000             |       |
mysql> | high    | double(17,5) |      |     | 0.00000             |       |
mysql> | low     | double(17,5) |      |     | 0.00000             |       |
mysql> | last    | double(17,5) |      |     | 0.00000             |       |
mysql> | volume  | int(11)      |      |     | 0                   |       |
mysql> +---------+--------------+------+-----+---------------------+-------+
mysql> 7 rows in set (0.00 sec)
>> 
mysql> select unix_timestamp(date) from intraday_PAR where symbole='1rpfte' order by
BAUMEISTER> date;
mysql> +----------------------+
mysql> | unix_timestamp(date) |
mysql> +----------------------+
mysql> |            941179740 |
mysql> |            941180400 |  <----------
mysql> |            941266860 |  <----------
mysql> |            941180520 |  <----------
mysql> |            941180580 |
mysql> |            941180640 |
Thread
Maybe a BUG in dates ordering ...BAUMEISTER Alexandre29 Oct
  • Re: Maybe a BUG in dates ordering ...sinisa29 Oct
    • Re[2]: Maybe a BUG in dates ordering ...BAUMEISTER Alexandre1 Nov
      • Re[2]: Maybe a BUG in dates ordering ...Michael Widenius26 Nov