sql2.v

lex 和yacc 的中文指南

state 40
	opt_all_distinct : DISTINCT .  (98)

	.  reduce 98


state 41
	select_statement : SELECT opt_all_distinct . selection INTO target_commalist 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 67
	scalar_exp  goto 68
	parameter_ref  goto 69
	scalar_exp_commalist  goto 70
	function_ref  goto 71
	parameter  goto 72


state 42
	table : NAME .  (192)
	table : NAME . '.' NAME

	'.'  shift 73
	.  reduce 192


state 43
	update_statement_positioned : UPDATE table . SET assignment_commalist WHERE CURRENT OF cursor
	update_statement_searched : UPDATE table . SET assignment_commalist opt_where_clause

	SET  shift 74


state 44
	sql : WHENEVER NOT . FOUND when_action

	FOUND  shift 75


state 45
	sql : WHENEVER SQLERROR . when_action

	CONTINUE  shift 76
	GOTO  shift 77

	when_action  goto 78


state 46
	sql_list : sql_list sql . ';'

	';'  shift 79


state 47
	sql_list : sql ';' .  (1)

	.  reduce 1


state 48
	schema : CREATE SCHEMA AUTHORIZATION . user opt_schema_element_list

	NAME  shift 80

	user  goto 81


state 49
	cursor_def : DECLARE cursor CURSOR . FOR query_exp opt_order_by_clause

	FOR  shift 82


state 50
	delete_statement_positioned : DELETE FROM table . WHERE CURRENT OF cursor
	delete_statement_searched : DELETE FROM table . opt_where_clause
	opt_where_clause : .  (109)

	WHERE  shift 83
	.  reduce 109

	opt_where_clause  goto 84
	where_clause  goto 85


state 51
	fetch_statement : FETCH cursor INTO . target_commalist

	PARAMETER  shift 62

	target_commalist  goto 86
	target  goto 87
	parameter_ref  goto 88
	parameter  goto 72


state 52
	insert_statement : INSERT INTO table . opt_column_commalist values_or_query_spec
	opt_column_commalist : .  (39)

	'('  shift 89
	.  reduce 39

	opt_column_commalist  goto 90


state 53
	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
	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 54
	selection : '*' .  (118)

	.  reduce 118


state 55
	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
	USER  shift 63

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


state 56
	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
	USER  shift 63

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


state 57
	column_ref : NAME .  (194)
	column_ref : NAME . '.' NAME
	column_ref : NAME . '.' NAME '.' NAME

	'.'  shift 94
	.  reduce 194


state 58
	literal : STRING .  (189)

	.  reduce 189


state 59
	literal : INTNUM .  (190)

	.  reduce 190


state 60
	literal : APPROXNUM .  (191)

	.  reduce 191


state 61
	function_ref : AMMSC . '(' '*' ')'
	function_ref : AMMSC . '(' DISTINCT column_ref ')'
	function_ref : AMMSC . '(' ALL scalar_exp ')'
	function_ref : AMMSC . '(' scalar_exp ')'

	'('  shift 95


state 62
	parameter : PARAMETER .  (213)

	.  reduce 213


state 63
	atom : USER .  (181)

	.  reduce 181


state 64
	atom : literal .  (180)

	.  reduce 180


state 65
	scalar_exp : column_ref .  (174)

	.  reduce 174


state 66
	scalar_exp : atom .  (173)

	.  reduce 173


state 67
	select_statement : SELECT opt_all_distinct selection . INTO target_commalist table_exp

	INTO  shift 96


state 68
	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 .  (177)

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


state 69
	atom : parameter_ref .  (179)

	.  reduce 179


state 70
	selection : scalar_exp_commalist .  (117)
	scalar_exp_commalist : scalar_exp_commalist . ',' scalar_exp

	','  shift 101
	.  reduce 117


state 71
	scalar_exp : function_ref .  (175)

	.  reduce 175


state 72
	parameter_ref : parameter .  (182)
	parameter_ref : parameter . parameter
	parameter_ref : parameter . INDICATOR parameter

	INDICATOR  shift 102
	PARAMETER  shift 62
	.  reduce 182

	parameter  goto 103


