exp.test002.ksh

b树实现源码,linux和unix下运行,速度快,极好用

CREATE TABLE t1 (f1 INT , f2 INT );
CREATE INDEX t1_PRIMARY on t1 ( f1 ) ;
CREATE TABLE t2 (f1 INT , f2 INT );
CREATE INDEX t2_PRIMARY on t2 ( f1 ) ;
CREATE TABLE t3 (f1 INT , f2 INT );
CREATE INDEX t3_PRIMARY on t3 ( f1 ) ;
CREATE TABLE t4 (f1 INT , f2 INT );
CREATE INDEX t4_PRIMARY on t4 ( f1 ) ;
CREATE TABLE t5 (f1 INT , f2 INT );
CREATE INDEX t5_PRIMARY on t5 ( f1 ) ;
CREATE TABLE t6 (f1 INT , f2 INT );
CREATE INDEX t6_PRIMARY on t6 ( f1 ) ;
CREATE TABLE t7 (f1 INT , f2 INT );
CREATE INDEX t7_PRIMARY on t7 ( f1 ) ;
CREATE TABLE t8 (f1 INT , f2 INT );
CREATE INDEX t8_PRIMARY on t8 ( f1 ) ;
CREATE TABLE t9 (f1 INT , f2 INT );
CREATE INDEX t9_PRIMARY on t9 ( f1 ) ;
CREATE TABLE t10 (f1 INT , f2 INT );
CREATE INDEX t10_PRIMARY on t10 ( f1 ) ;
CREATE TABLE t11 (f1 INT , f2 INT );
CREATE INDEX t11_PRIMARY on t11 ( f1 ) ;
CREATE TABLE t12 (f1 INT , f2 INT );
CREATE INDEX t12_PRIMARY on t12 ( f1 ) ;
CREATE TABLE t13 (f1 INT , f2 INT );
CREATE INDEX t13_PRIMARY on t13 ( f1 ) ;
CREATE TABLE t14 (f1 INT , f2 INT );
CREATE INDEX t14_PRIMARY on t14 ( f1 ) ;
CREATE TABLE t15 (f1 INT , f2 INT );
CREATE INDEX t15_PRIMARY on t15 ( f1 ) ;
CREATE TABLE t16 (f1 INT , f2 INT );
CREATE INDEX t16_PRIMARY on t16 ( f1 ) ;
CREATE TABLE t17 (f1 INT , f2 INT );
CREATE INDEX t17_PRIMARY on t17 ( f1 ) ;
CREATE TABLE t18 (f1 INT , f2 INT );
CREATE INDEX t18_PRIMARY on t18 ( f1 ) ;
CREATE TABLE t19 (f1 INT , f2 INT );
CREATE INDEX t19_PRIMARY on t19 ( f1 ) ;
CREATE TABLE t20 (f1 INT , f2 INT );
CREATE INDEX t20_PRIMARY on t20 ( f1 ) ;
CREATE TABLE t21 (f1 INT , f2 INT );
CREATE INDEX t21_PRIMARY on t21 ( f1 ) ;
CREATE TABLE t22 (f1 INT , f2 INT );
CREATE INDEX t22_PRIMARY on t22 ( f1 ) ;
CREATE TABLE t23 (f1 INT , f2 INT );
CREATE INDEX t23_PRIMARY on t23 ( f1 ) ;
CREATE TABLE t24 (f1 INT , f2 INT );
CREATE INDEX t24_PRIMARY on t24 ( f1 ) ;
CREATE TABLE t25 (f1 INT , f2 INT );
CREATE INDEX t25_PRIMARY on t25 ( f1 ) ;
CREATE TABLE t26 (f1 INT , f2 INT );
CREATE INDEX t26_PRIMARY on t26 ( f1 ) ;
CREATE TABLE t27 (f1 INT , f2 INT );
CREATE INDEX t27_PRIMARY on t27 ( f1 ) ;
CREATE TABLE t28 (f1 INT , f2 INT );
CREATE INDEX t28_PRIMARY on t28 ( f1 ) ;
CREATE TABLE t29 (f1 INT , f2 INT );
CREATE INDEX t29_PRIMARY on t29 ( f1 ) ;
CREATE TABLE t30 (f1 INT , f2 INT );
CREATE INDEX t30_PRIMARY on t30 ( f1 ) ;
CREATE TABLE t31 (f1 INT , f2 INT );
CREATE INDEX t31_PRIMARY on t31 ( f1 ) ;
CREATE TABLE t32 (f1 INT , f2 INT );
CREATE INDEX t32_PRIMARY on t32 ( f1 ) ;
CREATE TABLE t33 (f1 INT , f2 INT );
CREATE INDEX t33_PRIMARY on t33 ( f1 ) ;
CREATE TABLE t34 (f1 INT , f2 INT );
CREATE INDEX t34_PRIMARY on t34 ( f1 ) ;
CREATE TABLE t35 (f1 INT , f2 INT );
CREATE INDEX t35_PRIMARY on t35 ( f1 ) ;
CREATE TABLE t36 (f1 INT , f2 INT );
CREATE INDEX t36_PRIMARY on t36 ( f1 ) ;
CREATE TABLE t37 (f1 INT , f2 INT );
CREATE INDEX t37_PRIMARY on t37 ( f1 ) ;
CREATE TABLE t38 (f1 INT , f2 INT );
CREATE INDEX t38_PRIMARY on t38 ( f1 ) ;
CREATE TABLE t39 (f1 INT , f2 INT );
CREATE INDEX t39_PRIMARY on t39 ( f1 ) ;
CREATE TABLE t40 (f1 INT , f2 INT );
CREATE INDEX t40_PRIMARY on t40 ( f1 ) ;
CREATE TABLE t41 (f1 INT , f2 INT );
CREATE INDEX t41_PRIMARY on t41 ( f1 ) ;
CREATE TABLE t42 (f1 INT , f2 INT );
CREATE INDEX t42_PRIMARY on t42 ( f1 ) ;
CREATE TABLE t43 (f1 INT , f2 INT );
CREATE INDEX t43_PRIMARY on t43 ( f1 ) ;
CREATE TABLE t44 (f1 INT , f2 INT );
CREATE INDEX t44_PRIMARY on t44 ( f1 ) ;
CREATE TABLE t45 (f1 INT , f2 INT );
CREATE INDEX t45_PRIMARY on t45 ( f1 ) ;
CREATE TABLE t46 (f1 INT , f2 INT );
CREATE INDEX t46_PRIMARY on t46 ( f1 ) ;
CREATE TABLE t47 (f1 INT , f2 INT );
CREATE INDEX t47_PRIMARY on t47 ( f1 ) ;
CREATE TABLE t48 (f1 INT , f2 INT );
CREATE INDEX t48_PRIMARY on t48 ( f1 ) ;
CREATE TABLE t49 (f1 INT , f2 INT );
CREATE INDEX t49_PRIMARY on t49 ( f1 ) ;
CREATE TABLE t50 (f1 INT , f2 INT );
CREATE INDEX t50_PRIMARY on t50 ( f1 ) ;
CREATE TABLE t51 (f1 INT , f2 INT );
CREATE INDEX t51_PRIMARY on t51 ( f1 ) ;
CREATE TABLE t52 (f1 INT , f2 INT );
CREATE INDEX t52_PRIMARY on t52 ( f1 ) ;
CREATE TABLE t53 (f1 INT , f2 INT );
CREATE INDEX t53_PRIMARY on t53 ( f1 ) ;
CREATE TABLE t54 (f1 INT , f2 INT );
CREATE INDEX t54_PRIMARY on t54 ( f1 ) ;
CREATE TABLE t55 (f1 INT , f2 INT );
CREATE INDEX t55_PRIMARY on t55 ( f1 ) ;
CREATE TABLE t56 (f1 INT , f2 INT );
CREATE INDEX t56_PRIMARY on t56 ( f1 ) ;
CREATE TABLE t57 (f1 INT , f2 INT );
CREATE INDEX t57_PRIMARY on t57 ( f1 ) ;
CREATE TABLE t58 (f1 INT , f2 INT );
CREATE INDEX t58_PRIMARY on t58 ( f1 ) ;
CREATE TABLE t59 (f1 INT , f2 INT );
CREATE INDEX t59_PRIMARY on t59 ( f1 ) ;
CREATE TABLE t60 (f1 INT , f2 INT );
CREATE INDEX t60_PRIMARY on t60 ( f1 ) ;
CREATE TABLE t61 (f1 INT , f2 INT );
CREATE INDEX t61_PRIMARY on t61 ( f1 ) ;
CREATE TABLE t62 (f1 INT , f2 INT );
CREATE INDEX t62_PRIMARY on t62 ( f1 ) ;
CREATE TABLE t63 (f1 INT , f2 INT );
CREATE INDEX t63_PRIMARY on t63 ( f1 ) ;
CREATE TABLE t64 (f1 INT , f2 INT );
CREATE INDEX t64_PRIMARY on t64 ( f1 ) ;
CREATE TABLE t65 (f1 INT , f2 INT );
CREATE INDEX t65_PRIMARY on t65 ( f1 ) ;
CREATE TABLE t66 (f1 INT , f2 INT );
CREATE INDEX t66_PRIMARY on t66 ( f1 ) ;
CREATE TABLE t67 (f1 INT , f2 INT );
CREATE INDEX t67_PRIMARY on t67 ( f1 ) ;
CREATE TABLE t68 (f1 INT , f2 INT );
CREATE INDEX t68_PRIMARY on t68 ( f1 ) ;
CREATE TABLE t69 (f1 INT , f2 INT );
CREATE INDEX t69_PRIMARY on t69 ( f1 ) ;
CREATE TABLE t70 (f1 INT , f2 INT );
CREATE INDEX t70_PRIMARY on t70 ( f1 ) ;
CREATE TABLE t71 (f1 INT , f2 INT );
CREATE INDEX t71_PRIMARY on t71 ( f1 ) ;
CREATE TABLE t72 (f1 INT , f2 INT );
CREATE INDEX t72_PRIMARY on t72 ( f1 ) ;
CREATE TABLE t73 (f1 INT , f2 INT );
CREATE INDEX t73_PRIMARY on t73 ( f1 ) ;
CREATE TABLE t74 (f1 INT , f2 INT );
CREATE INDEX t74_PRIMARY on t74 ( f1 ) ;
CREATE TABLE t75 (f1 INT , f2 INT );
CREATE INDEX t75_PRIMARY on t75 ( f1 ) ;
CREATE TABLE t76 (f1 INT , f2 INT );
CREATE INDEX t76_PRIMARY on t76 ( f1 ) ;
CREATE TABLE t77 (f1 INT , f2 INT );
CREATE INDEX t77_PRIMARY on t77 ( f1 ) ;
CREATE TABLE t78 (f1 INT , f2 INT );
CREATE INDEX t78_PRIMARY on t78 ( f1 ) ;
CREATE TABLE t79 (f1 INT , f2 INT );
CREATE INDEX t79_PRIMARY on t79 ( f1 ) ;
CREATE TABLE t80 (f1 INT , f2 INT );
CREATE INDEX t80_PRIMARY on t80 ( f1 ) ;
CREATE TABLE t81 (f1 INT , f2 INT );
CREATE INDEX t81_PRIMARY on t81 ( f1 ) ;
CREATE TABLE t82 (f1 INT , f2 INT );
CREATE INDEX t82_PRIMARY on t82 ( f1 ) ;
CREATE TABLE t83 (f1 INT , f2 INT );
CREATE INDEX t83_PRIMARY on t83 ( f1 ) ;
CREATE TABLE t84 (f1 INT , f2 INT );
CREATE INDEX t84_PRIMARY on t84 ( f1 ) ;
CREATE TABLE t85 (f1 INT , f2 INT );
CREATE INDEX t85_PRIMARY on t85 ( f1 ) ;
CREATE TABLE t86 (f1 INT , f2 INT );
CREATE INDEX t86_PRIMARY on t86 ( f1 ) ;
CREATE TABLE t87 (f1 INT , f2 INT );
CREATE INDEX t87_PRIMARY on t87 ( f1 ) ;
CREATE TABLE t88 (f1 INT , f2 INT );
CREATE INDEX t88_PRIMARY on t88 ( f1 ) ;
CREATE TABLE t89 (f1 INT , f2 INT );
CREATE INDEX t89_PRIMARY on t89 ( f1 ) ;
CREATE TABLE t90 (f1 INT , f2 INT );
CREATE INDEX t90_PRIMARY on t90 ( f1 ) ;
CREATE TABLE t91 (f1 INT , f2 INT );
CREATE INDEX t91_PRIMARY on t91 ( f1 ) ;
CREATE TABLE t92 (f1 INT , f2 INT );
CREATE INDEX t92_PRIMARY on t92 ( f1 ) ;
CREATE TABLE t93 (f1 INT , f2 INT );
CREATE INDEX t93_PRIMARY on t93 ( f1 ) ;
CREATE TABLE t94 (f1 INT , f2 INT );
CREATE INDEX t94_PRIMARY on t94 ( f1 ) ;
CREATE TABLE t95 (f1 INT , f2 INT );
CREATE INDEX t95_PRIMARY on t95 ( f1 ) ;
CREATE TABLE t96 (f1 INT , f2 INT );
CREATE INDEX t96_PRIMARY on t96 ( f1 ) ;
CREATE TABLE t97 (f1 INT , f2 INT );
CREATE INDEX t97_PRIMARY on t97 ( f1 ) ;
CREATE TABLE t98 (f1 INT , f2 INT );
CREATE INDEX t98_PRIMARY on t98 ( f1 ) ;
CREATE TABLE t99 (f1 INT , f2 INT );
CREATE INDEX t99_PRIMARY on t99 ( f1 ) ;
CREATE TABLE t100 (f1 INT , f2 INT );
CREATE INDEX t100_PRIMARY on t100 ( f1 ) ;
SET AUTOCOMMIT OFF;
INSERT INTO t1 VALUES(1,11);
INSERT INTO t1 VALUES(2,21);
INSERT INTO t1 VALUES(3,31);
INSERT INTO t1 VALUES(4,41);
INSERT INTO t1 VALUES(5,51);
INSERT INTO t1 VALUES(6,61);
INSERT INTO t1 VALUES(7,71);
INSERT INTO t1 VALUES(8,81);
INSERT INTO t1 VALUES(9,91);
INSERT INTO t1 VALUES(10,101);
COMMIT;
INSERT INTO t2 VALUES(1,11);
INSERT INTO t2 VALUES(2,21);
INSERT INTO t2 VALUES(3,31);
INSERT INTO t2 VALUES(4,41);
INSERT INTO t2 VALUES(5,51);
INSERT INTO t2 VALUES(6,61);
INSERT INTO t2 VALUES(7,71);
INSERT INTO t2 VALUES(8,81);
INSERT INTO t2 VALUES(9,91);
INSERT INTO t2 VALUES(10,101);
COMMIT;
INSERT INTO t3 VALUES(1,11);
INSERT INTO t3 VALUES(2,21);
INSERT INTO t3 VALUES(3,31);
INSERT INTO t3 VALUES(4,41);
INSERT INTO t3 VALUES(5,51);
INSERT INTO t3 VALUES(6,61);
INSERT INTO t3 VALUES(7,71);
INSERT INTO t3 VALUES(8,81);
INSERT INTO t3 VALUES(9,91);
INSERT INTO t3 VALUES(10,101);
COMMIT;
INSERT INTO t4 VALUES(1,11);
INSERT INTO t4 VALUES(2,21);
INSERT INTO t4 VALUES(3,31);
INSERT INTO t4 VALUES(4,41);
INSERT INTO t4 VALUES(5,51);
INSERT INTO t4 VALUES(6,61);
INSERT INTO t4 VALUES(7,71);
INSERT INTO t4 VALUES(8,81);
INSERT INTO t4 VALUES(9,91);
INSERT INTO t4 VALUES(10,101);
COMMIT;
INSERT INTO t5 VALUES(1,11);
INSERT INTO t5 VALUES(2,21);
INSERT INTO t5 VALUES(3,31);
INSERT INTO t5 VALUES(4,41);
INSERT INTO t5 VALUES(5,51);
INSERT INTO t5 VALUES(6,61);
INSERT INTO t5 VALUES(7,71);
INSERT INTO t5 VALUES(8,81);
INSERT INTO t5 VALUES(9,91);
INSERT INTO t5 VALUES(10,101);
COMMIT;
INSERT INTO t6 VALUES(1,11);
INSERT INTO t6 VALUES(2,21);
INSERT INTO t6 VALUES(3,31);
INSERT INTO t6 VALUES(4,41);
INSERT INTO t6 VALUES(5,51);
INSERT INTO t6 VALUES(6,61);
INSERT INTO t6 VALUES(7,71);
INSERT INTO t6 VALUES(8,81);
INSERT INTO t6 VALUES(9,91);
INSERT INTO t6 VALUES(10,101);
COMMIT;
INSERT INTO t7 VALUES(1,11);
INSERT INTO t7 VALUES(2,21);
INSERT INTO t7 VALUES(3,31);
INSERT INTO t7 VALUES(4,41);
INSERT INTO t7 VALUES(5,51);
INSERT INTO t7 VALUES(6,61);
INSERT INTO t7 VALUES(7,71);
INSERT INTO t7 VALUES(8,81);
INSERT INTO t7 VALUES(9,91);
INSERT INTO t7 VALUES(10,101);
COMMIT;
INSERT INTO t8 VALUES(1,11);
INSERT INTO t8 VALUES(2,21);
INSERT INTO t8 VALUES(3,31);
INSERT INTO t8 VALUES(4,41);
INSERT INTO t8 VALUES(5,51);
INSERT INTO t8 VALUES(6,61);
INSERT INTO t8 VALUES(7,71);
INSERT INTO t8 VALUES(8,81);
INSERT INTO t8 VALUES(9,91);
INSERT INTO t8 VALUES(10,101);
COMMIT;
INSERT INTO t9 VALUES(1,11);
INSERT INTO t9 VALUES(2,21);
INSERT INTO t9 VALUES(3,31);
INSERT INTO t9 VALUES(4,41);
INSERT INTO t9 VALUES(5,51);
INSERT INTO t9 VALUES(6,61);
INSERT INTO t9 VALUES(7,71);
INSERT INTO t9 VALUES(8,81);
INSERT INTO t9 VALUES(9,91);
INSERT INTO t9 VALUES(10,101);
COMMIT;
INSERT INTO t10 VALUES(1,11);
INSERT INTO t10 VALUES(2,21);
INSERT INTO t10 VALUES(3,31);
INSERT INTO t10 VALUES(4,41);
INSERT INTO t10 VALUES(5,51);
INSERT INTO t10 VALUES(6,61);
INSERT INTO t10 VALUES(7,71);
INSERT INTO t10 VALUES(8,81);
INSERT INTO t10 VALUES(9,91);
INSERT INTO t10 VALUES(10,101);
COMMIT;
INSERT INTO t11 VALUES(1,11);
INSERT INTO t11 VALUES(2,21);
INSERT INTO t11 VALUES(3,31);
INSERT INTO t11 VALUES(4,41);
INSERT INTO t11 VALUES(5,51);
INSERT INTO t11 VALUES(6,61);
INSERT INTO t11 VALUES(7,71);
INSERT INTO t11 VALUES(8,81);
INSERT INTO t11 VALUES(9,91);
INSERT INTO t11 VALUES(10,101);
COMMIT;
INSERT INTO t12 VALUES(1,11);
INSERT INTO t12 VALUES(2,21);
INSERT INTO t12 VALUES(3,31);
INSERT INTO t12 VALUES(4,41);
INSERT INTO t12 VALUES(5,51);
INSERT INTO t12 VALUES(6,61);
INSERT INTO t12 VALUES(7,71);
INSERT INTO t12 VALUES(8,81);
INSERT INTO t12 VALUES(9,91);
INSERT INTO t12 VALUES(10,101);
COMMIT;
INSERT INTO t13 VALUES(1,11);
INSERT INTO t13 VALUES(2,21);
INSERT INTO t13 VALUES(3,31);
INSERT INTO t13 VALUES(4,41);
INSERT INTO t13 VALUES(5,51);
INSERT INTO t13 VALUES(6,61);
INSERT INTO t13 VALUES(7,71);
INSERT INTO t13 VALUES(8,81);
INSERT INTO t13 VALUES(9,91);
INSERT INTO t13 VALUES(10,101);
COMMIT;
INSERT INTO t14 VALUES(1,11);
INSERT INTO t14 VALUES(2,21);
INSERT INTO t14 VALUES(3,31);
INSERT INTO t14 VALUES(4,41);
INSERT INTO t14 VALUES(5,51);
INSERT INTO t14 VALUES(6,61);
INSERT INTO t14 VALUES(7,71);
INSERT INTO t14 VALUES(8,81);
INSERT INTO t14 VALUES(9,91);
INSERT INTO t14 VALUES(10,101);
COMMIT;
INSERT INTO t15 VALUES(1,11);
INSERT INTO t15 VALUES(2,21);
INSERT INTO t15 VALUES(3,31);
INSERT INTO t15 VALUES(4,41);
INSERT INTO t15 VALUES(5,51);
INSERT INTO t15 VALUES(6,61);
INSERT INTO t15 VALUES(7,71);
INSERT INTO t15 VALUES(8,81);
INSERT INTO t15 VALUES(9,91);
INSERT INTO t15 VALUES(10,101);
COMMIT;
INSERT INTO t16 VALUES(1,11);
INSERT INTO t16 VALUES(2,21);
INSERT INTO t16 VALUES(3,31);
INSERT INTO t16 VALUES(4,41);
INSERT INTO t16 VALUES(5,51);
INSERT INTO t16 VALUES(6,61);
INSERT INTO t16 VALUES(7,71);
INSERT INTO t16 VALUES(8,81);
INSERT INTO t16 VALUES(9,91);
INSERT INTO t16 VALUES(10,101);
COMMIT;
INSERT INTO t17 VALUES(1,11);
INSERT INTO t17 VALUES(2,21);
INSERT INTO t17 VALUES(3,31);
INSERT INTO t17 VALUES(4,41);
INSERT INTO t17 VALUES(5,51);
INSERT INTO t17 VALUES(6,61);
INSERT INTO t17 VALUES(7,71);
INSERT INTO t17 VALUES(8,81);
INSERT INTO t17 VALUES(9,91);
INSERT INTO t17 VALUES(10,101);
COMMIT;
INSERT INTO t18 VALUES(1,11);
INSERT INTO t18 VALUES(2,21);
INSERT INTO t18 VALUES(3,31);
INSERT INTO t18 VALUES(4,41);
INSERT INTO t18 VALUES(5,51);
INSERT INTO t18 VALUES(6,61);
INSERT INTO t18 VALUES(7,71);
INSERT INTO t18 VALUES(8,81);
INSERT INTO t18 VALUES(9,91);
INSERT INTO t18 VALUES(10,101);
COMMIT;
INSERT INTO t19 VALUES(1,11);
INSERT INTO t19 VALUES(2,21);
INSERT INTO t19 VALUES(3,31);
INSERT INTO t19 VALUES(4,41);
INSERT INTO t19 VALUES(5,51);
INSERT INTO t19 VALUES(6,61);
INSERT INTO t19 VALUES(7,71);
INSERT INTO t19 VALUES(8,81);
INSERT INTO t19 VALUES(9,91);
INSERT INTO t19 VALUES(10,101);
COMMIT;
INSERT INTO t20 VALUES(1,11);
INSERT INTO t20 VALUES(2,21);
INSERT INTO t20 VALUES(3,31);
INSERT INTO t20 VALUES(4,41);
INSERT INTO t20 VALUES(5,51);
INSERT INTO t20 VALUES(6,61);
INSERT INTO t20 VALUES(7,71);
INSERT INTO t20 VALUES(8,81);
INSERT INTO t20 VALUES(9,91);
INSERT INTO t20 VALUES(10,101);
COMMIT;
INSERT INTO t21 VALUES(1,11);
INSERT INTO t21 VALUES(2,21);
INSERT INTO t21 VALUES(3,31);
INSERT INTO t21 VALUES(4,41);
INSERT INTO t21 VALUES(5,51);
INSERT INTO t21 VALUES(6,61);
INSERT INTO t21 VALUES(7,71);
INSERT INTO t21 VALUES(8,81);
INSERT INTO t21 VALUES(9,91);
INSERT INTO t21 VALUES(10,101);
COMMIT;
INSERT INTO t22 VALUES(1,11);
INSERT INTO t22 VALUES(2,21);