?? sql2.v
字號:
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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -