//////////////////////////////////
// Oracle
//////////////////////////////////
drop table t1;
create table t1 (c1 char(20));
insert /*+ APPEND */ into t1 select rownum from dual connect by level <=1000000;
commit;
select count(*) from t1;
//////////////////////////////////
// Timesten 7
//////////////////////////////////
autocommit on;
drop table TEST.T1;
create table test.t1 (c1 char(20));
insert into t1 select a.rowid from sys.columns a cross join sys.columns b;
select count(*) from t1;
//////////////////////////////////
// Timesten 11
//////////////////////////////////
drop table TEST.T1;
create table test.t1 (c1 char(20));
insert into t1 select a.rowid from sys.columns a cross join sys.columns b;
select count(*) from t1;
commit;
//////////////////////////////////
// MS-SQL
//////////////////////////////////
drop table t1;
create table t1 (c1 char(128));
insert into t1(c1) select top 480000 newid() from sys.columns a cross join sys.columns b;
insert into t1(c1) select top 480000 newid() from sys.columns a cross join sys.columns b;
select count(*) from t1;
//////////////////////////////////
// MySQL
//////////////////////////////////
drop table test.t1;
create table test.t1 (c1 char(20));
/* 1,000,000 */
insert into test.t1 (c1) select @row := @row + 1 from
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t1,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t2,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t3,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t4,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t5
;
//////////////////////////////////
// Informix
//////////////////////////////////
drop table t1;
create table t1 (c1 varchar(128));
insert into t1(c1) select a.rowid from syscolumns a cross join syscolumns b;
select count(*) from t1;
//////////////////////////////////
//Altibase 6.5.1
//////////////////////////////////
drop table t1;
create table t1 (c1 char(20));
insert /*+ APPEND */ into t1 select rownum from dual connect by level <=1000000;
commit;
select count(*) from t1;
//////////////////////////////////
// Tibero
//////////////////////////////////
drop table t1;
create table test.t1 (c1 char(20));
insert into t1 select rownum from dual connect by level <=100000
//////////////////////////////////
// CUBRID 9.x
//////////////////////////////////
drop table t1;
create table t1 (c1 int);
insert into t1 select rownum+1 from
table({0,1,2,3,4,5,6,7,8,9}) t0(a),
table({0,1,2,3,4,5,6,7,8,9}) t1(a), -- 100
table({0,1,2,3,4,5,6,7,8,9}) t2(a), -- 1,000
table({0,1,2,3,4,5,6,7,8,9}) t3(a), -- 10,000
table({0,1,2,3,4,5,6,7,8,9}) t4(a), -- 100,000
table({0,1,2,3,4,5,6,7,8,9}) t5(a) -- 1,000,000
