← Back to branch summary

~ubuntu-branches/ubuntu/saucy/drizzle/saucy-proposed

« back to all changes in this revision

Viewing changes to plugin/pbxt/tests/r/basic_create_with_index.result

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2011-03-15 10:41:18 UTC
  • mfrom: (1.2.10 upstream)
  • Revision ID: james.westby@ubuntu.com-20110315104118-eaf0hvlytjdl4zrf
Tags: 2011.03.13-0ubuntu1
* New upstream release.
* Added slave plugin.
* Removed archive, blackhole and blitzdb plugins.
* Moved location of libdrizzle headers.
* Removed drizzleadmin manpage patch.
* Add drizzle_safe_write_string to symbols.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/pbxt/tests/r/basic_create_with_index.result
1
 
SET SESSION storage_engine=pbxt;
2
 
CREATE TABLE t1 (a int primary key);
3
 
SHOW CREATE TABLE t1;
4
 
Table   Create Table
5
 
t1      CREATE TABLE `t1` (
6
 
  `a` INT NOT NULL,
7
 
  PRIMARY KEY (`a`)
8
 
) ENGINE=PBXT COLLATE = utf8_general_ci
9
 
DROP TABLE t1;
10
 
CREATE TABLE t2 (a int primary key, b int unique, c varchar(100) unique);
11
 
SHOW CREATE TABLE t2;
12
 
Table   Create Table
13
 
t2      CREATE TABLE `t2` (
14
 
  `a` INT NOT NULL,
15
 
  `b` INT DEFAULT NULL,
16
 
  `c` VARCHAR(100) COLLATE utf8_general_ci DEFAULT NULL,
17
 
  PRIMARY KEY (`a`),
18
 
  UNIQUE KEY `b` (`b`),
19
 
  UNIQUE KEY `c` (`c`)
20
 
) ENGINE=PBXT COLLATE = utf8_general_ci
21
 
DROP TABLE t2;