← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/temp_table.result

  • Committer: Stewart Smith
  • Date: 2009-06-17 06:42:03 UTC
  • mto: This revision was merged to the branch mainline in revision 1094.
  • Revision ID: stewart@flamingspork.com-20090617064203-0ndcw2kjvgq3on4a
temp_table.test for myisam as temp table.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/temp_table.result
77
77
alter table t1 add primary key (a);
78
78
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
79
79
drop table t1;
80
 
CREATE TABLE t1 (
 
80
CREATE TEMPORARY TABLE t1 (
81
81
d datetime default NULL
82
82
) ENGINE=MyISAM;
83
83
INSERT INTO t1 VALUES ('2002-10-24 14:50:32'),('2002-10-24 14:50:33'),('2002-10-24 14:50:34'),('2002-10-24 14:50:34'),('2002-10-24 14:50:34'),('2002-10-24 14:50:35'),('2002-10-24 14:50:35'),('2002-10-24 14:50:35'),('2002-10-24 14:50:35'),('2002-10-24 14:50:36'),('2002-10-24 14:50:36'),('2002-10-24 14:50:36'),('2002-10-24 14:50:36'),('2002-10-24 14:50:37'),('2002-10-24 14:50:37'),('2002-10-24 14:50:37'),('2002-10-24 14:50:37'),('2002-10-24 14:50:38'),('2002-10-24 14:50:38'),('2002-10-24 14:50:38'),('2002-10-24 14:50:39'),('2002-10-24 14:50:39'),('2002-10-24 14:50:39'),('2002-10-24 14:50:39'),('2002-10-24 14:50:40'),('2002-10-24 14:50:40'),('2002-10-24 14:50:40');