State 0: input ::= * cmdlist cmdlist ::= * ecmd cmdlist ::= * cmdlist SEMI ecmd ecmd ::= * explain cmd ecmd ::= * cmd (5) ecmd ::= * explain ::= * EXPLAIN cmd ::= * BEGIN 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 ids cmd ::= * DROP TABLE ids cmd ::= * select select ::= * oneselect select ::= * select joinop oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt cmd ::= * DELETE FROM ids where_opt cmd ::= * UPDATE ids SET setlist where_opt cmd ::= * INSERT INTO ids inscollist_opt VALUES LP itemlist RP cmd ::= * INSERT INTO ids inscollist_opt select cmd ::= * CREATE uniqueflag INDEX ids ON ids LP idxlist RP cmd ::= * DROP INDEX ids cmd ::= * COPY ids FROM ids USING DELIMITERS STRING cmd ::= * COPY ids FROM ids cmd ::= * VACUUM cmd ::= * VACUUM ids cmd ::= * PRAGMA ids EQ ids cmd ::= * PRAGMA ids EQ ON cmd ::= * PRAGMA ids EQ plus_num cmd ::= * PRAGMA ids EQ minus_num cmd ::= * PRAGMA ids LP ids RP BEGIN shift 6 COMMIT shift 23 COPY shift 307 CREATE shift 243 DELETE shift 263 DROP shift 257 END shift 25 EXPLAIN shift 334 INSERT shift 279 PRAGMA shift 316 ROLLBACK shift 27 SELECT shift 63 UPDATE shift 267 VACUUM shift 314 cmd shift 333 cmdlist shift 1 create_table shift 29 ecmd shift 335 explain shift 4 input accept oneselect shift 59 select shift 262 {default} reduce 5 State 1: (0) input ::= cmdlist * cmdlist ::= cmdlist * SEMI ecmd $ reduce 0 SEMI shift 2 State 2: cmdlist ::= cmdlist SEMI * ecmd ecmd ::= * explain cmd ecmd ::= * cmd (5) ecmd ::= * explain ::= * EXPLAIN cmd ::= * BEGIN 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 ids cmd ::= * DROP TABLE ids cmd ::= * select select ::= * oneselect select ::= * select joinop oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt cmd ::= * DELETE FROM ids where_opt cmd ::= * UPDATE ids SET setlist where_opt cmd ::= * INSERT INTO ids inscollist_opt VALUES LP itemlist RP cmd ::= * INSERT INTO ids inscollist_opt select cmd ::= * CREATE uniqueflag INDEX ids ON ids LP idxlist RP cmd ::= * DROP INDEX ids cmd ::= * COPY ids FROM ids USING DELIMITERS STRING cmd ::= * COPY ids FROM ids cmd ::= * VACUUM cmd ::= * VACUUM ids cmd ::= * PRAGMA ids EQ ids cmd ::= * PRAGMA ids EQ ON cmd ::= * PRAGMA ids EQ plus_num cmd ::= * PRAGMA ids EQ minus_num cmd ::= * PRAGMA ids LP ids RP BEGIN shift 6 COMMIT shift 23 COPY shift 307 CREATE shift 243 DELETE shift 263 DROP shift 257 END shift 25 EXPLAIN shift 334 INSERT shift 279 PRAGMA shift 316 ROLLBACK shift 27 SELECT shift 63 UPDATE shift 267 VACUUM shift 314 cmd shift 333 create_table shift 29 ecmd shift 3 explain shift 4 oneselect shift 59 select shift 262 {default} reduce 5 State 3: (2) cmdlist ::= cmdlist SEMI ecmd * {default} reduce 2 State 4: ecmd ::= explain * cmd cmd ::= * BEGIN 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 ids cmd ::= * DROP TABLE ids cmd ::= * select select ::= * oneselect select ::= * select joinop oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt cmd ::= * DELETE FROM ids where_opt cmd ::= * UPDATE ids SET setlist where_opt cmd ::= * INSERT INTO ids inscollist_opt VALUES LP itemlist RP cmd ::= * INSERT INTO ids inscollist_opt select cmd ::= * CREATE uniqueflag INDEX ids ON ids LP idxlist RP cmd ::= * DROP INDEX ids cmd ::= * COPY ids FROM ids USING DELIMITERS STRING cmd ::= * COPY ids FROM ids cmd ::= * VACUUM cmd ::= * VACUUM ids cmd ::= * PRAGMA ids EQ ids cmd ::= * PRAGMA ids EQ ON cmd ::= * PRAGMA ids EQ plus_num cmd ::= * PRAGMA ids EQ minus_num cmd ::= * PRAGMA ids LP ids RP BEGIN shift 6 COMMIT shift 23 COPY shift 307 CREATE shift 243 DELETE shift 263 DROP shift 257 END shift 25 INSERT shift 279 PRAGMA shift 316 ROLLBACK shift 27 SELECT shift 63 UPDATE shift 267 VACUUM shift 314 cmd shift 5 create_table shift 29 oneselect shift 59 select shift 262 State 5: (3) ecmd ::= explain cmd * {default} reduce 3 State 6: cmd ::= BEGIN * trans_opt (8) trans_opt ::= * trans_opt ::= * TRANSACTION trans_opt ::= * TRANSACTION ids TRANSACTION shift 8 trans_opt shift 7 {default} reduce 8 State 7: (7) cmd ::= BEGIN trans_opt * {default} reduce 7 State 8: (9) trans_opt ::= TRANSACTION * trans_opt ::= TRANSACTION * ids id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 9 {default} reduce 9 State 9: (10) trans_opt ::= TRANSACTION ids * {default} reduce 10 State 10: (23) id ::= DESC * {default} reduce 23 State 11: (24) id ::= ASC * {default} reduce 24 State 12: (25) id ::= DELIMITERS * {default} reduce 25 State 13: (26) id ::= EXPLAIN * {default} reduce 26 State 14: (27) id ::= VACUUM * {default} reduce 27 State 15: (28) id ::= BEGIN * {default} reduce 28 State 16: (29) id ::= END * {default} reduce 29 State 17: (30) id ::= PRAGMA * {default} reduce 30 State 18: (31) id ::= CLUSTER * {default} reduce 31 State 19: (32) id ::= ID * {default} reduce 32 State 20: (33) id ::= TEMP * {default} reduce 33 State 21: (34) ids ::= id * {default} reduce 34 State 22: (35) ids ::= STRING * {default} reduce 35 State 23: (8) trans_opt ::= * trans_opt ::= * TRANSACTION trans_opt ::= * TRANSACTION ids cmd ::= COMMIT * trans_opt TRANSACTION shift 8 trans_opt shift 24 {default} reduce 8 State 24: (11) cmd ::= COMMIT trans_opt * {default} reduce 11 State 25: (8) trans_opt ::= * trans_opt ::= * TRANSACTION trans_opt ::= * TRANSACTION ids cmd ::= END * trans_opt TRANSACTION shift 8 trans_opt shift 26 {default} reduce 8 State 26: (12) cmd ::= END trans_opt * {default} reduce 12 State 27: (8) trans_opt ::= * trans_opt ::= * TRANSACTION trans_opt ::= * TRANSACTION ids cmd ::= ROLLBACK * trans_opt TRANSACTION shift 8 trans_opt shift 28 {default} reduce 8 State 28: (13) cmd ::= ROLLBACK trans_opt * {default} reduce 13 State 29: cmd ::= create_table * create_table_args create_table_args ::= * LP columnlist conslist_opt RP LP shift 31 create_table_args shift 30 State 30: (14) cmd ::= create_table create_table_args * {default} reduce 14 State 31: create_table_args ::= LP * columnlist conslist_opt RP columnlist ::= * columnlist COMMA column columnlist ::= * column column ::= * columnid type carglist columnid ::= * ids id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 column shift 242 columnid shift 37 columnlist shift 32 id shift 21 ids shift 219 State 32: create_table_args ::= LP columnlist * conslist_opt RP columnlist ::= columnlist * COMMA column (62) conslist_opt ::= * conslist_opt ::= * COMMA conslist COMMA shift 35 RP reduce 62 conslist_opt shift 33 State 33: create_table_args ::= LP columnlist conslist_opt * RP RP shift 34 State 34: (18) create_table_args ::= LP columnlist conslist_opt RP * {default} reduce 18 State 35: columnlist ::= columnlist COMMA * column column ::= * columnid type carglist columnid ::= * ids id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING conslist_opt ::= COMMA * conslist conslist ::= * conslist COMMA tcons conslist ::= * conslist tcons conslist ::= * tcons tcons ::= * CONSTRAINT ids tcons ::= * PRIMARY KEY LP idxlist RP tcons ::= * UNIQUE LP idxlist RP tcons ::= * CHECK expr ASC shift 11 BEGIN shift 15 CHECK shift 238 CLUSTER shift 18 CONSTRAINT shift 223 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 PRIMARY shift 225 STRING shift 22 TEMP shift 20 UNIQUE shift 234 VACUUM shift 14 column shift 36 columnid shift 37 conslist shift 220 id shift 21 ids shift 219 tcons shift 241 State 36: (19) columnlist ::= columnlist COMMA column * {default} reduce 19 State 37: column ::= columnid * type carglist id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING (36) type ::= * type ::= * typename type ::= * typename LP signed RP type ::= * typename LP signed COMMA signed RP typename ::= * ids typename ::= * typename ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 218 type shift 38 typename shift 205 {default} reduce 36 State 38: column ::= columnid type * carglist carglist ::= * carglist carg (46) carglist ::= * carglist shift 39 {default} reduce 46 State 39: (21) column ::= columnid type carglist * carglist ::= carglist * carg carg ::= * CONSTRAINT ids ccons carg ::= * ccons carg ::= * DEFAULT STRING carg ::= * DEFAULT ID carg ::= * DEFAULT INTEGER carg ::= * DEFAULT PLUS INTEGER carg ::= * DEFAULT MINUS INTEGER carg ::= * DEFAULT FLOAT carg ::= * DEFAULT PLUS FLOAT carg ::= * DEFAULT MINUS FLOAT carg ::= * DEFAULT NULL ccons ::= * NOT NULL ccons ::= * PRIMARY KEY sortorder ccons ::= * UNIQUE ccons ::= * CHECK LP expr RP CHECK shift 52 CONSTRAINT shift 41 DEFAULT shift 193 NOT shift 44 PRIMARY shift 46 UNIQUE shift 51 carg shift 40 ccons shift 192 {default} reduce 21 State 40: (45) carglist ::= carglist carg * {default} reduce 45 State 41: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING carg ::= CONSTRAINT * ids ccons ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 42 State 42: carg ::= CONSTRAINT ids * ccons ccons ::= * NOT NULL ccons ::= * PRIMARY KEY sortorder ccons ::= * UNIQUE ccons ::= * CHECK LP expr RP CHECK shift 52 NOT shift 44 PRIMARY shift 46 UNIQUE shift 51 ccons shift 43 State 43: (47) carg ::= CONSTRAINT ids ccons * {default} reduce 47 State 44: ccons ::= NOT * NULL NULL shift 45 State 45: (58) ccons ::= NOT NULL * {default} reduce 58 State 46: ccons ::= PRIMARY * KEY sortorder KEY shift 47 State 47: ccons ::= PRIMARY KEY * sortorder sortorder ::= * ASC sortorder ::= * DESC (102) sortorder ::= * ASC shift 49 DESC shift 50 sortorder shift 48 {default} reduce 102 State 48: (59) ccons ::= PRIMARY KEY sortorder * {default} reduce 59 State 49: (100) sortorder ::= ASC * {default} reduce 100 State 50: (101) sortorder ::= DESC * {default} reduce 101 State 51: (60) ccons ::= UNIQUE * {default} reduce 60 State 52: ccons ::= CHECK * LP expr RP LP shift 53 State 53: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING ccons ::= CHECK LP * expr RP expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 190 id shift 56 ids shift 80 State 54: (32) id ::= ID * expr ::= ID * LP exprlist RP expr ::= ID * LP STAR RP LP shift 55 {default} reduce 32 State 55: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= ID LP * exprlist RP expr ::= * ID LP STAR RP expr ::= ID LP * STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP exprlist ::= * exprlist COMMA expritem exprlist ::= * expritem expritem ::= * expr (172) expritem ::= * ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STAR shift 188 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 133 expritem shift 144 exprlist shift 186 id shift 56 ids shift 80 {default} reduce 172 State 56: (34) ids ::= id * (131) expr ::= id * $ reduce 131 AND reduce 131 AS reduce 131 ASC reduce 131 BEGIN reduce 131 BETWEEN reduce 131 CHECK reduce 131 CLUSTER reduce 131 COMMA reduce 131 CONCAT reduce 131 CONSTRAINT reduce 131 DELIMITERS reduce 131 DESC reduce 131 DOT reduce 34 END reduce 131 EQ reduce 131 EXCEPT reduce 131 EXPLAIN reduce 131 FROM reduce 131 GE reduce 131 GLOB reduce 131 GROUP reduce 131 GT reduce 131 HAVING reduce 131 ID reduce 131 IN reduce 131 INTERSECT reduce 131 IS reduce 131 ISNULL reduce 131 LE reduce 131 LIKE reduce 131 LT reduce 131 MINUS reduce 131 NE reduce 131 NOT reduce 131 NOTNULL reduce 131 OR reduce 131 ORDER reduce 131 PLUS reduce 131 PRAGMA reduce 131 PRIMARY reduce 131 RP reduce 131 SEMI reduce 131 SLASH reduce 131 STAR reduce 131 STRING reduce 131 TEMP reduce 131 UNION reduce 131 UNIQUE reduce 131 VACUUM reduce 131 WHERE reduce 131 State 57: (35) ids ::= STRING * (135) expr ::= STRING * $ reduce 135 AND reduce 135 AS reduce 135 ASC reduce 135 BEGIN reduce 135 BETWEEN reduce 135 CHECK reduce 135 CLUSTER reduce 135 COMMA reduce 135 CONCAT reduce 135 CONSTRAINT reduce 135 DELIMITERS reduce 135 DESC reduce 135 DOT reduce 35 END reduce 135 EQ reduce 135 EXCEPT reduce 135 EXPLAIN reduce 135 FROM reduce 135 GE reduce 135 GLOB reduce 135 GROUP reduce 135 GT reduce 135 HAVING reduce 135 ID reduce 135 IN reduce 135 INTERSECT reduce 135 IS reduce 135 ISNULL reduce 135 LE reduce 135 LIKE reduce 135 LT reduce 135 MINUS reduce 135 NE reduce 135 NOT reduce 135 NOTNULL reduce 135 OR reduce 135 ORDER reduce 135 PLUS reduce 135 PRAGMA reduce 135 PRIMARY reduce 135 RP reduce 135 SEMI reduce 135 SLASH reduce 135 STAR reduce 135 STRING reduce 135 TEMP reduce 135 UNION reduce 135 UNIQUE reduce 135 VACUUM reduce 135 WHERE reduce 135 State 58: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING select ::= * oneselect select ::= * select joinop oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt expr ::= * LP expr RP expr ::= LP * expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= LP * select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 SELECT shift 63 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 184 id shift 56 ids shift 80 oneselect shift 59 select shift 60 State 59: (73) select ::= oneselect * {default} reduce 73 State 60: select ::= select * joinop oneselect joinop ::= * UNION joinop ::= * UNION ALL joinop ::= * INTERSECT joinop ::= * EXCEPT expr ::= LP select * RP EXCEPT shift 131 INTERSECT shift 130 RP shift 183 UNION shift 128 joinop shift 61 State 61: select ::= select joinop * oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt SELECT shift 63 oneselect shift 62 State 62: (74) select ::= select joinop oneselect * {default} reduce 74 State 63: oneselect ::= SELECT * distinct selcollist from where_opt groupby_opt having_opt orderby_opt distinct ::= * DISTINCT distinct ::= * ALL (82) distinct ::= * ALL shift 182 DISTINCT shift 181 distinct shift 64 {default} reduce 82 State 64: oneselect ::= SELECT distinct * selcollist from where_opt groupby_opt having_opt orderby_opt sclp ::= * selcollist COMMA (84) sclp ::= * selcollist ::= * STAR selcollist ::= * sclp expr selcollist ::= * sclp expr as ids STAR shift 176 sclp shift 177 selcollist shift 65 {default} reduce 84 State 65: oneselect ::= SELECT distinct selcollist * from where_opt groupby_opt having_opt orderby_opt sclp ::= selcollist * COMMA from ::= * FROM seltablist COMMA shift 167 FROM shift 168 from shift 66 State 66: oneselect ::= SELECT distinct selcollist from * where_opt groupby_opt having_opt orderby_opt (108) where_opt ::= * where_opt ::= * WHERE expr WHERE shift 165 where_opt shift 67 {default} reduce 108 State 67: oneselect ::= SELECT distinct selcollist from where_opt * groupby_opt having_opt orderby_opt (103) groupby_opt ::= * groupby_opt ::= * GROUP BY exprlist GROUP shift 162 groupby_opt shift 68 {default} reduce 103 State 68: oneselect ::= SELECT distinct selcollist from where_opt groupby_opt * having_opt orderby_opt (105) having_opt ::= * having_opt ::= * HAVING expr HAVING shift 160 having_opt shift 69 {default} reduce 105 State 69: oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt * orderby_opt (95) orderby_opt ::= * orderby_opt ::= * ORDER BY sortlist ORDER shift 71 orderby_opt shift 70 {default} reduce 95 State 70: (79) oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt * {default} reduce 79 State 71: orderby_opt ::= ORDER * BY sortlist BY shift 72 State 72: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING orderby_opt ::= ORDER BY * sortlist sortlist ::= * sortlist COMMA sortitem sortorder sortlist ::= * sortitem sortorder sortitem ::= * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 77 id shift 56 ids shift 80 sortitem shift 158 sortlist shift 73 State 73: (96) orderby_opt ::= ORDER BY sortlist * sortlist ::= sortlist * COMMA sortitem sortorder COMMA shift 74 {default} reduce 96 State 74: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING sortlist ::= sortlist COMMA * sortitem sortorder sortitem ::= * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 77 id shift 56 ids shift 80 sortitem shift 75 State 75: sortlist ::= sortlist COMMA sortitem * sortorder sortorder ::= * ASC sortorder ::= * DESC (102) sortorder ::= * ASC shift 49 DESC shift 50 sortorder shift 76 {default} reduce 102 State 76: (97) sortlist ::= sortlist COMMA sortitem sortorder * {default} reduce 97 State 77: (99) sortitem ::= expr * expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 78 BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 OR shift 86 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 99 State 78: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= expr AND * expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 85 id shift 56 ids shift 80 State 79: (130) expr ::= NULL * {default} reduce 130 State 80: expr ::= ids * DOT ids DOT shift 81 State 81: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= ids DOT * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 82 State 82: (132) expr ::= ids DOT ids * {default} reduce 132 State 83: (133) expr ::= INTEGER * {default} reduce 133 State 84: (134) expr ::= FLOAT * {default} reduce 134 State 85: expr ::= expr * AND expr (138) expr ::= expr AND expr * expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 138 State 86: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= expr OR * expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 87 id shift 56 ids shift 80 State 87: expr ::= expr * AND expr expr ::= expr * OR expr (139) expr ::= expr OR expr * expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 78 BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 139 State 88: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= expr LT * expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 89 id shift 56 ids shift 80 State 89: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr (140) expr ::= expr LT expr * expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 115 MINUS shift 109 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 140 State 90: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= expr GT * expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 91 id shift 56 ids shift 80 State 91: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr (141) expr ::= expr GT expr * expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 115 MINUS shift 109 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 141 State 92: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= expr LE * expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 93 id shift 56 ids shift 80 State 93: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr (142) expr ::= expr LE expr * expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 115 MINUS shift 109 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 142 State 94: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= expr GE * expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 95 id shift 56 ids shift 80 State 95: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr (143) expr ::= expr GE expr * expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 115 MINUS shift 109 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 143 State 96: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= expr NE * expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 97 id shift 56 ids shift 80 State 97: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr (144) expr ::= expr NE expr * expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 115 GE shift 94 GT shift 90 LE shift 92 LT shift 88 MINUS shift 109 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 144 State 98: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= expr EQ * expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 99 id shift 56 ids shift 80 State 99: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr (145) expr ::= expr EQ expr * expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 115 GE shift 94 GT shift 90 LE shift 92 LT shift 88 MINUS shift 109 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 145 State 100: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= expr LIKE * expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 101 id shift 56 ids shift 80 State 101: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr (146) expr ::= expr LIKE expr * expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 115 GE shift 94 GT shift 90 LE shift 92 LT shift 88 MINUS shift 109 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 146 State 102: expr ::= expr NOT * LIKE expr expr ::= expr NOT * GLOB expr expr ::= expr NOT * NULL expr ::= expr NOT * BETWEEN expr AND expr expr ::= expr NOT * IN LP exprlist RP expr ::= expr NOT * IN LP select RP BETWEEN shift 148 GLOB shift 145 IN shift 152 LIKE shift 103 NULL shift 147 State 103: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= expr NOT LIKE * expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 104 id shift 56 ids shift 80 State 104: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr (147) expr ::= expr NOT LIKE expr * expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 147 State 105: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= expr GLOB * expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 106 id shift 56 ids shift 80 State 106: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr (148) expr ::= expr GLOB expr * expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 115 GE shift 94 GT shift 90 LE shift 92 LT shift 88 MINUS shift 109 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 148 State 107: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= expr PLUS * expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 108 id shift 56 ids shift 80 State 108: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr (150) expr ::= expr PLUS expr * expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 115 SLASH shift 113 STAR shift 111 {default} reduce 150 State 109: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= expr MINUS * expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 110 id shift 56 ids shift 80 State 110: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr (151) expr ::= expr MINUS expr * expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 115 SLASH shift 113 STAR shift 111 {default} reduce 151 State 111: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= expr STAR * expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 112 id shift 56 ids shift 80 State 112: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr (152) expr ::= expr STAR expr * expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 115 {default} reduce 152 State 113: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= expr SLASH * expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 114 id shift 56 ids shift 80 State 114: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr (153) expr ::= expr SLASH expr * expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP CONCAT shift 115 {default} reduce 153 State 115: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= expr CONCAT * expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 116 id shift 56 ids shift 80 State 116: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr (154) expr ::= expr CONCAT expr * expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP {default} reduce 154 State 117: (155) expr ::= expr ISNULL * {default} reduce 155 State 118: expr ::= expr IS * NULL NULL shift 119 State 119: (156) expr ::= expr IS NULL * {default} reduce 156 State 120: (157) expr ::= expr NOTNULL * {default} reduce 157 State 121: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= expr BETWEEN * expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 122 id shift 56 ids shift 80 State 122: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr BETWEEN expr * AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 123 BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 OR shift 86 PLUS shift 107 SLASH shift 113 STAR shift 111 State 123: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= expr AND * expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= expr BETWEEN expr AND * expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 124 id shift 56 ids shift 80 State 124: expr ::= expr * AND expr (138) expr ::= expr AND expr * expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr (163) expr ::= expr BETWEEN expr AND expr * expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP $ reduce 163 AND reduce 138 AND reduce 163 AS reduce 163 ASC reduce 163 BEGIN reduce 163 BETWEEN reduce 163 CHECK reduce 163 CLUSTER reduce 163 COMMA reduce 163 CONCAT shift 115 CONSTRAINT reduce 163 DELIMITERS reduce 163 DESC reduce 163 END reduce 163 EQ reduce 163 EXCEPT reduce 163 EXPLAIN reduce 163 FROM reduce 163 GE shift 94 GLOB reduce 163 GROUP reduce 163 GT shift 90 HAVING reduce 163 ID reduce 163 IN reduce 163 INTERSECT reduce 163 IS reduce 163 ISNULL reduce 163 LE shift 92 LIKE reduce 163 LT shift 88 MINUS shift 109 NE reduce 163 NOT reduce 163 NOTNULL reduce 163 OR reduce 138 OR reduce 163 ORDER reduce 163 PLUS shift 107 PRAGMA reduce 163 PRIMARY reduce 163 RP reduce 163 SEMI reduce 163 SLASH shift 113 STAR shift 111 STRING reduce 163 TEMP reduce 163 UNION reduce 163 UNIQUE reduce 163 VACUUM reduce 163 WHERE reduce 163 State 125: expr ::= expr IN * LP exprlist RP expr ::= expr IN * LP select RP LP shift 126 State 126: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING select ::= * oneselect select ::= * select joinop oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= expr IN LP * exprlist RP expr ::= * expr IN LP select RP expr ::= expr IN LP * select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP exprlist ::= * exprlist COMMA expritem exprlist ::= * expritem expritem ::= * expr (172) expritem ::= * ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 SELECT shift 63 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 133 expritem shift 144 exprlist shift 140 id shift 56 ids shift 80 oneselect shift 59 select shift 127 {default} reduce 172 State 127: select ::= select * joinop oneselect joinop ::= * UNION joinop ::= * UNION ALL joinop ::= * INTERSECT joinop ::= * EXCEPT expr ::= expr IN LP select * RP EXCEPT shift 131 INTERSECT shift 130 RP shift 132 UNION shift 128 joinop shift 61 State 128: (75) joinop ::= UNION * joinop ::= UNION * ALL ALL shift 129 SELECT reduce 75 State 129: (76) joinop ::= UNION ALL * SELECT reduce 76 State 130: (77) joinop ::= INTERSECT * SELECT reduce 77 State 131: (78) joinop ::= EXCEPT * SELECT reduce 78 State 132: (166) expr ::= expr IN LP select RP * {default} reduce 166 State 133: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP (171) expritem ::= expr * AND shift 78 BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 OR shift 86 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 171 State 134: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= NOT * expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 135 id shift 56 ids shift 80 State 135: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL (159) expr ::= NOT expr * expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 159 State 136: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= MINUS * expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 137 id shift 56 ids shift 80 State 137: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL (160) expr ::= MINUS expr * expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP {default} reduce 160 State 138: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= PLUS * expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 139 id shift 56 ids shift 80 State 139: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL (161) expr ::= PLUS expr * expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP {default} reduce 161 State 140: expr ::= expr IN LP exprlist * RP exprlist ::= exprlist * COMMA expritem COMMA shift 142 RP shift 141 State 141: (165) expr ::= expr IN LP exprlist RP * {default} reduce 165 State 142: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP exprlist ::= exprlist COMMA * expritem expritem ::= * expr (172) expritem ::= * ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 133 expritem shift 143 id shift 56 ids shift 80 {default} reduce 172 State 143: (169) exprlist ::= exprlist COMMA expritem * {default} reduce 169 State 144: (170) exprlist ::= expritem * {default} reduce 170 State 145: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= expr NOT GLOB * expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 146 id shift 56 ids shift 80 State 146: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr (149) expr ::= expr NOT GLOB expr * expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 149 State 147: (158) expr ::= expr NOT NULL * {default} reduce 158 State 148: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= expr NOT BETWEEN * expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 149 id shift 56 ids shift 80 State 149: expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr NOT BETWEEN expr * AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 150 BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 OR shift 86 PLUS shift 107 SLASH shift 113 STAR shift 111 State 150: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= expr AND * expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= expr NOT BETWEEN expr AND * expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 151 id shift 56 ids shift 80 State 151: expr ::= expr * AND expr (138) expr ::= expr AND expr * expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr (164) expr ::= expr NOT BETWEEN expr AND expr * expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP $ reduce 164 AND reduce 138 AND reduce 164 AS reduce 164 ASC reduce 164 BEGIN reduce 164 BETWEEN shift 121 CHECK reduce 164 CLUSTER reduce 164 COMMA reduce 164 CONCAT shift 115 CONSTRAINT reduce 164 DELIMITERS reduce 164 DESC reduce 164 END reduce 164 EQ shift 98 EXCEPT reduce 164 EXPLAIN reduce 164 FROM reduce 164 GE shift 94 GLOB shift 105 GROUP reduce 164 GT shift 90 HAVING reduce 164 ID reduce 164 IN shift 125 INTERSECT reduce 164 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 OR reduce 138 OR reduce 164 ORDER reduce 164 PLUS shift 107 PRAGMA reduce 164 PRIMARY reduce 164 RP reduce 164 SEMI reduce 164 SLASH shift 113 STAR shift 111 STRING reduce 164 TEMP reduce 164 UNION reduce 164 UNIQUE reduce 164 VACUUM reduce 164 WHERE reduce 164 State 152: expr ::= expr NOT IN * LP exprlist RP expr ::= expr NOT IN * LP select RP LP shift 153 State 153: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING select ::= * oneselect select ::= * select joinop oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= expr NOT IN LP * exprlist RP expr ::= * expr NOT IN LP select RP expr ::= expr NOT IN LP * select RP exprlist ::= * exprlist COMMA expritem exprlist ::= * expritem expritem ::= * expr (172) expritem ::= * ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 SELECT shift 63 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 133 expritem shift 144 exprlist shift 156 id shift 56 ids shift 80 oneselect shift 59 select shift 154 {default} reduce 172 State 154: select ::= select * joinop oneselect joinop ::= * UNION joinop ::= * UNION ALL joinop ::= * INTERSECT joinop ::= * EXCEPT expr ::= expr NOT IN LP select * RP EXCEPT shift 131 INTERSECT shift 130 RP shift 155 UNION shift 128 joinop shift 61 State 155: (168) expr ::= expr NOT IN LP select RP * {default} reduce 168 State 156: expr ::= expr NOT IN LP exprlist * RP exprlist ::= exprlist * COMMA expritem COMMA shift 142 RP shift 157 State 157: (167) expr ::= expr NOT IN LP exprlist RP * {default} reduce 167 State 158: sortlist ::= sortitem * sortorder sortorder ::= * ASC sortorder ::= * DESC (102) sortorder ::= * ASC shift 49 DESC shift 50 sortorder shift 159 {default} reduce 102 State 159: (98) sortlist ::= sortitem sortorder * {default} reduce 98 State 160: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING having_opt ::= HAVING * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 161 id shift 56 ids shift 80 State 161: (106) having_opt ::= HAVING expr * expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 78 BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 OR shift 86 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 106 State 162: groupby_opt ::= GROUP * BY exprlist BY shift 163 State 163: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING groupby_opt ::= GROUP BY * exprlist expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP exprlist ::= * exprlist COMMA expritem exprlist ::= * expritem expritem ::= * expr (172) expritem ::= * ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 133 expritem shift 144 exprlist shift 164 id shift 56 ids shift 80 {default} reduce 172 State 164: (104) groupby_opt ::= GROUP BY exprlist * exprlist ::= exprlist * COMMA expritem COMMA shift 142 {default} reduce 104 State 165: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING where_opt ::= WHERE * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 166 id shift 56 ids shift 80 State 166: (109) where_opt ::= WHERE expr * expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 78 BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 OR shift 86 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 109 State 167: (83) sclp ::= selcollist COMMA * {default} reduce 83 State 168: from ::= FROM * seltablist stl_prefix ::= * seltablist COMMA (92) stl_prefix ::= * seltablist ::= * stl_prefix ids seltablist ::= * stl_prefix ids as ids seltablist shift 169 stl_prefix shift 171 {default} reduce 92 State 169: (90) from ::= FROM seltablist * stl_prefix ::= seltablist * COMMA COMMA shift 170 {default} reduce 90 State 170: (91) stl_prefix ::= seltablist COMMA * {default} reduce 91 State 171: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING seltablist ::= stl_prefix * ids seltablist ::= stl_prefix * ids as ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 172 State 172: (88) as ::= * as ::= * AS (93) seltablist ::= stl_prefix ids * seltablist ::= stl_prefix ids * as ids $ reduce 93 AS shift 173 ASC reduce 88 BEGIN reduce 88 CLUSTER reduce 88 COMMA reduce 93 DELIMITERS reduce 88 DESC reduce 88 END reduce 88 EXCEPT reduce 93 EXPLAIN reduce 88 GROUP reduce 93 HAVING reduce 93 ID reduce 88 INTERSECT reduce 93 ORDER reduce 93 PRAGMA reduce 88 RP reduce 93 SEMI reduce 93 STRING reduce 88 TEMP reduce 88 UNION reduce 93 VACUUM reduce 88 WHERE reduce 93 as shift 174 State 173: (89) as ::= AS * {default} reduce 89 State 174: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING seltablist ::= stl_prefix ids as * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 175 State 175: (94) seltablist ::= stl_prefix ids as ids * {default} reduce 94 State 176: (85) selcollist ::= STAR * {default} reduce 85 State 177: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING selcollist ::= sclp * expr selcollist ::= sclp * expr as ids expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 178 id shift 56 ids shift 80 State 178: (86) selcollist ::= sclp expr * selcollist ::= sclp expr * as ids (88) as ::= * as ::= * AS expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 78 AS shift 173 ASC reduce 88 BEGIN reduce 88 BETWEEN shift 121 CLUSTER reduce 88 COMMA reduce 86 CONCAT shift 115 DELIMITERS reduce 88 DESC reduce 88 END reduce 88 EQ shift 98 EXPLAIN reduce 88 FROM reduce 86 GE shift 94 GLOB shift 105 GT shift 90 ID reduce 88 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 OR shift 86 PLUS shift 107 PRAGMA reduce 88 SLASH shift 113 STAR shift 111 STRING reduce 88 TEMP reduce 88 VACUUM reduce 88 as shift 179 State 179: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING selcollist ::= sclp expr as * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 180 State 180: (87) selcollist ::= sclp expr as ids * {default} reduce 87 State 181: (80) distinct ::= DISTINCT * {default} reduce 80 State 182: (81) distinct ::= ALL * {default} reduce 81 State 183: (162) expr ::= LP select RP * {default} reduce 162 State 184: expr ::= LP expr * RP expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 78 BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 OR shift 86 PLUS shift 107 RP shift 185 SLASH shift 113 STAR shift 111 State 185: (129) expr ::= LP expr RP * {default} reduce 129 State 186: expr ::= ID LP exprlist * RP exprlist ::= exprlist * COMMA expritem COMMA shift 142 RP shift 187 State 187: (136) expr ::= ID LP exprlist RP * {default} reduce 136 State 188: expr ::= ID LP STAR * RP RP shift 189 State 189: (137) expr ::= ID LP STAR RP * {default} reduce 137 State 190: ccons ::= CHECK LP expr * RP expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 78 BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 OR shift 86 PLUS shift 107 RP shift 191 SLASH shift 113 STAR shift 111 State 191: (61) ccons ::= CHECK LP expr RP * {default} reduce 61 State 192: (48) carg ::= ccons * {default} reduce 48 State 193: carg ::= DEFAULT * STRING carg ::= DEFAULT * ID carg ::= DEFAULT * INTEGER carg ::= DEFAULT * PLUS INTEGER carg ::= DEFAULT * MINUS INTEGER carg ::= DEFAULT * FLOAT carg ::= DEFAULT * PLUS FLOAT carg ::= DEFAULT * MINUS FLOAT carg ::= DEFAULT * NULL FLOAT shift 203 ID shift 195 INTEGER shift 196 MINUS shift 200 NULL shift 204 PLUS shift 197 STRING shift 194 State 194: (49) carg ::= DEFAULT STRING * {default} reduce 49 State 195: (50) carg ::= DEFAULT ID * {default} reduce 50 State 196: (51) carg ::= DEFAULT INTEGER * {default} reduce 51 State 197: carg ::= DEFAULT PLUS * INTEGER carg ::= DEFAULT PLUS * FLOAT FLOAT shift 199 INTEGER shift 198 State 198: (52) carg ::= DEFAULT PLUS INTEGER * {default} reduce 52 State 199: (55) carg ::= DEFAULT PLUS FLOAT * {default} reduce 55 State 200: carg ::= DEFAULT MINUS * INTEGER carg ::= DEFAULT MINUS * FLOAT FLOAT shift 202 INTEGER shift 201 State 201: (53) carg ::= DEFAULT MINUS INTEGER * {default} reduce 53 State 202: (56) carg ::= DEFAULT MINUS FLOAT * {default} reduce 56 State 203: (54) carg ::= DEFAULT FLOAT * {default} reduce 54 State 204: (57) carg ::= DEFAULT NULL * {default} reduce 57 State 205: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING (37) type ::= typename * type ::= typename * LP signed RP type ::= typename * LP signed COMMA signed RP typename ::= typename * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 LP shift 206 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 217 {default} reduce 37 State 206: type ::= typename LP * signed RP type ::= typename LP * signed COMMA signed RP signed ::= * INTEGER signed ::= * PLUS INTEGER signed ::= * MINUS INTEGER INTEGER shift 212 MINUS shift 215 PLUS shift 213 signed shift 207 State 207: type ::= typename LP signed * RP type ::= typename LP signed * COMMA signed RP COMMA shift 209 RP shift 208 State 208: (38) type ::= typename LP signed RP * {default} reduce 38 State 209: type ::= typename LP signed COMMA * signed RP signed ::= * INTEGER signed ::= * PLUS INTEGER signed ::= * MINUS INTEGER INTEGER shift 212 MINUS shift 215 PLUS shift 213 signed shift 210 State 210: type ::= typename LP signed COMMA signed * RP RP shift 211 State 211: (39) type ::= typename LP signed COMMA signed RP * {default} reduce 39 State 212: (42) signed ::= INTEGER * {default} reduce 42 State 213: signed ::= PLUS * INTEGER INTEGER shift 214 State 214: (43) signed ::= PLUS INTEGER * {default} reduce 43 State 215: signed ::= MINUS * INTEGER INTEGER shift 216 State 216: (44) signed ::= MINUS INTEGER * {default} reduce 44 State 217: (41) typename ::= typename ids * {default} reduce 41 State 218: (40) typename ::= ids * {default} reduce 40 State 219: (22) columnid ::= ids * {default} reduce 22 State 220: (63) conslist_opt ::= COMMA conslist * conslist ::= conslist * COMMA tcons conslist ::= conslist * tcons tcons ::= * CONSTRAINT ids tcons ::= * PRIMARY KEY LP idxlist RP tcons ::= * UNIQUE LP idxlist RP tcons ::= * CHECK expr CHECK shift 238 COMMA shift 221 CONSTRAINT shift 223 PRIMARY shift 225 RP reduce 63 UNIQUE shift 234 tcons shift 240 State 221: conslist ::= conslist COMMA * tcons tcons ::= * CONSTRAINT ids tcons ::= * PRIMARY KEY LP idxlist RP tcons ::= * UNIQUE LP idxlist RP tcons ::= * CHECK expr CHECK shift 238 CONSTRAINT shift 223 PRIMARY shift 225 UNIQUE shift 234 tcons shift 222 State 222: (64) conslist ::= conslist COMMA tcons * {default} reduce 64 State 223: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING tcons ::= CONSTRAINT * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 224 State 224: (67) tcons ::= CONSTRAINT ids * {default} reduce 67 State 225: tcons ::= PRIMARY * KEY LP idxlist RP KEY shift 226 State 226: tcons ::= PRIMARY KEY * LP idxlist RP LP shift 227 State 227: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING tcons ::= PRIMARY KEY LP * idxlist RP idxlist ::= * idxlist COMMA idxitem idxlist ::= * idxitem idxitem ::= * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 232 idxitem shift 233 idxlist shift 228 State 228: tcons ::= PRIMARY KEY LP idxlist * RP idxlist ::= idxlist * COMMA idxitem COMMA shift 230 RP shift 229 State 229: (68) tcons ::= PRIMARY KEY LP idxlist RP * {default} reduce 68 State 230: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING idxlist ::= idxlist COMMA * idxitem idxitem ::= * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 232 idxitem shift 231 State 231: (176) idxlist ::= idxlist COMMA idxitem * {default} reduce 176 State 232: (178) idxitem ::= ids * {default} reduce 178 State 233: (177) idxlist ::= idxitem * {default} reduce 177 State 234: tcons ::= UNIQUE * LP idxlist RP LP shift 235 State 235: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING tcons ::= UNIQUE LP * idxlist RP idxlist ::= * idxlist COMMA idxitem idxlist ::= * idxitem idxitem ::= * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 232 idxitem shift 233 idxlist shift 236 State 236: tcons ::= UNIQUE LP idxlist * RP idxlist ::= idxlist * COMMA idxitem COMMA shift 230 RP shift 237 State 237: (69) tcons ::= UNIQUE LP idxlist RP * {default} reduce 69 State 238: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING tcons ::= CHECK * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 239 id shift 56 ids shift 80 State 239: (70) tcons ::= CHECK expr * expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 78 BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 OR shift 86 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 70 State 240: (65) conslist ::= conslist tcons * {default} reduce 65 State 241: (66) conslist ::= tcons * {default} reduce 66 State 242: (20) columnlist ::= column * {default} reduce 20 State 243: create_table ::= CREATE * temp TABLE ids temp ::= * TEMP (17) temp ::= * cmd ::= CREATE * uniqueflag INDEX ids ON ids LP idxlist RP uniqueflag ::= * UNIQUE (175) uniqueflag ::= * INDEX reduce 175 TABLE reduce 17 TEMP shift 247 UNIQUE shift 256 temp shift 244 uniqueflag shift 248 State 244: create_table ::= CREATE temp * TABLE ids TABLE shift 245 State 245: create_table ::= CREATE temp TABLE * ids id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 246 State 246: (15) create_table ::= CREATE temp TABLE ids * LP reduce 15 State 247: (16) temp ::= TEMP * TABLE reduce 16 State 248: cmd ::= CREATE uniqueflag * INDEX ids ON ids LP idxlist RP INDEX shift 249 State 249: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= CREATE uniqueflag INDEX * ids ON ids LP idxlist RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 250 State 250: cmd ::= CREATE uniqueflag INDEX ids * ON ids LP idxlist RP ON shift 251 State 251: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= CREATE uniqueflag INDEX ids ON * ids LP idxlist RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 252 State 252: cmd ::= CREATE uniqueflag INDEX ids ON ids * LP idxlist RP LP shift 253 State 253: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= CREATE uniqueflag INDEX ids ON ids LP * idxlist RP idxlist ::= * idxlist COMMA idxitem idxlist ::= * idxitem idxitem ::= * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 232 idxitem shift 233 idxlist shift 254 State 254: cmd ::= CREATE uniqueflag INDEX ids ON ids LP idxlist * RP idxlist ::= idxlist * COMMA idxitem COMMA shift 230 RP shift 255 State 255: (173) cmd ::= CREATE uniqueflag INDEX ids ON ids LP idxlist RP * {default} reduce 173 State 256: (174) uniqueflag ::= UNIQUE * INDEX reduce 174 State 257: cmd ::= DROP * TABLE ids cmd ::= DROP * INDEX ids INDEX shift 260 TABLE shift 258 State 258: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= DROP TABLE * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 259 State 259: (71) cmd ::= DROP TABLE ids * {default} reduce 71 State 260: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= DROP INDEX * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 261 State 261: (179) cmd ::= DROP INDEX ids * {default} reduce 179 State 262: (72) cmd ::= select * select ::= select * joinop oneselect joinop ::= * UNION joinop ::= * UNION ALL joinop ::= * INTERSECT joinop ::= * EXCEPT EXCEPT shift 131 INTERSECT shift 130 UNION shift 128 joinop shift 61 {default} reduce 72 State 263: cmd ::= DELETE * FROM ids where_opt FROM shift 264 State 264: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= DELETE FROM * ids where_opt ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 265 State 265: cmd ::= DELETE FROM ids * where_opt (108) where_opt ::= * where_opt ::= * WHERE expr WHERE shift 165 where_opt shift 266 {default} reduce 108 State 266: (107) cmd ::= DELETE FROM ids where_opt * {default} reduce 107 State 267: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= UPDATE * ids SET setlist where_opt ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 268 State 268: cmd ::= UPDATE ids * SET setlist where_opt SET shift 269 State 269: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= UPDATE ids SET * setlist where_opt setlist ::= * setlist COMMA ids EQ expr setlist ::= * ids EQ expr ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 276 setlist shift 270 State 270: (108) where_opt ::= * where_opt ::= * WHERE expr cmd ::= UPDATE ids SET setlist * where_opt setlist ::= setlist * COMMA ids EQ expr COMMA shift 272 WHERE shift 165 where_opt shift 271 {default} reduce 108 State 271: (110) cmd ::= UPDATE ids SET setlist where_opt * {default} reduce 110 State 272: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING setlist ::= setlist COMMA * ids EQ expr ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 273 State 273: setlist ::= setlist COMMA ids * EQ expr EQ shift 274 State 274: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING setlist ::= setlist COMMA ids EQ * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 275 id shift 56 ids shift 80 State 275: (111) setlist ::= setlist COMMA ids EQ expr * expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 78 BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 OR shift 86 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 111 State 276: setlist ::= ids * EQ expr EQ shift 277 State 277: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING setlist ::= ids EQ * expr expr ::= * LP expr RP expr ::= * NULL expr ::= * id expr ::= * ids DOT ids expr ::= * INTEGER expr ::= * FLOAT expr ::= * STRING expr ::= * ID LP exprlist RP expr ::= * ID LP STAR RP expr ::= * expr AND expr expr ::= * expr OR expr expr ::= * expr LT expr expr ::= * expr GT expr expr ::= * expr LE expr expr ::= * expr GE expr expr ::= * expr NE expr expr ::= * expr EQ expr expr ::= * expr LIKE expr expr ::= * expr NOT LIKE expr expr ::= * expr GLOB expr expr ::= * expr NOT GLOB expr expr ::= * expr PLUS expr expr ::= * expr MINUS expr expr ::= * expr STAR expr expr ::= * expr SLASH expr expr ::= * expr CONCAT expr expr ::= * expr ISNULL expr ::= * expr IS NULL expr ::= * expr NOTNULL expr ::= * expr NOT NULL expr ::= * NOT expr expr ::= * MINUS expr expr ::= * PLUS expr expr ::= * LP select RP expr ::= * expr BETWEEN expr AND expr expr ::= * expr NOT BETWEEN expr AND expr expr ::= * expr IN LP exprlist RP expr ::= * expr IN LP select RP expr ::= * expr NOT IN LP exprlist RP expr ::= * expr NOT IN LP select RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 FLOAT shift 84 ID shift 54 INTEGER shift 83 LP shift 58 MINUS shift 136 NOT shift 134 NULL shift 79 PLUS shift 138 PRAGMA shift 17 STRING shift 57 TEMP shift 20 VACUUM shift 14 expr shift 278 id shift 56 ids shift 80 State 278: (112) setlist ::= ids EQ expr * expr ::= expr * AND expr expr ::= expr * OR expr expr ::= expr * LT expr expr ::= expr * GT expr expr ::= expr * LE expr expr ::= expr * GE expr expr ::= expr * NE expr expr ::= expr * EQ expr expr ::= expr * LIKE expr expr ::= expr * NOT LIKE expr expr ::= expr * GLOB expr expr ::= expr * NOT GLOB expr expr ::= expr * PLUS expr expr ::= expr * MINUS expr expr ::= expr * STAR expr expr ::= expr * SLASH expr expr ::= expr * CONCAT expr expr ::= expr * ISNULL expr ::= expr * IS NULL expr ::= expr * NOTNULL expr ::= expr * NOT NULL expr ::= expr * BETWEEN expr AND expr expr ::= expr * NOT BETWEEN expr AND expr expr ::= expr * IN LP exprlist RP expr ::= expr * IN LP select RP expr ::= expr * NOT IN LP exprlist RP expr ::= expr * NOT IN LP select RP AND shift 78 BETWEEN shift 121 CONCAT shift 115 EQ shift 98 GE shift 94 GLOB shift 105 GT shift 90 IN shift 125 IS shift 118 ISNULL shift 117 LE shift 92 LIKE shift 100 LT shift 88 MINUS shift 109 NE shift 96 NOT shift 102 NOTNULL shift 120 OR shift 86 PLUS shift 107 SLASH shift 113 STAR shift 111 {default} reduce 112 State 279: cmd ::= INSERT * INTO ids inscollist_opt VALUES LP itemlist RP cmd ::= INSERT * INTO ids inscollist_opt select INTO shift 280 State 280: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= INSERT INTO * ids inscollist_opt VALUES LP itemlist RP cmd ::= INSERT INTO * ids inscollist_opt select ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 281 State 281: cmd ::= INSERT INTO ids * inscollist_opt VALUES LP itemlist RP cmd ::= INSERT INTO ids * inscollist_opt select (125) inscollist_opt ::= * inscollist_opt ::= * LP inscollist RP LP shift 301 inscollist_opt shift 282 {default} reduce 125 State 282: select ::= * oneselect select ::= * select joinop oneselect oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt cmd ::= INSERT INTO ids inscollist_opt * VALUES LP itemlist RP cmd ::= INSERT INTO ids inscollist_opt * select SELECT shift 63 VALUES shift 284 oneselect shift 59 select shift 283 State 283: select ::= select * joinop oneselect joinop ::= * UNION joinop ::= * UNION ALL joinop ::= * INTERSECT joinop ::= * EXCEPT (114) cmd ::= INSERT INTO ids inscollist_opt select * EXCEPT shift 131 INTERSECT shift 130 UNION shift 128 joinop shift 61 {default} reduce 114 State 284: cmd ::= INSERT INTO ids inscollist_opt VALUES * LP itemlist RP LP shift 285 State 285: cmd ::= INSERT INTO ids inscollist_opt VALUES LP * itemlist RP itemlist ::= * itemlist COMMA item itemlist ::= * item item ::= * INTEGER item ::= * PLUS INTEGER item ::= * MINUS INTEGER item ::= * FLOAT item ::= * PLUS FLOAT item ::= * MINUS FLOAT item ::= * STRING item ::= * NULL FLOAT shift 297 INTEGER shift 290 MINUS shift 294 NULL shift 299 PLUS shift 291 STRING shift 298 item shift 300 itemlist shift 286 State 286: cmd ::= INSERT INTO ids inscollist_opt VALUES LP itemlist * RP itemlist ::= itemlist * COMMA item COMMA shift 288 RP shift 287 State 287: (113) cmd ::= INSERT INTO ids inscollist_opt VALUES LP itemlist RP * {default} reduce 113 State 288: itemlist ::= itemlist COMMA * item item ::= * INTEGER item ::= * PLUS INTEGER item ::= * MINUS INTEGER item ::= * FLOAT item ::= * PLUS FLOAT item ::= * MINUS FLOAT item ::= * STRING item ::= * NULL FLOAT shift 297 INTEGER shift 290 MINUS shift 294 NULL shift 299 PLUS shift 291 STRING shift 298 item shift 289 State 289: (115) itemlist ::= itemlist COMMA item * {default} reduce 115 State 290: (117) item ::= INTEGER * {default} reduce 117 State 291: item ::= PLUS * INTEGER item ::= PLUS * FLOAT FLOAT shift 293 INTEGER shift 292 State 292: (118) item ::= PLUS INTEGER * {default} reduce 118 State 293: (121) item ::= PLUS FLOAT * {default} reduce 121 State 294: item ::= MINUS * INTEGER item ::= MINUS * FLOAT FLOAT shift 296 INTEGER shift 295 State 295: (119) item ::= MINUS INTEGER * {default} reduce 119 State 296: (122) item ::= MINUS FLOAT * {default} reduce 122 State 297: (120) item ::= FLOAT * {default} reduce 120 State 298: (123) item ::= STRING * {default} reduce 123 State 299: (124) item ::= NULL * {default} reduce 124 State 300: (116) itemlist ::= item * {default} reduce 116 State 301: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING inscollist_opt ::= LP * inscollist RP inscollist ::= * inscollist COMMA ids inscollist ::= * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 306 inscollist shift 302 State 302: inscollist_opt ::= LP inscollist * RP inscollist ::= inscollist * COMMA ids COMMA shift 304 RP shift 303 State 303: (126) inscollist_opt ::= LP inscollist RP * {default} reduce 126 State 304: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING inscollist ::= inscollist COMMA * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 305 State 305: (127) inscollist ::= inscollist COMMA ids * {default} reduce 127 State 306: (128) inscollist ::= ids * {default} reduce 128 State 307: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= COPY * ids FROM ids USING DELIMITERS STRING cmd ::= COPY * ids FROM ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 308 State 308: cmd ::= COPY ids * FROM ids USING DELIMITERS STRING cmd ::= COPY ids * FROM ids FROM shift 309 State 309: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= COPY ids FROM * ids USING DELIMITERS STRING cmd ::= COPY ids FROM * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 310 State 310: cmd ::= COPY ids FROM ids * USING DELIMITERS STRING (181) cmd ::= COPY ids FROM ids * USING shift 311 {default} reduce 181 State 311: cmd ::= COPY ids FROM ids USING * DELIMITERS STRING DELIMITERS shift 312 State 312: cmd ::= COPY ids FROM ids USING DELIMITERS * STRING STRING shift 313 State 313: (180) cmd ::= COPY ids FROM ids USING DELIMITERS STRING * {default} reduce 180 State 314: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING (182) cmd ::= VACUUM * cmd ::= VACUUM * ids ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 315 {default} reduce 182 State 315: (183) cmd ::= VACUUM ids * {default} reduce 183 State 316: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= PRAGMA * ids EQ ids cmd ::= PRAGMA * ids EQ ON cmd ::= PRAGMA * ids EQ plus_num cmd ::= PRAGMA * ids EQ minus_num cmd ::= PRAGMA * ids LP ids RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 317 State 317: cmd ::= PRAGMA ids * EQ ids cmd ::= PRAGMA ids * EQ ON cmd ::= PRAGMA ids * EQ plus_num cmd ::= PRAGMA ids * EQ minus_num cmd ::= PRAGMA ids * LP ids RP EQ shift 318 LP shift 330 State 318: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= PRAGMA ids EQ * ids cmd ::= PRAGMA ids EQ * ON cmd ::= PRAGMA ids EQ * plus_num cmd ::= PRAGMA ids EQ * minus_num plus_num ::= * plus_opt number minus_num ::= * MINUS number plus_opt ::= * PLUS (194) plus_opt ::= * ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 MINUS shift 327 ON shift 320 PLUS shift 329 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 319 minus_num shift 322 plus_num shift 321 plus_opt shift 323 {default} reduce 194 State 319: (184) cmd ::= PRAGMA ids EQ ids * {default} reduce 184 State 320: (185) cmd ::= PRAGMA ids EQ ON * {default} reduce 185 State 321: (186) cmd ::= PRAGMA ids EQ plus_num * {default} reduce 186 State 322: (187) cmd ::= PRAGMA ids EQ minus_num * {default} reduce 187 State 323: plus_num ::= plus_opt * number number ::= * INTEGER number ::= * FLOAT FLOAT shift 326 INTEGER shift 325 number shift 324 State 324: (189) plus_num ::= plus_opt number * {default} reduce 189 State 325: (191) number ::= INTEGER * {default} reduce 191 State 326: (192) number ::= FLOAT * {default} reduce 192 State 327: minus_num ::= MINUS * number number ::= * INTEGER number ::= * FLOAT FLOAT shift 326 INTEGER shift 325 number shift 328 State 328: (190) minus_num ::= MINUS number * {default} reduce 190 State 329: (193) plus_opt ::= PLUS * {default} reduce 193 State 330: id ::= * DESC id ::= * ASC id ::= * DELIMITERS id ::= * EXPLAIN id ::= * VACUUM id ::= * BEGIN id ::= * END id ::= * PRAGMA id ::= * CLUSTER id ::= * ID id ::= * TEMP ids ::= * id ids ::= * STRING cmd ::= PRAGMA ids LP * ids RP ASC shift 11 BEGIN shift 15 CLUSTER shift 18 DELIMITERS shift 12 DESC shift 10 END shift 16 EXPLAIN shift 13 ID shift 19 PRAGMA shift 17 STRING shift 22 TEMP shift 20 VACUUM shift 14 id shift 21 ids shift 331 State 331: cmd ::= PRAGMA ids LP ids * RP RP shift 332 State 332: (188) cmd ::= PRAGMA ids LP ids RP * {default} reduce 188 State 333: (4) ecmd ::= cmd * {default} reduce 4 State 334: (6) explain ::= EXPLAIN * {default} reduce 6 State 335: (1) cmdlist ::= ecmd * {default} reduce 1