• Guilhem Bichot's avatar
    Fix for BUG#36104 "INFORMATION_SCHEMA.TABLES shows TRANSACTIONAL=1 twice in CREATE_OPTIONS" · cd8f6a1e
    Guilhem Bichot authored
    mysql-test/r/maria.result:
      result; before the bugfix it would be "TRANSACTIONAL=1 transactional=1"
    mysql-test/t/maria.test:
      test for BUG#36104 "INFORMATION_SCHEMA.TABLES shows TRANSACTIONAL=1 twice in CREATE_OPTIONS"
    sql-bench/example:
      doblewrite->doublewrite
    sql/mysqld.cc:
      fix of a wrong 5.1->maria merge of the past
    sql/sql_insert.cc:
      removing my old idea of disabling transactionality in CREATE SELECT:
      1) it caused bugs because re-enabling (ha_enable_transaction()) causes implicit commit, so in complex cases
      like "CREATE SELECT some_func())", where some_func() would want to insert two rows in another table, and fail on the second row, the implicit commit would commit the inserted row, while it should roll back.
      2) it's not needed anymore, because CREATE SELECT uses bulk insert, and Maria has transactionality disabled by
      bulk insert.
    sql/sql_show.cc:
      This was duplicate code, causing BUG#36104 "INFORMATION_SCHEMA.TABLES shows TRANSACTIONAL=1 twice in CREATE_OPTIONS"
    cd8f6a1e
example 1.49 KB