← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/insert.result

  • Committer: Brian Aker
  • Date: 2009-05-13 02:07:22 UTC
  • mfrom: (1008.1.5 merge)
  • Revision ID: brian@gaz-20090513020722-9nqehweityhn6ab0
Merge in refactoring around lock system

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/insert.result
56
56
create table t1 (email varchar(50));
57
57
insert into t1 values ('sasha@mysql.com'),('monty@mysql.com'),('foo@hotmail.com'),('foo@aol.com'),('bar@aol.com');
58
58
create table t2(id int not null auto_increment primary key, t2 varchar(50), unique(t2));
59
 
insert delayed into t2 (t2) select distinct substring(email, locate('@', email)+1) from t1;
 
59
insert into t2 (t2) select distinct substring(email, locate('@', email)+1) from t1;
60
60
select * from t2;
61
61
id      t2
62
62
1       mysql.com