| 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 |
|