--source include/have_ndb.inc SET SESSION storage_engine='NDB'; --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings CREATE TABLE t1 ( f_int1 INTEGER, f_int2 INTEGER, f_char1 CHAR(10), f_char2 CHAR(10), f_charbig VARCHAR(1000) ) PARTITION BY HASH(f_int1) PARTITIONS 2; # It looks like this record is needed. INSERT INTO t1 SET f_int1 = 4, f_int2 = 4, f_char1 = '4', f_char2 = '4', f_charbig = '===4==='; # It looks like INSERT + DELETE of this record is needed. INSERT INTO t1 SET f_int1 = 3, f_int2 = 3, f_char1 = '3', f_char2 = '3', f_charbig = 'delete me'; DELETE FROM t1 WHERE f_charbig = 'delete me'; let $num2 = 300; while ($num2) { eval SELECT COUNT(*) FROM t1 WHERE f_int1 = 1; dec $num2; }