Debian Codegraph @

mysql-test/suite/ndb_big/bug14000373.result

raw
1 set max_heap_table_size = 286720000;
2 create table t1 (a int key) engine=memory;
3 load data local infile 'suite/ndb/data/table_data10000.dat' into table t1 columns terminated by ' ' (a, @col2);
4 insert into t1 select a + 10000 from t1;;
5 insert into t1 select a + 10000 * 2 from t1;;
6 insert into t1 select a + 10000 * 2 * 2 from t1;;
7 insert into t1 select a + 10000 * 2 * 2 * 2 from t1;;
8 insert into t1 select a + 10000 * 2 * 2 * 2 * 2 from t1;;
9 insert into t1 select a + 10000 * 2 * 2 * 2 * 2 * 2 from t1;;
10 insert into t1 select a + 10000 * 2 * 2 * 2 * 2 * 2 * 2 from t1;;
11 insert into t1 select a + 10000 * 2 * 2 * 2 * 2 * 2 * 2 * 2 from t1;;
12 insert into t1 select a + 10000 * 2 * 2 * 2 * 2 * 2 * 2 * 2 * 2 from t1;;
13 select count(*) from t1;
14 count(*)
15 5120000
16 alter table t1 engine=ndbcluster comment='NDB_TABLE=NOLOGGING' partition by key() partitions 1;
17 alter table t1 engine=memory;
18 select count(*) from t1;
19 count(*)
20 5120000
21 drop table t1;