Bug #31379 Incorrect error ERROR 1114 (HY000): The table '' is full

• Submitted: 3 Oct 2007 16:43
• Modified: 20 May 2008 1:29
• Reporter: Diego Medina
• Status: Duplicate
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.41,5.0.45,5.1.22
• OS: Linux (Fedora 7 i686)
• Assigned to: Assigned Account
• CPU Architecture: Any

[3 Oct 2007 16:43] Diego Medina

Description:
When executing 
UPDATE  `data` 
RIGHT JOIN `temp`   
  ON `data`.`item_id`=`temp`.`internal_part` 

 JOIN `items`  
  ON `items`.`internal_part`=`data`.`item_id` 
 JOIN `temp` as `altkey_temp`  
  ON altkey_temp.`altkey`=`items`.`altkey`  
SET `data`.`quantity_on_hand`=`data`.`quantity_on_hand`
I get this error

ERROR 1114 (HY000): The table '' is full  
(Note that it does not show the table name (not a typo) )
and the same query with the same data on 5.0.45 gives me the error:
1022 Can't Write; duplicate key in table ''

(Note that it does not show the table name (not a typo) )

How to repeat:
I'll attach a sql dump so that you can reproduce this on your server.

Once the data is loaded, run:

When executing 
UPDATE  `data` 
RIGHT JOIN `temp`   
  ON `data`.`item_id`=`temp`.`internal_part` 

 JOIN `items`  
  ON `items`.`internal_part`=`data`.`item_id` 
 JOIN `temp` as `altkey_temp`  
  ON altkey_temp.`altkey`=`items`.`altkey`  
SET `data`.`quantity_on_hand`=`data`.`quantity_on_hand`

[3 Oct 2007 16:54] Diego Medina

I uploaded a compressed file under the name bug-data-31379.tar.gz

[3 Oct 2007 17:08] Diego Medina

I saw that bug report and that's why I updated MySQL server to 5.0.45 and as  I saw a different error I imagine it was not the same as on bug 27643

***********************
[3 Oct 18:59] Shane Bester

possible duplicate of bug #27643 ?

[3 Oct 2007 23:11] MySQL Verification Team

Thank you for the bug report. That error message with empty table name still
happens with current source server:

mysql> select version();
+--------------+
| version()    |
+--------------+
| 5.0.52-debug | 
+--------------+
1 row in set (0.00 sec)

mysql> UPDATE  `data` 
    -> RIGHT JOIN `temp`   
    ->   ON `data`.`item_id`=`temp`.`internal_part` 
    -> 
    ->  JOIN `items`  
    ->   ON `items`.`internal_part`=`data`.`item_id` 
    ->  JOIN `temp` as `altkey_temp`  
    ->   ON altkey_temp.`altkey`=`items`.`altkey`  
    -> SET `data`.`quantity_on_hand`=`data`.`quantity_on_hand`;
ERROR 1022 (23000): Can't write; duplicate key in table ''
mysql>

[4 Oct 2007 17:48] Diego Medina

I just downloaded MySQL 5.1.22-rc and run the same test and this time it did give me a table name 

Error: 1000 Can't Write: duplicate key in table '/tmp/#sql_6007_0'

I hope this may help you find / fix the bug.

[10 Oct 2007 1:50] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/35248

ChangeSet@1.2530, 2007-10-10 03:50:20+02:00, [e-mail] +3 -0
  Bug#31379: Incorrect error ERROR 1114 (HY000): The table '' is full
  
  Table alias could be empty for tempory tables, making the error message
  look broken. We now print the path to the table in such cases.

[19 May 2008 19:50] Sergey Petrunya

See also BUG#36676

[19 May 2008 20:23] Sergey Petrunya

Trying on 5.0.60-debug, tip cset:

ChangeSet@1.2609, 2008-04-19 22:21:51+05:00, [e-mail] +1 -0
  Bug#5299 Remove SHOW COLUMN TYPES
  result fix

I get this:
ERROR 1022 (23000): Can't write; duplicate key in table ''

[20 May 2008 1:29] Sergey Petrunya

Same issue as BUG#36676, addressed by fix for BUG#36676. Changing status to Duplicate.