sql2.v

lex 和yacc 的中文指南

	USER  shift 63

	literal  goto 64
	atom  goto 269
	parameter_ref  goto 69
	parameter  goto 72


state 231
	subquery : '(' . SELECT opt_all_distinct selection table_exp ')'
	scalar_exp : '(' . scalar_exp ')'

	'('  shift 53
	'+'  shift 55
	'-'  shift 56
	NAME  shift 57
	STRING  shift 58
	INTNUM  shift 59
	APPROXNUM  shift 60
	AMMSC  shift 61
	PARAMETER  shift 62
	SELECT  shift 223
	USER  shift 63

	literal  goto 64
	column_ref  goto 65
	atom  goto 66
	scalar_exp  goto 91
	parameter_ref  goto 69
	function_ref  goto 71
	parameter  goto 72


state 232
	any_all_some : ALL .  (163)

	.  reduce 163


state 233
	any_all_some : ANY .  (162)

	.  reduce 162


state 234
	any_all_some : SOME .  (164)

	.  reduce 164


state 235
	comparison_predicate : scalar_exp COMPARISON scalar_exp .  (145)
	scalar_exp : scalar_exp . '+' scalar_exp
	scalar_exp : scalar_exp . '-' scalar_exp
	scalar_exp : scalar_exp . '*' scalar_exp
	scalar_exp : scalar_exp . '/' scalar_exp

	'*'  shift 97
	'+'  shift 98
	'-'  shift 99
	'/'  shift 100
	.  reduce 145


state 236
	comparison_predicate : scalar_exp COMPARISON subquery .  (146)

	.  reduce 146


state 237
	all_or_any_predicate : scalar_exp COMPARISON any_all_some . subquery

	'('  shift 183

	subquery  goto 270


state 238
	between_predicate : scalar_exp BETWEEN scalar_exp . AND scalar_exp
	scalar_exp : scalar_exp . '+' scalar_exp
	scalar_exp : scalar_exp . '-' scalar_exp
	scalar_exp : scalar_exp . '*' scalar_exp
	scalar_exp : scalar_exp . '/' scalar_exp

	'*'  shift 97
	'+'  shift 98
	'-'  shift 99
	'/'  shift 100
	AND  shift 271


state 239
	in_predicate : scalar_exp IN '(' . subquery ')'
	in_predicate : scalar_exp IN '(' . atom_commalist ')'

	'('  shift 183
	STRING  shift 58
	INTNUM  shift 59
	APPROXNUM  shift 60
	PARAMETER  shift 62
	USER  shift 63

	literal  goto 64
	atom  goto 272
	parameter_ref  goto 69
	subquery  goto 273
	atom_commalist  goto 274
	parameter  goto 72


state 240
	like_predicate : scalar_exp LIKE atom . opt_escape
	opt_escape : .  (151)

	ESCAPE  shift 275
	.  reduce 151

	opt_escape  goto 276


state 241
	column_commalist : column_commalist ',' column .  (35)

	.  reduce 35


state 242
	insert_atom : NULLX .  (92)

	.  reduce 92


state 243
	values_or_query_spec : VALUES '(' insert_atom_commalist . ')'
	insert_atom_commalist : insert_atom_commalist . ',' insert_atom

	')'  shift 277
	','  shift 278


state 244
	insert_atom_commalist : insert_atom .  (89)

	.  reduce 89


state 245
	insert_atom : atom .  (91)

	.  reduce 91


state 246
	column_ref : NAME '.' NAME '.' NAME .  (196)

	.  reduce 196


state 247
	function_ref : AMMSC '(' ALL scalar_exp ')' .  (187)

	.  reduce 187


state 248
	function_ref : AMMSC '(' DISTINCT column_ref ')' .  (186)

	.  reduce 186


state 249
	table_ref : table .  (123)
	table_ref : table . range_variable

	NAME  shift 279
	.  reduce 123

	range_variable  goto 280


state 250
	from_clause : FROM table_ref_commalist .  (120)
	table_ref_commalist : table_ref_commalist . ',' table_ref

	','  shift 281
	.  reduce 120


state 251
	table_ref_commalist : table_ref .  (121)

	.  reduce 121


state 252
	where_clause : WHERE . search_condition
	search_condition : .  (132)

	'('  shift 124
	'+'  shift 55
	'-'  shift 56
	NAME  shift 57
	STRING  shift 58
	INTNUM  shift 59
	APPROXNUM  shift 60
	NOT  shift 125
	AMMSC  shift 61
	EXISTS  shift 127
	PARAMETER  shift 62
	USER  shift 63
	.  reduce 132

	literal  goto 64
	search_condition  goto 128
	column_ref  goto 129
	atom  goto 66
	scalar_exp  goto 130
	parameter_ref  goto 69
	predicate  goto 131
	comparison_predicate  goto 132
	between_predicate  goto 133
	like_predicate  goto 134
	test_for_null  goto 135
	in_predicate  goto 136
	all_or_any_predicate  goto 137
	existence_test  goto 138
	function_ref  goto 71
	parameter  goto 72


