Greetings.
I thought I'd run this one by the list before panicing and submitting a
bug report.
A couple of weeks ago, I did a mysqldump of all our databases,
uninstalled 4.0.something, did a clean install of 4.1.14, and imported
from our backups. As far as I could see, the upgrade went flawlessly.
Now, however, I've been alerted to an issue with max(date_field). I read
the upgrade documentation, but didn't see anything that would affect
this. The problem:
Background on data:
mysql> select ID, Loc_FK, BatchNo, EAPDate from EAPosting where Loc_FK=7249;
+-------+--------+---------+------------+
| ID | Loc_FK | BatchNo | EAPDate |
+-------+--------+---------+------------+
| 59370 | 7249 | 60992 | 2004-08-31 |
| 60512 | 7249 | 64986 | 2004-09-30 |
| 60513 | 7249 | 64986 | 2004-10-31 |
| 60514 | 7249 | 64986 | 2004-11-30 |
| 60515 | 7249 | 64986 | 2004-12-31 |
| 61714 | 7249 | 70753 | 2005-01-31 |
| 61715 | 7249 | 70753 | 2005-02-28 |
| 61716 | 7249 | 70753 | 2005-03-31 |
| 63124 | 7249 | 74142 | 2005-04-30 |
| 63125 | 7249 | 74142 | 2005-05-31 |
| 63126 | 7249 | 74142 | 2005-06-30 |
| 64194 | 7249 | 83404 | 2005-08-31 |
| 64195 | 7249 | 83404 | 2005-09-30 |
+-------+--------+---------+------------+
13 rows in set (0.01 sec)
So far so good.
mysql> select max(EAPDate) from EAPosting where Loc_FK=7249;
+--------------+
| max(EAPDate) |
+--------------+
| 2005-09-30 |
+--------------+
1 row in set (0.00 sec)
*BIG* problem! What's up with the 2005-09-30 record?
And yes, EAPDate is a date field:
mysql> describe EAPosting;
+---------------+-----------------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default
| Extra |
+---------------+-----------------------+------+-----+-------------------+----------------+
| Account_FK | mediumint(8) unsigned | | MUL | 0
| |
| Loc_FK | mediumint(8) unsigned | | MUL | 0
| |
| ID | mediumint(8) unsigned | | PRI | NULL
| auto_increment |
| MyStamp | timestamp | YES | | CURRENT_TIMESTAMP
| |
| BatchNo | mediumint(8) unsigned | | | 0
| |
| EAPDate | date | | | 0000-00-00
| |
etc ...
Should I report it?
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]