~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/blitzdb/tests/r/alter.result

  • Committer: Monty Taylor
  • Date: 2009-10-06 19:14:39 UTC
  • mfrom: (1130.2.18 plugin-base-class)
  • mto: This revision was merged to the branch mainline in revision 1184.
  • Revision ID: mordred@inaugust.com-20091006191439-fd1vvlp22654l3k3
Merged latest plugin-base-class.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
drop table if exists t1;
2
 
CREATE TABLE `t1` (
3
 
`col_varchar_10_key` varchar(10),
4
 
`col_varchar_10` varchar(10),
5
 
`col_int` int,
6
 
`col_varchar_1024_key` varchar(1024),
7
 
`col_varchar_1024` varchar(1024),
8
 
`col_int_key` int,
9
 
pk integer auto_increment,
10
 
/*Indices*/
11
 
key (`col_varchar_10_key` ),
12
 
key (`col_varchar_1024_key` ),
13
 
key (`col_int_key` ),
14
 
primary key (pk)
15
 
) ENGINE=blitzdb ;
16
 
Warnings:
17
 
Warning 1071    Specified key was too long; max key length is 1024 bytes
18
 
ALTER TABLE `t1` DISABLE KEYS;
19
 
ERROR 42000: Table 't1' uses an extension that doesn't exist in this Drizzle version
20
 
ALTER TABLE `t1` ENABLE KEYS;
21
 
ERROR 42000: Table 't1' uses an extension that doesn't exist in this Drizzle version
22
 
DROP TABLE `t1`;