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
|
-- 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;
set schema SULLIVAN1;
CREATE TABLE AUTH_TABLE (FIRST1 INTEGER, SECOND2 CHAR);
CREATE VIEW MUL_SCH
AS SELECT EMPNUM, SECOND2
FROM HU.STAFF, AUTH_TABLE
WHERE GRADE = FIRST1;
--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));
CREATE TABLE MP1_NN (NUMTEST NUMERIC(9));
CREATE TABLE MP1_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
CREATE TABLE MP2_MM2 (NUMTEST NUMERIC(10));
CREATE TABLE MP2_NN (NUMTEST NUMERIC(9));
CREATE TABLE MP2_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
CREATE TABLE MP3_MM2 (NUMTEST NUMERIC(10));
CREATE TABLE MP3_NN (NUMTEST NUMERIC(9));
CREATE TABLE MP3_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
CREATE TABLE MP4_MM2 (NUMTEST NUMERIC(10));
CREATE TABLE MP4_NN (NUMTEST NUMERIC(9));
CREATE TABLE MP4_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
CREATE TABLE MP5_AA (ANUM NUMERIC(4));
CREATE TABLE MP5_AA_INDEX (ANUM NUMERIC(4) NOT NULL UNIQUE);
CREATE TABLE MP5_TT (TESTTYPE CHAR(3), KOUNT DECIMAL(4));
-- The following tables are used to run interactive concurrency program pairs.
CREATE TABLE TTT (ANUM NUMERIC(4) NOT NULL UNIQUE, AUTHOR CHAR(1));
CREATE TABLE TT (DOLLARS NUMERIC(4), ANUM NUMERIC(4));
CREATE TABLE AA (ANUM NUMERIC(4));
--O this is a dup of a table in a different schema...
CREATE TABLE BB (BNUM NUMERIC(4));
--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));
CREATE TABLE MP6_NN (NUMTEST NUMERIC(9));
CREATE TABLE MP6_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
CREATE TABLE MP6_AA (ANUM NUMERIC(4));
CREATE TABLE MP6_BB (BNUM NUMERIC(4));
CREATE TABLE MP7_NN (NUMTEST NUMERIC(9));
CREATE TABLE MP7_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
CREATE TABLE MP7_AA (ANUM NUMERIC(4));
CREATE TABLE MP7_BB (BNUM NUMERIC(4));
CREATE TABLE MP8_NN (NUMTEST NUMERIC(9));
CREATE TABLE MP8_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
CREATE TABLE MP8_AA (ANUM NUMERIC(4) NOT NULL,
--O AUTHOR CHAR(1), UNIQUE (ANUM))
AUTHOR CHAR(1), constraint mp8_aa_con UNIQUE (ANUM));
CREATE TABLE MP8_BB (NUMTEST NUMERIC(9));
CREATE TABLE MP9_NN (NUMTEST NUMERIC(9));
CREATE TABLE MP9_NEXTKEY (KEYNUM INTEGER, AUTHOR CHAR(1),
DOLLARS INTEGER);
CREATE TABLE MP9_AA (ANUM NUMERIC(4));
CREATE TABLE MP9_BB (BNUM NUMERIC(4));
CREATE TABLE USG102 (C1 INT, C_1 INT);
CREATE TABLE USG103 (C1 INT, C_1 INT);
-- ************* End of Schema *************
|
