~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/heap_var.result

  • Committer: Brian Aker
  • Date: 2009-08-18 07:20:29 UTC
  • mfrom: (1117.1.9 merge)
  • Revision ID: brian@gaz-20090818072029-s9ch5lcmltxwidn7
Merge of Brian

Show diffs side-by-side

added added

removed removed

Lines of Context:
54
54
8       8       0123    NULL
55
55
alter table t1 block_size = 0;
56
56
alter table t1 row_format = dynamic;
57
 
alter table t1 block_size = 128, max_rows = 10001;
 
57
alter table t1 block_size = 128;
58
58
select * from t1;
59
59
a       b       c       d
60
60
1       1       012     NULL
71
71
count(*)
72
72
10001
73
73
insert into t1 values (100000,100000,NULL,'0123'), (100000,100000,NULL,'0123');
74
 
ERROR HY000: The table 't1' is full
 
74
ERROR 23000: Duplicate entry '100000' for key 'PRIMARY'
75
75
select count(*) from t1;
76
76
count(*)
77
 
10001
 
77
10002
78
78
set @@session.max_heap_table_size=default;
79
79
drop table t1;