← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/haildb/tests/r/index_read_res_check.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:
plugin/haildb/tests/r/index_read_res_check.result
1
 
DROP TABLE IF EXISTS `sbtest`;
2
 
Warnings:
3
 
Note    1051    Unknown table 'sbtest'
4
 
CREATE TABLE `sbtest` (
5
 
`id` INT NOT NULL AUTO_INCREMENT,
6
 
`k` INT NOT NULL DEFAULT '0',
7
 
`o` INT NOT NULL DEFAULT '0',
8
 
`c` VARCHAR(120) NOT NULL COLLATE utf8_general_ci,
9
 
`pad` VARCHAR(60) NOT NULL COLLATE utf8_general_ci,
10
 
PRIMARY KEY (`id`),
11
 
KEY `k` (`k`),
12
 
KEY `o` (`o`)
13
 
) ENGINE='InnoDB' AUTO_INCREMENT=1 COLLATE='utf8_general_ci';
14
 
ALTER TABLE `sbtest` DISABLE KEYS;
15
 
Warnings:
16
 
Note    1031    Table storage engine for 'sbtest' doesn't have this option
17
 
BEGIN;
18
 
ALTER TABLE `sbtest` ENABLE KEYS;
19
 
Warnings:
20
 
Note    1031    Table storage engine for 'sbtest' doesn't have this option
21
 
select *  from sbtest where k=5003;
22
 
id      k       o       c       pad
23
 
5003    5003    5003            qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt
24
 
DROP TABLE sbtest;