windows fixes for test directory
[csql.git] / test / sql / Join / exp.test028.ksh
blob17f8e46b3718406128d8edbcb22b33491cb5a1a4
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 insert into t1 values(101,100);
8 Statement Executed: Rows Affected = 1
9 echo insert into t1 values(303,333);
10 Statement Executed: Rows Affected = 1
11 echo insert into t1 values(505,555);
12 Statement Executed: Rows Affected = 1
13 echo insert into t2 values(505,100);
14 Statement Executed: Rows Affected = 1
15 echo insert into t2 values(404,444);
16 Statement Executed: Rows Affected = 1
17 echo insert into t2 values(101,110);
18 Statement Executed: Rows Affected = 1
19 echo insert into t3 values(303,333);
20 Statement Executed: Rows Affected = 1
21 echo insert into t3 values(101,110);
22 Statement Executed: Rows Affected = 1
23 echo insert into t3 values(222,200);
24 Statement Executed: Rows Affected = 1
25 echo select * from t1,t2,t3;
26 ---------------------------------------------------------
27 t1.f1 t1.f2 t2.f1 t2.f2 t3.f1 t3.f2
28 ---------------------------------------------------------
29 100 100 505 100 303 333
30 100 100 505 100 101 110
31 100 100 505 100 100 200
32 100 100 404 444 303 333
33 100 100 404 444 101 110
34 100 100 404 444 100 200
35 100 100 100 110 303 333
36 100 100 100 110 101 110
37 100 100 100 110 100 200
38 303 333 505 100 303 333
39 303 333 505 100 101 110
40 303 333 505 100 100 200
41 303 333 404 444 303 333
42 303 333 404 444 101 110
43 303 333 404 444 100 200
44 303 333 100 110 303 333
45 303 333 100 110 101 110
46 303 333 100 110 100 200
47 505 555 505 100 303 333
48 505 555 505 100 101 110
49 505 555 505 100 100 200
50 505 555 404 444 303 333
51 505 555 404 444 101 110
52 505 555 404 444 100 200
53 505 555 100 110 303 333
54 505 555 100 110 101 110
55 505 555 100 110 100 200
57 echo select * from t2,t1,t3;
58 ---------------------------------------------------------
59 t2.f1 t2.f2 t1.f1 t1.f2 t3.f1 t3.f2
60 ---------------------------------------------------------
61 505 100 100 100 303 333
62 505 100 100 100 101 110
63 505 100 100 100 100 200
64 505 100 303 333 303 333
65 505 100 303 333 101 110
66 505 100 303 333 100 200
67 505 100 505 555 303 333
68 505 100 505 555 101 110
69 505 100 505 555 100 200
70 404 444 100 100 303 333
71 404 444 100 100 101 110
72 404 444 100 100 100 200
73 404 444 303 333 303 333
74 404 444 303 333 101 110
75 404 444 303 333 100 200
76 404 444 505 555 303 333
77 404 444 505 555 101 110
78 404 444 505 555 100 200
79 100 110 100 100 303 333
80 100 110 100 100 101 110
81 100 110 100 100 100 200
82 100 110 303 333 303 333
83 100 110 303 333 101 110
84 100 110 303 333 100 200
85 100 110 505 555 303 333
86 100 110 505 555 101 110
87 100 110 505 555 100 200
89 echo select * from t3,t1,t2;
90 ---------------------------------------------------------
91 t3.f1 t3.f2 t1.f1 t1.f2 t2.f1 t2.f2
92 ---------------------------------------------------------
93 303 333 100 100 505 100
94 303 333 100 100 404 444
95 303 333 100 100 100 110
96 303 333 303 333 505 100
97 303 333 303 333 404 444
98 303 333 303 333 100 110
99 303 333 505 555 505 100
100 303 333 505 555 404 444
101 303 333 505 555 100 110
102 101 110 100 100 505 100
103 101 110 100 100 404 444
104 101 110 100 100 100 110
105 101 110 303 333 505 100
106 101 110 303 333 404 444
107 101 110 303 333 100 110
108 101 110 505 555 505 100
109 101 110 505 555 404 444
110 101 110 505 555 100 110
111 100 200 100 100 505 100
112 100 200 100 100 404 444
113 100 200 100 100 100 110
114 100 200 303 333 505 100
115 100 200 303 333 404 444
116 100 200 303 333 100 110
117 100 200 505 555 505 100
118 100 200 505 555 404 444
119 100 200 505 555 100 110
121 Statement Executed
122 Statement Executed
123 Statement Executed