code reorg for Transactionw!
[csql.git] / test / sql / Join / exp.test068.ksh
blob06668d5fd340a3279ebedd693626dfd6f61d3cf8
1 echo create table t1(f1 int,f2 int);
2 Statement Executed
3 echo create table t2(f1 int,f2 int);
4 Statement Executed
5 echo create table t3(f1 int,f2 int);
6 Statement Executed
7 echo create index idx1 on t1(f1) tree;
8 Statement Executed
9 echo create index idx2 on t2(f1) tree;
10 Statement Executed
11 echo create index idx3 on t3(f1) tree;
12 Statement Executed
13 echo create index idx4 on t1(f2) hash;
14 Statement Executed
15 echo create index idx5 on t2(f2) hash;
16 Statement Executed
17 echo create index idx6 on t3(f2) hash;
18 Statement Executed
19 echo insert into t1 values(101,100);
20 Statement Executed: Rows Affected = 1
21 echo insert into t1 values(303,333);
22 Statement Executed: Rows Affected = 1
23 echo insert into t1 values(505,555);
24 Statement Executed: Rows Affected = 1
25 echo insert into t2 values(505,100);
26 Statement Executed: Rows Affected = 1
27 echo insert into t2 values(404,444);
28 Statement Executed: Rows Affected = 1
29 echo insert into t2 values(101,110);
30 Statement Executed: Rows Affected = 1
31 echo insert into t3 values(303,333);
32 Statement Executed: Rows Affected = 1
33 echo insert into t3 values(101,110);
34 Statement Executed: Rows Affected = 1
35 echo insert into t3 values(222,200);
36 Statement Executed: Rows Affected = 1
37 echo select * from t1,t2,t3 where t1.f1 = t2.f1 and t2.f1 = t3.f1;
38 ---------------------------------------------------------
39 t1.f1 t1.f2 t2.f1 t2.f2 t3.f1 t3.f2
40 ---------------------------------------------------------
41 100 100 100 110 100 200
43 echo select * from t2,t1,t3 where t1.f1 = t2.f1 and t2.f1 = t3.f1;
44 ---------------------------------------------------------
45 t2.f1 t2.f2 t1.f1 t1.f2 t3.f1 t3.f2
46 ---------------------------------------------------------
47 100 110 100 100 100 200
49 echo select * from t3,t1,t2 where t1.f1 = t2.f1 and t2.f1 = t3.f1;
50 ---------------------------------------------------------
51 t3.f1 t3.f2 t1.f1 t1.f2 t2.f1 t2.f2
52 ---------------------------------------------------------
53 100 200 100 100 100 110
55 Statement Executed
56 Statement Executed
57 Statement Executed