sql2.v

lex 和yacc 的中文指南

	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 156
	parameter_ref  goto 69
	function_ref  goto 71
	parameter  goto 72


state 102
	parameter_ref : parameter INDICATOR . parameter

	PARAMETER  shift 62

	parameter  goto 157


state 103
	parameter_ref : parameter parameter .  (183)

	.  reduce 183


state 104
	table : NAME '.' NAME .  (193)

	.  reduce 193


state 105
	column : NAME .  (211)

	.  reduce 211


state 106
	assignment : column . '=' scalar_exp
	assignment : column . '=' NULLX

	'='  shift 158


state 107
	update_statement_positioned : UPDATE table SET assignment_commalist . WHERE CURRENT OF cursor
	assignment_commalist : assignment_commalist . ',' assignment
	update_statement_searched : UPDATE table SET assignment_commalist . opt_where_clause
	opt_where_clause : .  (109)

	','  shift 159
	WHERE  shift 160
	.  reduce 109

	opt_where_clause  goto 161
	where_clause  goto 85


state 108
	assignment_commalist : assignment .  (101)

	.  reduce 101


state 109
	sql : WHENEVER NOT FOUND when_action .  (216)

	.  reduce 216


state 110
	when_action : GOTO NAME .  (218)

	.  reduce 218


state 111
	base_table_def : CREATE . TABLE table '(' base_table_element_commalist ')'
	view_def : CREATE . VIEW table opt_column_commalist AS query_spec opt_with_check_option

	TABLE  shift 162
	VIEW  shift 163


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

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

	privileges  goto 170
	operation_commalist  goto 171
	operation  goto 172


state 113
	schema : CREATE SCHEMA AUTHORIZATION user opt_schema_element_list .  (4)

	.  reduce 4


state 114
	opt_schema_element_list : schema_element_list .  (6)
	schema_element_list : schema_element_list . schema_element

	CREATE  shift 111
	GRANT  shift 112
	.  reduce 6

	schema_element  goto 173
	base_table_def  goto 116
	view_def  goto 117
	privilege_def  goto 118


state 115
	schema_element_list : schema_element .  (7)

	.  reduce 7


state 116
	schema_element : base_table_def .  (9)

	.  reduce 9


state 117
	schema_element : view_def .  (10)

	.  reduce 10


state 118
	schema_element : privilege_def .  (11)

	.  reduce 11


state 119
	query_term : '(' . query_exp ')'

	'('  shift 119
	SELECT  shift 120

	query_spec  goto 121
	query_exp  goto 174
	query_term  goto 123


state 120
	query_spec : SELECT . opt_all_distinct selection table_exp
	opt_all_distinct : .  (96)

	ALL  shift 39
	DISTINCT  shift 40
	.  reduce 96

	opt_all_distinct  goto 175


state 121
	query_term : query_spec .  (114)

	.  reduce 114


state 122
	cursor_def : DECLARE cursor CURSOR FOR query_exp . opt_order_by_clause
	query_exp : query_exp . UNION query_term
	query_exp : query_exp . UNION ALL query_term
	opt_order_by_clause : .  (60)

	ORDER  shift 176
	UNION  shift 177
	.  reduce 60

	opt_order_by_clause  goto 178


state 123
	query_exp : query_term .  (111)

	.  reduce 111


state 124
	search_condition : '(' . search_condition ')'
	scalar_exp : '(' . scalar_exp ')'
	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 179
	column_ref  goto 129
	atom  goto 66
	scalar_exp  goto 180
	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 125
	search_condition : NOT . 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 181
	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 126
	delete_statement_positioned : DELETE FROM table WHERE CURRENT . OF cursor

	OF  shift 182


state 127
	existence_test : EXISTS . subquery

	'('  shift 183

	subquery  goto 184


state 128
	where_clause : WHERE search_condition .  (125)
	search_condition : search_condition . OR search_condition
	search_condition : search_condition . AND search_condition

	OR  shift 185
	AND  shift 186
	.  reduce 125


state 129
	test_for_null : column_ref . IS NOT NULLX
	test_for_null : column_ref . IS NULLX
	scalar_exp : column_ref .  (174)

	IS  shift 187
	.  reduce 174


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

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


state 131
	search_condition : predicate .  (137)

	.  reduce 137


