1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
|
ij> AUTOCOMMIT OFF;
ij> -- MODULE DML087
-- SQL Test Suite, V6.0, Interactive SQL, dml087.sql
-- 59-byte ID
-- TEd Version #
-- AUTHORIZATION FLATER
set schema FLATER;
0 rows inserted/updated/deleted
ij> --0 SELECT USER FROM HU.ECCO;
VALUES USER;
1
--------------------------------------------------------------------------------------------------------------------------------
FLATER
ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
-- date_time print
-- TEST:0518 CREATE VIEW with DISTINCT!
SELECT COUNT(*)
FROM DV1;
1
-----------
4
ij> -- PASS:0518 If count = 4?
SELECT HOURS FROM DV1
ORDER BY HOURS DESC;
HOURS
------
80
40
20
12
ij> -- PASS:0518 If 4 rows selected AND first HOURS = 80?
-- PASS:0518 AND second HOURS = 40 AND third HOURS = 20?
-- PASS:0518 AND fourth HOURS = 12?
-- restore
ROLLBACK WORK;
ij> -- END TEST >>> 0518 <<< END TEST;
-- *********************************************;
-- TEST:0519 CREATE VIEW with subqueries!
SELECT COUNT(*)
FROM VS2
WHERE C1 = 0;
1
-----------
2
ij> -- PASS:0519 If count = 2?
SELECT COUNT(*)
FROM VS2
WHERE C1 = 1;
1
-----------
2
ij> -- PASS:0519 If count = 2?
SELECT COUNT(*)
FROM VS3;
1
-----------
0
ij> -- PASS:0519 If count = 0?
SELECT COUNT(*)
FROM VS4;
1
-----------
0
ij> -- PASS:0519 If count = 0?
SELECT COUNT(*)
FROM VS5;
1
-----------
2
ij> -- PASS:0519 If count = 2?
SELECT COUNT(*)
FROM VS6;
1
-----------
2
ij> -- PASS:0519 If count = 2?
-- restore
ROLLBACK WORK;
ij> -- END TEST >>> 0519 <<< END TEST;
-- *********************************************;
-- TEST:0520 Underscores are legal an significant!
SELECT COUNT(*)
FROM USIG
WHERE C1 = 0;
1
-----------
1
ij> -- PASS:0520 If count = 1?
SELECT COUNT(*)
FROM USIG
WHERE C1 = 2;
1
-----------
0
ij> -- PASS:0520 If count = 0?
SELECT COUNT(*)
FROM USIG
WHERE C_1 = 0;
1
-----------
0
ij> -- PASS:0520 If count = 0?
SELECT COUNT(*)
FROM USIG
WHERE C_1 = 2;
1
-----------
1
ij> -- PASS:0520 If count = 1?
SELECT COUNT(*)
FROM USIG
WHERE C1 = 4;
1
-----------
0
ij> -- PASS:0520 If count = 0?
SELECT COUNT(*)
FROM U_SIG
WHERE C1 = 0;
1
-----------
0
ij> -- PASS:0520 If count = 0?
SELECT COUNT(*)
FROM U_SIG
WHERE C1 = 4;
1
-----------
1
ij> -- PASS:0520 If count = 1?
SELECT COUNT(*)
FROM HU.STAFF U_CN
WHERE U_CN.GRADE IN
(SELECT UCN.GRADE
FROM HU.STAFF UCN
WHERE UCN.GRADE > 10);
1
-----------
4
ij> -- PASS:0520 If count = 4?
SELECT COUNT(*)
FROM HU.STAFF
WHERE GRADE > 10;
1
-----------
4
ij> -- PASS:0520 If count = 4?
SELECT COUNT(*)
FROM HU.STAFF
WHERE GRADE < 10;
1
-----------
0
ij> -- PASS:0520 If count = 0?
-- restore
ROLLBACK WORK;
ij> -- END TEST >>> 0520 <<< END TEST;
-- *************************************************////END-OF-MODULE;
;
ij>
|
