sql2.v

lex 和yacc 的中文指南

	.  reduce 50


state 167
	operation : REFERENCES . opt_column_commalist
	opt_column_commalist : .  (39)

	'('  shift 89
	.  reduce 39

	opt_column_commalist  goto 212


state 168
	operation : SELECT .  (49)

	.  reduce 49


state 169
	operation : UPDATE . opt_column_commalist
	opt_column_commalist : .  (39)

	'('  shift 89
	.  reduce 39

	opt_column_commalist  goto 213


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

	ON  shift 214


state 171
	privileges : operation_commalist .  (46)
	operation_commalist : operation_commalist . ',' operation

	','  shift 215
	.  reduce 46


state 172
	operation_commalist : operation .  (47)

	.  reduce 47


state 173
	schema_element_list : schema_element_list schema_element .  (8)

	.  reduce 8


state 174
	query_exp : query_exp . UNION query_term
	query_exp : query_exp . UNION ALL query_term
	query_term : '(' query_exp . ')'

	')'  shift 216
	UNION  shift 177


state 175
	query_spec : 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 217
	scalar_exp  goto 68
	parameter_ref  goto 69
	scalar_exp_commalist  goto 70
	function_ref  goto 71
	parameter  goto 72


state 176
	opt_order_by_clause : ORDER . BY ordering_spec_commalist

	BY  shift 218


state 177
	query_exp : query_exp UNION . query_term
	query_exp : query_exp UNION . ALL query_term

	'('  shift 119
	ALL  shift 219
	SELECT  shift 120

	query_spec  goto 121
	query_term  goto 220


state 178
	cursor_def : DECLARE cursor CURSOR FOR query_exp opt_order_by_clause .  (59)

	.  reduce 59


state 179
	search_condition : search_condition . OR search_condition
	search_condition : search_condition . AND search_condition
	search_condition : '(' search_condition . ')'

	')'  shift 221
	OR  shift 185
	AND  shift 186


state 180
	comparison_predicate : scalar_exp . COMPARISON scalar_exp
	comparison_predicate : scalar_exp . COMPARISON subquery
	between_predicate : scalar_exp . NOT BETWEEN scalar_exp AND scalar_exp
	between_predicate : scalar_exp . BETWEEN scalar_exp AND scalar_exp
	like_predicate : scalar_exp . NOT LIKE atom opt_escape
	like_predicate : scalar_exp . LIKE atom opt_escape
	in_predicate : scalar_exp . NOT IN '(' subquery ')'
	in_predicate : scalar_exp . IN '(' subquery ')'
	in_predicate : scalar_exp . NOT IN '(' atom_commalist ')'
	in_predicate : scalar_exp . IN '(' atom_commalist ')'
	all_or_any_predicate : scalar_exp . COMPARISON any_all_some subquery
	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 : '(' scalar_exp . ')'

	')'  shift 145
	'*'  shift 97
	'+'  shift 98
	'-'  shift 99
	'/'  shift 100
	NOT  shift 188
	COMPARISON  shift 189
	BETWEEN  shift 190
	IN  shift 191
	LIKE  shift 192


state 181
	search_condition : search_condition . OR search_condition
	search_condition : search_condition . AND search_condition
	search_condition : NOT search_condition .  (135)

	.  reduce 135


state 182
	delete_statement_positioned : DELETE FROM table WHERE CURRENT OF . cursor

	NAME  shift 29

	cursor  goto 222


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

	SELECT  shift 223


state 184
	existence_test : EXISTS subquery .  (165)

	.  reduce 165


state 185
	search_condition : search_condition OR . 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 224
	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 186
	search_condition : search_condition AND . 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 225
	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 187
	test_for_null : column_ref IS . NOT NULLX
	test_for_null : column_ref IS . NULLX

	NOT  shift 226
	NULLX  shift 227


state 188
	between_predicate : scalar_exp NOT . BETWEEN scalar_exp AND scalar_exp
	like_predicate : scalar_exp NOT . LIKE atom opt_escape
	in_predicate : scalar_exp NOT . IN '(' subquery ')'
	in_predicate : scalar_exp NOT . IN '(' atom_commalist ')'

	BETWEEN  shift 228
	IN  shift 229
	LIKE  shift 230


state 189
	comparison_predicate : scalar_exp COMPARISON . scalar_exp
	comparison_predicate : scalar_exp COMPARISON . subquery
	all_or_any_predicate : scalar_exp COMPARISON . any_all_some subquery

	'('  shift 231
	'+'  shift 55
	'-'  shift 56
	NAME  shift 57
	STRING  shift 58
	INTNUM  shift 59
	APPROXNUM  shift 60
	ALL  shift 232
	AMMSC  shift 61
	ANY  shift 233
	PARAMETER  shift 62
	SOME  shift 234
	USER  shift 63

	literal  goto 64
	column_ref  goto 65
	atom  goto 66
	scalar_exp  goto 235
	parameter_ref  goto 69
	subquery  goto 236
	any_all_some  goto 237
	function_ref  goto 71
	parameter  goto 72


state 190
	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 238
	parameter_ref  goto 69
	function_ref  goto 71
	parameter  goto 72


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

	'('  shift 239


