~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/update.test

  • 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:
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 #