~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/include/unsafe_binlog.inc

  • Committer: Padraig O'Sullivan
  • Date: 2009-08-07 14:14:58 UTC
  • mfrom: (1112 staging)
  • mto: (1115.3.4 captain)
  • mto: This revision was merged to the branch mainline in revision 1117.
  • Revision ID: osullivan.padraig@gmail.com-20090807141458-qrc3don58s304ore
MergeĀ fromĀ trunk.

Show diffs side-by-side

added added

removed removed

Lines of Context:
34
34
INSERT INTO t2 VALUES (1, 0, '');
35
35
INSERT INTO t2 VALUES (8, 1, '');
36
36
commit;
37
 
DELETE ml.* FROM t1 AS ml LEFT JOIN t2 AS mm ON (mm.id=ml.id)
38
 
WHERE mm.id IS NULL;
39
37
select ml.* from t1 as ml left join t2 as mm on (mm.id=ml.id)
40
38
where mm.id is null lock in share mode;
41
39
drop table t1,t2;