~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/update.test

  • Committer: Stewart Smith
  • Date: 2011-01-14 05:21:52 UTC
  • mto: (2086.1.3 build)
  • mto: This revision was merged to the branch mainline in revision 2087.
  • Revision ID: stewart@flamingspork.com-20110114052152-xnvlbrzvy3bx1ucd
add some FIXME to analyze docs.

Show diffs side-by-side

added added

removed removed

Lines of Context:
214
214
create table t1 (a int);
215
215
insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
216
216
create table t2 (a int, filler1 char(200), filler2 char(200), key(a));
217
 
insert into t2 select A.a + 10*B.a, 'filler','filler' from t1 A CROSS JOIN t1 B;
 
217
insert into t2 select A.a + 10*B.a, 'filler','filler' from t1 A, t1 B;
218
218
flush status;
219
219
update t2 set a=3 where a=2;
220
220
--replace_column 2 #