← 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_bug788544.result

  • 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_bug788544.result
1
 
CREATE TABLE t1 (f2 VARCHAR (32), f4 LONGBLOB, f5 TEXT) ENGINE=HEAP;
2
 
INSERT INTO t1 VALUES ('a', NULL, NULL),
3
 
('b' , REPEAT('a' , 593338), REPEAT('a', 800));
4
 
UPDATE t1 SET f2 = 'c' WHERE f4 = 'd';
5
 
SELECT LENGTH(f2), LENGTH(f4), LENGTH(f5) FROM t1;
6
 
LENGTH(f2)      LENGTH(f4)      LENGTH(f5)
7
 
1       NULL    NULL
8
 
1       593338  800
9
 
DROP TABLE t1;