> To Whom it may concern,
>
> I've noticed a bug with the Billionium. Now that we have hit 1 Billion
> seconds since the beginning of the Epoch mysql will NOT work properly with
a
> MIN clause involving seconds before the Billionium.
>
> To clarify, I have a script that keeps track of the seconds of which the
> data was entered. I then use another script that pulls that data using a
> 'MIN(seconds)' statement to pull the oldest entry. This no longer works
as
> it will only pull data after 1 billion seconds and disregarding anything
> prior.
>
> Im sure you can easily recreate this event by entering false info into a
DB.
>
> Regards,
> Panos
I'm not seeing this behaviour with 3.23.41
mysql> show columns from test;
+---------+---------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+---------+------+-----+---------+-------+
| seconds | int(11) | | MUL | 1 | |
+---------+---------+------+-----+---------+-------+
1 row in set (0.00 sec)
mysql> select min(seconds) from test;
+--------------+
| min(seconds) |
+--------------+
| 998556700 |
+--------------+
1 row in set (0.18 sec)
mysql> select max(seconds) from test;
+--------------+
| max(seconds) |
+--------------+
| 1000013720 |
+--------------+
1 row in set (0.00 sec)
mysql> status;
--------------
mysql Ver 11.15 Distrib 3.23.41, for pc-linux-gnu (i686)
---------------------------------------------------------------------
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
