insert.out

derby database source code.good for you.

-----------------------
1          |1          
2          |2          
1          |1          
ij> rollback;
ij> -- zero-row deferred insert - degenerate case
insert into t1 select * from t1 where i = 17;
0 rows inserted/updated/deleted
ij> select * from t1;
I          |J          
-----------------------
1          |1          
2          |2          
ij> rollback;
ij> -- insert-select with ? parameters
prepare i1 as 'insert into t1 (j, i) select 101,102 from t1 where i = ?';
ij> execute i1 using 'values (1)';
1 row inserted/updated/deleted
ij> select * from t1;
I          |J          
-----------------------
1          |1          
2          |2          
102        |101        
ij> rollback;
ij> autocommit on;
ij> -- test atomicity of multi row inserts
create table atom_test_target (c1 smallint);
0 rows inserted/updated/deleted
ij> create table atom_test_source (c1 smallint);
0 rows inserted/updated/deleted
ij> insert into atom_test_source values 1, 30000,0, 2;
4 rows inserted/updated/deleted
ij> -- overflow
insert into atom_test_target select c1 + c1 from atom_test_source;
ERROR 22003: The resulting value is outside the range for the data type SMALLINT.
ij> select * from atom_test_target;
C1    
------
ij> -- divide by 0
insert into atom_test_target select c1 / c1 from atom_test_source;
ERROR 22012: Attempt to divide by zero.
ij> select * from atom_test_target;
C1    
------
ij> -- Derby-34
create table tchar( i int, c char(1) for bit data default x'02');
0 rows inserted/updated/deleted
ij> create table tchar1 (i int, c char(5) for bit data default x'2020202020',
			v varchar(5) for bit data default x'2020',
			l long varchar for bit data default x'303030');
0 rows inserted/updated/deleted
ij> drop table tchar;
0 rows inserted/updated/deleted
ij> drop table tchar1;
0 rows inserted/updated/deleted
ij> -- insert various numeric types into other numeric types
create table i1 (i int, t int, s smallint, l bigint, r real, dp double, dc dec);
0 rows inserted/updated/deleted
ij> create table i2 (i int, t int, s smallint, l bigint, r real, dp double, dc dec);
0 rows inserted/updated/deleted
ij> create table tab1 (
				i integer, 
				t integer, 
				s integer, 
				l bigint,
				r real, 
				dp double,
				dc decimal);
0 rows inserted/updated/deleted
ij> insert into i1 values (1, 2, 3, 4, 5.5, 6.6, 7.7);
1 row inserted/updated/deleted
ij> insert into i1 values (null, null, null, null, null, null, null);
1 row inserted/updated/deleted
ij> insert into tab1 values(1, 
				cast(2 as int), 
				cast(3 as smallint), 
				cast(4 as bigint), 
				cast(5.5 as real), 
				cast(6.6 as double), 
				7.7);
1 row inserted/updated/deleted
ij> insert into tab1 values (null, null, null, null, null, null, null);
1 row inserted/updated/deleted
ij> insert into i2 select i, i, i, i, i, i, i from i1;
2 rows inserted/updated/deleted
ij> insert into i2 select t, t, t, t, t, t, t from i1;
2 rows inserted/updated/deleted
ij> insert into i2 select s, s, s, s, s, s, s from i1;
2 rows inserted/updated/deleted
ij> insert into i2 select l, l, l, l, l, l, l from i1;
2 rows inserted/updated/deleted
ij> insert into i2 select r, r, r, r, r, r, r from i1;
2 rows inserted/updated/deleted
ij> insert into i2 select dp, dp, dp, dp, dp, dp, dp from i1;
2 rows inserted/updated/deleted
ij> insert into i2 select dc, dc, dc, dc, dc, dc, dc from i1;
2 rows inserted/updated/deleted
ij> select * from i2;
I          |T          |S     |L                   |R            |DP                    |DC    
-----------------------------------------------------------------------------------------------
1          |1          |1     |1                   |1.0          |1.0                   |1     
NULL       |NULL       |NULL  |NULL                |NULL         |NULL                  |NULL