← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/blitzdb/tests/t/alter.test

  • Committer: Padraig O'Sullivan
  • Date: 2009-07-22 23:26:26 UTC
  • mto: (1039.5.43 replication)
  • mto: This revision was merged to the branch mainline in revision 1130.
  • Revision ID: osullivan.padraig@gmail.com-20090722232626-mu4khq7ho6dqcf7q
Created a simple filtered replicator that can filter by schema name or table
name.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/blitzdb/tests/t/alter.test
1
 
# Test Suite for ALTER TABLE syntax
2
 
 
3
 
--disable_warnings
4
 
drop table if exists t1;
5
 
--enable_warnings
6
 
 
7
 
# Test Case for Bug:588487 from Patric Crews
8
 
# Using 'ALTER TABLE <> ENABLE KEYS' on a BlitzDB table locks up the server
9
 
 
10
 
--warning 1071
11
 
CREATE TABLE `t1` (
12
 
  `col_varchar_10_key` varchar(10),
13
 
  `col_varchar_10` varchar(10),
14
 
  `col_int` int,
15
 
  `col_varchar_1024_key` varchar(1024),
16
 
  `col_varchar_1024` varchar(1024),
17
 
  `col_int_key` int,
18
 
  pk integer auto_increment,
19
 
  /*Indices*/
20
 
  key (`col_varchar_10_key` ),
21
 
  key (`col_varchar_1024_key` ),
22
 
  key (`col_int_key` ),
23
 
  primary key (pk)
24
 
) ENGINE=blitzdb ;
25
 
 
26
 
--error ER_UNSUPPORTED_EXTENSION
27
 
ALTER TABLE `t1` DISABLE KEYS;
28
 
--error ER_UNSUPPORTED_EXTENSION
29
 
ALTER TABLE `t1` ENABLE KEYS;
30
 
 
31
 
DROP TABLE `t1`;