Serg...@mckinsey.com writes:
1) installation
OS = Windows 2000
MySql = 4.0.12-nt (binary download from you site)
All tables are myISAM
2) description
2.1) Problem1 :
I have one table (calc_t1) that contains 489 875 rows. The total data size
reported by show status is 155 400 900
I have another table (calc_t9) that contains 489 875 rows. The total data
size reported by show status 46 252 364
Both table uses the same primary key, made of five fields declared as
varchar(50). Actually, none of them exceeds 12 characters (note: later,I
tried to reduce the declared field size, but the problem described below
still occurs)
The keys are the same in both files (checked by doing a Select count(*)
from Calc_T1 inner join Calc_T9 using (....), which returned 489875)
Now I want to move some data from Calc_T9 to Calc_T1.
HI!
The above is not a fully repeatable test case, plus it does not look
like a bug either.
You are either hitting some filesystem limit or you need to increase
MAX_ROWS on T1 table.
3 messages in com.mysql.lists.bugsRe: MySql Version 4.xx problems with ...