sdbms_sql.v

使用yacc的一个例子

	term : term . OPDIV factor

	OPMUL  shift 220
	OPDIV  shift 221
	.  reduce 148


state 126
	term : factor .  (151)

	.  reduce 151


state 127
	factor : colref .  (159)

	.  reduce 159


state 128
	factor : bool_value .  (157)

	.  reduce 157


state 129
	select : SELECT select_list . FROM tablenames where_clause order_clause believe_clause

	FROM  shift 222


state 130
	select_list : select_sub_list .  (188)
	select_sub_list : select_sub_list . ',' expr

	','  shift 223
	.  reduce 188


state 131
	insert : INSERT INTO . tablename insert_collist VALUES insert_vallist
	insert : INSERT INTO . tablename VALUES insert_vallist

	IDENTIFIER  shift 132

	tablename goto 224


state 132
	tablename : IDENTIFIER .  (110)

	.  reduce 110


state 133
	update : UPDATE tablename . SET set_list
	update : UPDATE tablename . SET set_list WHERE conditions

	SET  shift 225


state 134
	delete : YDELETE FROM . tablename
	delete : YDELETE FROM . tablename WHERE conditions

	IDENTIFIER  shift 132

	tablename goto 226


state 135
	sqls : sqls ';' . sql
	sql : .  (36)

	CONNECT  shift 1
	CREATE  shift 2
	DROP  shift 3
	ADD  shift 4
	DEL  shift 5
	CHANGE  shift 6
	GRANT  shift 7
	REVOKE  shift 8
	SET  shift 9
	AUDIT  shift 10
	NOAUDIT  shift 11
	SELECT  shift 12
	INSERT  shift 13
	UPDATE  shift 14
	YDELETE  shift 15
	.  reduce 36

	sql goto 227
	connect_database goto 18
	create_database goto 19
	drop_database goto 20
	create_user goto 21
	drop_user goto 22
	create_role goto 23
	drop_role goto 24
	set_parent_role goto 25
	set_child_role goto 26
	set_top_role goto 27
	add_user_to_role goto 28
	del_user_from_role goto 29
	change_role goto 30
	grant1 goto 31
	revoke1 goto 32
	grant2 goto 33
	revoke2 goto 34
	set_user_seclevel goto 35
	set_table_seclevel goto 36
	set_allow_seclevel goto 37
	set_current_seclevel goto 38
	create_table goto 39
	drop_table goto 40
	insert goto 41
	update goto 42
	delete goto 43
	select goto 44
	audit1 goto 45
	noaudit1 goto 46
	audit2 goto 47
	noaudit2 goto 48
	audit3 goto 49
	noaudit3 goto 50


state 136
	connect_database : CONNECT username WITH . PASSWORD password

	PASSWORD  shift 228


state 137
	connect_database : CONNECT username TO . dbname WITH PASSWORD password

	IDENTIFIER  shift 140

	dbname goto 229


state 138
	rolename : IDENTIFIER .  (54)

	.  reduce 54


state 139
	create_role : CREATE ROLE rolename .  (50)
	create_role : CREATE ROLE rolename . AS CHILD OF rolename
	create_role : CREATE ROLE rolename . AS PARENT OF rolenames

	AS  shift 230
	.  reduce 50


state 140
	dbname : IDENTIFIER .  (41)

	.  reduce 41


state 141
	create_database : CREATE DATABASE dbname .  (39)

	.  reduce 39


state 142
	create_table : CREATE TABLE tablename . tabcollist
	create_table : CREATE TABLE tablename . tabcollist WITH SECLEVEL seclevel

	'('  shift 231

	tabcollist goto 232


state 143
	create_user : CREATE USER username . WITH PASSWORD password
	create_user : CREATE USER username . WITH PASSWORD password WITH SECLEVEL class
	create_user : CREATE USER username . WITH PASSWORD password WITH SECLEVEL seclevel

	WITH  shift 233


state 144
	rolenames : rolename .  (56)

	.  reduce 56


state 145
	drop_role : DROP ROLE rolenames .  (53)
	rolenames : rolenames . ',' rolename

	','  shift 234
	.  reduce 53


state 146
	drop_database : DROP DATABASE dbname .  (40)

	.  reduce 40


state 147
	tablenames : tablename .  (112)

	.  reduce 112


state 148
	tablenames : tablenames . ',' tablename
	drop_table : DROP TABLE tablenames .  (137)

	','  shift 235
	.  reduce 137


state 149
	usernames : username .  (48)

	.  reduce 48


state 150
	drop_user : DROP USER usernames .  (45)
	usernames : usernames . ',' username

	','  shift 236
	.  reduce 45


