~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/update.result

  • Committer: patrick crews
  • Date: 2011-01-30 23:02:12 UTC
  • mto: This revision was merged to the branch mainline in revision 2131.
  • Revision ID: gleebix@gmail.com-20110130230212-nnts892jsc0oiurv
Added initial docs for dbqp.py

Show diffs side-by-side

added added

removed removed

Lines of Context:
277
277
create table t1 (a int);
278
278
insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
279
279
create table t2 (a int, filler1 char(200), filler2 char(200), key(a));
280
 
insert into t2 select A.a + 10*B.a, 'filler','filler' from t1 A CROSS JOIN t1 B;
 
280
insert into t2 select A.a + 10*B.a, 'filler','filler' from t1 A, t1 B;
281
281
flush status;
282
282
update t2 set a=3 where a=2;
283
283
show status like 'handler_read%';