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