Bug #5389 Opening a MERGE table on QNX results in Error 135
Submitted: 3 Sep 2004 13:16 Modified: 6 Sep 2004 21:13
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:4.0.21 OS:Other (QNX)
Assigned to: Sergei Golubchik CPU Architecture:Any

[3 Sep 2004 13:16] Joerg Bruehe 
Description:
Building the '-debug' version of 4.0.21 on host 'buildqnx', then running the tests, led to this error:

=== cut ===
merge                          [ fail ]

Errors are (from /home/mysqldev/buildqnx/test/mysql-debug-4.0.21-pc-nto-qnx6.2.1-i386/mysql-test/var/log/mysqltest-
time) :
/home/mysqldev/buildqnx/test/mysql-debug-4.0.21-pc-nto-qnx6.2.1-i386/bin/mysqltest: At line 109: query 'select * fr
om t1' failed: 1016: Can't open file: 't1.MRG'. (errno: 135)
(the last line(s) may be the ones that caused the die() in mysqltest)
=== cut ===

Trace mentions 'ha_myisammrg::open' which notes that 'myrg_open' returns 135.

How to repeat:
<ql-debug-4.0.21-pc-nto-qnx6.2.1-i386> ./bin/mysql --debug -u root test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.0.21-debug

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

mysql> create table t1 (a int not null, key(a)) type=merge;
Query OK, 0 rows affected (0.09 sec)

mysql> select * from t1;
ERROR 1016: Can't open file: 't1.MRG'. (errno: 135)
mysql> drop t1;
ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 't1' at line 1
mysql> drop table t1;
Query OK, 0 rows affected (0.04 sec)

mysql> quit
[6 Sep 2004 21:13] Sergei Golubchik 
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

fixed in 4.0.21