~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/update.result

  • Committer: Brian Aker
  • Date: 2011-01-13 09:25:42 UTC
  • mfrom: (2073.1.4 catalogs)
  • mto: This revision was merged to the branch mainline in revision 2080.
  • Revision ID: brian@gir-3-20110113092542-lmomnx1t0zpidzl4
Merge of current catalogs

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%';