~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/insert_select.test

  • Committer: Stewart Smith
  • Date: 2010-09-23 05:33:01 UTC
  • mto: (1804.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1806.
  • Revision ID: stewart@flamingspork.com-20100923053301-b2b528g2dm5owa97
HailDB test suite loads the HailDB plugin (not the old name, which was 'embedded_innodb')

Show diffs side-by-side

added added

removed removed

Lines of Context:
87
87
select * from t1;
88
88
insert into t2 select * from t1 as t2;
89
89
select * from t1;
90
 
insert into t1 select t2.a from t1,t2 where t1.a > 0;
 
90
insert into t1 select t2.a from t1,t2;
91
91
select * from t1;
92
92
--error ER_NONUNIQ_TABLE
93
93
insert into t1 select * from t1,t1;