Description:
if you try to insert data in a table that is "full" (variable row length, 4GB of data reached), you get the error:
ERROR 1105 (HY000): Unknown error
You should get a specific error
How to repeat:
create 2 tables with the same format, having varchar and blob fields.
fill the 4st table to contain 4GB
have some entries in the 2nd table.
insert ignore into table1 select * from table2;
ERROR 1105 (HY000): Unknown error
the table format should not matter, anyway some info on it:
+-----------+-----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-----------------------+------+-----+---------+-------+
| timestamp | int(11) | | MUL | 0 | |
| msg_oid | bigint(20) unsigned | | PRI | 0 | |
| trn_oid | bigint(20) unsigned | | MUL | 0 | |
| trn_pos | mediumint(8) unsigned | | | 0 | |
| creator | varchar(44) | YES | | NULL | |
| msg_type | smallint(5) unsigned | | | 0 | |
| dest_to | tinyint(3) unsigned | | | 0 | |
| dest_from | tinyint(3) unsigned | | | 0 | |
| host | varchar(100) | YES | | NULL | |
| url | varchar(100) | YES | | NULL | |
| body | blob | YES | | NULL | |
+-----------+-----------------------+------+-----+---------+-------+
show table status \G
*************************** 1. row ***************************
Name: http
Engine: MyISAM
Version: 9
Row_format: Dynamic
Rows: 6274699
Avg_row_length: 441
Data_length: 4294967060
Max_data_length: 4294967295
Index_length: 321212416
Data_free: 1523833024
Auto_increment: NULL
Create_time: 2005-07-26 11:06:19
Update_time: 2005-09-18 13:51:25
Check_time: 2005-09-18 13:37:45
Collation: latin1_swedish_ci
Checksum: NULL
Create_options:
Comment:
Suggested fix:
-