not able to create merge table properly

------_=_NextPart_001_01C62132.6E8CF210
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

I have two myisam table usr1 and usr2.

I'm trying to create a merge table out of usr1 and usr2. The merge table
create is successful, but I'm not able to do any operation it says
'Can't open file: 'usrmerge.MRG' (errorno: 143).

Any help will be greatly appreciated.

=20

=20

mysql> create table usrmerge (

-> ID BIGINT NOT NULL,

-> AUTHROLE VARCHAR(32),

-> AUTHSERVERIPADDRESS VARCHAR(15),

-> AUTHTYPE INTEGER,

-> COMPUTERNAME VARCHAR(32),

-> ENTRYSTATUS INTEGER,

-> IPADDRESS VARCHAR(15),

-> AUTHSTATE INTEGER,

-> LOGINTIME BIGINT,

-> LOGOUTTIME BIGINT,

-> MACADDRESS VARCHAR(17),

-> NAME VARCHAR(32),

-> NETWORKACCESSPOINT VARCHAR(32),

-> TIDALDEVICEIPADDRESS VARCHAR(15),

-> TIDALDEVICEPHYSICALPORT INTEGER,

-> DEVICESPECIFICID BIGINT,

-> TIDALDEVICEPHYSICALSLOT INTEGER,

-> VLANID INTEGER,

-> TIDALDEVICEID BIGINT)

-> engine=3Dmerge union(usr1, usr2);

Query OK, 0 rows affected (0.02 sec)

=20

mysql> desc usrmerge;

ERROR 1016 (HY000): Can't open file: 'usrmerge.MRG' (errno: 143)

mysql> show table status like 'usr%';

+----------+--------+---------+------------+------+--------- -------+----
---------+-----------------+--------------+-----------+---

-------------+---------------------+---------------------+-- ----------+-
------------------+----------+----------------+-----------

-----------------------------------+

| Name | Engine | Version | Row_format | Rows | Avg_row_length |
Data_length | Max_data_length | Index_length | Data_free | Au

to_increment | Create_time | Update_time | Check_time |
Collation | Checksum | Create_options | Comment

|

+----------+--------+---------+------------+------+--------- -------+----
---------+-----------------+--------------+-----------+---

-------------+---------------------+---------------------+-- ----------+-
------------------+----------+----------------+-----------

-----------------------------------+

| usr | InnoDB | 9 | Dynamic | 494 | 331 |
163840 | NULL | 16384 | 0 |

NULL | 2006-01-03 11:29:23 | NULL | NULL |
latin1_swedish_ci | NULL | | InnoDB fre

e: 2247680 kB |

| usr1 | MyISAM | 9 | Dynamic | 620 | 144 |
89280 | 4294967295 | 1024 | 0 |

NULL | 2006-01-24 13:55:41 | 2006-01-24 13:55:42 | NULL |
latin1_swedish_ci | NULL | |

|

| usr2 | MyISAM | 9 | Dynamic | 620 | 144 |
89280 | 4294967295 | 1024 | 0 |

NULL | 2006-01-24 13:55:57 | 2006-01-24 13:55:57 | NULL |
latin1_swedish_ci | NULL | |

|

| usrmerge | NULL | NULL | NULL | NULL | NULL |
NULL | NULL | NULL | NULL |

NULL | NULL | NULL | NULL |
NULL | NULL | NULL | Can't open

file: 'usrmerge.MRG' (errno: 143) |

+----------+--------+---------+------------+------+--------- -------+----
---------+-----------------+--------------+-----------+---

-------------+---------------------+---------------------+-- ----------+-
------------------+----------+----------------+-----------

-----------------------------------+

4 rows in set (0.00 sec)

=20

Ila.

=20


------_=_NextPart_001_01C62132.6E8CF210--