• Jon Olav Hauglid's avatar
    Bug #21099 MySQL 5.0.22 silently creates MyISAM tables even though · 05f88483
    Jon Olav Hauglid authored
               InnoDB specified.
                
    NO_ENGINE_SUBSTITUTION added to TRADITIONAL sql mode to prevent
    silent conversions from InnoDB to MyISAM in that sql mode.
    
    A number of test case results files updated to reflect this change.
    Test added to sql_mode.test that checks that TRADITIONAL really 
    includes NO_ENGINE_SUBSTITUION.
    
    
    mysql-test/t/ctype_utf8.test:
      This test lacked "--source include/have_innodb.inc" which meant that 
      a number of DDL statements with engine=innodb in reality were using 
      myisam. "--disable_warnings" around all such statements, meant that 
      these engine substitutions were not visible. Test case has been 
      updated to include have_innodb.inc and "--disable_warnings" have been 
      removed for the relevant DDL statements.
    05f88483
sql_mode.test 8.59 KB