diff -r 000000000000 -r 08ec8eefde2f persistentstorage/sql/SQLite364/parse.c --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/persistentstorage/sql/SQLite364/parse.c Fri Jan 22 11:06:30 2010 +0200 @@ -0,0 +1,3498 @@ +/* Driver template for the LEMON parser generator. +** The author disclaims copyright to this source code. +*/ +/* First off, code is included that follows the "include" declaration +** in the input grammar file. */ +#include +#line 51 "parse.y" + +#include "sqliteInt.h" + +/* +** An instance of this structure holds information about the +** LIMIT clause of a SELECT statement. +*/ +struct LimitVal { + Expr *pLimit; /* The LIMIT expression. NULL if there is no limit */ + Expr *pOffset; /* The OFFSET expression. NULL if there is none */ +}; + +/* +** An instance of this structure is used to store the LIKE, +** GLOB, NOT LIKE, and NOT GLOB operators. +*/ +struct LikeOp { + Token eOperator; /* "like" or "glob" or "regexp" */ + int not; /* True if the NOT keyword is present */ +}; + +/* +** An instance of the following structure describes the event of a +** TRIGGER. "a" is the event type, one of TK_UPDATE, TK_INSERT, +** TK_DELETE, or TK_INSTEAD. If the event is of the form +** +** UPDATE ON (a,b,c) +** +** Then the "b" IdList records the list "a,b,c". +*/ +struct TrigEvent { int a; IdList * b; }; + +/* +** An instance of this structure holds the ATTACH key and the key type. +*/ +struct AttachKey { int type; Token key; }; + +#line 48 "parse.c" +/* Next is all token values, in a form suitable for use by makeheaders. +** This section will be null unless lemon is run with the -m switch. +*/ +/* +** These constants (all generated automatically by the parser generator) +** specify the various kinds of tokens (terminals) that the parser +** understands. +** +** Each symbol here is a terminal symbol in the grammar. +*/ +/* Make sure the INTERFACE macro is defined. +*/ +#ifndef INTERFACE +# define INTERFACE 1 +#endif +/* The next thing included is series of defines which control +** various aspects of the generated parser. +** YYCODETYPE is the data type used for storing terminal +** and nonterminal numbers. "unsigned char" is +** used if there are fewer than 250 terminals +** and nonterminals. "int" is used otherwise. +** YYNOCODE is a number of type YYCODETYPE which corresponds +** to no legal terminal or nonterminal number. This +** number is used to fill in empty slots of the hash +** table. +** YYFALLBACK If defined, this indicates that one or more tokens +** have fall-back values which should be used if the +** original value of the token will not parse. +** YYACTIONTYPE is the data type used for storing terminal +** and nonterminal numbers. "unsigned char" is +** used if there are fewer than 250 rules and +** states combined. "int" is used otherwise. +** sqlite3ParserTOKENTYPE is the data type used for minor tokens given +** directly to the parser from the tokenizer. +** YYMINORTYPE is the data type used for all minor tokens. +** This is typically a union of many types, one of +** which is sqlite3ParserTOKENTYPE. The entry in the union +** for base tokens is called "yy0". +** YYSTACKDEPTH is the maximum depth of the parser's stack. If +** zero the stack is dynamically sized using realloc() +** sqlite3ParserARG_SDECL A static variable declaration for the %extra_argument +** sqlite3ParserARG_PDECL A parameter declaration for the %extra_argument +** sqlite3ParserARG_STORE Code to store %extra_argument into yypParser +** sqlite3ParserARG_FETCH Code to extract %extra_argument from yypParser +** YYNSTATE the combined number of states. +** YYNRULE the number of rules in the grammar +** YYERRORSYMBOL is the code number of the error symbol. If not +** defined, then do no error processing. +*/ +#define YYCODETYPE unsigned char +#define YYNOCODE 243 +#define YYACTIONTYPE unsigned short int +#define YYWILDCARD 59 +#define sqlite3ParserTOKENTYPE Token +typedef union { + sqlite3ParserTOKENTYPE yy0; + struct LikeOp yy30; + Select* yy91; + IdList* yy232; + struct {int value; int mask;} yy319; + ExprList* yy322; + int yy328; + struct TrigEvent yy378; + struct LimitVal yy388; + Expr* yy418; + SrcList* yy439; + TriggerStep* yy451; +} YYMINORTYPE; +#ifndef YYSTACKDEPTH +#define YYSTACKDEPTH 100 +#endif +#define sqlite3ParserARG_SDECL Parse *pParse; +#define sqlite3ParserARG_PDECL ,Parse *pParse +#define sqlite3ParserARG_FETCH Parse *pParse = yypParser->pParse +#define sqlite3ParserARG_STORE yypParser->pParse = pParse +#define YYNSTATE 578 +#define YYNRULE 303 +#define YYFALLBACK 1 +#define YY_NO_ACTION (YYNSTATE+YYNRULE+2) +#define YY_ACCEPT_ACTION (YYNSTATE+YYNRULE+1) +#define YY_ERROR_ACTION (YYNSTATE+YYNRULE) + +/* The yyzerominor constant is used to initialize instances of +** YYMINORTYPE objects to zero. */ +#ifdef __cplusplus +static YYMINORTYPE yyzerominor; +#else +static const YYMINORTYPE yyzerominor; +#endif + +/* Next are the tables used to determine what action to take based on the +** current state and lookahead token. These tables are used to implement +** functions that take a state number and lookahead value and return an +** action integer. +** +** Suppose the action integer is N. Then the action is determined as +** follows +** +** 0 <= N < YYNSTATE Shift N. That is, push the lookahead +** token onto the stack and goto state N. +** +** YYNSTATE <= N < YYNSTATE+YYNRULE Reduce by rule N-YYNSTATE. +** +** N == YYNSTATE+YYNRULE A syntax error has occurred. +** +** N == YYNSTATE+YYNRULE+1 The parser accepts its input. +** +** N == YYNSTATE+YYNRULE+2 No such action. Denotes unused +** slots in the yy_action[] table. +** +** The action table is constructed as a single large table named yy_action[]. +** Given state S and lookahead X, the action is computed as +** +** yy_action[ yy_shift_ofst[S] + X ] +** +** If the index value yy_shift_ofst[S]+X is out of range or if the value +** yy_lookahead[yy_shift_ofst[S]+X] is not equal to X or if yy_shift_ofst[S] +** is equal to YY_SHIFT_USE_DFLT, it means that the action is not in the table +** and that yy_default[S] should be used instead. +** +** The formula above is for computing the action when the lookahead is +** a terminal symbol. If the lookahead is a non-terminal (as occurs after +** a reduce action) then the yy_reduce_ofst[] array is used in place of +** the yy_shift_ofst[] array and YY_REDUCE_USE_DFLT is used in place of +** YY_SHIFT_USE_DFLT. +** +** The following are the tables generated in this section: +** +** yy_action[] A single table containing all actions. +** yy_lookahead[] A table containing the lookahead for each entry in +** yy_action. Used to detect hash collisions. +** yy_shift_ofst[] For each state, the offset into yy_action for +** shifting terminals. +** yy_reduce_ofst[] For each state, the offset into yy_action for +** shifting non-terminals after a reduce. +** yy_default[] Default action for each state. +*/ +static const YYACTIONTYPE yy_action[] = { + /* 0 */ 288, 882, 118, 577, 2, 169, 412, 412, 62, 62, + /* 10 */ 62, 62, 205, 64, 64, 64, 64, 65, 65, 66, + /* 20 */ 66, 66, 67, 207, 385, 382, 419, 425, 69, 64, + /* 30 */ 64, 64, 64, 65, 65, 66, 66, 66, 67, 207, + /* 40 */ 445, 443, 317, 165, 61, 60, 293, 429, 430, 426, + /* 50 */ 426, 63, 63, 62, 62, 62, 62, 251, 64, 64, + /* 60 */ 64, 64, 65, 65, 66, 66, 66, 67, 207, 288, + /* 70 */ 485, 412, 412, 207, 414, 83, 68, 456, 70, 151, + /* 80 */ 64, 64, 64, 64, 65, 65, 66, 66, 66, 67, + /* 90 */ 207, 68, 299, 70, 151, 419, 425, 441, 209, 59, + /* 100 */ 65, 65, 66, 66, 66, 67, 207, 416, 416, 416, + /* 110 */ 484, 569, 288, 61, 60, 293, 429, 430, 426, 426, + /* 120 */ 63, 63, 62, 62, 62, 62, 311, 64, 64, 64, + /* 130 */ 64, 65, 65, 66, 66, 66, 67, 207, 419, 425, + /* 140 */ 95, 66, 66, 66, 67, 207, 390, 263, 408, 35, + /* 150 */ 57, 22, 472, 172, 404, 412, 61, 60, 293, 429, + /* 160 */ 430, 426, 426, 63, 63, 62, 62, 62, 62, 162, + /* 170 */ 64, 64, 64, 64, 65, 65, 66, 66, 66, 67, + /* 180 */ 207, 288, 578, 385, 382, 567, 109, 409, 264, 445, + /* 190 */ 403, 325, 307, 387, 486, 311, 336, 204, 514, 173, + /* 200 */ 157, 441, 209, 566, 197, 334, 230, 419, 425, 146, + /* 210 */ 147, 391, 392, 68, 295, 70, 151, 408, 42, 485, + /* 220 */ 412, 563, 564, 414, 288, 61, 60, 293, 429, 430, + /* 230 */ 426, 426, 63, 63, 62, 62, 62, 62, 409, 64, + /* 240 */ 64, 64, 64, 65, 65, 66, 66, 66, 67, 207, + /* 250 */ 419, 425, 402, 517, 527, 263, 416, 416, 416, 211, + /* 260 */ 545, 514, 612, 374, 520, 377, 208, 288, 61, 60, + /* 270 */ 293, 429, 430, 426, 426, 63, 63, 62, 62, 62, + /* 280 */ 62, 567, 64, 64, 64, 64, 65, 65, 66, 66, + /* 290 */ 66, 67, 207, 419, 425, 519, 379, 296, 544, 566, + /* 300 */ 565, 229, 468, 285, 529, 21, 443, 518, 165, 67, + /* 310 */ 207, 61, 60, 293, 429, 430, 426, 426, 63, 63, + /* 320 */ 62, 62, 62, 62, 468, 64, 64, 64, 64, 65, + /* 330 */ 65, 66, 66, 66, 67, 207, 526, 501, 237, 450, + /* 340 */ 78, 213, 288, 525, 296, 519, 480, 381, 369, 269, + /* 350 */ 268, 451, 390, 205, 401, 21, 322, 149, 311, 205, + /* 360 */ 463, 562, 208, 241, 452, 219, 321, 368, 419, 425, + /* 370 */ 156, 161, 114, 243, 339, 248, 340, 174, 148, 528, + /* 380 */ 408, 36, 330, 81, 252, 238, 61, 60, 293, 429, + /* 390 */ 430, 426, 426, 63, 63, 62, 62, 62, 62, 5, + /* 400 */ 64, 64, 64, 64, 65, 65, 66, 66, 66, 67, + /* 410 */ 207, 288, 219, 489, 490, 483, 390, 391, 392, 114, + /* 420 */ 243, 339, 248, 340, 174, 180, 311, 155, 341, 344, + /* 430 */ 345, 252, 519, 236, 152, 384, 2, 419, 425, 346, + /* 440 */ 180, 574, 21, 341, 344, 345, 206, 390, 408, 35, + /* 450 */ 225, 468, 463, 56, 346, 61, 60, 293, 429, 430, + /* 460 */ 426, 426, 63, 63, 62, 62, 62, 62, 409, 64, + /* 470 */ 64, 64, 64, 65, 65, 66, 66, 66, 67, 207, + /* 480 */ 288, 391, 392, 180, 500, 487, 341, 344, 345, 312, + /* 490 */ 476, 325, 337, 311, 405, 311, 324, 346, 542, 490, + /* 500 */ 420, 421, 441, 150, 168, 157, 419, 425, 68, 544, + /* 510 */ 70, 151, 391, 392, 389, 408, 42, 408, 28, 407, + /* 520 */ 198, 423, 424, 406, 61, 60, 293, 429, 430, 426, + /* 530 */ 426, 63, 63, 62, 62, 62, 62, 409, 64, 64, + /* 540 */ 64, 64, 65, 65, 66, 66, 66, 67, 207, 288, + /* 550 */ 422, 311, 450, 255, 409, 349, 327, 212, 311, 369, + /* 560 */ 269, 268, 115, 479, 451, 311, 393, 394, 395, 433, + /* 570 */ 205, 415, 191, 408, 50, 419, 425, 452, 472, 491, + /* 580 */ 408, 50, 175, 539, 535, 356, 535, 408, 35, 492, + /* 590 */ 294, 436, 437, 61, 60, 293, 429, 430, 426, 426, + /* 600 */ 63, 63, 62, 62, 62, 62, 409, 64, 64, 64, + /* 610 */ 64, 65, 65, 66, 66, 66, 67, 207, 288, 442, + /* 620 */ 304, 251, 1, 94, 10, 537, 390, 305, 390, 536, + /* 630 */ 329, 367, 316, 436, 437, 472, 169, 290, 412, 407, + /* 640 */ 357, 358, 252, 406, 419, 425, 439, 439, 18, 314, + /* 650 */ 323, 432, 432, 370, 208, 314, 220, 432, 432, 541, + /* 660 */ 272, 288, 61, 60, 293, 429, 430, 426, 426, 63, + /* 670 */ 63, 62, 62, 62, 62, 390, 64, 64, 64, 64, + /* 680 */ 65, 65, 66, 66, 66, 67, 207, 419, 425, 446, + /* 690 */ 454, 391, 392, 391, 392, 462, 208, 303, 275, 817, + /* 700 */ 273, 291, 191, 412, 288, 61, 60, 293, 429, 430, + /* 710 */ 426, 426, 63, 63, 62, 62, 62, 62, 366, 64, + /* 720 */ 64, 64, 64, 65, 65, 66, 66, 66, 67, 207, + /* 730 */ 419, 425, 478, 175, 333, 314, 409, 432, 432, 458, + /* 740 */ 391, 392, 176, 177, 178, 195, 459, 288, 61, 71, + /* 750 */ 293, 429, 430, 426, 426, 63, 63, 62, 62, 62, + /* 760 */ 62, 367, 64, 64, 64, 64, 65, 65, 66, 66, + /* 770 */ 66, 67, 207, 419, 425, 314, 359, 432, 432, 409, + /* 780 */ 274, 362, 467, 363, 221, 257, 251, 251, 290, 251, + /* 790 */ 288, 503, 60, 293, 429, 430, 426, 426, 63, 63, + /* 800 */ 62, 62, 62, 62, 335, 64, 64, 64, 64, 65, + /* 810 */ 65, 66, 66, 66, 67, 207, 419, 425, 390, 471, + /* 820 */ 390, 300, 301, 261, 302, 259, 408, 3, 77, 153, + /* 830 */ 79, 263, 366, 332, 182, 473, 293, 429, 430, 426, + /* 840 */ 426, 63, 63, 62, 62, 62, 62, 311, 64, 64, + /* 850 */ 64, 64, 65, 65, 66, 66, 66, 67, 207, 73, + /* 860 */ 318, 179, 4, 409, 263, 311, 292, 263, 409, 408, + /* 870 */ 29, 311, 552, 311, 315, 73, 318, 311, 4, 508, + /* 880 */ 311, 509, 292, 391, 392, 391, 392, 408, 24, 185, + /* 890 */ 315, 320, 263, 408, 33, 408, 54, 311, 224, 408, + /* 900 */ 53, 445, 408, 99, 311, 554, 311, 320, 555, 464, + /* 910 */ 20, 465, 142, 249, 263, 193, 502, 445, 311, 408, + /* 920 */ 97, 76, 75, 409, 263, 506, 408, 102, 408, 103, + /* 930 */ 74, 309, 310, 556, 313, 414, 498, 76, 75, 477, + /* 940 */ 408, 108, 376, 188, 311, 507, 74, 309, 310, 73, + /* 950 */ 318, 414, 4, 205, 311, 222, 292, 311, 495, 496, + /* 960 */ 311, 205, 263, 244, 315, 223, 408, 110, 416, 416, + /* 970 */ 416, 417, 418, 12, 245, 375, 408, 17, 250, 408, + /* 980 */ 100, 320, 408, 34, 416, 416, 416, 417, 418, 12, + /* 990 */ 461, 445, 434, 159, 23, 311, 521, 298, 226, 227, + /* 1000 */ 228, 105, 256, 278, 311, 470, 311, 170, 311, 258, + /* 1010 */ 427, 76, 75, 260, 202, 85, 280, 408, 98, 353, + /* 1020 */ 74, 309, 310, 281, 311, 414, 408, 25, 408, 55, + /* 1030 */ 408, 111, 311, 262, 311, 200, 510, 544, 179, 505, + /* 1040 */ 504, 199, 311, 231, 201, 311, 408, 112, 311, 254, + /* 1050 */ 311, 179, 311, 267, 408, 113, 408, 26, 416, 416, + /* 1060 */ 416, 417, 418, 12, 408, 37, 399, 408, 38, 311, + /* 1070 */ 408, 27, 408, 39, 408, 40, 348, 311, 179, 311, + /* 1080 */ 540, 145, 179, 548, 311, 170, 311, 372, 277, 268, + /* 1090 */ 311, 408, 41, 289, 549, 311, 92, 311, 205, 408, + /* 1100 */ 43, 408, 44, 311, 361, 311, 408, 45, 408, 30, + /* 1110 */ 19, 364, 408, 31, 559, 311, 92, 408, 46, 408, + /* 1120 */ 47, 311, 365, 378, 270, 408, 48, 408, 49, 311, + /* 1130 */ 271, 311, 561, 144, 279, 282, 438, 408, 32, 283, + /* 1140 */ 573, 413, 440, 408, 11, 319, 160, 501, 457, 239, + /* 1150 */ 460, 408, 51, 408, 52, 512, 547, 515, 276, 8, + /* 1160 */ 558, 388, 246, 511, 373, 396, 397, 513, 398, 7, + /* 1170 */ 343, 85, 308, 232, 328, 58, 233, 84, 80, 326, + /* 1180 */ 167, 455, 210, 119, 86, 338, 331, 410, 297, 494, + /* 1190 */ 498, 122, 488, 217, 493, 234, 247, 235, 286, 411, + /* 1200 */ 497, 350, 287, 499, 522, 516, 523, 240, 524, 469, + /* 1210 */ 242, 183, 475, 354, 89, 530, 184, 117, 352, 186, + /* 1220 */ 543, 130, 192, 187, 532, 189, 140, 371, 360, 131, + /* 1230 */ 216, 132, 133, 218, 550, 557, 134, 136, 306, 570, + /* 1240 */ 575, 571, 265, 572, 533, 386, 400, 613, 215, 139, + /* 1250 */ 93, 96, 107, 104, 614, 101, 163, 164, 428, 431, + /* 1260 */ 72, 447, 435, 444, 141, 154, 6, 448, 466, 449, + /* 1270 */ 166, 453, 14, 120, 82, 13, 171, 474, 121, 158, + /* 1280 */ 481, 482, 214, 87, 342, 123, 124, 116, 253, 88, + /* 1290 */ 125, 181, 245, 351, 143, 531, 126, 170, 355, 266, + /* 1300 */ 347, 190, 128, 9, 127, 546, 129, 90, 534, 15, + /* 1310 */ 538, 194, 196, 551, 553, 137, 138, 106, 135, 16, + /* 1320 */ 560, 568, 284, 203, 383, 883, 380, 576, 883, 883, + /* 1330 */ 883, 91, +}; +static const YYCODETYPE yy_lookahead[] = { + /* 0 */ 16, 140, 141, 142, 143, 21, 23, 23, 69, 70, + /* 10 */ 71, 72, 110, 74, 75, 76, 77, 78, 79, 80, + /* 20 */ 81, 82, 83, 84, 1, 2, 42, 43, 73, 74, + /* 30 */ 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, + /* 40 */ 58, 162, 163, 164, 60, 61, 62, 63, 64, 65, + /* 50 */ 66, 67, 68, 69, 70, 71, 72, 148, 74, 75, + /* 60 */ 76, 77, 78, 79, 80, 81, 82, 83, 84, 16, + /* 70 */ 88, 88, 88, 84, 92, 22, 219, 220, 221, 222, + /* 80 */ 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, + /* 90 */ 84, 219, 183, 221, 222, 42, 43, 78, 79, 46, + /* 100 */ 78, 79, 80, 81, 82, 83, 84, 125, 126, 127, + /* 110 */ 170, 239, 16, 60, 61, 62, 63, 64, 65, 66, + /* 120 */ 67, 68, 69, 70, 71, 72, 148, 74, 75, 76, + /* 130 */ 77, 78, 79, 80, 81, 82, 83, 84, 42, 43, + /* 140 */ 44, 80, 81, 82, 83, 84, 23, 148, 170, 171, + /* 150 */ 19, 19, 148, 156, 23, 23, 60, 61, 62, 63, + /* 160 */ 64, 65, 66, 67, 68, 69, 70, 71, 72, 19, + /* 170 */ 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, + /* 180 */ 84, 16, 0, 1, 2, 148, 21, 190, 189, 58, + /* 190 */ 169, 213, 144, 145, 170, 148, 218, 149, 177, 202, + /* 200 */ 203, 78, 79, 166, 156, 208, 191, 42, 43, 78, + /* 210 */ 79, 88, 89, 219, 210, 221, 222, 170, 171, 88, + /* 220 */ 88, 98, 99, 92, 16, 60, 61, 62, 63, 64, + /* 230 */ 65, 66, 67, 68, 69, 70, 71, 72, 190, 74, + /* 240 */ 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, + /* 250 */ 42, 43, 168, 169, 182, 148, 125, 126, 127, 212, + /* 260 */ 11, 177, 112, 215, 182, 228, 229, 16, 60, 61, + /* 270 */ 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, + /* 280 */ 72, 148, 74, 75, 76, 77, 78, 79, 80, 81, + /* 290 */ 82, 83, 84, 42, 43, 148, 189, 16, 49, 166, + /* 300 */ 167, 154, 162, 159, 157, 158, 162, 163, 164, 83, + /* 310 */ 84, 60, 61, 62, 63, 64, 65, 66, 67, 68, + /* 320 */ 69, 70, 71, 72, 162, 74, 75, 76, 77, 78, + /* 330 */ 79, 80, 81, 82, 83, 84, 177, 178, 148, 12, + /* 340 */ 132, 201, 16, 184, 16, 148, 20, 240, 99, 100, + /* 350 */ 101, 24, 23, 110, 157, 158, 187, 22, 148, 110, + /* 360 */ 22, 228, 229, 201, 37, 84, 39, 124, 42, 43, + /* 370 */ 148, 90, 91, 92, 93, 94, 95, 96, 181, 182, + /* 380 */ 170, 171, 148, 132, 103, 148, 60, 61, 62, 63, + /* 390 */ 64, 65, 66, 67, 68, 69, 70, 71, 72, 192, + /* 400 */ 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, + /* 410 */ 84, 16, 84, 186, 187, 20, 23, 88, 89, 91, + /* 420 */ 92, 93, 94, 95, 96, 90, 148, 89, 93, 94, + /* 430 */ 95, 103, 148, 223, 156, 142, 143, 42, 43, 104, + /* 440 */ 90, 157, 158, 93, 94, 95, 193, 23, 170, 171, + /* 450 */ 146, 162, 114, 200, 104, 60, 61, 62, 63, 64, + /* 460 */ 65, 66, 67, 68, 69, 70, 71, 72, 190, 74, + /* 470 */ 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, + /* 480 */ 16, 88, 89, 90, 20, 161, 93, 94, 95, 148, + /* 490 */ 201, 213, 80, 148, 170, 148, 218, 104, 186, 187, + /* 500 */ 42, 43, 78, 156, 202, 203, 42, 43, 219, 49, + /* 510 */ 221, 222, 88, 89, 148, 170, 171, 170, 171, 107, + /* 520 */ 156, 63, 64, 111, 60, 61, 62, 63, 64, 65, + /* 530 */ 66, 67, 68, 69, 70, 71, 72, 190, 74, 75, + /* 540 */ 76, 77, 78, 79, 80, 81, 82, 83, 84, 16, + /* 550 */ 92, 148, 12, 20, 190, 16, 211, 212, 148, 99, + /* 560 */ 100, 101, 148, 20, 24, 148, 7, 8, 9, 20, + /* 570 */ 110, 148, 156, 170, 171, 42, 43, 37, 148, 39, + /* 580 */ 170, 171, 43, 18, 99, 100, 101, 170, 171, 49, + /* 590 */ 165, 166, 167, 60, 61, 62, 63, 64, 65, 66, + /* 600 */ 67, 68, 69, 70, 71, 72, 190, 74, 75, 76, + /* 610 */ 77, 78, 79, 80, 81, 82, 83, 84, 16, 162, + /* 620 */ 217, 148, 19, 21, 19, 25, 23, 217, 23, 29, + /* 630 */ 213, 215, 165, 166, 167, 148, 21, 98, 23, 107, + /* 640 */ 210, 41, 103, 111, 42, 43, 125, 126, 232, 106, + /* 650 */ 148, 108, 109, 237, 229, 106, 183, 108, 109, 94, + /* 660 */ 14, 16, 60, 61, 62, 63, 64, 65, 66, 67, + /* 670 */ 68, 69, 70, 71, 72, 23, 74, 75, 76, 77, + /* 680 */ 78, 79, 80, 81, 82, 83, 84, 42, 43, 20, + /* 690 */ 148, 88, 89, 88, 89, 204, 229, 210, 52, 134, + /* 700 */ 54, 151, 156, 88, 16, 60, 61, 62, 63, 64, + /* 710 */ 65, 66, 67, 68, 69, 70, 71, 72, 148, 74, + /* 720 */ 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, + /* 730 */ 42, 43, 80, 43, 16, 106, 190, 108, 109, 27, + /* 740 */ 88, 89, 99, 100, 101, 156, 34, 16, 60, 61, + /* 750 */ 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, + /* 760 */ 72, 215, 74, 75, 76, 77, 78, 79, 80, 81, + /* 770 */ 82, 83, 84, 42, 43, 106, 226, 108, 109, 190, + /* 780 */ 134, 231, 148, 237, 214, 14, 148, 148, 98, 148, + /* 790 */ 16, 179, 61, 62, 63, 64, 65, 66, 67, 68, + /* 800 */ 69, 70, 71, 72, 148, 74, 75, 76, 77, 78, + /* 810 */ 79, 80, 81, 82, 83, 84, 42, 43, 23, 148, + /* 820 */ 23, 183, 183, 52, 183, 54, 170, 171, 131, 156, + /* 830 */ 133, 148, 148, 115, 156, 148, 62, 63, 64, 65, + /* 840 */ 66, 67, 68, 69, 70, 71, 72, 148, 74, 75, + /* 850 */ 76, 77, 78, 79, 80, 81, 82, 83, 84, 16, + /* 860 */ 17, 22, 19, 190, 148, 148, 23, 148, 190, 170, + /* 870 */ 171, 148, 189, 148, 31, 16, 17, 148, 19, 179, + /* 880 */ 148, 179, 23, 88, 89, 88, 89, 170, 171, 156, + /* 890 */ 31, 48, 148, 170, 171, 170, 171, 148, 214, 170, + /* 900 */ 171, 58, 170, 171, 148, 189, 148, 48, 189, 114, + /* 910 */ 19, 114, 21, 148, 148, 22, 148, 58, 148, 170, + /* 920 */ 171, 78, 79, 190, 148, 30, 170, 171, 170, 171, + /* 930 */ 87, 88, 89, 189, 16, 92, 97, 78, 79, 80, + /* 940 */ 170, 171, 91, 233, 148, 50, 87, 88, 89, 16, + /* 950 */ 17, 92, 19, 110, 148, 189, 23, 148, 7, 8, + /* 960 */ 148, 110, 148, 92, 31, 189, 170, 171, 125, 126, + /* 970 */ 127, 128, 129, 130, 103, 124, 170, 171, 148, 170, + /* 980 */ 171, 48, 170, 171, 125, 126, 127, 128, 129, 130, + /* 990 */ 22, 58, 20, 5, 22, 148, 148, 102, 10, 11, + /* 1000 */ 12, 13, 148, 189, 148, 20, 148, 22, 148, 148, + /* 1010 */ 92, 78, 79, 148, 26, 122, 28, 170, 171, 234, + /* 1020 */ 87, 88, 89, 35, 148, 92, 170, 171, 170, 171, + /* 1030 */ 170, 171, 148, 148, 148, 47, 20, 49, 22, 91, + /* 1040 */ 92, 53, 148, 194, 56, 148, 170, 171, 148, 20, + /* 1050 */ 148, 22, 148, 148, 170, 171, 170, 171, 125, 126, + /* 1060 */ 127, 128, 129, 130, 170, 171, 150, 170, 171, 148, + /* 1070 */ 170, 171, 170, 171, 170, 171, 20, 148, 22, 148, + /* 1080 */ 20, 113, 22, 20, 148, 22, 148, 99, 100, 101, + /* 1090 */ 148, 170, 171, 105, 20, 148, 22, 148, 110, 170, + /* 1100 */ 171, 170, 171, 148, 148, 148, 170, 171, 170, 171, + /* 1110 */ 19, 148, 170, 171, 20, 148, 22, 170, 171, 170, + /* 1120 */ 171, 148, 148, 135, 148, 170, 171, 170, 171, 148, + /* 1130 */ 148, 148, 148, 192, 148, 148, 230, 170, 171, 148, + /* 1140 */ 148, 162, 230, 170, 171, 225, 6, 178, 173, 205, + /* 1150 */ 173, 170, 171, 170, 171, 162, 195, 162, 205, 68, + /* 1160 */ 195, 147, 173, 173, 205, 147, 147, 173, 147, 22, + /* 1170 */ 174, 122, 155, 195, 119, 121, 196, 120, 131, 118, + /* 1180 */ 112, 153, 224, 153, 98, 98, 117, 190, 40, 180, + /* 1190 */ 97, 19, 172, 84, 172, 197, 172, 198, 175, 199, + /* 1200 */ 174, 15, 175, 172, 172, 180, 172, 206, 172, 207, + /* 1210 */ 206, 152, 207, 38, 131, 153, 152, 60, 153, 152, + /* 1220 */ 185, 19, 185, 153, 153, 152, 216, 15, 153, 188, + /* 1230 */ 227, 188, 188, 227, 195, 195, 188, 185, 153, 33, + /* 1240 */ 138, 153, 235, 153, 236, 1, 20, 112, 176, 216, + /* 1250 */ 238, 238, 241, 176, 112, 160, 112, 112, 92, 107, + /* 1260 */ 19, 11, 20, 20, 19, 19, 116, 20, 114, 20, + /* 1270 */ 22, 20, 116, 19, 22, 22, 116, 115, 20, 112, + /* 1280 */ 20, 20, 44, 19, 44, 19, 19, 32, 20, 19, + /* 1290 */ 19, 96, 103, 16, 21, 17, 98, 22, 36, 134, + /* 1300 */ 44, 98, 19, 5, 45, 1, 102, 68, 51, 19, + /* 1310 */ 45, 123, 113, 1, 17, 102, 123, 14, 113, 19, + /* 1320 */ 124, 20, 137, 136, 3, 242, 57, 4, 242, 242, + /* 1330 */ 242, 68, +}; +#define YY_SHIFT_USE_DFLT (-99) +#define YY_SHIFT_MAX 383 +static const short yy_shift_ofst[] = { + /* 0 */ 23, 843, 988, -16, 843, 933, 933, 393, 123, 460, + /* 10 */ -98, 96, 933, 933, 933, 933, 933, -45, 249, 424, + /* 20 */ 329, -17, 19, 19, 53, 165, 208, 251, 326, 395, + /* 30 */ 464, 533, 602, 645, 688, 645, 645, 645, 645, 645, + /* 40 */ 645, 645, 645, 645, 645, 645, 645, 645, 645, 645, + /* 50 */ 645, 645, 645, 731, 774, 774, 859, 933, 933, 933, + /* 60 */ 933, 933, 933, 933, 933, 933, 933, 933, 933, 933, + /* 70 */ 933, 933, 933, 933, 933, 933, 933, 933, 933, 933, + /* 80 */ 933, 933, 933, 933, 933, 933, 933, 933, 933, 933, + /* 90 */ 933, 933, 933, 933, 933, 933, 933, -61, -61, 6, + /* 100 */ 6, 281, 22, 61, 539, 565, 329, 329, 226, -17, + /* 110 */ -11, -99, -99, -99, 131, 328, 540, 540, 182, 615, + /* 120 */ 329, 615, 329, 329, 329, 329, 329, 329, 329, 329, + /* 130 */ 329, 329, 329, 329, 329, 329, 329, 329, 329, 851, + /* 140 */ 243, -98, -98, -98, -99, -99, -18, -18, 335, 350, + /* 150 */ 543, 603, 549, 669, 327, 795, 797, 605, 652, 559, + /* 160 */ 329, 329, 412, 329, 329, 132, 329, 329, 338, 329, + /* 170 */ 329, 329, 629, 338, 329, 329, 895, 895, 895, 329, + /* 180 */ 329, 329, 629, 329, 329, 629, 329, 600, 485, 329, + /* 190 */ 329, 629, 329, 329, 329, 629, 329, 629, 629, 329, + /* 200 */ 329, 329, 329, 329, 891, 532, 968, -17, 521, 521, + /* 210 */ 697, 712, 712, 718, 712, 690, 712, -17, 712, -17, + /* 220 */ 839, 893, 718, 718, 893, 1140, 1140, 1140, 1140, 1147, + /* 230 */ -98, 1049, 1055, 1057, 1061, 1054, 1047, 1068, 1068, 1086, + /* 240 */ 1069, 1086, 1069, 1087, 1087, 1148, 1087, 1093, 1087, 1172, + /* 250 */ 1109, 1109, 1148, 1087, 1087, 1087, 1172, 1186, 1068, 1186, + /* 260 */ 1068, 1186, 1068, 1068, 1175, 1083, 1186, 1068, 1157, 1157, + /* 270 */ 1202, 1049, 1212, 1212, 1212, 1212, 1049, 1157, 1202, 1068, + /* 280 */ 1206, 1206, 1068, 1068, 1102, -99, -99, -99, 458, 646, + /* 290 */ 643, 771, 150, 918, 972, 985, 871, 951, 948, 1016, + /* 300 */ 1029, 1056, 1060, 1063, 1074, 1094, 1091, 1244, 1226, 1135, + /* 310 */ 1142, 1144, 1145, 1166, 1152, 1241, 1242, 1243, 1245, 1250, + /* 320 */ 1246, 1247, 1248, 1249, 1251, 1252, 1150, 1253, 1156, 1252, + /* 330 */ 1154, 1254, 1160, 1162, 1258, 1167, 1260, 1261, 1255, 1238, + /* 340 */ 1264, 1240, 1266, 1268, 1267, 1270, 1256, 1271, 1195, 1189, + /* 350 */ 1277, 1278, 1273, 1198, 1262, 1257, 1259, 1275, 1265, 1165, + /* 360 */ 1203, 1283, 1298, 1304, 1204, 1239, 1263, 1188, 1290, 1199, + /* 370 */ 1312, 1297, 1205, 1213, 1193, 1300, 1196, 1301, 1303, 1269, + /* 380 */ 1187, 1185, 1321, 1323, +}; +#define YY_REDUCE_USE_DFLT (-144) +#define YY_REDUCE_MAX 287 +static const short yy_reduce_ofst[] = { + /* 0 */ -139, 278, 48, 289, 347, -22, 345, 197, 133, 416, + /* 10 */ -3, -128, 210, 47, 417, 403, 410, -143, 546, 37, + /* 20 */ 147, 144, 425, 467, -6, -6, -6, -6, -6, -6, + /* 30 */ -6, -6, -6, -6, -6, -6, -6, -6, -6, -6, + /* 40 */ -6, -6, -6, -6, -6, -6, -6, -6, -6, -6, + /* 50 */ -6, -6, -6, -6, -6, -6, 656, 699, 717, 723, + /* 60 */ 725, 729, 732, 749, 756, 758, 770, 796, 806, 809, + /* 70 */ 812, 847, 856, 858, 860, 876, 884, 886, 894, 897, + /* 80 */ 900, 902, 904, 921, 929, 931, 936, 938, 942, 947, + /* 90 */ 949, 955, 957, 967, 973, 981, 983, -6, -6, -6, + /* 100 */ -6, 84, -6, -6, 159, 550, 107, 284, -6, -121, + /* 110 */ -6, -6, -6, -6, 324, 21, 227, 312, 293, 140, + /* 120 */ 4, 162, -91, 473, 638, 639, -1, 430, 641, 570, + /* 130 */ 487, 683, 716, 719, 744, 766, 776, 684, 814, 364, + /* 140 */ 589, 673, 678, 733, 253, 302, -60, 24, 72, 82, + /* 150 */ 15, 190, 15, 15, 169, 222, 234, 237, 341, 304, + /* 160 */ 366, 414, 207, 341, 423, 457, 502, 542, 491, 634, + /* 170 */ 671, 687, 15, 491, 765, 768, 612, 700, 702, 830, + /* 180 */ 848, 854, 15, 861, 865, 15, 885, 710, 785, 905, + /* 190 */ 956, 15, 963, 974, 976, 15, 982, 15, 15, 984, + /* 200 */ 986, 987, 991, 992, 916, 941, 849, 979, 906, 912, + /* 210 */ 920, 975, 977, 944, 989, 969, 990, 993, 994, 995, + /* 220 */ 996, 961, 953, 959, 965, 1014, 1018, 1019, 1021, 1017, + /* 230 */ 997, 978, 980, 998, 999, 1000, 958, 1028, 1030, 1001, + /* 240 */ 1002, 1004, 1005, 1020, 1022, 1009, 1024, 1026, 1031, 1023, + /* 250 */ 1003, 1006, 1025, 1032, 1034, 1036, 1027, 1059, 1062, 1064, + /* 260 */ 1065, 1067, 1070, 1071, 1007, 1008, 1073, 1075, 1035, 1037, + /* 270 */ 1010, 1039, 1041, 1043, 1044, 1048, 1040, 1052, 1033, 1085, + /* 280 */ 1012, 1013, 1088, 1090, 1011, 1095, 1072, 1077, +}; +static const YYACTIONTYPE yy_default[] = { + /* 0 */ 583, 812, 881, 699, 881, 812, 881, 881, 839, 881, + /* 10 */ 703, 868, 810, 881, 881, 881, 881, 784, 881, 839, + /* 20 */ 881, 615, 839, 839, 735, 881, 881, 881, 881, 881, + /* 30 */ 881, 881, 881, 736, 881, 814, 809, 805, 807, 806, + /* 40 */ 813, 737, 726, 733, 740, 715, 852, 742, 743, 749, + /* 50 */ 750, 869, 867, 772, 771, 790, 881, 881, 881, 881, + /* 60 */ 881, 881, 881, 881, 881, 881, 881, 881, 881, 881, + /* 70 */ 881, 881, 881, 881, 881, 881, 881, 881, 881, 881, + /* 80 */ 881, 881, 881, 881, 881, 881, 881, 881, 881, 881, + /* 90 */ 881, 881, 881, 881, 881, 881, 881, 774, 796, 773, + /* 100 */ 783, 608, 775, 776, 668, 603, 881, 881, 777, 881, + /* 110 */ 778, 791, 792, 793, 881, 881, 881, 881, 583, 699, + /* 120 */ 881, 699, 881, 881, 881, 881, 881, 881, 881, 881, + /* 130 */ 881, 881, 881, 881, 881, 881, 881, 881, 881, 881, + /* 140 */ 881, 881, 881, 881, 693, 703, 881, 881, 659, 881, + /* 150 */ 881, 881, 881, 881, 881, 881, 881, 881, 881, 591, + /* 160 */ 589, 881, 691, 881, 881, 617, 881, 881, 701, 881, + /* 170 */ 881, 881, 706, 707, 881, 881, 881, 881, 881, 881, + /* 180 */ 881, 881, 605, 881, 881, 680, 881, 845, 881, 881, + /* 190 */ 881, 859, 881, 881, 881, 857, 881, 682, 745, 825, + /* 200 */ 881, 872, 874, 881, 881, 691, 700, 881, 881, 881, + /* 210 */ 808, 729, 729, 717, 729, 638, 729, 881, 729, 881, + /* 220 */ 641, 739, 717, 717, 739, 588, 588, 588, 588, 658, + /* 230 */ 881, 739, 730, 732, 722, 734, 881, 708, 708, 716, + /* 240 */ 721, 716, 721, 670, 670, 655, 670, 641, 670, 818, + /* 250 */ 822, 822, 655, 670, 670, 670, 818, 600, 708, 600, + /* 260 */ 708, 600, 708, 708, 849, 851, 600, 708, 672, 672, + /* 270 */ 751, 739, 679, 679, 679, 679, 739, 672, 751, 708, + /* 280 */ 871, 871, 708, 708, 879, 625, 643, 643, 881, 881, + /* 290 */ 881, 881, 758, 881, 881, 881, 881, 881, 881, 881, + /* 300 */ 881, 881, 881, 881, 881, 881, 832, 881, 881, 763, + /* 310 */ 759, 881, 760, 881, 685, 881, 881, 881, 881, 881, + /* 320 */ 881, 881, 881, 881, 881, 811, 881, 723, 881, 731, + /* 330 */ 881, 881, 881, 881, 881, 881, 881, 881, 881, 881, + /* 340 */ 881, 881, 881, 881, 881, 881, 881, 881, 881, 881, + /* 350 */ 881, 881, 881, 881, 881, 881, 847, 848, 881, 881, + /* 360 */ 881, 881, 881, 881, 881, 881, 881, 881, 881, 881, + /* 370 */ 881, 881, 881, 881, 881, 881, 881, 881, 881, 878, + /* 380 */ 881, 881, 584, 881, 579, 581, 582, 586, 587, 590, + /* 390 */ 612, 613, 614, 592, 593, 594, 595, 596, 597, 598, + /* 400 */ 604, 606, 624, 626, 610, 628, 689, 690, 755, 683, + /* 410 */ 684, 688, 611, 766, 757, 761, 762, 764, 765, 779, + /* 420 */ 780, 782, 788, 795, 798, 781, 786, 787, 789, 794, + /* 430 */ 797, 686, 687, 801, 618, 619, 622, 623, 835, 837, + /* 440 */ 836, 838, 621, 620, 767, 770, 803, 804, 860, 861, + /* 450 */ 862, 863, 864, 799, 709, 802, 785, 724, 727, 728, + /* 460 */ 725, 692, 702, 711, 712, 713, 714, 697, 698, 704, + /* 470 */ 720, 753, 754, 718, 719, 705, 694, 695, 696, 800, + /* 480 */ 756, 768, 769, 629, 630, 763, 631, 632, 633, 671, + /* 490 */ 674, 675, 676, 634, 653, 656, 657, 635, 642, 636, + /* 500 */ 637, 644, 645, 646, 649, 650, 651, 652, 647, 648, + /* 510 */ 819, 820, 823, 821, 639, 640, 654, 627, 616, 609, + /* 520 */ 660, 663, 664, 665, 666, 667, 669, 661, 662, 607, + /* 530 */ 599, 601, 710, 841, 850, 846, 842, 843, 844, 602, + /* 540 */ 815, 816, 673, 747, 748, 840, 853, 855, 752, 856, + /* 550 */ 858, 854, 677, 678, 681, 824, 865, 738, 741, 744, + /* 560 */ 746, 826, 827, 828, 829, 830, 833, 834, 831, 866, + /* 570 */ 870, 873, 875, 876, 877, 880, 585, 580, +}; +#define YY_SZ_ACTTAB (int)(sizeof(yy_action)/sizeof(yy_action[0])) + +/* The next table maps tokens into fallback tokens. If a construct +** like the following: +** +** %fallback ID X Y Z. +** +** appears in the grammar, then ID becomes a fallback token for X, Y, +** and Z. Whenever one of the tokens X, Y, or Z is input to the parser +** but it does not parse, the type of the token is changed to ID and +** the parse is retried before an error is thrown. +*/ +#ifdef YYFALLBACK +static const YYCODETYPE yyFallback[] = { + 0, /* $ => nothing */ + 0, /* SEMI => nothing */ + 23, /* EXPLAIN => ID */ + 23, /* QUERY => ID */ + 23, /* PLAN => ID */ + 23, /* BEGIN => ID */ + 0, /* TRANSACTION => nothing */ + 23, /* DEFERRED => ID */ + 23, /* IMMEDIATE => ID */ + 23, /* EXCLUSIVE => ID */ + 0, /* COMMIT => nothing */ + 23, /* END => ID */ + 0, /* ROLLBACK => nothing */ + 0, /* CREATE => nothing */ + 0, /* TABLE => nothing */ + 23, /* IF => ID */ + 0, /* NOT => nothing */ + 0, /* EXISTS => nothing */ + 23, /* TEMP => ID */ + 0, /* LP => nothing */ + 0, /* RP => nothing */ + 0, /* AS => nothing */ + 0, /* COMMA => nothing */ + 0, /* ID => nothing */ + 23, /* ABORT => ID */ + 23, /* AFTER => ID */ + 23, /* ANALYZE => ID */ + 23, /* ASC => ID */ + 23, /* ATTACH => ID */ + 23, /* BEFORE => ID */ + 23, /* CASCADE => ID */ + 23, /* CAST => ID */ + 23, /* CONFLICT => ID */ + 23, /* DATABASE => ID */ + 23, /* DESC => ID */ + 23, /* DETACH => ID */ + 23, /* EACH => ID */ + 23, /* FAIL => ID */ + 23, /* FOR => ID */ + 23, /* IGNORE => ID */ + 23, /* INITIALLY => ID */ + 23, /* INSTEAD => ID */ + 23, /* LIKE_KW => ID */ + 23, /* MATCH => ID */ + 23, /* KEY => ID */ + 23, /* OF => ID */ + 23, /* OFFSET => ID */ + 23, /* PRAGMA => ID */ + 23, /* RAISE => ID */ + 23, /* REPLACE => ID */ + 23, /* RESTRICT => ID */ + 23, /* ROW => ID */ + 23, /* TRIGGER => ID */ + 23, /* VACUUM => ID */ + 23, /* VIEW => ID */ + 23, /* VIRTUAL => ID */ + 23, /* REINDEX => ID */ + 23, /* RENAME => ID */ + 23, /* CTIME_KW => ID */ + 0, /* ANY => nothing */ + 0, /* OR => nothing */ + 0, /* AND => nothing */ + 0, /* IS => nothing */ + 0, /* BETWEEN => nothing */ + 0, /* IN => nothing */ + 0, /* ISNULL => nothing */ + 0, /* NOTNULL => nothing */ + 0, /* NE => nothing */ + 0, /* EQ => nothing */ + 0, /* GT => nothing */ + 0, /* LE => nothing */ + 0, /* LT => nothing */ + 0, /* GE => nothing */ + 0, /* ESCAPE => nothing */ + 0, /* BITAND => nothing */ + 0, /* BITOR => nothing */ + 0, /* LSHIFT => nothing */ + 0, /* RSHIFT => nothing */ + 0, /* PLUS => nothing */ + 0, /* MINUS => nothing */ + 0, /* STAR => nothing */ + 0, /* SLASH => nothing */ + 0, /* REM => nothing */ + 0, /* CONCAT => nothing */ + 0, /* COLLATE => nothing */ + 0, /* UMINUS => nothing */ + 0, /* UPLUS => nothing */ + 0, /* BITNOT => nothing */ + 0, /* STRING => nothing */ + 0, /* JOIN_KW => nothing */ + 0, /* CONSTRAINT => nothing */ + 0, /* DEFAULT => nothing */ + 0, /* NULL => nothing */ + 0, /* PRIMARY => nothing */ + 0, /* UNIQUE => nothing */ + 0, /* CHECK => nothing */ + 0, /* REFERENCES => nothing */ + 0, /* AUTOINCR => nothing */ + 0, /* ON => nothing */ + 0, /* DELETE => nothing */ + 0, /* UPDATE => nothing */ + 0, /* INSERT => nothing */ + 0, /* SET => nothing */ + 0, /* DEFERRABLE => nothing */ + 0, /* FOREIGN => nothing */ + 0, /* DROP => nothing */ + 0, /* UNION => nothing */ + 0, /* ALL => nothing */ + 0, /* EXCEPT => nothing */ + 0, /* INTERSECT => nothing */ + 0, /* SELECT => nothing */ + 0, /* DISTINCT => nothing */ + 0, /* DOT => nothing */ + 0, /* FROM => nothing */ + 0, /* JOIN => nothing */ + 0, /* INDEXED => nothing */ + 0, /* BY => nothing */ + 0, /* USING => nothing */ + 0, /* ORDER => nothing */ + 0, /* GROUP => nothing */ + 0, /* HAVING => nothing */ + 0, /* LIMIT => nothing */ + 0, /* WHERE => nothing */ + 0, /* INTO => nothing */ + 0, /* VALUES => nothing */ + 0, /* INTEGER => nothing */ + 0, /* FLOAT => nothing */ + 0, /* BLOB => nothing */ + 0, /* REGISTER => nothing */ + 0, /* VARIABLE => nothing */ + 0, /* CASE => nothing */ + 0, /* WHEN => nothing */ + 0, /* THEN => nothing */ + 0, /* ELSE => nothing */ + 0, /* INDEX => nothing */ + 0, /* ALTER => nothing */ + 0, /* TO => nothing */ + 0, /* ADD => nothing */ + 0, /* COLUMNKW => nothing */ +}; +#endif /* YYFALLBACK */ + +/* The following structure represents a single element of the +** parser's stack. Information stored includes: +** +** + The state number for the parser at this level of the stack. +** +** + The value of the token stored at this level of the stack. +** (In other words, the "major" token.) +** +** + The semantic value stored at this level of the stack. This is +** the information used by the action routines in the grammar. +** It is sometimes called the "minor" token. +*/ +struct yyStackEntry { + YYACTIONTYPE stateno; /* The state-number */ + YYCODETYPE major; /* The major token value. This is the code + ** number for the token at this stack level */ + YYMINORTYPE minor; /* The user-supplied minor token value. This + ** is the value of the token */ +}; +typedef struct yyStackEntry yyStackEntry; + +/* The state of the parser is completely contained in an instance of +** the following structure */ +struct yyParser { + int yyidx; /* Index of top element in stack */ +#ifdef YYTRACKMAXSTACKDEPTH + int yyidxMax; /* Maximum value of yyidx */ +#endif + int yyerrcnt; /* Shifts left before out of the error */ + sqlite3ParserARG_SDECL /* A place to hold %extra_argument */ +#if YYSTACKDEPTH<=0 + int yystksz; /* Current side of the stack */ + yyStackEntry *yystack; /* The parser's stack */ +#else + yyStackEntry yystack[YYSTACKDEPTH]; /* The parser's stack */ +#endif +}; +typedef struct yyParser yyParser; + +#ifndef NDEBUG +#include +static FILE *yyTraceFILE = 0; +static char *yyTracePrompt = 0; +#endif /* NDEBUG */ + +#ifndef NDEBUG +/* +** Turn parser tracing on by giving a stream to which to write the trace +** and a prompt to preface each trace message. Tracing is turned off +** by making either argument NULL +** +** Inputs: +** +** +** Outputs: +** None. +*/ +void sqlite3ParserTrace(FILE *TraceFILE, char *zTracePrompt){ + yyTraceFILE = TraceFILE; + yyTracePrompt = zTracePrompt; + if( yyTraceFILE==0 ) yyTracePrompt = 0; + else if( yyTracePrompt==0 ) yyTraceFILE = 0; +} +#endif /* NDEBUG */ + +#ifndef NDEBUG +/* For tracing shifts, the names of all terminals and nonterminals +** are required. The following table supplies these names */ +static const char *const yyTokenName[] = { + "$", "SEMI", "EXPLAIN", "QUERY", + "PLAN", "BEGIN", "TRANSACTION", "DEFERRED", + "IMMEDIATE", "EXCLUSIVE", "COMMIT", "END", + "ROLLBACK", "CREATE", "TABLE", "IF", + "NOT", "EXISTS", "TEMP", "LP", + "RP", "AS", "COMMA", "ID", + "ABORT", "AFTER", "ANALYZE", "ASC", + "ATTACH", "BEFORE", "CASCADE", "CAST", + "CONFLICT", "DATABASE", "DESC", "DETACH", + "EACH", "FAIL", "FOR", "IGNORE", + "INITIALLY", "INSTEAD", "LIKE_KW", "MATCH", + "KEY", "OF", "OFFSET", "PRAGMA", + "RAISE", "REPLACE", "RESTRICT", "ROW", + "TRIGGER", "VACUUM", "VIEW", "VIRTUAL", + "REINDEX", "RENAME", "CTIME_KW", "ANY", + "OR", "AND", "IS", "BETWEEN", + "IN", "ISNULL", "NOTNULL", "NE", + "EQ", "GT", "LE", "LT", + "GE", "ESCAPE", "BITAND", "BITOR", + "LSHIFT", "RSHIFT", "PLUS", "MINUS", + "STAR", "SLASH", "REM", "CONCAT", + "COLLATE", "UMINUS", "UPLUS", "BITNOT", + "STRING", "JOIN_KW", "CONSTRAINT", "DEFAULT", + "NULL", "PRIMARY", "UNIQUE", "CHECK", + "REFERENCES", "AUTOINCR", "ON", "DELETE", + "UPDATE", "INSERT", "SET", "DEFERRABLE", + "FOREIGN", "DROP", "UNION", "ALL", + "EXCEPT", "INTERSECT", "SELECT", "DISTINCT", + "DOT", "FROM", "JOIN", "INDEXED", + "BY", "USING", "ORDER", "GROUP", + "HAVING", "LIMIT", "WHERE", "INTO", + "VALUES", "INTEGER", "FLOAT", "BLOB", + "REGISTER", "VARIABLE", "CASE", "WHEN", + "THEN", "ELSE", "INDEX", "ALTER", + "TO", "ADD", "COLUMNKW", "error", + "input", "cmdlist", "ecmd", "explain", + "cmdx", "cmd", "transtype", "trans_opt", + "nm", "create_table", "create_table_args", "temp", + "ifnotexists", "dbnm", "columnlist", "conslist_opt", + "select", "column", "columnid", "type", + "carglist", "id", "ids", "typetoken", + "typename", "signed", "plus_num", "minus_num", + "carg", "ccons", "term", "expr", + "onconf", "sortorder", "autoinc", "idxlist_opt", + "refargs", "defer_subclause", "refarg", "refact", + "init_deferred_pred_opt", "conslist", "tcons", "idxlist", + "defer_subclause_opt", "orconf", "resolvetype", "raisetype", + "ifexists", "fullname", "oneselect", "multiselect_op", + "distinct", "selcollist", "from", "where_opt", + "groupby_opt", "having_opt", "orderby_opt", "limit_opt", + "sclp", "as", "seltablist", "stl_prefix", + "joinop", "indexed_opt", "on_opt", "using_opt", + "seltablist_paren", "joinop2", "inscollist", "sortlist", + "sortitem", "nexprlist", "setlist", "insert_cmd", + "inscollist_opt", "itemlist", "exprlist", "likeop", + "escape", "between_op", "in_op", "case_operand", + "case_exprlist", "case_else", "uniqueflag", "collate", + "nmnum", "plus_opt", "number", "trigger_decl", + "trigger_cmd_list", "trigger_time", "trigger_event", "foreach_clause", + "when_clause", "trigger_cmd", "database_kw_opt", "key_opt", + "add_column_fullname", "kwcolumn_opt", +}; +#endif /* NDEBUG */ + +#ifndef NDEBUG +/* For tracing reduce actions, the names of all rules are required. +*/ +static const char *const yyRuleName[] = { + /* 0 */ "input ::= cmdlist", + /* 1 */ "cmdlist ::= cmdlist ecmd", + /* 2 */ "cmdlist ::= ecmd", + /* 3 */ "ecmd ::= SEMI", + /* 4 */ "ecmd ::= explain cmdx SEMI", + /* 5 */ "explain ::=", + /* 6 */ "explain ::= EXPLAIN", + /* 7 */ "explain ::= EXPLAIN QUERY PLAN", + /* 8 */ "cmdx ::= cmd", + /* 9 */ "cmd ::= BEGIN transtype trans_opt", + /* 10 */ "trans_opt ::=", + /* 11 */ "trans_opt ::= TRANSACTION", + /* 12 */ "trans_opt ::= TRANSACTION nm", + /* 13 */ "transtype ::=", + /* 14 */ "transtype ::= DEFERRED", + /* 15 */ "transtype ::= IMMEDIATE", + /* 16 */ "transtype ::= EXCLUSIVE", + /* 17 */ "cmd ::= COMMIT trans_opt", + /* 18 */ "cmd ::= END trans_opt", + /* 19 */ "cmd ::= ROLLBACK trans_opt", + /* 20 */ "cmd ::= create_table create_table_args", + /* 21 */ "create_table ::= CREATE temp TABLE ifnotexists nm dbnm", + /* 22 */ "ifnotexists ::=", + /* 23 */ "ifnotexists ::= IF NOT EXISTS", + /* 24 */ "temp ::= TEMP", + /* 25 */ "temp ::=", + /* 26 */ "create_table_args ::= LP columnlist conslist_opt RP", + /* 27 */ "create_table_args ::= AS select", + /* 28 */ "columnlist ::= columnlist COMMA column", + /* 29 */ "columnlist ::= column", + /* 30 */ "column ::= columnid type carglist", + /* 31 */ "columnid ::= nm", + /* 32 */ "id ::= ID", + /* 33 */ "ids ::= ID|STRING", + /* 34 */ "nm ::= ID", + /* 35 */ "nm ::= STRING", + /* 36 */ "nm ::= JOIN_KW", + /* 37 */ "type ::=", + /* 38 */ "type ::= typetoken", + /* 39 */ "typetoken ::= typename", + /* 40 */ "typetoken ::= typename LP signed RP", + /* 41 */ "typetoken ::= typename LP signed COMMA signed RP", + /* 42 */ "typename ::= ids", + /* 43 */ "typename ::= typename ids", + /* 44 */ "signed ::= plus_num", + /* 45 */ "signed ::= minus_num", + /* 46 */ "carglist ::= carglist carg", + /* 47 */ "carglist ::=", + /* 48 */ "carg ::= CONSTRAINT nm ccons", + /* 49 */ "carg ::= ccons", + /* 50 */ "ccons ::= DEFAULT term", + /* 51 */ "ccons ::= DEFAULT LP expr RP", + /* 52 */ "ccons ::= DEFAULT PLUS term", + /* 53 */ "ccons ::= DEFAULT MINUS term", + /* 54 */ "ccons ::= DEFAULT id", + /* 55 */ "ccons ::= NULL onconf", + /* 56 */ "ccons ::= NOT NULL onconf", + /* 57 */ "ccons ::= PRIMARY KEY sortorder onconf autoinc", + /* 58 */ "ccons ::= UNIQUE onconf", + /* 59 */ "ccons ::= CHECK LP expr RP", + /* 60 */ "ccons ::= REFERENCES nm idxlist_opt refargs", + /* 61 */ "ccons ::= defer_subclause", + /* 62 */ "ccons ::= COLLATE ids", + /* 63 */ "autoinc ::=", + /* 64 */ "autoinc ::= AUTOINCR", + /* 65 */ "refargs ::=", + /* 66 */ "refargs ::= refargs refarg", + /* 67 */ "refarg ::= MATCH nm", + /* 68 */ "refarg ::= ON DELETE refact", + /* 69 */ "refarg ::= ON UPDATE refact", + /* 70 */ "refarg ::= ON INSERT refact", + /* 71 */ "refact ::= SET NULL", + /* 72 */ "refact ::= SET DEFAULT", + /* 73 */ "refact ::= CASCADE", + /* 74 */ "refact ::= RESTRICT", + /* 75 */ "defer_subclause ::= NOT DEFERRABLE init_deferred_pred_opt", + /* 76 */ "defer_subclause ::= DEFERRABLE init_deferred_pred_opt", + /* 77 */ "init_deferred_pred_opt ::=", + /* 78 */ "init_deferred_pred_opt ::= INITIALLY DEFERRED", + /* 79 */ "init_deferred_pred_opt ::= INITIALLY IMMEDIATE", + /* 80 */ "conslist_opt ::=", + /* 81 */ "conslist_opt ::= COMMA conslist", + /* 82 */ "conslist ::= conslist COMMA tcons", + /* 83 */ "conslist ::= conslist tcons", + /* 84 */ "conslist ::= tcons", + /* 85 */ "tcons ::= CONSTRAINT nm", + /* 86 */ "tcons ::= PRIMARY KEY LP idxlist autoinc RP onconf", + /* 87 */ "tcons ::= UNIQUE LP idxlist RP onconf", + /* 88 */ "tcons ::= CHECK LP expr RP onconf", + /* 89 */ "tcons ::= FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt", + /* 90 */ "defer_subclause_opt ::=", + /* 91 */ "defer_subclause_opt ::= defer_subclause", + /* 92 */ "onconf ::=", + /* 93 */ "onconf ::= ON CONFLICT resolvetype", + /* 94 */ "orconf ::=", + /* 95 */ "orconf ::= OR resolvetype", + /* 96 */ "resolvetype ::= raisetype", + /* 97 */ "resolvetype ::= IGNORE", + /* 98 */ "resolvetype ::= REPLACE", + /* 99 */ "cmd ::= DROP TABLE ifexists fullname", + /* 100 */ "ifexists ::= IF EXISTS", + /* 101 */ "ifexists ::=", + /* 102 */ "cmd ::= CREATE temp VIEW ifnotexists nm dbnm AS select", + /* 103 */ "cmd ::= DROP VIEW ifexists fullname", + /* 104 */ "cmd ::= select", + /* 105 */ "select ::= oneselect", + /* 106 */ "select ::= select multiselect_op oneselect", + /* 107 */ "multiselect_op ::= UNION", + /* 108 */ "multiselect_op ::= UNION ALL", + /* 109 */ "multiselect_op ::= EXCEPT|INTERSECT", + /* 110 */ "oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt", + /* 111 */ "distinct ::= DISTINCT", + /* 112 */ "distinct ::= ALL", + /* 113 */ "distinct ::=", + /* 114 */ "sclp ::= selcollist COMMA", + /* 115 */ "sclp ::=", + /* 116 */ "selcollist ::= sclp expr as", + /* 117 */ "selcollist ::= sclp STAR", + /* 118 */ "selcollist ::= sclp nm DOT STAR", + /* 119 */ "as ::= AS nm", + /* 120 */ "as ::= ids", + /* 121 */ "as ::=", + /* 122 */ "from ::=", + /* 123 */ "from ::= FROM seltablist", + /* 124 */ "stl_prefix ::= seltablist joinop", + /* 125 */ "stl_prefix ::=", + /* 126 */ "seltablist ::= stl_prefix nm dbnm as indexed_opt on_opt using_opt", + /* 127 */ "seltablist ::= stl_prefix LP seltablist_paren RP as on_opt using_opt", + /* 128 */ "seltablist_paren ::= select", + /* 129 */ "seltablist_paren ::= seltablist", + /* 130 */ "dbnm ::=", + /* 131 */ "dbnm ::= DOT nm", + /* 132 */ "fullname ::= nm dbnm", + /* 133 */ "joinop ::= COMMA|JOIN", + /* 134 */ "joinop ::= JOIN_KW JOIN", + /* 135 */ "joinop ::= JOIN_KW nm JOIN", + /* 136 */ "joinop ::= JOIN_KW nm nm JOIN", + /* 137 */ "on_opt ::= ON expr", + /* 138 */ "on_opt ::=", + /* 139 */ "indexed_opt ::=", + /* 140 */ "indexed_opt ::= INDEXED BY nm", + /* 141 */ "indexed_opt ::= NOT INDEXED", + /* 142 */ "using_opt ::= USING LP inscollist RP", + /* 143 */ "using_opt ::=", + /* 144 */ "orderby_opt ::=", + /* 145 */ "orderby_opt ::= ORDER BY sortlist", + /* 146 */ "sortlist ::= sortlist COMMA sortitem sortorder", + /* 147 */ "sortlist ::= sortitem sortorder", + /* 148 */ "sortitem ::= expr", + /* 149 */ "sortorder ::= ASC", + /* 150 */ "sortorder ::= DESC", + /* 151 */ "sortorder ::=", + /* 152 */ "groupby_opt ::=", + /* 153 */ "groupby_opt ::= GROUP BY nexprlist", + /* 154 */ "having_opt ::=", + /* 155 */ "having_opt ::= HAVING expr", + /* 156 */ "limit_opt ::=", + /* 157 */ "limit_opt ::= LIMIT expr", + /* 158 */ "limit_opt ::= LIMIT expr OFFSET expr", + /* 159 */ "limit_opt ::= LIMIT expr COMMA expr", + /* 160 */ "cmd ::= DELETE FROM fullname indexed_opt where_opt", + /* 161 */ "where_opt ::=", + /* 162 */ "where_opt ::= WHERE expr", + /* 163 */ "cmd ::= UPDATE orconf fullname indexed_opt SET setlist where_opt", + /* 164 */ "setlist ::= setlist COMMA nm EQ expr", + /* 165 */ "setlist ::= nm EQ expr", + /* 166 */ "cmd ::= insert_cmd INTO fullname inscollist_opt VALUES LP itemlist RP", + /* 167 */ "cmd ::= insert_cmd INTO fullname inscollist_opt select", + /* 168 */ "cmd ::= insert_cmd INTO fullname inscollist_opt DEFAULT VALUES", + /* 169 */ "insert_cmd ::= INSERT orconf", + /* 170 */ "insert_cmd ::= REPLACE", + /* 171 */ "itemlist ::= itemlist COMMA expr", + /* 172 */ "itemlist ::= expr", + /* 173 */ "inscollist_opt ::=", + /* 174 */ "inscollist_opt ::= LP inscollist RP", + /* 175 */ "inscollist ::= inscollist COMMA nm", + /* 176 */ "inscollist ::= nm", + /* 177 */ "expr ::= term", + /* 178 */ "expr ::= LP expr RP", + /* 179 */ "term ::= NULL", + /* 180 */ "expr ::= ID", + /* 181 */ "expr ::= JOIN_KW", + /* 182 */ "expr ::= nm DOT nm", + /* 183 */ "expr ::= nm DOT nm DOT nm", + /* 184 */ "term ::= INTEGER|FLOAT|BLOB", + /* 185 */ "term ::= STRING", + /* 186 */ "expr ::= REGISTER", + /* 187 */ "expr ::= VARIABLE", + /* 188 */ "expr ::= expr COLLATE ids", + /* 189 */ "expr ::= CAST LP expr AS typetoken RP", + /* 190 */ "expr ::= ID LP distinct exprlist RP", + /* 191 */ "expr ::= ID LP STAR RP", + /* 192 */ "term ::= CTIME_KW", + /* 193 */ "expr ::= expr AND expr", + /* 194 */ "expr ::= expr OR expr", + /* 195 */ "expr ::= expr LT|GT|GE|LE expr", + /* 196 */ "expr ::= expr EQ|NE expr", + /* 197 */ "expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT expr", + /* 198 */ "expr ::= expr PLUS|MINUS expr", + /* 199 */ "expr ::= expr STAR|SLASH|REM expr", + /* 200 */ "expr ::= expr CONCAT expr", + /* 201 */ "likeop ::= LIKE_KW", + /* 202 */ "likeop ::= NOT LIKE_KW", + /* 203 */ "likeop ::= MATCH", + /* 204 */ "likeop ::= NOT MATCH", + /* 205 */ "escape ::= ESCAPE expr", + /* 206 */ "escape ::=", + /* 207 */ "expr ::= expr likeop expr escape", + /* 208 */ "expr ::= expr ISNULL|NOTNULL", + /* 209 */ "expr ::= expr IS NULL", + /* 210 */ "expr ::= expr NOT NULL", + /* 211 */ "expr ::= expr IS NOT NULL", + /* 212 */ "expr ::= NOT expr", + /* 213 */ "expr ::= BITNOT expr", + /* 214 */ "expr ::= MINUS expr", + /* 215 */ "expr ::= PLUS expr", + /* 216 */ "between_op ::= BETWEEN", + /* 217 */ "between_op ::= NOT BETWEEN", + /* 218 */ "expr ::= expr between_op expr AND expr", + /* 219 */ "in_op ::= IN", + /* 220 */ "in_op ::= NOT IN", + /* 221 */ "expr ::= expr in_op LP exprlist RP", + /* 222 */ "expr ::= LP select RP", + /* 223 */ "expr ::= expr in_op LP select RP", + /* 224 */ "expr ::= expr in_op nm dbnm", + /* 225 */ "expr ::= EXISTS LP select RP", + /* 226 */ "expr ::= CASE case_operand case_exprlist case_else END", + /* 227 */ "case_exprlist ::= case_exprlist WHEN expr THEN expr", + /* 228 */ "case_exprlist ::= WHEN expr THEN expr", + /* 229 */ "case_else ::= ELSE expr", + /* 230 */ "case_else ::=", + /* 231 */ "case_operand ::= expr", + /* 232 */ "case_operand ::=", + /* 233 */ "exprlist ::= nexprlist", + /* 234 */ "exprlist ::=", + /* 235 */ "nexprlist ::= nexprlist COMMA expr", + /* 236 */ "nexprlist ::= expr", + /* 237 */ "cmd ::= CREATE uniqueflag INDEX ifnotexists nm dbnm ON nm LP idxlist RP", + /* 238 */ "uniqueflag ::= UNIQUE", + /* 239 */ "uniqueflag ::=", + /* 240 */ "idxlist_opt ::=", + /* 241 */ "idxlist_opt ::= LP idxlist RP", + /* 242 */ "idxlist ::= idxlist COMMA nm collate sortorder", + /* 243 */ "idxlist ::= nm collate sortorder", + /* 244 */ "collate ::=", + /* 245 */ "collate ::= COLLATE ids", + /* 246 */ "cmd ::= DROP INDEX ifexists fullname", + /* 247 */ "cmd ::= VACUUM", + /* 248 */ "cmd ::= VACUUM nm", + /* 249 */ "cmd ::= PRAGMA nm dbnm EQ nmnum", + /* 250 */ "cmd ::= PRAGMA nm dbnm EQ ON", + /* 251 */ "cmd ::= PRAGMA nm dbnm EQ DELETE", + /* 252 */ "cmd ::= PRAGMA nm dbnm EQ minus_num", + /* 253 */ "cmd ::= PRAGMA nm dbnm LP nmnum RP", + /* 254 */ "cmd ::= PRAGMA nm dbnm", + /* 255 */ "nmnum ::= plus_num", + /* 256 */ "nmnum ::= nm", + /* 257 */ "plus_num ::= plus_opt number", + /* 258 */ "minus_num ::= MINUS number", + /* 259 */ "number ::= INTEGER|FLOAT", + /* 260 */ "plus_opt ::= PLUS", + /* 261 */ "plus_opt ::=", + /* 262 */ "cmd ::= CREATE trigger_decl BEGIN trigger_cmd_list END", + /* 263 */ "trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause", + /* 264 */ "trigger_time ::= BEFORE", + /* 265 */ "trigger_time ::= AFTER", + /* 266 */ "trigger_time ::= INSTEAD OF", + /* 267 */ "trigger_time ::=", + /* 268 */ "trigger_event ::= DELETE|INSERT", + /* 269 */ "trigger_event ::= UPDATE", + /* 270 */ "trigger_event ::= UPDATE OF inscollist", + /* 271 */ "foreach_clause ::=", + /* 272 */ "foreach_clause ::= FOR EACH ROW", + /* 273 */ "when_clause ::=", + /* 274 */ "when_clause ::= WHEN expr", + /* 275 */ "trigger_cmd_list ::= trigger_cmd_list trigger_cmd SEMI", + /* 276 */ "trigger_cmd_list ::= trigger_cmd SEMI", + /* 277 */ "trigger_cmd ::= UPDATE orconf nm SET setlist where_opt", + /* 278 */ "trigger_cmd ::= insert_cmd INTO nm inscollist_opt VALUES LP itemlist RP", + /* 279 */ "trigger_cmd ::= insert_cmd INTO nm inscollist_opt select", + /* 280 */ "trigger_cmd ::= DELETE FROM nm where_opt", + /* 281 */ "trigger_cmd ::= select", + /* 282 */ "expr ::= RAISE LP IGNORE RP", + /* 283 */ "expr ::= RAISE LP raisetype COMMA nm RP", + /* 284 */ "raisetype ::= ROLLBACK", + /* 285 */ "raisetype ::= ABORT", + /* 286 */ "raisetype ::= FAIL", + /* 287 */ "cmd ::= DROP TRIGGER ifexists fullname", + /* 288 */ "cmd ::= ATTACH database_kw_opt expr AS expr key_opt", + /* 289 */ "cmd ::= DETACH database_kw_opt expr", + /* 290 */ "key_opt ::=", + /* 291 */ "key_opt ::= KEY expr", + /* 292 */ "database_kw_opt ::= DATABASE", + /* 293 */ "database_kw_opt ::=", + /* 294 */ "cmd ::= REINDEX", + /* 295 */ "cmd ::= REINDEX nm dbnm", + /* 296 */ "cmd ::= ANALYZE", + /* 297 */ "cmd ::= ANALYZE nm dbnm", + /* 298 */ "cmd ::= ALTER TABLE fullname RENAME TO nm", + /* 299 */ "cmd ::= ALTER TABLE add_column_fullname ADD kwcolumn_opt column", + /* 300 */ "add_column_fullname ::= fullname", + /* 301 */ "kwcolumn_opt ::=", + /* 302 */ "kwcolumn_opt ::= COLUMNKW", +}; +#endif /* NDEBUG */ + + +#if YYSTACKDEPTH<=0 +/* +** Try to increase the size of the parser stack. +*/ +static void yyGrowStack(yyParser *p){ + int newSize; + yyStackEntry *pNew; + + newSize = p->yystksz*2 + 100; + pNew = realloc(p->yystack, newSize*sizeof(pNew[0])); + if( pNew ){ + p->yystack = pNew; + p->yystksz = newSize; +#ifndef NDEBUG + if( yyTraceFILE ){ + fprintf(yyTraceFILE,"%sStack grows to %d entries!\n", + yyTracePrompt, p->yystksz); + } +#endif + } +} +#endif + +/* +** This function allocates a new parser. +** The only argument is a pointer to a function which works like +** malloc. +** +** Inputs: +** A pointer to the function used to allocate memory. +** +** Outputs: +** A pointer to a parser. This pointer is used in subsequent calls +** to sqlite3Parser and sqlite3ParserFree. +*/ +void *sqlite3ParserAlloc(void *(*mallocProc)(size_t)){ + yyParser *pParser; + pParser = (yyParser*)(*mallocProc)( (size_t)sizeof(yyParser) ); + if( pParser ){ + pParser->yyidx = -1; +#ifdef YYTRACKMAXSTACKDEPTH + pParser->yyidxMax = 0; +#endif +#if YYSTACKDEPTH<=0 + yyGrowStack(pParser); +#endif + } + return pParser; +} + +/* The following function deletes the value associated with a +** symbol. The symbol can be either a terminal or nonterminal. +** "yymajor" is the symbol code, and "yypminor" is a pointer to +** the value. +*/ +static void yy_destructor( + yyParser *yypParser, /* The parser */ + YYCODETYPE yymajor, /* Type code for object to destroy */ + YYMINORTYPE *yypminor /* The object to be destroyed */ +){ + sqlite3ParserARG_FETCH; + switch( yymajor ){ + /* Here is inserted the actions which take place when a + ** terminal or non-terminal is destroyed. This can happen + ** when the symbol is popped from the stack during a + ** reduce or during error processing or when a parser is + ** being destroyed before it is finished parsing. + ** + ** Note: during a reduce, the only symbols destroyed are those + ** which appear on the RHS of the rule, but which are not used + ** inside the C code. + */ + case 156: /* select */ + case 190: /* oneselect */ + case 208: /* seltablist_paren */ +{ +#line 369 "parse.y" +sqlite3SelectDelete(pParse->db, (yypminor->yy91)); +#line 1279 "parse.c" +} + break; + case 170: /* term */ + case 171: /* expr */ + case 195: /* where_opt */ + case 197: /* having_opt */ + case 206: /* on_opt */ + case 212: /* sortitem */ + case 220: /* escape */ + case 223: /* case_operand */ + case 225: /* case_else */ + case 236: /* when_clause */ + case 239: /* key_opt */ +{ +#line 669 "parse.y" +sqlite3ExprDelete(pParse->db, (yypminor->yy418)); +#line 1296 "parse.c" +} + break; + case 175: /* idxlist_opt */ + case 183: /* idxlist */ + case 193: /* selcollist */ + case 196: /* groupby_opt */ + case 198: /* orderby_opt */ + case 200: /* sclp */ + case 211: /* sortlist */ + case 213: /* nexprlist */ + case 214: /* setlist */ + case 217: /* itemlist */ + case 218: /* exprlist */ + case 224: /* case_exprlist */ +{ +#line 927 "parse.y" +sqlite3ExprListDelete(pParse->db, (yypminor->yy322)); +#line 1314 "parse.c" +} + break; + case 189: /* fullname */ + case 194: /* from */ + case 202: /* seltablist */ + case 203: /* stl_prefix */ +{ +#line 487 "parse.y" +sqlite3SrcListDelete(pParse->db, (yypminor->yy439)); +#line 1324 "parse.c" +} + break; + case 207: /* using_opt */ + case 210: /* inscollist */ + case 216: /* inscollist_opt */ +{ +#line 519 "parse.y" +sqlite3IdListDelete(pParse->db, (yypminor->yy232)); +#line 1333 "parse.c" +} + break; + case 232: /* trigger_cmd_list */ + case 237: /* trigger_cmd */ +{ +#line 1031 "parse.y" +sqlite3DeleteTriggerStep(pParse->db, (yypminor->yy451)); +#line 1341 "parse.c" +} + break; + case 234: /* trigger_event */ +{ +#line 1017 "parse.y" +sqlite3IdListDelete(pParse->db, (yypminor->yy378).b); +#line 1348 "parse.c" +} + break; + default: break; /* If no destructor action specified: do nothing */ + } +} + +/* +** Pop the parser's stack once. +** +** If there is a destructor routine associated with the token which +** is popped from the stack, then call it. +** +** Return the major token number for the symbol popped. +*/ +static int yy_pop_parser_stack(yyParser *pParser){ + YYCODETYPE yymajor; + yyStackEntry *yytos = &pParser->yystack[pParser->yyidx]; + + if( pParser->yyidx<0 ) return 0; +#ifndef NDEBUG + if( yyTraceFILE && pParser->yyidx>=0 ){ + fprintf(yyTraceFILE,"%sPopping %s\n", + yyTracePrompt, + yyTokenName[yytos->major]); + } +#endif + yymajor = yytos->major; + yy_destructor(pParser, yymajor, &yytos->minor); + pParser->yyidx--; + return yymajor; +} + +/* +** Deallocate and destroy a parser. Destructors are all called for +** all stack elements before shutting the parser down. +** +** Inputs: +** +*/ +void sqlite3ParserFree( + void *p, /* The parser to be deleted */ + void (*freeProc)(void*) /* Function used to reclaim memory */ +){ + yyParser *pParser = (yyParser*)p; + if( pParser==0 ) return; + while( pParser->yyidx>=0 ) yy_pop_parser_stack(pParser); +#if YYSTACKDEPTH<=0 + free(pParser->yystack); +#endif + (*freeProc)((void*)pParser); +} + +/* +** Return the peak depth of the stack for a parser. +*/ +#ifdef YYTRACKMAXSTACKDEPTH +int sqlite3ParserStackPeak(void *p){ + yyParser *pParser = (yyParser*)p; + return pParser->yyidxMax; +} +#endif + +/* +** Find the appropriate action for a parser given the terminal +** look-ahead token iLookAhead. +** +** If the look-ahead token is YYNOCODE, then check to see if the action is +** independent of the look-ahead. If it is, return the action, otherwise +** return YY_NO_ACTION. +*/ +static int yy_find_shift_action( + yyParser *pParser, /* The parser */ + YYCODETYPE iLookAhead /* The look-ahead token */ +){ + int i; + int stateno = pParser->yystack[pParser->yyidx].stateno; + + if( stateno>YY_SHIFT_MAX || (i = yy_shift_ofst[stateno])==YY_SHIFT_USE_DFLT ){ + return yy_default[stateno]; + } + assert( iLookAhead!=YYNOCODE ); + i += iLookAhead; + if( i<0 || i>=YY_SZ_ACTTAB || yy_lookahead[i]!=iLookAhead ){ + if( iLookAhead>0 ){ +#ifdef YYFALLBACK + int iFallback; /* Fallback token */ + if( iLookAhead %s\n", + yyTracePrompt, yyTokenName[iLookAhead], yyTokenName[iFallback]); + } +#endif + return yy_find_shift_action(pParser, iFallback); + } +#endif +#ifdef YYWILDCARD + { + int j = i - iLookAhead + YYWILDCARD; + if( j>=0 && j %s\n", + yyTracePrompt, yyTokenName[iLookAhead], yyTokenName[YYWILDCARD]); + } +#endif /* NDEBUG */ + return yy_action[j]; + } + } +#endif /* YYWILDCARD */ + } + return yy_default[stateno]; + }else{ + return yy_action[i]; + } +} + +/* +** Find the appropriate action for a parser given the non-terminal +** look-ahead token iLookAhead. +** +** If the look-ahead token is YYNOCODE, then check to see if the action is +** independent of the look-ahead. If it is, return the action, otherwise +** return YY_NO_ACTION. +*/ +static int yy_find_reduce_action( + int stateno, /* Current state number */ + YYCODETYPE iLookAhead /* The look-ahead token */ +){ + int i; +#ifdef YYERRORSYMBOL + if( stateno>YY_REDUCE_MAX ){ + return yy_default[stateno]; + } +#else + assert( stateno<=YY_REDUCE_MAX ); +#endif + i = yy_reduce_ofst[stateno]; + assert( i!=YY_REDUCE_USE_DFLT ); + assert( iLookAhead!=YYNOCODE ); + i += iLookAhead; +#ifdef YYERRORSYMBOL + if( i<0 || i>=YY_SZ_ACTTAB || yy_lookahead[i]!=iLookAhead ){ + return yy_default[stateno]; + } +#else + assert( i>=0 && iyyidx--; +#ifndef NDEBUG + if( yyTraceFILE ){ + fprintf(yyTraceFILE,"%sStack Overflow!\n",yyTracePrompt); + } +#endif + while( yypParser->yyidx>=0 ) yy_pop_parser_stack(yypParser); + /* Here code is inserted which will execute if the parser + ** stack every overflows */ +#line 39 "parse.y" + + sqlite3ErrorMsg(pParse, "parser stack overflow"); + pParse->parseError = 1; +#line 1526 "parse.c" + sqlite3ParserARG_STORE; /* Suppress warning about unused %extra_argument var */ +} + +/* +** Perform a shift action. +*/ +static void yy_shift( + yyParser *yypParser, /* The parser to be shifted */ + int yyNewState, /* The new state to shift in */ + int yyMajor, /* The major token to shift in */ + YYMINORTYPE *yypMinor /* Pointer to the minor token to shift in */ +){ + yyStackEntry *yytos; + yypParser->yyidx++; +#ifdef YYTRACKMAXSTACKDEPTH + if( yypParser->yyidx>yypParser->yyidxMax ){ + yypParser->yyidxMax = yypParser->yyidx; + } +#endif +#if YYSTACKDEPTH>0 + if( yypParser->yyidx>=YYSTACKDEPTH ){ + yyStackOverflow(yypParser, yypMinor); + return; + } +#else + if( yypParser->yyidx>=yypParser->yystksz ){ + yyGrowStack(yypParser); + if( yypParser->yyidx>=yypParser->yystksz ){ + yyStackOverflow(yypParser, yypMinor); + return; + } + } +#endif + yytos = &yypParser->yystack[yypParser->yyidx]; + yytos->stateno = yyNewState; + yytos->major = yyMajor; + yytos->minor = *yypMinor; +#ifndef NDEBUG + if( yyTraceFILE && yypParser->yyidx>0 ){ + int i; + fprintf(yyTraceFILE,"%sShift %d\n",yyTracePrompt,yyNewState); + fprintf(yyTraceFILE,"%sStack:",yyTracePrompt); + for(i=1; i<=yypParser->yyidx; i++) + fprintf(yyTraceFILE," %s",yyTokenName[yypParser->yystack[i].major]); + fprintf(yyTraceFILE,"\n"); + } +#endif +} + +/* The following table contains information about every rule that +** is used during the reduce. +*/ +static const struct { + YYCODETYPE lhs; /* Symbol on the left-hand side of the rule */ + unsigned char nrhs; /* Number of right-hand side symbols in the rule */ +} yyRuleInfo[] = { + { 140, 1 }, + { 141, 2 }, + { 141, 1 }, + { 142, 1 }, + { 142, 3 }, + { 143, 0 }, + { 143, 1 }, + { 143, 3 }, + { 144, 1 }, + { 145, 3 }, + { 147, 0 }, + { 147, 1 }, + { 147, 2 }, + { 146, 0 }, + { 146, 1 }, + { 146, 1 }, + { 146, 1 }, + { 145, 2 }, + { 145, 2 }, + { 145, 2 }, + { 145, 2 }, + { 149, 6 }, + { 152, 0 }, + { 152, 3 }, + { 151, 1 }, + { 151, 0 }, + { 150, 4 }, + { 150, 2 }, + { 154, 3 }, + { 154, 1 }, + { 157, 3 }, + { 158, 1 }, + { 161, 1 }, + { 162, 1 }, + { 148, 1 }, + { 148, 1 }, + { 148, 1 }, + { 159, 0 }, + { 159, 1 }, + { 163, 1 }, + { 163, 4 }, + { 163, 6 }, + { 164, 1 }, + { 164, 2 }, + { 165, 1 }, + { 165, 1 }, + { 160, 2 }, + { 160, 0 }, + { 168, 3 }, + { 168, 1 }, + { 169, 2 }, + { 169, 4 }, + { 169, 3 }, + { 169, 3 }, + { 169, 2 }, + { 169, 2 }, + { 169, 3 }, + { 169, 5 }, + { 169, 2 }, + { 169, 4 }, + { 169, 4 }, + { 169, 1 }, + { 169, 2 }, + { 174, 0 }, + { 174, 1 }, + { 176, 0 }, + { 176, 2 }, + { 178, 2 }, + { 178, 3 }, + { 178, 3 }, + { 178, 3 }, + { 179, 2 }, + { 179, 2 }, + { 179, 1 }, + { 179, 1 }, + { 177, 3 }, + { 177, 2 }, + { 180, 0 }, + { 180, 2 }, + { 180, 2 }, + { 155, 0 }, + { 155, 2 }, + { 181, 3 }, + { 181, 2 }, + { 181, 1 }, + { 182, 2 }, + { 182, 7 }, + { 182, 5 }, + { 182, 5 }, + { 182, 10 }, + { 184, 0 }, + { 184, 1 }, + { 172, 0 }, + { 172, 3 }, + { 185, 0 }, + { 185, 2 }, + { 186, 1 }, + { 186, 1 }, + { 186, 1 }, + { 145, 4 }, + { 188, 2 }, + { 188, 0 }, + { 145, 8 }, + { 145, 4 }, + { 145, 1 }, + { 156, 1 }, + { 156, 3 }, + { 191, 1 }, + { 191, 2 }, + { 191, 1 }, + { 190, 9 }, + { 192, 1 }, + { 192, 1 }, + { 192, 0 }, + { 200, 2 }, + { 200, 0 }, + { 193, 3 }, + { 193, 2 }, + { 193, 4 }, + { 201, 2 }, + { 201, 1 }, + { 201, 0 }, + { 194, 0 }, + { 194, 2 }, + { 203, 2 }, + { 203, 0 }, + { 202, 7 }, + { 202, 7 }, + { 208, 1 }, + { 208, 1 }, + { 153, 0 }, + { 153, 2 }, + { 189, 2 }, + { 204, 1 }, + { 204, 2 }, + { 204, 3 }, + { 204, 4 }, + { 206, 2 }, + { 206, 0 }, + { 205, 0 }, + { 205, 3 }, + { 205, 2 }, + { 207, 4 }, + { 207, 0 }, + { 198, 0 }, + { 198, 3 }, + { 211, 4 }, + { 211, 2 }, + { 212, 1 }, + { 173, 1 }, + { 173, 1 }, + { 173, 0 }, + { 196, 0 }, + { 196, 3 }, + { 197, 0 }, + { 197, 2 }, + { 199, 0 }, + { 199, 2 }, + { 199, 4 }, + { 199, 4 }, + { 145, 5 }, + { 195, 0 }, + { 195, 2 }, + { 145, 7 }, + { 214, 5 }, + { 214, 3 }, + { 145, 8 }, + { 145, 5 }, + { 145, 6 }, + { 215, 2 }, + { 215, 1 }, + { 217, 3 }, + { 217, 1 }, + { 216, 0 }, + { 216, 3 }, + { 210, 3 }, + { 210, 1 }, + { 171, 1 }, + { 171, 3 }, + { 170, 1 }, + { 171, 1 }, + { 171, 1 }, + { 171, 3 }, + { 171, 5 }, + { 170, 1 }, + { 170, 1 }, + { 171, 1 }, + { 171, 1 }, + { 171, 3 }, + { 171, 6 }, + { 171, 5 }, + { 171, 4 }, + { 170, 1 }, + { 171, 3 }, + { 171, 3 }, + { 171, 3 }, + { 171, 3 }, + { 171, 3 }, + { 171, 3 }, + { 171, 3 }, + { 171, 3 }, + { 219, 1 }, + { 219, 2 }, + { 219, 1 }, + { 219, 2 }, + { 220, 2 }, + { 220, 0 }, + { 171, 4 }, + { 171, 2 }, + { 171, 3 }, + { 171, 3 }, + { 171, 4 }, + { 171, 2 }, + { 171, 2 }, + { 171, 2 }, + { 171, 2 }, + { 221, 1 }, + { 221, 2 }, + { 171, 5 }, + { 222, 1 }, + { 222, 2 }, + { 171, 5 }, + { 171, 3 }, + { 171, 5 }, + { 171, 4 }, + { 171, 4 }, + { 171, 5 }, + { 224, 5 }, + { 224, 4 }, + { 225, 2 }, + { 225, 0 }, + { 223, 1 }, + { 223, 0 }, + { 218, 1 }, + { 218, 0 }, + { 213, 3 }, + { 213, 1 }, + { 145, 11 }, + { 226, 1 }, + { 226, 0 }, + { 175, 0 }, + { 175, 3 }, + { 183, 5 }, + { 183, 3 }, + { 227, 0 }, + { 227, 2 }, + { 145, 4 }, + { 145, 1 }, + { 145, 2 }, + { 145, 5 }, + { 145, 5 }, + { 145, 5 }, + { 145, 5 }, + { 145, 6 }, + { 145, 3 }, + { 228, 1 }, + { 228, 1 }, + { 166, 2 }, + { 167, 2 }, + { 230, 1 }, + { 229, 1 }, + { 229, 0 }, + { 145, 5 }, + { 231, 11 }, + { 233, 1 }, + { 233, 1 }, + { 233, 2 }, + { 233, 0 }, + { 234, 1 }, + { 234, 1 }, + { 234, 3 }, + { 235, 0 }, + { 235, 3 }, + { 236, 0 }, + { 236, 2 }, + { 232, 3 }, + { 232, 2 }, + { 237, 6 }, + { 237, 8 }, + { 237, 5 }, + { 237, 4 }, + { 237, 1 }, + { 171, 4 }, + { 171, 6 }, + { 187, 1 }, + { 187, 1 }, + { 187, 1 }, + { 145, 4 }, + { 145, 6 }, + { 145, 3 }, + { 239, 0 }, + { 239, 2 }, + { 238, 1 }, + { 238, 0 }, + { 145, 1 }, + { 145, 3 }, + { 145, 1 }, + { 145, 3 }, + { 145, 6 }, + { 145, 6 }, + { 240, 1 }, + { 241, 0 }, + { 241, 1 }, +}; + +static void yy_accept(yyParser*); /* Forward Declaration */ + +/* +** Perform a reduce action and the shift that must immediately +** follow the reduce. +*/ +static void yy_reduce( + yyParser *yypParser, /* The parser */ + int yyruleno /* Number of the rule by which to reduce */ +){ + int yygoto; /* The next state */ + int yyact; /* The next action */ + YYMINORTYPE yygotominor; /* The LHS of the rule reduced */ + yyStackEntry *yymsp; /* The top of the parser's stack */ + int yysize; /* Amount to pop the stack */ + sqlite3ParserARG_FETCH; + yymsp = &yypParser->yystack[yypParser->yyidx]; +#ifndef NDEBUG + if( yyTraceFILE && yyruleno>=0 + && yyruleno<(int)(sizeof(yyRuleName)/sizeof(yyRuleName[0])) ){ + fprintf(yyTraceFILE, "%sReduce [%s].\n", yyTracePrompt, + yyRuleName[yyruleno]); + } +#endif /* NDEBUG */ + + /* Silence complaints from purify about yygotominor being uninitialized + ** in some cases when it is copied into the stack after the following + ** switch. yygotominor is uninitialized when a rule reduces that does + ** not set the value of its left-hand side nonterminal. Leaving the + ** value of the nonterminal uninitialized is utterly harmless as long + ** as the value is never used. So really the only thing this code + ** accomplishes is to quieten purify. + ** + ** 2007-01-16: The wireshark project (www.wireshark.org) reports that + ** without this code, their parser segfaults. I'm not sure what there + ** parser is doing to make this happen. This is the second bug report + ** from wireshark this week. Clearly they are stressing Lemon in ways + ** that it has not been previously stressed... (SQLite ticket #2172) + */ + /*memset(&yygotominor, 0, sizeof(yygotominor));*/ + yygotominor = yyzerominor; + + + switch( yyruleno ){ + /* Beginning here are the reduction cases. A typical example + ** follows: + ** case 0: + ** #line + ** { ... } // User supplied code + ** #line + ** break; + */ + case 0: /* input ::= cmdlist */ + case 1: /* cmdlist ::= cmdlist ecmd */ + case 2: /* cmdlist ::= ecmd */ + case 3: /* ecmd ::= SEMI */ + case 4: /* ecmd ::= explain cmdx SEMI */ + case 10: /* trans_opt ::= */ + case 11: /* trans_opt ::= TRANSACTION */ + case 12: /* trans_opt ::= TRANSACTION nm */ + case 20: /* cmd ::= create_table create_table_args */ + case 28: /* columnlist ::= columnlist COMMA column */ + case 29: /* columnlist ::= column */ + case 37: /* type ::= */ + case 44: /* signed ::= plus_num */ + case 45: /* signed ::= minus_num */ + case 46: /* carglist ::= carglist carg */ + case 47: /* carglist ::= */ + case 48: /* carg ::= CONSTRAINT nm ccons */ + case 49: /* carg ::= ccons */ + case 55: /* ccons ::= NULL onconf */ + case 82: /* conslist ::= conslist COMMA tcons */ + case 83: /* conslist ::= conslist tcons */ + case 84: /* conslist ::= tcons */ + case 85: /* tcons ::= CONSTRAINT nm */ + case 260: /* plus_opt ::= PLUS */ + case 261: /* plus_opt ::= */ + case 271: /* foreach_clause ::= */ + case 272: /* foreach_clause ::= FOR EACH ROW */ + case 292: /* database_kw_opt ::= DATABASE */ + case 293: /* database_kw_opt ::= */ + case 301: /* kwcolumn_opt ::= */ + case 302: /* kwcolumn_opt ::= COLUMNKW */ +#line 91 "parse.y" +{ +} +#line 1974 "parse.c" + break; + case 5: /* explain ::= */ +#line 96 "parse.y" +{ sqlite3BeginParse(pParse, 0); } +#line 1979 "parse.c" + break; + case 6: /* explain ::= EXPLAIN */ +#line 98 "parse.y" +{ sqlite3BeginParse(pParse, 1); } +#line 1984 "parse.c" + break; + case 7: /* explain ::= EXPLAIN QUERY PLAN */ +#line 99 "parse.y" +{ sqlite3BeginParse(pParse, 2); } +#line 1989 "parse.c" + break; + case 8: /* cmdx ::= cmd */ +#line 101 "parse.y" +{ sqlite3FinishCoding(pParse); } +#line 1994 "parse.c" + break; + case 9: /* cmd ::= BEGIN transtype trans_opt */ +#line 106 "parse.y" +{sqlite3BeginTransaction(pParse, yymsp[-1].minor.yy328);} +#line 1999 "parse.c" + break; + case 13: /* transtype ::= */ +#line 111 "parse.y" +{yygotominor.yy328 = TK_DEFERRED;} +#line 2004 "parse.c" + break; + case 14: /* transtype ::= DEFERRED */ + case 15: /* transtype ::= IMMEDIATE */ + case 16: /* transtype ::= EXCLUSIVE */ + case 107: /* multiselect_op ::= UNION */ + case 109: /* multiselect_op ::= EXCEPT|INTERSECT */ +#line 112 "parse.y" +{yygotominor.yy328 = yymsp[0].major;} +#line 2013 "parse.c" + break; + case 17: /* cmd ::= COMMIT trans_opt */ + case 18: /* cmd ::= END trans_opt */ +#line 115 "parse.y" +{sqlite3CommitTransaction(pParse);} +#line 2019 "parse.c" + break; + case 19: /* cmd ::= ROLLBACK trans_opt */ +#line 117 "parse.y" +{sqlite3RollbackTransaction(pParse);} +#line 2024 "parse.c" + break; + case 21: /* create_table ::= CREATE temp TABLE ifnotexists nm dbnm */ +#line 122 "parse.y" +{ + sqlite3StartTable(pParse,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy0,yymsp[-4].minor.yy328,0,0,yymsp[-2].minor.yy328); +} +#line 2031 "parse.c" + break; + case 22: /* ifnotexists ::= */ + case 25: /* temp ::= */ + case 63: /* autoinc ::= */ + case 77: /* init_deferred_pred_opt ::= */ + case 79: /* init_deferred_pred_opt ::= INITIALLY IMMEDIATE */ + case 90: /* defer_subclause_opt ::= */ + case 101: /* ifexists ::= */ + case 112: /* distinct ::= ALL */ + case 113: /* distinct ::= */ + case 216: /* between_op ::= BETWEEN */ + case 219: /* in_op ::= IN */ +#line 126 "parse.y" +{yygotominor.yy328 = 0;} +#line 2046 "parse.c" + break; + case 23: /* ifnotexists ::= IF NOT EXISTS */ + case 24: /* temp ::= TEMP */ + case 64: /* autoinc ::= AUTOINCR */ + case 78: /* init_deferred_pred_opt ::= INITIALLY DEFERRED */ + case 100: /* ifexists ::= IF EXISTS */ + case 111: /* distinct ::= DISTINCT */ + case 217: /* between_op ::= NOT BETWEEN */ + case 220: /* in_op ::= NOT IN */ +#line 127 "parse.y" +{yygotominor.yy328 = 1;} +#line 2058 "parse.c" + break; + case 26: /* create_table_args ::= LP columnlist conslist_opt RP */ +#line 133 "parse.y" +{ + sqlite3EndTable(pParse,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy0,0); +} +#line 2065 "parse.c" + break; + case 27: /* create_table_args ::= AS select */ +#line 136 "parse.y" +{ + sqlite3EndTable(pParse,0,0,yymsp[0].minor.yy91); + sqlite3SelectDelete(pParse->db, yymsp[0].minor.yy91); +} +#line 2073 "parse.c" + break; + case 30: /* column ::= columnid type carglist */ +#line 148 "parse.y" +{ + yygotominor.yy0.z = yymsp[-2].minor.yy0.z; + yygotominor.yy0.n = (pParse->sLastToken.z-yymsp[-2].minor.yy0.z) + pParse->sLastToken.n; +} +#line 2081 "parse.c" + break; + case 31: /* columnid ::= nm */ +#line 152 "parse.y" +{ + sqlite3AddColumn(pParse,&yymsp[0].minor.yy0); + yygotominor.yy0 = yymsp[0].minor.yy0; +} +#line 2089 "parse.c" + break; + case 32: /* id ::= ID */ + case 33: /* ids ::= ID|STRING */ + case 34: /* nm ::= ID */ + case 35: /* nm ::= STRING */ + case 36: /* nm ::= JOIN_KW */ + case 39: /* typetoken ::= typename */ + case 42: /* typename ::= ids */ + case 119: /* as ::= AS nm */ + case 120: /* as ::= ids */ + case 131: /* dbnm ::= DOT nm */ + case 140: /* indexed_opt ::= INDEXED BY nm */ + case 245: /* collate ::= COLLATE ids */ + case 255: /* nmnum ::= plus_num */ + case 256: /* nmnum ::= nm */ + case 257: /* plus_num ::= plus_opt number */ + case 258: /* minus_num ::= MINUS number */ + case 259: /* number ::= INTEGER|FLOAT */ +#line 162 "parse.y" +{yygotominor.yy0 = yymsp[0].minor.yy0;} +#line 2110 "parse.c" + break; + case 38: /* type ::= typetoken */ +#line 223 "parse.y" +{sqlite3AddColumnType(pParse,&yymsp[0].minor.yy0);} +#line 2115 "parse.c" + break; + case 40: /* typetoken ::= typename LP signed RP */ +#line 225 "parse.y" +{ + yygotominor.yy0.z = yymsp[-3].minor.yy0.z; + yygotominor.yy0.n = &yymsp[0].minor.yy0.z[yymsp[0].minor.yy0.n] - yymsp[-3].minor.yy0.z; +} +#line 2123 "parse.c" + break; + case 41: /* typetoken ::= typename LP signed COMMA signed RP */ +#line 229 "parse.y" +{ + yygotominor.yy0.z = yymsp[-5].minor.yy0.z; + yygotominor.yy0.n = &yymsp[0].minor.yy0.z[yymsp[0].minor.yy0.n] - yymsp[-5].minor.yy0.z; +} +#line 2131 "parse.c" + break; + case 43: /* typename ::= typename ids */ +#line 235 "parse.y" +{yygotominor.yy0.z=yymsp[-1].minor.yy0.z; yygotominor.yy0.n=yymsp[0].minor.yy0.n+(yymsp[0].minor.yy0.z-yymsp[-1].minor.yy0.z);} +#line 2136 "parse.c" + break; + case 50: /* ccons ::= DEFAULT term */ + case 52: /* ccons ::= DEFAULT PLUS term */ +#line 246 "parse.y" +{sqlite3AddDefaultValue(pParse,yymsp[0].minor.yy418);} +#line 2142 "parse.c" + break; + case 51: /* ccons ::= DEFAULT LP expr RP */ +#line 247 "parse.y" +{sqlite3AddDefaultValue(pParse,yymsp[-1].minor.yy418);} +#line 2147 "parse.c" + break; + case 53: /* ccons ::= DEFAULT MINUS term */ +#line 249 "parse.y" +{ + Expr *p = sqlite3PExpr(pParse, TK_UMINUS, yymsp[0].minor.yy418, 0, 0); + sqlite3AddDefaultValue(pParse,p); +} +#line 2155 "parse.c" + break; + case 54: /* ccons ::= DEFAULT id */ +#line 253 "parse.y" +{ + Expr *p = sqlite3PExpr(pParse, TK_STRING, 0, 0, &yymsp[0].minor.yy0); + sqlite3AddDefaultValue(pParse,p); +} +#line 2163 "parse.c" + break; + case 56: /* ccons ::= NOT NULL onconf */ +#line 262 "parse.y" +{sqlite3AddNotNull(pParse, yymsp[0].minor.yy328);} +#line 2168 "parse.c" + break; + case 57: /* ccons ::= PRIMARY KEY sortorder onconf autoinc */ +#line 264 "parse.y" +{sqlite3AddPrimaryKey(pParse,0,yymsp[-1].minor.yy328,yymsp[0].minor.yy328,yymsp[-2].minor.yy328);} +#line 2173 "parse.c" + break; + case 58: /* ccons ::= UNIQUE onconf */ +#line 265 "parse.y" +{sqlite3CreateIndex(pParse,0,0,0,0,yymsp[0].minor.yy328,0,0,0,0);} +#line 2178 "parse.c" + break; + case 59: /* ccons ::= CHECK LP expr RP */ +#line 266 "parse.y" +{sqlite3AddCheckConstraint(pParse,yymsp[-1].minor.yy418);} +#line 2183 "parse.c" + break; + case 60: /* ccons ::= REFERENCES nm idxlist_opt refargs */ +#line 268 "parse.y" +{sqlite3CreateForeignKey(pParse,0,&yymsp[-2].minor.yy0,yymsp[-1].minor.yy322,yymsp[0].minor.yy328);} +#line 2188 "parse.c" + break; + case 61: /* ccons ::= defer_subclause */ +#line 269 "parse.y" +{sqlite3DeferForeignKey(pParse,yymsp[0].minor.yy328);} +#line 2193 "parse.c" + break; + case 62: /* ccons ::= COLLATE ids */ +#line 270 "parse.y" +{sqlite3AddCollateType(pParse, &yymsp[0].minor.yy0);} +#line 2198 "parse.c" + break; + case 65: /* refargs ::= */ +#line 283 "parse.y" +{ yygotominor.yy328 = OE_Restrict * 0x010101; } +#line 2203 "parse.c" + break; + case 66: /* refargs ::= refargs refarg */ +#line 284 "parse.y" +{ yygotominor.yy328 = (yymsp[-1].minor.yy328 & ~yymsp[0].minor.yy319.mask) | yymsp[0].minor.yy319.value; } +#line 2208 "parse.c" + break; + case 67: /* refarg ::= MATCH nm */ +#line 286 "parse.y" +{ yygotominor.yy319.value = 0; yygotominor.yy319.mask = 0x000000; } +#line 2213 "parse.c" + break; + case 68: /* refarg ::= ON DELETE refact */ +#line 287 "parse.y" +{ yygotominor.yy319.value = yymsp[0].minor.yy328; yygotominor.yy319.mask = 0x0000ff; } +#line 2218 "parse.c" + break; + case 69: /* refarg ::= ON UPDATE refact */ +#line 288 "parse.y" +{ yygotominor.yy319.value = yymsp[0].minor.yy328<<8; yygotominor.yy319.mask = 0x00ff00; } +#line 2223 "parse.c" + break; + case 70: /* refarg ::= ON INSERT refact */ +#line 289 "parse.y" +{ yygotominor.yy319.value = yymsp[0].minor.yy328<<16; yygotominor.yy319.mask = 0xff0000; } +#line 2228 "parse.c" + break; + case 71: /* refact ::= SET NULL */ +#line 291 "parse.y" +{ yygotominor.yy328 = OE_SetNull; } +#line 2233 "parse.c" + break; + case 72: /* refact ::= SET DEFAULT */ +#line 292 "parse.y" +{ yygotominor.yy328 = OE_SetDflt; } +#line 2238 "parse.c" + break; + case 73: /* refact ::= CASCADE */ +#line 293 "parse.y" +{ yygotominor.yy328 = OE_Cascade; } +#line 2243 "parse.c" + break; + case 74: /* refact ::= RESTRICT */ +#line 294 "parse.y" +{ yygotominor.yy328 = OE_Restrict; } +#line 2248 "parse.c" + break; + case 75: /* defer_subclause ::= NOT DEFERRABLE init_deferred_pred_opt */ + case 76: /* defer_subclause ::= DEFERRABLE init_deferred_pred_opt */ + case 91: /* defer_subclause_opt ::= defer_subclause */ + case 93: /* onconf ::= ON CONFLICT resolvetype */ + case 95: /* orconf ::= OR resolvetype */ + case 96: /* resolvetype ::= raisetype */ + case 169: /* insert_cmd ::= INSERT orconf */ +#line 296 "parse.y" +{yygotominor.yy328 = yymsp[0].minor.yy328;} +#line 2259 "parse.c" + break; + case 80: /* conslist_opt ::= */ +#line 306 "parse.y" +{yygotominor.yy0.n = 0; yygotominor.yy0.z = 0;} +#line 2264 "parse.c" + break; + case 81: /* conslist_opt ::= COMMA conslist */ +#line 307 "parse.y" +{yygotominor.yy0 = yymsp[-1].minor.yy0;} +#line 2269 "parse.c" + break; + case 86: /* tcons ::= PRIMARY KEY LP idxlist autoinc RP onconf */ +#line 313 "parse.y" +{sqlite3AddPrimaryKey(pParse,yymsp[-3].minor.yy322,yymsp[0].minor.yy328,yymsp[-2].minor.yy328,0);} +#line 2274 "parse.c" + break; + case 87: /* tcons ::= UNIQUE LP idxlist RP onconf */ +#line 315 "parse.y" +{sqlite3CreateIndex(pParse,0,0,0,yymsp[-2].minor.yy322,yymsp[0].minor.yy328,0,0,0,0);} +#line 2279 "parse.c" + break; + case 88: /* tcons ::= CHECK LP expr RP onconf */ +#line 316 "parse.y" +{sqlite3AddCheckConstraint(pParse,yymsp[-2].minor.yy418);} +#line 2284 "parse.c" + break; + case 89: /* tcons ::= FOREIGN KEY LP idxlist RP REFERENCES nm idxlist_opt refargs defer_subclause_opt */ +#line 318 "parse.y" +{ + sqlite3CreateForeignKey(pParse, yymsp[-6].minor.yy322, &yymsp[-3].minor.yy0, yymsp[-2].minor.yy322, yymsp[-1].minor.yy328); + sqlite3DeferForeignKey(pParse, yymsp[0].minor.yy328); +} +#line 2292 "parse.c" + break; + case 92: /* onconf ::= */ + case 94: /* orconf ::= */ +#line 332 "parse.y" +{yygotominor.yy328 = OE_Default;} +#line 2298 "parse.c" + break; + case 97: /* resolvetype ::= IGNORE */ +#line 337 "parse.y" +{yygotominor.yy328 = OE_Ignore;} +#line 2303 "parse.c" + break; + case 98: /* resolvetype ::= REPLACE */ + case 170: /* insert_cmd ::= REPLACE */ +#line 338 "parse.y" +{yygotominor.yy328 = OE_Replace;} +#line 2309 "parse.c" + break; + case 99: /* cmd ::= DROP TABLE ifexists fullname */ +#line 342 "parse.y" +{ + sqlite3DropTable(pParse, yymsp[0].minor.yy439, 0, yymsp[-1].minor.yy328); +} +#line 2316 "parse.c" + break; + case 102: /* cmd ::= CREATE temp VIEW ifnotexists nm dbnm AS select */ +#line 352 "parse.y" +{ + sqlite3CreateView(pParse, &yymsp[-7].minor.yy0, &yymsp[-3].minor.yy0, &yymsp[-2].minor.yy0, yymsp[0].minor.yy91, yymsp[-6].minor.yy328, yymsp[-4].minor.yy328); +} +#line 2323 "parse.c" + break; + case 103: /* cmd ::= DROP VIEW ifexists fullname */ +#line 355 "parse.y" +{ + sqlite3DropTable(pParse, yymsp[0].minor.yy439, 1, yymsp[-1].minor.yy328); +} +#line 2330 "parse.c" + break; + case 104: /* cmd ::= select */ +#line 362 "parse.y" +{ + SelectDest dest = {SRT_Output, 0, 0, 0, 0}; + sqlite3Select(pParse, yymsp[0].minor.yy91, &dest); + sqlite3SelectDelete(pParse->db, yymsp[0].minor.yy91); +} +#line 2339 "parse.c" + break; + case 105: /* select ::= oneselect */ + case 128: /* seltablist_paren ::= select */ +#line 373 "parse.y" +{yygotominor.yy91 = yymsp[0].minor.yy91;} +#line 2345 "parse.c" + break; + case 106: /* select ::= select multiselect_op oneselect */ +#line 375 "parse.y" +{ + if( yymsp[0].minor.yy91 ){ + yymsp[0].minor.yy91->op = yymsp[-1].minor.yy328; + yymsp[0].minor.yy91->pPrior = yymsp[-2].minor.yy91; + }else{ + sqlite3SelectDelete(pParse->db, yymsp[-2].minor.yy91); + } + yygotominor.yy91 = yymsp[0].minor.yy91; +} +#line 2358 "parse.c" + break; + case 108: /* multiselect_op ::= UNION ALL */ +#line 386 "parse.y" +{yygotominor.yy328 = TK_ALL;} +#line 2363 "parse.c" + break; + case 110: /* oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt */ +#line 390 "parse.y" +{ + yygotominor.yy91 = sqlite3SelectNew(pParse,yymsp[-6].minor.yy322,yymsp[-5].minor.yy439,yymsp[-4].minor.yy418,yymsp[-3].minor.yy322,yymsp[-2].minor.yy418,yymsp[-1].minor.yy322,yymsp[-7].minor.yy328,yymsp[0].minor.yy388.pLimit,yymsp[0].minor.yy388.pOffset); +} +#line 2370 "parse.c" + break; + case 114: /* sclp ::= selcollist COMMA */ + case 241: /* idxlist_opt ::= LP idxlist RP */ +#line 411 "parse.y" +{yygotominor.yy322 = yymsp[-1].minor.yy322;} +#line 2376 "parse.c" + break; + case 115: /* sclp ::= */ + case 144: /* orderby_opt ::= */ + case 152: /* groupby_opt ::= */ + case 234: /* exprlist ::= */ + case 240: /* idxlist_opt ::= */ +#line 412 "parse.y" +{yygotominor.yy322 = 0;} +#line 2385 "parse.c" + break; + case 116: /* selcollist ::= sclp expr as */ +#line 413 "parse.y" +{ + yygotominor.yy322 = sqlite3ExprListAppend(pParse,yymsp[-2].minor.yy322,yymsp[-1].minor.yy418,yymsp[0].minor.yy0.n?&yymsp[0].minor.yy0:0); +} +#line 2392 "parse.c" + break; + case 117: /* selcollist ::= sclp STAR */ +#line 416 "parse.y" +{ + Expr *p = sqlite3PExpr(pParse, TK_ALL, 0, 0, 0); + yygotominor.yy322 = sqlite3ExprListAppend(pParse, yymsp[-1].minor.yy322, p, 0); +} +#line 2400 "parse.c" + break; + case 118: /* selcollist ::= sclp nm DOT STAR */ +#line 420 "parse.y" +{ + Expr *pRight = sqlite3PExpr(pParse, TK_ALL, 0, 0, &yymsp[0].minor.yy0); + Expr *pLeft = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[-2].minor.yy0); + Expr *pDot = sqlite3PExpr(pParse, TK_DOT, pLeft, pRight, 0); + yygotominor.yy322 = sqlite3ExprListAppend(pParse,yymsp[-3].minor.yy322, pDot, 0); +} +#line 2410 "parse.c" + break; + case 121: /* as ::= */ +#line 433 "parse.y" +{yygotominor.yy0.n = 0;} +#line 2415 "parse.c" + break; + case 122: /* from ::= */ +#line 445 "parse.y" +{yygotominor.yy439 = sqlite3DbMallocZero(pParse->db, sizeof(*yygotominor.yy439));} +#line 2420 "parse.c" + break; + case 123: /* from ::= FROM seltablist */ +#line 446 "parse.y" +{ + yygotominor.yy439 = yymsp[0].minor.yy439; + sqlite3SrcListShiftJoinType(yygotominor.yy439); +} +#line 2428 "parse.c" + break; + case 124: /* stl_prefix ::= seltablist joinop */ +#line 454 "parse.y" +{ + yygotominor.yy439 = yymsp[-1].minor.yy439; + if( yygotominor.yy439 && yygotominor.yy439->nSrc>0 ) yygotominor.yy439->a[yygotominor.yy439->nSrc-1].jointype = yymsp[0].minor.yy328; +} +#line 2436 "parse.c" + break; + case 125: /* stl_prefix ::= */ +#line 458 "parse.y" +{yygotominor.yy439 = 0;} +#line 2441 "parse.c" + break; + case 126: /* seltablist ::= stl_prefix nm dbnm as indexed_opt on_opt using_opt */ +#line 459 "parse.y" +{ + yygotominor.yy439 = sqlite3SrcListAppendFromTerm(pParse,yymsp[-6].minor.yy439,&yymsp[-5].minor.yy0,&yymsp[-4].minor.yy0,&yymsp[-3].minor.yy0,0,yymsp[-1].minor.yy418,yymsp[0].minor.yy232); + sqlite3SrcListIndexedBy(pParse, yygotominor.yy439, &yymsp[-2].minor.yy0); +} +#line 2449 "parse.c" + break; + case 127: /* seltablist ::= stl_prefix LP seltablist_paren RP as on_opt using_opt */ +#line 465 "parse.y" +{ + yygotominor.yy439 = sqlite3SrcListAppendFromTerm(pParse,yymsp[-6].minor.yy439,0,0,&yymsp[-2].minor.yy0,yymsp[-4].minor.yy91,yymsp[-1].minor.yy418,yymsp[0].minor.yy232); + } +#line 2456 "parse.c" + break; + case 129: /* seltablist_paren ::= seltablist */ +#line 476 "parse.y" +{ + sqlite3SrcListShiftJoinType(yymsp[0].minor.yy439); + yygotominor.yy91 = sqlite3SelectNew(pParse,0,yymsp[0].minor.yy439,0,0,0,0,0,0,0); + } +#line 2464 "parse.c" + break; + case 130: /* dbnm ::= */ + case 139: /* indexed_opt ::= */ +#line 483 "parse.y" +{yygotominor.yy0.z=0; yygotominor.yy0.n=0;} +#line 2470 "parse.c" + break; + case 132: /* fullname ::= nm dbnm */ +#line 488 "parse.y" +{yygotominor.yy439 = sqlite3SrcListAppend(pParse->db,0,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy0);} +#line 2475 "parse.c" + break; + case 133: /* joinop ::= COMMA|JOIN */ +#line 492 "parse.y" +{ yygotominor.yy328 = JT_INNER; } +#line 2480 "parse.c" + break; + case 134: /* joinop ::= JOIN_KW JOIN */ +#line 493 "parse.y" +{ yygotominor.yy328 = sqlite3JoinType(pParse,&yymsp[-1].minor.yy0,0,0); } +#line 2485 "parse.c" + break; + case 135: /* joinop ::= JOIN_KW nm JOIN */ +#line 494 "parse.y" +{ yygotominor.yy328 = sqlite3JoinType(pParse,&yymsp[-2].minor.yy0,&yymsp[-1].minor.yy0,0); } +#line 2490 "parse.c" + break; + case 136: /* joinop ::= JOIN_KW nm nm JOIN */ +#line 496 "parse.y" +{ yygotominor.yy328 = sqlite3JoinType(pParse,&yymsp[-3].minor.yy0,&yymsp[-2].minor.yy0,&yymsp[-1].minor.yy0); } +#line 2495 "parse.c" + break; + case 137: /* on_opt ::= ON expr */ + case 148: /* sortitem ::= expr */ + case 155: /* having_opt ::= HAVING expr */ + case 162: /* where_opt ::= WHERE expr */ + case 177: /* expr ::= term */ + case 205: /* escape ::= ESCAPE expr */ + case 229: /* case_else ::= ELSE expr */ + case 231: /* case_operand ::= expr */ +#line 500 "parse.y" +{yygotominor.yy418 = yymsp[0].minor.yy418;} +#line 2507 "parse.c" + break; + case 138: /* on_opt ::= */ + case 154: /* having_opt ::= */ + case 161: /* where_opt ::= */ + case 206: /* escape ::= */ + case 230: /* case_else ::= */ + case 232: /* case_operand ::= */ +#line 501 "parse.y" +{yygotominor.yy418 = 0;} +#line 2517 "parse.c" + break; + case 141: /* indexed_opt ::= NOT INDEXED */ +#line 516 "parse.y" +{yygotominor.yy0.z=0; yygotominor.yy0.n=1;} +#line 2522 "parse.c" + break; + case 142: /* using_opt ::= USING LP inscollist RP */ + case 174: /* inscollist_opt ::= LP inscollist RP */ +#line 520 "parse.y" +{yygotominor.yy232 = yymsp[-1].minor.yy232;} +#line 2528 "parse.c" + break; + case 143: /* using_opt ::= */ + case 173: /* inscollist_opt ::= */ +#line 521 "parse.y" +{yygotominor.yy232 = 0;} +#line 2534 "parse.c" + break; + case 145: /* orderby_opt ::= ORDER BY sortlist */ + case 153: /* groupby_opt ::= GROUP BY nexprlist */ + case 233: /* exprlist ::= nexprlist */ +#line 532 "parse.y" +{yygotominor.yy322 = yymsp[0].minor.yy322;} +#line 2541 "parse.c" + break; + case 146: /* sortlist ::= sortlist COMMA sortitem sortorder */ +#line 533 "parse.y" +{ + yygotominor.yy322 = sqlite3ExprListAppend(pParse,yymsp[-3].minor.yy322,yymsp[-1].minor.yy418,0); + if( yygotominor.yy322 ) yygotominor.yy322->a[yygotominor.yy322->nExpr-1].sortOrder = yymsp[0].minor.yy328; +} +#line 2549 "parse.c" + break; + case 147: /* sortlist ::= sortitem sortorder */ +#line 537 "parse.y" +{ + yygotominor.yy322 = sqlite3ExprListAppend(pParse,0,yymsp[-1].minor.yy418,0); + if( yygotominor.yy322 && yygotominor.yy322->a ) yygotominor.yy322->a[0].sortOrder = yymsp[0].minor.yy328; +} +#line 2557 "parse.c" + break; + case 149: /* sortorder ::= ASC */ + case 151: /* sortorder ::= */ +#line 545 "parse.y" +{yygotominor.yy328 = SQLITE_SO_ASC;} +#line 2563 "parse.c" + break; + case 150: /* sortorder ::= DESC */ +#line 546 "parse.y" +{yygotominor.yy328 = SQLITE_SO_DESC;} +#line 2568 "parse.c" + break; + case 156: /* limit_opt ::= */ +#line 572 "parse.y" +{yygotominor.yy388.pLimit = 0; yygotominor.yy388.pOffset = 0;} +#line 2573 "parse.c" + break; + case 157: /* limit_opt ::= LIMIT expr */ +#line 573 "parse.y" +{yygotominor.yy388.pLimit = yymsp[0].minor.yy418; yygotominor.yy388.pOffset = 0;} +#line 2578 "parse.c" + break; + case 158: /* limit_opt ::= LIMIT expr OFFSET expr */ +#line 575 "parse.y" +{yygotominor.yy388.pLimit = yymsp[-2].minor.yy418; yygotominor.yy388.pOffset = yymsp[0].minor.yy418;} +#line 2583 "parse.c" + break; + case 159: /* limit_opt ::= LIMIT expr COMMA expr */ +#line 577 "parse.y" +{yygotominor.yy388.pOffset = yymsp[-2].minor.yy418; yygotominor.yy388.pLimit = yymsp[0].minor.yy418;} +#line 2588 "parse.c" + break; + case 160: /* cmd ::= DELETE FROM fullname indexed_opt where_opt */ +#line 590 "parse.y" +{ + sqlite3SrcListIndexedBy(pParse, yymsp[-2].minor.yy439, &yymsp[-1].minor.yy0); + sqlite3DeleteFrom(pParse,yymsp[-2].minor.yy439,yymsp[0].minor.yy418); +} +#line 2596 "parse.c" + break; + case 163: /* cmd ::= UPDATE orconf fullname indexed_opt SET setlist where_opt */ +#line 613 "parse.y" +{ + sqlite3SrcListIndexedBy(pParse, yymsp[-4].minor.yy439, &yymsp[-3].minor.yy0); + sqlite3ExprListCheckLength(pParse,yymsp[-1].minor.yy322,"set list"); + sqlite3Update(pParse,yymsp[-4].minor.yy439,yymsp[-1].minor.yy322,yymsp[0].minor.yy418,yymsp[-5].minor.yy328); +} +#line 2605 "parse.c" + break; + case 164: /* setlist ::= setlist COMMA nm EQ expr */ +#line 624 "parse.y" +{yygotominor.yy322 = sqlite3ExprListAppend(pParse,yymsp[-4].minor.yy322,yymsp[0].minor.yy418,&yymsp[-2].minor.yy0);} +#line 2610 "parse.c" + break; + case 165: /* setlist ::= nm EQ expr */ +#line 626 "parse.y" +{yygotominor.yy322 = sqlite3ExprListAppend(pParse,0,yymsp[0].minor.yy418,&yymsp[-2].minor.yy0);} +#line 2615 "parse.c" + break; + case 166: /* cmd ::= insert_cmd INTO fullname inscollist_opt VALUES LP itemlist RP */ +#line 632 "parse.y" +{sqlite3Insert(pParse, yymsp[-5].minor.yy439, yymsp[-1].minor.yy322, 0, yymsp[-4].minor.yy232, yymsp[-7].minor.yy328);} +#line 2620 "parse.c" + break; + case 167: /* cmd ::= insert_cmd INTO fullname inscollist_opt select */ +#line 634 "parse.y" +{sqlite3Insert(pParse, yymsp[-2].minor.yy439, 0, yymsp[0].minor.yy91, yymsp[-1].minor.yy232, yymsp[-4].minor.yy328);} +#line 2625 "parse.c" + break; + case 168: /* cmd ::= insert_cmd INTO fullname inscollist_opt DEFAULT VALUES */ +#line 636 "parse.y" +{sqlite3Insert(pParse, yymsp[-3].minor.yy439, 0, 0, yymsp[-2].minor.yy232, yymsp[-5].minor.yy328);} +#line 2630 "parse.c" + break; + case 171: /* itemlist ::= itemlist COMMA expr */ + case 235: /* nexprlist ::= nexprlist COMMA expr */ +#line 647 "parse.y" +{yygotominor.yy322 = sqlite3ExprListAppend(pParse,yymsp[-2].minor.yy322,yymsp[0].minor.yy418,0);} +#line 2636 "parse.c" + break; + case 172: /* itemlist ::= expr */ + case 236: /* nexprlist ::= expr */ +#line 649 "parse.y" +{yygotominor.yy322 = sqlite3ExprListAppend(pParse,0,yymsp[0].minor.yy418,0);} +#line 2642 "parse.c" + break; + case 175: /* inscollist ::= inscollist COMMA nm */ +#line 659 "parse.y" +{yygotominor.yy232 = sqlite3IdListAppend(pParse->db,yymsp[-2].minor.yy232,&yymsp[0].minor.yy0);} +#line 2647 "parse.c" + break; + case 176: /* inscollist ::= nm */ +#line 661 "parse.y" +{yygotominor.yy232 = sqlite3IdListAppend(pParse->db,0,&yymsp[0].minor.yy0);} +#line 2652 "parse.c" + break; + case 178: /* expr ::= LP expr RP */ +#line 672 "parse.y" +{yygotominor.yy418 = yymsp[-1].minor.yy418; sqlite3ExprSpan(yygotominor.yy418,&yymsp[-2].minor.yy0,&yymsp[0].minor.yy0); } +#line 2657 "parse.c" + break; + case 179: /* term ::= NULL */ + case 184: /* term ::= INTEGER|FLOAT|BLOB */ + case 185: /* term ::= STRING */ +#line 673 "parse.y" +{yygotominor.yy418 = sqlite3PExpr(pParse, yymsp[0].major, 0, 0, &yymsp[0].minor.yy0);} +#line 2664 "parse.c" + break; + case 180: /* expr ::= ID */ + case 181: /* expr ::= JOIN_KW */ +#line 674 "parse.y" +{yygotominor.yy418 = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[0].minor.yy0);} +#line 2670 "parse.c" + break; + case 182: /* expr ::= nm DOT nm */ +#line 676 "parse.y" +{ + Expr *temp1 = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[-2].minor.yy0); + Expr *temp2 = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[0].minor.yy0); + yygotominor.yy418 = sqlite3PExpr(pParse, TK_DOT, temp1, temp2, 0); +} +#line 2679 "parse.c" + break; + case 183: /* expr ::= nm DOT nm DOT nm */ +#line 681 "parse.y" +{ + Expr *temp1 = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[-4].minor.yy0); + Expr *temp2 = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[-2].minor.yy0); + Expr *temp3 = sqlite3PExpr(pParse, TK_ID, 0, 0, &yymsp[0].minor.yy0); + Expr *temp4 = sqlite3PExpr(pParse, TK_DOT, temp2, temp3, 0); + yygotominor.yy418 = sqlite3PExpr(pParse, TK_DOT, temp1, temp4, 0); +} +#line 2690 "parse.c" + break; + case 186: /* expr ::= REGISTER */ +#line 690 "parse.y" +{yygotominor.yy418 = sqlite3RegisterExpr(pParse, &yymsp[0].minor.yy0);} +#line 2695 "parse.c" + break; + case 187: /* expr ::= VARIABLE */ +#line 691 "parse.y" +{ + Token *pToken = &yymsp[0].minor.yy0; + Expr *pExpr = yygotominor.yy418 = sqlite3PExpr(pParse, TK_VARIABLE, 0, 0, pToken); + sqlite3ExprAssignVarNumber(pParse, pExpr); +} +#line 2704 "parse.c" + break; + case 188: /* expr ::= expr COLLATE ids */ +#line 696 "parse.y" +{ + yygotominor.yy418 = sqlite3ExprSetColl(pParse, yymsp[-2].minor.yy418, &yymsp[0].minor.yy0); +} +#line 2711 "parse.c" + break; + case 189: /* expr ::= CAST LP expr AS typetoken RP */ +#line 700 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, TK_CAST, yymsp[-3].minor.yy418, 0, &yymsp[-1].minor.yy0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-5].minor.yy0,&yymsp[0].minor.yy0); +} +#line 2719 "parse.c" + break; + case 190: /* expr ::= ID LP distinct exprlist RP */ +#line 705 "parse.y" +{ + if( yymsp[-1].minor.yy322 && yymsp[-1].minor.yy322->nExpr>SQLITE_MAX_FUNCTION_ARG ){ + sqlite3ErrorMsg(pParse, "too many arguments on function %T", &yymsp[-4].minor.yy0); + } + yygotominor.yy418 = sqlite3ExprFunction(pParse, yymsp[-1].minor.yy322, &yymsp[-4].minor.yy0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-4].minor.yy0,&yymsp[0].minor.yy0); + if( yymsp[-2].minor.yy328 && yygotominor.yy418 ){ + yygotominor.yy418->flags |= EP_Distinct; + } +} +#line 2733 "parse.c" + break; + case 191: /* expr ::= ID LP STAR RP */ +#line 715 "parse.y" +{ + yygotominor.yy418 = sqlite3ExprFunction(pParse, 0, &yymsp[-3].minor.yy0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-3].minor.yy0,&yymsp[0].minor.yy0); +} +#line 2741 "parse.c" + break; + case 192: /* term ::= CTIME_KW */ +#line 719 "parse.y" +{ + /* The CURRENT_TIME, CURRENT_DATE, and CURRENT_TIMESTAMP values are + ** treated as functions that return constants */ + yygotominor.yy418 = sqlite3ExprFunction(pParse, 0,&yymsp[0].minor.yy0); + if( yygotominor.yy418 ){ + yygotominor.yy418->op = TK_CONST_FUNC; + yygotominor.yy418->span = yymsp[0].minor.yy0; + } +} +#line 2754 "parse.c" + break; + case 193: /* expr ::= expr AND expr */ + case 194: /* expr ::= expr OR expr */ + case 195: /* expr ::= expr LT|GT|GE|LE expr */ + case 196: /* expr ::= expr EQ|NE expr */ + case 197: /* expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT expr */ + case 198: /* expr ::= expr PLUS|MINUS expr */ + case 199: /* expr ::= expr STAR|SLASH|REM expr */ + case 200: /* expr ::= expr CONCAT expr */ +#line 728 "parse.y" +{yygotominor.yy418 = sqlite3PExpr(pParse,yymsp[-1].major,yymsp[-2].minor.yy418,yymsp[0].minor.yy418,0);} +#line 2766 "parse.c" + break; + case 201: /* likeop ::= LIKE_KW */ + case 203: /* likeop ::= MATCH */ +#line 740 "parse.y" +{yygotominor.yy30.eOperator = yymsp[0].minor.yy0; yygotominor.yy30.not = 0;} +#line 2772 "parse.c" + break; + case 202: /* likeop ::= NOT LIKE_KW */ + case 204: /* likeop ::= NOT MATCH */ +#line 741 "parse.y" +{yygotominor.yy30.eOperator = yymsp[0].minor.yy0; yygotominor.yy30.not = 1;} +#line 2778 "parse.c" + break; + case 207: /* expr ::= expr likeop expr escape */ +#line 748 "parse.y" +{ + ExprList *pList; + pList = sqlite3ExprListAppend(pParse,0, yymsp[-1].minor.yy418, 0); + pList = sqlite3ExprListAppend(pParse,pList, yymsp[-3].minor.yy418, 0); + if( yymsp[0].minor.yy418 ){ + pList = sqlite3ExprListAppend(pParse,pList, yymsp[0].minor.yy418, 0); + } + yygotominor.yy418 = sqlite3ExprFunction(pParse, pList, &yymsp[-2].minor.yy30.eOperator); + if( yymsp[-2].minor.yy30.not ) yygotominor.yy418 = sqlite3PExpr(pParse, TK_NOT, yygotominor.yy418, 0, 0); + sqlite3ExprSpan(yygotominor.yy418, &yymsp[-3].minor.yy418->span, &yymsp[-1].minor.yy418->span); + if( yygotominor.yy418 ) yygotominor.yy418->flags |= EP_InfixFunc; +} +#line 2794 "parse.c" + break; + case 208: /* expr ::= expr ISNULL|NOTNULL */ +#line 761 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, yymsp[0].major, yymsp[-1].minor.yy418, 0, 0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-1].minor.yy418->span,&yymsp[0].minor.yy0); +} +#line 2802 "parse.c" + break; + case 209: /* expr ::= expr IS NULL */ +#line 765 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, TK_ISNULL, yymsp[-2].minor.yy418, 0, 0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-2].minor.yy418->span,&yymsp[0].minor.yy0); +} +#line 2810 "parse.c" + break; + case 210: /* expr ::= expr NOT NULL */ +#line 769 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, TK_NOTNULL, yymsp[-2].minor.yy418, 0, 0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-2].minor.yy418->span,&yymsp[0].minor.yy0); +} +#line 2818 "parse.c" + break; + case 211: /* expr ::= expr IS NOT NULL */ +#line 773 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, TK_NOTNULL, yymsp[-3].minor.yy418, 0, 0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-3].minor.yy418->span,&yymsp[0].minor.yy0); +} +#line 2826 "parse.c" + break; + case 212: /* expr ::= NOT expr */ + case 213: /* expr ::= BITNOT expr */ +#line 777 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, yymsp[-1].major, yymsp[0].minor.yy418, 0, 0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy418->span); +} +#line 2835 "parse.c" + break; + case 214: /* expr ::= MINUS expr */ +#line 785 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, TK_UMINUS, yymsp[0].minor.yy418, 0, 0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy418->span); +} +#line 2843 "parse.c" + break; + case 215: /* expr ::= PLUS expr */ +#line 789 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, TK_UPLUS, yymsp[0].minor.yy418, 0, 0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy418->span); +} +#line 2851 "parse.c" + break; + case 218: /* expr ::= expr between_op expr AND expr */ +#line 796 "parse.y" +{ + ExprList *pList = sqlite3ExprListAppend(pParse,0, yymsp[-2].minor.yy418, 0); + pList = sqlite3ExprListAppend(pParse,pList, yymsp[0].minor.yy418, 0); + yygotominor.yy418 = sqlite3PExpr(pParse, TK_BETWEEN, yymsp[-4].minor.yy418, 0, 0); + if( yygotominor.yy418 ){ + yygotominor.yy418->pList = pList; + }else{ + sqlite3ExprListDelete(pParse->db, pList); + } + if( yymsp[-3].minor.yy328 ) yygotominor.yy418 = sqlite3PExpr(pParse, TK_NOT, yygotominor.yy418, 0, 0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-4].minor.yy418->span,&yymsp[0].minor.yy418->span); +} +#line 2867 "parse.c" + break; + case 221: /* expr ::= expr in_op LP exprlist RP */ +#line 812 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, TK_IN, yymsp[-4].minor.yy418, 0, 0); + if( yygotominor.yy418 ){ + yygotominor.yy418->pList = yymsp[-1].minor.yy322; + sqlite3ExprSetHeight(pParse, yygotominor.yy418); + }else{ + sqlite3ExprListDelete(pParse->db, yymsp[-1].minor.yy322); + } + if( yymsp[-3].minor.yy328 ) yygotominor.yy418 = sqlite3PExpr(pParse, TK_NOT, yygotominor.yy418, 0, 0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-4].minor.yy418->span,&yymsp[0].minor.yy0); + } +#line 2882 "parse.c" + break; + case 222: /* expr ::= LP select RP */ +#line 823 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, TK_SELECT, 0, 0, 0); + if( yygotominor.yy418 ){ + yygotominor.yy418->pSelect = yymsp[-1].minor.yy91; + sqlite3ExprSetHeight(pParse, yygotominor.yy418); + }else{ + sqlite3SelectDelete(pParse->db, yymsp[-1].minor.yy91); + } + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-2].minor.yy0,&yymsp[0].minor.yy0); + } +#line 2896 "parse.c" + break; + case 223: /* expr ::= expr in_op LP select RP */ +#line 833 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, TK_IN, yymsp[-4].minor.yy418, 0, 0); + if( yygotominor.yy418 ){ + yygotominor.yy418->pSelect = yymsp[-1].minor.yy91; + sqlite3ExprSetHeight(pParse, yygotominor.yy418); + }else{ + sqlite3SelectDelete(pParse->db, yymsp[-1].minor.yy91); + } + if( yymsp[-3].minor.yy328 ) yygotominor.yy418 = sqlite3PExpr(pParse, TK_NOT, yygotominor.yy418, 0, 0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-4].minor.yy418->span,&yymsp[0].minor.yy0); + } +#line 2911 "parse.c" + break; + case 224: /* expr ::= expr in_op nm dbnm */ +#line 844 "parse.y" +{ + SrcList *pSrc = sqlite3SrcListAppend(pParse->db, 0,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy0); + yygotominor.yy418 = sqlite3PExpr(pParse, TK_IN, yymsp[-3].minor.yy418, 0, 0); + if( yygotominor.yy418 ){ + yygotominor.yy418->pSelect = sqlite3SelectNew(pParse, 0,pSrc,0,0,0,0,0,0,0); + sqlite3ExprSetHeight(pParse, yygotominor.yy418); + }else{ + sqlite3SrcListDelete(pParse->db, pSrc); + } + if( yymsp[-2].minor.yy328 ) yygotominor.yy418 = sqlite3PExpr(pParse, TK_NOT, yygotominor.yy418, 0, 0); + sqlite3ExprSpan(yygotominor.yy418,&yymsp[-3].minor.yy418->span,yymsp[0].minor.yy0.z?&yymsp[0].minor.yy0:&yymsp[-1].minor.yy0); + } +#line 2927 "parse.c" + break; + case 225: /* expr ::= EXISTS LP select RP */ +#line 856 "parse.y" +{ + Expr *p = yygotominor.yy418 = sqlite3PExpr(pParse, TK_EXISTS, 0, 0, 0); + if( p ){ + p->pSelect = yymsp[-1].minor.yy91; + sqlite3ExprSpan(p,&yymsp[-3].minor.yy0,&yymsp[0].minor.yy0); + sqlite3ExprSetHeight(pParse, yygotominor.yy418); + }else{ + sqlite3SelectDelete(pParse->db, yymsp[-1].minor.yy91); + } + } +#line 2941 "parse.c" + break; + case 226: /* expr ::= CASE case_operand case_exprlist case_else END */ +#line 869 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, TK_CASE, yymsp[-3].minor.yy418, yymsp[-1].minor.yy418, 0); + if( yygotominor.yy418 ){ + yygotominor.yy418->pList = yymsp[-2].minor.yy322; + sqlite3ExprSetHeight(pParse, yygotominor.yy418); + }else{ + sqlite3ExprListDelete(pParse->db, yymsp[-2].minor.yy322); + } + sqlite3ExprSpan(yygotominor.yy418, &yymsp[-4].minor.yy0, &yymsp[0].minor.yy0); +} +#line 2955 "parse.c" + break; + case 227: /* case_exprlist ::= case_exprlist WHEN expr THEN expr */ +#line 881 "parse.y" +{ + yygotominor.yy322 = sqlite3ExprListAppend(pParse,yymsp[-4].minor.yy322, yymsp[-2].minor.yy418, 0); + yygotominor.yy322 = sqlite3ExprListAppend(pParse,yygotominor.yy322, yymsp[0].minor.yy418, 0); +} +#line 2963 "parse.c" + break; + case 228: /* case_exprlist ::= WHEN expr THEN expr */ +#line 885 "parse.y" +{ + yygotominor.yy322 = sqlite3ExprListAppend(pParse,0, yymsp[-2].minor.yy418, 0); + yygotominor.yy322 = sqlite3ExprListAppend(pParse,yygotominor.yy322, yymsp[0].minor.yy418, 0); +} +#line 2971 "parse.c" + break; + case 237: /* cmd ::= CREATE uniqueflag INDEX ifnotexists nm dbnm ON nm LP idxlist RP */ +#line 914 "parse.y" +{ + sqlite3CreateIndex(pParse, &yymsp[-6].minor.yy0, &yymsp[-5].minor.yy0, + sqlite3SrcListAppend(pParse->db,0,&yymsp[-3].minor.yy0,0), yymsp[-1].minor.yy322, yymsp[-9].minor.yy328, + &yymsp[-10].minor.yy0, &yymsp[0].minor.yy0, SQLITE_SO_ASC, yymsp[-7].minor.yy328); +} +#line 2980 "parse.c" + break; + case 238: /* uniqueflag ::= UNIQUE */ + case 285: /* raisetype ::= ABORT */ +#line 921 "parse.y" +{yygotominor.yy328 = OE_Abort;} +#line 2986 "parse.c" + break; + case 239: /* uniqueflag ::= */ +#line 922 "parse.y" +{yygotominor.yy328 = OE_None;} +#line 2991 "parse.c" + break; + case 242: /* idxlist ::= idxlist COMMA nm collate sortorder */ +#line 931 "parse.y" +{ + Expr *p = 0; + if( yymsp[-1].minor.yy0.n>0 ){ + p = sqlite3PExpr(pParse, TK_COLUMN, 0, 0, 0); + sqlite3ExprSetColl(pParse, p, &yymsp[-1].minor.yy0); + } + yygotominor.yy322 = sqlite3ExprListAppend(pParse,yymsp[-4].minor.yy322, p, &yymsp[-2].minor.yy0); + sqlite3ExprListCheckLength(pParse, yygotominor.yy322, "index"); + if( yygotominor.yy322 ) yygotominor.yy322->a[yygotominor.yy322->nExpr-1].sortOrder = yymsp[0].minor.yy328; +} +#line 3005 "parse.c" + break; + case 243: /* idxlist ::= nm collate sortorder */ +#line 941 "parse.y" +{ + Expr *p = 0; + if( yymsp[-1].minor.yy0.n>0 ){ + p = sqlite3PExpr(pParse, TK_COLUMN, 0, 0, 0); + sqlite3ExprSetColl(pParse, p, &yymsp[-1].minor.yy0); + } + yygotominor.yy322 = sqlite3ExprListAppend(pParse,0, p, &yymsp[-2].minor.yy0); + sqlite3ExprListCheckLength(pParse, yygotominor.yy322, "index"); + if( yygotominor.yy322 ) yygotominor.yy322->a[yygotominor.yy322->nExpr-1].sortOrder = yymsp[0].minor.yy328; +} +#line 3019 "parse.c" + break; + case 244: /* collate ::= */ +#line 953 "parse.y" +{yygotominor.yy0.z = 0; yygotominor.yy0.n = 0;} +#line 3024 "parse.c" + break; + case 246: /* cmd ::= DROP INDEX ifexists fullname */ +#line 959 "parse.y" +{sqlite3DropIndex(pParse, yymsp[0].minor.yy439, yymsp[-1].minor.yy328);} +#line 3029 "parse.c" + break; + case 247: /* cmd ::= VACUUM */ + case 248: /* cmd ::= VACUUM nm */ +#line 965 "parse.y" +{sqlite3Vacuum(pParse);} +#line 3035 "parse.c" + break; + case 249: /* cmd ::= PRAGMA nm dbnm EQ nmnum */ + case 250: /* cmd ::= PRAGMA nm dbnm EQ ON */ + case 251: /* cmd ::= PRAGMA nm dbnm EQ DELETE */ +#line 974 "parse.y" +{sqlite3Pragma(pParse,&yymsp[-3].minor.yy0,&yymsp[-2].minor.yy0,&yymsp[0].minor.yy0,0);} +#line 3042 "parse.c" + break; + case 252: /* cmd ::= PRAGMA nm dbnm EQ minus_num */ +#line 977 "parse.y" +{ + sqlite3Pragma(pParse,&yymsp[-3].minor.yy0,&yymsp[-2].minor.yy0,&yymsp[0].minor.yy0,1); +} +#line 3049 "parse.c" + break; + case 253: /* cmd ::= PRAGMA nm dbnm LP nmnum RP */ +#line 980 "parse.y" +{sqlite3Pragma(pParse,&yymsp[-4].minor.yy0,&yymsp[-3].minor.yy0,&yymsp[-1].minor.yy0,0);} +#line 3054 "parse.c" + break; + case 254: /* cmd ::= PRAGMA nm dbnm */ +#line 981 "parse.y" +{sqlite3Pragma(pParse,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy0,0,0);} +#line 3059 "parse.c" + break; + case 262: /* cmd ::= CREATE trigger_decl BEGIN trigger_cmd_list END */ +#line 996 "parse.y" +{ + Token all; + all.z = yymsp[-3].minor.yy0.z; + all.n = (yymsp[0].minor.yy0.z - yymsp[-3].minor.yy0.z) + yymsp[0].minor.yy0.n; + sqlite3FinishTrigger(pParse, yymsp[-1].minor.yy451, &all); +} +#line 3069 "parse.c" + break; + case 263: /* trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause */ +#line 1005 "parse.y" +{ + sqlite3BeginTrigger(pParse, &yymsp[-7].minor.yy0, &yymsp[-6].minor.yy0, yymsp[-5].minor.yy328, yymsp[-4].minor.yy378.a, yymsp[-4].minor.yy378.b, yymsp[-2].minor.yy439, yymsp[0].minor.yy418, yymsp[-10].minor.yy328, yymsp[-8].minor.yy328); + yygotominor.yy0 = (yymsp[-6].minor.yy0.n==0?yymsp[-7].minor.yy0:yymsp[-6].minor.yy0); +} +#line 3077 "parse.c" + break; + case 264: /* trigger_time ::= BEFORE */ + case 267: /* trigger_time ::= */ +#line 1011 "parse.y" +{ yygotominor.yy328 = TK_BEFORE; } +#line 3083 "parse.c" + break; + case 265: /* trigger_time ::= AFTER */ +#line 1012 "parse.y" +{ yygotominor.yy328 = TK_AFTER; } +#line 3088 "parse.c" + break; + case 266: /* trigger_time ::= INSTEAD OF */ +#line 1013 "parse.y" +{ yygotominor.yy328 = TK_INSTEAD;} +#line 3093 "parse.c" + break; + case 268: /* trigger_event ::= DELETE|INSERT */ + case 269: /* trigger_event ::= UPDATE */ +#line 1018 "parse.y" +{yygotominor.yy378.a = yymsp[0].major; yygotominor.yy378.b = 0;} +#line 3099 "parse.c" + break; + case 270: /* trigger_event ::= UPDATE OF inscollist */ +#line 1020 "parse.y" +{yygotominor.yy378.a = TK_UPDATE; yygotominor.yy378.b = yymsp[0].minor.yy232;} +#line 3104 "parse.c" + break; + case 273: /* when_clause ::= */ + case 290: /* key_opt ::= */ +#line 1027 "parse.y" +{ yygotominor.yy418 = 0; } +#line 3110 "parse.c" + break; + case 274: /* when_clause ::= WHEN expr */ + case 291: /* key_opt ::= KEY expr */ +#line 1028 "parse.y" +{ yygotominor.yy418 = yymsp[0].minor.yy418; } +#line 3116 "parse.c" + break; + case 275: /* trigger_cmd_list ::= trigger_cmd_list trigger_cmd SEMI */ +#line 1032 "parse.y" +{ +/* + if( yymsp[-2].minor.yy451 ){ + yymsp[-2].minor.yy451->pLast->pNext = yymsp[-1].minor.yy451; + }else{ + yymsp[-2].minor.yy451 = yymsp[-1].minor.yy451; + } +*/ + assert( yymsp[-2].minor.yy451!=0 ); + yymsp[-2].minor.yy451->pLast->pNext = yymsp[-1].minor.yy451; + yymsp[-2].minor.yy451->pLast = yymsp[-1].minor.yy451; + yygotominor.yy451 = yymsp[-2].minor.yy451; +} +#line 3133 "parse.c" + break; + case 276: /* trigger_cmd_list ::= trigger_cmd SEMI */ +#line 1045 "parse.y" +{ + /* if( yymsp[-1].minor.yy451 ) */ + assert( yymsp[-1].minor.yy451!=0 ); + yymsp[-1].minor.yy451->pLast = yymsp[-1].minor.yy451; + yygotominor.yy451 = yymsp[-1].minor.yy451; +} +#line 3143 "parse.c" + break; + case 277: /* trigger_cmd ::= UPDATE orconf nm SET setlist where_opt */ +#line 1056 "parse.y" +{ yygotominor.yy451 = sqlite3TriggerUpdateStep(pParse->db, &yymsp[-3].minor.yy0, yymsp[-1].minor.yy322, yymsp[0].minor.yy418, yymsp[-4].minor.yy328); } +#line 3148 "parse.c" + break; + case 278: /* trigger_cmd ::= insert_cmd INTO nm inscollist_opt VALUES LP itemlist RP */ +#line 1061 "parse.y" +{yygotominor.yy451 = sqlite3TriggerInsertStep(pParse->db, &yymsp[-5].minor.yy0, yymsp[-4].minor.yy232, yymsp[-1].minor.yy322, 0, yymsp[-7].minor.yy328);} +#line 3153 "parse.c" + break; + case 279: /* trigger_cmd ::= insert_cmd INTO nm inscollist_opt select */ +#line 1064 "parse.y" +{yygotominor.yy451 = sqlite3TriggerInsertStep(pParse->db, &yymsp[-2].minor.yy0, yymsp[-1].minor.yy232, 0, yymsp[0].minor.yy91, yymsp[-4].minor.yy328);} +#line 3158 "parse.c" + break; + case 280: /* trigger_cmd ::= DELETE FROM nm where_opt */ +#line 1068 "parse.y" +{yygotominor.yy451 = sqlite3TriggerDeleteStep(pParse->db, &yymsp[-1].minor.yy0, yymsp[0].minor.yy418);} +#line 3163 "parse.c" + break; + case 281: /* trigger_cmd ::= select */ +#line 1071 "parse.y" +{yygotominor.yy451 = sqlite3TriggerSelectStep(pParse->db, yymsp[0].minor.yy91); } +#line 3168 "parse.c" + break; + case 282: /* expr ::= RAISE LP IGNORE RP */ +#line 1074 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, TK_RAISE, 0, 0, 0); + if( yygotominor.yy418 ){ + yygotominor.yy418->iColumn = OE_Ignore; + sqlite3ExprSpan(yygotominor.yy418, &yymsp[-3].minor.yy0, &yymsp[0].minor.yy0); + } +} +#line 3179 "parse.c" + break; + case 283: /* expr ::= RAISE LP raisetype COMMA nm RP */ +#line 1081 "parse.y" +{ + yygotominor.yy418 = sqlite3PExpr(pParse, TK_RAISE, 0, 0, &yymsp[-1].minor.yy0); + if( yygotominor.yy418 ) { + yygotominor.yy418->iColumn = yymsp[-3].minor.yy328; + sqlite3ExprSpan(yygotominor.yy418, &yymsp[-5].minor.yy0, &yymsp[0].minor.yy0); + } +} +#line 3190 "parse.c" + break; + case 284: /* raisetype ::= ROLLBACK */ +#line 1091 "parse.y" +{yygotominor.yy328 = OE_Rollback;} +#line 3195 "parse.c" + break; + case 286: /* raisetype ::= FAIL */ +#line 1093 "parse.y" +{yygotominor.yy328 = OE_Fail;} +#line 3200 "parse.c" + break; + case 287: /* cmd ::= DROP TRIGGER ifexists fullname */ +#line 1098 "parse.y" +{ + sqlite3DropTrigger(pParse,yymsp[0].minor.yy439,yymsp[-1].minor.yy328); +} +#line 3207 "parse.c" + break; + case 288: /* cmd ::= ATTACH database_kw_opt expr AS expr key_opt */ +#line 1105 "parse.y" +{ + sqlite3Attach(pParse, yymsp[-3].minor.yy418, yymsp[-1].minor.yy418, yymsp[0].minor.yy418); +} +#line 3214 "parse.c" + break; + case 289: /* cmd ::= DETACH database_kw_opt expr */ +#line 1108 "parse.y" +{ + sqlite3Detach(pParse, yymsp[0].minor.yy418); +} +#line 3221 "parse.c" + break; + case 294: /* cmd ::= REINDEX */ +#line 1123 "parse.y" +{sqlite3Reindex(pParse, 0, 0);} +#line 3226 "parse.c" + break; + case 295: /* cmd ::= REINDEX nm dbnm */ +#line 1124 "parse.y" +{sqlite3Reindex(pParse, &yymsp[-1].minor.yy0, &yymsp[0].minor.yy0);} +#line 3231 "parse.c" + break; + case 296: /* cmd ::= ANALYZE */ +#line 1129 "parse.y" +{sqlite3Analyze(pParse, 0, 0);} +#line 3236 "parse.c" + break; + case 297: /* cmd ::= ANALYZE nm dbnm */ +#line 1130 "parse.y" +{sqlite3Analyze(pParse, &yymsp[-1].minor.yy0, &yymsp[0].minor.yy0);} +#line 3241 "parse.c" + break; + case 298: /* cmd ::= ALTER TABLE fullname RENAME TO nm */ +#line 1135 "parse.y" +{ + sqlite3AlterRenameTable(pParse,yymsp[-3].minor.yy439,&yymsp[0].minor.yy0); +} +#line 3248 "parse.c" + break; + case 299: /* cmd ::= ALTER TABLE add_column_fullname ADD kwcolumn_opt column */ +#line 1138 "parse.y" +{ + sqlite3AlterFinishAddColumn(pParse, &yymsp[0].minor.yy0); +} +#line 3255 "parse.c" + break; + case 300: /* add_column_fullname ::= fullname */ +#line 1141 "parse.y" +{ + sqlite3AlterBeginAddColumn(pParse, yymsp[0].minor.yy439); +} +#line 3262 "parse.c" + break; + }; + yygoto = yyRuleInfo[yyruleno].lhs; + yysize = yyRuleInfo[yyruleno].nrhs; + yypParser->yyidx -= yysize; + yyact = yy_find_reduce_action(yymsp[-yysize].stateno,yygoto); + if( yyact < YYNSTATE ){ +#ifdef NDEBUG + /* If we are not debugging and the reduce action popped at least + ** one element off the stack, then we can push the new element back + ** onto the stack here, and skip the stack overflow test in yy_shift(). + ** That gives a significant speed improvement. */ + if( yysize ){ + yypParser->yyidx++; + yymsp -= yysize-1; + yymsp->stateno = yyact; + yymsp->major = yygoto; + yymsp->minor = yygotominor; + }else +#endif + { + yy_shift(yypParser,yyact,yygoto,&yygotominor); + } + }else{ + assert( yyact == YYNSTATE + YYNRULE + 1 ); + yy_accept(yypParser); + } +} + +/* +** The following code executes when the parse fails +*/ +static void yy_parse_failed( + yyParser *yypParser /* The parser */ +){ + sqlite3ParserARG_FETCH; +#ifndef NDEBUG + if( yyTraceFILE ){ + fprintf(yyTraceFILE,"%sFail!\n",yyTracePrompt); + } +#endif + while( yypParser->yyidx>=0 ) yy_pop_parser_stack(yypParser); + /* Here code is inserted which will be executed whenever the + ** parser fails */ + sqlite3ParserARG_STORE; /* Suppress warning about unused %extra_argument variable */ +} + +/* +** The following code executes when a syntax error first occurs. +*/ +static void yy_syntax_error( + yyParser *yypParser, /* The parser */ + int yymajor, /* The major type of the error token */ + YYMINORTYPE yyminor /* The minor type of the error token */ +){ + sqlite3ParserARG_FETCH; +#define TOKEN (yyminor.yy0) +#line 34 "parse.y" + + assert( TOKEN.z[0] ); /* The tokenizer always gives us a token */ + sqlite3ErrorMsg(pParse, "near \"%T\": syntax error", &TOKEN); + pParse->parseError = 1; +#line 3327 "parse.c" + sqlite3ParserARG_STORE; /* Suppress warning about unused %extra_argument variable */ +} + +/* +** The following is executed when the parser accepts +*/ +static void yy_accept( + yyParser *yypParser /* The parser */ +){ + sqlite3ParserARG_FETCH; +#ifndef NDEBUG + if( yyTraceFILE ){ + fprintf(yyTraceFILE,"%sAccept!\n",yyTracePrompt); + } +#endif + while( yypParser->yyidx>=0 ) yy_pop_parser_stack(yypParser); + /* Here code is inserted which will be executed whenever the + ** parser accepts */ + sqlite3ParserARG_STORE; /* Suppress warning about unused %extra_argument variable */ +} + +/* The main parser program. +** The first argument is a pointer to a structure obtained from +** "sqlite3ParserAlloc" which describes the current state of the parser. +** The second argument is the major token number. The third is +** the minor token. The fourth optional argument is whatever the +** user wants (and specified in the grammar) and is available for +** use by the action routines. +** +** Inputs: +**
    +**
  • A pointer to the parser (an opaque structure.) +**
  • The major token number. +**
  • The minor token number. +**
  • An option argument of a grammar-specified type. +**
+** +** Outputs: +** None. +*/ +void sqlite3Parser( + void *yyp, /* The parser */ + int yymajor, /* The major token code number */ + sqlite3ParserTOKENTYPE yyminor /* The value for the token */ + sqlite3ParserARG_PDECL /* Optional %extra_argument parameter */ +){ + YYMINORTYPE yyminorunion; + int yyact; /* The parser action. */ + int yyendofinput; /* True if we are at the end of input */ +#ifdef YYERRORSYMBOL + int yyerrorhit = 0; /* True if yymajor has invoked an error */ +#endif + yyParser *yypParser; /* The parser */ + + /* (re)initialize the parser, if necessary */ + yypParser = (yyParser*)yyp; + if( yypParser->yyidx<0 ){ +#if YYSTACKDEPTH<=0 + if( yypParser->yystksz <=0 ){ + /*memset(&yyminorunion, 0, sizeof(yyminorunion));*/ + yyminorunion = yyzerominor; + yyStackOverflow(yypParser, &yyminorunion); + return; + } +#endif + yypParser->yyidx = 0; + yypParser->yyerrcnt = -1; + yypParser->yystack[0].stateno = 0; + yypParser->yystack[0].major = 0; + } + yyminorunion.yy0 = yyminor; + yyendofinput = (yymajor==0); + sqlite3ParserARG_STORE; + +#ifndef NDEBUG + if( yyTraceFILE ){ + fprintf(yyTraceFILE,"%sInput %s\n",yyTracePrompt,yyTokenName[yymajor]); + } +#endif + + do{ + yyact = yy_find_shift_action(yypParser,yymajor); + if( yyactyyerrcnt--; + yymajor = YYNOCODE; + }else if( yyact < YYNSTATE + YYNRULE ){ + yy_reduce(yypParser,yyact-YYNSTATE); + }else{ + assert( yyact == YY_ERROR_ACTION ); +#ifdef YYERRORSYMBOL + int yymx; +#endif +#ifndef NDEBUG + if( yyTraceFILE ){ + fprintf(yyTraceFILE,"%sSyntax Error!\n",yyTracePrompt); + } +#endif +#ifdef YYERRORSYMBOL + /* A syntax error has occurred. + ** The response to an error depends upon whether or not the + ** grammar defines an error token "ERROR". + ** + ** This is what we do if the grammar does define ERROR: + ** + ** * Call the %syntax_error function. + ** + ** * Begin popping the stack until we enter a state where + ** it is legal to shift the error symbol, then shift + ** the error symbol. + ** + ** * Set the error count to three. + ** + ** * Begin accepting and shifting new tokens. No new error + ** processing will occur until three tokens have been + ** shifted successfully. + ** + */ + if( yypParser->yyerrcnt<0 ){ + yy_syntax_error(yypParser,yymajor,yyminorunion); + } + yymx = yypParser->yystack[yypParser->yyidx].major; + if( yymx==YYERRORSYMBOL || yyerrorhit ){ +#ifndef NDEBUG + if( yyTraceFILE ){ + fprintf(yyTraceFILE,"%sDiscard input token %s\n", + yyTracePrompt,yyTokenName[yymajor]); + } +#endif + yy_destructor(yypParser, yymajor,&yyminorunion); + yymajor = YYNOCODE; + }else{ + while( + yypParser->yyidx >= 0 && + yymx != YYERRORSYMBOL && + (yyact = yy_find_reduce_action( + yypParser->yystack[yypParser->yyidx].stateno, + YYERRORSYMBOL)) >= YYNSTATE + ){ + yy_pop_parser_stack(yypParser); + } + if( yypParser->yyidx < 0 || yymajor==0 ){ + yy_destructor(yypParser,yymajor,&yyminorunion); + yy_parse_failed(yypParser); + yymajor = YYNOCODE; + }else if( yymx!=YYERRORSYMBOL ){ + YYMINORTYPE u2; + u2.YYERRSYMDT = 0; + yy_shift(yypParser,yyact,YYERRORSYMBOL,&u2); + } + } + yypParser->yyerrcnt = 3; + yyerrorhit = 1; +#else /* YYERRORSYMBOL is not defined */ + /* This is what we do if the grammar does not define ERROR: + ** + ** * Report an error message, and throw away the input token. + ** + ** * If the input token is $, then fail the parse. + ** + ** As before, subsequent error messages are suppressed until + ** three input tokens have been successfully shifted. + */ + if( yypParser->yyerrcnt<=0 ){ + yy_syntax_error(yypParser,yymajor,yyminorunion); + } + yypParser->yyerrcnt = 3; + yy_destructor(yypParser,yymajor,&yyminorunion); + if( yyendofinput ){ + yy_parse_failed(yypParser); + } + yymajor = YYNOCODE; +#endif + } + }while( yymajor!=YYNOCODE && yypParser->yyidx>=0 ); + return; +}