← Back to branch summary

~clint-fewbar/drizzle/regex-policy-cache-limiter

« back to all changes in this revision

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

  • Committer: Clint Byrum
  • Date: 2012-03-15 18:05:43 UTC
  • mfrom: (2224.1.302 workspace)
  • Revision ID: clint@ubuntu.com-20120315180543-9jxxm4q10k3np2ws
merging with latest trunk

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/pbxt/tests/r/basic_create_select.result
1
 
SET SESSION storage_engine=pbxt;
2
 
create table t1 (d int primary key);
3
 
create table t2 (d int primary key);
4
 
insert into t1 values ("100000000");
5
 
insert into t2 values (2);
6
 
create table t3 (d int primary key) as select t2.d from t2 union select t1.d from t1;
7
 
select * from t3;
8
 
d
9
 
2
10
 
100000000
11
 
show create table t3;
12
 
Table   Create Table
13
 
t3      CREATE TABLE `t3` (
14
 
  `d` INT NOT NULL,
15
 
  PRIMARY KEY (`d`)
16
 
) ENGINE=DEFAULT COLLATE = utf8_general_ci
17
 
drop table t1, t2, t3;