1
create table t1 (a blob);
2
insert into t1 values ('a'),('aa'),('aaa');
3
select length(a) from t1;
9
create table t1 (pk int auto_increment primary key, a blob);
10
insert into t1 (a) values ('ccc'),('bb'),('a');
11
select pk,length(a) from t1 order by length(a);
16
SELECT libinnodb_datadict_dump();
17
libinnodb_datadict_dump()
18
InnoDB Data Dictionary Contents
19
-------------------------------
20
SYS_FOREIGN Format: REDUNDANT Page size: 0 Columns: 7 Indexes: 3
34
SYS_FOREIGN_COLS Format: REDUNDANT Page size: 0 Columns: 7 Indexes: 1
45
data_dictionary/innodb_table_definitions Format: COMPACT Page size: 0 Columns: 5 Indexes: 1
53
test/t1 Format: COMPACT Page size: 0 Columns: 5 Indexes: 1
63
create table t1 (a blob);
64
insert into t1 values ('aaa'),('aa'),('a');
65
select length(a) from t1 order by length(a);