state 0 $accept : _query $end ABORT_TRANS shift 68 ADD_ATTR shift 51 APPEND shift 81 ATTACH_AS shift 24 BEGIN_TRANS shift 69 CLOSE shift 52 CLUSTER shift 53 COPY shift 54 CREATE shift 55 DEFINE shift 56 DELETE shift 82 DESTROY shift 57 END_TRANS shift 70 EXECUTE shift 79 FETCH shift 58 MERGE shift 59 MOVE shift 60 PURGE shift 61 REMOVE shift 62 RENAME shift 36 REPLACE shift 80 RETRIEVE shift 78 BEFORE shift 91 PNULL shift 85 SCONST shift 84 SORT shift 90 IDENT shift 86 ICONST shift 83 Op shift 49 CCONST shift 74 FCONST shift 73 ( shift 50 . error query goto 1 stmt goto 2 experiment goto 3 a_expr goto 22 AttributeAddStmt goto 4 Attachas goto 5 ClosePortalStmt goto 6 ClusterStmt goto 7 CopyStmt goto 8 CreateStmt goto 9 DefineStmt goto 10 DestroyStmt goto 11 FetchStmt goto 12 IndexStmt goto 13 MergeStmt goto 14 MoveStmt goto 15 PurgeStmt goto 16 RemoveStmt goto 17 RenameStmt goto 18 OptimizableStmt goto 19 RuleStmt goto 20 TransactionStmt goto 21 Addattr goto 23 relation_name goto 71 Close goto 25 Cluster goto 26 Copy goto 27 Sconst goto 75 Id goto 77 Create goto 28 Define goto 29 AexprConst goto 46 Destroy goto 30 Fetch goto 31 Merge goto 32 Move goto 33 Purge goto 34 Remove goto 35 Iconst goto 72 Abort goto 42 Begin goto 43 End goto 44 RetrieveStmt goto 37 ExecuteStmt goto 38 ReplaceStmt goto 39 AppendStmt goto 40 DeleteStmt goto 41 Append goto 66 Delete goto 67 Execute goto 64 Replace goto 65 Retrieve goto 63 Sort goto 88 attr goto 45 adt_name goto 47 spec goto 48 Pnull goto 76 Keyword goto 87 Before goto 89 state 1 $accept : query_$end $end accept . error state 2 query : stmt_ (1) . reduce 1 state 3 query : experiment_ (2) . reduce 2 state 4 stmt : AttributeAddStmt_ (4) . reduce 4 state 5 stmt : Attachas_attach_args SCONST shift 84 . error attach_args goto 92 Sconst goto 93 state 6 stmt : ClosePortalStmt_ (6) . reduce 6 state 7 stmt : ClusterStmt_ (7) . reduce 7 state 8 stmt : CopyStmt_ (8) . reduce 8 state 9 stmt : CreateStmt_ (9) . reduce 9 state 10 stmt : DefineStmt_ (10) . reduce 10 state 11 stmt : DestroyStmt_ (11) . reduce 11 state 12 stmt : FetchStmt_ (12) . reduce 12 state 13 stmt : IndexStmt_ (13) . reduce 13 state 14 stmt : MergeStmt_ (14) . reduce 14 state 15 stmt : MoveStmt_ (15) . reduce 15 state 16 stmt : PurgeStmt_ (16) . reduce 16 state 17 stmt : RemoveStmt_ (17) . reduce 17 state 18 stmt : RenameStmt_ (18) . reduce 18 state 19 stmt : OptimizableStmt_ (19) . reduce 19 state 20 stmt : RuleStmt_ (20) . reduce 20 state 21 stmt : TransactionStmt_ (21) . reduce 21 state 22 experiment : a_expr_ (3) a_expr : a_expr_Op a_expr a_expr : a_expr_Op Op shift 94 . reduce 3 state 23 AttributeAddStmt : Addattr_( dom_list ) To relation_name ( shift 95 . error state 24 Attachas : ATTACH_AS_ (268) . reduce 268 state 25 ClosePortalStmt : Close_opt_id opt_id : _ (222) BEFORE shift 91 SORT shift 90 IDENT shift 86 . reduce 222 opt_id goto 96 Id goto 97 Sort goto 88 Keyword goto 87 Before goto 89 state 26 ClusterStmt : Cluster_Relation On index_name OptUseOp BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 99 Relation goto 98 Id goto 100 Sort goto 88 Keyword goto 87 Before goto 89 state 27 CopyStmt : Copy_copy_type copy_null relation_name ( copy_list ) copy_dirn file_name copy_map copy_type : _ (32) BINARY shift 103 . reduce 32 copy_type goto 101 Binary goto 102 state 28 CreateStmt : Create_relation_name ( dom_list ) OptKeyPhrase OptInherit OptIndexable OptArchiveType CreateStmt : Create_Version relation_name FROM Relation BEFORE shift 91 NEWVERSION shift 106 SORT shift 90 IDENT shift 86 . error relation_name goto 104 Id goto 100 Version goto 105 Sort goto 88 Keyword goto 87 Before goto 89 state 29 DefineStmt : Define_def_type def_name definition opt_def_args RuleStmt : Define_Rule name opt_priority Is rule_tag OptimizableStmt IndexStmt : Define_opt_archive Index index_name On relation_name Using access_method ( index_list ) with_clause opt_archive : _ (153) ARCHIVE shift 118 RULE shift 113 FUNCTION shift 115 OPERATOR shift 116 P_TYPE shift 117 . reduce 153 Archive goto 114 def_type goto 107 Function goto 110 Operator goto 111 Type goto 112 Rule goto 108 opt_archive goto 109 state 30 DestroyStmt : Destroy_relation_name_list BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 122 name_list goto 120 relation_name_list goto 119 name goto 121 Sort goto 88 Keyword goto 87 Before goto 89 state 31 FetchStmt : Fetch_OptFetchDirn OptFetchNum OptFetchPname OptFetchDirn : _ (79) BACKWARD shift 126 FORWARD shift 127 . reduce 79 OptFetchDirn goto 123 Backward goto 124 Forward goto 125 state 32 MergeStmt : Merge_Relation Into relation_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 99 Relation goto 128 Id goto 100 Sort goto 88 Keyword goto 87 Before goto 89 state 33 MoveStmt : Move_opt_move_dirn opt_move_where opt_move_pname opt_move_dirn : _ (89) BACKWARD shift 126 FORWARD shift 127 . reduce 89 Backward goto 131 Forward goto 130 opt_move_dirn goto 129 state 34 PurgeStmt : Purge_relation_name purge_quals BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 132 Id goto 100 Sort goto 88 Keyword goto 87 Before goto 89 state 35 RemoveStmt : Remove_remove_type name INDEX shift 139 RULE shift 113 FUNCTION shift 115 OPERATOR shift 116 P_TYPE shift 117 . error Function goto 134 Operator goto 136 Type goto 137 remove_type goto 133 Rule goto 135 Index goto 138 state 36 RenameStmt : RENAME_att_name In relation_name To att_name RenameStmt : RENAME_relation_name To relation_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 141 Id goto 142 att_name goto 140 Sort goto 88 Keyword goto 87 Before goto 89 state 37 OptimizableStmt : RetrieveStmt_ (127) . reduce 127 state 38 OptimizableStmt : ExecuteStmt_ (128) . reduce 128 state 39 OptimizableStmt : ReplaceStmt_ (129) . reduce 129 state 40 OptimizableStmt : AppendStmt_ (130) . reduce 130 state 41 OptimizableStmt : DeleteStmt_ (131) . reduce 131 state 42 TransactionStmt : Abort_Transaction TransactionStmt : Abort_ (123) TRANSACTION shift 144 . reduce 123 Transaction goto 143 state 43 TransactionStmt : Begin_Transaction TransactionStmt : Begin_ (124) TRANSACTION shift 144 . reduce 124 Transaction goto 145 state 44 TransactionStmt : End_Transaction TransactionStmt : End_ (125) TRANSACTION shift 144 . reduce 125 Transaction goto 146 state 45 a_expr : attr_ (202) . reduce 202 state 46 a_expr : AexprConst_ (203) . reduce 203 state 47 a_expr : adt_name_[ adt_const ] spec : adt_name_[ $ spec_tail ] [ shift 147 . error state 48 a_expr : spec_ (205) . reduce 205 state 49 a_expr : Op_a_expr BEFORE shift 91 PNULL shift 85 SCONST shift 84 SORT shift 90 IDENT shift 86 ICONST shift 83 Op shift 49 CCONST shift 74 FCONST shift 73 ( shift 50 . error a_expr goto 148 relation_name goto 71 Sconst goto 75 Id goto 77 AexprConst goto 46 Iconst goto 72 Sort goto 88 attr goto 45 adt_name goto 47 spec goto 48 Pnull goto 76 Keyword goto 87 Before goto 89 state 50 a_expr : (_a_expr ) BEFORE shift 91 PNULL shift 85 SCONST shift 84 SORT shift 90 IDENT shift 86 ICONST shift 83 Op shift 49 CCONST shift 74 FCONST shift 73 ( shift 50 . error a_expr goto 149 relation_name goto 71 Sconst goto 75 Id goto 77 AexprConst goto 46 Iconst goto 72 Sort goto 88 attr goto 45 adt_name goto 47 spec goto 48 Pnull goto 76 Keyword goto 87 Before goto 89 state 51 Addattr : ADD_ATTR_ (259) . reduce 259 state 52 Close : CLOSE_ (274) . reduce 274 state 53 Cluster : CLUSTER_ (275) . reduce 275 state 54 Copy : COPY_ (276) . reduce 276 state 55 Create : CREATE_ (277) . reduce 277 state 56 Define : DEFINE_ (278) . reduce 278 state 57 Destroy : DESTROY_ (282) . reduce 282 state 58 Fetch : FETCH_ (286) . reduce 286 state 59 Merge : MERGE_ (302) . reduce 302 state 60 Move : MOVE_ (303) . reduce 303 state 61 Purge : PURGE_ (315) . reduce 315 state 62 Remove : REMOVE_ (317) . reduce 317 state 63 RetrieveStmt : Retrieve_$$142 from_clause opt_star result opt_unique ( res_target_list ) where_clause ret_opt2 $$142 : _ (142) . reduce 142 $$142 goto 150 state 64 ExecuteStmt : Execute_opt_star opt_portal ( res_target_list ) from_clause with_clause where_clause opt_star : _ (162) Op shift 152 . reduce 162 opt_star goto 151 state 65 ReplaceStmt : Replace_$$137 from_clause opt_star opt_rep_duration var_name ( res_target_list ) where_clause $$137 : _ (137) . reduce 137 $$137 goto 153 state 66 AppendStmt : Append_$$132 from_clause opt_star relation_name ( res_target_list ) where_clause $$132 : _ (132) . reduce 132 $$132 goto 154 state 67 DeleteStmt : Delete_$$134 from_clause opt_star var_name where_clause $$134 : _ (134) . reduce 134 $$134 goto 155 state 68 Abort : ABORT_TRANS_ (258) . reduce 258 state 69 Begin : BEGIN_TRANS_ (271) . reduce 271 state 70 End : END_TRANS_ (284) . reduce 284 state 71 attr : relation_name_. att_name . shift 156 . error state 72 AexprConst : Iconst_ (245) . reduce 245 state 73 AexprConst : FCONST_ (246) . reduce 246 state 74 AexprConst : CCONST_ (247) . reduce 247 state 75 AexprConst : Sconst_ (248) . reduce 248 state 76 AexprConst : Pnull_ (249) . reduce 249 state 77 relation_name : Id_ (224) adt_name : Id_ (226) . reduce 224 . reduce 226 state 78 Retrieve : RETRIEVE_ (320) . reduce 320 state 79 Execute : EXECUTE_ (285) . reduce 285 state 80 Replace : REPLACE_ (319) . reduce 319 state 81 Append : APPEND_ (264) . reduce 264 state 82 Delete : DELETE_ (279) . reduce 279 state 83 Iconst : ICONST_ (252) . reduce 252 state 84 Sconst : SCONST_ (253) . reduce 253 state 85 Pnull : PNULL_ (333) . reduce 333 state 86 Id : IDENT_ (254) . reduce 254 state 87 Id : Keyword_ (255) . reduce 255 state 88 Keyword : Sort_ (256) . reduce 256 state 89 Keyword : Before_ (257) . reduce 257 state 90 Sort : SORT_ (323) . reduce 323 state 91 Before : BEFORE_ (270) . reduce 270 state 92 stmt : Attachas attach_args_ (5) . reduce 5 state 93 attach_args : Sconst_ (241) . reduce 241 94: shift/reduce conflict (shift 90, red'n 207) on SORT 94: shift/reduce conflict (shift 49, red'n 207) on Op state 94 a_expr : a_expr Op_a_expr a_expr : a_expr Op_ (207) BEFORE shift 91 PNULL shift 85 SCONST shift 84 SORT shift 90 IDENT shift 86 ICONST shift 83 Op shift 49 CCONST shift 74 FCONST shift 73 ( shift 50 . reduce 207 a_expr goto 157 relation_name goto 71 Sconst goto 75 Id goto 77 AexprConst goto 46 Iconst goto 72 Sort goto 88 attr goto 45 adt_name goto 47 spec goto 48 Pnull goto 76 Keyword goto 87 Before goto 89 state 95 AttributeAddStmt : Addattr (_dom_list ) To relation_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error dom_list goto 158 Id goto 161 dom_name goto 160 Sort goto 88 dom goto 159 Keyword goto 87 Before goto 89 state 96 ClosePortalStmt : Close opt_id_ (23) . reduce 23 state 97 opt_id : Id_ (223) . reduce 223 state 98 ClusterStmt : Cluster Relation_On index_name OptUseOp ON shift 163 . error On goto 162 99: shift/reduce conflict (shift 166, red'n 188) on Op state 99 Relation : relation_name_ (188) Relation : relation_name_star Relation : relation_name_[ date_string ] Relation : relation_name_[ date , date ] Relation : relation_name_star [ date , date ] Op shift 166 [ shift 165 . reduce 188 star goto 164 state 100 relation_name : Id_ (224) . reduce 224 state 101 CopyStmt : Copy copy_type_copy_null relation_name ( copy_list ) copy_dirn file_name copy_map copy_null : _ (30) NONULLS shift 169 . reduce 30 copy_null goto 167 Nonulls goto 168 state 102 copy_type : Binary_ (33) . reduce 33 state 103 Binary : BINARY_ (272) . reduce 272 state 104 CreateStmt : Create relation_name_( dom_list ) OptKeyPhrase OptInherit OptIndexable OptArchiveType ( shift 170 . error state 105 CreateStmt : Create Version_relation_name FROM Relation BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 171 Id goto 100 Sort goto 88 Keyword goto 87 Before goto 89 state 106 Version : NEWVERSION_ (330) . reduce 330 state 107 DefineStmt : Define def_type_def_name definition opt_def_args BEFORE shift 91 SORT shift 90 IDENT shift 86 Op shift 174 . error Id goto 173 def_name goto 172 Sort goto 88 Keyword goto 87 Before goto 89 state 108 RuleStmt : Define Rule_name opt_priority Is rule_tag OptimizableStmt BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 122 name goto 175 Sort goto 88 Keyword goto 87 Before goto 89 state 109 IndexStmt : Define opt_archive_Index index_name On relation_name Using access_method ( index_list ) with_clause INDEX shift 139 . error Index goto 176 state 110 def_type : Function_ (61) . reduce 61 state 111 def_type : Operator_ (62) . reduce 62 state 112 def_type : Type_ (63) . reduce 63 state 113 Rule : RULE_ (322) . reduce 322 state 114 opt_archive : Archive_ (154) . reduce 154 state 115 Function : FUNCTION_ (289) . reduce 289 state 116 Operator : OPERATOR_ (310) . reduce 310 state 117 Type : P_TYPE_ (325) . reduce 325 state 118 Archive : ARCHIVE_ (265) . reduce 265 state 119 DestroyStmt : Destroy relation_name_list_ (77) . reduce 77 state 120 relation_name_list : name_list_ (164) name_list : name_list_, name , shift 177 . reduce 164 state 121 name_list : name_ (165) . reduce 165 state 122 name : Id_ (235) . reduce 235 state 123 FetchStmt : Fetch OptFetchDirn_OptFetchNum OptFetchPname OptFetchNum : _ (82) ALL shift 183 ICONST shift 83 FCONST shift 182 . reduce 82 OptFetchNum goto 178 NumConst goto 179 All goto 180 Iconst goto 181 state 124 OptFetchDirn : Backward_ (80) . reduce 80 state 125 OptFetchDirn : Forward_ (81) . reduce 81 state 126 Backward : BACKWARD_ (269) . reduce 269 state 127 Forward : FORWARD_ (287) . reduce 287 state 128 MergeStmt : Merge Relation_Into relation_name INTO shift 185 . error Into goto 184 state 129 MoveStmt : Move opt_move_dirn_opt_move_where opt_move_pname opt_move_where : _ (92) TO shift 189 ICONST shift 83 FCONST shift 182 . reduce 92 To goto 188 NumConst goto 187 opt_move_where goto 186 Iconst goto 181 state 130 opt_move_dirn : Forward_ (90) . reduce 90 state 131 opt_move_dirn : Backward_ (91) . reduce 91 state 132 PurgeStmt : Purge relation_name_purge_quals purge_quals : _ (99) AFTER shift 194 BEFORE shift 193 . reduce 99 purge_quals goto 190 before_clause goto 191 after_clause goto 192 state 133 RemoveStmt : Remove remove_type_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 122 name goto 195 Sort goto 88 Keyword goto 87 Before goto 89 state 134 remove_type : Function_ (107) . reduce 107 state 135 remove_type : Rule_ (108) . reduce 108 state 136 remove_type : Operator_ (109) . reduce 109 state 137 remove_type : Type_ (110) . reduce 110 state 138 remove_type : Index_ (111) . reduce 111 state 139 Index : INDEX_ (292) . reduce 292 state 140 RenameStmt : RENAME att_name_In relation_name To att_name IN shift 197 . error In goto 196 state 141 RenameStmt : RENAME relation_name_To relation_name TO shift 189 . error To goto 198 state 142 relation_name : Id_ (224) att_name : Id_ (227) TO reduce 224 . reduce 227 state 143 TransactionStmt : Abort Transaction_ (120) . reduce 120 state 144 Transaction : TRANSACTION_ (326) . reduce 326 state 145 TransactionStmt : Begin Transaction_ (121) . reduce 121 state 146 TransactionStmt : End Transaction_ (122) . reduce 122 state 147 a_expr : adt_name [_adt_const ] spec : adt_name [_$ spec_tail ] SCONST shift 84 $ shift 200 . error Sconst goto 201 adt_const goto 199 148: shift/reduce conflict (shift 94, red'n 208) on Op state 148 a_expr : a_expr_Op a_expr a_expr : a_expr_Op a_expr : Op a_expr_ (208) Op shift 94 . reduce 208 state 149 a_expr : a_expr_Op a_expr a_expr : a_expr_Op a_expr : ( a_expr_) Op shift 94 ) shift 202 . error state 150 RetrieveStmt : Retrieve $$142_from_clause opt_star result opt_unique ( res_target_list ) where_clause ret_opt2 from_clause : _ (173) FROM shift 205 . reduce 173 From goto 204 from_clause goto 203 state 151 ExecuteStmt : Execute opt_star_opt_portal ( res_target_list ) from_clause with_clause where_clause opt_portal : _ (181) PORTAL shift 208 . reduce 181 opt_portal goto 206 Portal goto 207 state 152 opt_star : Op_ (163) . reduce 163 state 153 ReplaceStmt : Replace $$137_from_clause opt_star opt_rep_duration var_name ( res_target_list ) where_clause from_clause : _ (173) FROM shift 205 . reduce 173 From goto 204 from_clause goto 209 state 154 AppendStmt : Append $$132_from_clause opt_star relation_name ( res_target_list ) where_clause from_clause : _ (173) FROM shift 205 . reduce 173 From goto 204 from_clause goto 210 state 155 DeleteStmt : Delete $$134_from_clause opt_star var_name where_clause from_clause : _ (173) FROM shift 205 . reduce 173 From goto 204 from_clause goto 211 state 156 attr : relation_name ._att_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 213 att_name goto 212 Sort goto 88 Keyword goto 87 Before goto 89 157: shift/reduce conflict (shift 94, red'n 206) on Op state 157 a_expr : a_expr_Op a_expr a_expr : a_expr Op a_expr_ (206) a_expr : a_expr_Op Op shift 94 . reduce 206 state 158 AttributeAddStmt : Addattr ( dom_list_) To relation_name dom_list : dom_list_, dom ) shift 214 , shift 215 . error state 159 dom_list : dom_ (199) . reduce 199 state 160 dom : dom_name_equals adt Op shift 217 . error equals goto 216 state 161 dom_name : Id_ (230) . reduce 230 state 162 ClusterStmt : Cluster Relation On_index_name OptUseOp BEFORE shift 91 SORT shift 90 IDENT shift 86 . error index_name goto 218 Id goto 219 Sort goto 88 Keyword goto 87 Before goto 89 state 163 On : ON_ (308) . reduce 308 state 164 Relation : relation_name star_ (189) Relation : relation_name star_[ date , date ] [ shift 220 . reduce 189 state 165 Relation : relation_name [_date_string ] Relation : relation_name [_date , date ] date : _ (214) SCONST shift 84 . reduce 214 Sconst goto 223 date goto 222 date_string goto 221 state 166 star : Op_ (161) . reduce 161 state 167 CopyStmt : Copy copy_type copy_null_relation_name ( copy_list ) copy_dirn file_name copy_map BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 224 Id goto 100 Sort goto 88 Keyword goto 87 Before goto 89 state 168 copy_null : Nonulls_ (31) . reduce 31 state 169 Nonulls : NONULLS_ (306) . reduce 306 state 170 CreateStmt : Create relation_name (_dom_list ) OptKeyPhrase OptInherit OptIndexable OptArchiveType BEFORE shift 91 SORT shift 90 IDENT shift 86 . error dom_list goto 225 Id goto 161 dom_name goto 160 Sort goto 88 dom goto 159 Keyword goto 87 Before goto 89 state 171 CreateStmt : Create Version relation_name_FROM Relation FROM shift 226 . error state 172 DefineStmt : Define def_type def_name_definition opt_def_args ( shift 228 . error definition goto 227 state 173 def_name : Id_ (64) . reduce 64 state 174 def_name : Op_ (65) . reduce 65 state 175 RuleStmt : Define Rule name_opt_priority Is rule_tag OptimizableStmt opt_priority : _ (118) PRIORITY shift 230 . reduce 118 opt_priority goto 229 state 176 IndexStmt : Define opt_archive Index_index_name On relation_name Using access_method ( index_list ) with_clause BEFORE shift 91 SORT shift 90 IDENT shift 86 . error index_name goto 231 Id goto 219 Sort goto 88 Keyword goto 87 Before goto 89 state 177 name_list : name_list ,_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 122 name goto 232 Sort goto 88 Keyword goto 87 Before goto 89 state 178 FetchStmt : Fetch OptFetchDirn OptFetchNum_OptFetchPname OptFetchPname : _ (85) IN shift 197 . reduce 85 OptFetchPname goto 233 In goto 234 state 179 OptFetchNum : NumConst_ (83) . reduce 83 state 180 OptFetchNum : All_ (84) . reduce 84 state 181 NumConst : Iconst_ (250) . reduce 250 state 182 NumConst : FCONST_ (251) . reduce 251 state 183 All : ALL_ (261) . reduce 261 state 184 MergeStmt : Merge Relation Into_relation_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 235 Id goto 100 Sort goto 88 Keyword goto 87 Before goto 89 state 185 Into : INTO_ (297) . reduce 297 state 186 MoveStmt : Move opt_move_dirn opt_move_where_opt_move_pname opt_move_pname : _ (96) IN shift 197 . reduce 96 In goto 237 opt_move_pname goto 236 state 187 opt_move_where : NumConst_ (93) . reduce 93 state 188 opt_move_where : To_NumConst opt_move_where : To_record_qual record_qual : _ (197) ICONST shift 83 FCONST shift 182 . reduce 197 NumConst goto 238 record_qual goto 239 Iconst goto 181 state 189 To : TO_ (324) . reduce 324 state 190 PurgeStmt : Purge relation_name purge_quals_ (98) . reduce 98 state 191 purge_quals : before_clause_ (100) purge_quals : before_clause_after_clause AFTER shift 194 . reduce 100 after_clause goto 240 state 192 purge_quals : after_clause_ (101) purge_quals : after_clause_before_clause BEFORE shift 193 . reduce 101 before_clause goto 241 state 193 before_clause : BEFORE_date date : _ (214) SCONST shift 84 . reduce 214 Sconst goto 223 date goto 242 date_string goto 243 state 194 after_clause : AFTER_date date : _ (214) SCONST shift 84 . reduce 214 Sconst goto 223 date goto 244 date_string goto 243 state 195 RemoveStmt : Remove remove_type name_ (106) . reduce 106 state 196 RenameStmt : RENAME att_name In_relation_name To att_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 245 Id goto 100 Sort goto 88 Keyword goto 87 Before goto 89 state 197 In : IN_ (291) . reduce 291 state 198 RenameStmt : RENAME relation_name To_relation_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 246 Id goto 100 Sort goto 88 Keyword goto 87 Before goto 89 state 199 a_expr : adt_name [ adt_const_] ] shift 247 . error state 200 spec : adt_name [ $_spec_tail ] ICONST shift 83 . shift 250 . error Iconst goto 249 spec_tail goto 248 state 201 adt_const : Sconst_ (240) . reduce 240 state 202 a_expr : ( a_expr )_ (209) . reduce 209 state 203 RetrieveStmt : Retrieve $$142 from_clause_opt_star result opt_unique ( res_target_list ) where_clause ret_opt2 opt_star : _ (162) Op shift 152 . reduce 162 opt_star goto 251 state 204 from_clause : From_from_list BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 256 var_name goto 255 Sort goto 88 from_list goto 252 from_val goto 253 var_list goto 254 Keyword goto 87 Before goto 89 state 205 From : FROM_ (288) . reduce 288 state 206 ExecuteStmt : Execute opt_star opt_portal_( res_target_list ) from_clause with_clause where_clause ( shift 257 . error state 207 opt_portal : Portal_portal_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 259 portal_name goto 258 Sort goto 88 Keyword goto 87 Before goto 89 state 208 Portal : PORTAL_ (313) . reduce 313 state 209 ReplaceStmt : Replace $$137 from_clause_opt_star opt_rep_duration var_name ( res_target_list ) where_clause opt_star : _ (162) Op shift 152 . reduce 162 opt_star goto 260 state 210 AppendStmt : Append $$132 from_clause_opt_star relation_name ( res_target_list ) where_clause opt_star : _ (162) Op shift 152 . reduce 162 opt_star goto 261 state 211 DeleteStmt : Delete $$134 from_clause_opt_star var_name where_clause opt_star : _ (162) Op shift 152 . reduce 162 opt_star goto 262 state 212 attr : relation_name . att_name_ (215) . reduce 215 state 213 att_name : Id_ (227) . reduce 227 state 214 AttributeAddStmt : Addattr ( dom_list )_To relation_name TO shift 189 . error To goto 263 state 215 dom_list : dom_list ,_dom BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 161 dom_name goto 160 Sort goto 88 dom goto 264 Keyword goto 87 Before goto 89 state 216 dom : dom_name equals_adt BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 266 Sort goto 88 adt goto 265 Keyword goto 87 Before goto 89 state 217 equals : Op_ (210) . reduce 210 state 218 ClusterStmt : Cluster Relation On index_name_OptUseOp OptUseOp : _ (183) USING shift 269 . reduce 183 OptUseOp goto 267 Using goto 268 state 219 index_name : Id_ (231) . reduce 231 state 220 Relation : relation_name star [_date , date ] date : _ (214) SCONST shift 84 . reduce 214 Sconst goto 223 date goto 270 date_string goto 243 state 221 Relation : relation_name [ date_string_] date : date_string_ (213) ] shift 271 . reduce 213 state 222 Relation : relation_name [ date_, date ] , shift 272 . error state 223 date_string : Sconst_ (238) . reduce 238 state 224 CopyStmt : Copy copy_type copy_null relation_name_( copy_list ) copy_dirn file_name copy_map ( shift 273 . error state 225 CreateStmt : Create relation_name ( dom_list_) OptKeyPhrase OptInherit OptIndexable OptArchiveType dom_list : dom_list_, dom ) shift 274 , shift 215 . error state 226 CreateStmt : Create Version relation_name FROM_Relation BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 99 Relation goto 275 Id goto 100 Sort goto 88 Keyword goto 87 Before goto 89 state 227 DefineStmt : Define def_type def_name definition_opt_def_args opt_def_args : _ (67) ARG shift 278 . reduce 67 opt_def_args goto 276 Arg goto 277 state 228 definition : (_def_list ) BEFORE shift 91 SORT shift 90 IDENT shift 86 Op shift 174 . error Id goto 173 def_name goto 281 def_list goto 279 def_elem goto 280 Sort goto 88 Keyword goto 87 Before goto 89 state 229 RuleStmt : Define Rule name opt_priority_Is rule_tag OptimizableStmt IS shift 283 . error Is goto 282 state 230 opt_priority : PRIORITY_Iconst ICONST shift 83 . error Iconst goto 284 state 231 IndexStmt : Define opt_archive Index index_name_On relation_name Using access_method ( index_list ) with_clause ON shift 163 . error On goto 285 state 232 name_list : name_list , name_ (166) . reduce 166 state 233 FetchStmt : Fetch OptFetchDirn OptFetchNum OptFetchPname_ (78) . reduce 78 state 234 OptFetchPname : In_portal_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 259 portal_name goto 286 Sort goto 88 Keyword goto 87 Before goto 89 state 235 MergeStmt : Merge Relation Into relation_name_ (87) . reduce 87 state 236 MoveStmt : Move opt_move_dirn opt_move_where opt_move_pname_ (88) . reduce 88 state 237 opt_move_pname : In_portal_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 259 portal_name goto 287 Sort goto 88 Keyword goto 87 Before goto 89 state 238 opt_move_where : To NumConst_ (94) . reduce 94 state 239 opt_move_where : To record_qual_ (95) . reduce 95 state 240 purge_quals : before_clause after_clause_ (102) . reduce 102 state 241 purge_quals : after_clause before_clause_ (103) . reduce 103 state 242 before_clause : BEFORE date_ (104) . reduce 104 state 243 date : date_string_ (213) . reduce 213 state 244 after_clause : AFTER date_ (105) . reduce 105 state 245 RenameStmt : RENAME att_name In relation_name_To att_name TO shift 189 . error To goto 288 state 246 RenameStmt : RENAME relation_name To relation_name_ (113) . reduce 113 state 247 a_expr : adt_name [ adt_const ]_ (204) . reduce 204 state 248 spec : adt_name [ $ spec_tail_] ] shift 289 . error state 249 spec_tail : Iconst_ (243) . reduce 243 state 250 spec_tail : ._Id BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 290 Sort goto 88 Keyword goto 87 Before goto 89 state 251 RetrieveStmt : Retrieve $$142 from_clause opt_star_result opt_unique ( res_target_list ) where_clause ret_opt2 opt_portal : _ (181) INTO shift 185 PORTAL shift 208 . reduce 181 Into goto 292 opt_portal goto 293 result goto 291 Portal goto 207 state 252 from_clause : From from_list_ (172) from_list : from_list_, from_val , shift 294 . reduce 172 state 253 from_list : from_val_ (175) . reduce 175 state 254 from_val : var_list_In from_rel_name var_list : var_list_, var_name IN shift 197 , shift 296 . error In goto 295 state 255 var_list : var_name_ (178) . reduce 178 state 256 var_name : Id_ (234) . reduce 234 state 257 ExecuteStmt : Execute opt_star opt_portal (_res_target_list ) from_clause with_clause where_clause BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 299 Id goto 300 res_target_list goto 297 Sort goto 88 attr goto 301 res_target_el goto 298 Keyword goto 87 Before goto 89 state 258 opt_portal : Portal portal_name_ (182) . reduce 182 state 259 portal_name : Id_ (233) . reduce 233 state 260 ReplaceStmt : Replace $$137 from_clause opt_star_opt_rep_duration var_name ( res_target_list ) where_clause opt_rep_duration : _ (139) ALWAYS shift 306 DEMAND shift 305 . reduce 139 Always goto 304 opt_rep_duration goto 302 Demand goto 303 state 261 AppendStmt : Append $$132 from_clause opt_star_relation_name ( res_target_list ) where_clause BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 307 Id goto 100 Sort goto 88 Keyword goto 87 Before goto 89 state 262 DeleteStmt : Delete $$134 from_clause opt_star_var_name where_clause BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 256 var_name goto 308 Sort goto 88 Keyword goto 87 Before goto 89 state 263 AttributeAddStmt : Addattr ( dom_list ) To_relation_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 309 Id goto 100 Sort goto 88 Keyword goto 87 Before goto 89 state 264 dom_list : dom_list , dom_ (198) . reduce 198 state 265 dom : dom_name equals adt_ (200) . reduce 200 state 266 adt : Id_ (237) . reduce 237 state 267 ClusterStmt : Cluster Relation On index_name OptUseOp_ (24) . reduce 24 state 268 OptUseOp : Using_Op OptUseOp : Using_Id BEFORE shift 91 SORT shift 90 IDENT shift 86 Op shift 310 . error Id goto 311 Sort goto 88 Keyword goto 87 Before goto 89 state 269 Using : USING_ (329) . reduce 329 state 270 Relation : relation_name star [ date_, date ] , shift 312 . error state 271 Relation : relation_name [ date_string ]_ (190) . reduce 190 state 272 Relation : relation_name [ date ,_date ] date : _ (214) SCONST shift 84 . reduce 214 Sconst goto 223 date goto 313 date_string goto 243 state 273 CopyStmt : Copy copy_type copy_null relation_name (_copy_list ) copy_dirn file_name copy_map copy_list : _ (34) BEFORE shift 91 SCONST shift 84 SORT shift 90 IDENT shift 86 . reduce 34 copy_list goto 314 copy_spec goto 315 col_name goto 316 Sconst goto 317 Id goto 318 Sort goto 88 Keyword goto 87 Before goto 89 state 274 CreateStmt : Create relation_name ( dom_list )_OptKeyPhrase OptInherit OptIndexable OptArchiveType OptKeyPhrase : _ (55) KEY shift 321 . reduce 55 OptKeyPhrase goto 319 Key goto 320 state 275 CreateStmt : Create Version relation_name FROM Relation_ (44) . reduce 44 state 276 DefineStmt : Define def_type def_name definition opt_def_args_ (60) . reduce 60 state 277 opt_def_args : Arg_Is ( def_name_list ) IS shift 283 . error Is goto 322 state 278 Arg : ARG_ (266) . reduce 266 state 279 definition : ( def_list_) def_list : def_list_, def_elem ) shift 323 , shift 324 . error state 280 def_list : def_elem_ (75) . reduce 75 state 281 def_elem : def_name_equals def_arg def_elem : def_name_ (74) Op shift 217 . reduce 74 equals goto 325 state 282 RuleStmt : Define Rule name opt_priority Is_rule_tag OptimizableStmt ALWAYS shift 306 NEVER shift 331 ONCE shift 330 . error rule_tag goto 326 Always goto 327 Once goto 328 Never goto 329 state 283 Is : IS_ (298) . reduce 298 state 284 opt_priority : PRIORITY Iconst_ (119) . reduce 119 state 285 IndexStmt : Define opt_archive Index index_name On_relation_name Using access_method ( index_list ) with_clause BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 332 Id goto 100 Sort goto 88 Keyword goto 87 Before goto 89 state 286 OptFetchPname : In portal_name_ (86) . reduce 86 state 287 opt_move_pname : In portal_name_ (97) . reduce 97 state 288 RenameStmt : RENAME att_name In relation_name To_att_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 213 att_name goto 333 Sort goto 88 Keyword goto 87 Before goto 89 state 289 spec : adt_name [ $ spec_tail ]_ (242) . reduce 242 state 290 spec_tail : . Id_ (244) . reduce 244 state 291 RetrieveStmt : Retrieve $$142 from_clause opt_star result_opt_unique ( res_target_list ) where_clause ret_opt2 opt_unique : _ (146) UNIQUE shift 336 . reduce 146 opt_unique goto 334 Unique goto 335 state 292 result : Into_relation_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 337 Id goto 100 Sort goto 88 Keyword goto 87 Before goto 89 state 293 result : opt_portal_ (145) . reduce 145 state 294 from_list : from_list ,_from_val BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 256 var_name goto 255 Sort goto 88 from_val goto 338 var_list goto 254 Keyword goto 87 Before goto 89 state 295 from_val : var_list In_from_rel_name BEFORE shift 91 SORT shift 90 IDENT shift 86 Op shift 342 . error relation_name goto 99 Relation goto 340 Id goto 100 Sort goto 88 from_rel_name goto 339 le_op goto 341 Keyword goto 87 Before goto 89 state 296 var_list : var_list ,_var_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 256 var_name goto 343 Sort goto 88 Keyword goto 87 Before goto 89 state 297 ExecuteStmt : Execute opt_star opt_portal ( res_target_list_) from_clause with_clause where_clause res_target_list : res_target_list_, res_target_el res_target_list : res_target_list_, relation_name . All ) shift 344 , shift 345 . error state 298 res_target_list : res_target_el_ (217) . reduce 217 state 299 attr : relation_name_. att_name res_target_list : relation_name_. All . shift 346 . error state 300 res_target_el : Id_equals a_expr relation_name : Id_ (224) Op shift 217 . reduce 224 equals goto 347 state 301 res_target_el : attr_ (221) . reduce 221 state 302 ReplaceStmt : Replace $$137 from_clause opt_star opt_rep_duration_var_name ( res_target_list ) where_clause BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 256 var_name goto 348 Sort goto 88 Keyword goto 87 Before goto 89 state 303 opt_rep_duration : Demand_ (140) . reduce 140 state 304 opt_rep_duration : Always_ (141) . reduce 141 state 305 Demand : DEMAND_ (280) . reduce 280 state 306 Always : ALWAYS_ (262) . reduce 262 state 307 AppendStmt : Append $$132 from_clause opt_star relation_name_( res_target_list ) where_clause ( shift 349 . error state 308 DeleteStmt : Delete $$134 from_clause opt_star var_name_where_clause where_clause : _ (179) WHERE shift 352 . reduce 179 where_clause goto 350 Where goto 351 state 309 AttributeAddStmt : Addattr ( dom_list ) To relation_name_ (22) . reduce 22 state 310 OptUseOp : Using Op_ (184) . reduce 184 state 311 OptUseOp : Using Id_ (185) . reduce 185 state 312 Relation : relation_name star [ date ,_date ] date : _ (214) SCONST shift 84 . reduce 214 Sconst goto 223 date goto 353 date_string goto 243 state 313 Relation : relation_name [ date , date_] ] shift 354 . error state 314 CopyStmt : Copy copy_type copy_null relation_name ( copy_list_) copy_dirn file_name copy_map copy_list : copy_list_, copy_spec ) shift 355 , shift 356 . error state 315 copy_list : copy_spec_ (35) . reduce 35 state 316 copy_spec : col_name_copy_eq copy_char copy_eq : _ (39) Op shift 217 . reduce 39 copy_eq goto 357 equals goto 358 state 317 copy_spec : Sconst_ (38) . reduce 38 state 318 col_name : Id_ (229) . reduce 229 state 319 CreateStmt : Create relation_name ( dom_list ) OptKeyPhrase_OptInherit OptIndexable OptArchiveType OptInherit : _ (53) INHERITS shift 361 . reduce 53 OptInherit goto 359 Inherits goto 360 state 320 OptKeyPhrase : Key_( key_list ) ( shift 362 . error state 321 Key : KEY_ (299) . reduce 299 state 322 opt_def_args : Arg Is_( def_name_list ) ( shift 363 . error state 323 definition : ( def_list )_ (72) . reduce 72 state 324 def_list : def_list ,_def_elem BEFORE shift 91 SORT shift 90 IDENT shift 86 Op shift 174 . error Id goto 173 def_name goto 281 def_elem goto 364 Sort goto 88 Keyword goto 87 Before goto 89 state 325 def_elem : def_name equals_def_arg BEFORE shift 91 PNULL shift 85 SCONST shift 84 SORT shift 90 IDENT shift 86 ICONST shift 83 Op shift 367 CCONST shift 74 FCONST shift 73 . error Sconst goto 75 Id goto 366 def_arg goto 365 AexprConst goto 368 Iconst goto 72 Sort goto 88 Pnull goto 76 Keyword goto 87 Before goto 89 state 326 RuleStmt : Define Rule name opt_priority Is rule_tag_OptimizableStmt APPEND shift 81 DELETE shift 82 EXECUTE shift 79 REPLACE shift 80 RETRIEVE shift 78 . error OptimizableStmt goto 369 RetrieveStmt goto 37 ExecuteStmt goto 38 ReplaceStmt goto 39 AppendStmt goto 40 DeleteStmt goto 41 Append goto 66 Delete goto 67 Execute goto 64 Replace goto 65 Retrieve goto 63 state 327 rule_tag : Always_ (115) . reduce 115 state 328 rule_tag : Once_ (116) . reduce 116 state 329 rule_tag : Never_ (117) . reduce 117 state 330 Once : ONCE_ (309) . reduce 309 state 331 Never : NEVER_ (304) . reduce 304 state 332 IndexStmt : Define opt_archive Index index_name On relation_name_Using access_method ( index_list ) with_clause USING shift 269 . error Using goto 370 state 333 RenameStmt : RENAME att_name In relation_name To att_name_ (112) . reduce 112 state 334 RetrieveStmt : Retrieve $$142 from_clause opt_star result opt_unique_( res_target_list ) where_clause ret_opt2 ( shift 371 . error state 335 opt_unique : Unique_ (147) . reduce 147 state 336 Unique : UNIQUE_ (328) . reduce 328 state 337 result : Into relation_name_ (144) . reduce 144 state 338 from_list : from_list , from_val_ (174) . reduce 174 state 339 from_val : var_list In from_rel_name_ (176) . reduce 176 state 340 from_rel_name : Relation_ (186) . reduce 186 state 341 from_rel_name : le_op_Iconst gt_op ICONST shift 83 . error Iconst goto 372 state 342 le_op : Op_ (211) . reduce 211 state 343 var_list : var_list , var_name_ (177) . reduce 177 state 344 ExecuteStmt : Execute opt_star opt_portal ( res_target_list )_from_clause with_clause where_clause from_clause : _ (173) FROM shift 205 . reduce 173 From goto 204 from_clause goto 373 state 345 res_target_list : res_target_list ,_res_target_el res_target_list : res_target_list ,_relation_name . All BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 375 Id goto 300 Sort goto 88 attr goto 301 res_target_el goto 374 Keyword goto 87 Before goto 89 state 346 attr : relation_name ._att_name res_target_list : relation_name ._All ALL shift 183 BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 213 All goto 376 att_name goto 212 Sort goto 88 Keyword goto 87 Before goto 89 state 347 res_target_el : Id equals_a_expr BEFORE shift 91 PNULL shift 85 SCONST shift 84 SORT shift 90 IDENT shift 86 ICONST shift 83 Op shift 49 CCONST shift 74 FCONST shift 73 ( shift 50 . error a_expr goto 377 relation_name goto 71 Sconst goto 75 Id goto 77 AexprConst goto 46 Iconst goto 72 Sort goto 88 attr goto 45 adt_name goto 47 spec goto 48 Pnull goto 76 Keyword goto 87 Before goto 89 state 348 ReplaceStmt : Replace $$137 from_clause opt_star opt_rep_duration var_name_( res_target_list ) where_clause ( shift 378 . error state 349 AppendStmt : Append $$132 from_clause opt_star relation_name (_res_target_list ) where_clause BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 299 Id goto 300 res_target_list goto 379 Sort goto 88 attr goto 301 res_target_el goto 298 Keyword goto 87 Before goto 89 state 350 DeleteStmt : Delete $$134 from_clause opt_star var_name where_clause_ (135) . reduce 135 state 351 where_clause : Where_boolexpr BEFORE shift 91 NOT shift 384 PNULL shift 85 SCONST shift 84 SORT shift 90 IDENT shift 86 ICONST shift 83 Op shift 49 CCONST shift 74 FCONST shift 73 ( shift 50 . error a_expr goto 383 relation_name goto 71 Sconst goto 75 Id goto 77 AexprConst goto 46 Iconst goto 72 Sort goto 88 boolexpr goto 380 b_expr goto 381 Not goto 382 attr goto 45 adt_name goto 47 spec goto 48 Pnull goto 76 Keyword goto 87 Before goto 89 state 352 Where : WHERE_ (331) . reduce 331 state 353 Relation : relation_name star [ date , date_] ] shift 385 . error state 354 Relation : relation_name [ date , date ]_ (191) . reduce 191 state 355 CopyStmt : Copy copy_type copy_null relation_name ( copy_list )_copy_dirn file_name copy_map FROM shift 205 TO shift 189 . error To goto 387 copy_dirn goto 386 From goto 388 state 356 copy_list : copy_list ,_copy_spec BEFORE shift 91 SCONST shift 84 SORT shift 90 IDENT shift 86 . error copy_spec goto 389 col_name goto 316 Sconst goto 317 Id goto 318 Sort goto 88 Keyword goto 87 Before goto 89 state 357 copy_spec : col_name copy_eq_copy_char copy_char : _ (41) CCONST shift 391 . reduce 41 copy_char goto 390 state 358 copy_eq : equals_Id BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 392 Sort goto 88 Keyword goto 87 Before goto 89 state 359 CreateStmt : Create relation_name ( dom_list ) OptKeyPhrase OptInherit_OptIndexable OptArchiveType OptIndexable : _ (45) INDEXABLE shift 395 . reduce 45 OptIndexable goto 393 Indexable goto 394 state 360 OptInherit : Inherits_( relation_name_list ) ( shift 396 . error state 361 Inherits : INHERITS_ (294) . reduce 294 state 362 OptKeyPhrase : Key (_key_list ) BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 161 key_list goto 397 key goto 398 dom_name goto 399 Sort goto 88 Keyword goto 87 Before goto 89 state 363 opt_def_args : Arg Is (_def_name_list ) BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 122 name_list goto 401 def_name_list goto 400 name goto 121 Sort goto 88 Keyword goto 87 Before goto 89 state 364 def_list : def_list , def_elem_ (76) . reduce 76 state 365 def_elem : def_name equals def_arg_ (73) . reduce 73 state 366 def_arg : Id_ (69) . reduce 69 state 367 def_arg : Op_ (70) . reduce 70 state 368 def_arg : AexprConst_ (71) . reduce 71 state 369 RuleStmt : Define Rule name opt_priority Is rule_tag OptimizableStmt_ (114) . reduce 114 state 370 IndexStmt : Define opt_archive Index index_name On relation_name Using_access_method ( index_list ) with_clause BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 403 access_method goto 402 Sort goto 88 Keyword goto 87 Before goto 89 state 371 RetrieveStmt : Retrieve $$142 from_clause opt_star result opt_unique (_res_target_list ) where_clause ret_opt2 BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 299 Id goto 300 res_target_list goto 404 Sort goto 88 attr goto 301 res_target_el goto 298 Keyword goto 87 Before goto 89 state 372 from_rel_name : le_op Iconst_gt_op Op shift 406 . error gt_op goto 405 state 373 ExecuteStmt : Execute opt_star opt_portal ( res_target_list ) from_clause_with_clause where_clause with_clause : _ (167) WITH shift 409 . reduce 167 with_clause goto 407 With goto 408 state 374 res_target_list : res_target_list , res_target_el_ (216) . reduce 216 state 375 attr : relation_name_. att_name res_target_list : res_target_list , relation_name_. All . shift 410 . error state 376 res_target_list : relation_name . All_ (218) . reduce 218 state 377 a_expr : a_expr_Op a_expr a_expr : a_expr_Op res_target_el : Id equals a_expr_ (220) Op shift 94 . reduce 220 state 378 ReplaceStmt : Replace $$137 from_clause opt_star opt_rep_duration var_name (_res_target_list ) where_clause BEFORE shift 91 SORT shift 90 IDENT shift 86 . error relation_name goto 299 Id goto 300 res_target_list goto 411 Sort goto 88 attr goto 301 res_target_el goto 298 Keyword goto 87 Before goto 89 state 379 AppendStmt : Append $$132 from_clause opt_star relation_name ( res_target_list_) where_clause res_target_list : res_target_list_, res_target_el res_target_list : res_target_list_, relation_name . All ) shift 412 , shift 345 . error state 380 where_clause : Where boolexpr_ (180) . reduce 180 state 381 boolexpr : b_expr_And boolexpr boolexpr : b_expr_Or boolexpr boolexpr : b_expr_ (195) AND shift 415 OR shift 416 . reduce 195 And goto 413 Or goto 414 state 382 boolexpr : Not_b_expr BEFORE shift 91 PNULL shift 85 SCONST shift 84 SORT shift 90 IDENT shift 86 ICONST shift 83 Op shift 49 CCONST shift 74 FCONST shift 73 ( shift 50 . error a_expr goto 383 relation_name goto 71 Sconst goto 75 Id goto 77 AexprConst goto 46 Iconst goto 72 Sort goto 88 b_expr goto 417 attr goto 45 adt_name goto 47 spec goto 48 Pnull goto 76 Keyword goto 87 Before goto 89 state 383 b_expr : a_expr_ (201) a_expr : a_expr_Op a_expr a_expr : a_expr_Op Op shift 94 . reduce 201 state 384 Not : NOT_ (307) . reduce 307 state 385 Relation : relation_name star [ date , date ]_ (192) . reduce 192 state 386 CopyStmt : Copy copy_type copy_null relation_name ( copy_list ) copy_dirn_file_name copy_map SCONST shift 419 . error file_name goto 418 state 387 copy_dirn : To_ (26) . reduce 26 state 388 copy_dirn : From_ (27) . reduce 27 state 389 copy_list : copy_list , copy_spec_ (36) . reduce 36 state 390 copy_spec : col_name copy_eq copy_char_ (37) . reduce 37 state 391 copy_char : CCONST_ (42) . reduce 42 state 392 copy_eq : equals Id_ (40) . reduce 40 state 393 CreateStmt : Create relation_name ( dom_list ) OptKeyPhrase OptInherit OptIndexable_OptArchiveType OptArchiveType : _ (48) ARCHIVE shift 118 . reduce 48 OptArchiveType goto 420 Archive goto 421 state 394 OptIndexable : Indexable_dom_name_list BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 122 dom_name_list goto 422 name_list goto 423 name goto 121 Sort goto 88 Keyword goto 87 Before goto 89 state 395 Indexable : INDEXABLE_ (293) . reduce 293 state 396 OptInherit : Inherits (_relation_name_list ) BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 122 name_list goto 120 relation_name_list goto 424 name goto 121 Sort goto 88 Keyword goto 87 Before goto 89 state 397 OptKeyPhrase : Key ( key_list_) key_list : key_list_, key ) shift 425 , shift 426 . error state 398 key_list : key_ (57) . reduce 57 state 399 key : dom_name_OptUseOp OptUseOp : _ (183) USING shift 269 . reduce 183 OptUseOp goto 427 Using goto 268 state 400 opt_def_args : Arg Is ( def_name_list_) ) shift 428 . error state 401 def_name_list : name_list_ (68) name_list : name_list_, name , shift 177 . reduce 68 state 402 IndexStmt : Define opt_archive Index index_name On relation_name Using access_method_( index_list ) with_clause ( shift 429 . error state 403 access_method : Id_ (225) . reduce 225 state 404 RetrieveStmt : Retrieve $$142 from_clause opt_star result opt_unique ( res_target_list_) where_clause ret_opt2 res_target_list : res_target_list_, res_target_el res_target_list : res_target_list_, relation_name . All ) shift 430 , shift 345 . error state 405 from_rel_name : le_op Iconst gt_op_ (187) . reduce 187 state 406 gt_op : Op_ (212) . reduce 212 state 407 ExecuteStmt : Execute opt_star opt_portal ( res_target_list ) from_clause with_clause_where_clause where_clause : _ (179) WHERE shift 352 . reduce 179 where_clause goto 431 Where goto 351 state 408 with_clause : With_( param_list ) ( shift 432 . error state 409 With : WITH_ (332) . reduce 332 state 410 attr : relation_name ._att_name res_target_list : res_target_list , relation_name ._All ALL shift 183 BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 213 All goto 433 att_name goto 212 Sort goto 88 Keyword goto 87 Before goto 89 state 411 ReplaceStmt : Replace $$137 from_clause opt_star opt_rep_duration var_name ( res_target_list_) where_clause res_target_list : res_target_list_, res_target_el res_target_list : res_target_list_, relation_name . All ) shift 434 , shift 345 . error state 412 AppendStmt : Append $$132 from_clause opt_star relation_name ( res_target_list )_where_clause where_clause : _ (179) WHERE shift 352 . reduce 179 where_clause goto 435 Where goto 351 state 413 boolexpr : b_expr And_boolexpr BEFORE shift 91 NOT shift 384 PNULL shift 85 SCONST shift 84 SORT shift 90 IDENT shift 86 ICONST shift 83 Op shift 49 CCONST shift 74 FCONST shift 73 ( shift 50 . error a_expr goto 383 relation_name goto 71 Sconst goto 75 Id goto 77 AexprConst goto 46 Iconst goto 72 Sort goto 88 boolexpr goto 436 b_expr goto 381 Not goto 382 attr goto 45 adt_name goto 47 spec goto 48 Pnull goto 76 Keyword goto 87 Before goto 89 state 414 boolexpr : b_expr Or_boolexpr BEFORE shift 91 NOT shift 384 PNULL shift 85 SCONST shift 84 SORT shift 90 IDENT shift 86 ICONST shift 83 Op shift 49 CCONST shift 74 FCONST shift 73 ( shift 50 . error a_expr goto 383 relation_name goto 71 Sconst goto 75 Id goto 77 AexprConst goto 46 Iconst goto 72 Sort goto 88 boolexpr goto 437 b_expr goto 381 Not goto 382 attr goto 45 adt_name goto 47 spec goto 48 Pnull goto 76 Keyword goto 87 Before goto 89 state 415 And : AND_ (263) . reduce 263 state 416 Or : OR_ (311) . reduce 311 state 417 boolexpr : Not b_expr_ (196) . reduce 196 state 418 CopyStmt : Copy copy_type copy_null relation_name ( copy_list ) copy_dirn file_name_copy_map copy_map : _ (28) USING shift 269 . reduce 28 copy_map goto 438 Using goto 439 state 419 file_name : SCONST_ (239) . reduce 239 state 420 CreateStmt : Create relation_name ( dom_list ) OptKeyPhrase OptInherit OptIndexable OptArchiveType_ (43) . reduce 43 state 421 OptArchiveType : Archive_equals archive_type Op shift 217 . error equals goto 440 state 422 OptIndexable : Indexable dom_name_list_ (46) . reduce 46 state 423 dom_name_list : name_list_ (47) name_list : name_list_, name , shift 177 . reduce 47 state 424 OptInherit : Inherits ( relation_name_list_) ) shift 441 . error state 425 OptKeyPhrase : Key ( key_list )_ (56) . reduce 56 state 426 key_list : key_list ,_key BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 161 key goto 442 dom_name goto 399 Sort goto 88 Keyword goto 87 Before goto 89 state 427 key : dom_name OptUseOp_ (59) . reduce 59 state 428 opt_def_args : Arg Is ( def_name_list )_ (66) . reduce 66 state 429 IndexStmt : Define opt_archive Index index_name On relation_name Using access_method (_index_list ) with_clause BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 161 dom_name goto 445 index_list goto 443 Sort goto 88 index_elem goto 444 Keyword goto 87 Before goto 89 state 430 RetrieveStmt : Retrieve $$142 from_clause opt_star result opt_unique ( res_target_list )_where_clause ret_opt2 where_clause : _ (179) WHERE shift 352 . reduce 179 where_clause goto 446 Where goto 351 state 431 ExecuteStmt : Execute opt_star opt_portal ( res_target_list ) from_clause with_clause where_clause_ (136) . reduce 136 state 432 with_clause : With (_param_list ) BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 449 Sort goto 88 param_list goto 447 param goto 448 Keyword goto 87 Before goto 89 state 433 res_target_list : res_target_list , relation_name . All_ (219) . reduce 219 state 434 ReplaceStmt : Replace $$137 from_clause opt_star opt_rep_duration var_name ( res_target_list )_where_clause where_clause : _ (179) WHERE shift 352 . reduce 179 where_clause goto 450 Where goto 351 state 435 AppendStmt : Append $$132 from_clause opt_star relation_name ( res_target_list ) where_clause_ (133) . reduce 133 state 436 boolexpr : b_expr And boolexpr_ (193) . reduce 193 state 437 boolexpr : b_expr Or boolexpr_ (194) . reduce 194 state 438 CopyStmt : Copy copy_type copy_null relation_name ( copy_list ) copy_dirn file_name copy_map_ (25) . reduce 25 state 439 copy_map : Using_map_rel_name BEFORE shift 91 SORT shift 90 IDENT shift 86 . error map_rel_name goto 451 Id goto 452 Sort goto 88 Keyword goto 87 Before goto 89 state 440 OptArchiveType : Archive equals_archive_type HEAVY shift 457 LIGHT shift 458 NONE shift 459 . error archive_type goto 453 Heavy goto 454 Light goto 455 None goto 456 state 441 OptInherit : Inherits ( relation_name_list )_ (54) . reduce 54 state 442 key_list : key_list , key_ (58) . reduce 58 state 443 IndexStmt : Define opt_archive Index index_name On relation_name Using access_method ( index_list_) with_clause index_list : index_list_, index_elem ) shift 460 , shift 461 . error state 444 index_list : index_elem_ (156) . reduce 156 state 445 index_elem : dom_name_opt_class opt_class : _ (158) BEFORE shift 91 SORT shift 90 WITH shift 409 IDENT shift 86 . reduce 158 Id goto 465 Sort goto 88 opt_class goto 462 class goto 463 With goto 464 Keyword goto 87 Before goto 89 state 446 RetrieveStmt : Retrieve $$142 from_clause opt_star result opt_unique ( res_target_list ) where_clause_ret_opt2 ret_opt2 : _ (148) SORT shift 90 . reduce 148 ret_opt2 goto 466 Sort goto 467 state 447 with_clause : With ( param_list_) param_list : param_list_, param ) shift 468 , shift 469 . error state 448 param_list : param_ (170) . reduce 170 state 449 param : Id_equals string Op shift 217 . error equals goto 470 state 450 ReplaceStmt : Replace $$137 from_clause opt_star opt_rep_duration var_name ( res_target_list ) where_clause_ (138) . reduce 138 state 451 copy_map : Using map_rel_name_ (29) . reduce 29 state 452 map_rel_name : Id_ (232) . reduce 232 state 453 OptArchiveType : Archive equals archive_type_ (49) . reduce 49 state 454 archive_type : Heavy_ (50) . reduce 50 state 455 archive_type : Light_ (51) . reduce 51 state 456 archive_type : None_ (52) . reduce 52 state 457 Heavy : HEAVY_ (290) . reduce 290 state 458 Light : LIGHT_ (301) . reduce 301 state 459 None : NONE_ (305) . reduce 305 state 460 IndexStmt : Define opt_archive Index index_name On relation_name Using access_method ( index_list )_with_clause with_clause : _ (167) WITH shift 409 . reduce 167 with_clause goto 471 With goto 408 state 461 index_list : index_list ,_index_elem BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 161 dom_name goto 445 Sort goto 88 index_elem goto 472 Keyword goto 87 Before goto 89 state 462 index_elem : dom_name opt_class_ (157) . reduce 157 state 463 opt_class : class_ (159) . reduce 159 state 464 opt_class : With_class BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 465 Sort goto 88 class goto 473 Keyword goto 87 Before goto 89 state 465 class : Id_ (228) . reduce 228 state 466 RetrieveStmt : Retrieve $$142 from_clause opt_star result opt_unique ( res_target_list ) where_clause ret_opt2_ (143) . reduce 143 state 467 ret_opt2 : Sort_By sortby_list BY shift 475 . error By goto 474 state 468 with_clause : With ( param_list )_ (168) . reduce 168 state 469 param_list : param_list ,_param BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 449 Sort goto 88 param goto 476 Keyword goto 87 Before goto 89 state 470 param : Id equals_string BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 478 Sort goto 88 string goto 477 Keyword goto 87 Before goto 89 state 471 IndexStmt : Define opt_archive Index index_name On relation_name Using access_method ( index_list ) with_clause_ (126) . reduce 126 state 472 index_list : index_list , index_elem_ (155) . reduce 155 state 473 opt_class : With class_ (160) . reduce 160 state 474 ret_opt2 : Sort By_sortby_list BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 481 Sort goto 88 sortby_list goto 479 sortby goto 480 Keyword goto 87 Before goto 89 state 475 By : BY_ (273) . reduce 273 state 476 param_list : param_list , param_ (169) . reduce 169 state 477 param : Id equals string_ (171) . reduce 171 state 478 string : Id_ (236) . reduce 236 state 479 ret_opt2 : Sort By sortby_list_ (149) sortby_list : sortby_list_, sortby , shift 482 . reduce 149 state 480 sortby_list : sortby_ (150) . reduce 150 state 481 sortby : Id_OptUseOp OptUseOp : _ (183) USING shift 269 . reduce 183 OptUseOp goto 483 Using goto 268 state 482 sortby_list : sortby_list ,_sortby BEFORE shift 91 SORT shift 90 IDENT shift 86 . error Id goto 481 Sort goto 88 sortby goto 484 Keyword goto 87 Before goto 89 state 483 sortby : Id OptUseOp_ (152) . reduce 152 state 484 sortby_list : sortby_list , sortby_ (151) . reduce 151 Rule not reduced: After : AFTER Rule not reduced: Ascending : ASCENDING Rule not reduced: Descending : DESCENDING Rule not reduced: Empty : EMPTY Rule not reduced: Input_proc : INPUTPROC Rule not reduced: Intersect : INTERSECT Rule not reduced: Leftouter : LEFTOUTER Rule not reduced: Output_proc : OUTPUTPROC Rule not reduced: Priority : PRIORITY Rule not reduced: Quel : QUEL Rule not reduced: Rename : RENAME Rule not reduced: Rightouter : RIGHTOUTER Rule not reduced: Union : UNION 96/300 terminals, 207/300 nonterminals 334/600 grammar rules, 485/750 states 5 shift/reduce, 0 reduce/reduce conflicts reported 207/350 working sets used memory: states,etc. 2307/24000, parser 910/12000 259/600 distinct lookahead sets 257 extra closures 521 shift entries, 3 exceptions 417 goto entries 348 entries saved by goto default Optimizer space used: input 1671/24000, output 661/12000 661 table entries, 14 zero maximum spread: 338, maximum offset: 482