state 151
	usernames : usernames . ',' username
	add_user_to_role : ADD USER usernames . TO rolenames

	','  shift 236
	TO  shift 237


state 152
	usernames : usernames . ',' username
	del_user_from_role : DEL USER usernames . FROM rolenames

	','  shift 236
	FROM  shift 238


state 153
	usernames : usernames . ',' username
	change_role : CHANGE USER usernames . TO rolenames

	','  shift 236
	TO  shift 239


state 154
	systemright : CREATE DATABASE .  (67)

	.  reduce 67


state 155
	systemright : CREATE TABLE .  (68)

	.  reduce 68


state 156
	systemright : CREATE VIEW .  (69)

	.  reduce 69


state 157
	systemright : CREATE INDEX .  (70)

	.  reduce 70


state 158
	systemright : DROP DATABASE .  (71)

	.  reduce 71


state 159
	systemright : DROP TABLE .  (72)

	.  reduce 72


state 160
	systemright : DROP VIEW .  (73)

	.  reduce 73


state 161
	systemright : DROP INDEX .  (74)

	.  reduce 74


state 162
	operation : SELECT '(' . fieldnames ')'

	IDENTIFIER  shift 240

	fieldname goto 241
	fieldnames goto 242


state 163
	operation : INSERT '(' . fieldnames ')'

	IDENTIFIER  shift 240

	fieldname goto 241
	fieldnames goto 243


state 164
	operation : UPDATE '(' . fieldnames ')'

	IDENTIFIER  shift 240

	fieldname goto 241
	fieldnames goto 244


state 165
	operation : YDELETE '(' . fieldnames ')'

	IDENTIFIER  shift 240

	fieldname goto 241
	fieldnames goto 245


state 166
	systemrights : systemrights ',' . systemright

	CREATE  shift 64
	DROP  shift 65
	GRANT  shift 66
	REVOKE  shift 67

	systemright goto 246


state 167
	grant1 : GRANT systemrights TO . rolenames

	IDENTIFIER  shift 138

	rolename goto 144
	rolenames goto 247


state 168
	operations : operations ',' . operation

	SELECT  shift 68
	INSERT  shift 69
	UPDATE  shift 70
	YDELETE  shift 71

	operation goto 248


state 169
	where_clause : WHERE . conditions

	'('  shift 249
	SECLEVEL  shift 112
	OPSUB  shift 113
	OPNOT  shift 250
	OPLESS  shift 115
	YTRUE  shift 116
	YFALSE  shift 117
	IDENTIFIER  shift 118
	STRING  shift 119
	INTEGER  shift 120

	tablename goto 121
	fieldname goto 122
	seclevel goto 123
	expr goto 251
	term goto 125
	factor goto 126
	colref goto 127
	conditions goto 252
	condition goto 253
	condfactor goto 254
	comp_clause goto 255
	bool_value goto 128


state 170
	grant2 : GRANT operations where_clause . ON tablename TO rolenames
	grant2 : GRANT operations where_clause . ON tablename TO rolenames WITH GRANT OPTION

	ON  shift 256


state 171
	revoke2 : REVOKE GRANT OPTION . FOR operations where_clause FROM tablename TO rolenames

	FOR  shift 257


state 172
	revoke1 : REVOKE systemrights FROM . rolenames

	IDENTIFIER  shift 138

	rolename goto 144
	rolenames goto 258


state 173
	revoke2 : REVOKE operations where_clause . ON tablename FROM rolenames
	revoke2 : REVOKE operations where_clause . ON tablename FROM rolenames CASCADE
	revoke2 : REVOKE operations where_clause . ON tablename FROM rolenames RESTRICT

	ON  shift 259


state 174
	set_child_role : SET CHILD ROLE . rolenames OF rolename

	IDENTIFIER  shift 138

	rolename goto 144
	rolenames goto 260


state 175
	set_parent_role : SET PARENT ROLE . rolename OF rolenames

	IDENTIFIER  shift 138

	rolename goto 261


state 176
	set_top_role : SET TOP ROLE . rolenames

	IDENTIFIER  shift 138

	rolename goto 144
	rolenames goto 262


state 177
	set_user_seclevel : SET SECURITY LEVEL . class TO usernames
	set_user_seclevel : SET SECURITY LEVEL . seclevel TO usernames
	set_table_seclevel : SET SECURITY LEVEL . seclevel ON tablenames

	OPLESS  shift 115
	INTEGER  shift 215

	class goto 263
	seclevel goto 264


state 178
	set_allow_seclevel : SET ALLOW SECURITY . LEVEL seclevel ON tablenames TO usernames

	LEVEL  shift 265


