| 1 |
# |
| 2 |
# Check creating table with record size at the limits of |
| 3 |
# what is supported by NDB and MySQL |
| 4 |
# |
| 5 |
CREATE TABLE t1( |
| 6 |
col1 int unsigned not null primary key, |
| 7 |
col3 varchar(15000), |
| 8 |
col4 varchar(14000)) |
| 9 |
charset=latin1 engine=ndbcluster; |
| 10 |
drop table t1; |
| 11 |
CREATE TABLE t2( |
| 12 |
col1 int unsigned not null primary key, |
| 13 |
col3 varchar(15000), |
| 14 |
col4 varchar(14990)) |
| 15 |
charset=latin1 engine=ndbcluster; |
| 16 |
drop table t2; |
| 17 |
CREATE TABLE t3_too_large_for_ndb( |
| 18 |
col1 int unsigned not null primary key, |
| 19 |
col3 varchar(15000), |
| 20 |
col4 varchar(14991)) |
| 21 |
charset=latin1 engine=ndbcluster; |
| 22 |
ERROR HY000: Can't create table 't3_too_large_for_ndb' (use SHOW WARNINGS for more info). |
| 23 |
SHOW WARNINGS; |
| 24 |
Level Code Message |
| 25 |
Warning 1296 Got error 738 'Record too big' from NDB |
| 26 |
Error 1005 Can't create table 't3_too_large_for_ndb' (use SHOW WARNINGS for more info). |
| 27 |
CREATE TABLE t4_too_large_for_mysql( |
| 28 |
col1 int unsigned not null primary key, |
| 29 |
col3 varchar(35000), |
| 30 |
col4 varchar(35000)) |
| 31 |
charset=latin1 engine=ndbcluster; |
| 32 |
ERROR 42000: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs |