AryaWu/sqlite
0
1State 0:2 input ::= * cmdlist3 cmdlist ::= * cmdlist ecmd4 cmdlist ::= * ecmd5 ecmd ::= * SEMI6 ecmd ::= * cmdx SEMI7 ecmd ::= * explain cmdx SEMI8 explain ::= * EXPLAIN9 explain ::= * EXPLAIN QUERY PLAN10 cmdx ::= * cmd11 cmd ::= * BEGIN transtype trans_opt12 cmd ::= * COMMIT|END trans_opt13 cmd ::= * ROLLBACK trans_opt14 cmd ::= * SAVEPOINT nm15 cmd ::= * RELEASE savepoint_opt nm16 cmd ::= * ROLLBACK trans_opt TO savepoint_opt nm17 cmd ::= * create_table create_table_args18 create_table ::= * createkw temp TABLE ifnotexists nm dbnm19 createkw ::= * CREATE20 cmd ::= * DROP TABLE ifexists fullname21 cmd ::= * createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS select22 cmd ::= * DROP VIEW ifexists fullname23 cmd ::= * select24 select ::= * WITH wqlist selectnowith25 select ::= * WITH RECURSIVE wqlist selectnowith26 select ::= * selectnowith27 selectnowith ::= * oneselect28 selectnowith ::= * selectnowith multiselect_op oneselect29 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt30 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt31 oneselect ::= * values32 values ::= * VALUES LP nexprlist RP33 oneselect ::= * mvalues34 mvalues ::= * values COMMA LP nexprlist RP35 mvalues ::= * mvalues COMMA LP nexprlist RP36 cmd ::= * with DELETE FROM xfullname indexed_opt where_opt_ret37 cmd ::= * with UPDATE orconf xfullname indexed_opt SET setlist from where_opt_ret38 cmd ::= * with insert_cmd INTO xfullname idlist_opt select upsert39 cmd ::= * with insert_cmd INTO xfullname idlist_opt DEFAULT VALUES returning40 cmd ::= * createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP sortlist RP where_opt41 cmd ::= * DROP INDEX ifexists fullname42 cmd ::= * VACUUM vinto43 cmd ::= * VACUUM nm vinto44 cmd ::= * PRAGMA nm dbnm45 cmd ::= * PRAGMA nm dbnm EQ nmnum46 cmd ::= * PRAGMA nm dbnm LP nmnum RP47 cmd ::= * PRAGMA nm dbnm EQ minus_num48 cmd ::= * PRAGMA nm dbnm LP minus_num RP49 cmd ::= * createkw trigger_decl BEGIN trigger_cmd_list END50 cmd ::= * DROP TRIGGER ifexists fullname51 cmd ::= * ATTACH database_kw_opt expr AS expr key_opt52 cmd ::= * DETACH database_kw_opt expr53 cmd ::= * REINDEX54 cmd ::= * REINDEX nm dbnm55 cmd ::= * ANALYZE56 cmd ::= * ANALYZE nm dbnm57 cmd ::= * ALTER TABLE fullname RENAME TO nm58 cmd ::= * alter_add carglist59 alter_add ::= * ALTER TABLE fullname ADD kwcolumn_opt nm typetoken60 cmd ::= * ALTER TABLE fullname DROP kwcolumn_opt nm61 cmd ::= * ALTER TABLE fullname RENAME kwcolumn_opt nm TO nm62 cmd ::= * ALTER TABLE fullname DROP CONSTRAINT nm63 cmd ::= * ALTER TABLE fullname ALTER kwcolumn_opt nm DROP NOT NULL64 cmd ::= * ALTER TABLE fullname ALTER kwcolumn_opt nm SET NOT NULL onconf65 cmd ::= * ALTER TABLE fullname ADD CONSTRAINT nm CHECK LP expr RP onconf66 cmd ::= * ALTER TABLE fullname ADD CHECK LP expr RP onconf67 cmd ::= * create_vtab68 cmd ::= * create_vtab LP vtabarglist RP69 create_vtab ::= * createkw VIRTUAL TABLE ifnotexists nm dbnm USING nm70 (409) with ::= *71 with ::= * WITH wqlist72 with ::= * WITH RECURSIVE wqlist73 74 SEMI shift-reduce 351 ecmd ::= SEMI75 EXPLAIN shift 466 76 BEGIN shift 300 77 COMMIT shift 407 78 END shift 407 79 ROLLBACK shift 406 80 SAVEPOINT shift 284 81 RELEASE shift 404 82 CREATE shift-reduce 14 createkw ::= CREATE83 ANALYZE shift 247 84 ATTACH shift 338 85 DETACH shift 337 86 PRAGMA shift 249 87 VACUUM shift 178 88 WITH shift 43 89 REINDEX shift 248 90 DROP shift 426 91 SELECT shift 329 92 VALUES shift 584 93 ALTER shift 476 94 input accept95 cmdlist shift 1 96 ecmd shift 1 /* because ecmd==cmdlist */97 cmdx shift 599 98 explain shift 2 99 cmd shift-reduce 2 cmdx ::= cmd100 create_table shift 330 101 createkw shift 158 102 select shift-reduce 84 cmd ::= select103 selectnowith shift 296 104 oneselect shift 296 /* because oneselect==selectnowith */105 values shift 590 106 mvalues shift 579 107 with shift 250 108 alter_add shift 412 109 create_vtab shift 467 110 {default} reduce 409 with ::=111 112State 1:113 (348) input ::= cmdlist *114 cmdlist ::= cmdlist * ecmd115 ecmd ::= * SEMI116 ecmd ::= * cmdx SEMI117 ecmd ::= * explain cmdx SEMI118 explain ::= * EXPLAIN119 explain ::= * EXPLAIN QUERY PLAN120 cmdx ::= * cmd121 cmd ::= * BEGIN transtype trans_opt122 cmd ::= * COMMIT|END trans_opt123 cmd ::= * ROLLBACK trans_opt124 cmd ::= * SAVEPOINT nm125 cmd ::= * RELEASE savepoint_opt nm126 cmd ::= * ROLLBACK trans_opt TO savepoint_opt nm127 cmd ::= * create_table create_table_args128 create_table ::= * createkw temp TABLE ifnotexists nm dbnm129 createkw ::= * CREATE130 cmd ::= * DROP TABLE ifexists fullname131 cmd ::= * createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS select132 cmd ::= * DROP VIEW ifexists fullname133 cmd ::= * select134 select ::= * WITH wqlist selectnowith135 select ::= * WITH RECURSIVE wqlist selectnowith136 select ::= * selectnowith137 selectnowith ::= * oneselect138 selectnowith ::= * selectnowith multiselect_op oneselect139 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt140 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt141 oneselect ::= * values142 values ::= * VALUES LP nexprlist RP143 oneselect ::= * mvalues144 mvalues ::= * values COMMA LP nexprlist RP145 mvalues ::= * mvalues COMMA LP nexprlist RP146 cmd ::= * with DELETE FROM xfullname indexed_opt where_opt_ret147 cmd ::= * with UPDATE orconf xfullname indexed_opt SET setlist from where_opt_ret148 cmd ::= * with insert_cmd INTO xfullname idlist_opt select upsert149 cmd ::= * with insert_cmd INTO xfullname idlist_opt DEFAULT VALUES returning150 cmd ::= * createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP sortlist RP where_opt151 cmd ::= * DROP INDEX ifexists fullname152 cmd ::= * VACUUM vinto153 cmd ::= * VACUUM nm vinto154 cmd ::= * PRAGMA nm dbnm155 cmd ::= * PRAGMA nm dbnm EQ nmnum156 cmd ::= * PRAGMA nm dbnm LP nmnum RP157 cmd ::= * PRAGMA nm dbnm EQ minus_num158 cmd ::= * PRAGMA nm dbnm LP minus_num RP159 cmd ::= * createkw trigger_decl BEGIN trigger_cmd_list END160 cmd ::= * DROP TRIGGER ifexists fullname161 cmd ::= * ATTACH database_kw_opt expr AS expr key_opt162 cmd ::= * DETACH database_kw_opt expr163 cmd ::= * REINDEX164 cmd ::= * REINDEX nm dbnm165 cmd ::= * ANALYZE166 cmd ::= * ANALYZE nm dbnm167 cmd ::= * ALTER TABLE fullname RENAME TO nm168 cmd ::= * alter_add carglist169 alter_add ::= * ALTER TABLE fullname ADD kwcolumn_opt nm typetoken170 cmd ::= * ALTER TABLE fullname DROP kwcolumn_opt nm171 cmd ::= * ALTER TABLE fullname RENAME kwcolumn_opt nm TO nm172 cmd ::= * ALTER TABLE fullname DROP CONSTRAINT nm173 cmd ::= * ALTER TABLE fullname ALTER kwcolumn_opt nm DROP NOT NULL174 cmd ::= * ALTER TABLE fullname ALTER kwcolumn_opt nm SET NOT NULL onconf175 cmd ::= * ALTER TABLE fullname ADD CONSTRAINT nm CHECK LP expr RP onconf176 cmd ::= * ALTER TABLE fullname ADD CHECK LP expr RP onconf177 cmd ::= * create_vtab178 cmd ::= * create_vtab LP vtabarglist RP179 create_vtab ::= * createkw VIRTUAL TABLE ifnotexists nm dbnm USING nm180 (409) with ::= *181 with ::= * WITH wqlist182 with ::= * WITH RECURSIVE wqlist183 184 $ reduce 348 input ::= cmdlist185 SEMI shift-reduce 351 ecmd ::= SEMI186 EXPLAIN shift 466 187 BEGIN shift 300 188 COMMIT shift 407 189 END shift 407 190 ROLLBACK shift 406 191 SAVEPOINT shift 284 192 RELEASE shift 404 193 CREATE shift-reduce 14 createkw ::= CREATE194 ANALYZE shift 247 195 ATTACH shift 338 196 DETACH shift 337 197 PRAGMA shift 249 198 VACUUM shift 178 199 WITH shift 43 200 REINDEX shift 248 201 DROP shift 426 202 SELECT shift 329 203 VALUES shift 584 204 ALTER shift 476 205 ecmd shift-reduce 349 cmdlist ::= cmdlist ecmd206 cmdx shift 599 207 explain shift 2 208 cmd shift-reduce 2 cmdx ::= cmd209 create_table shift 330 210 createkw shift 158 211 select shift-reduce 84 cmd ::= select212 selectnowith shift 296 213 oneselect shift 296 /* because oneselect==selectnowith */214 values shift 590 215 mvalues shift 579 216 with shift 250 217 alter_add shift 412 218 create_vtab shift 467 219 {default} reduce 409 with ::=220 221State 2:222 ecmd ::= explain * cmdx SEMI223 cmdx ::= * cmd224 cmd ::= * BEGIN transtype trans_opt225 cmd ::= * COMMIT|END trans_opt226 cmd ::= * ROLLBACK trans_opt227 cmd ::= * SAVEPOINT nm228 cmd ::= * RELEASE savepoint_opt nm229 cmd ::= * ROLLBACK trans_opt TO savepoint_opt nm230 cmd ::= * create_table create_table_args231 create_table ::= * createkw temp TABLE ifnotexists nm dbnm232 createkw ::= * CREATE233 cmd ::= * DROP TABLE ifexists fullname234 cmd ::= * createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS select235 cmd ::= * DROP VIEW ifexists fullname236 cmd ::= * select237 select ::= * WITH wqlist selectnowith238 select ::= * WITH RECURSIVE wqlist selectnowith239 select ::= * selectnowith240 selectnowith ::= * oneselect241 selectnowith ::= * selectnowith multiselect_op oneselect242 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt243 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt244 oneselect ::= * values245 values ::= * VALUES LP nexprlist RP246 oneselect ::= * mvalues247 mvalues ::= * values COMMA LP nexprlist RP248 mvalues ::= * mvalues COMMA LP nexprlist RP249 cmd ::= * with DELETE FROM xfullname indexed_opt where_opt_ret250 cmd ::= * with UPDATE orconf xfullname indexed_opt SET setlist from where_opt_ret251 cmd ::= * with insert_cmd INTO xfullname idlist_opt select upsert252 cmd ::= * with insert_cmd INTO xfullname idlist_opt DEFAULT VALUES returning253 cmd ::= * createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP sortlist RP where_opt254 cmd ::= * DROP INDEX ifexists fullname255 cmd ::= * VACUUM vinto256 cmd ::= * VACUUM nm vinto257 cmd ::= * PRAGMA nm dbnm258 cmd ::= * PRAGMA nm dbnm EQ nmnum259 cmd ::= * PRAGMA nm dbnm LP nmnum RP260 cmd ::= * PRAGMA nm dbnm EQ minus_num261 cmd ::= * PRAGMA nm dbnm LP minus_num RP262 cmd ::= * createkw trigger_decl BEGIN trigger_cmd_list END263 cmd ::= * DROP TRIGGER ifexists fullname264 cmd ::= * ATTACH database_kw_opt expr AS expr key_opt265 cmd ::= * DETACH database_kw_opt expr266 cmd ::= * REINDEX267 cmd ::= * REINDEX nm dbnm268 cmd ::= * ANALYZE269 cmd ::= * ANALYZE nm dbnm270 cmd ::= * ALTER TABLE fullname RENAME TO nm271 cmd ::= * alter_add carglist272 alter_add ::= * ALTER TABLE fullname ADD kwcolumn_opt nm typetoken273 cmd ::= * ALTER TABLE fullname DROP kwcolumn_opt nm274 cmd ::= * ALTER TABLE fullname RENAME kwcolumn_opt nm TO nm275 cmd ::= * ALTER TABLE fullname DROP CONSTRAINT nm276 cmd ::= * ALTER TABLE fullname ALTER kwcolumn_opt nm DROP NOT NULL277 cmd ::= * ALTER TABLE fullname ALTER kwcolumn_opt nm SET NOT NULL onconf278 cmd ::= * ALTER TABLE fullname ADD CONSTRAINT nm CHECK LP expr RP onconf279 cmd ::= * ALTER TABLE fullname ADD CHECK LP expr RP onconf280 cmd ::= * create_vtab281 cmd ::= * create_vtab LP vtabarglist RP282 create_vtab ::= * createkw VIRTUAL TABLE ifnotexists nm dbnm USING nm283 (409) with ::= *284 with ::= * WITH wqlist285 with ::= * WITH RECURSIVE wqlist286 287 BEGIN shift 300 288 COMMIT shift 407 289 END shift 407 290 ROLLBACK shift 406 291 SAVEPOINT shift 284 292 RELEASE shift 404 293 CREATE shift-reduce 14 createkw ::= CREATE294 ANALYZE shift 247 295 ATTACH shift 338 296 DETACH shift 337 297 PRAGMA shift 249 298 VACUUM shift 178 299 WITH shift 43 300 REINDEX shift 248 301 DROP shift 426 302 SELECT shift 329 303 VALUES shift 584 304 ALTER shift 476 305 cmdx shift 598 306 cmd shift-reduce 2 cmdx ::= cmd307 create_table shift 330 308 createkw shift 158 309 select shift-reduce 84 cmd ::= select310 selectnowith shift 296 311 oneselect shift 296 /* because oneselect==selectnowith */312 values shift 590 313 mvalues shift 579 314 with shift 250 315 alter_add shift 412 316 create_vtab shift 467 317 {default} reduce 409 with ::=318 319State 3:320 nm ::= * ID|INDEXED|JOIN_KW321 nm ::= * STRING322 select ::= * WITH wqlist selectnowith323 select ::= * WITH RECURSIVE wqlist selectnowith324 select ::= * selectnowith325 selectnowith ::= * oneselect326 selectnowith ::= * selectnowith multiselect_op oneselect327 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt328 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt329 oneselect ::= * values330 values ::= * VALUES LP nexprlist RP331 oneselect ::= * mvalues332 mvalues ::= * values COMMA LP nexprlist RP333 mvalues ::= * mvalues COMMA LP nexprlist RP334 expr ::= * term335 expr ::= * LP expr RP336 expr ::= * ID|INDEXED|JOIN_KW337 expr ::= * nm DOT nm338 expr ::= * nm DOT nm DOT nm339 term ::= * NULL|FLOAT|BLOB340 term ::= * STRING341 term ::= * INTEGER342 expr ::= * VARIABLE343 expr ::= * expr COLLATE ID|STRING344 expr ::= * CAST LP expr AS typetoken RP345 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP346 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP347 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP348 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP filter_over349 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP filter_over350 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP filter_over351 term ::= * CTIME_KW352 expr ::= * LP nexprlist COMMA expr RP353 expr ::= * expr AND expr354 expr ::= * expr OR expr355 expr ::= * expr LT|GT|GE|LE expr356 expr ::= * expr EQ|NE expr357 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr358 expr ::= * expr PLUS|MINUS expr359 expr ::= * expr STAR|SLASH|REM expr360 expr ::= * expr CONCAT expr361 expr ::= * expr likeop expr362 expr ::= * expr likeop expr ESCAPE expr363 expr ::= * expr ISNULL|NOTNULL364 expr ::= * expr NOT NULL365 expr ::= * expr IS expr366 expr ::= * expr IS NOT expr367 expr ::= * expr IS NOT DISTINCT FROM expr368 expr ::= * expr IS DISTINCT FROM expr369 expr ::= * NOT expr370 expr ::= * BITNOT expr371 expr ::= * PLUS|MINUS expr372 expr ::= * expr PTR expr373 expr ::= * expr between_op expr AND expr374 expr ::= * expr in_op LP exprlist RP375 expr ::= expr in_op LP * exprlist RP376 expr ::= * LP select RP377 expr ::= * expr in_op LP select RP378 expr ::= expr in_op LP * select RP379 expr ::= * expr in_op nm dbnm paren_exprlist380 expr ::= * EXISTS LP select RP381 expr ::= * CASE case_operand case_exprlist case_else END382 exprlist ::= * nexprlist383 (234) exprlist ::= *384 nexprlist ::= * nexprlist COMMA expr385 nexprlist ::= * expr386 expr ::= * RAISE LP IGNORE RP387 expr ::= * RAISE LP raisetype COMMA expr RP388 term ::= * QNUMBER389 390 NOT shift 127 391 EXISTS shift 585 392 LP shift 4 393 CAST shift 588 394 ID shift 464 395 RAISE shift 582 396 WITH shift 44 397 CTIME_KW shift-reduce 195 term ::= CTIME_KW398 PLUS shift 125 399 MINUS shift 125 400 BITNOT shift 126 401 INDEXED shift 464 402 STRING shift 594 403 JOIN_KW shift 464 404 NULL shift-reduce 183 term ::= NULL|FLOAT|BLOB405 SELECT shift 329 406 VALUES shift 584 407 FLOAT shift-reduce 183 term ::= NULL|FLOAT|BLOB408 BLOB shift-reduce 183 term ::= NULL|FLOAT|BLOB409 INTEGER shift-reduce 185 term ::= INTEGER410 VARIABLE shift-reduce 186 expr ::= VARIABLE411 CASE shift 35 412 QNUMBER shift-reduce 347 term ::= QNUMBER413 nm shift 593 414 select shift 575 415 term shift 84 /* because term==expr */416 expr shift 84 417 selectnowith shift 296 418 oneselect shift 296 /* because oneselect==selectnowith */419 values shift 590 420 nexprlist shift 574 421 mvalues shift 579 422 exprlist shift 576 423 {default} reduce 234 exprlist ::=424 425State 4:426 nm ::= * ID|INDEXED|JOIN_KW427 nm ::= * STRING428 select ::= * WITH wqlist selectnowith429 select ::= * WITH RECURSIVE wqlist selectnowith430 select ::= * selectnowith431 selectnowith ::= * oneselect432 selectnowith ::= * selectnowith multiselect_op oneselect433 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt434 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt435 oneselect ::= * values436 values ::= * VALUES LP nexprlist RP437 oneselect ::= * mvalues438 mvalues ::= * values COMMA LP nexprlist RP439 mvalues ::= * mvalues COMMA LP nexprlist RP440 expr ::= * term441 expr ::= * LP expr RP442 expr ::= LP * expr RP443 expr ::= * ID|INDEXED|JOIN_KW444 expr ::= * nm DOT nm445 expr ::= * nm DOT nm DOT nm446 term ::= * NULL|FLOAT|BLOB447 term ::= * STRING448 term ::= * INTEGER449 expr ::= * VARIABLE450 expr ::= * expr COLLATE ID|STRING451 expr ::= * CAST LP expr AS typetoken RP452 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP453 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP454 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP455 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP filter_over456 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP filter_over457 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP filter_over458 term ::= * CTIME_KW459 expr ::= * LP nexprlist COMMA expr RP460 expr ::= LP * nexprlist COMMA expr RP461 expr ::= * expr AND expr462 expr ::= * expr OR expr463 expr ::= * expr LT|GT|GE|LE expr464 expr ::= * expr EQ|NE expr465 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr466 expr ::= * expr PLUS|MINUS expr467 expr ::= * expr STAR|SLASH|REM expr468 expr ::= * expr CONCAT expr469 expr ::= * expr likeop expr470 expr ::= * expr likeop expr ESCAPE expr471 expr ::= * expr ISNULL|NOTNULL472 expr ::= * expr NOT NULL473 expr ::= * expr IS expr474 expr ::= * expr IS NOT expr475 expr ::= * expr IS NOT DISTINCT FROM expr476 expr ::= * expr IS DISTINCT FROM expr477 expr ::= * NOT expr478 expr ::= * BITNOT expr479 expr ::= * PLUS|MINUS expr480 expr ::= * expr PTR expr481 expr ::= * expr between_op expr AND expr482 expr ::= * expr in_op LP exprlist RP483 expr ::= * LP select RP484 expr ::= LP * select RP485 expr ::= * expr in_op LP select RP486 expr ::= * expr in_op nm dbnm paren_exprlist487 expr ::= * EXISTS LP select RP488 expr ::= * CASE case_operand case_exprlist case_else END489 nexprlist ::= * nexprlist COMMA expr490 nexprlist ::= * expr491 expr ::= * RAISE LP IGNORE RP492 expr ::= * RAISE LP raisetype COMMA expr RP493 term ::= * QNUMBER494 495 NOT shift 127 496 EXISTS shift 585 497 LP shift 4 498 CAST shift 588 499 ID shift 464 500 RAISE shift 582 501 WITH shift 44 502 CTIME_KW shift-reduce 195 term ::= CTIME_KW503 PLUS shift 125 504 MINUS shift 125 505 BITNOT shift 126 506 INDEXED shift 464 507 STRING shift 594 508 JOIN_KW shift 464 509 NULL shift-reduce 183 term ::= NULL|FLOAT|BLOB510 SELECT shift 329 511 VALUES shift 584 512 FLOAT shift-reduce 183 term ::= NULL|FLOAT|BLOB513 BLOB shift-reduce 183 term ::= NULL|FLOAT|BLOB514 INTEGER shift-reduce 185 term ::= INTEGER515 VARIABLE shift-reduce 186 expr ::= VARIABLE516 CASE shift 35 517 QNUMBER shift-reduce 347 term ::= QNUMBER518 nm shift 593 519 select shift 541 520 term shift 63 /* because term==expr */521 expr shift 63 522 selectnowith shift 296 523 oneselect shift 296 /* because oneselect==selectnowith */524 values shift 590 525 nexprlist shift 542 526 mvalues shift 579 527 528State 5:529 select ::= * WITH wqlist selectnowith530 select ::= * WITH RECURSIVE wqlist selectnowith531 select ::= * selectnowith532 selectnowith ::= * oneselect533 selectnowith ::= * selectnowith multiselect_op oneselect534 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt535 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt536 oneselect ::= * values537 values ::= * VALUES LP nexprlist RP538 oneselect ::= * mvalues539 mvalues ::= * values COMMA LP nexprlist RP540 mvalues ::= * mvalues COMMA LP nexprlist RP541 stl_prefix ::= * seltablist joinop542 (110) stl_prefix ::= *543 seltablist ::= * stl_prefix nm dbnm as on_using544 seltablist ::= * stl_prefix nm dbnm as indexed_by on_using545 seltablist ::= * stl_prefix nm dbnm LP exprlist RP as on_using546 seltablist ::= * stl_prefix LP select RP as on_using547 seltablist ::= stl_prefix LP * select RP as on_using548 seltablist ::= * stl_prefix LP seltablist RP as on_using549 seltablist ::= stl_prefix LP * seltablist RP as on_using550 551 WITH shift 44 552 SELECT shift 329 553 VALUES shift 584 554 select shift 547 555 selectnowith shift 296 556 oneselect shift 296 /* because oneselect==selectnowith */557 values shift 590 558 mvalues shift 579 559 seltablist shift 271 560 stl_prefix shift 235 561 {default} reduce 110 stl_prefix ::=562 563State 6:564 select ::= * WITH wqlist selectnowith565 select ::= * WITH RECURSIVE wqlist selectnowith566 select ::= * selectnowith567 selectnowith ::= * oneselect568 selectnowith ::= * selectnowith multiselect_op oneselect569 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt570 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt571 oneselect ::= * values572 values ::= * VALUES LP nexprlist RP573 oneselect ::= * mvalues574 mvalues ::= * values COMMA LP nexprlist RP575 mvalues ::= * mvalues COMMA LP nexprlist RP576 insert_cmd ::= * INSERT orconf577 insert_cmd ::= * REPLACE578 trigger_cmd ::= scanpt * insert_cmd INTO xfullname idlist_opt select upsert scanpt579 trigger_cmd ::= scanpt * select scanpt580 581 REPLACE shift-reduce 174 insert_cmd ::= REPLACE582 WITH shift 44 583 INSERT shift 355 584 SELECT shift 329 585 VALUES shift 584 586 select shift 414 587 selectnowith shift 296 588 oneselect shift 296 /* because oneselect==selectnowith */589 values shift 590 590 mvalues shift 579 591 insert_cmd shift 496 592 593State 7:594 nm ::= * ID|INDEXED|JOIN_KW595 nm ::= * STRING596 expr ::= * term597 expr ::= * LP expr RP598 expr ::= * ID|INDEXED|JOIN_KW599 expr ::= * nm DOT nm600 expr ::= * nm DOT nm DOT nm601 term ::= * NULL|FLOAT|BLOB602 term ::= * STRING603 term ::= * INTEGER604 expr ::= * VARIABLE605 expr ::= * expr COLLATE ID|STRING606 expr ::= * CAST LP expr AS typetoken RP607 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP608 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP609 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP610 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP filter_over611 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP filter_over612 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP filter_over613 term ::= * CTIME_KW614 expr ::= * LP nexprlist COMMA expr RP615 expr ::= * expr AND expr616 expr ::= * expr OR expr617 expr ::= * expr LT|GT|GE|LE expr618 expr ::= * expr EQ|NE expr619 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr620 expr ::= * expr PLUS|MINUS expr621 expr ::= * expr STAR|SLASH|REM expr622 expr ::= * expr CONCAT expr623 expr ::= * expr likeop expr624 expr ::= * expr likeop expr ESCAPE expr625 expr ::= * expr ISNULL|NOTNULL626 expr ::= * expr NOT NULL627 expr ::= * expr IS expr628 expr ::= * expr IS NOT expr629 expr ::= * expr IS NOT DISTINCT FROM expr630 expr ::= * expr IS DISTINCT FROM expr631 expr ::= * NOT expr632 expr ::= * BITNOT expr633 expr ::= * PLUS|MINUS expr634 expr ::= * expr PTR expr635 expr ::= * expr between_op expr AND expr636 expr ::= * expr in_op LP exprlist RP637 expr ::= * LP select RP638 expr ::= * expr in_op LP select RP639 expr ::= * expr in_op nm dbnm paren_exprlist640 expr ::= * EXISTS LP select RP641 expr ::= * CASE case_operand case_exprlist case_else END642 expr ::= * RAISE LP IGNORE RP643 expr ::= * RAISE LP raisetype COMMA expr RP644 frame_opt ::= range_or_rows * frame_bound_s frame_exclude_opt645 frame_opt ::= range_or_rows * BETWEEN frame_bound_s AND frame_bound_e frame_exclude_opt646 frame_bound_s ::= * frame_bound647 frame_bound_s ::= * UNBOUNDED PRECEDING648 frame_bound ::= * expr PRECEDING|FOLLOWING649 frame_bound ::= * CURRENT ROW650 term ::= * QNUMBER651 652 NOT shift 127 653 EXISTS shift 585 654 LP shift 4 655 CAST shift 588 656 BETWEEN shift 9 657 ID shift 464 658 RAISE shift 582 659 CURRENT shift 559 660 UNBOUNDED shift 558 661 CTIME_KW shift-reduce 195 term ::= CTIME_KW662 PLUS shift 125 663 MINUS shift 125 664 BITNOT shift 126 665 INDEXED shift 464 666 STRING shift 594 667 JOIN_KW shift 464 668 NULL shift-reduce 183 term ::= NULL|FLOAT|BLOB669 FLOAT shift-reduce 183 term ::= NULL|FLOAT|BLOB670 BLOB shift-reduce 183 term ::= NULL|FLOAT|BLOB671 INTEGER shift-reduce 185 term ::= INTEGER672 VARIABLE shift-reduce 186 expr ::= VARIABLE673 CASE shift 35 674 QNUMBER shift-reduce 347 term ::= QNUMBER675 nm shift 593 676 term shift 51 /* because term==expr */677 expr shift 51 678 frame_bound shift-reduce 329 frame_bound_s ::= frame_bound679 frame_bound_s shift 391 680 681State 8:682 nm ::= * ID|INDEXED|JOIN_KW683 nm ::= * STRING684 expr ::= * term685 expr ::= * LP expr RP686 expr ::= * ID|INDEXED|JOIN_KW687 expr ::= * nm DOT nm688 expr ::= * nm DOT nm DOT nm689 term ::= * NULL|FLOAT|BLOB690 term ::= * STRING691 term ::= * INTEGER692 expr ::= * VARIABLE693 expr ::= * expr COLLATE ID|STRING694 expr ::= * CAST LP expr AS typetoken RP695 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP696 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP697 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP698 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP filter_over699 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP filter_over700 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP filter_over701 term ::= * CTIME_KW702 expr ::= * LP nexprlist COMMA expr RP703 expr ::= * expr AND expr704 expr ::= * expr OR expr705 expr ::= * expr LT|GT|GE|LE expr706 expr ::= * expr EQ|NE expr707 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr708 expr ::= * expr PLUS|MINUS expr709 expr ::= * expr STAR|SLASH|REM expr710 expr ::= * expr CONCAT expr711 expr ::= * expr likeop expr712 expr ::= * expr likeop expr ESCAPE expr713 expr ::= * expr ISNULL|NOTNULL714 expr ::= * expr NOT NULL715 expr ::= * expr IS expr716 expr ::= * expr IS NOT expr717 expr ::= * expr IS NOT DISTINCT FROM expr718 expr ::= * expr IS DISTINCT FROM expr719 expr ::= * NOT expr720 expr ::= * BITNOT expr721 expr ::= * PLUS|MINUS expr722 expr ::= * expr PTR expr723 expr ::= * expr between_op expr AND expr724 expr ::= * expr in_op LP exprlist RP725 expr ::= * LP select RP726 expr ::= * expr in_op LP select RP727 expr ::= * expr in_op nm dbnm paren_exprlist728 expr ::= * EXISTS LP select RP729 expr ::= * CASE case_operand case_exprlist case_else END730 expr ::= * RAISE LP IGNORE RP731 expr ::= * RAISE LP raisetype COMMA expr RP732 frame_opt ::= range_or_rows BETWEEN frame_bound_s AND * frame_bound_e frame_exclude_opt733 frame_bound_e ::= * frame_bound734 frame_bound_e ::= * UNBOUNDED FOLLOWING735 frame_bound ::= * expr PRECEDING|FOLLOWING736 frame_bound ::= * CURRENT ROW737 term ::= * QNUMBER738 739 NOT shift 127 740 EXISTS shift 585 741 LP shift 4 742 CAST shift 588 743 ID shift 464 744 RAISE shift 582 745 CURRENT shift 559 746 UNBOUNDED shift 560 747 CTIME_KW shift-reduce 195 term ::= CTIME_KW748 PLUS shift 125 749 MINUS shift 125 750 BITNOT shift 126 751 INDEXED shift 464 752 STRING shift 594 753 JOIN_KW shift 464 754 NULL shift-reduce 183 term ::= NULL|FLOAT|BLOB755 FLOAT shift-reduce 183 term ::= NULL|FLOAT|BLOB756 BLOB shift-reduce 183 term ::= NULL|FLOAT|BLOB757 INTEGER shift-reduce 185 term ::= INTEGER758 VARIABLE shift-reduce 186 expr ::= VARIABLE759 CASE shift 35 760 QNUMBER shift-reduce 347 term ::= QNUMBER761 nm shift 593 762 term shift 51 /* because term==expr */763 expr shift 51 764 frame_bound shift-reduce 331 frame_bound_e ::= frame_bound765 frame_bound_e shift 390 766 767State 9:768 nm ::= * ID|INDEXED|JOIN_KW769 nm ::= * STRING770 expr ::= * term771 expr ::= * LP expr RP772 expr ::= * ID|INDEXED|JOIN_KW773 expr ::= * nm DOT nm774 expr ::= * nm DOT nm DOT nm775 term ::= * NULL|FLOAT|BLOB776 term ::= * STRING777 term ::= * INTEGER778 expr ::= * VARIABLE779 expr ::= * expr COLLATE ID|STRING780 expr ::= * CAST LP expr AS typetoken RP781 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP782 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP783 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP784 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP filter_over785 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP filter_over786 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP filter_over787 term ::= * CTIME_KW788 expr ::= * LP nexprlist COMMA expr RP789 expr ::= * expr AND expr790 expr ::= * expr OR expr791 expr ::= * expr LT|GT|GE|LE expr792 expr ::= * expr EQ|NE expr793 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr794 expr ::= * expr PLUS|MINUS expr795 expr ::= * expr STAR|SLASH|REM expr796 expr ::= * expr CONCAT expr797 expr ::= * expr likeop expr798 expr ::= * expr likeop expr ESCAPE expr799 expr ::= * expr ISNULL|NOTNULL800 expr ::= * expr NOT NULL801 expr ::= * expr IS expr802 expr ::= * expr IS NOT expr803 expr ::= * expr IS NOT DISTINCT FROM expr804 expr ::= * expr IS DISTINCT FROM expr805 expr ::= * NOT expr806 expr ::= * BITNOT expr807 expr ::= * PLUS|MINUS expr808 expr ::= * expr PTR expr809 expr ::= * expr between_op expr AND expr810 expr ::= * expr in_op LP exprlist RP811 expr ::= * LP select RP812 expr ::= * expr in_op LP select RP813 expr ::= * expr in_op nm dbnm paren_exprlist814 expr ::= * EXISTS LP select RP815 expr ::= * CASE case_operand case_exprlist case_else END816 expr ::= * RAISE LP IGNORE RP817 expr ::= * RAISE LP raisetype COMMA expr RP818 frame_opt ::= range_or_rows BETWEEN * frame_bound_s AND frame_bound_e frame_exclude_opt819 frame_bound_s ::= * frame_bound820 frame_bound_s ::= * UNBOUNDED PRECEDING821 frame_bound ::= * expr PRECEDING|FOLLOWING822 frame_bound ::= * CURRENT ROW823 term ::= * QNUMBER824 825 NOT shift 127 826 EXISTS shift 585 827 LP shift 4 828 CAST shift 588 829 ID shift 464 830 RAISE shift 582 831 CURRENT shift 559 832 UNBOUNDED shift 558 833 CTIME_KW shift-reduce 195 term ::= CTIME_KW834 PLUS shift 125 835 MINUS shift 125 836 BITNOT shift 126 837 INDEXED shift 464 838 STRING shift 594 839 JOIN_KW shift 464 840 NULL shift-reduce 183 term ::= NULL|FLOAT|BLOB841 FLOAT shift-reduce 183 term ::= NULL|FLOAT|BLOB842 BLOB shift-reduce 183 term ::= NULL|FLOAT|BLOB843 INTEGER shift-reduce 185 term ::= INTEGER844 VARIABLE shift-reduce 186 expr ::= VARIABLE845 CASE shift 35 846 QNUMBER shift-reduce 347 term ::= QNUMBER847 nm shift 593 848 term shift 51 /* because term==expr */849 expr shift 51 850 frame_bound shift-reduce 329 frame_bound_s ::= frame_bound851 frame_bound_s shift 561 852 853State 10:854 nm ::= * ID|INDEXED|JOIN_KW855 nm ::= * STRING856 seltablist ::= stl_prefix nm dbnm LP * exprlist RP as on_using857 expr ::= * term858 expr ::= * LP expr RP859 expr ::= * ID|INDEXED|JOIN_KW860 expr ::= * nm DOT nm861 expr ::= * nm DOT nm DOT nm862 term ::= * NULL|FLOAT|BLOB863 term ::= * STRING864 term ::= * INTEGER865 expr ::= * VARIABLE866 expr ::= * expr COLLATE ID|STRING867 expr ::= * CAST LP expr AS typetoken RP868 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP869 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP870 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP871 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP filter_over872 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP filter_over873 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP filter_over874 term ::= * CTIME_KW875 expr ::= * LP nexprlist COMMA expr RP876 expr ::= * expr AND expr877 expr ::= * expr OR expr878 expr ::= * expr LT|GT|GE|LE expr879 expr ::= * expr EQ|NE expr880 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr881 expr ::= * expr PLUS|MINUS expr882 expr ::= * expr STAR|SLASH|REM expr883 expr ::= * expr CONCAT expr884 expr ::= * expr likeop expr885 expr ::= * expr likeop expr ESCAPE expr886 expr ::= * expr ISNULL|NOTNULL887 expr ::= * expr NOT NULL888 expr ::= * expr IS expr889 expr ::= * expr IS NOT expr890 expr ::= * expr IS NOT DISTINCT FROM expr891 expr ::= * expr IS DISTINCT FROM expr892 expr ::= * NOT expr893 expr ::= * BITNOT expr894 expr ::= * PLUS|MINUS expr895 expr ::= * expr PTR expr896 expr ::= * expr between_op expr AND expr897 expr ::= * expr in_op LP exprlist RP898 expr ::= * LP select RP899 expr ::= * expr in_op LP select RP900 expr ::= * expr in_op nm dbnm paren_exprlist901 expr ::= * EXISTS LP select RP902 expr ::= * CASE case_operand case_exprlist case_else END903 exprlist ::= * nexprlist904 (234) exprlist ::= *905 nexprlist ::= * nexprlist COMMA expr906 nexprlist ::= * expr907 expr ::= * RAISE LP IGNORE RP908 expr ::= * RAISE LP raisetype COMMA expr RP909 term ::= * QNUMBER910 911 NOT shift 127 912 EXISTS shift 585 913 LP shift 4 914 CAST shift 588 915 ID shift 464 916 RAISE shift 582 917 CTIME_KW shift-reduce 195 term ::= CTIME_KW918 PLUS shift 125 919 MINUS shift 125 920 BITNOT shift 126 921 INDEXED shift 464 922 STRING shift 594 923 JOIN_KW shift 464 924 NULL shift-reduce 183 term ::= NULL|FLOAT|BLOB925 FLOAT shift-reduce 183 term ::= NULL|FLOAT|BLOB926 BLOB shift-reduce 183 term ::= NULL|FLOAT|BLOB927 INTEGER shift-reduce 185 term ::= INTEGER928 VARIABLE shift-reduce 186 expr ::= VARIABLE929 CASE shift 35 930 QNUMBER shift-reduce 347 term ::= QNUMBER931 nm shift 593 932 term shift 84 /* because term==expr */933 expr shift 84 934 nexprlist shift 574 935 exprlist shift 548 936 {default} reduce 234 exprlist ::=937 938State 11:939 nm ::= * ID|INDEXED|JOIN_KW940 nm ::= * STRING941 expr ::= * term942 expr ::= * LP expr RP943 expr ::= * ID|INDEXED|JOIN_KW944 expr ::= * nm DOT nm945 expr ::= * nm DOT nm DOT nm946 term ::= * NULL|FLOAT|BLOB947 term ::= * STRING948 term ::= * INTEGER949 expr ::= * VARIABLE950 expr ::= * expr COLLATE ID|STRING951 expr ::= * CAST LP expr AS typetoken RP952 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP953 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP954 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP955 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP filter_over956 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP filter_over957 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP filter_over958 term ::= * CTIME_KW959 expr ::= * LP nexprlist COMMA expr RP960 expr ::= * expr AND expr961 expr ::= * expr OR expr962 expr ::= * expr LT|GT|GE|LE expr963 expr ::= * expr EQ|NE expr964 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr965 expr ::= * expr PLUS|MINUS expr966 expr ::= * expr STAR|SLASH|REM expr967 expr ::= * expr CONCAT expr968 expr ::= * expr likeop expr969 expr ::= * expr likeop expr ESCAPE expr970 expr ::= * expr ISNULL|NOTNULL971 expr ::= * expr NOT NULL972 expr ::= * expr IS expr973 expr ::= * expr IS NOT expr974 expr ::= * expr IS NOT DISTINCT FROM expr975 expr ::= * expr IS DISTINCT FROM expr976 expr ::= * NOT expr977 expr ::= * BITNOT expr978 expr ::= * PLUS|MINUS expr979 expr ::= * expr PTR expr980 expr ::= * expr between_op expr AND expr981 expr ::= * expr in_op LP exprlist RP982 expr ::= * LP select RP983 expr ::= * expr in_op LP select RP984 expr ::= * expr in_op nm dbnm paren_exprlist985 expr ::= * EXISTS LP select RP986 expr ::= * CASE case_operand case_exprlist case_else END987 exprlist ::= * nexprlist988 (234) exprlist ::= *989 nexprlist ::= * nexprlist COMMA expr990 nexprlist ::= * expr991 paren_exprlist ::= LP * exprlist RP992 expr ::= * RAISE LP IGNORE RP993 expr ::= * RAISE LP raisetype COMMA expr RP994 term ::= * QNUMBER995 996 NOT shift 127 997 EXISTS shift 585 998 LP shift 4 999 CAST shift 588 1000 ID shift 464 1001 RAISE shift 582 1002 CTIME_KW shift-reduce 195 term ::= CTIME_KW1003 PLUS shift 125 1004 MINUS shift 125 1005 BITNOT shift 126 1006 INDEXED shift 464 1007 STRING shift 594 1008 JOIN_KW shift 464 1009 NULL shift-reduce 183 term ::= NULL|FLOAT|BLOB1010 FLOAT shift-reduce 183 term ::= NULL|FLOAT|BLOB1011 BLOB shift-reduce 183 term ::= NULL|FLOAT|BLOB1012 INTEGER shift-reduce 185 term ::= INTEGER1013 VARIABLE shift-reduce 186 expr ::= VARIABLE1014 CASE shift 35 1015 QNUMBER shift-reduce 347 term ::= QNUMBER1016 nm shift 593 1017 term shift 84 /* because term==expr */1018 expr shift 84 1019 nexprlist shift 574 1020 exprlist shift 573 1021 {default} reduce 234 exprlist ::=1022 1023State 12:1024 nm ::= * ID|INDEXED|JOIN_KW1025 nm ::= * STRING1026 expr ::= * term1027 expr ::= * LP expr RP1028 expr ::= * ID|INDEXED|JOIN_KW1029 expr ::= * nm DOT nm1030 expr ::= * nm DOT nm DOT nm1031 term ::= * NULL|FLOAT|BLOB1032 term ::= * STRING1033 term ::= * INTEGER1034 expr ::= * VARIABLE1035 expr ::= * expr COLLATE ID|STRING1036 expr ::= * CAST LP expr AS typetoken RP1037 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP1038 expr ::= ID|INDEXED|JOIN_KW LP distinct * exprlist RP1039 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP1040 expr ::= ID|INDEXED|JOIN_KW LP distinct * exprlist ORDER BY sortlist RP1041 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP1042 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist RP filter_over1043 expr ::= ID|INDEXED|JOIN_KW LP distinct * exprlist RP filter_over1044 expr ::= * ID|INDEXED|JOIN_KW LP distinct exprlist ORDER BY sortlist RP filter_over1045 expr ::= ID|INDEXED|JOIN_KW LP distinct * exprlist ORDER BY sortlist RP filter_over1046 expr ::= * ID|INDEXED|JOIN_KW LP STAR RP filter_over1047 term ::= * CTIME_KW1048 expr ::= * LP nexprlist COMMA expr RP1049 expr ::= * expr AND expr1050 expr ::= * expr OR expr1051 expr ::= * expr LT|GT|GE|LE expr1052 expr ::= * expr EQ|NE expr1053 expr ::= * expr BITAND|BITOR|LSHIFT|RSHIFT expr1054 expr ::= * expr PLUS|MINUS expr1055 expr ::= * expr STAR|SLASH|REM expr1056 expr ::= * expr CONCAT expr1057 expr ::= * expr likeop expr1058 expr ::= * expr likeop expr ESCAPE expr1059 expr ::= * expr ISNULL|NOTNULL1060 expr ::= * expr NOT NULL1061 expr ::= * expr IS expr1062 expr ::= * expr IS NOT expr1063 expr ::= * expr IS NOT DISTINCT FROM expr1064 expr ::= * expr IS DISTINCT FROM expr1065 expr ::= * NOT expr1066 expr ::= * BITNOT expr1067 expr ::= * PLUS|MINUS expr1068 expr ::= * expr PTR expr1069 expr ::= * expr between_op expr AND expr1070 expr ::= * expr in_op LP exprlist RP1071 expr ::= * LP select RP1072 expr ::= * expr in_op LP select RP1073 expr ::= * expr in_op nm dbnm paren_exprlist1074 expr ::= * EXISTS LP select RP1075 expr ::= * CASE case_operand case_exprlist case_else END1076 exprlist ::= * nexprlist1077 (234) exprlist ::= *1078 nexprlist ::= * nexprlist COMMA expr1079 nexprlist ::= * expr1080 expr ::= * RAISE LP IGNORE RP1081 expr ::= * RAISE LP raisetype COMMA expr RP1082 term ::= * QNUMBER1083 1084 NOT shift 127 1085 EXISTS shift 585 1086 LP shift 4 1087 CAST shift 588 1088 ID shift 464 1089 RAISE shift 582 1090 CTIME_KW shift-reduce 195 term ::= CTIME_KW1091 PLUS shift 125 1092 MINUS shift 125 1093 BITNOT shift 126 1094 INDEXED shift 464 1095 STRING shift 594 1096 JOIN_KW shift 464 1097 NULL shift-reduce 183 term ::= NULL|FLOAT|BLOB1098 FLOAT shift-reduce 183 term ::= NULL|FLOAT|BLOB1099 BLOB shift-reduce 183 term ::= NULL|FLOAT|BLOB1100 INTEGER shift-reduce 185 term ::= INTEGER1101 VARIABLE shift-reduce 186 expr ::= VARIABLE1102 CASE shift 35 1103 QNUMBER shift-reduce 347 term ::= QNUMBER1104 nm shift 593 1105 term shift 84 /* because term==expr */1106 expr shift 84 1107 nexprlist shift 574 1108 exprlist shift 451 1109 {default} reduce 234 exprlist ::=1110 1111State 13:1112 select ::= * WITH wqlist selectnowith1113 select ::= * WITH RECURSIVE wqlist selectnowith1114 select ::= * selectnowith1115 selectnowith ::= * oneselect1116 selectnowith ::= * selectnowith multiselect_op oneselect1117 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt1118 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt1119 oneselect ::= * values1120 values ::= * VALUES LP nexprlist RP1121 oneselect ::= * mvalues1122 mvalues ::= * values COMMA LP nexprlist RP1123 mvalues ::= * mvalues COMMA LP nexprlist RP1124 cmd ::= with insert_cmd INTO xfullname idlist_opt * select upsert1125 cmd ::= with insert_cmd INTO xfullname idlist_opt * DEFAULT VALUES returning1126 1127 WITH shift 44 1128 DEFAULT shift 479 1129 SELECT shift 329 1130 VALUES shift 584 1131 select shift 303 1132 selectnowith shift 296 1133 oneselect shift 296 /* because oneselect==selectnowith */1134 values shift 590 1135 mvalues shift 579 1136 1137State 14:1138 select ::= * WITH wqlist selectnowith1139 select ::= * WITH RECURSIVE wqlist selectnowith1140 select ::= * selectnowith1141 selectnowith ::= * oneselect1142 selectnowith ::= * selectnowith multiselect_op oneselect1143 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt1144 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt1145 oneselect ::= * values1146 values ::= * VALUES LP nexprlist RP1147 oneselect ::= * mvalues1148 mvalues ::= * values COMMA LP nexprlist RP1149 mvalues ::= * mvalues COMMA LP nexprlist RP1150 trigger_cmd ::= scanpt insert_cmd INTO xfullname idlist_opt * select upsert scanpt1151 1152 WITH shift 44 1153 SELECT shift 329 1154 VALUES shift 584 1155 select shift 312 1156 selectnowith shift 296 1157 oneselect shift 296 /* because oneselect==selectnowith */1158 values shift 590 1159 mvalues shift 579 1160 1161State 15:1162 cmd ::= createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS * select1163 select ::= * WITH wqlist selectnowith1164 select ::= * WITH RECURSIVE wqlist selectnowith1165 select ::= * selectnowith1166 selectnowith ::= * oneselect1167 selectnowith ::= * selectnowith multiselect_op oneselect1168 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt1169 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt1170 oneselect ::= * values1171 values ::= * VALUES LP nexprlist RP1172 oneselect ::= * mvalues1173 mvalues ::= * values COMMA LP nexprlist RP1174 mvalues ::= * mvalues COMMA LP nexprlist RP1175 1176 WITH shift 44 1177 SELECT shift 329 1178 VALUES shift 584 1179 select shift-reduce 82 cmd ::= createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS select1180 selectnowith shift 296 1181 oneselect shift 296 /* because oneselect==selectnowith */1182 values shift 590 1183 mvalues shift 579 1184 1185State 16:1186 create_table_args ::= AS * select1187 select ::= * WITH wqlist selectnowith1188 select ::= * WITH RECURSIVE wqlist selectnowith1189 select ::= * selectnowith1190 selectnowith ::= * oneselect1191 selectnowith ::= * selectnowith multiselect_op oneselect1192 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt1193 oneselect ::= * SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt1194 oneselect ::= * values1195 values ::= * VALUES LP nexprlist RP1196 oneselect ::= * mvalues1197 mvalues ::= * values COMMA LP nexprlist RP1198 mvalues ::= * mvalues COMMA LP nexprlist RP1199 1200 WITH shift 44