Is it a bug or a feature that with the conditions
1. INNODB is not configured in my.cnf 2. Table type is specified as INNODB
that when you create the table there is no warning, and no syntax error, and the table type silently and Microsoft-like, defaults to MyISAM?
It is the documented behavior:
http://www.mysql.com/doc/en/CREATE_TABLE.html
See just below the table that lists available table types.
In 4.1.1, the behavior will change such that a warning is generated. You can see the warning message with SHOW WARNINGS.
Now, if you specify table type as TYPE=bullshit, you get a nice (and expected) syntax error.
_justin
-- Justin Farnsworth Eye Integrated Communications 321 South Evans - Suite 203 Greenville, NC 27858 | Tel: (252) 353-0722
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]