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