Debian Codegraph @

mysql-test/suite/ndb/t/ndb_dd_debug.test

raw
1 -- source include/have_ndb.inc
2 -- source include/have_debug.inc
3
4 # Setup disk data
5
6 CREATE LOGFILE GROUP lg
7 ADD UNDOFILE 'undofile.dat'
8 INITIAL_SIZE 16M
9 UNDO_BUFFER_SIZE = 1M
10 ENGINE=NDB;
11
12 CREATE TABLESPACE ts1
13 ADD DATAFILE 'datafile.dat'
14 USE LOGFILE GROUP lg
15 INITIAL_SIZE 30M
16 EXTENT_SIZE 256K
17 ENGINE NDB;
18
19 # Create table with many disk columns and check that disk scan is selected for
20 # table scan.
21
22 set @save_debug = @@session.debug;
23 set debug='+d,ndb_disk_scan';
24
25 let $n = 255;
26 let $i = 1;
27 let $columns = pk int PRIMARY KEY;
28 while ($i <= $n) {
29 let $columns =$columns, col$i BINARY(10) DEFAULT NULL;
30 inc $i;
31 }
32
33 # 255 disk columns
34
35 echo CREATE TABLE t1 (255 disk columns) TABLESPACE ts1 STORAGE DISK ENGINE=NDB;
36 disable_query_log;
37 eval CREATE TABLE t1 ($columns)
38 TABLESPACE ts1 STORAGE DISK ENGINE=NDB;
39 enable_query_log;
40 INSERT INTO t1 (pk) VALUES (1),(2),(3),(4),(5),(6),(7);
41 SELECT col17 FROM t1;
42 DROP TABLE t1;
43
44 # 256 disk columns
45
46 let $columns =$columns, col$i BINARY(10) DEFAULT NULL;
47 echo CREATE TABLE t1 (256 disk columns) TABLESPACE ts1 STORAGE DISK ENGINE=NDB;
48 disable_query_log;
49 eval CREATE TABLE t1 ($columns)
50 TABLESPACE ts1 STORAGE DISK ENGINE=NDB;
51 enable_query_log;
52 INSERT INTO t1 (pk) VALUES (1),(2),(3),(4),(5),(6),(7);
53 SELECT col17 FROM t1;
54 DROP TABLE t1;
55
56 set session debug=@save_debug;
57
58 # Cleanup disk data
59
60 ALTER TABLESPACE ts1
61 DROP DATAFILE 'datafile.dat';
62 DROP TABLESPACE ts1;
63
64 DROP LOGFILE GROUP lg
65 ENGINE=NDB;
66