Andre,
the strange behavior may have been due to the same bug Alex
Baumeister reported, and for which I posted a fix on the mailing
list a few minutes ago.
After you had reloaded the table, did you insert, update, or delete
any rows in the table? Or did you just do selects? Did you have any
other transactions open when you did the selects, i.e., clients in
the non-autocommit mode?
Regards,
Heikki
>Hi,
>
>I accidently delete all my records from a table, but I always make backups!!!
>Okay, I deleted the (empty) table with drop table.
>Than I recreate the table and all the data mith a mysql batch job (from
>mysqldump) .No problem. Than I started the mysql UI and make some test queries.
>select * from passwd;All records are displayed
>if I query only for one column I get an empty set back
>select pw_name from passwd where pw_name='pbs013';
>Empty set (0.00 sec)
>If I query for the whole record all works fine:
>mysql> select * from passwd where pw_name='pbs013';
>+---------+----+---------+---------------+--------+--------+---------------
+----
>----------+----------+
>| name_nr | nr | pw_name | pw_passwd | pw_uid | pw_gid | pw_gecos |
>pw_dir | shell_nr |
>+---------+----+---------+---------------+--------+--------+---------------
+----
>----------+----------+
>| 50 | 50 | pbs013 | deleted | 10013 | 10000 | andre konopka |
>/home/pbs013 | 1 |
>+---------+----+---------+---------------+--------+--------+---------------
+----
>----------+----------+1 row in set (0.00 sec)
>After restarting mysqld all works as expected???
>
mysql> select pw_name from passwd where pw_name='pbs013';+---------+| pw_name |
>+---------+| pbs013 |+---------+1 row in set (0.01 sec)Andre
>----------------------------------E-Mail: [EMAIL PROTECTED]
>Date: 08-May-01Time: 16:28:44
---------------------------------------------------------------------
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
