Debian Codegraph @

mysql-test/suite/ndb_ddl/create_table_max_record.test

raw
1 --source include/have_ndb.inc
2
3 --echo #
4 --echo # Check creating table with record size at the limits of
5 --echo # what is supported by NDB and MySQL
6 --echo #
7
8 # Record size well below limit
9 CREATE TABLE t1(
10 col1 int unsigned not null primary key,
11 col3 varchar(15000),
12 col4 varchar(14000))
13 charset=latin1 engine=ndbcluster;
14 drop table t1;
15
16 # Record size just below limit
17 CREATE TABLE t2(
18 col1 int unsigned not null primary key,
19 col3 varchar(15000),
20 col4 varchar(14990))
21 charset=latin1 engine=ndbcluster;
22 drop table t2;
23
24 # Record size above NDB limit
25 --error ER_CANT_CREATE_TABLE
26 CREATE TABLE t3_too_large_for_ndb(
27 col1 int unsigned not null primary key,
28 col3 varchar(15000),
29 col4 varchar(14991))
30 charset=latin1 engine=ndbcluster;
31 SHOW WARNINGS;
32
33 # Record size above MySQL limit
34 --error ER_TOO_BIG_ROWSIZE
35 CREATE TABLE t4_too_large_for_mysql(
36 col1 int unsigned not null primary key,
37 col3 varchar(35000),
38 col4 varchar(35000))
39 charset=latin1 engine=ndbcluster;
40