Re: Parition

[Phil Hildebrand]

Did you try Hartmut's suggestion? (show warnings)

the issue I saw was related to SQL_MODE (I had the SQL_MODE set to ORACLE, which does not print out engine types for show create table)

I'd try the show warnings to see if there is a warning you are not seeing first, in case the issue is related to innodb not being enabled.

Also - check the information schema for what it says the table engine is:


select table_name,engine from information_schema.tables where table_name like 'XXX';