1#
2# BLOB column types
3#
4
5--disable_warnings
6DROP TABLE IF EXISTS t1;
7--enable_warnings
8
9eval CREATE TABLE t1 (
10  pk INT AUTO_INCREMENT PRIMARY KEY,
11  b BLOB $extra_col_opts,
12  b0 BLOB(0) $extra_col_opts,
13  b1 BLOB(1) $extra_col_opts,
14  b300 BLOB(300) $extra_col_opts,
15  bm BLOB(65535) $extra_col_opts,
16  b70k BLOB(70000) $extra_col_opts,
17  b17m BLOB(17000000) $extra_col_opts,
18  t TINYBLOB $extra_col_opts,
19  m MEDIUMBLOB $extra_col_opts,
20  l LONGBLOB $extra_col_opts
21) ENGINE=rocksdb;
22
23SHOW COLUMNS IN t1;
24
25# Valid values
26# (cannot get MAX for all columns due to max_allowed_packet limitations)
27
28INSERT INTO t1 (b,b0,b1,b300,bm,b70k,b17m,t,m,l) VALUES
29('','','','','','','','','',''),
30('a','b','c','d','e','f','g','h','i','j'),
31('test1','test2','test3','test4','test5','test6','test7','test8','test9','test10'),
32( REPEAT('a',65535), REPEAT('b',65535), REPEAT('c',255), REPEAT('d',65535), REPEAT('e',65535), REPEAT('f',1048576), HEX(REPEAT('g',1048576)), REPEAT('h',255), REPEAT('i',1048576), HEX(REPEAT('j',1048576)) );
33
34--sorted_result
35SELECT LENGTH(b), LENGTH(b0), LENGTH(b1), LENGTH(b300), LENGTH(bm), LENGTH(b70k), LENGTH(b17m), LENGTH(t), LENGTH(m), LENGTH(l) FROM t1;
36
37# Invalid values (produce warnings, except for mediumblob and longblob columns for which the values are within limits)
38
39INSERT INTO t1 (b,b0,b1,b300,bm,b70k,b17m,t,m,l) VALUES
40( REPEAT('a',65536), REPEAT('b',65536), REPEAT('c',256), REPEAT('d',65536), REPEAT('e',65536), REPEAT('f',1048576), REPEAT('g',1048576), REPEAT('h',256), REPEAT('i',1048576), REPEAT('j',1048576) );
41
42--sorted_result
43SELECT LENGTH(b), LENGTH(b0), LENGTH(b1), LENGTH(b300), LENGTH(bm), LENGTH(b70k), LENGTH(b17m), LENGTH(t), LENGTH(m), LENGTH(l) FROM t1;
44
45--error ER_TOO_BIG_DISPLAYWIDTH
46ALTER TABLE t1 ADD COLUMN bbb BLOB(4294967296);
47
48DROP TABLE t1;
49
50