state 192
	like_predicate : scalar_exp LIKE . atom opt_escape

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

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


state 193
	target_commalist : target_commalist ',' target .  (107)

	.  reduce 107


state 194
	opt_column_commalist : '(' column_commalist ')' .  (40)

	.  reduce 40


state 195
	column_commalist : column_commalist ',' . column

	NAME  shift 105

	column  goto 241


state 196
	values_or_query_spec : VALUES '(' . insert_atom_commalist ')'

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

	literal  goto 64
	insert_atom_commalist  goto 243
	insert_atom  goto 244
	atom  goto 245
	parameter_ref  goto 69
	parameter  goto 72


state 197
	column_ref : NAME '.' NAME '.' . NAME

	NAME  shift 246


state 198
	function_ref : AMMSC '(' '*' ')' .  (185)

	.  reduce 185


state 199
	scalar_exp : scalar_exp . '+' scalar_exp
	scalar_exp : scalar_exp . '-' scalar_exp
	scalar_exp : scalar_exp . '*' scalar_exp
	scalar_exp : scalar_exp . '/' scalar_exp
	function_ref : AMMSC '(' ALL scalar_exp . ')'

	')'  shift 247
	'*'  shift 97
	'+'  shift 98
	'-'  shift 99
	'/'  shift 100


state 200
	function_ref : AMMSC '(' DISTINCT column_ref . ')'

	')'  shift 248


state 201
	function_ref : AMMSC '(' scalar_exp ')' .  (188)

	.  reduce 188


state 202
	from_clause : FROM . table_ref_commalist

	NAME  shift 42

	table  goto 249
	table_ref_commalist  goto 250
	table_ref  goto 251


state 203
	select_statement : SELECT opt_all_distinct selection INTO target_commalist table_exp .  (95)

	.  reduce 95


state 204
	table_exp : from_clause . opt_where_clause opt_group_by_clause opt_having_clause
	opt_where_clause : .  (109)

	WHERE  shift 252
	.  reduce 109

	opt_where_clause  goto 253
	where_clause  goto 85


state 205
	assignment : column '=' NULLX .  (104)

	.  reduce 104


state 206
	assignment : column '=' scalar_exp .  (103)
	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 103


state 207
	assignment_commalist : assignment_commalist ',' assignment .  (102)

	.  reduce 102


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

	OF  shift 254


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

	'('  shift 255


state 210
	view_def : CREATE VIEW table . opt_column_commalist AS query_spec opt_with_check_option
	opt_column_commalist : .  (39)

	'('  shift 89
	.  reduce 39

	opt_column_commalist  goto 256


state 211
	privileges : ALL PRIVILEGES .  (44)

	.  reduce 44


state 212
	operation : REFERENCES opt_column_commalist .  (53)

	.  reduce 53


state 213
	operation : UPDATE opt_column_commalist .  (52)

	.  reduce 52


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

	NAME  shift 42

	table  goto 257


state 215
	operation_commalist : operation_commalist ',' . operation

	DELETE  shift 165
	INSERT  shift 166
	REFERENCES  shift 167
	SELECT  shift 168
	UPDATE  shift 169

	operation  goto 258


state 216
	query_term : '(' query_exp ')' .  (115)

	.  reduce 115


state 217
	query_spec : SELECT opt_all_distinct selection . table_exp

	FROM  shift 202

	table_exp  goto 259
	from_clause  goto 204


state 218
	opt_order_by_clause : ORDER BY . ordering_spec_commalist

	NAME  shift 57
	INTNUM  shift 260

	ordering_spec_commalist  goto 261
	ordering_spec  goto 262
	column_ref  goto 263


state 219
	query_exp : query_exp UNION ALL . query_term

	'('  shift 119
	SELECT  shift 120

	query_spec  goto 121
	query_term  goto 264


state 220
	query_exp : query_exp UNION query_term .  (112)

	.  reduce 112


state 221
	search_condition : '(' search_condition ')' .  (136)

	.  reduce 136


state 222
	delete_statement_positioned : DELETE FROM table WHERE CURRENT OF cursor .  (83)

	.  reduce 83


state 223
	subquery : '(' SELECT . opt_all_distinct selection table_exp ')'
	opt_all_distinct : .  (96)

	ALL  shift 39
	DISTINCT  shift 40
	.  reduce 96

	opt_all_distinct  goto 265


state 224
	search_condition : search_condition OR search_condition .  (133)
	search_condition : search_condition . OR search_condition
	search_condition : search_condition . AND search_condition

	AND  shift 186
	.  reduce 133


state 225
	search_condition : search_condition . OR search_condition
	search_condition : search_condition AND search_condition .  (134)
	search_condition : search_condition . AND search_condition

	.  reduce 134


state 226
	test_for_null : column_ref IS NOT . NULLX

	NULLX  shift 266


state 227
	test_for_null : column_ref IS NULLX .  (154)

	.  reduce 154


state 228
	between_predicate : scalar_exp NOT 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 267
	parameter_ref  goto 69
	function_ref  goto 71
	parameter  goto 72


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

	'('  shift 268


state 230
	like_predicate : scalar_exp NOT LIKE . atom opt_escape

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