state 253
	table_exp : from_clause opt_where_clause . opt_group_by_clause opt_having_clause
	opt_group_by_clause : .  (126)

	GROUP  shift 282
	.  reduce 126

	opt_group_by_clause  goto 283


state 254
	update_statement_positioned : UPDATE table SET assignment_commalist WHERE CURRENT OF . cursor

	NAME  shift 29

	cursor  goto 284


state 255
	base_table_def : CREATE TABLE table '(' . base_table_element_commalist ')'

	NAME  shift 105
	CHECK  shift 285
	FOREIGN  shift 286
	PRIMARY  shift 287
	UNIQUE  shift 288

	base_table_element_commalist  goto 289
	base_table_element  goto 290
	column_def  goto 291
	table_constraint_def  goto 292
	column  goto 293


state 256
	view_def : CREATE VIEW table opt_column_commalist . AS query_spec opt_with_check_option

	AS  shift 294


state 257
	privilege_def : GRANT privileges ON table . TO grantee_commalist opt_with_grant_option

	TO  shift 295


state 258
	operation_commalist : operation_commalist ',' operation .  (48)

	.  reduce 48


state 259
	query_spec : SELECT opt_all_distinct selection table_exp .  (116)

	.  reduce 116


state 260
	ordering_spec : INTNUM . opt_asc_desc
	opt_asc_desc : .  (66)

	ASC  shift 296
	DESC  shift 297
	.  reduce 66

	opt_asc_desc  goto 298


state 261
	opt_order_by_clause : ORDER BY ordering_spec_commalist .  (61)
	ordering_spec_commalist : ordering_spec_commalist . ',' ordering_spec

	','  shift 299
	.  reduce 61


state 262
	ordering_spec_commalist : ordering_spec .  (62)

	.  reduce 62


state 263
	ordering_spec : column_ref . opt_asc_desc
	opt_asc_desc : .  (66)

	ASC  shift 296
	DESC  shift 297
	.  reduce 66

	opt_asc_desc  goto 300


state 264
	query_exp : query_exp UNION ALL query_term .  (113)

	.  reduce 113


state 265
	subquery : '(' SELECT opt_all_distinct . selection table_exp ')'

	'('  shift 53
	'*'  shift 54
	'+'  shift 55
	'-'  shift 56
	NAME  shift 57
	STRING  shift 58
	INTNUM  shift 59
	APPROXNUM  shift 60
	AMMSC  shift 61
	PARAMETER  shift 62
	USER  shift 63

	literal  goto 64
	column_ref  goto 65
	atom  goto 66
	selection  goto 301
	scalar_exp  goto 68
	parameter_ref  goto 69
	scalar_exp_commalist  goto 70
	function_ref  goto 71
	parameter  goto 72


state 266
	test_for_null : column_ref IS NOT NULLX .  (153)

	.  reduce 153


state 267
	between_predicate : scalar_exp NOT BETWEEN scalar_exp . AND scalar_exp
	scalar_exp : scalar_exp . '+' scalar_exp
	scalar_exp : scalar_exp . '-' scalar_exp
	scalar_exp : scalar_exp . '*' scalar_exp
	scalar_exp : scalar_exp . '/' scalar_exp

	'*'  shift 97
	'+'  shift 98
	'-'  shift 99
	'/'  shift 100
	AND  shift 302


state 268
	in_predicate : scalar_exp NOT IN '(' . subquery ')'
	in_predicate : scalar_exp NOT IN '(' . atom_commalist ')'

	'('  shift 183
	STRING  shift 58
	INTNUM  shift 59
	APPROXNUM  shift 60
	PARAMETER  shift 62
	USER  shift 63

	literal  goto 64
	atom  goto 272
	parameter_ref  goto 69
	subquery  goto 303
	atom_commalist  goto 304
	parameter  goto 72


state 269
	like_predicate : scalar_exp NOT LIKE atom . opt_escape
	opt_escape : .  (151)

	ESCAPE  shift 275
	.  reduce 151

	opt_escape  goto 305


state 270
	all_or_any_predicate : scalar_exp COMPARISON any_all_some subquery .  (161)

	.  reduce 161


state 271
	between_predicate : scalar_exp BETWEEN scalar_exp AND . scalar_exp

	'('  shift 53
	'+'  shift 55
	'-'  shift 56
	NAME  shift 57
	STRING  shift 58
	INTNUM  shift 59
	APPROXNUM  shift 60
	AMMSC  shift 61
	PARAMETER  shift 62
	USER  shift 63

	literal  goto 64
	column_ref  goto 65
	atom  goto 66
	scalar_exp  goto 306
	parameter_ref  goto 69
	function_ref  goto 71
	parameter  goto 72


