Debian Codegraph @

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

raw
1 --result_format 2
2 --source include/have_ndb.inc
3
4 use test;
5
6 --disable_query_log
7 create table commacomma (
8 id int not null primary key,
9 `,` int,
10 ```` int,
11 `name.with.dots` int
12 ) engine=ndb;
13
14 create table allprimitives (
15 id int not null primary key,
16
17 int_not_null_hash int not null,
18 int_not_null_btree int not null,
19 int_not_null_both int not null,
20 int_not_null_none int not null,
21 int_null_hash int,
22 int_null_btree int,
23 int_null_both int,
24 int_null_none int,
25
26 byte_not_null_hash tinyint not null,
27 byte_not_null_btree tinyint not null,
28 byte_not_null_both tinyint not null,
29 byte_not_null_none tinyint not null,
30 byte_null_hash tinyint,
31 byte_null_btree tinyint,
32 byte_null_both tinyint,
33 byte_null_none tinyint,
34
35 short_not_null_hash smallint not null,
36 short_not_null_btree smallint not null,
37 short_not_null_both smallint not null,
38 short_not_null_none smallint not null,
39 short_null_hash smallint,
40 short_null_btree smallint,
41 short_null_both smallint,
42 short_null_none smallint,
43
44 long_not_null_hash bigint not null,
45 long_not_null_btree bigint not null,
46 long_not_null_both bigint not null,
47 long_not_null_none bigint not null,
48 long_null_hash bigint,
49 long_null_btree bigint,
50 long_null_both bigint,
51 long_null_none bigint
52 ) ENGINE=ndbcluster DEFAULT CHARSET=latin1;
53 --enable_query_log
54
55 -- echo See truncated column list
56 select substring(columns, -20)
57 from ndbinfo.events where name = 'REPL$test/allprimitives';
58 -- echo See quoted column names
59 select columns from ndbinfo.events where name = 'REPL$test/commacomma';
60
61 DROP table allprimitives;
62 DROP table commacomma;
63