~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/myisam-blob.result

  • Committer: Brian Aker
  • Date: 2009-06-16 00:53:22 UTC
  • mto: This revision was merged to the branch mainline in revision 1094.
  • Revision ID: brian@gaz-20090616005322-w0ode4jul9z8s2y9
Partial fix for tests for tmp

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
1
drop table if exists t1;
2
 
CREATE TEMPORARY TABLE t1 (data LONGBLOB) ENGINE=myisam;
 
2
CREATE TABLE t1 (data LONGBLOB) ENGINE=myisam;
3
3
INSERT INTO t1 (data) VALUES (NULL);
4
4
UPDATE t1 set data=repeat('a',18*1024*1024);
5
5
select length(data) from t1;
33
33
length(data)
34
34
18874368
35
35
drop table t1;
36
 
CREATE TEMPORARY TABLE t1 (data BLOB) ENGINE=myisam;
 
36
CREATE TABLE t1 (data BLOB) ENGINE=myisam;
37
37
INSERT INTO t1 (data) VALUES (NULL);
38
38
UPDATE t1 set data=repeat('a',18*1024*1024);
39
39
select length(data) from t1;