← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/derived.result

  • Committer: Brian Aker
  • Date: 2009-08-04 02:33:47 UTC
  • mto: (1108.2.1 merge)
  • mto: This revision was merged to the branch mainline in revision 1109.
  • Revision ID: brian@gaz-20090804023347-z0ciilv9f2exhlws
Removal multi-update/delete

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/derived.result
205
205
1
206
206
create table t1 (a int);
207
207
insert into t1 values (1),(2),(3);
208
 
update (select * from t1) as t1 set a = 5;
209
 
ERROR HY000: The target table t1 of the UPDATE is not updatable
210
208
delete from (select * from t1);
211
209
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your Drizzle server version for the right syntax to use near '(select * from t1)' at line 1
212
210
insert into  (select * from t1) values (5);