State 0: input ::= * cmdlist cmdlist ::= * ecmd cmdlist ::= * cmdlist ecmd ecmd ::= * explain cmdx SEMI ecmd ::= * SEMI explain ::= * EXPLAIN (7) explain ::= * EXPLAIN shift 553 SEMI shift 552 cmdlist shift 1 ecmd shift 554 explain shift 3 input accept {default} reduce 7 State 1: (0) input ::= cmdlist * cmdlist ::= cmdlist * ecmd ecmd ::= * explain cmdx SEMI ecmd ::= * SEMI explain ::= * EXPLAIN (7) explain ::= * $ reduce 0 EXPLAIN shift 553 SEMI shift 552 ecmd shift 2 explain shift 3 {default} reduce 7 State 2: (2) cmdlist ::= cmdlist ecmd * {default} reduce 2 State 3: ecmd ::= explain * cmdx SEMI cmdx ::= * cmd cmd ::= * BEGIN trans_opt onconf cmd ::= * COMMIT trans_opt cmd ::= * END trans_opt cmd ::= * ROLLBACK trans_opt cmd ::= * create_table create_table_args create_table ::= * CREATE temp TABLE nm cmd ::= * DROP TABLE nm cmd ::= * CREATE temp VIEW nm AS select cmd ::= * DROP VIEW nm cmd ::= * select select ::= * oneselect select ::= * select multiselect_op oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt cmd ::= * DELETE FROM nm dbnm where_opt cmd ::= * UPDATE orconf nm dbnm SET setlist where_opt cmd ::= * insert_cmd INTO nm dbnm inscollist_opt VALUES LP itemlist RP cmd ::= * insert_cmd INTO nm dbnm inscollist_opt select insert_cmd ::= * INSERT orconf insert_cmd ::= * REPLACE cmd ::= * CREATE temp uniqueflag INDEX nm ON nm dbnm LP idxlist RP onconf cmd ::= * DROP INDEX nm dbnm cmd ::= * COPY orconf nm dbnm FROM nm USING DELIMITERS STRING cmd ::= * COPY orconf nm dbnm FROM nm cmd ::= * VACUUM cmd ::= * VACUUM nm cmd ::= * PRAGMA ids EQ nm cmd ::= * PRAGMA ids EQ ON cmd ::= * PRAGMA ids EQ plus_num cmd ::= * PRAGMA ids EQ minus_num cmd ::= * PRAGMA ids LP nm RP cmd ::= * PRAGMA ids cmd ::= * CREATE trigger_decl BEGIN trigger_cmd_list END cmd ::= * DROP TRIGGER nm dbnm cmd ::= * ATTACH database_kw_opt ids AS nm cmd ::= * DETACH database_kw_opt nm ATTACH shift 543 BEGIN shift 7 COMMIT shift 23 COPY shift 515 CREATE shift 388 DELETE shift 490 DETACH shift 549 DROP shift 478 END shift 25 INSERT shift 512 PRAGMA shift 526 REPLACE shift 514 ROLLBACK shift 27 SELECT shift 73 UPDATE shift 495 VACUUM shift 524 cmd shift 6 cmdx shift 4 create_table shift 29 insert_cmd shift 502 oneselect shift 69 select shift 489 State 4: ecmd ::= explain cmdx * SEMI SEMI shift 5 State 5: (3) ecmd ::= explain cmdx SEMI * {default} reduce 3 State 6: (5) cmdx ::= cmd * SEMI reduce 5 State 7: cmd ::= BEGIN * trans_opt onconf (9) trans_opt ::= * trans_opt ::= * TRANSACTION trans_opt ::= * TRANSACTION nm TRANSACTION shift 18 trans_opt shift 8 {default} reduce 9 State 8: cmd ::= BEGIN trans_opt * onconf (88) onconf ::= * onconf ::= * ON CONFLICT resolvetype ON shift 10 SEMI reduce 88 onconf shift 9 State 9: (8) cmd ::= BEGIN trans_opt onconf * SEMI reduce 8 State 10: onconf ::= ON * CONFLICT resolvetype CONFLICT shift 11 State 11: onconf ::= ON CONFLICT * resolvetype resolvetype ::= * ROLLBACK resolvetype ::= * ABORT resolvetype ::= * FAIL resolvetype ::= * IGNORE resolvetype ::= * REPLACE ABORT shift 14 FAIL shift 15 IGNORE shift 16 REPLACE shift 17 ROLLBACK shift 13 resolvetype shift 12 State 12: (89) onconf ::= ON CONFLICT resolvetype * {default} reduce 89 State 13: (92) resolvetype ::= ROLLBACK * {default} reduce 92 State 14: (93) resolvetype ::= ABORT * {default} reduce 93 State 15: (94) resolvetype ::= FAIL * {default} reduce 94 State 16: (95) resolvetype ::= IGNORE * {default} reduce 95 State 17: (96) resolvetype ::= REPLACE * {default} reduce 96 State 18: (10) trans_opt ::= TRANSACTION * trans_opt ::= TRANSACTION * nm nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 19 {default} reduce 10 State 19: (11) trans_opt ::= TRANSACTION nm * {default} reduce 11 State 20: (28) nm ::= ID * {default} reduce 28 State 21: (29) nm ::= STRING * {default} reduce 29 State 22: (30) nm ::= JOIN_KW * {default} reduce 30 State 23: (9) trans_opt ::= * trans_opt ::= * TRANSACTION trans_opt ::= * TRANSACTION nm cmd ::= COMMIT * trans_opt SEMI reduce 9 TRANSACTION shift 18 trans_opt shift 24 State 24: (12) cmd ::= COMMIT trans_opt * SEMI reduce 12 State 25: (9) trans_opt ::= * trans_opt ::= * TRANSACTION trans_opt ::= * TRANSACTION nm cmd ::= END * trans_opt SEMI reduce 9 TRANSACTION shift 18 trans_opt shift 26 State 26: (13) cmd ::= END trans_opt * SEMI reduce 13 State 27: (9) trans_opt ::= * trans_opt ::= * TRANSACTION trans_opt ::= * TRANSACTION nm cmd ::= ROLLBACK * trans_opt SEMI reduce 9 TRANSACTION shift 18 trans_opt shift 28 State 28: (14) cmd ::= ROLLBACK trans_opt * SEMI reduce 14 State 29: cmd ::= create_table * create_table_args create_table_args ::= * LP columnlist conslist_opt RP create_table_args ::= * AS select AS shift 386 LP shift 31 create_table_args shift 30 State 30: (15) cmd ::= create_table create_table_args * SEMI reduce 15 State 31: create_table_args ::= LP * columnlist conslist_opt RP columnlist ::= * columnlist COMMA column columnlist ::= * column column ::= * columnid type carglist columnid ::= * nm nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW ID shift 20 JOIN_KW shift 22 STRING shift 21 column shift 385 columnid shift 37 columnlist shift 32 nm shift 351 State 32: create_table_args ::= LP columnlist * conslist_opt RP columnlist ::= columnlist * COMMA column (76) conslist_opt ::= * conslist_opt ::= * COMMA conslist COMMA shift 35 RP reduce 76 conslist_opt shift 33 State 33: create_table_args ::= LP columnlist conslist_opt * RP RP shift 34 State 34: (19) create_table_args ::= LP columnlist conslist_opt RP * SEMI reduce 19 State 35: columnlist ::= columnlist COMMA * column column ::= * columnid type carglist columnid ::= * nm nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW conslist_opt ::= COMMA * conslist conslist ::= * conslist COMMA tcons conslist ::= * conslist tcons conslist ::= * tcons tcons ::= * CONSTRAINT nm tcons ::= * PRIMARY KEY LP idxlist RP onconf tcons ::= * UNIQUE LP idxlist RP onconf tcons ::= * CHECK expr onconf tcons ::= * FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt CHECK shift 368 CONSTRAINT shift 355 FOREIGN shift 371 ID shift 20 JOIN_KW shift 22 PRIMARY shift 357 STRING shift 21 UNIQUE shift 363 column shift 36 columnid shift 37 conslist shift 352 nm shift 351 tcons shift 384 State 36: (21) columnlist ::= columnlist COMMA column * {default} reduce 21 State 37: column ::= columnid * type carglist ids ::= * ID ids ::= * STRING (31) type ::= * type ::= * typename type ::= * typename LP signed RP type ::= * typename LP signed COMMA signed RP typename ::= * ids typename ::= * typename ids ID shift 256 STRING shift 257 ids shift 350 type shift 38 typename shift 342 {default} reduce 31 State 38: column ::= columnid type * carglist carglist ::= * carglist carg (41) carglist ::= * carglist shift 39 {default} reduce 41 State 39: (23) column ::= columnid type carglist * carglist ::= carglist * carg carg ::= * CONSTRAINT nm ccons carg ::= * ccons carg ::= * DEFAULT STRING carg ::= * DEFAULT ID carg ::= * DEFAULT INTEGER carg ::= * DEFAULT PLUS INTEGER carg ::= * DEFAULT MINUS INTEGER carg ::= * DEFAULT FLOAT carg ::= * DEFAULT PLUS FLOAT carg ::= * DEFAULT MINUS FLOAT carg ::= * DEFAULT NULL ccons ::= * NULL onconf ccons ::= * NOT NULL onconf ccons ::= * PRIMARY KEY sortorder onconf ccons ::= * UNIQUE onconf ccons ::= * CHECK LP expr RP onconf ccons ::= * REFERENCES nm idxlist_opt refargs ccons ::= * defer_subclause ccons ::= * COLLATE id defer_subclause ::= * NOT DEFERRABLE init_deferred_pred_opt defer_subclause ::= * DEFERRABLE init_deferred_pred_opt CHECK shift 62 COLLATE shift 325 CONSTRAINT shift 41 DEFAULT shift 330 DEFERRABLE shift 327 NOT shift 46 NULL shift 44 PRIMARY shift 54 REFERENCES shift 302 UNIQUE shift 60 carg shift 40 ccons shift 329 defer_subclause shift 324 {default} reduce 23 State 40: (40) carglist ::= carglist carg * {default} reduce 40 State 41: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW carg ::= CONSTRAINT * nm ccons ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 42 State 42: carg ::= CONSTRAINT nm * ccons ccons ::= * NULL onconf ccons ::= * NOT NULL onconf ccons ::= * PRIMARY KEY sortorder onconf ccons ::= * UNIQUE onconf ccons ::= * CHECK LP expr RP onconf ccons ::= * REFERENCES nm idxlist_opt refargs ccons ::= * defer_subclause ccons ::= * COLLATE id defer_subclause ::= * NOT DEFERRABLE init_deferred_pred_opt defer_subclause ::= * DEFERRABLE init_deferred_pred_opt CHECK shift 62 COLLATE shift 325 DEFERRABLE shift 327 NOT shift 46 NULL shift 44 PRIMARY shift 54 REFERENCES shift 302 UNIQUE shift 60 ccons shift 43 defer_subclause shift 324 State 43: (42) carg ::= CONSTRAINT nm ccons * {default} reduce 42 State 44: ccons ::= NULL * onconf (88) onconf ::= * onconf ::= * ON CONFLICT resolvetype ON shift 10 onconf shift 45 {default} reduce 88 State 45: (53) ccons ::= NULL onconf * {default} reduce 53 State 46: ccons ::= NOT * NULL onconf defer_subclause ::= NOT * DEFERRABLE init_deferred_pred_opt DEFERRABLE shift 49 NULL shift 47 State 47: ccons ::= NOT NULL * onconf (88) onconf ::= * onconf ::= * ON CONFLICT resolvetype ON shift 10 onconf shift 48 {default} reduce 88 State 48: (54) ccons ::= NOT NULL onconf * {default} reduce 54 State 49: defer_subclause ::= NOT DEFERRABLE * init_deferred_pred_opt (73) init_deferred_pred_opt ::= * init_deferred_pred_opt ::= * INITIALLY DEFERRED init_deferred_pred_opt ::= * INITIALLY IMMEDIATE INITIALLY shift 51 init_deferred_pred_opt shift 50 {default} reduce 73 State 50: (71) defer_subclause ::= NOT DEFERRABLE init_deferred_pred_opt * {default} reduce 71 State 51: init_deferred_pred_opt ::= INITIALLY * DEFERRED init_deferred_pred_opt ::= INITIALLY * IMMEDIATE DEFERRED shift 52 IMMEDIATE shift 53 State 52: (74) init_deferred_pred_opt ::= INITIALLY DEFERRED * {default} reduce 74 State 53: (75) init_deferred_pred_opt ::= INITIALLY IMMEDIATE * {default} reduce 75 State 54: ccons ::= PRIMARY * KEY sortorder onconf KEY shift 55 State 55: ccons ::= PRIMARY KEY * sortorder onconf sortorder ::= * ASC sortorder ::= * DESC (143) sortorder ::= * ASC shift 58 DESC shift 59 sortorder shift 56 {default} reduce 143 State 56: ccons ::= PRIMARY KEY sortorder * onconf (88) onconf ::= * onconf ::= * ON CONFLICT resolvetype ON shift 10 onconf shift 57 {default} reduce 88 State 57: (55) ccons ::= PRIMARY KEY sortorder onconf * {default} reduce 55 State 58: (141) sortorder ::= ASC * {default} reduce 141 State 59: (142) sortorder ::= DESC * {default} reduce 142 State 60: ccons ::= UNIQUE * onconf (88) onconf ::= * onconf ::= * ON CONFLICT resolvetype ON shift 10 onconf shift 61 {default} reduce 88 State 61: (56) ccons ::= UNIQUE onconf * {default} reduce 56 State 62: ccons ::= CHECK * LP expr RP onconf LP shift 63 State 63: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW ccons ::= CHECK LP * expr RP onconf expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 299 nm shift 107 State 64: (28) nm ::= ID * (172) expr ::= ID * expr ::= ID * LP exprlist RP expr ::= ID * LP STAR RP DOT reduce 28 LP shift 65 {default} reduce 172 State 65: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= ID LP * exprlist RP expr ::= * ID LP STAR RP expr ::= ID LP * STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END exprlist ::= * exprlist COMMA expritem exprlist ::= * expritem expritem ::= * expr (230) expritem ::= * expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STAR shift 297 STRING shift 66 expr shift 172 expritem shift 219 exprlist shift 295 nm shift 107 {default} reduce 230 State 66: (29) nm ::= STRING * (179) expr ::= STRING * DOT reduce 29 {default} reduce 179 State 67: (30) nm ::= JOIN_KW * (173) expr ::= JOIN_KW * DOT reduce 30 {default} reduce 173 State 68: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW select ::= * oneselect select ::= * select multiselect_op oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt expr ::= * LP expr RP expr ::= LP * expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= LP * select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 SELECT shift 73 STRING shift 66 expr shift 293 nm shift 107 oneselect shift 69 select shift 70 State 69: (101) select ::= oneselect * {default} reduce 101 State 70: select ::= select * multiselect_op oneselect multiselect_op ::= * UNION multiselect_op ::= * UNION ALL multiselect_op ::= * INTERSECT multiselect_op ::= * EXCEPT expr ::= LP select * RP EXCEPT shift 170 INTERSECT shift 169 RP shift 292 UNION shift 167 multiselect_op shift 71 State 71: select ::= select multiselect_op * oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt SELECT shift 73 oneselect shift 72 State 72: (102) select ::= select multiselect_op oneselect * {default} reduce 102 State 73: oneselect ::= SELECT * distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt distinct ::= * DISTINCT distinct ::= * ALL (110) distinct ::= * ALL shift 291 DISTINCT shift 290 distinct shift 74 {default} reduce 110 State 74: oneselect ::= SELECT distinct * selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt sclp ::= * selcollist COMMA (112) sclp ::= * selcollist ::= * sclp expr as selcollist ::= * sclp STAR selcollist ::= * sclp nm DOT STAR sclp shift 283 selcollist shift 75 {default} reduce 112 State 75: oneselect ::= SELECT distinct selcollist * from where_opt groupby_opt having_opt orderby_opt limit_opt sclp ::= selcollist * COMMA (119) from ::= * from ::= * FROM seltablist COMMA shift 241 FROM shift 242 from shift 76 {default} reduce 119 State 76: oneselect ::= SELECT distinct selcollist from * where_opt groupby_opt having_opt orderby_opt limit_opt (155) where_opt ::= * where_opt ::= * WHERE expr WHERE shift 239 where_opt shift 77 {default} reduce 155 State 77: oneselect ::= SELECT distinct selcollist from where_opt * groupby_opt having_opt orderby_opt limit_opt (146) groupby_opt ::= * groupby_opt ::= * GROUP BY exprlist GROUP shift 236 groupby_opt shift 78 {default} reduce 146 State 78: oneselect ::= SELECT distinct selcollist from where_opt groupby_opt * having_opt orderby_opt limit_opt (148) having_opt ::= * having_opt ::= * HAVING expr HAVING shift 234 having_opt shift 79 {default} reduce 148 State 79: oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt * orderby_opt limit_opt (136) orderby_opt ::= * orderby_opt ::= * ORDER BY sortlist ORDER shift 93 orderby_opt shift 80 {default} reduce 136 State 80: oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt * limit_opt (150) limit_opt ::= * limit_opt ::= * LIMIT signed limit_opt ::= * LIMIT signed OFFSET signed limit_opt ::= * LIMIT signed COMMA signed LIMIT shift 82 limit_opt shift 81 {default} reduce 150 State 81: (107) oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt * {default} reduce 107 State 82: signed ::= * INTEGER signed ::= * PLUS INTEGER signed ::= * MINUS INTEGER limit_opt ::= LIMIT * signed limit_opt ::= LIMIT * signed OFFSET signed limit_opt ::= LIMIT * signed COMMA signed INTEGER shift 83 MINUS shift 86 PLUS shift 84 signed shift 88 State 83: (37) signed ::= INTEGER * {default} reduce 37 State 84: signed ::= PLUS * INTEGER INTEGER shift 85 State 85: (38) signed ::= PLUS INTEGER * {default} reduce 38 State 86: signed ::= MINUS * INTEGER INTEGER shift 87 State 87: (39) signed ::= MINUS INTEGER * {default} reduce 39 State 88: (151) limit_opt ::= LIMIT signed * limit_opt ::= LIMIT signed * OFFSET signed limit_opt ::= LIMIT signed * COMMA signed COMMA shift 91 OFFSET shift 89 {default} reduce 151 State 89: signed ::= * INTEGER signed ::= * PLUS INTEGER signed ::= * MINUS INTEGER limit_opt ::= LIMIT signed OFFSET * signed INTEGER shift 83 MINUS shift 86 PLUS shift 84 signed shift 90 State 90: (152) limit_opt ::= LIMIT signed OFFSET signed * {default} reduce 152 State 91: signed ::= * INTEGER signed ::= * PLUS INTEGER signed ::= * MINUS INTEGER limit_opt ::= LIMIT signed COMMA * signed INTEGER shift 83 MINUS shift 86 PLUS shift 84 signed shift 92 State 92: (153) limit_opt ::= LIMIT signed COMMA signed * {default} reduce 153 State 93: orderby_opt ::= ORDER * BY sortlist BY shift 94 State 94: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW orderby_opt ::= ORDER BY * sortlist sortlist ::= * sortlist COMMA sortitem collate sortorder sortlist ::= * sortitem collate sortorder sortitem ::= * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 103 nm shift 107 sortitem shift 231 sortlist shift 95 State 95: (137) orderby_opt ::= ORDER BY sortlist * sortlist ::= sortlist * COMMA sortitem collate sortorder COMMA shift 96 {default} reduce 137 State 96: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW sortlist ::= sortlist COMMA * sortitem collate sortorder sortitem ::= * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 103 nm shift 107 sortitem shift 97 State 97: sortlist ::= sortlist COMMA sortitem * collate sortorder (144) collate ::= * collate ::= * COLLATE id COLLATE shift 100 collate shift 98 {default} reduce 144 State 98: sortlist ::= sortlist COMMA sortitem collate * sortorder sortorder ::= * ASC sortorder ::= * DESC (143) sortorder ::= * ASC shift 58 DESC shift 59 sortorder shift 99 {default} reduce 143 State 99: (138) sortlist ::= sortlist COMMA sortitem collate sortorder * {default} reduce 138 State 100: id ::= * ID collate ::= COLLATE * id ID shift 101 id shift 102 State 101: (25) id ::= ID * {default} reduce 25 State 102: (145) collate ::= COLLATE id * {default} reduce 145 State 103: (140) sortitem ::= expr * expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 140 State 104: (176) expr ::= expr ORACLE_OUTER_JOIN * {default} reduce 176 State 105: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= expr AND * expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 112 nm shift 107 State 106: (171) expr ::= NULL * {default} reduce 171 State 107: expr ::= nm * DOT nm expr ::= nm * DOT nm DOT nm DOT shift 108 State 108: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= nm DOT * nm expr ::= nm DOT * nm DOT nm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 109 State 109: (174) expr ::= nm DOT nm * expr ::= nm DOT nm * DOT nm DOT shift 110 {default} reduce 174 State 110: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= nm DOT nm DOT * nm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 111 State 111: (175) expr ::= nm DOT nm DOT nm * {default} reduce 175 State 112: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr (182) expr ::= expr AND expr * expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 182 State 113: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= expr OR * expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 114 nm shift 107 State 114: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr (183) expr ::= expr OR expr * expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 183 State 115: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= expr LT * expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 116 nm shift 107 State 116: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr (184) expr ::= expr LT expr * expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BITAND shift 127 BITOR shift 129 CONCAT shift 152 LSHIFT shift 131 MINUS shift 144 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 184 State 117: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= expr GT * expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 118 nm shift 107 State 118: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr (185) expr ::= expr GT expr * expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BITAND shift 127 BITOR shift 129 CONCAT shift 152 LSHIFT shift 131 MINUS shift 144 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 185 State 119: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= expr LE * expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 120 nm shift 107 State 120: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr (186) expr ::= expr LE expr * expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BITAND shift 127 BITOR shift 129 CONCAT shift 152 LSHIFT shift 131 MINUS shift 144 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 186 State 121: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= expr GE * expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 122 nm shift 107 State 122: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr (187) expr ::= expr GE expr * expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BITAND shift 127 BITOR shift 129 CONCAT shift 152 LSHIFT shift 131 MINUS shift 144 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 187 State 123: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= expr NE * expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 124 nm shift 107 State 124: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr (188) expr ::= expr NE expr * expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BITAND shift 127 BITOR shift 129 CONCAT shift 152 GE shift 121 GT shift 117 LE shift 119 LSHIFT shift 131 LT shift 115 MINUS shift 144 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 188 State 125: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= expr EQ * expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 126 nm shift 107 State 126: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr (189) expr ::= expr EQ expr * expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BITAND shift 127 BITOR shift 129 CONCAT shift 152 GE shift 121 GT shift 117 LE shift 119 LSHIFT shift 131 LT shift 115 MINUS shift 144 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 189 State 127: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= expr BITAND * expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 128 nm shift 107 State 128: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr (190) expr ::= expr BITAND expr * expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 152 MINUS shift 144 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 190 State 129: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= expr BITOR * expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 130 nm shift 107 State 130: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr (191) expr ::= expr BITOR expr * expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 152 MINUS shift 144 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 191 State 131: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= expr LSHIFT * expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 132 nm shift 107 State 132: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr (192) expr ::= expr LSHIFT expr * expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 152 MINUS shift 144 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 192 State 133: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= expr RSHIFT * expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 134 nm shift 107 State 134: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr (193) expr ::= expr RSHIFT expr * expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 152 MINUS shift 144 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 193 State 135: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= expr likeop * expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 136 nm shift 107 State 136: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr (194) expr ::= expr likeop expr * expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BITAND shift 127 BITOR shift 129 CONCAT shift 152 GE shift 121 GT shift 117 LE shift 119 LSHIFT shift 131 LT shift 115 MINUS shift 144 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 194 State 137: expr ::= expr NOT * likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr NOT * NULL expr ::= expr NOT * BETWEEN expr AND expr expr ::= expr NOT * IN LP exprlist RP expr ::= expr NOT * IN LP select RP BETWEEN shift 221 GLOB shift 141 IN shift 225 LIKE shift 140 NULL shift 220 likeop shift 138 State 138: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= expr NOT likeop * expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 139 nm shift 107 State 139: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr (195) expr ::= expr NOT likeop expr * likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BITAND shift 127 BITOR shift 129 CONCAT shift 152 GE shift 121 GT shift 117 LE shift 119 LSHIFT shift 131 LT shift 115 MINUS shift 144 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 195 State 140: (196) likeop ::= LIKE * {default} reduce 196 State 141: (197) likeop ::= GLOB * {default} reduce 197 State 142: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= expr PLUS * expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 143 nm shift 107 State 143: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr (198) expr ::= expr PLUS expr * expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 152 ORACLE_OUTER_JOIN shift 104 REM shift 150 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 198 State 144: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= expr MINUS * expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 145 nm shift 107 State 145: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr (199) expr ::= expr MINUS expr * expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 152 ORACLE_OUTER_JOIN shift 104 REM shift 150 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 199 State 146: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= expr STAR * expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 147 nm shift 107 State 147: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr (200) expr ::= expr STAR expr * expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 152 ORACLE_OUTER_JOIN shift 104 likeop shift 135 {default} reduce 200 State 148: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= expr SLASH * expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 149 nm shift 107 State 149: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr (201) expr ::= expr SLASH expr * expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 152 ORACLE_OUTER_JOIN shift 104 likeop shift 135 {default} reduce 201 State 150: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= expr REM * expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 151 nm shift 107 State 151: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr (202) expr ::= expr REM expr * expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 152 ORACLE_OUTER_JOIN shift 104 likeop shift 135 {default} reduce 202 State 152: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= expr CONCAT * expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 153 nm shift 107 State 153: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr (203) expr ::= expr CONCAT expr * expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP ORACLE_OUTER_JOIN shift 104 likeop shift 135 {default} reduce 203 State 154: (204) expr ::= expr ISNULL * {default} reduce 204 State 155: expr ::= expr IS * NULL expr ::= expr IS * NOT NULL NOT shift 157 NULL shift 156 State 156: (205) expr ::= expr IS NULL * {default} reduce 205 State 157: expr ::= expr IS NOT * NULL NULL shift 158 State 158: (208) expr ::= expr IS NOT NULL * {default} reduce 208 State 159: (206) expr ::= expr NOTNULL * {default} reduce 206 State 160: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= expr BETWEEN * expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 161 nm shift 107 State 161: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr BETWEEN expr * AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 162 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 State 162: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= expr AND * expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= expr BETWEEN expr AND * expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 163 nm shift 107 State 163: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr (182) expr ::= expr AND expr * expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr (214) expr ::= expr BETWEEN expr AND expr * expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BITAND shift 127 BITOR shift 129 CONCAT shift 152 GE shift 121 GT shift 117 LE shift 119 LSHIFT shift 131 LT shift 115 MINUS shift 144 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 214 State 164: expr ::= expr IN * LP exprlist RP expr ::= expr IN * LP select RP LP shift 165 State 165: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW select ::= * oneselect select ::= * select multiselect_op oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= expr IN LP * exprlist RP expr ::= * expr IN LP select RP expr ::= expr IN LP * select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END exprlist ::= * exprlist COMMA expritem exprlist ::= * expritem expritem ::= * expr (230) expritem ::= * expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 SELECT shift 73 STRING shift 66 expr shift 172 expritem shift 219 exprlist shift 215 nm shift 107 oneselect shift 69 select shift 166 {default} reduce 230 State 166: select ::= select * multiselect_op oneselect multiselect_op ::= * UNION multiselect_op ::= * UNION ALL multiselect_op ::= * INTERSECT multiselect_op ::= * EXCEPT expr ::= expr IN LP select * RP EXCEPT shift 170 INTERSECT shift 169 RP shift 171 UNION shift 167 multiselect_op shift 71 State 167: (103) multiselect_op ::= UNION * multiselect_op ::= UNION * ALL ALL shift 168 SELECT reduce 103 State 168: (104) multiselect_op ::= UNION ALL * SELECT reduce 104 State 169: (105) multiselect_op ::= INTERSECT * SELECT reduce 105 State 170: (106) multiselect_op ::= EXCEPT * SELECT reduce 106 State 171: (217) expr ::= expr IN LP select RP * {default} reduce 217 State 172: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP (229) expritem ::= expr * AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 229 State 173: (177) expr ::= INTEGER * {default} reduce 177 State 174: (178) expr ::= FLOAT * {default} reduce 178 State 175: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= NOT * expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 176 nm shift 107 State 176: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL (209) expr ::= NOT expr * expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 209 State 177: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= BITNOT * expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 178 nm shift 107 State 178: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL (210) expr ::= BITNOT expr * expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP ORACLE_OUTER_JOIN shift 104 likeop shift 135 {default} reduce 210 State 179: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= MINUS * expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 180 nm shift 107 State 180: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL (211) expr ::= MINUS expr * expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP ORACLE_OUTER_JOIN shift 104 likeop shift 135 {default} reduce 211 State 181: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= PLUS * expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 182 nm shift 107 State 182: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL (212) expr ::= PLUS expr * expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP ORACLE_OUTER_JOIN shift 104 likeop shift 135 {default} reduce 212 State 183: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= CASE * case_operand case_exprlist case_else END case_operand ::= * expr (226) case_operand ::= * expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 WHEN reduce 226 case_operand shift 185 expr shift 184 nm shift 107 State 184: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP (225) case_operand ::= expr * AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 WHEN reduce 225 likeop shift 135 State 185: expr ::= CASE case_operand * case_exprlist case_else END case_exprlist ::= * case_exprlist WHEN expr THEN expr case_exprlist ::= * WHEN expr THEN expr WHEN shift 211 case_exprlist shift 186 State 186: expr ::= CASE case_operand case_exprlist * case_else END case_exprlist ::= case_exprlist * WHEN expr THEN expr case_else ::= * ELSE expr (224) case_else ::= * ELSE shift 209 END reduce 224 WHEN shift 189 case_else shift 187 State 187: expr ::= CASE case_operand case_exprlist case_else * END END shift 188 State 188: (220) expr ::= CASE case_operand case_exprlist case_else END * {default} reduce 220 State 189: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END case_exprlist ::= case_exprlist WHEN * expr THEN expr expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 190 nm shift 107 State 190: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP case_exprlist ::= case_exprlist WHEN expr * THEN expr AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 THEN shift 191 likeop shift 135 State 191: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END case_exprlist ::= case_exprlist WHEN expr THEN * expr expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 192 nm shift 107 State 192: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP (221) case_exprlist ::= case_exprlist WHEN expr THEN expr * AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 221 State 193: expr ::= RAISE * LP IGNORE RP expr ::= RAISE * LP ROLLBACK COMMA nm RP expr ::= RAISE * LP ABORT COMMA nm RP expr ::= RAISE * LP FAIL COMMA nm RP LP shift 194 State 194: expr ::= RAISE LP * IGNORE RP expr ::= RAISE LP * ROLLBACK COMMA nm RP expr ::= RAISE LP * ABORT COMMA nm RP expr ::= RAISE LP * FAIL COMMA nm RP ABORT shift 201 FAIL shift 205 IGNORE shift 195 ROLLBACK shift 197 State 195: expr ::= RAISE LP IGNORE * RP RP shift 196 State 196: (278) expr ::= RAISE LP IGNORE RP * {default} reduce 278 State 197: expr ::= RAISE LP ROLLBACK * COMMA nm RP COMMA shift 198 State 198: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= RAISE LP ROLLBACK COMMA * nm RP ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 199 State 199: expr ::= RAISE LP ROLLBACK COMMA nm * RP RP shift 200 State 200: (279) expr ::= RAISE LP ROLLBACK COMMA nm RP * {default} reduce 279 State 201: expr ::= RAISE LP ABORT * COMMA nm RP COMMA shift 202 State 202: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= RAISE LP ABORT COMMA * nm RP ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 203 State 203: expr ::= RAISE LP ABORT COMMA nm * RP RP shift 204 State 204: (280) expr ::= RAISE LP ABORT COMMA nm RP * {default} reduce 280 State 205: expr ::= RAISE LP FAIL * COMMA nm RP COMMA shift 206 State 206: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= RAISE LP FAIL COMMA * nm RP ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 207 State 207: expr ::= RAISE LP FAIL COMMA nm * RP RP shift 208 State 208: (281) expr ::= RAISE LP FAIL COMMA nm RP * {default} reduce 281 State 209: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END case_else ::= ELSE * expr expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 210 nm shift 107 State 210: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP (223) case_else ::= ELSE expr * AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 END reduce 223 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 State 211: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END case_exprlist ::= WHEN * expr THEN expr expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 212 nm shift 107 State 212: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP case_exprlist ::= WHEN expr * THEN expr AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 THEN shift 213 likeop shift 135 State 213: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END case_exprlist ::= WHEN expr THEN * expr expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 214 nm shift 107 State 214: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP (222) case_exprlist ::= WHEN expr THEN expr * AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 222 State 215: expr ::= expr IN LP exprlist * RP exprlist ::= exprlist * COMMA expritem COMMA shift 217 RP shift 216 State 216: (216) expr ::= expr IN LP exprlist RP * {default} reduce 216 State 217: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END exprlist ::= exprlist COMMA * expritem expritem ::= * expr (230) expritem ::= * expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 172 expritem shift 218 nm shift 107 {default} reduce 230 State 218: (227) exprlist ::= exprlist COMMA expritem * {default} reduce 227 State 219: (228) exprlist ::= expritem * {default} reduce 228 State 220: (207) expr ::= expr NOT NULL * {default} reduce 207 State 221: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= expr NOT BETWEEN * expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 222 nm shift 107 State 222: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr NOT BETWEEN expr * AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 223 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 State 223: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= expr AND * expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= expr NOT BETWEEN expr AND * expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 224 nm shift 107 State 224: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr (182) expr ::= expr AND expr * expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr (215) expr ::= expr NOT BETWEEN expr AND expr * expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 215 State 225: expr ::= expr NOT IN * LP exprlist RP expr ::= expr NOT IN * LP select RP LP shift 226 State 226: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW select ::= * oneselect select ::= * select multiselect_op oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= expr NOT IN LP * exprlist RP expr ::= * expr NOT IN LP select RP expr ::= expr NOT IN LP * select RP expr ::= * CASE case_operand case_exprlist case_else END exprlist ::= * exprlist COMMA expritem exprlist ::= * expritem expritem ::= * expr (230) expritem ::= * expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 SELECT shift 73 STRING shift 66 expr shift 172 expritem shift 219 exprlist shift 229 nm shift 107 oneselect shift 69 select shift 227 {default} reduce 230 State 227: select ::= select * multiselect_op oneselect multiselect_op ::= * UNION multiselect_op ::= * UNION ALL multiselect_op ::= * INTERSECT multiselect_op ::= * EXCEPT expr ::= expr NOT IN LP select * RP EXCEPT shift 170 INTERSECT shift 169 RP shift 228 UNION shift 167 multiselect_op shift 71 State 228: (219) expr ::= expr NOT IN LP select RP * {default} reduce 219 State 229: expr ::= expr NOT IN LP exprlist * RP exprlist ::= exprlist * COMMA expritem COMMA shift 217 RP shift 230 State 230: (218) expr ::= expr NOT IN LP exprlist RP * {default} reduce 218 State 231: sortlist ::= sortitem * collate sortorder (144) collate ::= * collate ::= * COLLATE id COLLATE shift 100 collate shift 232 {default} reduce 144 State 232: sortlist ::= sortitem collate * sortorder sortorder ::= * ASC sortorder ::= * DESC (143) sortorder ::= * ASC shift 58 DESC shift 59 sortorder shift 233 {default} reduce 143 State 233: (139) sortlist ::= sortitem collate sortorder * {default} reduce 139 State 234: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW having_opt ::= HAVING * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 235 nm shift 107 State 235: (149) having_opt ::= HAVING expr * expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 149 State 236: groupby_opt ::= GROUP * BY exprlist BY shift 237 State 237: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW groupby_opt ::= GROUP BY * exprlist expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END exprlist ::= * exprlist COMMA expritem exprlist ::= * expritem expritem ::= * expr (230) expritem ::= * expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 172 expritem shift 219 exprlist shift 238 nm shift 107 {default} reduce 230 State 238: (147) groupby_opt ::= GROUP BY exprlist * exprlist ::= exprlist * COMMA expritem COMMA shift 217 {default} reduce 147 State 239: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW where_opt ::= WHERE * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 240 nm shift 107 State 240: (156) where_opt ::= WHERE expr * expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 156 State 241: (111) sclp ::= selcollist COMMA * {default} reduce 111 State 242: from ::= FROM * seltablist stl_prefix ::= * seltablist joinop (122) stl_prefix ::= * seltablist ::= * stl_prefix nm dbnm as on_opt using_opt seltablist ::= * stl_prefix LP select RP as on_opt using_opt seltablist shift 243 stl_prefix shift 253 {default} reduce 122 State 243: (120) from ::= FROM seltablist * stl_prefix ::= seltablist * joinop joinop ::= * COMMA joinop ::= * JOIN joinop ::= * JOIN_KW JOIN joinop ::= * JOIN_KW nm JOIN joinop ::= * JOIN_KW nm nm JOIN COMMA shift 245 JOIN shift 246 JOIN_KW shift 247 joinop shift 244 {default} reduce 120 State 244: (121) stl_prefix ::= seltablist joinop * {default} reduce 121 State 245: (127) joinop ::= COMMA * {default} reduce 127 State 246: (128) joinop ::= JOIN * {default} reduce 128 State 247: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW joinop ::= JOIN_KW * JOIN joinop ::= JOIN_KW * nm JOIN joinop ::= JOIN_KW * nm nm JOIN ID shift 20 JOIN shift 248 JOIN_KW shift 22 STRING shift 21 nm shift 249 State 248: (129) joinop ::= JOIN_KW JOIN * {default} reduce 129 State 249: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW joinop ::= JOIN_KW nm * JOIN joinop ::= JOIN_KW nm * nm JOIN ID shift 20 JOIN shift 250 JOIN_KW shift 22 STRING shift 21 nm shift 251 State 250: (130) joinop ::= JOIN_KW nm JOIN * {default} reduce 130 State 251: joinop ::= JOIN_KW nm nm * JOIN JOIN shift 252 State 252: (131) joinop ::= JOIN_KW nm nm JOIN * {default} reduce 131 State 253: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW seltablist ::= stl_prefix * nm dbnm as on_opt using_opt seltablist ::= stl_prefix * LP select RP as on_opt using_opt ID shift 20 JOIN_KW shift 22 LP shift 277 STRING shift 21 nm shift 254 State 254: seltablist ::= stl_prefix nm * dbnm as on_opt using_opt (125) dbnm ::= * dbnm ::= * DOT nm DOT shift 275 dbnm shift 255 {default} reduce 125 State 255: ids ::= * ID ids ::= * STRING as ::= * AS nm as ::= * ids (118) as ::= * seltablist ::= stl_prefix nm dbnm * as on_opt using_opt AS shift 258 ID shift 256 STRING shift 257 as shift 261 ids shift 260 {default} reduce 118 State 256: (26) ids ::= ID * {default} reduce 26 State 257: (27) ids ::= STRING * {default} reduce 27 State 258: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW as ::= AS * nm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 259 State 259: (116) as ::= AS nm * {default} reduce 116 State 260: (117) as ::= ids * {default} reduce 117 State 261: seltablist ::= stl_prefix nm dbnm as * on_opt using_opt on_opt ::= * ON expr (133) on_opt ::= * ON shift 273 on_opt shift 262 {default} reduce 133 State 262: seltablist ::= stl_prefix nm dbnm as on_opt * using_opt using_opt ::= * USING LP idxlist RP (135) using_opt ::= * USING shift 264 using_opt shift 263 {default} reduce 135 State 263: (123) seltablist ::= stl_prefix nm dbnm as on_opt using_opt * {default} reduce 123 State 264: using_opt ::= USING * LP idxlist RP LP shift 265 State 265: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW using_opt ::= USING LP * idxlist RP idxlist ::= * idxlist COMMA idxitem idxlist ::= * idxitem idxitem ::= * nm sortorder ID shift 20 JOIN_KW shift 22 STRING shift 21 idxitem shift 272 idxlist shift 266 nm shift 270 State 266: using_opt ::= USING LP idxlist * RP idxlist ::= idxlist * COMMA idxitem COMMA shift 268 RP shift 267 State 267: (134) using_opt ::= USING LP idxlist RP * {default} reduce 134 State 268: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW idxlist ::= idxlist COMMA * idxitem idxitem ::= * nm sortorder ID shift 20 JOIN_KW shift 22 STRING shift 21 idxitem shift 269 nm shift 270 State 269: (236) idxlist ::= idxlist COMMA idxitem * {default} reduce 236 State 270: sortorder ::= * ASC sortorder ::= * DESC (143) sortorder ::= * idxitem ::= nm * sortorder ASC shift 58 DESC shift 59 sortorder shift 271 {default} reduce 143 State 271: (238) idxitem ::= nm sortorder * {default} reduce 238 State 272: (237) idxlist ::= idxitem * {default} reduce 237 State 273: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW on_opt ::= ON * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 274 nm shift 107 State 274: (132) on_opt ::= ON expr * expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 132 State 275: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW dbnm ::= DOT * nm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 276 State 276: (126) dbnm ::= DOT nm * {default} reduce 126 State 277: select ::= * oneselect select ::= * select multiselect_op oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt seltablist ::= stl_prefix LP * select RP as on_opt using_opt SELECT shift 73 oneselect shift 69 select shift 278 State 278: select ::= select * multiselect_op oneselect multiselect_op ::= * UNION multiselect_op ::= * UNION ALL multiselect_op ::= * INTERSECT multiselect_op ::= * EXCEPT seltablist ::= stl_prefix LP select * RP as on_opt using_opt EXCEPT shift 170 INTERSECT shift 169 RP shift 279 UNION shift 167 multiselect_op shift 71 State 279: ids ::= * ID ids ::= * STRING as ::= * AS nm as ::= * ids (118) as ::= * seltablist ::= stl_prefix LP select RP * as on_opt using_opt AS shift 258 ID shift 256 STRING shift 257 as shift 280 ids shift 260 {default} reduce 118 State 280: seltablist ::= stl_prefix LP select RP as * on_opt using_opt on_opt ::= * ON expr (133) on_opt ::= * ON shift 273 on_opt shift 281 {default} reduce 133 State 281: seltablist ::= stl_prefix LP select RP as on_opt * using_opt using_opt ::= * USING LP idxlist RP (135) using_opt ::= * USING shift 264 using_opt shift 282 {default} reduce 135 State 282: (124) seltablist ::= stl_prefix LP select RP as on_opt using_opt * {default} reduce 124 State 283: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW selcollist ::= sclp * expr as selcollist ::= sclp * STAR selcollist ::= sclp * nm DOT STAR expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STAR shift 286 STRING shift 66 expr shift 284 nm shift 287 State 284: ids ::= * ID ids ::= * STRING selcollist ::= sclp expr * as as ::= * AS nm as ::= * ids (118) as ::= * expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 105 AS shift 258 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 ID shift 256 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 STRING shift 257 as shift 285 ids shift 260 likeop shift 135 {default} reduce 118 State 285: (113) selcollist ::= sclp expr as * {default} reduce 113 State 286: (114) selcollist ::= sclp STAR * {default} reduce 114 State 287: selcollist ::= sclp nm * DOT STAR expr ::= nm * DOT nm expr ::= nm * DOT nm DOT nm DOT shift 288 State 288: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW selcollist ::= sclp nm DOT * STAR expr ::= nm DOT * nm expr ::= nm DOT * nm DOT nm ID shift 20 JOIN_KW shift 22 STAR shift 289 STRING shift 21 nm shift 109 State 289: (115) selcollist ::= sclp nm DOT STAR * {default} reduce 115 State 290: (108) distinct ::= DISTINCT * {default} reduce 108 State 291: (109) distinct ::= ALL * {default} reduce 109 State 292: (213) expr ::= LP select RP * {default} reduce 213 State 293: expr ::= LP expr * RP expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RP shift 294 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 State 294: (170) expr ::= LP expr RP * {default} reduce 170 State 295: expr ::= ID LP exprlist * RP exprlist ::= exprlist * COMMA expritem COMMA shift 217 RP shift 296 State 296: (180) expr ::= ID LP exprlist RP * {default} reduce 180 State 297: expr ::= ID LP STAR * RP RP shift 298 State 298: (181) expr ::= ID LP STAR RP * {default} reduce 181 State 299: ccons ::= CHECK LP expr * RP onconf expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RP shift 300 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 State 300: ccons ::= CHECK LP expr RP * onconf (88) onconf ::= * onconf ::= * ON CONFLICT resolvetype ON shift 10 onconf shift 301 {default} reduce 88 State 301: (57) ccons ::= CHECK LP expr RP onconf * {default} reduce 57 State 302: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW ccons ::= REFERENCES * nm idxlist_opt refargs ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 303 State 303: ccons ::= REFERENCES nm * idxlist_opt refargs (234) idxlist_opt ::= * idxlist_opt ::= * LP idxlist RP LP shift 321 idxlist_opt shift 304 {default} reduce 234 State 304: ccons ::= REFERENCES nm idxlist_opt * refargs (61) refargs ::= * refargs ::= * refargs refarg refargs shift 305 {default} reduce 61 State 305: (58) ccons ::= REFERENCES nm idxlist_opt refargs * refargs ::= refargs * refarg refarg ::= * MATCH nm refarg ::= * ON DELETE refact refarg ::= * ON UPDATE refact refarg ::= * ON INSERT refact MATCH shift 307 ON shift 309 refarg shift 306 {default} reduce 58 State 306: (62) refargs ::= refargs refarg * {default} reduce 62 State 307: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW refarg ::= MATCH * nm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 308 State 308: (63) refarg ::= MATCH nm * {default} reduce 63 State 309: refarg ::= ON * DELETE refact refarg ::= ON * UPDATE refact refarg ::= ON * INSERT refact DELETE shift 310 INSERT shift 319 UPDATE shift 317 State 310: refarg ::= ON DELETE * refact refact ::= * SET NULL refact ::= * SET DEFAULT refact ::= * CASCADE refact ::= * RESTRICT CASCADE shift 315 RESTRICT shift 316 SET shift 312 refact shift 311 State 311: (64) refarg ::= ON DELETE refact * {default} reduce 64 State 312: refact ::= SET * NULL refact ::= SET * DEFAULT DEFAULT shift 314 NULL shift 313 State 313: (67) refact ::= SET NULL * {default} reduce 67 State 314: (68) refact ::= SET DEFAULT * {default} reduce 68 State 315: (69) refact ::= CASCADE * {default} reduce 69 State 316: (70) refact ::= RESTRICT * {default} reduce 70 State 317: refarg ::= ON UPDATE * refact refact ::= * SET NULL refact ::= * SET DEFAULT refact ::= * CASCADE refact ::= * RESTRICT CASCADE shift 315 RESTRICT shift 316 SET shift 312 refact shift 318 State 318: (65) refarg ::= ON UPDATE refact * {default} reduce 65 State 319: refarg ::= ON INSERT * refact refact ::= * SET NULL refact ::= * SET DEFAULT refact ::= * CASCADE refact ::= * RESTRICT CASCADE shift 315 RESTRICT shift 316 SET shift 312 refact shift 320 State 320: (66) refarg ::= ON INSERT refact * {default} reduce 66 State 321: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW idxlist_opt ::= LP * idxlist RP idxlist ::= * idxlist COMMA idxitem idxlist ::= * idxitem idxitem ::= * nm sortorder ID shift 20 JOIN_KW shift 22 STRING shift 21 idxitem shift 272 idxlist shift 322 nm shift 270 State 322: idxlist_opt ::= LP idxlist * RP idxlist ::= idxlist * COMMA idxitem COMMA shift 268 RP shift 323 State 323: (235) idxlist_opt ::= LP idxlist RP * {default} reduce 235 State 324: (59) ccons ::= defer_subclause * {default} reduce 59 State 325: id ::= * ID ccons ::= COLLATE * id ID shift 101 id shift 326 State 326: (60) ccons ::= COLLATE id * {default} reduce 60 State 327: defer_subclause ::= DEFERRABLE * init_deferred_pred_opt (73) init_deferred_pred_opt ::= * init_deferred_pred_opt ::= * INITIALLY DEFERRED init_deferred_pred_opt ::= * INITIALLY IMMEDIATE INITIALLY shift 51 init_deferred_pred_opt shift 328 {default} reduce 73 State 328: (72) defer_subclause ::= DEFERRABLE init_deferred_pred_opt * {default} reduce 72 State 329: (43) carg ::= ccons * {default} reduce 43 State 330: carg ::= DEFAULT * STRING carg ::= DEFAULT * ID carg ::= DEFAULT * INTEGER carg ::= DEFAULT * PLUS INTEGER carg ::= DEFAULT * MINUS INTEGER carg ::= DEFAULT * FLOAT carg ::= DEFAULT * PLUS FLOAT carg ::= DEFAULT * MINUS FLOAT carg ::= DEFAULT * NULL FLOAT shift 340 ID shift 332 INTEGER shift 333 MINUS shift 337 NULL shift 341 PLUS shift 334 STRING shift 331 State 331: (44) carg ::= DEFAULT STRING * {default} reduce 44 State 332: (45) carg ::= DEFAULT ID * {default} reduce 45 State 333: (46) carg ::= DEFAULT INTEGER * {default} reduce 46 State 334: carg ::= DEFAULT PLUS * INTEGER carg ::= DEFAULT PLUS * FLOAT FLOAT shift 336 INTEGER shift 335 State 335: (47) carg ::= DEFAULT PLUS INTEGER * {default} reduce 47 State 336: (50) carg ::= DEFAULT PLUS FLOAT * {default} reduce 50 State 337: carg ::= DEFAULT MINUS * INTEGER carg ::= DEFAULT MINUS * FLOAT FLOAT shift 339 INTEGER shift 338 State 338: (48) carg ::= DEFAULT MINUS INTEGER * {default} reduce 48 State 339: (51) carg ::= DEFAULT MINUS FLOAT * {default} reduce 51 State 340: (49) carg ::= DEFAULT FLOAT * {default} reduce 49 State 341: (52) carg ::= DEFAULT NULL * {default} reduce 52 State 342: ids ::= * ID ids ::= * STRING (32) type ::= typename * type ::= typename * LP signed RP type ::= typename * LP signed COMMA signed RP typename ::= typename * ids ID shift 256 LP shift 343 STRING shift 257 ids shift 349 {default} reduce 32 State 343: type ::= typename LP * signed RP type ::= typename LP * signed COMMA signed RP signed ::= * INTEGER signed ::= * PLUS INTEGER signed ::= * MINUS INTEGER INTEGER shift 83 MINUS shift 86 PLUS shift 84 signed shift 344 State 344: type ::= typename LP signed * RP type ::= typename LP signed * COMMA signed RP COMMA shift 346 RP shift 345 State 345: (33) type ::= typename LP signed RP * {default} reduce 33 State 346: type ::= typename LP signed COMMA * signed RP signed ::= * INTEGER signed ::= * PLUS INTEGER signed ::= * MINUS INTEGER INTEGER shift 83 MINUS shift 86 PLUS shift 84 signed shift 347 State 347: type ::= typename LP signed COMMA signed * RP RP shift 348 State 348: (34) type ::= typename LP signed COMMA signed RP * {default} reduce 34 State 349: (36) typename ::= typename ids * {default} reduce 36 State 350: (35) typename ::= ids * {default} reduce 35 State 351: (24) columnid ::= nm * {default} reduce 24 State 352: (77) conslist_opt ::= COMMA conslist * conslist ::= conslist * COMMA tcons conslist ::= conslist * tcons tcons ::= * CONSTRAINT nm tcons ::= * PRIMARY KEY LP idxlist RP onconf tcons ::= * UNIQUE LP idxlist RP onconf tcons ::= * CHECK expr onconf tcons ::= * FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt CHECK shift 368 COMMA shift 353 CONSTRAINT shift 355 FOREIGN shift 371 PRIMARY shift 357 RP reduce 77 UNIQUE shift 363 tcons shift 383 State 353: conslist ::= conslist COMMA * tcons tcons ::= * CONSTRAINT nm tcons ::= * PRIMARY KEY LP idxlist RP onconf tcons ::= * UNIQUE LP idxlist RP onconf tcons ::= * CHECK expr onconf tcons ::= * FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt CHECK shift 368 CONSTRAINT shift 355 FOREIGN shift 371 PRIMARY shift 357 UNIQUE shift 363 tcons shift 354 State 354: (78) conslist ::= conslist COMMA tcons * {default} reduce 78 State 355: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW tcons ::= CONSTRAINT * nm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 356 State 356: (81) tcons ::= CONSTRAINT nm * {default} reduce 81 State 357: tcons ::= PRIMARY * KEY LP idxlist RP onconf KEY shift 358 State 358: tcons ::= PRIMARY KEY * LP idxlist RP onconf LP shift 359 State 359: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW tcons ::= PRIMARY KEY LP * idxlist RP onconf idxlist ::= * idxlist COMMA idxitem idxlist ::= * idxitem idxitem ::= * nm sortorder ID shift 20 JOIN_KW shift 22 STRING shift 21 idxitem shift 272 idxlist shift 360 nm shift 270 State 360: tcons ::= PRIMARY KEY LP idxlist * RP onconf idxlist ::= idxlist * COMMA idxitem COMMA shift 268 RP shift 361 State 361: tcons ::= PRIMARY KEY LP idxlist RP * onconf (88) onconf ::= * onconf ::= * ON CONFLICT resolvetype ON shift 10 onconf shift 362 {default} reduce 88 State 362: (82) tcons ::= PRIMARY KEY LP idxlist RP onconf * {default} reduce 82 State 363: tcons ::= UNIQUE * LP idxlist RP onconf LP shift 364 State 364: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW tcons ::= UNIQUE LP * idxlist RP onconf idxlist ::= * idxlist COMMA idxitem idxlist ::= * idxitem idxitem ::= * nm sortorder ID shift 20 JOIN_KW shift 22 STRING shift 21 idxitem shift 272 idxlist shift 365 nm shift 270 State 365: tcons ::= UNIQUE LP idxlist * RP onconf idxlist ::= idxlist * COMMA idxitem COMMA shift 268 RP shift 366 State 366: tcons ::= UNIQUE LP idxlist RP * onconf (88) onconf ::= * onconf ::= * ON CONFLICT resolvetype ON shift 10 onconf shift 367 {default} reduce 88 State 367: (83) tcons ::= UNIQUE LP idxlist RP onconf * {default} reduce 83 State 368: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW tcons ::= CHECK * expr onconf expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 369 nm shift 107 State 369: tcons ::= CHECK expr * onconf (88) onconf ::= * onconf ::= * ON CONFLICT resolvetype expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 ON shift 10 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 onconf shift 370 {default} reduce 88 State 370: (84) tcons ::= CHECK expr onconf * {default} reduce 84 State 371: tcons ::= FOREIGN * KEY LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt KEY shift 372 State 372: tcons ::= FOREIGN KEY * LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt LP shift 373 State 373: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW tcons ::= FOREIGN KEY LP * idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt idxlist ::= * idxlist COMMA idxitem idxlist ::= * idxitem idxitem ::= * nm sortorder ID shift 20 JOIN_KW shift 22 STRING shift 21 idxitem shift 272 idxlist shift 374 nm shift 270 State 374: tcons ::= FOREIGN KEY LP idxlist * RP REFERENCES nm idxlist_opt refargs defer_subclause_opt idxlist ::= idxlist * COMMA idxitem COMMA shift 268 RP shift 375 State 375: tcons ::= FOREIGN KEY LP idxlist RP * REFERENCES nm idxlist_opt refargs defer_subclause_opt REFERENCES shift 376 State 376: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW tcons ::= FOREIGN KEY LP idxlist RP REFERENCES * nm idxlist_opt refargs defer_subclause_opt ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 377 State 377: tcons ::= FOREIGN KEY LP idxlist RP REFERENCES nm * idxlist_opt refargs defer_subclause_opt (234) idxlist_opt ::= * idxlist_opt ::= * LP idxlist RP LP shift 321 idxlist_opt shift 378 {default} reduce 234 State 378: (61) refargs ::= * refargs ::= * refargs refarg tcons ::= FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt * refargs defer_subclause_opt refargs shift 379 {default} reduce 61 State 379: refargs ::= refargs * refarg refarg ::= * MATCH nm refarg ::= * ON DELETE refact refarg ::= * ON UPDATE refact refarg ::= * ON INSERT refact defer_subclause ::= * NOT DEFERRABLE init_deferred_pred_opt defer_subclause ::= * DEFERRABLE init_deferred_pred_opt tcons ::= FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt refargs * defer_subclause_opt (86) defer_subclause_opt ::= * defer_subclause_opt ::= * defer_subclause DEFERRABLE shift 327 MATCH shift 307 NOT shift 380 ON shift 309 defer_subclause shift 382 defer_subclause_opt shift 381 refarg shift 306 {default} reduce 86 State 380: defer_subclause ::= NOT * DEFERRABLE init_deferred_pred_opt DEFERRABLE shift 49 State 381: (85) tcons ::= FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt * {default} reduce 85 State 382: (87) defer_subclause_opt ::= defer_subclause * {default} reduce 87 State 383: (79) conslist ::= conslist tcons * {default} reduce 79 State 384: (80) conslist ::= tcons * {default} reduce 80 State 385: (22) columnlist ::= column * {default} reduce 22 State 386: create_table_args ::= AS * select select ::= * oneselect select ::= * select multiselect_op oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt SELECT shift 73 oneselect shift 69 select shift 387 State 387: (20) create_table_args ::= AS select * select ::= select * multiselect_op oneselect multiselect_op ::= * UNION multiselect_op ::= * UNION ALL multiselect_op ::= * INTERSECT multiselect_op ::= * EXCEPT EXCEPT shift 170 INTERSECT shift 169 SEMI reduce 20 UNION shift 167 multiselect_op shift 71 State 388: create_table ::= CREATE * temp TABLE nm temp ::= * TEMP (18) temp ::= * cmd ::= CREATE * temp VIEW nm AS select cmd ::= CREATE * temp uniqueflag INDEX nm ON nm dbnm LP idxlist RP onconf cmd ::= CREATE * trigger_decl BEGIN trigger_cmd_list END trigger_decl ::= * temp TRIGGER nm trigger_time trigger_event ON nm dbnm foreach_clause when_clause TEMP shift 434 temp shift 389 trigger_decl shift 435 {default} reduce 18 State 389: create_table ::= CREATE temp * TABLE nm cmd ::= CREATE temp * VIEW nm AS select cmd ::= CREATE temp * uniqueflag INDEX nm ON nm dbnm LP idxlist RP onconf uniqueflag ::= * UNIQUE (233) uniqueflag ::= * trigger_decl ::= temp * TRIGGER nm trigger_time trigger_event ON nm dbnm foreach_clause when_clause INDEX reduce 233 TABLE shift 390 TRIGGER shift 407 UNIQUE shift 406 VIEW shift 392 uniqueflag shift 396 State 390: create_table ::= CREATE temp TABLE * nm nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 391 State 391: (16) create_table ::= CREATE temp TABLE nm * {default} reduce 16 State 392: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= CREATE temp VIEW * nm AS select ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 393 State 393: cmd ::= CREATE temp VIEW nm * AS select AS shift 394 State 394: cmd ::= CREATE temp VIEW nm AS * select select ::= * oneselect select ::= * select multiselect_op oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt SELECT shift 73 oneselect shift 69 select shift 395 State 395: (98) cmd ::= CREATE temp VIEW nm AS select * select ::= select * multiselect_op oneselect multiselect_op ::= * UNION multiselect_op ::= * UNION ALL multiselect_op ::= * INTERSECT multiselect_op ::= * EXCEPT EXCEPT shift 170 INTERSECT shift 169 SEMI reduce 98 UNION shift 167 multiselect_op shift 71 State 396: cmd ::= CREATE temp uniqueflag * INDEX nm ON nm dbnm LP idxlist RP onconf INDEX shift 397 State 397: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= CREATE temp uniqueflag INDEX * nm ON nm dbnm LP idxlist RP onconf ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 398 State 398: cmd ::= CREATE temp uniqueflag INDEX nm * ON nm dbnm LP idxlist RP onconf ON shift 399 State 399: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= CREATE temp uniqueflag INDEX nm ON * nm dbnm LP idxlist RP onconf ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 400 State 400: (125) dbnm ::= * dbnm ::= * DOT nm cmd ::= CREATE temp uniqueflag INDEX nm ON nm * dbnm LP idxlist RP onconf DOT shift 275 LP reduce 125 dbnm shift 401 State 401: cmd ::= CREATE temp uniqueflag INDEX nm ON nm dbnm * LP idxlist RP onconf LP shift 402 State 402: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= CREATE temp uniqueflag INDEX nm ON nm dbnm LP * idxlist RP onconf idxlist ::= * idxlist COMMA idxitem idxlist ::= * idxitem idxitem ::= * nm sortorder ID shift 20 JOIN_KW shift 22 STRING shift 21 idxitem shift 272 idxlist shift 403 nm shift 270 State 403: cmd ::= CREATE temp uniqueflag INDEX nm ON nm dbnm LP idxlist * RP onconf idxlist ::= idxlist * COMMA idxitem COMMA shift 268 RP shift 404 State 404: (88) onconf ::= * onconf ::= * ON CONFLICT resolvetype cmd ::= CREATE temp uniqueflag INDEX nm ON nm dbnm LP idxlist RP * onconf ON shift 10 SEMI reduce 88 onconf shift 405 State 405: (231) cmd ::= CREATE temp uniqueflag INDEX nm ON nm dbnm LP idxlist RP onconf * SEMI reduce 231 State 406: (232) uniqueflag ::= UNIQUE * INDEX reduce 232 State 407: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW trigger_decl ::= temp TRIGGER * nm trigger_time trigger_event ON nm dbnm foreach_clause when_clause ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 408 State 408: trigger_decl ::= temp TRIGGER nm * trigger_time trigger_event ON nm dbnm foreach_clause when_clause trigger_time ::= * BEFORE trigger_time ::= * AFTER trigger_time ::= * INSTEAD OF (261) trigger_time ::= * AFTER shift 431 BEFORE shift 430 INSTEAD shift 432 trigger_time shift 409 {default} reduce 261 State 409: trigger_decl ::= temp TRIGGER nm trigger_time * trigger_event ON nm dbnm foreach_clause when_clause trigger_event ::= * DELETE trigger_event ::= * INSERT trigger_event ::= * UPDATE trigger_event ::= * UPDATE OF inscollist DELETE shift 422 INSERT shift 423 UPDATE shift 424 trigger_event shift 410 State 410: trigger_decl ::= temp TRIGGER nm trigger_time trigger_event * ON nm dbnm foreach_clause when_clause ON shift 411 State 411: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW trigger_decl ::= temp TRIGGER nm trigger_time trigger_event ON * nm dbnm foreach_clause when_clause ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 412 State 412: (125) dbnm ::= * dbnm ::= * DOT nm trigger_decl ::= temp TRIGGER nm trigger_time trigger_event ON nm * dbnm foreach_clause when_clause DOT shift 275 dbnm shift 413 {default} reduce 125 State 413: trigger_decl ::= temp TRIGGER nm trigger_time trigger_event ON nm dbnm * foreach_clause when_clause (266) foreach_clause ::= * foreach_clause ::= * FOR EACH ROW foreach_clause ::= * FOR EACH STATEMENT FOR shift 418 foreach_clause shift 414 {default} reduce 266 State 414: trigger_decl ::= temp TRIGGER nm trigger_time trigger_event ON nm dbnm foreach_clause * when_clause (269) when_clause ::= * when_clause ::= * WHEN expr BEGIN reduce 269 WHEN shift 416 when_clause shift 415 State 415: (257) trigger_decl ::= temp TRIGGER nm trigger_time trigger_event ON nm dbnm foreach_clause when_clause * BEGIN reduce 257 State 416: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END when_clause ::= WHEN * expr expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 417 nm shift 107 State 417: expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP (270) when_clause ::= WHEN expr * AND shift 105 BEGIN reduce 270 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 State 418: foreach_clause ::= FOR * EACH ROW foreach_clause ::= FOR * EACH STATEMENT EACH shift 419 State 419: foreach_clause ::= FOR EACH * ROW foreach_clause ::= FOR EACH * STATEMENT ROW shift 420 STATEMENT shift 421 State 420: (267) foreach_clause ::= FOR EACH ROW * {default} reduce 267 State 421: (268) foreach_clause ::= FOR EACH STATEMENT * {default} reduce 268 State 422: (262) trigger_event ::= DELETE * ON reduce 262 State 423: (263) trigger_event ::= INSERT * ON reduce 263 State 424: (264) trigger_event ::= UPDATE * trigger_event ::= UPDATE * OF inscollist OF shift 425 ON reduce 264 State 425: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW inscollist ::= * inscollist COMMA nm inscollist ::= * nm trigger_event ::= UPDATE OF * inscollist ID shift 20 JOIN_KW shift 22 STRING shift 21 inscollist shift 426 nm shift 429 State 426: inscollist ::= inscollist * COMMA nm (265) trigger_event ::= UPDATE OF inscollist * COMMA shift 427 ON reduce 265 State 427: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW inscollist ::= inscollist COMMA * nm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 428 State 428: (168) inscollist ::= inscollist COMMA nm * {default} reduce 168 State 429: (169) inscollist ::= nm * {default} reduce 169 State 430: (258) trigger_time ::= BEFORE * {default} reduce 258 State 431: (259) trigger_time ::= AFTER * {default} reduce 259 State 432: trigger_time ::= INSTEAD * OF OF shift 433 State 433: (260) trigger_time ::= INSTEAD OF * {default} reduce 260 State 434: (17) temp ::= TEMP * {default} reduce 17 State 435: cmd ::= CREATE trigger_decl * BEGIN trigger_cmd_list END BEGIN shift 436 State 436: select ::= * oneselect select ::= * select multiselect_op oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt cmd ::= CREATE trigger_decl BEGIN * trigger_cmd_list END trigger_cmd_list ::= * trigger_cmd SEMI trigger_cmd_list (272) trigger_cmd_list ::= * trigger_cmd ::= * UPDATE orconf nm SET setlist where_opt trigger_cmd ::= * INSERT orconf INTO nm inscollist_opt VALUES LP itemlist RP trigger_cmd ::= * INSERT orconf INTO nm inscollist_opt select trigger_cmd ::= * DELETE FROM nm where_opt trigger_cmd ::= * select DELETE shift 474 END reduce 272 INSERT shift 458 SELECT shift 73 UPDATE shift 443 oneselect shift 69 select shift 437 trigger_cmd shift 440 trigger_cmd_list shift 438 State 437: select ::= select * multiselect_op oneselect multiselect_op ::= * UNION multiselect_op ::= * UNION ALL multiselect_op ::= * INTERSECT multiselect_op ::= * EXCEPT (277) trigger_cmd ::= select * EXCEPT shift 170 INTERSECT shift 169 SEMI reduce 277 UNION shift 167 multiselect_op shift 71 State 438: cmd ::= CREATE trigger_decl BEGIN trigger_cmd_list * END END shift 439 State 439: (256) cmd ::= CREATE trigger_decl BEGIN trigger_cmd_list END * SEMI reduce 256 State 440: trigger_cmd_list ::= trigger_cmd * SEMI trigger_cmd_list SEMI shift 441 State 441: select ::= * oneselect select ::= * select multiselect_op oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt trigger_cmd_list ::= * trigger_cmd SEMI trigger_cmd_list trigger_cmd_list ::= trigger_cmd SEMI * trigger_cmd_list (272) trigger_cmd_list ::= * trigger_cmd ::= * UPDATE orconf nm SET setlist where_opt trigger_cmd ::= * INSERT orconf INTO nm inscollist_opt VALUES LP itemlist RP trigger_cmd ::= * INSERT orconf INTO nm inscollist_opt select trigger_cmd ::= * DELETE FROM nm where_opt trigger_cmd ::= * select DELETE shift 474 END reduce 272 INSERT shift 458 SELECT shift 73 UPDATE shift 443 oneselect shift 69 select shift 437 trigger_cmd shift 440 trigger_cmd_list shift 442 State 442: (271) trigger_cmd_list ::= trigger_cmd SEMI trigger_cmd_list * END reduce 271 State 443: (90) orconf ::= * orconf ::= * OR resolvetype trigger_cmd ::= UPDATE * orconf nm SET setlist where_opt OR shift 444 orconf shift 446 {default} reduce 90 State 444: orconf ::= OR * resolvetype resolvetype ::= * ROLLBACK resolvetype ::= * ABORT resolvetype ::= * FAIL resolvetype ::= * IGNORE resolvetype ::= * REPLACE ABORT shift 14 FAIL shift 15 IGNORE shift 16 REPLACE shift 17 ROLLBACK shift 13 resolvetype shift 445 State 445: (91) orconf ::= OR resolvetype * {default} reduce 91 State 446: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW trigger_cmd ::= UPDATE orconf * nm SET setlist where_opt ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 447 State 447: trigger_cmd ::= UPDATE orconf nm * SET setlist where_opt SET shift 448 State 448: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW setlist ::= * setlist COMMA nm EQ expr setlist ::= * nm EQ expr trigger_cmd ::= UPDATE orconf nm SET * setlist where_opt ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 455 setlist shift 449 State 449: (155) where_opt ::= * where_opt ::= * WHERE expr setlist ::= setlist * COMMA nm EQ expr trigger_cmd ::= UPDATE orconf nm SET setlist * where_opt COMMA shift 450 SEMI reduce 155 WHERE shift 239 where_opt shift 454 State 450: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW setlist ::= setlist COMMA * nm EQ expr ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 451 State 451: setlist ::= setlist COMMA nm * EQ expr EQ shift 452 State 452: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW setlist ::= setlist COMMA nm EQ * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 453 nm shift 107 State 453: (158) setlist ::= setlist COMMA nm EQ expr * expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 158 State 454: (273) trigger_cmd ::= UPDATE orconf nm SET setlist where_opt * SEMI reduce 273 State 455: setlist ::= nm * EQ expr EQ shift 456 State 456: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW setlist ::= nm EQ * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 457 nm shift 107 State 457: (159) setlist ::= nm EQ expr * expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 159 State 458: (90) orconf ::= * orconf ::= * OR resolvetype trigger_cmd ::= INSERT * orconf INTO nm inscollist_opt VALUES LP itemlist RP trigger_cmd ::= INSERT * orconf INTO nm inscollist_opt select INTO reduce 90 OR shift 444 orconf shift 459 State 459: trigger_cmd ::= INSERT orconf * INTO nm inscollist_opt VALUES LP itemlist RP trigger_cmd ::= INSERT orconf * INTO nm inscollist_opt select INTO shift 460 State 460: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW trigger_cmd ::= INSERT orconf INTO * nm inscollist_opt VALUES LP itemlist RP trigger_cmd ::= INSERT orconf INTO * nm inscollist_opt select ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 461 State 461: (166) inscollist_opt ::= * inscollist_opt ::= * LP inscollist RP trigger_cmd ::= INSERT orconf INTO nm * inscollist_opt VALUES LP itemlist RP trigger_cmd ::= INSERT orconf INTO nm * inscollist_opt select LP shift 462 inscollist_opt shift 465 {default} reduce 166 State 462: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW inscollist_opt ::= LP * inscollist RP inscollist ::= * inscollist COMMA nm inscollist ::= * nm ID shift 20 JOIN_KW shift 22 STRING shift 21 inscollist shift 463 nm shift 429 State 463: inscollist_opt ::= LP inscollist * RP inscollist ::= inscollist * COMMA nm COMMA shift 427 RP shift 464 State 464: (167) inscollist_opt ::= LP inscollist RP * {default} reduce 167 State 465: select ::= * oneselect select ::= * select multiselect_op oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt trigger_cmd ::= INSERT orconf INTO nm inscollist_opt * VALUES LP itemlist RP trigger_cmd ::= INSERT orconf INTO nm inscollist_opt * select SELECT shift 73 VALUES shift 467 oneselect shift 69 select shift 466 State 466: select ::= select * multiselect_op oneselect multiselect_op ::= * UNION multiselect_op ::= * UNION ALL multiselect_op ::= * INTERSECT multiselect_op ::= * EXCEPT (275) trigger_cmd ::= INSERT orconf INTO nm inscollist_opt select * EXCEPT shift 170 INTERSECT shift 169 SEMI reduce 275 UNION shift 167 multiselect_op shift 71 State 467: trigger_cmd ::= INSERT orconf INTO nm inscollist_opt VALUES * LP itemlist RP LP shift 468 State 468: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW itemlist ::= * itemlist COMMA expr itemlist ::= * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END trigger_cmd ::= INSERT orconf INTO nm inscollist_opt VALUES LP * itemlist RP expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 473 itemlist shift 469 nm shift 107 State 469: itemlist ::= itemlist * COMMA expr trigger_cmd ::= INSERT orconf INTO nm inscollist_opt VALUES LP itemlist * RP COMMA shift 470 RP shift 472 State 470: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW itemlist ::= itemlist COMMA * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 471 nm shift 107 State 471: (164) itemlist ::= itemlist COMMA expr * expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 164 State 472: (274) trigger_cmd ::= INSERT orconf INTO nm inscollist_opt VALUES LP itemlist RP * SEMI reduce 274 State 473: (165) itemlist ::= expr * expr ::= expr * ORACLE_OUTER_JOIN expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * BITAND expr expr ::= expr * BITOR expr expr ::= expr * LSHIFT expr expr ::= expr * RSHIFT expr expr ::= expr * likeop expr expr ::= expr * NOT likeop expr likeop ::= * LIKE likeop ::= * GLOB expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * REM expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * IS NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 105 BETWEEN shift 160 BITAND shift 127 BITOR shift 129 CONCAT shift 152 EQ shift 125 GE shift 121 GLOB shift 141 GT shift 117 IN shift 164 IS shift 155 ISNULL shift 154 LE shift 119 LIKE shift 140 LSHIFT shift 131 LT shift 115 MINUS shift 144 NE shift 123 NOT shift 137 NOTNULL shift 159 OR shift 113 ORACLE_OUTER_JOIN shift 104 PLUS shift 142 REM shift 150 RSHIFT shift 133 SLASH shift 148 STAR shift 146 likeop shift 135 {default} reduce 165 State 474: trigger_cmd ::= DELETE * FROM nm where_opt FROM shift 475 State 475: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW trigger_cmd ::= DELETE FROM * nm where_opt ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 476 State 476: (155) where_opt ::= * where_opt ::= * WHERE expr trigger_cmd ::= DELETE FROM nm * where_opt SEMI reduce 155 WHERE shift 239 where_opt shift 477 State 477: (276) trigger_cmd ::= DELETE FROM nm where_opt * SEMI reduce 276 State 478: cmd ::= DROP * TABLE nm cmd ::= DROP * VIEW nm cmd ::= DROP * INDEX nm dbnm cmd ::= DROP * TRIGGER nm dbnm INDEX shift 483 TABLE shift 479 TRIGGER shift 486 VIEW shift 481 State 479: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= DROP TABLE * nm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 480 State 480: (97) cmd ::= DROP TABLE nm * SEMI reduce 97 State 481: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= DROP VIEW * nm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 482 State 482: (99) cmd ::= DROP VIEW nm * SEMI reduce 99 State 483: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= DROP INDEX * nm dbnm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 484 State 484: (125) dbnm ::= * dbnm ::= * DOT nm cmd ::= DROP INDEX nm * dbnm DOT shift 275 SEMI reduce 125 dbnm shift 485 State 485: (239) cmd ::= DROP INDEX nm dbnm * SEMI reduce 239 State 486: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= DROP TRIGGER * nm dbnm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 487 State 487: (125) dbnm ::= * dbnm ::= * DOT nm cmd ::= DROP TRIGGER nm * dbnm DOT shift 275 SEMI reduce 125 dbnm shift 488 State 488: (282) cmd ::= DROP TRIGGER nm dbnm * SEMI reduce 282 State 489: (100) cmd ::= select * select ::= select * multiselect_op oneselect multiselect_op ::= * UNION multiselect_op ::= * UNION ALL multiselect_op ::= * INTERSECT multiselect_op ::= * EXCEPT EXCEPT shift 170 INTERSECT shift 169 SEMI reduce 100 UNION shift 167 multiselect_op shift 71 State 490: cmd ::= DELETE * FROM nm dbnm where_opt FROM shift 491 State 491: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= DELETE FROM * nm dbnm where_opt ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 492 State 492: (125) dbnm ::= * dbnm ::= * DOT nm cmd ::= DELETE FROM nm * dbnm where_opt DOT shift 275 dbnm shift 493 {default} reduce 125 State 493: cmd ::= DELETE FROM nm dbnm * where_opt (155) where_opt ::= * where_opt ::= * WHERE expr SEMI reduce 155 WHERE shift 239 where_opt shift 494 State 494: (154) cmd ::= DELETE FROM nm dbnm where_opt * SEMI reduce 154 State 495: (90) orconf ::= * orconf ::= * OR resolvetype cmd ::= UPDATE * orconf nm dbnm SET setlist where_opt OR shift 444 orconf shift 496 {default} reduce 90 State 496: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= UPDATE orconf * nm dbnm SET setlist where_opt ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 497 State 497: (125) dbnm ::= * dbnm ::= * DOT nm cmd ::= UPDATE orconf nm * dbnm SET setlist where_opt DOT shift 275 SET reduce 125 dbnm shift 498 State 498: cmd ::= UPDATE orconf nm dbnm * SET setlist where_opt SET shift 499 State 499: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= UPDATE orconf nm dbnm SET * setlist where_opt setlist ::= * setlist COMMA nm EQ expr setlist ::= * nm EQ expr ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 455 setlist shift 500 State 500: (155) where_opt ::= * where_opt ::= * WHERE expr cmd ::= UPDATE orconf nm dbnm SET setlist * where_opt setlist ::= setlist * COMMA nm EQ expr COMMA shift 450 SEMI reduce 155 WHERE shift 239 where_opt shift 501 State 501: (157) cmd ::= UPDATE orconf nm dbnm SET setlist where_opt * SEMI reduce 157 State 502: cmd ::= insert_cmd * INTO nm dbnm inscollist_opt VALUES LP itemlist RP cmd ::= insert_cmd * INTO nm dbnm inscollist_opt select INTO shift 503 State 503: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= insert_cmd INTO * nm dbnm inscollist_opt VALUES LP itemlist RP cmd ::= insert_cmd INTO * nm dbnm inscollist_opt select ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 504 State 504: (125) dbnm ::= * dbnm ::= * DOT nm cmd ::= insert_cmd INTO nm * dbnm inscollist_opt VALUES LP itemlist RP cmd ::= insert_cmd INTO nm * dbnm inscollist_opt select DOT shift 275 dbnm shift 505 {default} reduce 125 State 505: cmd ::= insert_cmd INTO nm dbnm * inscollist_opt VALUES LP itemlist RP cmd ::= insert_cmd INTO nm dbnm * inscollist_opt select (166) inscollist_opt ::= * inscollist_opt ::= * LP inscollist RP LP shift 462 inscollist_opt shift 506 {default} reduce 166 State 506: select ::= * oneselect select ::= * select multiselect_op oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt cmd ::= insert_cmd INTO nm dbnm inscollist_opt * VALUES LP itemlist RP cmd ::= insert_cmd INTO nm dbnm inscollist_opt * select SELECT shift 73 VALUES shift 508 oneselect shift 69 select shift 507 State 507: select ::= select * multiselect_op oneselect multiselect_op ::= * UNION multiselect_op ::= * UNION ALL multiselect_op ::= * INTERSECT multiselect_op ::= * EXCEPT (161) cmd ::= insert_cmd INTO nm dbnm inscollist_opt select * EXCEPT shift 170 INTERSECT shift 169 SEMI reduce 161 UNION shift 167 multiselect_op shift 71 State 508: cmd ::= insert_cmd INTO nm dbnm inscollist_opt VALUES * LP itemlist RP LP shift 509 State 509: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= insert_cmd INTO nm dbnm inscollist_opt VALUES LP * itemlist RP itemlist ::= * itemlist COMMA expr itemlist ::= * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * ID expr ::= * JOIN_KW expr ::= * nm DOT nm expr ::= * nm DOT nm DOT nm expr ::= * expr ORACLE_OUTER_JOIN expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr BITAND expr expr ::= * expr BITOR expr expr ::= * expr LSHIFT expr expr ::= * expr RSHIFT expr expr ::= * expr likeop expr expr ::= * expr NOT likeop expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr REM expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * expr IS NOT NULL expr ::= * NOT expr expr ::= * BITNOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP expr ::= * CASE case_operand case_exprlist case_else END expr ::= * RAISE LP IGNORE RP expr ::= * RAISE LP ROLLBACK COMMA nm RP expr ::= * RAISE LP ABORT COMMA nm RP expr ::= * RAISE LP FAIL COMMA nm RP BITNOT shift 177 CASE shift 183 FLOAT shift 174 ID shift 64 INTEGER shift 173 JOIN_KW shift 67 LP shift 68 MINUS shift 179 NOT shift 175 NULL shift 106 PLUS shift 181 RAISE shift 193 STRING shift 66 expr shift 473 itemlist shift 510 nm shift 107 State 510: cmd ::= insert_cmd INTO nm dbnm inscollist_opt VALUES LP itemlist * RP itemlist ::= itemlist * COMMA expr COMMA shift 470 RP shift 511 State 511: (160) cmd ::= insert_cmd INTO nm dbnm inscollist_opt VALUES LP itemlist RP * SEMI reduce 160 State 512: (90) orconf ::= * orconf ::= * OR resolvetype insert_cmd ::= INSERT * orconf INTO reduce 90 OR shift 444 orconf shift 513 State 513: (162) insert_cmd ::= INSERT orconf * INTO reduce 162 State 514: (163) insert_cmd ::= REPLACE * INTO reduce 163 State 515: (90) orconf ::= * orconf ::= * OR resolvetype cmd ::= COPY * orconf nm dbnm FROM nm USING DELIMITERS STRING cmd ::= COPY * orconf nm dbnm FROM nm OR shift 444 orconf shift 516 {default} reduce 90 State 516: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= COPY orconf * nm dbnm FROM nm USING DELIMITERS STRING cmd ::= COPY orconf * nm dbnm FROM nm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 517 State 517: (125) dbnm ::= * dbnm ::= * DOT nm cmd ::= COPY orconf nm * dbnm FROM nm USING DELIMITERS STRING cmd ::= COPY orconf nm * dbnm FROM nm DOT shift 275 FROM reduce 125 dbnm shift 518 State 518: cmd ::= COPY orconf nm dbnm * FROM nm USING DELIMITERS STRING cmd ::= COPY orconf nm dbnm * FROM nm FROM shift 519 State 519: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= COPY orconf nm dbnm FROM * nm USING DELIMITERS STRING cmd ::= COPY orconf nm dbnm FROM * nm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 520 State 520: cmd ::= COPY orconf nm dbnm FROM nm * USING DELIMITERS STRING (241) cmd ::= COPY orconf nm dbnm FROM nm * SEMI reduce 241 USING shift 521 State 521: cmd ::= COPY orconf nm dbnm FROM nm USING * DELIMITERS STRING DELIMITERS shift 522 State 522: cmd ::= COPY orconf nm dbnm FROM nm USING DELIMITERS * STRING STRING shift 523 State 523: (240) cmd ::= COPY orconf nm dbnm FROM nm USING DELIMITERS STRING * SEMI reduce 240 State 524: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW (242) cmd ::= VACUUM * cmd ::= VACUUM * nm ID shift 20 JOIN_KW shift 22 SEMI reduce 242 STRING shift 21 nm shift 525 State 525: (243) cmd ::= VACUUM nm * SEMI reduce 243 State 526: ids ::= * ID ids ::= * STRING cmd ::= PRAGMA * ids EQ nm cmd ::= PRAGMA * ids EQ ON cmd ::= PRAGMA * ids EQ plus_num cmd ::= PRAGMA * ids EQ minus_num cmd ::= PRAGMA * ids LP nm RP cmd ::= PRAGMA * ids ID shift 256 STRING shift 257 ids shift 527 State 527: cmd ::= PRAGMA ids * EQ nm cmd ::= PRAGMA ids * EQ ON cmd ::= PRAGMA ids * EQ plus_num cmd ::= PRAGMA ids * EQ minus_num cmd ::= PRAGMA ids * LP nm RP (249) cmd ::= PRAGMA ids * EQ shift 528 LP shift 540 SEMI reduce 249 State 528: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= PRAGMA ids EQ * nm cmd ::= PRAGMA ids EQ * ON cmd ::= PRAGMA ids EQ * plus_num cmd ::= PRAGMA ids EQ * minus_num plus_num ::= * plus_opt number minus_num ::= * MINUS number plus_opt ::= * PLUS (255) plus_opt ::= * ID shift 20 JOIN_KW shift 22 MINUS shift 537 ON shift 530 PLUS shift 539 STRING shift 21 minus_num shift 532 nm shift 529 plus_num shift 531 plus_opt shift 533 {default} reduce 255 State 529: (244) cmd ::= PRAGMA ids EQ nm * SEMI reduce 244 State 530: (245) cmd ::= PRAGMA ids EQ ON * SEMI reduce 245 State 531: (246) cmd ::= PRAGMA ids EQ plus_num * SEMI reduce 246 State 532: (247) cmd ::= PRAGMA ids EQ minus_num * SEMI reduce 247 State 533: plus_num ::= plus_opt * number number ::= * INTEGER number ::= * FLOAT FLOAT shift 536 INTEGER shift 535 number shift 534 State 534: (250) plus_num ::= plus_opt number * SEMI reduce 250 State 535: (252) number ::= INTEGER * SEMI reduce 252 State 536: (253) number ::= FLOAT * SEMI reduce 253 State 537: minus_num ::= MINUS * number number ::= * INTEGER number ::= * FLOAT FLOAT shift 536 INTEGER shift 535 number shift 538 State 538: (251) minus_num ::= MINUS number * SEMI reduce 251 State 539: (254) plus_opt ::= PLUS * {default} reduce 254 State 540: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= PRAGMA ids LP * nm RP ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 541 State 541: cmd ::= PRAGMA ids LP nm * RP RP shift 542 State 542: (248) cmd ::= PRAGMA ids LP nm RP * SEMI reduce 248 State 543: cmd ::= ATTACH * database_kw_opt ids AS nm database_kw_opt ::= * DATABASE (285) database_kw_opt ::= * DATABASE shift 548 database_kw_opt shift 544 {default} reduce 285 State 544: ids ::= * ID ids ::= * STRING cmd ::= ATTACH database_kw_opt * ids AS nm ID shift 256 STRING shift 257 ids shift 545 State 545: cmd ::= ATTACH database_kw_opt ids * AS nm AS shift 546 State 546: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= ATTACH database_kw_opt ids AS * nm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 547 State 547: (283) cmd ::= ATTACH database_kw_opt ids AS nm * SEMI reduce 283 State 548: (284) database_kw_opt ::= DATABASE * {default} reduce 284 State 549: database_kw_opt ::= * DATABASE (285) database_kw_opt ::= * cmd ::= DETACH * database_kw_opt nm DATABASE shift 548 database_kw_opt shift 550 {default} reduce 285 State 550: nm ::= * ID nm ::= * STRING nm ::= * JOIN_KW cmd ::= DETACH database_kw_opt * nm ID shift 20 JOIN_KW shift 22 STRING shift 21 nm shift 551 State 551: (286) cmd ::= DETACH database_kw_opt nm * SEMI reduce 286 State 552: (4) ecmd ::= SEMI * {default} reduce 4 State 553: (6) explain ::= EXPLAIN * {default} reduce 6 State 554: (1) cmdlist ::= ecmd * {default} reduce 1