← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/insert.test

  • Committer: Brian Aker
  • Date: 2008-07-20 09:02:20 UTC
  • Revision ID: brian@tangent.org-20080720090220-bhrg1wemfnzutbgi
Convert default engine to Innodb

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/insert.test
43
43
drop table t1;
44
44
 
45
45
#
46
 
# Test problem with bulk insert and auto_increment on second part keys
47
 
#
48
 
 
49
 
create table t1 (sid char(20), id int(2) NOT NULL auto_increment, key(sid, id));
50
 
insert into t1 values ('skr',NULL),('skr',NULL),('test',NULL);
51
 
select * from t1;
52
 
insert into t1 values ('rts',NULL),('rts',NULL),('test',NULL);
53
 
select * from t1;
54
 
drop table t1;
55
 
 
56
 
#
57
46
#Test of behaviour with INSERT VALUES (NULL)
58
47
#
59
48