state 179
	set_current_seclevel : SET CURRENT SECURITY . LEVEL seclevel ON tablenames TO usernames

	LEVEL  shift 266


state 180
	security_right : CREATE ROLE .  (225)

	.  reduce 225


state 181
	security_right : CREATE USER .  (223)

	.  reduce 223


state 182
	security_right : DROP ROLE .  (226)

	.  reduce 226


state 183
	security_right : DROP USER .  (224)

	.  reduce 224


state 184
	security_right : ADD ROLE .  (230)

	.  reduce 230


state 185
	security_right : DEL ROLE .  (231)

	.  reduce 231


state 186
	security_right : CHANGE ROLE .  (232)

	.  reduce 232


state 187
	executor : ROLE '(' . rolenames ')'
	executor : ROLE '(' . rolenames ')' ',' USER '(' usernames ')'

	IDENTIFIER  shift 138

	rolename goto 144
	rolenames goto 267


state 188
	security_right : GRANT OBJRIGHT .  (237)

	.  reduce 237


state 189
	security_right : GRANT SYSRIGHT .  (239)

	.  reduce 239


state 190
	security_right : REVOKE OBJRIGHT .  (238)

	.  reduce 238


state 191
	security_right : REVOKE SYSRIGHT .  (240)

	.  reduce 240


state 192
	security_right : SET TABLE . SECURITY LEVEL

	SECURITY  shift 268


state 193
	security_right : SET USER . SECURITY LEVEL
	security_right : SET USER . ALLOW SECURITY LEVEL
	security_right : SET USER . CURRENT SECURITY LEVEL

	SECURITY  shift 269
	ALLOW  shift 270
	CURRENT  shift 271


state 194
	security_right : SET CHILD . ROLE

	ROLE  shift 272


state 195
	security_right : SET PARENT . ROLE

	ROLE  shift 273


state 196
	security_right : SET TOP . ROLE

	ROLE  shift 274


state 197
	security_right : AUDIT OBJRIGHT .  (243)

	.  reduce 243


state 198
	security_right : AUDIT SYSRIGHT .  (245)

	.  reduce 245


state 199
	security_right : AUDIT USER .  (241)

	.  reduce 241


state 200
	security_right : NOAUDIT OBJRIGHT .  (244)

	.  reduce 244


state 201
	security_right : NOAUDIT SYSRIGHT .  (246)

	.  reduce 246


state 202
	security_right : NOAUDIT USER .  (242)

	.  reduce 242


state 203
	executor : USER '(' . usernames ')'
	executor : USER '(' . usernames ')' ',' ROLE '(' rolenames ')'

	IDENTIFIER  shift 51

	username goto 149
	usernames goto 275


state 204
	objectrights : objectrights ',' . objectright

	SELECT  shift 96
	INSERT  shift 97
	UPDATE  shift 98
	YDELETE  shift 99

	objectright goto 276


state 205
	audit2 : AUDIT objectrights ON . tablename EXECUTED BY executor

	IDENTIFIER  shift 132

	tablename goto 277


state 206
	auditrights : auditrights ',' . auditright

	CREATE  shift 85
	DROP  shift 86
	ADD  shift 87
	DEL  shift 88
	CHANGE  shift 89
	GRANT  shift 91
	REVOKE  shift 92
	SET  shift 93
	AUDIT  shift 94
	NOAUDIT  shift 95

	systemright goto 103
	auditright goto 278
	security_right goto 105


state 207
	audit3 : AUDIT auditrights EXECUTED . BY executor

	BY  shift 279


state 208
	noaudit2 : NOAUDIT objectrights ON . tablename EXECUTED BY executor

	IDENTIFIER  shift 132

	tablename goto 280


state 209
	noaudit3 : NOAUDIT auditrights EXECUTED . BY executor

	BY  shift 281


state 210
	expr : expr . OPADD term
	expr : expr . OPSUB term
	factor : '(' expr . ')'
	factor : '(' expr . error

	')'  shift 282
	error  shift 283
	OPADD  shift 218
	OPSUB  shift 219


state 211
	colref : SECLEVEL '(' . fieldname ')'
	colref : SECLEVEL '(' . tablename '.' fieldname ')'

	IDENTIFIER  shift 118

	tablename goto 284
	fieldname goto 285


state 212
	factor : OPSUB factor .  (154)

	.  reduce 154


state 213
	seclevel : OPLESS ',' . OPMORE
	seclevel : OPLESS ',' . range OPMORE

	'{'  shift 286
	OPMORE  shift 287

	range goto 288


state 214
	seclevel : OPLESS OPMORE .  (93)