Bug #43236 ndb_use_transactions is ignored in 6.4.3

Description:
set ndb_use_transactions=0; is ignored in 6.4.3, works fine in 6.3.20.

How to repeat:
create table t1 (a int);
create table t2 (a int) engine=ndb;
// insert 100,000 rows into t1
set ndb_use_transactions=0;
insert into t2 select * from t1;

ERROR 1297 (HY000): Got temporary error 233 'Out of operation records in transaction coordinator (increase MaxNoOfConcurrentOperations)' from NDBCLUSTER

I encountered a similar problem on MySQL Cluster 7.0.4. When altering a large table from MyISAM to NDB, the same error happened. I can alter the same table from MyISAM to NDB on 6.3.23 without any problem. The table has approx 1.5M rows, generated by DBT-2 benchmark with 5 warehouses.

Proposed patch

Attachment: bug43236.patch (text/x-patch), 4.36 KiB.

Patch adds option checking call to two new startTransaction() calling paths in 7.0 ha_ndbcluster.
Testcase added that should verify that this functionality works, as long as the number of rows inserted is >= the MaxNoOfConcurrentOperations for the cluster being tested.

CREATE TABLE ... AS SELECT also tested.
ALTER TABLE ... ENGINE=NDB also tested.

possibly also add check for alter table

and also btw, maybe add the testcase to 6.3 aswell,
so we don't accidently break it there...

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/71435

2929 Frazer Clement	2009-04-06
      Bug#43236 : ndb_use_transactions is ignored in 6.4.3.  Testcases added to 6.3 + and fix added to 6.4
      modified:
        mysql-test/suite/ndb/r/ndb_load.result
        mysql-test/suite/ndb/t/ndb_load.test

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/71437

2879 Frazer Clement	2009-04-06 [merge]
      Merge 6.3->7.0.  Add fix for bug#43236
      modified:
        mysql-test/suite/ndb/r/ndb_load.result
        mysql-test/suite/ndb/t/ndb_load.test
        sql/ha_ndbcluster.cc

Pushed into 5.1.32-ndb-7.0.5 (revid:frazer@mysql.com-20090406104656-1qm4438ga4akrrob) (version source revid:frazer@mysql.com-20090406104656-1qm4438ga4akrrob) (merge vers: 5.1.32-ndb-7.0.5) (pib:6)

Pushed into 5.1.32-ndb-6.3.25 (revid:frazer@mysql.com-20090406103755-5mxf854inxldconw) (version source revid:frazer@mysql.com-20090406103755-5mxf854inxldconw) (merge vers: 5.1.32-ndb-6.3.25) (pib:6)

Documented bugfix in the NDB-7.0.5 changelog as follows:

        The setting for ndb_use_transactions was ignored. This issue was 
        only known to occur in MySQL Cluster NDB 6.4.3 and MySQL Cluster 
        NDB 7.0.4.

Did not add a changelog entry for NDB-6.3.25 since only test case was pushed to 6.3 tree and actual issue was not found there.