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