You cannot create a temporary table as TYPE=MERGE. I have tried it using both a temporary and a "normal" on-disk table in the UNION paramater without success. This might be useful to, say, the guy who posted thread "Tuple length Question" earlier today...:) I'm sure you can duplicate this on any platform so I'm not going to bother with actual mysqlbug output unless a MySQL A.B. person wishes me to do so. This could easily end up being a documentation bug, with the fix to document that it is not possible to create temporary merge tables. :) --- Jeff S Wheeler [EMAIL PROTECTED] Software Development Five Elements, Inc http://www.five-elements.com/~jsw/ mysql> CREATE TABLE language_en (id INT NOT NULL); Query OK, 0 rows affected (0.04 sec) mysql> CREATE TEMPORARY TABLE language (id INT NOT NULL) TYPE=MERGE UNION=(language_en); ERROR 1017: Can't find file: '#sql3f8_1_0.MRG' (errno: 2) mysql> CREATE TABLE language (id INT NOT NULL) TYPE=MERGE UNION=(language_en); Query OK, 0 rows affected (0.00 sec) mysql> DROP TABLE language; Query OK, 0 rows affected (0.01 sec) mysql> DROP TABLE language_en; Query OK, 0 rows affected (0.00 sec) mysql> CREATE TEMPORARY TABLE language_en (id INT NOT NULL); Query OK, 0 rows affected (0.00 sec) mysql> CREATE TEMPORARY TABLE language (id INT NOT NULL) TYPE=MERGE UNION=(language_en); ERROR 1017: Can't find file: '#sql3f8_1_2.MRG' (errno: 2) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
