|
244.1.1
by Harrison Fisk
Port Ebay/Google memory storage engine variable width columns. |
1 |
drop table if exists t1; |
|
1502.1.29
by Brian Aker
Another option removed. |
2 |
set @@session.max_heap_table_size=16*1024*1024*24; |
3 |
create temporary table t1 (a int not null, b int, c varchar(400), d varchar(400), primary key (a), key (b)) engine=MEMORY comment="testing heaps"; |
|
|
1273.19.12
by Brian Aker
Enabled more tests. |
4 |
show table status like "t1"; |
|
1320.1.18
by Brian Aker
Overhaul of SHOW TABLE STATUS. |
5 |
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment |
6 |
# test t1 TEMPORARY MEMORY # # # # #
|
|
|
244.1.1
by Harrison Fisk
Port Ebay/Google memory storage engine variable width columns. |
7 |
insert into t1 values (1,1,'012',NULL), (2,2,'0123456789',NULL), (3,3,'012345678901234567890123456789',NULL), (4,4,NULL,'0123456789012345678901234567890123456789012345678901234567890123456789'); |
8 |
select * from t1; |
|
9 |
a b c d |
|
10 |
1 1 012 NULL |
|
11 |
2 2 0123456789 NULL |
|
12 |
3 3 012345678901234567890123456789 NULL |
|
13 |
4 4 NULL 0123456789012345678901234567890123456789012345678901234567890123456789 |
|
14 |
delete from t1 where a = 3; |
|
15 |
select * from t1; |
|
16 |
a b c d |
|
17 |
1 1 012 NULL |
|
18 |
2 2 0123456789 NULL |
|
19 |
4 4 NULL 0123456789012345678901234567890123456789012345678901234567890123456789 |
|
20 |
insert into t1 values (5,5,NULL,'0123'), (6,6,NULL,'0123'); |
|
21 |
select * from t1; |
|
22 |
a b c d |
|
23 |
1 1 012 NULL |
|
24 |
2 2 0123456789 NULL |
|
25 |
5 5 NULL 0123 |
|
26 |
4 4 NULL 0123456789012345678901234567890123456789012345678901234567890123456789 |
|
|
1502.1.29
by Brian Aker
Another option removed. |
27 |
6 6 NULL 0123 |
|
244.1.1
by Harrison Fisk
Port Ebay/Google memory storage engine variable width columns. |
28 |
update t1 set c = '012345678901234567890123456789' where a = 2; |
29 |
select * from t1; |
|
30 |
a b c d |
|
31 |
1 1 012 NULL |
|
32 |
2 2 012345678901234567890123456789 NULL |
|
33 |
5 5 NULL 0123 |
|
34 |
4 4 NULL 0123456789012345678901234567890123456789012345678901234567890123456789 |
|
|
1502.1.29
by Brian Aker
Another option removed. |
35 |
6 6 NULL 0123 |
|
244.1.1
by Harrison Fisk
Port Ebay/Google memory storage engine variable width columns. |
36 |
update t1 set c = '0123456789' where a = 2; |
37 |
select * from t1; |
|
38 |
a b c d |
|
39 |
1 1 012 NULL |
|
40 |
2 2 0123456789 NULL |
|
41 |
5 5 NULL 0123 |
|
42 |
4 4 NULL 0123456789012345678901234567890123456789012345678901234567890123456789 |
|
|
1502.1.29
by Brian Aker
Another option removed. |
43 |
6 6 NULL 0123 |
|
244.1.1
by Harrison Fisk
Port Ebay/Google memory storage engine variable width columns. |
44 |
insert into t1 values (7,7,'0123',NULL), (8,8,'0123',NULL); |
45 |
select * from t1; |
|
46 |
a b c d |
|
47 |
1 1 012 NULL |
|
48 |
2 2 0123456789 NULL |
|
|
1502.1.29
by Brian Aker
Another option removed. |
49 |
5 5 NULL 0123 |
50 |
4 4 NULL 0123456789012345678901234567890123456789012345678901234567890123456789 |
|
51 |
6 6 NULL 0123 |
|
|
244.1.1
by Harrison Fisk
Port Ebay/Google memory storage engine variable width columns. |
52 |
7 7 0123 NULL |
53 |
8 8 0123 NULL |
|
54 |
delete from t1; |
|
55 |
select * from t1; |
|
56 |
a b c d |
|
57 |
select count(*) from t1; |
|
58 |
count(*) |
|
59 |
10001
|
|
60 |
insert into t1 values (100000,100000,NULL,'0123'), (100000,100000,NULL,'0123'); |
|
|
1116.1.2
by Brian Aker
Remove options which are just for internal optimizations. |
61 |
ERROR 23000: Duplicate entry '100000' for key 'PRIMARY' |
|
1273.19.12
by Brian Aker
Enabled more tests. |
62 |
show table status like "t1"; |
|
1320.1.18
by Brian Aker
Overhaul of SHOW TABLE STATUS. |
63 |
Session Schema Name Type Engine Version Rows Avg_row_length Table_size Auto_increment |
64 |
# test t1 TEMPORARY MEMORY # # # # #
|
|
|
244.1.1
by Harrison Fisk
Port Ebay/Google memory storage engine variable width columns. |
65 |
select count(*) from t1; |
66 |
count(*) |
|
|
1116.1.2
by Brian Aker
Remove options which are just for internal optimizations. |
67 |
10002
|
|
244.1.1
by Harrison Fisk
Port Ebay/Google memory storage engine variable width columns. |
68 |
set @@session.max_heap_table_size=default; |
69 |
drop table t1; |