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
|
ij> -- SQL Test Suite, V6.0, Schema Definition, schema4.std
-- 59-byte ID
-- TEd Version #
-- date_time print
-- ******************************************************************
-- ****** THIS FILE SHOULD BE RUN UNDER AUTHORIZATION ID SULLIVAN1
-- ******************************************************************
-- This is a standard schema definition.
--O CREATE SCHEMA AUTHORIZATION SULLIVAN1
CREATE SCHEMA SULLIVAN1;
0 rows inserted/updated/deleted
ij> set schema SULLIVAN1;
0 rows inserted/updated/deleted
ij> CREATE TABLE AUTH_TABLE (FIRST1 INTEGER, SECOND2 CHAR);
0 rows inserted/updated/deleted
ij> CREATE VIEW MUL_SCH
AS SELECT EMPNUM, SECOND2
FROM HU.STAFF, AUTH_TABLE
WHERE GRADE = FIRST1;
0 rows inserted/updated/deleted
ij> --O GRANT ALL PRIVILEGES ON AUTH_TABLE TO HU
--O GRANT SELECT ON MUL_SCH TO HU
-- The following tables are used to run concurrency program pairs
-- e.g MPA001 and MPB001 use the tables with prefix MP1_
CREATE TABLE MP1_MM2 (NUMTEST NUMERIC(10));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP1_NN (NUMTEST NUMERIC(9));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP1_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
0 rows inserted/updated/deleted
ij> CREATE TABLE MP2_MM2 (NUMTEST NUMERIC(10));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP2_NN (NUMTEST NUMERIC(9));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP2_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
0 rows inserted/updated/deleted
ij> CREATE TABLE MP3_MM2 (NUMTEST NUMERIC(10));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP3_NN (NUMTEST NUMERIC(9));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP3_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
0 rows inserted/updated/deleted
ij> CREATE TABLE MP4_MM2 (NUMTEST NUMERIC(10));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP4_NN (NUMTEST NUMERIC(9));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP4_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
0 rows inserted/updated/deleted
ij> CREATE TABLE MP5_AA (ANUM NUMERIC(4));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP5_AA_INDEX (ANUM NUMERIC(4) NOT NULL UNIQUE);
0 rows inserted/updated/deleted
ij> CREATE TABLE MP5_TT (TESTTYPE CHAR(3), KOUNT DECIMAL(4));
0 rows inserted/updated/deleted
ij> -- The following tables are used to run interactive concurrency program pairs.
CREATE TABLE TTT (ANUM NUMERIC(4) NOT NULL UNIQUE, AUTHOR CHAR(1));
0 rows inserted/updated/deleted
ij> CREATE TABLE TT (DOLLARS NUMERIC(4), ANUM NUMERIC(4));
0 rows inserted/updated/deleted
ij> CREATE TABLE AA (ANUM NUMERIC(4));
0 rows inserted/updated/deleted
ij> --O this is a dup of a table in a different schema...
CREATE TABLE BB (BNUM NUMERIC(4));
0 rows inserted/updated/deleted
ij> --O this is a dup of a table in a different schema...
-- Test GRANT UPDATE for additional columns beyond those WITH GRANT OPTION.
-- expect error message!
-- In SCHEMA1 for USER HU is the following grant:
-- GRANT SELECT,UPDATE(EMPNUM,EMPNAME) ON STAFF3
-- TO ..., SULLIVAN1 WITH GRANT OPTION
-- If the following self-grant by SULLIVAN1 will not compile/execute, delete it.
--O GRANT SELECT,UPDATE ON HU.STAFF3
--O TO SULLIVAN1
--O WITH GRANT OPTION
CREATE TABLE MP6_MM2 (NUMTEST NUMERIC(10));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP6_NN (NUMTEST NUMERIC(9));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP6_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
0 rows inserted/updated/deleted
ij> CREATE TABLE MP6_AA (ANUM NUMERIC(4));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP6_BB (BNUM NUMERIC(4));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP7_NN (NUMTEST NUMERIC(9));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP7_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
0 rows inserted/updated/deleted
ij> CREATE TABLE MP7_AA (ANUM NUMERIC(4));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP7_BB (BNUM NUMERIC(4));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP8_NN (NUMTEST NUMERIC(9));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP8_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
0 rows inserted/updated/deleted
ij> CREATE TABLE MP8_AA (ANUM NUMERIC(4) NOT NULL,
--O AUTHOR CHAR(1), UNIQUE (ANUM))
AUTHOR CHAR(1), constraint mp8_aa_con UNIQUE (ANUM));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP8_BB (NUMTEST NUMERIC(9));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP9_NN (NUMTEST NUMERIC(9));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP9_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
0 rows inserted/updated/deleted
ij> CREATE TABLE MP9_AA (ANUM NUMERIC(4));
0 rows inserted/updated/deleted
ij> CREATE TABLE MP9_BB (BNUM NUMERIC(4));
0 rows inserted/updated/deleted
ij> CREATE TABLE USG102 (C1 INT, C_1 INT);
0 rows inserted/updated/deleted
ij> CREATE TABLE USG103 (C1 INT, C_1 INT);
0 rows inserted/updated/deleted
ij> -- ************* End of Schema *************
;
ij>
|