state 132
	predicate : comparison_predicate .  (138)

	.  reduce 138


state 133
	predicate : between_predicate .  (139)

	.  reduce 139


state 134
	predicate : like_predicate .  (140)

	.  reduce 140


state 135
	predicate : test_for_null .  (141)

	.  reduce 141


state 136
	predicate : in_predicate .  (142)

	.  reduce 142


state 137
	predicate : all_or_any_predicate .  (143)

	.  reduce 143


state 138
	predicate : existence_test .  (144)

	.  reduce 144


state 139
	target_commalist : target_commalist ',' . target

	PARAMETER  shift 62

	target  goto 193
	parameter_ref  goto 88
	parameter  goto 72


state 140
	column_commalist : column .  (34)

	.  reduce 34


state 141
	column_commalist : column_commalist . ',' column
	opt_column_commalist : '(' column_commalist . ')'

	')'  shift 194
	','  shift 195


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

	'('  shift 196


state 143
	values_or_query_spec : query_spec .  (88)

	.  reduce 88


state 144
	insert_statement : INSERT INTO table opt_column_commalist values_or_query_spec .  (86)

	.  reduce 86


state 145
	scalar_exp : '(' scalar_exp ')' .  (176)

	.  reduce 176


state 146
	column_ref : NAME '.' NAME .  (195)
	column_ref : NAME '.' NAME . '.' NAME

	'.'  shift 197
	.  reduce 195


state 147
	function_ref : AMMSC '(' '*' . ')'

	')'  shift 198


state 148
	function_ref : AMMSC '(' ALL . 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 199
	parameter_ref  goto 69
	function_ref  goto 71
	parameter  goto 72


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

	NAME  shift 57

	column_ref  goto 200


state 150
	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 '(' scalar_exp . ')'

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


state 151
	select_statement : SELECT opt_all_distinct selection INTO target_commalist . table_exp
	target_commalist : target_commalist . ',' target

	','  shift 139
	FROM  shift 202

	table_exp  goto 203
	from_clause  goto 204


state 152
	scalar_exp : scalar_exp . '+' scalar_exp
	scalar_exp : scalar_exp . '-' scalar_exp
	scalar_exp : scalar_exp '*' scalar_exp .  (169)
	scalar_exp : scalar_exp . '*' scalar_exp
	scalar_exp : scalar_exp . '/' scalar_exp

	.  reduce 169


state 153
	scalar_exp : scalar_exp '+' scalar_exp .  (167)
	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 100
	.  reduce 167


state 154
	scalar_exp : scalar_exp . '+' scalar_exp
	scalar_exp : scalar_exp '-' scalar_exp .  (168)
	scalar_exp : scalar_exp . '-' scalar_exp
	scalar_exp : scalar_exp . '*' scalar_exp
	scalar_exp : scalar_exp . '/' scalar_exp

	'*'  shift 97
	'/'  shift 100
	.  reduce 168


state 155
	scalar_exp : scalar_exp . '+' scalar_exp
	scalar_exp : scalar_exp . '-' scalar_exp
	scalar_exp : scalar_exp . '*' scalar_exp
	scalar_exp : scalar_exp '/' scalar_exp .  (170)
	scalar_exp : scalar_exp . '/' scalar_exp

	.  reduce 170


state 156
	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_commalist : scalar_exp_commalist ',' scalar_exp .  (178)

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


state 157
	parameter_ref : parameter INDICATOR parameter .  (184)

	.  reduce 184


state 158
	assignment : column '=' . scalar_exp
	assignment : column '=' . NULLX

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

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


state 159
	assignment_commalist : assignment_commalist ',' . assignment

	NAME  shift 105

	column  goto 106
	assignment  goto 207


state 160
	update_statement_positioned : UPDATE table SET assignment_commalist WHERE . CURRENT OF cursor
	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
	CURRENT  shift 208
	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 161
	update_statement_searched : UPDATE table SET assignment_commalist opt_where_clause .  (105)

	.  reduce 105


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

	NAME  shift 42

	table  goto 209


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

	NAME  shift 42

	table  goto 210


state 164
	privileges : ALL . PRIVILEGES
	privileges : ALL .  (45)

	PRIVILEGES  shift 211
	.  reduce 45


state 165
	operation : DELETE .  (51)

	.  reduce 51


state 166
	operation : INSERT .  (50)