insert.out

derby database source code.good for you.

insert into t1 values;
ERROR 42X80: VALUES clause must contain at least one element. Empty elements are not allowed. 
ij> -- Too many values in values clause
insert into t1 values(1,1,1);
ERROR 42802: The number of values assigned is not the same as the number of specified or implied columns.
ij> -- insert select with too many result columns in select
insert into t1 select 1, 2, 3 from t2;
ERROR 42802: The number of values assigned is not the same as the number of specified or implied columns.
ij> -- multiple instances of same column in colum list
insert into t1 (i, i) values(2,2);
ERROR 42X13: Column name 'I' appears more than once times in the column list of an INSERT statement. 
ij> -- target column list size != source size
insert into t1 (i, j) values(1);
ERROR 42802: The number of values assigned is not the same as the number of specified or implied columns.
ij> insert into t1 (i) values (1, 2);
ERROR 42802: The number of values assigned is not the same as the number of specified or implied columns.
ij> -- Negative test cases - column name not specified
insert into t1 select 666 from t2;
ERROR 42802: The number of values assigned is not the same as the number of specified or implied columns.
ij> -- target table in source - deferred mode
insert into t1 values (1,1);
1 row inserted/updated/deleted
ij> insert into t1 values (2,2);
1 row inserted/updated/deleted
ij> delete from t2;
2 rows inserted/updated/deleted
ij> insert into t2 select * from t1;
2 rows inserted/updated/deleted
ij> autocommit off;
ij> select * from t1;
I          |J          
-----------------------
1          |1          
2          |2          
ij> insert into t1 select t1.* from t1, t2;
4 rows inserted/updated/deleted
ij> select * from t1 order by 1, 2;
I          |J          
-----------------------
1          |1          
1          |1          
1          |1          
2          |2          
2          |2          
2          |2          
ij> rollback;
ij> insert into t1 (i) select (select i from t1 where i = 1) from t2;
2 rows inserted/updated/deleted
ij> select * from t1;
I          |J          
-----------------------
1          |1          
2          |2          
1          |NULL       
1          |NULL       
ij> rollback;
ij> insert into t1 (i) select 1 from t2 where 1 = (select i from t1 where i = 1);
2 rows inserted/updated/deleted
ij> select * from t1;
I          |J          
-----------------------
1          |1          
2          |2          
1          |NULL       
1          |NULL       
ij> rollback;
ij> insert into t1 select * from (select * from t1) a;
2 rows inserted/updated/deleted
ij> select * from t1;
I          |J          
-----------------------
1          |1          
2          |2          
1          |1          
2          |2          
ij> rollback;
ij> -- bug 5638
insert into t1 select * from t2 union select * from t1;
2 rows inserted/updated/deleted
ij> select * from t1;
I          |J          
-----------------------
1          |1          
2          |2          
1          |1          
2          |2          
ij> rollback;
ij> -- bug 5638
insert into t1 select * from t2 union select * from (select * from t1) a;
2 rows inserted/updated/deleted
ij> select * from t1;
I          |J          
-----------------------
1          |1          
2          |2          
1          |1          
2          |2          
ij> rollback;
ij> -- single-row deferred insert
insert into t1 select * from t1 where i = 1;
1 row inserted/updated/deleted
ij> select * from t1;
I          |J