sdbms_sql.v

使用yacc的一个例子

	.  reduce 93


state 215
	class : INTEGER .  (98)

	.  reduce 98


state 216
	seclevel : OPLESS class . ',' OPMORE
	seclevel : OPLESS class . ',' range OPMORE

	','  shift 289


state 217
	colref : tablename '.' . fieldname

	IDENTIFIER  shift 240

	fieldname goto 290


state 218
	expr : expr OPADD . term

	'('  shift 111
	SECLEVEL  shift 112
	OPSUB  shift 113
	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
	term goto 291
	factor goto 126
	colref goto 127
	bool_value goto 128


state 219
	expr : expr OPSUB . term

	'('  shift 111
	SECLEVEL  shift 112
	OPSUB  shift 113
	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
	term goto 292
	factor goto 126
	colref goto 127
	bool_value goto 128


state 220
	term : term OPMUL . factor

	'('  shift 111
	SECLEVEL  shift 112
	OPSUB  shift 113
	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
	factor goto 293
	colref goto 127
	bool_value goto 128


state 221
	term : term OPDIV . factor

	'('  shift 111
	SECLEVEL  shift 112
	OPSUB  shift 113
	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
	factor goto 294
	colref goto 127
	bool_value goto 128


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

	IDENTIFIER  shift 132

	tablename goto 147
	tablenames goto 295


state 223
	select_sub_list : select_sub_list ',' . expr

	'('  shift 111
	SECLEVEL  shift 112
	OPSUB  shift 113
	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 296
	term goto 125
	factor goto 126
	colref goto 127
	bool_value goto 128


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

	'('  shift 297
	VALUES  shift 298

	insert_collist goto 299


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

	IDENTIFIER  shift 240

	fieldname goto 300
	set_list goto 301
	set_clause goto 302


state 226
	delete : YDELETE FROM tablename .  (184)
	delete : YDELETE FROM tablename . WHERE conditions

	WHERE  shift 303
	.  reduce 184


state 227
	sqls : sqls ';' sql .  (1)

	.  reduce 1


state 228
	connect_database : CONNECT username WITH PASSWORD . password

	STRING  shift 304

	password goto 305


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

	WITH  shift 306


state 230
	create_role : CREATE ROLE rolename AS . CHILD OF rolename
	create_role : CREATE ROLE rolename AS . PARENT OF rolenames

	CHILD  shift 307
	PARENT  shift 308


state 231
	tabcollist : '(' . tabcols ')'
	tabcollist : '(' . tabcols error

	PRIMARY  shift 309
	IDENTIFIER  shift 240

	fieldname goto 310
	tabcols goto 311
	tabcol goto 312
	coldef goto 313
	keydef goto 314


state 232
	create_table : CREATE TABLE tablename tabcollist .  (116)
	create_table : CREATE TABLE tablename tabcollist . WITH SECLEVEL seclevel

	WITH  shift 315
	.  reduce 116


state 233
	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

	PASSWORD  shift 316


state 234
	rolenames : rolenames ',' . rolename

	IDENTIFIER  shift 138

	rolename goto 317


state 235
	tablenames : tablenames ',' . tablename

	IDENTIFIER  shift 132

	tablename goto 318


state 236
	usernames : usernames ',' . username

	IDENTIFIER  shift 51

	username goto 319


state 237
	add_user_to_role : ADD USER usernames TO . rolenames

	IDENTIFIER  shift 138

	rolename goto 144
	rolenames goto 320


state 238
	del_user_from_role : DEL USER usernames FROM . rolenames

	IDENTIFIER  shift 138

	rolename goto 144
	rolenames goto 321


state 239
	change_role : CHANGE USER usernames TO . rolenames

	IDENTIFIER  shift 138

	rolename goto 144
	rolenames goto 322


state 240
	fieldname : IDENTIFIER .  (113)

	.  reduce 113


state 241
	fieldnames : fieldname .  (115)

	.  reduce 115


state 242
	operation : SELECT '(' fieldnames . ')'
	fieldnames : fieldnames . ',' fieldname

	')'  shift 323
	','  shift 324


state 243
	operation : INSERT '(' fieldnames . ')'
	fieldnames : fieldnames . ',' fieldname

	')'  shift 325
	','  shift 324


state 244
	operation : UPDATE '(' fieldnames . ')'
	fieldnames : fieldnames . ',' fieldname

	')'  shift 326
	','  shift 324


state 245
	operation : YDELETE '(' fieldnames . ')'
	fieldnames : fieldnames . ',' fieldname

	')'  shift 327
	','  shift 324


state 246
	systemrights : systemrights ',' systemright .  (65)

	.  reduce 65


state 247
	rolenames : rolenames . ',' rolename
	grant1 : GRANT systemrights TO rolenames .  (63)

	','  shift 234
	.  reduce 63


state 248
	operations : operations ',' operation .  (83)

	.  reduce 83


state 249
	factor : '(' . expr ')'
	factor : '(' . expr error
	condfactor : '(' . 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 328
	term goto 125
	factor goto 126
	colref goto 127
	conditions goto 329
	condition goto 253
	condfactor goto 254
	comp_clause goto 255
	bool_value goto 128


