← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/regression/r/680028.result

  • Committer: Brian Aker
  • Date: 2010-11-26 21:03:23 UTC
  • mto: This revision was merged to the branch mainline in revision 1958.
  • Revision ID: brian@tangent.org-20101126210323-k05fhmvnqx076t5j
Fix ID return for 680028.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/regression/r/680028.result
1
1
CREATE TABLE CONNECTION_ID (id int);
2
2
CREATE TABLE t1 (a serial);
3
3
insert into CONNECTION_ID VALUES (CONNECTION_ID());
4
 
SELECT @id:=id FROM CONNECTION_ID LIMIT 1;
5
 
@id:=id 
6
 
2
 
4
EXECUTE "SELECT @id:=id FROM CONNECTION_ID LIMIT 1" WITH NO RETURN;
7
5
FLUSH TABLES WITH READ LOCK;
8
6
select * from t1 for update;
9
7
KILL @id;