state 272
	atom_commalist : atom .  (159)

	.  reduce 159


state 273
	in_predicate : scalar_exp IN '(' subquery . ')'

	')'  shift 307


state 274
	in_predicate : scalar_exp IN '(' atom_commalist . ')'
	atom_commalist : atom_commalist . ',' atom

	')'  shift 308
	','  shift 309


state 275
	opt_escape : ESCAPE . atom

	STRING  shift 58
	INTNUM  shift 59
	APPROXNUM  shift 60
	PARAMETER  shift 62
	USER  shift 63

	literal  goto 64
	atom  goto 310
	parameter_ref  goto 69
	parameter  goto 72


state 276
	like_predicate : scalar_exp LIKE atom opt_escape .  (150)

	.  reduce 150


state 277
	values_or_query_spec : VALUES '(' insert_atom_commalist ')' .  (87)

	.  reduce 87


state 278
	insert_atom_commalist : insert_atom_commalist ',' . insert_atom

	STRING  shift 58
	INTNUM  shift 59
	APPROXNUM  shift 60
	NULLX  shift 242
	PARAMETER  shift 62
	USER  shift 63

	literal  goto 64
	insert_atom  goto 311
	atom  goto 245
	parameter_ref  goto 69
	parameter  goto 72


state 279
	range_variable : NAME .  (214)

	.  reduce 214


state 280
	table_ref : table range_variable .  (124)

	.  reduce 124


state 281
	table_ref_commalist : table_ref_commalist ',' . table_ref

	NAME  shift 42

	table  goto 249
	table_ref  goto 312


state 282
	opt_group_by_clause : GROUP . BY column_ref_commalist

	BY  shift 313


state 283
	table_exp : from_clause opt_where_clause opt_group_by_clause . opt_having_clause
	opt_having_clause : .  (130)

	HAVING  shift 314
	.  reduce 130

	opt_having_clause  goto 315


state 284
	update_statement_positioned : UPDATE table SET assignment_commalist WHERE CURRENT OF cursor .  (99)

	.  reduce 99


state 285
	table_constraint_def : CHECK . '(' search_condition ')'

	'('  shift 316


state 286
	table_constraint_def : FOREIGN . KEY '(' column_commalist ')' REFERENCES table
	table_constraint_def : FOREIGN . KEY '(' column_commalist ')' REFERENCES table '(' column_commalist ')'

	KEY  shift 317


state 287
	table_constraint_def : PRIMARY . KEY '(' column_commalist ')'

	KEY  shift 318


state 288
	table_constraint_def : UNIQUE . '(' column_commalist ')'

	'('  shift 319


state 289
	base_table_def : CREATE TABLE table '(' base_table_element_commalist . ')'
	base_table_element_commalist : base_table_element_commalist . ',' base_table_element

	')'  shift 320
	','  shift 321


state 290
	base_table_element_commalist : base_table_element .  (13)

	.  reduce 13


state 291
	base_table_element : column_def .  (15)

	.  reduce 15


state 292
	base_table_element : table_constraint_def .  (16)

	.  reduce 16


state 293
	column_def : column . data_type column_def_opt_list

	CHARACTER  shift 322
	DECIMAL  shift 323
	DOUBLE  shift 324
	FLOAT  shift 325
	INTEGER  shift 326
	NUMERIC  shift 327
	REAL  shift 328
	SMALLINT  shift 329

	data_type  goto 330


state 294
	view_def : CREATE VIEW table opt_column_commalist AS . query_spec opt_with_check_option

	SELECT  shift 120

	query_spec  goto 331


state 295
	privilege_def : GRANT privileges ON table TO . grantee_commalist opt_with_grant_option

	NAME  shift 80
	PUBLIC  shift 332

	user  goto 333
	grantee_commalist  goto 334
	grantee  goto 335


state 296
	opt_asc_desc : ASC .  (67)

	.  reduce 67


state 297
	opt_asc_desc : DESC .  (68)

	.  reduce 68


state 298
	ordering_spec : INTNUM opt_asc_desc .  (64)

	.  reduce 64


state 299
	ordering_spec_commalist : ordering_spec_commalist ',' . ordering_spec

	NAME  shift 57
	INTNUM  shift 260

	ordering_spec  goto 336
	column_ref  goto 263


state 300
	ordering_spec : column_ref opt_asc_desc .  (65)

	.  reduce 65


state 301
	subquery : '(' SELECT opt_all_distinct selection . table_exp ')'

	FROM