Grammar 0 $accept: sql_list $end 1 sql_list: sql SEMICOLON 2 | sql_list sql SEMICOLON 3 sql: schema 4 | module_def 5 | manipulative_statement 6 | WHENEVER NOT FOUND when_action 7 | WHENEVER SQLERROR when_action 8 schema: CREATE SCHEMA AUTHORIZATION user opt_schema_element_list 9 opt_schema_element_list: /* empty */ 10 | schema_element_list 11 schema_element_list: schema_element 12 | schema_element_list schema_element 13 schema_element: base_table_def 14 | view_def 15 | privilege_def 16 base_table_def: CREATE TABLE table LPAREN base_table_element_commalist RPAREN 17 base_table_element_commalist: base_table_element 18 | base_table_element_commalist COMMA base_table_element 19 base_table_element: column_def 20 | table_constraint_def 21 column_def: column data_type column_def_opt_list 22 column_def_opt_list: /* empty */ 23 | column_def_opt_list column_def_opt 24 column_def_opt: NOT NULLX 25 | NOT NULLX UNIQUE 26 | NOT NULLX PRIMARY KEY 27 | DEFAULT literal 28 | DEFAULT NULLX 29 | DEFAULT USER 30 | CHECK LPAREN search_condition RPAREN 31 | REFERENCES table 32 | REFERENCES table LPAREN column_commalist RPAREN 33 table_constraint_def: UNIQUE LPAREN column_commalist RPAREN 34 | PRIMARY KEY LPAREN column_commalist RPAREN 35 | FOREIGN KEY LPAREN column_commalist RPAREN REFERENCES table 36 | FOREIGN KEY LPAREN column_commalist RPAREN REFERENCES table LPAREN column_commalist RPAREN 37 | CHECK LPAREN search_condition RPAREN 38 column_commalist: column 39 | column_commalist COMMA column 40 view_def: CREATE VIEW table opt_column_commalist AS query_spec opt_with_check_option 41 opt_with_check_option: /* empty */ 42 | WITH CHECK OPTION 43 opt_column_commalist: /* empty */ 44 | LPAREN column_commalist RPAREN 45 privilege_def: GRANT privileges ON table TO grantee_commalist opt_with_grant_option 46 opt_with_grant_option: /* empty */ 47 | WITH GRANT OPTION 48 privileges: ALL PRIVILEGES 49 | ALL 50 | operation_commalist 51 operation_commalist: operation 52 | operation_commalist COMMA operation 53 operation: SELECT 54 | INSERT 55 | DELETE 56 | UPDATE opt_column_commalist 57 | REFERENCES opt_column_commalist 58 grantee_commalist: grantee 59 | grantee_commalist COMMA grantee 60 grantee: PUBLIC 61 | user 62 module_def: MODULE opt_module LANGUAGE lang AUTHORIZATION user opt_cursor_def_list procedure_def_list 63 opt_module: /* empty */ 64 | module 65 lang: COBOL 66 | FORTRAN 67 | PASCAL 68 | PLI 69 | C 70 | ADA 71 opt_cursor_def_list: /* empty */ 72 | cursor_def_list 73 cursor_def_list: cursor_def 74 | cursor_def_list cursor_def 75 cursor_def: DECLARE cursor CURSOR FOR query_exp opt_order_by_clause 76 opt_order_by_clause: /* empty */ 77 | ORDER BY ordering_spec_commalist 78 ordering_spec_commalist: ordering_spec 79 | ordering_spec_commalist COMMA ordering_spec 80 ordering_spec: INTNUM opt_asc_desc 81 | column_ref opt_asc_desc 82 opt_asc_desc: /* empty */ 83 | ASC 84 | DESC 85 procedure_def_list: procedure_def 86 | procedure_def_list procedure_def 87 procedure_def: PROCEDURE procedure parameter_def_list SEMICOLON manipulative_statement_list 88 manipulative_statement_list: manipulative_statement 89 | manipulative_statement_list manipulative_statement 90 parameter_def_list: parameter_def 91 | parameter_def_list parameter_def 92 parameter_def: parameter data_type 93 | SQLCODE 94 manipulative_statement: close_statement 95 | commit_statement 96 | delete_statement_positioned 97 | delete_statement_searched 98 | fetch_statement 99 | insert_statement 100 | open_statement 101 | rollback_statement 102 | select_statement 103 | update_statement_positioned 104 | update_statement_searched 105 close_statement: CLOSE cursor 106 commit_statement: COMMIT WORK 107 delete_statement_positioned: DELETE FROM table WHERE CURRENT OF cursor 108 delete_statement_searched: DELETE FROM table opt_where_clause 109 fetch_statement: FETCH cursor INTO target_commalist 110 insert_statement: INSERT INTO table opt_column_commalist values_or_query_spec 111 values_or_query_spec: VALUES LPAREN insert_atom_commalist RPAREN 112 | query_spec 113 insert_atom_commalist: insert_atom 114 | insert_atom_commalist COMMA insert_atom 115 insert_atom: atom 116 | NULLX 117 open_statement: OPEN cursor 118 rollback_statement: ROLLBACK WORK 119 select_statement: SELECT opt_all_distinct selection INTO target_commalist table_exp 120 opt_all_distinct: /* empty */ 121 | ALL 122 | DISTINCT 123 update_statement_positioned: UPDATE table SET assignment_commalist WHERE CURRENT OF cursor 124 assignment_commalist: /* empty */ 125 | assignment 126 | assignment_commalist COMMA assignment 127 assignment: column ASSIGN_OP scalar_exp 128 | column ASSIGN_OP NULLX 129 update_statement_searched: UPDATE table SET assignment_commalist opt_where_clause 130 target_commalist: target 131 | target_commalist COMMA target 132 target: parameter_ref 133 opt_where_clause: /* empty */ 134 | where_clause 135 query_exp: query_term 136 | query_exp UNION query_term 137 | query_exp UNION ALL query_term 138 query_term: query_spec 139 | LPAREN query_exp RPAREN 140 query_spec: SELECT opt_all_distinct selection table_exp 141 selection: scalar_exp_commalist 142 | TIMES 143 table_exp: from_clause opt_where_clause opt_group_by_clause opt_having_clause 144 from_clause: FROM table_ref_commalist 145 table_ref_commalist: table_ref 146 | table_ref_commalist COMMA table_ref 147 table_ref: table 148 | table range_variable 149 where_clause: WHERE search_condition 150 opt_group_by_clause: /* empty */ 151 | GROUP BY column_ref_commalist 152 column_ref_commalist: column_ref 153 | column_ref_commalist COMMA column_ref 154 opt_having_clause: /* empty */ 155 | HAVING search_condition 156 search_condition: /* empty */ 157 | search_condition OR search_condition 158 | search_condition AND search_condition 159 | NOT search_condition 160 | LPAREN search_condition RPAREN 161 | predicate 162 predicate: comparison_predicate 163 | between_predicate 164 | like_predicate 165 | test_for_null 166 | in_predicate 167 | all_or_any_predicate 168 | existence_test 169 comparison_predicate: scalar_exp COMPARISON scalar_exp 170 | scalar_exp COMPARISON subquery 171 between_predicate: scalar_exp NOT BETWEEN scalar_exp AND scalar_exp 172 | scalar_exp BETWEEN scalar_exp AND scalar_exp 173 like_predicate: scalar_exp NOT LIKE atom opt_escape 174 | scalar_exp LIKE atom opt_escape 175 opt_escape: /* empty */ 176 | ESCAPE atom 177 test_for_null: column_ref IS NOT NULLX 178 | column_ref IS NULLX 179 in_predicate: scalar_exp NOT IN LPAREN subquery RPAREN 180 | scalar_exp IN LPAREN subquery RPAREN 181 | scalar_exp NOT IN LPAREN atom_commalist RPAREN 182 | scalar_exp IN LPAREN atom_commalist RPAREN 183 atom_commalist: atom 184 | atom_commalist COMMA atom 185 all_or_any_predicate: scalar_exp COMPARISON any_all_some subquery 186 any_all_some: ANY 187 | ALL 188 | SOME 189 existence_test: EXISTS subquery 190 subquery: LPAREN SELECT opt_all_distinct selection table_exp RPAREN 191 scalar_exp: scalar_exp PLUS scalar_exp 192 | scalar_exp MINUS scalar_exp 193 | scalar_exp TIMES scalar_exp 194 | scalar_exp DIV scalar_exp 195 | PLUS scalar_exp 196 | MINUS scalar_exp 197 | atom 198 | column_ref 199 | function_ref 200 | LPAREN scalar_exp RPAREN 201 scalar_exp_commalist: scalar_exp 202 | scalar_exp_commalist COMMA scalar_exp 203 atom: parameter_ref 204 | literal 205 | USER 206 parameter_ref: parameter 207 | parameter parameter 208 | parameter INDICATOR parameter 209 function_ref: AMMSC LPAREN TIMES RPAREN 210 | AMMSC LPAREN DISTINCT column_ref RPAREN 211 | AMMSC LPAREN ALL scalar_exp RPAREN 212 | AMMSC LPAREN scalar_exp RPAREN 213 literal: STRING 214 | INTNUM 215 | APPROXNUM 216 table: NAME 217 | NAME PERIOD NAME 218 column_ref: NAME 219 | NAME PERIOD NAME 220 | NAME PERIOD NAME PERIOD NAME 221 data_type: CHARACTER 222 | CHARACTER LPAREN INTNUM RPAREN 223 | NUMERIC 224 | NUMERIC LPAREN INTNUM RPAREN 225 | NUMERIC LPAREN INTNUM COMMA INTNUM RPAREN 226 | DECIMAL 227 | DECIMAL LPAREN INTNUM RPAREN 228 | DECIMAL LPAREN INTNUM COMMA INTNUM RPAREN 229 | INTEGER 230 | SMALLINT 231 | FLOAT 232 | FLOAT LPAREN INTNUM RPAREN 233 | REAL 234 | DOUBLE PRECISION 235 column: NAME 236 cursor: NAME 237 module: NAME 238 parameter: COLON NAME 239 procedure: NAME 240 range_variable: NAME 241 user: NAME 242 when_action: GOTO NAME 243 | CONTINUE Terminals, with rules where they appear $end (0) 0 error (256) NAME (258) 216 217 218 219 220 235 236 237 238 239 240 241 242 STRING (259) 213 INTNUM (260) 80 214 222 224 225 227 228 232 APPROXNUM (261) 215 OR (262) 157 AND (263) 158 171 172 NOT (264) 6 24 25 26 159 171 173 177 179 181 COMPARISON (265) 169 170 185 MINUS (266) 192 196 PLUS (267) 191 195 DIV (268) 194 TIMES (269) 142 193 209 UMINUS (270) ALL (271) 48 49 121 137 187 211 AMMSC (272) 209 210 211 212 ANY (273) 186 AS (274) 40 ASC (275) 83 AUTHORIZATION (276) 8 62 BETWEEN (277) 171 172 BY (278) 77 151 CHARACTER (279) 221 222 CHECK (280) 30 37 42 CLOSE (281) 105 COMMIT (282) 106 CONTINUE (283) 243 CREATE (284) 8 16 40 CURRENT (285) 107 123 CURSOR (286) 75 DECIMAL (287) 226 227 228 DECLARE (288) 75 DEFAULT (289) 27 28 29 DELETE (290) 55 107 108 DESC (291) 84 DISTINCT (292) 122 210 DOUBLE (293) 234 ESCAPE (294) 176 EXISTS (295) 189 FETCH (296) 109 FLOAT (297) 231 232 FOR (298) 75 FOREIGN (299) 35 36 FOUND (300) 6 FROM (301) 107 108 144 GOTO (302) 242 GRANT (303) 45 47 GROUP (304) 151 HAVING (305) 155 IN (306) 179 180 181 182 INDICATOR (307) 208 INSERT (308) 54 110 INTEGER (309) 229 INTO (310) 109 110 119 IS (311) 177 178 KEY (312) 26 34 35 36 LANGUAGE (313) 62 LIKE (314) 173 174 MODULE (315) 62 NULLX (316) 24 25 26 28 116 128 177 178 NUMERIC (317) 223 224 225 OF (318) 107 123 ON (319) 45 OPEN (320) 117 OPTION (321) 42 47 ORDER (322) 77 PRECISION (323) 234 PRIMARY (324) 26 34 PRIVILEGES (325) 48 PROCEDURE (326) 87 PUBLIC (327) 60 REAL (328) 233 REFERENCES (329) 31 32 35 36 57 ROLLBACK (330) 118 SCHEMA (331) 8 SELECT (332) 53 119 140 190 SET (333) 123 129 SMALLINT (334) 230 SOME (335) 188 SQLCODE (336) 93 SQLERROR (337) 7 TABLE (338) 16 TO (339) 45 UNION (340) 136 137 UNIQUE (341) 25 33 UPDATE (342) 56 123 129 USER (343) 29 205 VALUES (344) 111 VIEW (345) 40 WHENEVER (346) 6 7 WHERE (347) 107 123 149 WITH (348) 42 47 WORK (349) 106 118 COBOL (350) 65 FORTRAN (351) 66 PASCAL (352) 67 PLI (353) 68 C (354) 69 ADA (355) 70 RPAREN (356) 16 30 32 33 34 35 36 37 44 111 139 160 179 180 181 182 190 200 209 210 211 212 222 224 225 227 228 232 LPAREN (357) 16 30 32 33 34 35 36 37 44 111 139 160 179 180 181 182 190 200 209 210 211 212 222 224 225 227 228 232 COMMA (358) 18 39 52 59 79 114 126 131 146 153 184 202 225 228 PERIOD (359) 217 219 220 SEMICOLON (360) 1 2 87 COLON (361) 238 ASSIGN_OP (362) 127 128 Nonterminals, with rules where they appear $accept (108) on left: 0 sql_list (109) on left: 1 2, on right: 0 2 sql (110) on left: 3 4 5 6 7, on right: 1 2 schema (111) on left: 8, on right: 3 opt_schema_element_list (112) on left: 9 10, on right: 8 schema_element_list (113) on left: 11 12, on right: 10 12 schema_element (114) on left: 13 14 15, on right: 11 12 base_table_def (115) on left: 16, on right: 13 base_table_element_commalist (116) on left: 17 18, on right: 16 18 base_table_element (117) on left: 19 20, on right: 17 18 column_def (118) on left: 21, on right: 19 column_def_opt_list (119) on left: 22 23, on right: 21 23 column_def_opt (120) on left: 24 25 26 27 28 29 30 31 32, on right: 23 table_constraint_def (121) on left: 33 34 35 36 37, on right: 20 column_commalist (122) on left: 38 39, on right: 32 33 34 35 36 39 44 view_def (123) on left: 40, on right: 14 opt_with_check_option (124) on left: 41 42, on right: 40 opt_column_commalist (125) on left: 43 44, on right: 40 56 57 110 privilege_def (126) on left: 45, on right: 15 opt_with_grant_option (127) on left: 46 47, on right: 45 privileges (128) on left: 48 49 50, on right: 45 operation_commalist (129) on left: 51 52, on right: 50 52 operation (130) on left: 53 54 55 56 57, on right: 51 52 grantee_commalist (131) on left: 58 59, on right: 45 59 grantee (132) on left: 60 61, on right: 58 59 module_def (133) on left: 62, on right: 4 opt_module (134) on left: 63 64, on right: 62 lang (135) on left: 65 66 67 68 69 70, on right: 62 opt_cursor_def_list (136) on left: 71 72, on right: 62 cursor_def_list (137) on left: 73 74, on right: 72 74 cursor_def (138) on left: 75, on right: 73 74 opt_order_by_clause (139) on left: 76 77, on right: 75 ordering_spec_commalist (140) on left: 78 79, on right: 77 79 ordering_spec (141) on left: 80 81, on right: 78 79 opt_asc_desc (142) on left: 82 83 84, on right: 80 81 procedure_def_list (143) on left: 85 86, on right: 62 86 procedure_def (144) on left: 87, on right: 85 86 manipulative_statement_list (145) on left: 88 89, on right: 87 89 parameter_def_list (146) on left: 90 91, on right: 87 91 parameter_def (147) on left: 92 93, on right: 90 91 manipulative_statement (148) on left: 94 95 96 97 98 99 100 101 102 103 104, on right: 5 88 89 close_statement (149) on left: 105, on right: 94 commit_statement (150) on left: 106, on right: 95 delete_statement_positioned (151) on left: 107, on right: 96 delete_statement_searched (152) on left: 108, on right: 97 fetch_statement (153) on left: 109, on right: 98 insert_statement (154) on left: 110, on right: 99 values_or_query_spec (155) on left: 111 112, on right: 110 insert_atom_commalist (156) on left: 113 114, on right: 111 114 insert_atom (157) on left: 115 116, on right: 113 114 open_statement (158) on left: 117, on right: 100 rollback_statement (159) on left: 118, on right: 101 select_statement (160) on left: 119, on right: 102 opt_all_distinct (161) on left: 120 121 122, on right: 119 140 190 update_statement_positioned (162) on left: 123, on right: 103 assignment_commalist (163) on left: 124 125 126, on right: 123 126 129 assignment (164) on left: 127 128, on right: 125 126 update_statement_searched (165) on left: 129, on right: 104 target_commalist (166) on left: 130 131, on right: 109 119 131 target (167) on left: 132, on right: 130 131 opt_where_clause (168) on left: 133 134, on right: 108 129 143 query_exp (169) on left: 135 136 137, on right: 75 136 137 139 query_term (170) on left: 138 139, on right: 135 136 137 query_spec (171) on left: 140, on right: 40 112 138 selection (172) on left: 141 142, on right: 119 140 190 table_exp (173) on left: 143, on right: 119 140 190 from_clause (174) on left: 144, on right: 143 table_ref_commalist (175) on left: 145 146, on right: 144 146 table_ref (176) on left: 147 148, on right: 145 146 where_clause (177) on left: 149, on right: 134 opt_group_by_clause (178) on left: 150 151, on right: 143 column_ref_commalist (179) on left: 152 153, on right: 151 153 opt_having_clause (180) on left: 154 155, on right: 143 search_condition (181) on left: 156 157 158 159 160 161, on right: 30 37 149 155 157 158 159 160 predicate (182) on left: 162 163 164 165 166 167 168, on right: 161 comparison_predicate (183) on left: 169 170, on right: 162 between_predicate (184) on left: 171 172, on right: 163 like_predicate (185) on left: 173 174, on right: 164 opt_escape (186) on left: 175 176, on right: 173 174 test_for_null (187) on left: 177 178, on right: 165 in_predicate (188) on left: 179 180 181 182, on right: 166 atom_commalist (189) on left: 183 184, on right: 181 182 184 all_or_any_predicate (190) on left: 185, on right: 167 any_all_some (191) on left: 186 187 188, on right: 185 existence_test (192) on left: 189, on right: 168 subquery (193) on left: 190, on right: 170 179 180 185 189 scalar_exp (194) on left: 191 192 193 194 195 196 197 198 199 200, on right: 127 169 170 171 172 173 174 179 180 181 182 185 191 192 193 194 195 196 200 201 202 211 212 scalar_exp_commalist (195) on left: 201 202, on right: 141 202 atom (196) on left: 203 204 205, on right: 115 173 174 176 183 184 197 parameter_ref (197) on left: 206 207 208, on right: 132 203 function_ref (198) on left: 209 210 211 212, on right: 199 literal (199) on left: 213 214 215, on right: 27 204 table (200) on left: 216 217, on right: 16 31 32 35 36 40 45 107 108 110 123 129 147 148 column_ref (201) on left: 218 219 220, on right: 81 152 153 177 178 198 210 data_type (202) on left: 221 222 223 224 225 226 227 228 229 230 231 232 233 234 , on right: 21 92 column (203) on left: 235, on right: 21 38 39 127 128 cursor (204) on left: 236, on right: 75 105 107 109 117 123 module (205) on left: 237, on right: 64 parameter (206) on left: 238, on right: 92 206 207 208 procedure (207) on left: 239, on right: 87 range_variable (208) on left: 240, on right: 148 user (209) on left: 241, on right: 8 61 62 when_action (210) on left: 242 243, on right: 6 7 state 0 0 $accept: . sql_list $end CLOSE shift, and go to state 1 COMMIT shift, and go to state 2 CREATE shift, and go to state 3 DELETE shift, and go to state 4 FETCH shift, and go to state 5 INSERT shift, and go to state 6 MODULE shift, and go to state 7 OPEN shift, and go to state 8 ROLLBACK shift, and go to state 9 SELECT shift, and go to state 10 UPDATE shift, and go to state 11 WHENEVER shift, and go to state 12 sql_list go to state 13 sql go to state 14 schema go to state 15 module_def go to state 16 manipulative_statement go to state 17 close_statement go to state 18 commit_statement go to state 19 delete_statement_positioned go to state 20 delete_statement_searched go to state 21 fetch_statement go to state 22 insert_statement go to state 23 open_statement go to state 24 rollback_statement go to state 25 select_statement go to state 26 update_statement_positioned go to state 27 update_statement_searched go to state 28 state 1 105 close_statement: CLOSE . cursor NAME shift, and go to state 29 cursor go to state 30 state 2 106 commit_statement: COMMIT . WORK WORK shift, and go to state 31 state 3 8 schema: CREATE . SCHEMA AUTHORIZATION user opt_schema_element_list SCHEMA shift, and go to state 32 state 4 107 delete_statement_positioned: DELETE . FROM table WHERE CURRENT OF cursor 108 delete_statement_searched: DELETE . FROM table opt_where_clause FROM shift, and go to state 33 state 5 109 fetch_statement: FETCH . cursor INTO target_commalist NAME shift, and go to state 29 cursor go to state 34 state 6 110 insert_statement: INSERT . INTO table opt_column_commalist values_or_query_spec INTO shift, and go to state 35 state 7 62 module_def: MODULE . opt_module LANGUAGE lang AUTHORIZATION user opt_cursor_def_list procedure_def_list NAME shift, and go to state 36 $default reduce using rule 63 (opt_module) opt_module go to state 37 module go to state 38 state 8 117 open_statement: OPEN . cursor NAME shift, and go to state 29 cursor go to state 39 state 9 118 rollback_statement: ROLLBACK . WORK WORK shift, and go to state 40 state 10 119 select_statement: SELECT . opt_all_distinct selection INTO target_commalist table_exp ALL shift, and go to state 41 DISTINCT shift, and go to state 42 $default reduce using rule 120 (opt_all_distinct) opt_all_distinct go to state 43 state 11 123 update_statement_positioned: UPDATE . table SET assignment_commalist WHERE CURRENT OF cursor 129 update_statement_searched: UPDATE . table SET assignment_commalist opt_where_clause NAME shift, and go to state 44 table go to state 45 state 12 6 sql: WHENEVER . NOT FOUND when_action 7 | WHENEVER . SQLERROR when_action NOT shift, and go to state 46 SQLERROR shift, and go to state 47 state 13 0 $accept: sql_list . $end 2 sql_list: sql_list . sql SEMICOLON $end shift, and go to state 48 CLOSE shift, and go to state 1 COMMIT shift, and go to state 2 CREATE shift, and go to state 3 DELETE shift, and go to state 4 FETCH shift, and go to state 5 INSERT shift, and go to state 6 MODULE shift, and go to state 7 OPEN shift, and go to state 8 ROLLBACK shift, and go to state 9 SELECT shift, and go to state 10 UPDATE shift, and go to state 11 WHENEVER shift, and go to state 12 sql go to state 49 schema go to state 15 module_def go to state 16 manipulative_statement go to state 17 close_statement go to state 18 commit_statement go to state 19 delete_statement_positioned go to state 20 delete_statement_searched go to state 21 fetch_statement go to state 22 insert_statement go to state 23 open_statement go to state 24 rollback_statement go to state 25 select_statement go to state 26 update_statement_positioned go to state 27 update_statement_searched go to state 28 state 14 1 sql_list: sql . SEMICOLON SEMICOLON shift, and go to state 50 state 15 3 sql: schema . $default reduce using rule 3 (sql) state 16 4 sql: module_def . $default reduce using rule 4 (sql) state 17 5 sql: manipulative_statement . $default reduce using rule 5 (sql) state 18 94 manipulative_statement: close_statement . $default reduce using rule 94 (manipulative_statement) state 19 95 manipulative_statement: commit_statement . $default reduce using rule 95 (manipulative_statement) state 20 96 manipulative_statement: delete_statement_positioned . $default reduce using rule 96 (manipulative_statement) state 21 97 manipulative_statement: delete_statement_searched . $default reduce using rule 97 (manipulative_statement) state 22 98 manipulative_statement: fetch_statement . $default reduce using rule 98 (manipulative_statement) state 23 99 manipulative_statement: insert_statement . $default reduce using rule 99 (manipulative_statement) state 24 100 manipulative_statement: open_statement . $default reduce using rule 100 (manipulative_statement) state 25 101 manipulative_statement: rollback_statement . $default reduce using rule 101 (manipulative_statement) state 26 102 manipulative_statement: select_statement . $default reduce using rule 102 (manipulative_statement) state 27 103 manipulative_statement: update_statement_positioned . $default reduce using rule 103 (manipulative_statement) state 28 104 manipulative_statement: update_statement_searched . $default reduce using rule 104 (manipulative_statement) state 29 236 cursor: NAME . $default reduce using rule 236 (cursor) state 30 105 close_statement: CLOSE cursor . $default reduce using rule 105 (close_statement) state 31 106 commit_statement: COMMIT WORK . $default reduce using rule 106 (commit_statement) state 32 8 schema: CREATE SCHEMA . AUTHORIZATION user opt_schema_element_list AUTHORIZATION shift, and go to state 51 state 33 107 delete_statement_positioned: DELETE FROM . table WHERE CURRENT OF cursor 108 delete_statement_searched: DELETE FROM . table opt_where_clause NAME shift, and go to state 44 table go to state 52 state 34 109 fetch_statement: FETCH cursor . INTO target_commalist INTO shift, and go to state 53 state 35 110 insert_statement: INSERT INTO . table opt_column_commalist values_or_query_spec NAME shift, and go to state 44 table go to state 54 state 36 237 module: NAME . $default reduce using rule 237 (module) state 37 62 module_def: MODULE opt_module . LANGUAGE lang AUTHORIZATION user opt_cursor_def_list procedure_def_list LANGUAGE shift, and go to state 55 state 38 64 opt_module: module . $default reduce using rule 64 (opt_module) state 39 117 open_statement: OPEN cursor . $default reduce using rule 117 (open_statement) state 40 118 rollback_statement: ROLLBACK WORK . $default reduce using rule 118 (rollback_statement) state 41 121 opt_all_distinct: ALL . $default reduce using rule 121 (opt_all_distinct) state 42 122 opt_all_distinct: DISTINCT . $default reduce using rule 122 (opt_all_distinct) state 43 119 select_statement: SELECT opt_all_distinct . selection INTO target_commalist table_exp NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 TIMES shift, and go to state 62 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 selection go to state 67 scalar_exp go to state 68 scalar_exp_commalist go to state 69 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 44 216 table: NAME . 217 | NAME . PERIOD NAME PERIOD shift, and go to state 76 $default reduce using rule 216 (table) state 45 123 update_statement_positioned: UPDATE table . SET assignment_commalist WHERE CURRENT OF cursor 129 update_statement_searched: UPDATE table . SET assignment_commalist opt_where_clause SET shift, and go to state 77 state 46 6 sql: WHENEVER NOT . FOUND when_action FOUND shift, and go to state 78 state 47 7 sql: WHENEVER SQLERROR . when_action CONTINUE shift, and go to state 79 GOTO shift, and go to state 80 when_action go to state 81 state 48 0 $accept: sql_list $end . $default accept state 49 2 sql_list: sql_list sql . SEMICOLON SEMICOLON shift, and go to state 82 state 50 1 sql_list: sql SEMICOLON . $default reduce using rule 1 (sql_list) state 51 8 schema: CREATE SCHEMA AUTHORIZATION . user opt_schema_element_list NAME shift, and go to state 83 user go to state 84 state 52 107 delete_statement_positioned: DELETE FROM table . WHERE CURRENT OF cursor 108 delete_statement_searched: DELETE FROM table . opt_where_clause WHERE shift, and go to state 85 $default reduce using rule 133 (opt_where_clause) opt_where_clause go to state 86 where_clause go to state 87 state 53 109 fetch_statement: FETCH cursor INTO . target_commalist COLON shift, and go to state 66 target_commalist go to state 88 target go to state 89 parameter_ref go to state 90 parameter go to state 75 state 54 110 insert_statement: INSERT INTO table . opt_column_commalist values_or_query_spec LPAREN shift, and go to state 91 $default reduce using rule 43 (opt_column_commalist) opt_column_commalist go to state 92 state 55 62 module_def: MODULE opt_module LANGUAGE . lang AUTHORIZATION user opt_cursor_def_list procedure_def_list COBOL shift, and go to state 93 FORTRAN shift, and go to state 94 PASCAL shift, and go to state 95 PLI shift, and go to state 96 C shift, and go to state 97 ADA shift, and go to state 98 lang go to state 99 state 56 218 column_ref: NAME . 219 | NAME . PERIOD NAME 220 | NAME . PERIOD NAME PERIOD NAME PERIOD shift, and go to state 100 $default reduce using rule 218 (column_ref) state 57 213 literal: STRING . $default reduce using rule 213 (literal) state 58 214 literal: INTNUM . $default reduce using rule 214 (literal) state 59 215 literal: APPROXNUM . $default reduce using rule 215 (literal) state 60 196 scalar_exp: MINUS . scalar_exp NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 101 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 61 195 scalar_exp: PLUS . scalar_exp NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 102 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 62 142 selection: TIMES . $default reduce using rule 142 (selection) state 63 209 function_ref: AMMSC . LPAREN TIMES RPAREN 210 | AMMSC . LPAREN DISTINCT column_ref RPAREN 211 | AMMSC . LPAREN ALL scalar_exp RPAREN 212 | AMMSC . LPAREN scalar_exp RPAREN LPAREN shift, and go to state 103 state 64 205 atom: USER . $default reduce using rule 205 (atom) state 65 200 scalar_exp: LPAREN . scalar_exp RPAREN NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 104 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 66 238 parameter: COLON . NAME NAME shift, and go to state 105 state 67 119 select_statement: SELECT opt_all_distinct selection . INTO target_commalist table_exp INTO shift, and go to state 106 state 68 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp 201 scalar_exp_commalist: scalar_exp . MINUS shift, and go to state 107 PLUS shift, and go to state 108 DIV shift, and go to state 109 TIMES shift, and go to state 110 $default reduce using rule 201 (scalar_exp_commalist) state 69 141 selection: scalar_exp_commalist . 202 scalar_exp_commalist: scalar_exp_commalist . COMMA scalar_exp COMMA shift, and go to state 111 $default reduce using rule 141 (selection) state 70 197 scalar_exp: atom . $default reduce using rule 197 (scalar_exp) state 71 203 atom: parameter_ref . $default reduce using rule 203 (atom) state 72 199 scalar_exp: function_ref . $default reduce using rule 199 (scalar_exp) state 73 204 atom: literal . $default reduce using rule 204 (atom) state 74 198 scalar_exp: column_ref . $default reduce using rule 198 (scalar_exp) state 75 206 parameter_ref: parameter . 207 | parameter . parameter 208 | parameter . INDICATOR parameter INDICATOR shift, and go to state 112 COLON shift, and go to state 66 $default reduce using rule 206 (parameter_ref) parameter go to state 113 state 76 217 table: NAME PERIOD . NAME NAME shift, and go to state 114 state 77 123 update_statement_positioned: UPDATE table SET . assignment_commalist WHERE CURRENT OF cursor 129 update_statement_searched: UPDATE table SET . assignment_commalist opt_where_clause NAME shift, and go to state 115 $default reduce using rule 124 (assignment_commalist) assignment_commalist go to state 116 assignment go to state 117 column go to state 118 state 78 6 sql: WHENEVER NOT FOUND . when_action CONTINUE shift, and go to state 79 GOTO shift, and go to state 80 when_action go to state 119 state 79 243 when_action: CONTINUE . $default reduce using rule 243 (when_action) state 80 242 when_action: GOTO . NAME NAME shift, and go to state 120 state 81 7 sql: WHENEVER SQLERROR when_action . $default reduce using rule 7 (sql) state 82 2 sql_list: sql_list sql SEMICOLON . $default reduce using rule 2 (sql_list) state 83 241 user: NAME . $default reduce using rule 241 (user) state 84 8 schema: CREATE SCHEMA AUTHORIZATION user . opt_schema_element_list CREATE shift, and go to state 121 GRANT shift, and go to state 122 $default reduce using rule 9 (opt_schema_element_list) opt_schema_element_list go to state 123 schema_element_list go to state 124 schema_element go to state 125 base_table_def go to state 126 view_def go to state 127 privilege_def go to state 128 state 85 107 delete_statement_positioned: DELETE FROM table WHERE . CURRENT OF cursor 149 where_clause: WHERE . search_condition NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 NOT shift, and go to state 129 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 CURRENT shift, and go to state 130 EXISTS shift, and go to state 131 USER shift, and go to state 64 LPAREN shift, and go to state 132 COLON shift, and go to state 66 $default reduce using rule 156 (search_condition) search_condition go to state 133 predicate go to state 134 comparison_predicate go to state 135 between_predicate go to state 136 like_predicate go to state 137 test_for_null go to state 138 in_predicate go to state 139 all_or_any_predicate go to state 140 existence_test go to state 141 scalar_exp go to state 142 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 143 parameter go to state 75 state 86 108 delete_statement_searched: DELETE FROM table opt_where_clause . $default reduce using rule 108 (delete_statement_searched) state 87 134 opt_where_clause: where_clause . $default reduce using rule 134 (opt_where_clause) state 88 109 fetch_statement: FETCH cursor INTO target_commalist . 131 target_commalist: target_commalist . COMMA target COMMA shift, and go to state 144 $default reduce using rule 109 (fetch_statement) state 89 130 target_commalist: target . $default reduce using rule 130 (target_commalist) state 90 132 target: parameter_ref . $default reduce using rule 132 (target) state 91 44 opt_column_commalist: LPAREN . column_commalist RPAREN NAME shift, and go to state 115 column_commalist go to state 145 column go to state 146 state 92 110 insert_statement: INSERT INTO table opt_column_commalist . values_or_query_spec SELECT shift, and go to state 147 VALUES shift, and go to state 148 values_or_query_spec go to state 149 query_spec go to state 150 state 93 65 lang: COBOL . $default reduce using rule 65 (lang) state 94 66 lang: FORTRAN . $default reduce using rule 66 (lang) state 95 67 lang: PASCAL . $default reduce using rule 67 (lang) state 96 68 lang: PLI . $default reduce using rule 68 (lang) state 97 69 lang: C . $default reduce using rule 69 (lang) state 98 70 lang: ADA . $default reduce using rule 70 (lang) state 99 62 module_def: MODULE opt_module LANGUAGE lang . AUTHORIZATION user opt_cursor_def_list procedure_def_list AUTHORIZATION shift, and go to state 151 state 100 219 column_ref: NAME PERIOD . NAME 220 | NAME PERIOD . NAME PERIOD NAME NAME shift, and go to state 152 state 101 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp 196 | MINUS scalar_exp . $default reduce using rule 196 (scalar_exp) state 102 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp 195 | PLUS scalar_exp . $default reduce using rule 195 (scalar_exp) state 103 209 function_ref: AMMSC LPAREN . TIMES RPAREN 210 | AMMSC LPAREN . DISTINCT column_ref RPAREN 211 | AMMSC LPAREN . ALL scalar_exp RPAREN 212 | AMMSC LPAREN . scalar_exp RPAREN NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 TIMES shift, and go to state 153 ALL shift, and go to state 154 AMMSC shift, and go to state 63 DISTINCT shift, and go to state 155 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 156 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 104 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp 200 | LPAREN scalar_exp . RPAREN MINUS shift, and go to state 107 PLUS shift, and go to state 108 DIV shift, and go to state 109 TIMES shift, and go to state 110 RPAREN shift, and go to state 157 state 105 238 parameter: COLON NAME . $default reduce using rule 238 (parameter) state 106 119 select_statement: SELECT opt_all_distinct selection INTO . target_commalist table_exp COLON shift, and go to state 66 target_commalist go to state 158 target go to state 89 parameter_ref go to state 90 parameter go to state 75 state 107 192 scalar_exp: scalar_exp MINUS . scalar_exp NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 159 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 108 191 scalar_exp: scalar_exp PLUS . scalar_exp NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 160 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 109 194 scalar_exp: scalar_exp DIV . scalar_exp NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 161 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 110 193 scalar_exp: scalar_exp TIMES . scalar_exp NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 162 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 111 202 scalar_exp_commalist: scalar_exp_commalist COMMA . scalar_exp NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 163 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 112 208 parameter_ref: parameter INDICATOR . parameter COLON shift, and go to state 66 parameter go to state 164 state 113 207 parameter_ref: parameter parameter . $default reduce using rule 207 (parameter_ref) state 114 217 table: NAME PERIOD NAME . $default reduce using rule 217 (table) state 115 235 column: NAME . $default reduce using rule 235 (column) state 116 123 update_statement_positioned: UPDATE table SET assignment_commalist . WHERE CURRENT OF cursor 126 assignment_commalist: assignment_commalist . COMMA assignment 129 update_statement_searched: UPDATE table SET assignment_commalist . opt_where_clause WHERE shift, and go to state 165 COMMA shift, and go to state 166 $default reduce using rule 133 (opt_where_clause) opt_where_clause go to state 167 where_clause go to state 87 state 117 125 assignment_commalist: assignment . $default reduce using rule 125 (assignment_commalist) state 118 127 assignment: column . ASSIGN_OP scalar_exp 128 | column . ASSIGN_OP NULLX ASSIGN_OP shift, and go to state 168 state 119 6 sql: WHENEVER NOT FOUND when_action . $default reduce using rule 6 (sql) state 120 242 when_action: GOTO NAME . $default reduce using rule 242 (when_action) state 121 16 base_table_def: CREATE . TABLE table LPAREN base_table_element_commalist RPAREN 40 view_def: CREATE . VIEW table opt_column_commalist AS query_spec opt_with_check_option TABLE shift, and go to state 169 VIEW shift, and go to state 170 state 122 45 privilege_def: GRANT . privileges ON table TO grantee_commalist opt_with_grant_option ALL shift, and go to state 171 DELETE shift, and go to state 172 INSERT shift, and go to state 173 REFERENCES shift, and go to state 174 SELECT shift, and go to state 175 UPDATE shift, and go to state 176 privileges go to state 177 operation_commalist go to state 178 operation go to state 179 state 123 8 schema: CREATE SCHEMA AUTHORIZATION user opt_schema_element_list . $default reduce using rule 8 (schema) state 124 10 opt_schema_element_list: schema_element_list . 12 schema_element_list: schema_element_list . schema_element CREATE shift, and go to state 121 GRANT shift, and go to state 122 $default reduce using rule 10 (opt_schema_element_list) schema_element go to state 180 base_table_def go to state 126 view_def go to state 127 privilege_def go to state 128 state 125 11 schema_element_list: schema_element . $default reduce using rule 11 (schema_element_list) state 126 13 schema_element: base_table_def . $default reduce using rule 13 (schema_element) state 127 14 schema_element: view_def . $default reduce using rule 14 (schema_element) state 128 15 schema_element: privilege_def . $default reduce using rule 15 (schema_element) state 129 159 search_condition: NOT . search_condition NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 NOT shift, and go to state 129 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 EXISTS shift, and go to state 131 USER shift, and go to state 64 LPAREN shift, and go to state 132 COLON shift, and go to state 66 $default reduce using rule 156 (search_condition) search_condition go to state 181 predicate go to state 134 comparison_predicate go to state 135 between_predicate go to state 136 like_predicate go to state 137 test_for_null go to state 138 in_predicate go to state 139 all_or_any_predicate go to state 140 existence_test go to state 141 scalar_exp go to state 142 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 143 parameter go to state 75 state 130 107 delete_statement_positioned: DELETE FROM table WHERE CURRENT . OF cursor OF shift, and go to state 182 state 131 189 existence_test: EXISTS . subquery LPAREN shift, and go to state 183 subquery go to state 184 state 132 160 search_condition: LPAREN . search_condition RPAREN 200 scalar_exp: LPAREN . scalar_exp RPAREN NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 NOT shift, and go to state 129 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 EXISTS shift, and go to state 131 USER shift, and go to state 64 LPAREN shift, and go to state 132 COLON shift, and go to state 66 $default reduce using rule 156 (search_condition) search_condition go to state 185 predicate go to state 134 comparison_predicate go to state 135 between_predicate go to state 136 like_predicate go to state 137 test_for_null go to state 138 in_predicate go to state 139 all_or_any_predicate go to state 140 existence_test go to state 141 scalar_exp go to state 186 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 143 parameter go to state 75 state 133 149 where_clause: WHERE search_condition . 157 search_condition: search_condition . OR search_condition 158 | search_condition . AND search_condition OR shift, and go to state 187 AND shift, and go to state 188 $default reduce using rule 149 (where_clause) state 134 161 search_condition: predicate . $default reduce using rule 161 (search_condition) state 135 162 predicate: comparison_predicate . $default reduce using rule 162 (predicate) state 136 163 predicate: between_predicate . $default reduce using rule 163 (predicate) state 137 164 predicate: like_predicate . $default reduce using rule 164 (predicate) state 138 165 predicate: test_for_null . $default reduce using rule 165 (predicate) state 139 166 predicate: in_predicate . $default reduce using rule 166 (predicate) state 140 167 predicate: all_or_any_predicate . $default reduce using rule 167 (predicate) state 141 168 predicate: existence_test . $default reduce using rule 168 (predicate) state 142 169 comparison_predicate: scalar_exp . COMPARISON scalar_exp 170 | scalar_exp . COMPARISON subquery 171 between_predicate: scalar_exp . NOT BETWEEN scalar_exp AND scalar_exp 172 | scalar_exp . BETWEEN scalar_exp AND scalar_exp 173 like_predicate: scalar_exp . NOT LIKE atom opt_escape 174 | scalar_exp . LIKE atom opt_escape 179 in_predicate: scalar_exp . NOT IN LPAREN subquery RPAREN 180 | scalar_exp . IN LPAREN subquery RPAREN 181 | scalar_exp . NOT IN LPAREN atom_commalist RPAREN 182 | scalar_exp . IN LPAREN atom_commalist RPAREN 185 all_or_any_predicate: scalar_exp . COMPARISON any_all_some subquery 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp NOT shift, and go to state 189 COMPARISON shift, and go to state 190 MINUS shift, and go to state 107 PLUS shift, and go to state 108 DIV shift, and go to state 109 TIMES shift, and go to state 110 BETWEEN shift, and go to state 191 IN shift, and go to state 192 LIKE shift, and go to state 193 state 143 177 test_for_null: column_ref . IS NOT NULLX 178 | column_ref . IS NULLX 198 scalar_exp: column_ref . IS shift, and go to state 194 $default reduce using rule 198 (scalar_exp) state 144 131 target_commalist: target_commalist COMMA . target COLON shift, and go to state 66 target go to state 195 parameter_ref go to state 90 parameter go to state 75 state 145 39 column_commalist: column_commalist . COMMA column 44 opt_column_commalist: LPAREN column_commalist . RPAREN RPAREN shift, and go to state 196 COMMA shift, and go to state 197 state 146 38 column_commalist: column . $default reduce using rule 38 (column_commalist) state 147 140 query_spec: SELECT . opt_all_distinct selection table_exp ALL shift, and go to state 41 DISTINCT shift, and go to state 42 $default reduce using rule 120 (opt_all_distinct) opt_all_distinct go to state 198 state 148 111 values_or_query_spec: VALUES . LPAREN insert_atom_commalist RPAREN LPAREN shift, and go to state 199 state 149 110 insert_statement: INSERT INTO table opt_column_commalist values_or_query_spec . $default reduce using rule 110 (insert_statement) state 150 112 values_or_query_spec: query_spec . $default reduce using rule 112 (values_or_query_spec) state 151 62 module_def: MODULE opt_module LANGUAGE lang AUTHORIZATION . user opt_cursor_def_list procedure_def_list NAME shift, and go to state 83 user go to state 200 state 152 219 column_ref: NAME PERIOD NAME . 220 | NAME PERIOD NAME . PERIOD NAME PERIOD shift, and go to state 201 $default reduce using rule 219 (column_ref) state 153 209 function_ref: AMMSC LPAREN TIMES . RPAREN RPAREN shift, and go to state 202 state 154 211 function_ref: AMMSC LPAREN ALL . scalar_exp RPAREN NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 203 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 155 210 function_ref: AMMSC LPAREN DISTINCT . column_ref RPAREN NAME shift, and go to state 56 column_ref go to state 204 state 156 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp 212 function_ref: AMMSC LPAREN scalar_exp . RPAREN MINUS shift, and go to state 107 PLUS shift, and go to state 108 DIV shift, and go to state 109 TIMES shift, and go to state 110 RPAREN shift, and go to state 205 state 157 200 scalar_exp: LPAREN scalar_exp RPAREN . $default reduce using rule 200 (scalar_exp) state 158 119 select_statement: SELECT opt_all_distinct selection INTO target_commalist . table_exp 131 target_commalist: target_commalist . COMMA target FROM shift, and go to state 206 COMMA shift, and go to state 144 table_exp go to state 207 from_clause go to state 208 state 159 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 192 | scalar_exp MINUS scalar_exp . 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp DIV shift, and go to state 109 TIMES shift, and go to state 110 $default reduce using rule 192 (scalar_exp) state 160 191 scalar_exp: scalar_exp . PLUS scalar_exp 191 | scalar_exp PLUS scalar_exp . 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp DIV shift, and go to state 109 TIMES shift, and go to state 110 $default reduce using rule 191 (scalar_exp) state 161 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp 194 | scalar_exp DIV scalar_exp . $default reduce using rule 194 (scalar_exp) state 162 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 193 | scalar_exp TIMES scalar_exp . 194 | scalar_exp . DIV scalar_exp $default reduce using rule 193 (scalar_exp) state 163 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp 202 scalar_exp_commalist: scalar_exp_commalist COMMA scalar_exp . MINUS shift, and go to state 107 PLUS shift, and go to state 108 DIV shift, and go to state 109 TIMES shift, and go to state 110 $default reduce using rule 202 (scalar_exp_commalist) state 164 208 parameter_ref: parameter INDICATOR parameter . $default reduce using rule 208 (parameter_ref) state 165 123 update_statement_positioned: UPDATE table SET assignment_commalist WHERE . CURRENT OF cursor 149 where_clause: WHERE . search_condition NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 NOT shift, and go to state 129 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 CURRENT shift, and go to state 209 EXISTS shift, and go to state 131 USER shift, and go to state 64 LPAREN shift, and go to state 132 COLON shift, and go to state 66 $default reduce using rule 156 (search_condition) search_condition go to state 133 predicate go to state 134 comparison_predicate go to state 135 between_predicate go to state 136 like_predicate go to state 137 test_for_null go to state 138 in_predicate go to state 139 all_or_any_predicate go to state 140 existence_test go to state 141 scalar_exp go to state 142 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 143 parameter go to state 75 state 166 126 assignment_commalist: assignment_commalist COMMA . assignment NAME shift, and go to state 115 assignment go to state 210 column go to state 118 state 167 129 update_statement_searched: UPDATE table SET assignment_commalist opt_where_clause . $default reduce using rule 129 (update_statement_searched) state 168 127 assignment: column ASSIGN_OP . scalar_exp 128 | column ASSIGN_OP . NULLX NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 NULLX shift, and go to state 211 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 212 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 169 16 base_table_def: CREATE TABLE . table LPAREN base_table_element_commalist RPAREN NAME shift, and go to state 44 table go to state 213 state 170 40 view_def: CREATE VIEW . table opt_column_commalist AS query_spec opt_with_check_option NAME shift, and go to state 44 table go to state 214 state 171 48 privileges: ALL . PRIVILEGES 49 | ALL . PRIVILEGES shift, and go to state 215 $default reduce using rule 49 (privileges) state 172 55 operation: DELETE . $default reduce using rule 55 (operation) state 173 54 operation: INSERT . $default reduce using rule 54 (operation) state 174 57 operation: REFERENCES . opt_column_commalist LPAREN shift, and go to state 91 $default reduce using rule 43 (opt_column_commalist) opt_column_commalist go to state 216 state 175 53 operation: SELECT . $default reduce using rule 53 (operation) state 176 56 operation: UPDATE . opt_column_commalist LPAREN shift, and go to state 91 $default reduce using rule 43 (opt_column_commalist) opt_column_commalist go to state 217 state 177 45 privilege_def: GRANT privileges . ON table TO grantee_commalist opt_with_grant_option ON shift, and go to state 218 state 178 50 privileges: operation_commalist . 52 operation_commalist: operation_commalist . COMMA operation COMMA shift, and go to state 219 $default reduce using rule 50 (privileges) state 179 51 operation_commalist: operation . $default reduce using rule 51 (operation_commalist) state 180 12 schema_element_list: schema_element_list schema_element . $default reduce using rule 12 (schema_element_list) state 181 157 search_condition: search_condition . OR search_condition 158 | search_condition . AND search_condition 159 | NOT search_condition . $default reduce using rule 159 (search_condition) state 182 107 delete_statement_positioned: DELETE FROM table WHERE CURRENT OF . cursor NAME shift, and go to state 29 cursor go to state 220 state 183 190 subquery: LPAREN . SELECT opt_all_distinct selection table_exp RPAREN SELECT shift, and go to state 221 state 184 189 existence_test: EXISTS subquery . $default reduce using rule 189 (existence_test) state 185 157 search_condition: search_condition . OR search_condition 158 | search_condition . AND search_condition 160 | LPAREN search_condition . RPAREN OR shift, and go to state 187 AND shift, and go to state 188 RPAREN shift, and go to state 222 state 186 169 comparison_predicate: scalar_exp . COMPARISON scalar_exp 170 | scalar_exp . COMPARISON subquery 171 between_predicate: scalar_exp . NOT BETWEEN scalar_exp AND scalar_exp 172 | scalar_exp . BETWEEN scalar_exp AND scalar_exp 173 like_predicate: scalar_exp . NOT LIKE atom opt_escape 174 | scalar_exp . LIKE atom opt_escape 179 in_predicate: scalar_exp . NOT IN LPAREN subquery RPAREN 180 | scalar_exp . IN LPAREN subquery RPAREN 181 | scalar_exp . NOT IN LPAREN atom_commalist RPAREN 182 | scalar_exp . IN LPAREN atom_commalist RPAREN 185 all_or_any_predicate: scalar_exp . COMPARISON any_all_some subquery 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp 200 | LPAREN scalar_exp . RPAREN NOT shift, and go to state 189 COMPARISON shift, and go to state 190 MINUS shift, and go to state 107 PLUS shift, and go to state 108 DIV shift, and go to state 109 TIMES shift, and go to state 110 BETWEEN shift, and go to state 191 IN shift, and go to state 192 LIKE shift, and go to state 193 RPAREN shift, and go to state 157 state 187 157 search_condition: search_condition OR . search_condition NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 NOT shift, and go to state 129 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 EXISTS shift, and go to state 131 USER shift, and go to state 64 LPAREN shift, and go to state 132 COLON shift, and go to state 66 $default reduce using rule 156 (search_condition) search_condition go to state 223 predicate go to state 134 comparison_predicate go to state 135 between_predicate go to state 136 like_predicate go to state 137 test_for_null go to state 138 in_predicate go to state 139 all_or_any_predicate go to state 140 existence_test go to state 141 scalar_exp go to state 142 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 143 parameter go to state 75 state 188 158 search_condition: search_condition AND . search_condition NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 NOT shift, and go to state 129 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 EXISTS shift, and go to state 131 USER shift, and go to state 64 LPAREN shift, and go to state 132 COLON shift, and go to state 66 $default reduce using rule 156 (search_condition) search_condition go to state 224 predicate go to state 134 comparison_predicate go to state 135 between_predicate go to state 136 like_predicate go to state 137 test_for_null go to state 138 in_predicate go to state 139 all_or_any_predicate go to state 140 existence_test go to state 141 scalar_exp go to state 142 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 143 parameter go to state 75 state 189 171 between_predicate: scalar_exp NOT . BETWEEN scalar_exp AND scalar_exp 173 like_predicate: scalar_exp NOT . LIKE atom opt_escape 179 in_predicate: scalar_exp NOT . IN LPAREN subquery RPAREN 181 | scalar_exp NOT . IN LPAREN atom_commalist RPAREN BETWEEN shift, and go to state 225 IN shift, and go to state 226 LIKE shift, and go to state 227 state 190 169 comparison_predicate: scalar_exp COMPARISON . scalar_exp 170 | scalar_exp COMPARISON . subquery 185 all_or_any_predicate: scalar_exp COMPARISON . any_all_some subquery NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 ALL shift, and go to state 228 AMMSC shift, and go to state 63 ANY shift, and go to state 229 SOME shift, and go to state 230 USER shift, and go to state 64 LPAREN shift, and go to state 231 COLON shift, and go to state 66 any_all_some go to state 232 subquery go to state 233 scalar_exp go to state 234 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 191 172 between_predicate: scalar_exp BETWEEN . scalar_exp AND scalar_exp NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 235 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 192 180 in_predicate: scalar_exp IN . LPAREN subquery RPAREN 182 | scalar_exp IN . LPAREN atom_commalist RPAREN LPAREN shift, and go to state 236 state 193 174 like_predicate: scalar_exp LIKE . atom opt_escape STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 USER shift, and go to state 64 COLON shift, and go to state 66 atom go to state 237 parameter_ref go to state 71 literal go to state 73 parameter go to state 75 state 194 177 test_for_null: column_ref IS . NOT NULLX 178 | column_ref IS . NULLX NOT shift, and go to state 238 NULLX shift, and go to state 239 state 195 131 target_commalist: target_commalist COMMA target . $default reduce using rule 131 (target_commalist) state 196 44 opt_column_commalist: LPAREN column_commalist RPAREN . $default reduce using rule 44 (opt_column_commalist) state 197 39 column_commalist: column_commalist COMMA . column NAME shift, and go to state 115 column go to state 240 state 198 140 query_spec: SELECT opt_all_distinct . selection table_exp NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 TIMES shift, and go to state 62 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 selection go to state 241 scalar_exp go to state 68 scalar_exp_commalist go to state 69 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 199 111 values_or_query_spec: VALUES LPAREN . insert_atom_commalist RPAREN STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 NULLX shift, and go to state 242 USER shift, and go to state 64 COLON shift, and go to state 66 insert_atom_commalist go to state 243 insert_atom go to state 244 atom go to state 245 parameter_ref go to state 71 literal go to state 73 parameter go to state 75 state 200 62 module_def: MODULE opt_module LANGUAGE lang AUTHORIZATION user . opt_cursor_def_list procedure_def_list DECLARE shift, and go to state 246 $default reduce using rule 71 (opt_cursor_def_list) opt_cursor_def_list go to state 247 cursor_def_list go to state 248 cursor_def go to state 249 state 201 220 column_ref: NAME PERIOD NAME PERIOD . NAME NAME shift, and go to state 250 state 202 209 function_ref: AMMSC LPAREN TIMES RPAREN . $default reduce using rule 209 (function_ref) state 203 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp 211 function_ref: AMMSC LPAREN ALL scalar_exp . RPAREN MINUS shift, and go to state 107 PLUS shift, and go to state 108 DIV shift, and go to state 109 TIMES shift, and go to state 110 RPAREN shift, and go to state 251 state 204 210 function_ref: AMMSC LPAREN DISTINCT column_ref . RPAREN RPAREN shift, and go to state 252 state 205 212 function_ref: AMMSC LPAREN scalar_exp RPAREN . $default reduce using rule 212 (function_ref) state 206 144 from_clause: FROM . table_ref_commalist NAME shift, and go to state 44 table_ref_commalist go to state 253 table_ref go to state 254 table go to state 255 state 207 119 select_statement: SELECT opt_all_distinct selection INTO target_commalist table_exp . $default reduce using rule 119 (select_statement) state 208 143 table_exp: from_clause . opt_where_clause opt_group_by_clause opt_having_clause WHERE shift, and go to state 256 $default reduce using rule 133 (opt_where_clause) opt_where_clause go to state 257 where_clause go to state 87 state 209 123 update_statement_positioned: UPDATE table SET assignment_commalist WHERE CURRENT . OF cursor OF shift, and go to state 258 state 210 126 assignment_commalist: assignment_commalist COMMA assignment . $default reduce using rule 126 (assignment_commalist) state 211 128 assignment: column ASSIGN_OP NULLX . $default reduce using rule 128 (assignment) state 212 127 assignment: column ASSIGN_OP scalar_exp . 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp MINUS shift, and go to state 107 PLUS shift, and go to state 108 DIV shift, and go to state 109 TIMES shift, and go to state 110 $default reduce using rule 127 (assignment) state 213 16 base_table_def: CREATE TABLE table . LPAREN base_table_element_commalist RPAREN LPAREN shift, and go to state 259 state 214 40 view_def: CREATE VIEW table . opt_column_commalist AS query_spec opt_with_check_option LPAREN shift, and go to state 91 $default reduce using rule 43 (opt_column_commalist) opt_column_commalist go to state 260 state 215 48 privileges: ALL PRIVILEGES . $default reduce using rule 48 (privileges) state 216 57 operation: REFERENCES opt_column_commalist . $default reduce using rule 57 (operation) state 217 56 operation: UPDATE opt_column_commalist . $default reduce using rule 56 (operation) state 218 45 privilege_def: GRANT privileges ON . table TO grantee_commalist opt_with_grant_option NAME shift, and go to state 44 table go to state 261 state 219 52 operation_commalist: operation_commalist COMMA . operation DELETE shift, and go to state 172 INSERT shift, and go to state 173 REFERENCES shift, and go to state 174 SELECT shift, and go to state 175 UPDATE shift, and go to state 176 operation go to state 262 state 220 107 delete_statement_positioned: DELETE FROM table WHERE CURRENT OF cursor . $default reduce using rule 107 (delete_statement_positioned) state 221 190 subquery: LPAREN SELECT . opt_all_distinct selection table_exp RPAREN ALL shift, and go to state 41 DISTINCT shift, and go to state 42 $default reduce using rule 120 (opt_all_distinct) opt_all_distinct go to state 263 state 222 160 search_condition: LPAREN search_condition RPAREN . $default reduce using rule 160 (search_condition) state 223 157 search_condition: search_condition . OR search_condition 157 | search_condition OR search_condition . 158 | search_condition . AND search_condition AND shift, and go to state 188 $default reduce using rule 157 (search_condition) state 224 157 search_condition: search_condition . OR search_condition 158 | search_condition . AND search_condition 158 | search_condition AND search_condition . $default reduce using rule 158 (search_condition) state 225 171 between_predicate: scalar_exp NOT BETWEEN . scalar_exp AND scalar_exp NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 264 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 226 179 in_predicate: scalar_exp NOT IN . LPAREN subquery RPAREN 181 | scalar_exp NOT IN . LPAREN atom_commalist RPAREN LPAREN shift, and go to state 265 state 227 173 like_predicate: scalar_exp NOT LIKE . atom opt_escape STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 USER shift, and go to state 64 COLON shift, and go to state 66 atom go to state 266 parameter_ref go to state 71 literal go to state 73 parameter go to state 75 state 228 187 any_all_some: ALL . $default reduce using rule 187 (any_all_some) state 229 186 any_all_some: ANY . $default reduce using rule 186 (any_all_some) state 230 188 any_all_some: SOME . $default reduce using rule 188 (any_all_some) state 231 190 subquery: LPAREN . SELECT opt_all_distinct selection table_exp RPAREN 200 scalar_exp: LPAREN . scalar_exp RPAREN NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 SELECT shift, and go to state 221 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 104 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 232 185 all_or_any_predicate: scalar_exp COMPARISON any_all_some . subquery LPAREN shift, and go to state 183 subquery go to state 267 state 233 170 comparison_predicate: scalar_exp COMPARISON subquery . $default reduce using rule 170 (comparison_predicate) state 234 169 comparison_predicate: scalar_exp COMPARISON scalar_exp . 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp MINUS shift, and go to state 107 PLUS shift, and go to state 108 DIV shift, and go to state 109 TIMES shift, and go to state 110 $default reduce using rule 169 (comparison_predicate) state 235 172 between_predicate: scalar_exp BETWEEN scalar_exp . AND scalar_exp 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp AND shift, and go to state 268 MINUS shift, and go to state 107 PLUS shift, and go to state 108 DIV shift, and go to state 109 TIMES shift, and go to state 110 state 236 180 in_predicate: scalar_exp IN LPAREN . subquery RPAREN 182 | scalar_exp IN LPAREN . atom_commalist RPAREN STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 USER shift, and go to state 64 LPAREN shift, and go to state 183 COLON shift, and go to state 66 atom_commalist go to state 269 subquery go to state 270 atom go to state 271 parameter_ref go to state 71 literal go to state 73 parameter go to state 75 state 237 174 like_predicate: scalar_exp LIKE atom . opt_escape ESCAPE shift, and go to state 272 $default reduce using rule 175 (opt_escape) opt_escape go to state 273 state 238 177 test_for_null: column_ref IS NOT . NULLX NULLX shift, and go to state 274 state 239 178 test_for_null: column_ref IS NULLX . $default reduce using rule 178 (test_for_null) state 240 39 column_commalist: column_commalist COMMA column . $default reduce using rule 39 (column_commalist) state 241 140 query_spec: SELECT opt_all_distinct selection . table_exp FROM shift, and go to state 206 table_exp go to state 275 from_clause go to state 208 state 242 116 insert_atom: NULLX . $default reduce using rule 116 (insert_atom) state 243 111 values_or_query_spec: VALUES LPAREN insert_atom_commalist . RPAREN 114 insert_atom_commalist: insert_atom_commalist . COMMA insert_atom RPAREN shift, and go to state 276 COMMA shift, and go to state 277 state 244 113 insert_atom_commalist: insert_atom . $default reduce using rule 113 (insert_atom_commalist) state 245 115 insert_atom: atom . $default reduce using rule 115 (insert_atom) state 246 75 cursor_def: DECLARE . cursor CURSOR FOR query_exp opt_order_by_clause NAME shift, and go to state 29 cursor go to state 278 state 247 62 module_def: MODULE opt_module LANGUAGE lang AUTHORIZATION user opt_cursor_def_list . procedure_def_list PROCEDURE shift, and go to state 279 procedure_def_list go to state 280 procedure_def go to state 281 state 248 72 opt_cursor_def_list: cursor_def_list . 74 cursor_def_list: cursor_def_list . cursor_def DECLARE shift, and go to state 246 $default reduce using rule 72 (opt_cursor_def_list) cursor_def go to state 282 state 249 73 cursor_def_list: cursor_def . $default reduce using rule 73 (cursor_def_list) state 250 220 column_ref: NAME PERIOD NAME PERIOD NAME . $default reduce using rule 220 (column_ref) state 251 211 function_ref: AMMSC LPAREN ALL scalar_exp RPAREN . $default reduce using rule 211 (function_ref) state 252 210 function_ref: AMMSC LPAREN DISTINCT column_ref RPAREN . $default reduce using rule 210 (function_ref) state 253 144 from_clause: FROM table_ref_commalist . 146 table_ref_commalist: table_ref_commalist . COMMA table_ref COMMA shift, and go to state 283 $default reduce using rule 144 (from_clause) state 254 145 table_ref_commalist: table_ref . $default reduce using rule 145 (table_ref_commalist) state 255 147 table_ref: table . 148 | table . range_variable NAME shift, and go to state 284 $default reduce using rule 147 (table_ref) range_variable go to state 285 state 256 149 where_clause: WHERE . search_condition NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 NOT shift, and go to state 129 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 EXISTS shift, and go to state 131 USER shift, and go to state 64 LPAREN shift, and go to state 132 COLON shift, and go to state 66 $default reduce using rule 156 (search_condition) search_condition go to state 133 predicate go to state 134 comparison_predicate go to state 135 between_predicate go to state 136 like_predicate go to state 137 test_for_null go to state 138 in_predicate go to state 139 all_or_any_predicate go to state 140 existence_test go to state 141 scalar_exp go to state 142 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 143 parameter go to state 75 state 257 143 table_exp: from_clause opt_where_clause . opt_group_by_clause opt_having_clause GROUP shift, and go to state 286 $default reduce using rule 150 (opt_group_by_clause) opt_group_by_clause go to state 287 state 258 123 update_statement_positioned: UPDATE table SET assignment_commalist WHERE CURRENT OF . cursor NAME shift, and go to state 29 cursor go to state 288 state 259 16 base_table_def: CREATE TABLE table LPAREN . base_table_element_commalist RPAREN NAME shift, and go to state 115 CHECK shift, and go to state 289 FOREIGN shift, and go to state 290 PRIMARY shift, and go to state 291 UNIQUE shift, and go to state 292 base_table_element_commalist go to state 293 base_table_element go to state 294 column_def go to state 295 table_constraint_def go to state 296 column go to state 297 state 260 40 view_def: CREATE VIEW table opt_column_commalist . AS query_spec opt_with_check_option AS shift, and go to state 298 state 261 45 privilege_def: GRANT privileges ON table . TO grantee_commalist opt_with_grant_option TO shift, and go to state 299 state 262 52 operation_commalist: operation_commalist COMMA operation . $default reduce using rule 52 (operation_commalist) state 263 190 subquery: LPAREN SELECT opt_all_distinct . selection table_exp RPAREN NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 TIMES shift, and go to state 62 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 selection go to state 300 scalar_exp go to state 68 scalar_exp_commalist go to state 69 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 264 171 between_predicate: scalar_exp NOT BETWEEN scalar_exp . AND scalar_exp 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp AND shift, and go to state 301 MINUS shift, and go to state 107 PLUS shift, and go to state 108 DIV shift, and go to state 109 TIMES shift, and go to state 110 state 265 179 in_predicate: scalar_exp NOT IN LPAREN . subquery RPAREN 181 | scalar_exp NOT IN LPAREN . atom_commalist RPAREN STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 USER shift, and go to state 64 LPAREN shift, and go to state 183 COLON shift, and go to state 66 atom_commalist go to state 302 subquery go to state 303 atom go to state 271 parameter_ref go to state 71 literal go to state 73 parameter go to state 75 state 266 173 like_predicate: scalar_exp NOT LIKE atom . opt_escape ESCAPE shift, and go to state 272 $default reduce using rule 175 (opt_escape) opt_escape go to state 304 state 267 185 all_or_any_predicate: scalar_exp COMPARISON any_all_some subquery . $default reduce using rule 185 (all_or_any_predicate) state 268 172 between_predicate: scalar_exp BETWEEN scalar_exp AND . scalar_exp NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 305 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 269 182 in_predicate: scalar_exp IN LPAREN atom_commalist . RPAREN 184 atom_commalist: atom_commalist . COMMA atom RPAREN shift, and go to state 306 COMMA shift, and go to state 307 state 270 180 in_predicate: scalar_exp IN LPAREN subquery . RPAREN RPAREN shift, and go to state 308 state 271 183 atom_commalist: atom . $default reduce using rule 183 (atom_commalist) state 272 176 opt_escape: ESCAPE . atom STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 USER shift, and go to state 64 COLON shift, and go to state 66 atom go to state 309 parameter_ref go to state 71 literal go to state 73 parameter go to state 75 state 273 174 like_predicate: scalar_exp LIKE atom opt_escape . $default reduce using rule 174 (like_predicate) state 274 177 test_for_null: column_ref IS NOT NULLX . $default reduce using rule 177 (test_for_null) state 275 140 query_spec: SELECT opt_all_distinct selection table_exp . $default reduce using rule 140 (query_spec) state 276 111 values_or_query_spec: VALUES LPAREN insert_atom_commalist RPAREN . $default reduce using rule 111 (values_or_query_spec) state 277 114 insert_atom_commalist: insert_atom_commalist COMMA . insert_atom STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 NULLX shift, and go to state 242 USER shift, and go to state 64 COLON shift, and go to state 66 insert_atom go to state 310 atom go to state 245 parameter_ref go to state 71 literal go to state 73 parameter go to state 75 state 278 75 cursor_def: DECLARE cursor . CURSOR FOR query_exp opt_order_by_clause CURSOR shift, and go to state 311 state 279 87 procedure_def: PROCEDURE . procedure parameter_def_list SEMICOLON manipulative_statement_list NAME shift, and go to state 312 procedure go to state 313 state 280 62 module_def: MODULE opt_module LANGUAGE lang AUTHORIZATION user opt_cursor_def_list procedure_def_list . 86 procedure_def_list: procedure_def_list . procedure_def PROCEDURE shift, and go to state 279 $default reduce using rule 62 (module_def) procedure_def go to state 314 state 281 85 procedure_def_list: procedure_def . $default reduce using rule 85 (procedure_def_list) state 282 74 cursor_def_list: cursor_def_list cursor_def . $default reduce using rule 74 (cursor_def_list) state 283 146 table_ref_commalist: table_ref_commalist COMMA . table_ref NAME shift, and go to state 44 table_ref go to state 315 table go to state 255 state 284 240 range_variable: NAME . $default reduce using rule 240 (range_variable) state 285 148 table_ref: table range_variable . $default reduce using rule 148 (table_ref) state 286 151 opt_group_by_clause: GROUP . BY column_ref_commalist BY shift, and go to state 316 state 287 143 table_exp: from_clause opt_where_clause opt_group_by_clause . opt_having_clause HAVING shift, and go to state 317 $default reduce using rule 154 (opt_having_clause) opt_having_clause go to state 318 state 288 123 update_statement_positioned: UPDATE table SET assignment_commalist WHERE CURRENT OF cursor . $default reduce using rule 123 (update_statement_positioned) state 289 37 table_constraint_def: CHECK . LPAREN search_condition RPAREN LPAREN shift, and go to state 319 state 290 35 table_constraint_def: FOREIGN . KEY LPAREN column_commalist RPAREN REFERENCES table 36 | FOREIGN . KEY LPAREN column_commalist RPAREN REFERENCES table LPAREN column_commalist RPAREN KEY shift, and go to state 320 state 291 34 table_constraint_def: PRIMARY . KEY LPAREN column_commalist RPAREN KEY shift, and go to state 321 state 292 33 table_constraint_def: UNIQUE . LPAREN column_commalist RPAREN LPAREN shift, and go to state 322 state 293 16 base_table_def: CREATE TABLE table LPAREN base_table_element_commalist . RPAREN 18 base_table_element_commalist: base_table_element_commalist . COMMA base_table_element RPAREN shift, and go to state 323 COMMA shift, and go to state 324 state 294 17 base_table_element_commalist: base_table_element . $default reduce using rule 17 (base_table_element_commalist) state 295 19 base_table_element: column_def . $default reduce using rule 19 (base_table_element) state 296 20 base_table_element: table_constraint_def . $default reduce using rule 20 (base_table_element) state 297 21 column_def: column . data_type column_def_opt_list CHARACTER shift, and go to state 325 DECIMAL shift, and go to state 326 DOUBLE shift, and go to state 327 FLOAT shift, and go to state 328 INTEGER shift, and go to state 329 NUMERIC shift, and go to state 330 REAL shift, and go to state 331 SMALLINT shift, and go to state 332 data_type go to state 333 state 298 40 view_def: CREATE VIEW table opt_column_commalist AS . query_spec opt_with_check_option SELECT shift, and go to state 147 query_spec go to state 334 state 299 45 privilege_def: GRANT privileges ON table TO . grantee_commalist opt_with_grant_option NAME shift, and go to state 83 PUBLIC shift, and go to state 335 grantee_commalist go to state 336 grantee go to state 337 user go to state 338 state 300 190 subquery: LPAREN SELECT opt_all_distinct selection . table_exp RPAREN FROM shift, and go to state 206 table_exp go to state 339 from_clause go to state 208 state 301 171 between_predicate: scalar_exp NOT BETWEEN scalar_exp AND . scalar_exp NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 USER shift, and go to state 64 LPAREN shift, and go to state 65 COLON shift, and go to state 66 scalar_exp go to state 340 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 74 parameter go to state 75 state 302 181 in_predicate: scalar_exp NOT IN LPAREN atom_commalist . RPAREN 184 atom_commalist: atom_commalist . COMMA atom RPAREN shift, and go to state 341 COMMA shift, and go to state 307 state 303 179 in_predicate: scalar_exp NOT IN LPAREN subquery . RPAREN RPAREN shift, and go to state 342 state 304 173 like_predicate: scalar_exp NOT LIKE atom opt_escape . $default reduce using rule 173 (like_predicate) state 305 172 between_predicate: scalar_exp BETWEEN scalar_exp AND scalar_exp . 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp MINUS shift, and go to state 107 PLUS shift, and go to state 108 DIV shift, and go to state 109 TIMES shift, and go to state 110 $default reduce using rule 172 (between_predicate) state 306 182 in_predicate: scalar_exp IN LPAREN atom_commalist RPAREN . $default reduce using rule 182 (in_predicate) state 307 184 atom_commalist: atom_commalist COMMA . atom STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 USER shift, and go to state 64 COLON shift, and go to state 66 atom go to state 343 parameter_ref go to state 71 literal go to state 73 parameter go to state 75 state 308 180 in_predicate: scalar_exp IN LPAREN subquery RPAREN . $default reduce using rule 180 (in_predicate) state 309 176 opt_escape: ESCAPE atom . $default reduce using rule 176 (opt_escape) state 310 114 insert_atom_commalist: insert_atom_commalist COMMA insert_atom . $default reduce using rule 114 (insert_atom_commalist) state 311 75 cursor_def: DECLARE cursor CURSOR . FOR query_exp opt_order_by_clause FOR shift, and go to state 344 state 312 239 procedure: NAME . $default reduce using rule 239 (procedure) state 313 87 procedure_def: PROCEDURE procedure . parameter_def_list SEMICOLON manipulative_statement_list SQLCODE shift, and go to state 345 COLON shift, and go to state 66 parameter_def_list go to state 346 parameter_def go to state 347 parameter go to state 348 state 314 86 procedure_def_list: procedure_def_list procedure_def . $default reduce using rule 86 (procedure_def_list) state 315 146 table_ref_commalist: table_ref_commalist COMMA table_ref . $default reduce using rule 146 (table_ref_commalist) state 316 151 opt_group_by_clause: GROUP BY . column_ref_commalist NAME shift, and go to state 56 column_ref_commalist go to state 349 column_ref go to state 350 state 317 155 opt_having_clause: HAVING . search_condition NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 NOT shift, and go to state 129 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 EXISTS shift, and go to state 131 USER shift, and go to state 64 LPAREN shift, and go to state 132 COLON shift, and go to state 66 $default reduce using rule 156 (search_condition) search_condition go to state 351 predicate go to state 134 comparison_predicate go to state 135 between_predicate go to state 136 like_predicate go to state 137 test_for_null go to state 138 in_predicate go to state 139 all_or_any_predicate go to state 140 existence_test go to state 141 scalar_exp go to state 142 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 143 parameter go to state 75 state 318 143 table_exp: from_clause opt_where_clause opt_group_by_clause opt_having_clause . $default reduce using rule 143 (table_exp) state 319 37 table_constraint_def: CHECK LPAREN . search_condition RPAREN NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 NOT shift, and go to state 129 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 EXISTS shift, and go to state 131 USER shift, and go to state 64 LPAREN shift, and go to state 132 COLON shift, and go to state 66 $default reduce using rule 156 (search_condition) search_condition go to state 352 predicate go to state 134 comparison_predicate go to state 135 between_predicate go to state 136 like_predicate go to state 137 test_for_null go to state 138 in_predicate go to state 139 all_or_any_predicate go to state 140 existence_test go to state 141 scalar_exp go to state 142 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 143 parameter go to state 75 state 320 35 table_constraint_def: FOREIGN KEY . LPAREN column_commalist RPAREN REFERENCES table 36 | FOREIGN KEY . LPAREN column_commalist RPAREN REFERENCES table LPAREN column_commalist RPAREN LPAREN shift, and go to state 353 state 321 34 table_constraint_def: PRIMARY KEY . LPAREN column_commalist RPAREN LPAREN shift, and go to state 354 state 322 33 table_constraint_def: UNIQUE LPAREN . column_commalist RPAREN NAME shift, and go to state 115 column_commalist go to state 355 column go to state 146 state 323 16 base_table_def: CREATE TABLE table LPAREN base_table_element_commalist RPAREN . $default reduce using rule 16 (base_table_def) state 324 18 base_table_element_commalist: base_table_element_commalist COMMA . base_table_element NAME shift, and go to state 115 CHECK shift, and go to state 289 FOREIGN shift, and go to state 290 PRIMARY shift, and go to state 291 UNIQUE shift, and go to state 292 base_table_element go to state 356 column_def go to state 295 table_constraint_def go to state 296 column go to state 297 state 325 221 data_type: CHARACTER . 222 | CHARACTER . LPAREN INTNUM RPAREN LPAREN shift, and go to state 357 $default reduce using rule 221 (data_type) state 326 226 data_type: DECIMAL . 227 | DECIMAL . LPAREN INTNUM RPAREN 228 | DECIMAL . LPAREN INTNUM COMMA INTNUM RPAREN LPAREN shift, and go to state 358 $default reduce using rule 226 (data_type) state 327 234 data_type: DOUBLE . PRECISION PRECISION shift, and go to state 359 state 328 231 data_type: FLOAT . 232 | FLOAT . LPAREN INTNUM RPAREN LPAREN shift, and go to state 360 $default reduce using rule 231 (data_type) state 329 229 data_type: INTEGER . $default reduce using rule 229 (data_type) state 330 223 data_type: NUMERIC . 224 | NUMERIC . LPAREN INTNUM RPAREN 225 | NUMERIC . LPAREN INTNUM COMMA INTNUM RPAREN LPAREN shift, and go to state 361 $default reduce using rule 223 (data_type) state 331 233 data_type: REAL . $default reduce using rule 233 (data_type) state 332 230 data_type: SMALLINT . $default reduce using rule 230 (data_type) state 333 21 column_def: column data_type . column_def_opt_list $default reduce using rule 22 (column_def_opt_list) column_def_opt_list go to state 362 state 334 40 view_def: CREATE VIEW table opt_column_commalist AS query_spec . opt_with_check_option WITH shift, and go to state 363 $default reduce using rule 41 (opt_with_check_option) opt_with_check_option go to state 364 state 335 60 grantee: PUBLIC . $default reduce using rule 60 (grantee) state 336 45 privilege_def: GRANT privileges ON table TO grantee_commalist . opt_with_grant_option 59 grantee_commalist: grantee_commalist . COMMA grantee WITH shift, and go to state 365 COMMA shift, and go to state 366 $default reduce using rule 46 (opt_with_grant_option) opt_with_grant_option go to state 367 state 337 58 grantee_commalist: grantee . $default reduce using rule 58 (grantee_commalist) state 338 61 grantee: user . $default reduce using rule 61 (grantee) state 339 190 subquery: LPAREN SELECT opt_all_distinct selection table_exp . RPAREN RPAREN shift, and go to state 368 state 340 171 between_predicate: scalar_exp NOT BETWEEN scalar_exp AND scalar_exp . 191 scalar_exp: scalar_exp . PLUS scalar_exp 192 | scalar_exp . MINUS scalar_exp 193 | scalar_exp . TIMES scalar_exp 194 | scalar_exp . DIV scalar_exp MINUS shift, and go to state 107 PLUS shift, and go to state 108 DIV shift, and go to state 109 TIMES shift, and go to state 110 $default reduce using rule 171 (between_predicate) state 341 181 in_predicate: scalar_exp NOT IN LPAREN atom_commalist RPAREN . $default reduce using rule 181 (in_predicate) state 342 179 in_predicate: scalar_exp NOT IN LPAREN subquery RPAREN . $default reduce using rule 179 (in_predicate) state 343 184 atom_commalist: atom_commalist COMMA atom . $default reduce using rule 184 (atom_commalist) state 344 75 cursor_def: DECLARE cursor CURSOR FOR . query_exp opt_order_by_clause SELECT shift, and go to state 147 LPAREN shift, and go to state 369 query_exp go to state 370 query_term go to state 371 query_spec go to state 372 state 345 93 parameter_def: SQLCODE . $default reduce using rule 93 (parameter_def) state 346 87 procedure_def: PROCEDURE procedure parameter_def_list . SEMICOLON manipulative_statement_list 91 parameter_def_list: parameter_def_list . parameter_def SQLCODE shift, and go to state 345 SEMICOLON shift, and go to state 373 COLON shift, and go to state 66 parameter_def go to state 374 parameter go to state 348 state 347 90 parameter_def_list: parameter_def . $default reduce using rule 90 (parameter_def_list) state 348 92 parameter_def: parameter . data_type CHARACTER shift, and go to state 325 DECIMAL shift, and go to state 326 DOUBLE shift, and go to state 327 FLOAT shift, and go to state 328 INTEGER shift, and go to state 329 NUMERIC shift, and go to state 330 REAL shift, and go to state 331 SMALLINT shift, and go to state 332 data_type go to state 375 state 349 151 opt_group_by_clause: GROUP BY column_ref_commalist . 153 column_ref_commalist: column_ref_commalist . COMMA column_ref COMMA shift, and go to state 376 $default reduce using rule 151 (opt_group_by_clause) state 350 152 column_ref_commalist: column_ref . $default reduce using rule 152 (column_ref_commalist) state 351 155 opt_having_clause: HAVING search_condition . 157 search_condition: search_condition . OR search_condition 158 | search_condition . AND search_condition OR shift, and go to state 187 AND shift, and go to state 188 $default reduce using rule 155 (opt_having_clause) state 352 37 table_constraint_def: CHECK LPAREN search_condition . RPAREN 157 search_condition: search_condition . OR search_condition 158 | search_condition . AND search_condition OR shift, and go to state 187 AND shift, and go to state 188 RPAREN shift, and go to state 377 state 353 35 table_constraint_def: FOREIGN KEY LPAREN . column_commalist RPAREN REFERENCES table 36 | FOREIGN KEY LPAREN . column_commalist RPAREN REFERENCES table LPAREN column_commalist RPAREN NAME shift, and go to state 115 column_commalist go to state 378 column go to state 146 state 354 34 table_constraint_def: PRIMARY KEY LPAREN . column_commalist RPAREN NAME shift, and go to state 115 column_commalist go to state 379 column go to state 146 state 355 33 table_constraint_def: UNIQUE LPAREN column_commalist . RPAREN 39 column_commalist: column_commalist . COMMA column RPAREN shift, and go to state 380 COMMA shift, and go to state 197 state 356 18 base_table_element_commalist: base_table_element_commalist COMMA base_table_element . $default reduce using rule 18 (base_table_element_commalist) state 357 222 data_type: CHARACTER LPAREN . INTNUM RPAREN INTNUM shift, and go to state 381 state 358 227 data_type: DECIMAL LPAREN . INTNUM RPAREN 228 | DECIMAL LPAREN . INTNUM COMMA INTNUM RPAREN INTNUM shift, and go to state 382 state 359 234 data_type: DOUBLE PRECISION . $default reduce using rule 234 (data_type) state 360 232 data_type: FLOAT LPAREN . INTNUM RPAREN INTNUM shift, and go to state 383 state 361 224 data_type: NUMERIC LPAREN . INTNUM RPAREN 225 | NUMERIC LPAREN . INTNUM COMMA INTNUM RPAREN INTNUM shift, and go to state 384 state 362 21 column_def: column data_type column_def_opt_list . 23 column_def_opt_list: column_def_opt_list . column_def_opt NOT shift, and go to state 385 CHECK shift, and go to state 386 DEFAULT shift, and go to state 387 REFERENCES shift, and go to state 388 $default reduce using rule 21 (column_def) column_def_opt go to state 389 state 363 42 opt_with_check_option: WITH . CHECK OPTION CHECK shift, and go to state 390 state 364 40 view_def: CREATE VIEW table opt_column_commalist AS query_spec opt_with_check_option . $default reduce using rule 40 (view_def) state 365 47 opt_with_grant_option: WITH . GRANT OPTION GRANT shift, and go to state 391 state 366 59 grantee_commalist: grantee_commalist COMMA . grantee NAME shift, and go to state 83 PUBLIC shift, and go to state 335 grantee go to state 392 user go to state 338 state 367 45 privilege_def: GRANT privileges ON table TO grantee_commalist opt_with_grant_option . $default reduce using rule 45 (privilege_def) state 368 190 subquery: LPAREN SELECT opt_all_distinct selection table_exp RPAREN . $default reduce using rule 190 (subquery) state 369 139 query_term: LPAREN . query_exp RPAREN SELECT shift, and go to state 147 LPAREN shift, and go to state 369 query_exp go to state 393 query_term go to state 371 query_spec go to state 372 state 370 75 cursor_def: DECLARE cursor CURSOR FOR query_exp . opt_order_by_clause 136 query_exp: query_exp . UNION query_term 137 | query_exp . UNION ALL query_term ORDER shift, and go to state 394 UNION shift, and go to state 395 $default reduce using rule 76 (opt_order_by_clause) opt_order_by_clause go to state 396 state 371 135 query_exp: query_term . $default reduce using rule 135 (query_exp) state 372 138 query_term: query_spec . $default reduce using rule 138 (query_term) state 373 87 procedure_def: PROCEDURE procedure parameter_def_list SEMICOLON . manipulative_statement_list CLOSE shift, and go to state 1 COMMIT shift, and go to state 2 DELETE shift, and go to state 4 FETCH shift, and go to state 5 INSERT shift, and go to state 6 OPEN shift, and go to state 8 ROLLBACK shift, and go to state 9 SELECT shift, and go to state 10 UPDATE shift, and go to state 11 manipulative_statement_list go to state 397 manipulative_statement go to state 398 close_statement go to state 18 commit_statement go to state 19 delete_statement_positioned go to state 20 delete_statement_searched go to state 21 fetch_statement go to state 22 insert_statement go to state 23 open_statement go to state 24 rollback_statement go to state 25 select_statement go to state 26 update_statement_positioned go to state 27 update_statement_searched go to state 28 state 374 91 parameter_def_list: parameter_def_list parameter_def . $default reduce using rule 91 (parameter_def_list) state 375 92 parameter_def: parameter data_type . $default reduce using rule 92 (parameter_def) state 376 153 column_ref_commalist: column_ref_commalist COMMA . column_ref NAME shift, and go to state 56 column_ref go to state 399 state 377 37 table_constraint_def: CHECK LPAREN search_condition RPAREN . $default reduce using rule 37 (table_constraint_def) state 378 35 table_constraint_def: FOREIGN KEY LPAREN column_commalist . RPAREN REFERENCES table 36 | FOREIGN KEY LPAREN column_commalist . RPAREN REFERENCES table LPAREN column_commalist RPAREN 39 column_commalist: column_commalist . COMMA column RPAREN shift, and go to state 400 COMMA shift, and go to state 197 state 379 34 table_constraint_def: PRIMARY KEY LPAREN column_commalist . RPAREN 39 column_commalist: column_commalist . COMMA column RPAREN shift, and go to state 401 COMMA shift, and go to state 197 state 380 33 table_constraint_def: UNIQUE LPAREN column_commalist RPAREN . $default reduce using rule 33 (table_constraint_def) state 381 222 data_type: CHARACTER LPAREN INTNUM . RPAREN RPAREN shift, and go to state 402 state 382 227 data_type: DECIMAL LPAREN INTNUM . RPAREN 228 | DECIMAL LPAREN INTNUM . COMMA INTNUM RPAREN RPAREN shift, and go to state 403 COMMA shift, and go to state 404 state 383 232 data_type: FLOAT LPAREN INTNUM . RPAREN RPAREN shift, and go to state 405 state 384 224 data_type: NUMERIC LPAREN INTNUM . RPAREN 225 | NUMERIC LPAREN INTNUM . COMMA INTNUM RPAREN RPAREN shift, and go to state 406 COMMA shift, and go to state 407 state 385 24 column_def_opt: NOT . NULLX 25 | NOT . NULLX UNIQUE 26 | NOT . NULLX PRIMARY KEY NULLX shift, and go to state 408 state 386 30 column_def_opt: CHECK . LPAREN search_condition RPAREN LPAREN shift, and go to state 409 state 387 27 column_def_opt: DEFAULT . literal 28 | DEFAULT . NULLX 29 | DEFAULT . USER STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 NULLX shift, and go to state 410 USER shift, and go to state 411 literal go to state 412 state 388 31 column_def_opt: REFERENCES . table 32 | REFERENCES . table LPAREN column_commalist RPAREN NAME shift, and go to state 44 table go to state 413 state 389 23 column_def_opt_list: column_def_opt_list column_def_opt . $default reduce using rule 23 (column_def_opt_list) state 390 42 opt_with_check_option: WITH CHECK . OPTION OPTION shift, and go to state 414 state 391 47 opt_with_grant_option: WITH GRANT . OPTION OPTION shift, and go to state 415 state 392 59 grantee_commalist: grantee_commalist COMMA grantee . $default reduce using rule 59 (grantee_commalist) state 393 136 query_exp: query_exp . UNION query_term 137 | query_exp . UNION ALL query_term 139 query_term: LPAREN query_exp . RPAREN UNION shift, and go to state 395 RPAREN shift, and go to state 416 state 394 77 opt_order_by_clause: ORDER . BY ordering_spec_commalist BY shift, and go to state 417 state 395 136 query_exp: query_exp UNION . query_term 137 | query_exp UNION . ALL query_term ALL shift, and go to state 418 SELECT shift, and go to state 147 LPAREN shift, and go to state 369 query_term go to state 419 query_spec go to state 372 state 396 75 cursor_def: DECLARE cursor CURSOR FOR query_exp opt_order_by_clause . $default reduce using rule 75 (cursor_def) state 397 87 procedure_def: PROCEDURE procedure parameter_def_list SEMICOLON manipulative_statement_list . 89 manipulative_statement_list: manipulative_statement_list . manipulative_statement CLOSE shift, and go to state 1 COMMIT shift, and go to state 2 DELETE shift, and go to state 4 FETCH shift, and go to state 5 INSERT shift, and go to state 6 OPEN shift, and go to state 8 ROLLBACK shift, and go to state 9 SELECT shift, and go to state 10 UPDATE shift, and go to state 11 $default reduce using rule 87 (procedure_def) manipulative_statement go to state 420 close_statement go to state 18 commit_statement go to state 19 delete_statement_positioned go to state 20 delete_statement_searched go to state 21 fetch_statement go to state 22 insert_statement go to state 23 open_statement go to state 24 rollback_statement go to state 25 select_statement go to state 26 update_statement_positioned go to state 27 update_statement_searched go to state 28 state 398 88 manipulative_statement_list: manipulative_statement . $default reduce using rule 88 (manipulative_statement_list) state 399 153 column_ref_commalist: column_ref_commalist COMMA column_ref . $default reduce using rule 153 (column_ref_commalist) state 400 35 table_constraint_def: FOREIGN KEY LPAREN column_commalist RPAREN . REFERENCES table 36 | FOREIGN KEY LPAREN column_commalist RPAREN . REFERENCES table LPAREN column_commalist RPAREN REFERENCES shift, and go to state 421 state 401 34 table_constraint_def: PRIMARY KEY LPAREN column_commalist RPAREN . $default reduce using rule 34 (table_constraint_def) state 402 222 data_type: CHARACTER LPAREN INTNUM RPAREN . $default reduce using rule 222 (data_type) state 403 227 data_type: DECIMAL LPAREN INTNUM RPAREN . $default reduce using rule 227 (data_type) state 404 228 data_type: DECIMAL LPAREN INTNUM COMMA . INTNUM RPAREN INTNUM shift, and go to state 422 state 405 232 data_type: FLOAT LPAREN INTNUM RPAREN . $default reduce using rule 232 (data_type) state 406 224 data_type: NUMERIC LPAREN INTNUM RPAREN . $default reduce using rule 224 (data_type) state 407 225 data_type: NUMERIC LPAREN INTNUM COMMA . INTNUM RPAREN INTNUM shift, and go to state 423 state 408 24 column_def_opt: NOT NULLX . 25 | NOT NULLX . UNIQUE 26 | NOT NULLX . PRIMARY KEY PRIMARY shift, and go to state 424 UNIQUE shift, and go to state 425 $default reduce using rule 24 (column_def_opt) state 409 30 column_def_opt: CHECK LPAREN . search_condition RPAREN NAME shift, and go to state 56 STRING shift, and go to state 57 INTNUM shift, and go to state 58 APPROXNUM shift, and go to state 59 NOT shift, and go to state 129 MINUS shift, and go to state 60 PLUS shift, and go to state 61 AMMSC shift, and go to state 63 EXISTS shift, and go to state 131 USER shift, and go to state 64 LPAREN shift, and go to state 132 COLON shift, and go to state 66 $default reduce using rule 156 (search_condition) search_condition go to state 426 predicate go to state 134 comparison_predicate go to state 135 between_predicate go to state 136 like_predicate go to state 137 test_for_null go to state 138 in_predicate go to state 139 all_or_any_predicate go to state 140 existence_test go to state 141 scalar_exp go to state 142 atom go to state 70 parameter_ref go to state 71 function_ref go to state 72 literal go to state 73 column_ref go to state 143 parameter go to state 75 state 410 28 column_def_opt: DEFAULT NULLX . $default reduce using rule 28 (column_def_opt) state 411 29 column_def_opt: DEFAULT USER . $default reduce using rule 29 (column_def_opt) state 412 27 column_def_opt: DEFAULT literal . $default reduce using rule 27 (column_def_opt) state 413 31 column_def_opt: REFERENCES table . 32 | REFERENCES table . LPAREN column_commalist RPAREN LPAREN shift, and go to state 427 $default reduce using rule 31 (column_def_opt) state 414 42 opt_with_check_option: WITH CHECK OPTION . $default reduce using rule 42 (opt_with_check_option) state 415 47 opt_with_grant_option: WITH GRANT OPTION . $default reduce using rule 47 (opt_with_grant_option) state 416 139 query_term: LPAREN query_exp RPAREN . $default reduce using rule 139 (query_term) state 417 77 opt_order_by_clause: ORDER BY . ordering_spec_commalist NAME shift, and go to state 56 INTNUM shift, and go to state 428 ordering_spec_commalist go to state 429 ordering_spec go to state 430 column_ref go to state 431 state 418 137 query_exp: query_exp UNION ALL . query_term SELECT shift, and go to state 147 LPAREN shift, and go to state 369 query_term go to state 432 query_spec go to state 372 state 419 136 query_exp: query_exp UNION query_term . $default reduce using rule 136 (query_exp) state 420 89 manipulative_statement_list: manipulative_statement_list manipulative_statement . $default reduce using rule 89 (manipulative_statement_list) state 421 35 table_constraint_def: FOREIGN KEY LPAREN column_commalist RPAREN REFERENCES . table 36 | FOREIGN KEY LPAREN column_commalist RPAREN REFERENCES . table LPAREN column_commalist RPAREN NAME shift, and go to state 44 table go to state 433 state 422 228 data_type: DECIMAL LPAREN INTNUM COMMA INTNUM . RPAREN RPAREN shift, and go to state 434 state 423 225 data_type: NUMERIC LPAREN INTNUM COMMA INTNUM . RPAREN RPAREN shift, and go to state 435 state 424 26 column_def_opt: NOT NULLX PRIMARY . KEY KEY shift, and go to state 436 state 425 25 column_def_opt: NOT NULLX UNIQUE . $default reduce using rule 25 (column_def_opt) state 426 30 column_def_opt: CHECK LPAREN search_condition . RPAREN 157 search_condition: search_condition . OR search_condition 158 | search_condition . AND search_condition OR shift, and go to state 187 AND shift, and go to state 188 RPAREN shift, and go to state 437 state 427 32 column_def_opt: REFERENCES table LPAREN . column_commalist RPAREN NAME shift, and go to state 115 column_commalist go to state 438 column go to state 146 state 428 80 ordering_spec: INTNUM . opt_asc_desc ASC shift, and go to state 439 DESC shift, and go to state 440 $default reduce using rule 82 (opt_asc_desc) opt_asc_desc go to state 441 state 429 77 opt_order_by_clause: ORDER BY ordering_spec_commalist . 79 ordering_spec_commalist: ordering_spec_commalist . COMMA ordering_spec COMMA shift, and go to state 442 $default reduce using rule 77 (opt_order_by_clause) state 430 78 ordering_spec_commalist: ordering_spec . $default reduce using rule 78 (ordering_spec_commalist) state 431 81 ordering_spec: column_ref . opt_asc_desc ASC shift, and go to state 439 DESC shift, and go to state 440 $default reduce using rule 82 (opt_asc_desc) opt_asc_desc go to state 443 state 432 137 query_exp: query_exp UNION ALL query_term . $default reduce using rule 137 (query_exp) state 433 35 table_constraint_def: FOREIGN KEY LPAREN column_commalist RPAREN REFERENCES table . 36 | FOREIGN KEY LPAREN column_commalist RPAREN REFERENCES table . LPAREN column_commalist RPAREN LPAREN shift, and go to state 444 $default reduce using rule 35 (table_constraint_def) state 434 228 data_type: DECIMAL LPAREN INTNUM COMMA INTNUM RPAREN . $default reduce using rule 228 (data_type) state 435 225 data_type: NUMERIC LPAREN INTNUM COMMA INTNUM RPAREN . $default reduce using rule 225 (data_type) state 436 26 column_def_opt: NOT NULLX PRIMARY KEY . $default reduce using rule 26 (column_def_opt) state 437 30 column_def_opt: CHECK LPAREN search_condition RPAREN . $default reduce using rule 30 (column_def_opt) state 438 32 column_def_opt: REFERENCES table LPAREN column_commalist . RPAREN 39 column_commalist: column_commalist . COMMA column RPAREN shift, and go to state 445 COMMA shift, and go to state 197 state 439 83 opt_asc_desc: ASC . $default reduce using rule 83 (opt_asc_desc) state 440 84 opt_asc_desc: DESC . $default reduce using rule 84 (opt_asc_desc) state 441 80 ordering_spec: INTNUM opt_asc_desc . $default reduce using rule 80 (ordering_spec) state 442 79 ordering_spec_commalist: ordering_spec_commalist COMMA . ordering_spec NAME shift, and go to state 56 INTNUM shift, and go to state 428 ordering_spec go to state 446 column_ref go to state 431 state 443 81 ordering_spec: column_ref opt_asc_desc . $default reduce using rule 81 (ordering_spec) state 444 36 table_constraint_def: FOREIGN KEY LPAREN column_commalist RPAREN REFERENCES table LPAREN . column_commalist RPAREN NAME shift, and go to state 115 column_commalist go to state 447 column go to state 146 state 445 32 column_def_opt: REFERENCES table LPAREN column_commalist RPAREN . $default reduce using rule 32 (column_def_opt) state 446 79 ordering_spec_commalist: ordering_spec_commalist COMMA ordering_spec . $default reduce using rule 79 (ordering_spec_commalist) state 447 36 table_constraint_def: FOREIGN KEY LPAREN column_commalist RPAREN REFERENCES table LPAREN column_commalist . RPAREN 39 column_commalist: column_commalist . COMMA column RPAREN shift, and go to state 448 COMMA shift, and go to state 197 state 448 36 table_constraint_def: FOREIGN KEY LPAREN column_commalist RPAREN REFERENCES table LPAREN column_commalist RPAREN . $default reduce using rule 36 (table_constraint_def)