Andre,
it might be a bug in the multiversioning code in InnoDB.
Can you describe in detail the situation:
- What is the CREATE TABLE statement?
- How many rows there are in the table?
- How did you import the table?
- Are you able to repeat the bug if you delete and drop the table,
and create and import it again?
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
