~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/type_blob.result

  • Committer: Olaf van der Spek
  • Date: 2011-08-04 08:13:04 UTC
  • mfrom: (2384 drizzle)
  • mto: This revision was merged to the branch mainline in revision 2385.
  • Revision ID: olafvdspek@gmail.com-20110804081304-rlejjpvoos17bjdf
Merge trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
343
343
Table   Create Table
344
344
t1      CREATE TABLE `t1` (
345
345
  `a` TEXT COLLATE utf8_general_ci,
346
 
  KEY `a` (`a`(255))
 
346
  KEY `a` (`a`(255)) USING BTREE
347
347
) ENGINE=DEFAULT COLLATE = utf8_general_ci
348
348
drop table t1;
349
349
CREATE TABLE t1 (
590
590
  `c` BLOB NOT NULL,
591
591
  `d` INT NOT NULL,
592
592
  `e` INT DEFAULT NULL,
593
 
  PRIMARY KEY (`a`,`b`,`c`(255),`d`),
594
 
  KEY `a` (`a`,`b`,`d`,`e`)
 
593
  PRIMARY KEY (`a`,`b`,`c`(255),`d`) USING BTREE,
 
594
  KEY `a` (`a`,`b`,`d`,`e`) USING BTREE
595
595
) ENGINE=DEFAULT COLLATE = utf8_general_ci
596
596
drop table t1;
597
597
CREATE table t1 (a blob);