Weird things have just started happening in at least one table of my MySQL
3.22.32 database. The symptoms are like this:
mysql> describe orders;
+--------------+----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+----------------------+------+-----+---------+-------+
...
| contact_info | smallint(5) unsigned | YES | | NULL | |
| expired | datetime | YES | | NULL | |
+--------------+----------------------+------+-----+---------+-------+
mysql> select contact_info, expired from orders where order_num = '1';
+--------------+---------+
| contact_info | expired |
+--------------+---------+
| NULL | NULL |
+--------------+---------+
1 row in set (0.00 sec)
mysql> select count(*) from orders where contact_info is null;
+----------+
| count(*) |
+----------+
| 248 |
+----------+
1 row in set (0.02 sec)
// here comes the problematic part //
mysql> select count(*) from orders where expired is null;
+----------+
| count(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)
Obviously this last result is wrong; there should be at least one (and in
fact about thirty) table entries where expired is null. The thing can select
on and update the 'expired' field, and can show rows where 'expired' is null
if I select on another key, but can't seem to find those same rows when I
try to select them by the 'expired' field. Only that one field is giving me
trouble, and this just started happening today.
I've tried 'isamchk -r orders' to no avail, and I found nothing else that
might do this in the manual or archives.. I can send more info to anybody
that wants it, but does anybody recognize these symptoms right off or know
what might be causing them?
Thanks,
-Jt.
Jeremiah T. Folsom-Kovarik
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
---------------------------------------------------------------------
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
