← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to plugin/memory/tests/r/basic.result

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2012-06-19 10:46:49 UTC
  • mfrom: (1.1.6)
  • mto: This revision was merged to the branch mainline in revision 29.
  • Revision ID: package-import@ubuntu.com-20120619104649-e2l0ggd4oz3um0f4
Tags: upstream-7.1.36-stable
Import upstream version 7.1.36-stable

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/memory/tests/r/basic.result
321
321
  `v` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,
322
322
  `c` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,
323
323
  `t` VARCHAR(50) COLLATE utf8_general_ci DEFAULT NULL,
324
 
  KEY `v` (`v`),
325
 
  KEY `c` (`c`),
326
 
  KEY `t` (`t`(10))
 
324
  KEY `v` (`v`) USING HASH,
 
325
  KEY `c` (`c`) USING HASH,
 
326
  KEY `t` (`t`(10)) USING HASH
327
327
) ENGINE=MEMORY COLLATE = utf8_general_ci
328
328
select count(*) from t1;
329
329
count(*)
635
635
  `v` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,
636
636
  `c` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL,
637
637
  `t` VARCHAR(50) COLLATE utf8_general_ci DEFAULT NULL,
638
 
  KEY `v` (`v`(5)),
639
 
  KEY `c` (`c`(5)),
640
 
  KEY `t` (`t`(5))
 
638
  KEY `v` (`v`(5)) USING HASH,
 
639
  KEY `c` (`c`(5)) USING HASH,
 
640
  KEY `t` (`t`(5)) USING HASH
641
641
) ENGINE=MEMORY COLLATE = utf8_general_ci
642
642
drop table t1;
643
643
create temporary table t1 (v varchar(16383), key(v(10)));
645
645
Table   Create Table
646
646
t1      CREATE TEMPORARY TABLE `t1` (
647
647
  `v` VARCHAR(16383) COLLATE utf8_general_ci DEFAULT NULL,
648
 
  KEY `v` (`v`(10))
 
648
  KEY `v` (`v`(10)) USING HASH
649
649
) ENGINE=MEMORY COLLATE = utf8_general_ci
650
650
insert into t1 values(repeat('a',16383));
651
651
select length(v) from t1 where v=repeat('a',16383);