1-- source include/have_ndb.inc 2 3--disable_warnings 4DROP TABLE IF EXISTS t1, t2; 5--enable_warnings 6 7CREATE TABLE t1 ( 8 a bigint unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, 9 b int unsigned not null, 10 c int unsigned 11) engine=ndbcluster; 12 13 14# 15# insert records into table 16# 17let $1=500; 18disable_query_log; 19while ($1) 20{ 21 eval insert into t1 values(NULL, $1+9, 5*$1), (NULL, $1+10, 7),(NULL, $1+10, 7*$1), (NULL, $1+10, 10+$1), (NULL, $1+10, 70*$1), (NULL, $1+10, 7), (NULL, $1+10, 9), (NULL, $1+299, 899), (NULL, $1+10, 12), (NULL, $1+10, 14*$1); 22 dec $1; 23} 24enable_query_log; 25 26select count(*) from t1; 27 28select * from t1 order by a limit 2; 29 30truncate table t1; 31 32select count(*) from t1; 33 34insert into t1 values(NULL,1,1),(NULL,2,2); 35 36select * from t1 order by a; 37 38drop table t1; 39 40# End of 4.1 tests 41