state 73
	table : NAME '.' . NAME

	NAME  shift 104


state 74
	update_statement_positioned : UPDATE table SET . assignment_commalist WHERE CURRENT OF cursor
	update_statement_searched : UPDATE table SET . assignment_commalist opt_where_clause
	assignment_commalist : .  (100)

	NAME  shift 105
	.  reduce 100

	column  goto 106
	assignment_commalist  goto 107
	assignment  goto 108


state 75
	sql : WHENEVER NOT FOUND . when_action

	CONTINUE  shift 76
	GOTO  shift 77

	when_action  goto 109


state 76
	when_action : CONTINUE .  (219)

	.  reduce 219


state 77
	when_action : GOTO . NAME

	NAME  shift 110


state 78
	sql : WHENEVER SQLERROR when_action .  (217)

	.  reduce 217


state 79
	sql_list : sql_list sql ';' .  (2)

	.  reduce 2


state 80
	user : NAME .  (215)

	.  reduce 215


state 81
	schema : CREATE SCHEMA AUTHORIZATION user . opt_schema_element_list
	opt_schema_element_list : .  (5)

	CREATE  shift 111
	GRANT  shift 112
	.  reduce 5

	opt_schema_element_list  goto 113
	schema_element_list  goto 114
	schema_element  goto 115
	base_table_def  goto 116
	view_def  goto 117
	privilege_def  goto 118


state 82
	cursor_def : DECLARE cursor CURSOR FOR . query_exp opt_order_by_clause

	'('  shift 119
	SELECT  shift 120

	query_spec  goto 121
	query_exp  goto 122
	query_term  goto 123


state 83
	delete_statement_positioned : DELETE FROM table 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 126
	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 84
	delete_statement_searched : DELETE FROM table opt_where_clause .  (84)

	.  reduce 84


state 85
	opt_where_clause : where_clause .  (110)

	.  reduce 110


state 86
	fetch_statement : FETCH cursor INTO target_commalist .  (85)
	target_commalist : target_commalist . ',' target

	','  shift 139
	.  reduce 85


state 87
	target_commalist : target .  (106)

	.  reduce 106


state 88
	target : parameter_ref .  (108)

	.  reduce 108


state 89
	opt_column_commalist : '(' . column_commalist ')'

	NAME  shift 105

	column  goto 140
	column_commalist  goto 141


state 90
	insert_statement : INSERT INTO table opt_column_commalist . values_or_query_spec

	SELECT  shift 120
	VALUES  shift 142

	query_spec  goto 143
	values_or_query_spec  goto 144


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


state 92
	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 .  (171)

	.  reduce 171


state 93
	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 .  (172)

	.  reduce 172


state 94
	column_ref : NAME '.' . NAME
	column_ref : NAME '.' . NAME '.' NAME

	NAME  shift 146


state 95
	function_ref : AMMSC '(' . '*' ')'
	function_ref : AMMSC '(' . DISTINCT column_ref ')'
	function_ref : AMMSC '(' . ALL scalar_exp ')'
	function_ref : AMMSC '(' . scalar_exp ')'

	'('  shift 53
	'*'  shift 147
	'+'  shift 55
	'-'  shift 56
	NAME  shift 57
	STRING  shift 58
	INTNUM  shift 59
	APPROXNUM  shift 60
	ALL  shift 148
	AMMSC  shift 61
	DISTINCT  shift 149
	PARAMETER  shift 62
	USER  shift 63

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


state 96
	select_statement : SELECT opt_all_distinct selection INTO . target_commalist table_exp

	PARAMETER  shift 62

	target_commalist  goto 151
	target  goto 87
	parameter_ref  goto 88
	parameter  goto 72


state 97
	scalar_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
	USER  shift 63

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


state 98
	scalar_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
	USER  shift 63

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


state 99
	scalar_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
	USER  shift 63

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


state 100
	scalar_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
	USER  shift 63

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


state 101
	scalar_exp_commalist : scalar_exp_commalist ',' . scalar_exp

	'('  shift 53
	'+'  shift 55
	'-'  shift 56
	NAME  shift 57