← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/insert_notembedded.result

  • Committer: Monty Taylor
  • Date: 2009-08-12 06:25:19 UTC
  • mto: (1114.1.1 innodb-plugin-merge)
  • mto: This revision was merged to the branch mainline in revision 1183.
  • Revision ID: mordred@inaugust.com-20090812062519-cij02mrrunvnxblt
Tags: innodb-plugin-1.0.4
InnoDB Plugin 1.0.4

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/insert_notembedded.result
 
1
drop table if exists t1;
 
2
connection: default
 
3
set low_priority_updates=1;
 
4
drop table if exists t1;
 
5
create table t1 (a int, b int, unique key t1$a (a));
 
6
lock table t1 read;
 
7
connection: update
 
8
set low_priority_updates=1;
 
9
show variables like 'low_priority_updates';
 
10
Variable_name   Value
 
11
low_priority_updates    ON
 
12
insert into t1 values (1, 2) ON DUPLICATE KEY UPDATE b = 2;;
 
13
connection: select
 
14
select * from t1;
 
15
a       b
 
16
connection: default
 
17
select * from t1;
 
18
a       b
 
19
unlock tables;
 
20
drop table t1;
 
21
set low_priority_updates=default;