~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/mysql_protocol.result

  • Committer: Padraig O'Sullivan
  • Date: 2009-03-30 18:27:35 UTC
  • mto: (968.2.5 mordred)
  • mto: This revision was merged to the branch mainline in revision 971.
  • Revision ID: osullivan.padraig@gmail.com-20090330182735-8tor89czwodcv77s
Removing the last of LIST from the MyISAM storage engine.

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
DROP TABLE IF EXISTS t1;
2
 
CREATE TABLE t1(a int, key (a));
3
 
INSERT INTO t1 VALUES (1), (2);
4
 
 
5
 
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
6
 
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
7
 
DROP TABLE IF EXISTS `t1`;
8
 
CREATE TABLE `t1` (
9
 
  `a` INT DEFAULT NULL,
10
 
  KEY `a` (`a`)
11
 
) ENGINE='InnoDB' COLLATE='utf8_general_ci';
12
 
 
13
 
ALTER TABLE `t1` DISABLE KEYS;
14
 
INSERT INTO `t1` VALUES (1),(2);
15
 
ALTER TABLE `t1` ENABLE KEYS;
16
 
 
17
 
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
18
 
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
19
 
DROP TABLE t1;
20
 
drizzled is alive