← Back to branch summary

~akopytov/percona-server/slow_extended_and_rtd_fixes-5.5

« back to all changes in this revision

Viewing changes to mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.test

  • Committer: Alexey Kopytov
  • Date: 2011-09-07 14:00:24 UTC
  • mfrom: (140.1.19 merge)
  • Revision ID: akopytov@gmail.com-20110907140024-a8dvq86m5pxh9pxy
Manual merge from trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/memory_dynamic_rows.patch/percona_heap_bug784468.test
1
 
#
2
 
# Bug #784468: Tables with VARCHAR(<31) are created as row_format = Fixed
3
 
#
4
 
 
5
 
CREATE TABLE t1 ( f1 VARCHAR(30)) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
6
 
--replace_column 8 X
7
 
SHOW TABLE STATUS LIKE 't1';
8
 
DROP TABLE t1;
9
 
 
10
 
CREATE TABLE t1 ( f1 VARCHAR(31)) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
11
 
--replace_column 8 X
12
 
SHOW TABLE STATUS LIKE 't1';
13
 
DROP TABLE t1;
14
 
 
15
 
CREATE TABLE t1 ( f1 VARCHAR(32)) ENGINE=HEAP ROW_FORMAT=DYNAMIC;
16
 
--replace_column 8 X
17
 
SHOW TABLE STATUS LIKE 't1';
18
 
DROP TABLE t1;
19