state 250
	condfactor : OPNOT . condfactor

	'('  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
	condfactor goto 330
	comp_clause goto 255
	bool_value goto 128


state 251
	expr : expr . OPADD term
	expr : expr . OPSUB term
	comp_clause : expr . OPEQU expr
	comp_clause : expr . OPUNEQU expr
	comp_clause : expr . OPLESS expr
	comp_clause : expr . OPLESSEQU expr
	comp_clause : expr . OPMORE expr
	comp_clause : expr . OPMOREEQU expr

	OPADD  shift 218
	OPSUB  shift 219
	OPEQU  shift 331
	OPUNEQU  shift 332
	OPLESS  shift 333
	OPLESSEQU  shift 334
	OPMORE  shift 335
	OPMOREEQU  shift 336


state 252
	conditions : conditions . OPOR condition
	where_clause : WHERE conditions .  (191)

	OPOR  shift 337
	.  reduce 191


state 253
	conditions : condition .  (172)
	condition : condition . OPAND condfactor

	OPAND  shift 338
	.  reduce 172


state 254
	condition : condfactor .  (174)

	.  reduce 174


state 255
	condfactor : comp_clause .  (177)

	.  reduce 177


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

	IDENTIFIER  shift 132

	tablename goto 339


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

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

	operations goto 340
	operation goto 75


state 258
	rolenames : rolenames . ',' rolename
	revoke1 : REVOKE systemrights FROM rolenames .  (64)

	','  shift 234
	.  reduce 64


state 259
	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

	IDENTIFIER  shift 132

	tablename goto 341


state 260
	rolenames : rolenames . ',' rolename
	set_child_role : SET CHILD ROLE rolenames . OF rolename

	','  shift 234
	OF  shift 342


state 261
	set_parent_role : SET PARENT ROLE rolename . OF rolenames

	OF  shift 343


state 262
	rolenames : rolenames . ',' rolename
	set_top_role : SET TOP ROLE rolenames .  (59)

	','  shift 234
	.  reduce 59


state 263
	set_user_seclevel : SET SECURITY LEVEL class . TO usernames

	TO  shift 344


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

	TO  shift 345
	ON  shift 346


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

	OPLESS  shift 115

	seclevel goto 347


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

	OPLESS  shift 115

	seclevel goto 348


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

	')'  shift 349
	','  shift 234


state 268
	security_right : SET TABLE SECURITY . LEVEL

	LEVEL  shift 350


state 269
	security_right : SET USER SECURITY . LEVEL

	LEVEL  shift 351


state 270
	security_right : SET USER ALLOW . SECURITY LEVEL

	SECURITY  shift 352


state 271
	security_right : SET USER CURRENT . SECURITY LEVEL

	SECURITY  shift 353


state 272
	security_right : SET CHILD ROLE .  (228)

	.  reduce 228


state 273
	security_right : SET PARENT ROLE .  (227)

	.  reduce 227


state 274
	security_right : SET TOP ROLE .  (229)

	.  reduce 229


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

	')'  shift 354
	','  shift 236


state 276
	objectrights : objectrights ',' objectright .  (211)

	.  reduce 211


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

	EXECUTED  shift 355


state 278
	auditrights : auditrights ',' auditright .  (219)

	.  reduce 219


state 279
	audit3 : AUDIT auditrights EXECUTED BY . executor

	ROLE  shift 90
	USER  shift 100

	executor goto 356


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

	EXECUTED  shift 357


state 281
	noaudit3 : NOAUDIT auditrights EXECUTED BY . executor

	ROLE  shift 90
	USER  shift 100

	executor goto 358


state 282
	factor : '(' expr ')' .  (152)

	.  reduce 152


state 283
	factor : '(' expr error .  (153)

	.  reduce 153


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

	'.'  shift 359


state 285
	colref : SECLEVEL '(' fieldname . ')'

	')'  shift 360


state 286
	range : '{' . '}'
	range : '{' . rangeitems '}'
	range : '{' . rangeitems error

	'}'  shift 361
	STRING  shift 362

	rangeitem goto 363
	rangeitems goto 364


state 287
	seclevel : OPLESS ',' OPMORE .  (94)

	.  reduce 94


state 288
	seclevel : OPLESS ',' range . OPMORE

	OPMORE  shift 365


state 289
	seclevel : OPLESS class ',' . OPMORE
	seclevel : OPLESS class ',' . range OPMORE

	'{'  shift 286
	OPMORE  shift 366

	range goto 367


state 290
	colref : tablename '.' fieldname .  (164)

	.  reduce 164


state 291
	expr : expr OPADD term .  (146)
	term : term . OPMUL factor
	term : term . OPDIV factor

	OPMUL  shift 220
	OPDIV  shift 221
	.  reduce 146


state 292
	expr : expr OPSUB term .  (147)
	term : term . OPMUL factor
	term : term . OPDIV factor

	OPMUL  shift 220
	OPDIV  shift 221
	.  reduce 147


state 293
	term : term OPMUL factor .  (149)

	.  reduce 149


state 294
	term : term OPDIV factor .  (150)