Bug #17174 Problem with a Merge

• Submitted: 7 Feb 2006 1:08
• Modified: 7 Feb 2006 2:09
• Reporter: [ name withheld ]
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: MYSQL Server 5.0.18
• OS: Windows (Windows)
• Assigned to: MySQL Verification Team
• CPU Architecture: Any

[7 Feb 2006 1:08] [ name withheld ]

Description:
Merge table doesn't work. Problem reported: ERROR 1017 (HY000): Can't find file: 'bg' (errno: 2)

How to repeat:
CREATE TABLE IF NOT EXISTS BG2006(
IDBG TINYINT UNSIGNED,
DATAIN DATE,
DATAFIN DATE,
TOTALE FLOAT(10,2));

CREATE TABLE IF NOT EXISTS BG2007(
IDBG TINYINT UNSIGNED,
DATAIN DATE,
DATAFIN DATE,
TOTALE FLOAT(10,2));

CREATE TABLE BG(
IDBG TINYINT UNSIGNED,
DATAIN DATE,
DATAFIN DATE,
TOTALE FLOAT(10,2))ENGINE= MERGE UNION(BG2006, BG2007);

SELECT * FROM BG;

[7 Feb 2006 2:09] MySQL Verification Team

I was unable to repeat the behavior reported:

c:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.0.18-nt-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> CREATE TABLE IF NOT EXISTS BG2006(
    -> IDBG TINYINT UNSIGNED,
    -> DATAIN DATE,
    -> DATAFIN DATE,
    -> TOTALE FLOAT(10,2));
Query OK, 0 rows affected (0.13 sec)

mysql>
mysql> CREATE TABLE IF NOT EXISTS BG2007(
    -> IDBG TINYINT UNSIGNED,
    -> DATAIN DATE,
    -> DATAFIN DATE,
    -> TOTALE FLOAT(10,2));
Query OK, 0 rows affected (0.08 sec)

mysql>
mysql> CREATE TABLE BG(
    -> IDBG TINYINT UNSIGNED,
    -> DATAIN DATE,
    -> DATAFIN DATE,
    -> TOTALE FLOAT(10,2))ENGINE= MERGE UNION(BG2006, BG2007);
Query OK, 0 rows affected (0.06 sec)

mysql>
mysql> SELECT * FROM BG;
Empty set (0.03 sec)

mysql> exit
Bye