~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/delete.test

  • Committer: Brian Aker
  • Date: 2010-04-05 23:46:43 UTC
  • Revision ID: brian@gaz-20100405234643-0he3xnj902rc70r8
Fixing tests to work with PBXT.

Show diffs side-by-side

added added

removed removed

Lines of Context:
112
112
-- error 1242
113
113
delete from t11 where t11.b <> (select b from t2 where t11.a < t2.a);
114
114
select * from t11;
115
 
delete ignore from t11 where t11.b <> (select b from t2 where t11.a < t2.a);
 
115
 
 
116
# PBXT doesn't currently support DELETE IGNORE and turns it into plain DELETE
 
117
if (`select if (@@storage_engine = 'PBXT', 0, 1)`) { 
 
118
  delete ignore from t11 where t11.b <> (select b from t2 where t11.a < t2.a);
 
119
}
116
120
select * from t11;
117
121
drop table t11, t12, t2;
118
122