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

« back to all changes in this revision

Viewing changes to plugin/pbxt/tests/t/basic_create_select.test

  • 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:
1
 
--source include/have_linux.inc
2
 
--source include/not_valgrind.inc
3
 
SET SESSION storage_engine=pbxt;
4
 
create table t1 (d int primary key);
5
 
create table t2 (d int primary key);
6
 
insert into t1 values ("100000000");
7
 
insert into t2 values (2);
8
 
create table t3 (d int primary key) as select t2.d from t2 union select t1.d from t1;
9
 
select * from t3;
10
 
--replace_regex /ENGINE=[a-zA-Z]+/ENGINE=DEFAULT/
11
 
show create table t3;
12
 
drop table t1, t2, t3;
13