← Back to branch summary

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

« back to all changes in this revision

Viewing changes to plugin/haildb/tests/r/index_prefix.result

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2012-06-19 10:46:49 UTC
  • mfrom: (1.1.6)
  • mto: This revision was merged to the branch mainline in revision 29.
  • Revision ID: package-import@ubuntu.com-20120619104649-e2l0ggd4oz3um0f4
Tags: upstream-7.1.36-stable
Import upstream version 7.1.36-stable

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/haildb/tests/r/index_prefix.result
1
 
create table t1 (a int primary key, b varchar(111), unique index b_idx (b(5)));
2
 
insert into t1 values (1, "foobar"),(2,"barbarbar");
3
 
insert into t1 values (3, "barbarpub");
4
 
Got one of the listed errors
5
 
select * from t1;
6
 
a       b
7
 
1       foobar
8
 
2       barbarbar
9
 
drop table t1;
10
 
create table t2 (a int primary key, b varbinary(111), unique index b_idx (b(5)));
11
 
insert into t2 values (1, "foobar"),(2,"barbarbar");
12
 
insert into t2 values (3, "barbarpub");
13
 
Got one of the listed errors
14
 
select * from t2;
15
 
a       b
16
 
1       foobar
17
 
2       barbarbar
18
 
drop table t2;