Tarantool development patches archive
 help / color / mirror / Atom feed
* [tarantool-patches] [PATCH v2] sql: remove support of partial indexes
@ 2018-04-18 20:03 Gleb
  2018-04-23 17:30 ` [tarantool-patches] " GLEB SKIBA
  0 siblings, 1 reply; 3+ messages in thread
From: Gleb @ 2018-04-18 20:03 UTC (permalink / raw)
  To: tarantool-patches

Remove support partial indexes.
Add test which checks inaccessibility of partial index syntax.
Delete use partial index from tests.
They can be enabled after #2626.

Fixes #2165
---
Issue from https://github.com/tarantool/tarantool/issues/2165.
Source from https://github.com/tarantool/tarantool/tree/gh-2165-remove-support-partial-indexes.
Changes in v2:
 -return tests which use partial.
 -delete "WHERE" from returned tests.

 src/box/sql/parse.c                                | 472 ++++++++++-----------
 src/box/sql/parse.y                                |   4 +-
 test/sql-tap/analyze9.test.lua                     |   2 +-
 test/sql-tap/autoindex4.test.lua                   |   2 +-
 test/sql-tap/fkey1.test.lua                        |   2 +-
 ...gh-2165-remove-support-partial-indexes.test.lua |  17 +
 test/sql-tap/index6.test.lua                       |  12 +-
 test/sql-tap/index7.test.lua                       |  25 +-
 8 files changed, 277 insertions(+), 259 deletions(-)
 create mode 100644 test/sql-tap/gh-2165-remove-support-partial-indexes.test.lua

diff --git a/src/box/sql/parse.c b/src/box/sql/parse.c
index 5c0f0ea..f5612d4 100644
--- a/src/box/sql/parse.c
+++ b/src/box/sql/parse.c
@@ -315,16 +315,16 @@ typedef union {
 #define sqlite3ParserARG_FETCH Parse *pParse = yypParser->pParse
 #define sqlite3ParserARG_STORE yypParser->pParse = pParse
 #define YYFALLBACK 1
-#define YYNSTATE             409
+#define YYNSTATE             408
 #define YYNRULE              297
-#define YY_MAX_SHIFT         408
-#define YY_MIN_SHIFTREDUCE   604
-#define YY_MAX_SHIFTREDUCE   900
-#define YY_MIN_REDUCE        901
-#define YY_MAX_REDUCE        1197
-#define YY_ERROR_ACTION      1198
-#define YY_ACCEPT_ACTION     1199
-#define YY_NO_ACTION         1200
+#define YY_MAX_SHIFT         407
+#define YY_MIN_SHIFTREDUCE   603
+#define YY_MAX_SHIFTREDUCE   899
+#define YY_MIN_REDUCE        900
+#define YY_MAX_REDUCE        1196
+#define YY_ERROR_ACTION      1197
+#define YY_ACCEPT_ACTION     1198
+#define YY_NO_ACTION         1199
 /************* End control #defines *******************************************/
 
 /* Define the yytestcase() macro to be a no-op if is not already defined
@@ -396,149 +396,149 @@ typedef union {
 **  yy_default[]       Default action for each state.
 **
 *********** Begin parsing tables **********************************************/
-#define YY_ACTTAB_COUNT (1402)
+#define YY_ACTTAB_COUNT (1401)
 static const YYACTIONTYPE yy_action[] = {
- /*     0 */    91,   92,  285,   82,  771,  771,  783,  786,  775,  775,
- /*    10 */    89,   89,   90,   90,   90,   90,  307,   88,   88,   88,
- /*    20 */    88,   87,   87,   86,   86,   86,   85,  307,   90,   90,
+ /*     0 */    91,   92,  284,   82,  770,  770,  782,  785,  774,  774,
+ /*    10 */    89,   89,   90,   90,   90,   90,  306,   88,   88,   88,
+ /*    20 */    88,   87,   87,   86,   86,   86,   85,  306,   90,   90,
  /*    30 */    90,   90,   83,   88,   88,   88,   88,   87,   87,   86,
- /*    40 */    86,   86,   85,  307,  208,  201,  885,   90,   90,   90,
+ /*    40 */    86,   86,   85,  306,  208,  201,  884,   90,   90,   90,
  /*    50 */    90,  122,   88,   88,   88,   88,   87,   87,   86,   86,
- /*    60 */    86,   85,  307,   87,   87,   86,   86,   86,   85,  307,
- /*    70 */   885,   86,   86,   86,   85,  307,   91,   92,  285,   82,
- /*    80 */   771,  771,  783,  786,  775,  775,   89,   89,   90,   90,
- /*    90 */    90,   90,  630,   88,   88,   88,   88,   87,   87,   86,
- /*   100 */    86,   86,   85,  307,   91,   92,  285,   82,  771,  771,
- /*   110 */   783,  786,  775,  775,   89,   89,   90,   90,   90,   90,
- /*   120 */   287,   88,   88,   88,   88,   87,   87,   86,   86,   86,
- /*   130 */    85,  307,  705,   91,   92,  285,   82,  771,  771,  783,
- /*   140 */   786,  775,  775,   89,   89,   90,   90,   90,   90,   67,
+ /*    60 */    86,   85,  306,   87,   87,   86,   86,   86,   85,  306,
+ /*    70 */   884,   86,   86,   86,   85,  306,   91,   92,  284,   82,
+ /*    80 */   770,  770,  782,  785,  774,  774,   89,   89,   90,   90,
+ /*    90 */    90,   90,  629,   88,   88,   88,   88,   87,   87,   86,
+ /*   100 */    86,   86,   85,  306,   91,   92,  284,   82,  770,  770,
+ /*   110 */   782,  785,  774,  774,   89,   89,   90,   90,   90,   90,
+ /*   120 */   286,   88,   88,   88,   88,   87,   87,   86,   86,   86,
+ /*   130 */    85,  306,  704,   91,   92,  284,   82,  770,  770,  782,
+ /*   140 */   785,  774,  774,   89,   89,   90,   90,   90,   90,   67,
  /*   150 */    88,   88,   88,   88,   87,   87,   86,   86,   86,   85,
- /*   160 */   307,  772,  772,  784,  787,  740,   93,  172,  280,  706,
- /*   170 */   312,  278,  277,  276,  220,  274,  243,  633,  618,  721,
- /*   180 */   722,  632,   91,   92,  285,   82,  771,  771,  783,  786,
- /*   190 */   775,  775,   89,   89,   90,   90,   90,   90,  109,   88,
- /*   200 */    88,   88,   88,   87,   87,   86,   86,   86,   85,  307,
+ /*   160 */   306,  771,  771,  783,  786,  739,   93,  172,  279,  705,
+ /*   170 */   311,  277,  276,  275,  220,  273,  242,  632,  617,  720,
+ /*   180 */   721,  631,   91,   92,  284,   82,  770,  770,  782,  785,
+ /*   190 */   774,  774,   89,   89,   90,   90,   90,   90,  109,   88,
+ /*   200 */    88,   88,   88,   87,   87,   86,   86,   86,   85,  306,
  /*   210 */    88,   88,   88,   88,   87,   87,   86,   86,   86,   85,
- /*   220 */   307,  344,  165,  706,  341,  638,  286,  305,  304,  824,
- /*   230 */   776,   91,   92,  285,   82,  771,  771,  783,  786,  775,
- /*   240 */   775,   89,   89,   90,   90,   90,   90,  333,   88,   88,
- /*   250 */    88,   88,   87,   87,   86,   86,   86,   85,  307,  182,
- /*   260 */   743,  666,  645,  407,  407,  180,  313,  122,  137,  218,
- /*   270 */   666,  119,  624,  624,  631,  679,  236,  330,  235,  877,
- /*   280 */    91,   92,  285,   82,  771,  771,  783,  786,  775,  775,
- /*   290 */    89,   89,   90,   90,   90,   90,  743,   88,   88,   88,
- /*   300 */    88,   87,   87,   86,   86,   86,   85,  307,   22,  215,
- /*   310 */   404,  183,  236,  320,  224,  761,  896,  754,  896,   54,
- /*   320 */   749,  720,  705,  762,  122,  216,  366,   48,   48,   91,
- /*   330 */    92,  285,   82,  771,  771,  783,  786,  775,  775,   89,
- /*   340 */    89,   90,   90,   90,   90,  265,   88,   88,   88,   88,
- /*   350 */    87,   87,   86,   86,   86,   85,  307,  753,  753,  755,
- /*   360 */   223,  199,  382,  367,  356,  353,  352,  649,   84,   81,
- /*   370 */   176,  699,  748, 1199,  408,    3,  351,  294,   91,   92,
- /*   380 */   285,   82,  771,  771,  783,  786,  775,  775,   89,   89,
- /*   390 */    90,   90,   90,   90,  317,   88,   88,   88,   88,   87,
- /*   400 */    87,   86,   86,   86,   85,  307,   91,   92,  285,   82,
- /*   410 */   771,  771,  783,  786,  775,  775,   89,   89,   90,   90,
- /*   420 */    90,   90,  648,   88,   88,   88,   88,   87,   87,   86,
- /*   430 */    86,   86,   85,  307,   91,   92,  285,   82,  771,  771,
- /*   440 */   783,  786,  775,  775,   89,   89,   90,   90,   90,   90,
+ /*   220 */   306,  343,  165,  705,  340,  637,  285,  304,  303,  823,
+ /*   230 */   775,   91,   92,  284,   82,  770,  770,  782,  785,  774,
+ /*   240 */   774,   89,   89,   90,   90,   90,   90,  332,   88,   88,
+ /*   250 */    88,   88,   87,   87,   86,   86,   86,   85,  306,  182,
+ /*   260 */   742,  665,  644,  406,  406,  180,  312,  122,  137,  218,
+ /*   270 */   665,  119,  623,  623,  630,  678,  236,  329,  235,  876,
+ /*   280 */    91,   92,  284,   82,  770,  770,  782,  785,  774,  774,
+ /*   290 */    89,   89,   90,   90,   90,   90,  742,   88,   88,   88,
+ /*   300 */    88,   87,   87,   86,   86,   86,   85,  306,   22,  215,
+ /*   310 */   403,  183,  236,  319,  224,  760,  895,  753,  895,   54,
+ /*   320 */   748,  719,  704,  761,  122,  216,  365,   48,   48,   91,
+ /*   330 */    92,  284,   82,  770,  770,  782,  785,  774,  774,   89,
+ /*   340 */    89,   90,   90,   90,   90,  264,   88,   88,   88,   88,
+ /*   350 */    87,   87,   86,   86,   86,   85,  306,  752,  752,  754,
+ /*   360 */   223,  199,  381,  366,  355,  352,  351,  648,   84,   81,
+ /*   370 */   176,  698,  747, 1198,  407,    3,  350,  293,   91,   92,
+ /*   380 */   284,   82,  770,  770,  782,  785,  774,  774,   89,   89,
+ /*   390 */    90,   90,   90,   90,  316,   88,   88,   88,   88,   87,
+ /*   400 */    87,   86,   86,   86,   85,  306,   91,   92,  284,   82,
+ /*   410 */   770,  770,  782,  785,  774,  774,   89,   89,   90,   90,
+ /*   420 */    90,   90,  647,   88,   88,   88,   88,   87,   87,   86,
+ /*   430 */    86,   86,   85,  306,   91,   92,  284,   82,  770,  770,
+ /*   440 */   782,  785,  774,  774,   89,   89,   90,   90,   90,   90,
  /*   450 */   122,   88,   88,   88,   88,   87,   87,   86,   86,   86,
- /*   460 */    85,  307,   91,   92,  285,   82,  771,  771,  783,  786,
- /*   470 */   775,  775,   89,   89,   90,   90,   90,   90,  145,   88,
- /*   480 */    88,   88,   88,   87,   87,   86,   86,   86,   85,  307,
- /*   490 */  1150, 1150,   84,   81,  176,   70,   92,  285,   82,  771,
- /*   500 */   771,  783,  786,  775,  775,   89,   89,   90,   90,   90,
- /*   510 */    90,  647,   88,   88,   88,   88,   87,   87,   86,   86,
- /*   520 */    86,   85,  307,   73,  207,  122,  402,  402,  402,   91,
- /*   530 */    80,  285,   82,  771,  771,  783,  786,  775,  775,   89,
- /*   540 */    89,   90,   90,   90,   90,  376,   88,   88,   88,   88,
- /*   550 */    87,   87,   86,   86,   86,   85,  307,  285,   82,  771,
- /*   560 */   771,  783,  786,  775,  775,   89,   89,   90,   90,   90,
+ /*   460 */    85,  306,   91,   92,  284,   82,  770,  770,  782,  785,
+ /*   470 */   774,  774,   89,   89,   90,   90,   90,   90,  145,   88,
+ /*   480 */    88,   88,   88,   87,   87,   86,   86,   86,   85,  306,
+ /*   490 */  1149, 1149,   84,   81,  176,   70,   92,  284,   82,  770,
+ /*   500 */   770,  782,  785,  774,  774,   89,   89,   90,   90,   90,
+ /*   510 */    90,  646,   88,   88,   88,   88,   87,   87,   86,   86,
+ /*   520 */    86,   85,  306,   73,  207,  122,  401,  401,  401,   91,
+ /*   530 */    80,  284,   82,  770,  770,  782,  785,  774,  774,   89,
+ /*   540 */    89,   90,   90,   90,   90,  375,   88,   88,   88,   88,
+ /*   550 */    87,   87,   86,   86,   86,   85,  306,  284,   82,  770,
+ /*   560 */   770,  782,  785,  774,  774,   89,   89,   90,   90,   90,
  /*   570 */    90,   78,   88,   88,   88,   88,   87,   87,   86,   86,
- /*   580 */    86,   85,  307,  404,  306,  306,  306,  605,  310,  141,
- /*   590 */    75,   76,  264,  624,  624,  692,  873,   77,  284,  315,
- /*   600 */    48,   48,  305,  304,  640,   78,  265,   84,   81,  176,
- /*   610 */   400,    2, 1097,  315,  314,  308,  308,  200,  199,  200,
- /*   620 */   141,  356,  353,  352,   75,   76,  273,  624,  624,  281,
- /*   630 */   404,   77,  389,  351,  387,  382,  372,  761,  303,  754,
- /*   640 */   743, 1173,  749,  661,  400,    2,  404,   10,   10,  308,
- /*   650 */   308,  891,  299,  895,  383,  373,  236,  330,  235,  371,
- /*   660 */   893,  293,  894,   48,   48,  361,  389,  751,  348,  333,
- /*   670 */   201,  761,  846,  754,  705,  315,  749,  296,  398,  753,
- /*   680 */   753,  755,  756,  403,   18,  138,  847,  109,  404,  624,
- /*   690 */   624,  896,  109,  896,  848,  672,  164,  122,  382,  384,
- /*   700 */   374,  751,  673,  843,  122,   48,   48,  162,  174,   78,
- /*   710 */   719,  843,  184,  753,  753,  755,  756,  403,   18,  886,
- /*   720 */   886,  217,  155,  253,  359,  248,  358,  203,   75,   76,
- /*   730 */   693,  122,  689,  189,  246,   77,  109,  688,  404,  328,
- /*   740 */   382,  381,  870,   78,  109,  287,  363,  404,  400,    2,
- /*   750 */   246,   85,  307,  308,  308,   30,   30,   84,   81,  176,
- /*   760 */   331,  658,   75,   76,   48,   48,  870,  404,  331,   77,
- /*   770 */   389,  887,  708,   23,  370,  761,  167,  754,  329,  109,
- /*   780 */   749,  255,  400,    2,   10,   10,  340,  308,  308,  404,
- /*   790 */   364,    9,    9,  216,  366,  404,  177,  177,  295,  382,
- /*   800 */   362,  830,  830,  325,  389,  751,   48,   48,  369,  761,
- /*   810 */   705,  754,   10,   10,  749,  659,  404,  753,  753,  755,
- /*   820 */   756,  403,   18,  624,  624,  404,  198,  404,  339,  886,
- /*   830 */   886,  671,  671,   48,   48,  316,  157,  156,  823,  751,
- /*   840 */   823,  300,   47,   47,   10,   10,   66,   68,  185,  816,
- /*   850 */   818,  753,  753,  755,  756,  403,   18,   95,  379,  146,
- /*   860 */   404,  634,  634,  177,  177,  652,   75,   76,  377,  241,
- /*   870 */     5,  357,  208,   77,  885,  369,  653,   34,   34,  643,
- /*   880 */   339,  887,  707,  761,  404,  754,  400,    2,  749,  318,
- /*   890 */   705,  308,  308,  706,  297,  229,  263,  705,  885,  404,
- /*   900 */    24,   35,   35,  335,  624,  624,  806,  846,  389,  624,
- /*   910 */   624,  816,  188,  761,  404,  754,   36,   36,  749,  240,
- /*   920 */   178,  847,  404,  747,  404,  753,  753,  755,  849,  848,
- /*   930 */   388,   37,   37,  404,  705,  321,  404,  669,  669,   38,
- /*   940 */    38,   26,   26,  751,  404,  228,  165,  706,  404,  841,
- /*   950 */    27,   27,  232,   29,   29,  753,  753,  755,  756,  403,
- /*   960 */    18,   39,   39,  404,  234,   40,   40,  827,  264,  826,
- /*   970 */   404,  705,  678,  404,  921,  323,  227,  404,  226,  404,
- /*   980 */    41,   41,  109,  623,  288,  404,  324,   11,   11,  404,
- /*   990 */    42,   42,  143,  404,   97,   97,   43,   43,  404,  747,
- /*  1000 */   404,  257,   44,   44,  404,  339,   31,   31,  404,  674,
- /*  1010 */    45,   45,  404,  747,  404,   46,   46,   32,   32,  404,
- /*  1020 */   752,  112,  112,  252,  694,  113,  113,  404,  705,  114,
- /*  1030 */   114,   52,   52,  404,  251,  404,   33,   33,  404,  677,
- /*  1040 */   404,  208,  404,  885,   98,   98,  404,  624,  624,  259,
- /*  1050 */    49,   49,   99,   99,  394,  100,  100,   96,   96,  111,
- /*  1060 */   111,  404,  290,  108,  108,  404,  231,  885,  404,  747,
- /*  1070 */   404,  747,  109,  404,  163,  404,  291,  404,  104,  104,
- /*  1080 */   404,  169,  103,  103,  404,  101,  101,  102,  102,  191,
+ /*   580 */    86,   85,  306,  403,  305,  305,  305,  604,  309,  141,
+ /*   590 */    75,   76,  263,  623,  623,  691,  872,   77,  283,  314,
+ /*   600 */    48,   48,  304,  303,  639,   78,  264,   84,   81,  176,
+ /*   610 */   399,    2, 1096,  314,  313,  307,  307,  200,  199,  200,
+ /*   620 */   141,  355,  352,  351,   75,   76,  272,  623,  623,  280,
+ /*   630 */   403,   77,  388,  350,  386,  381,  371,  760,  302,  753,
+ /*   640 */   742, 1172,  748,  660,  399,    2,  403,   10,   10,  307,
+ /*   650 */   307,  890,  298,  894,  382,  372,  236,  329,  235,  370,
+ /*   660 */   892,  292,  893,   48,   48,  360,  388,  750,  347,  332,
+ /*   670 */   201,  760,  845,  753,  704,  314,  748,  295,  397,  752,
+ /*   680 */   752,  754,  755,  402,   18,  138,  846,  109,  403,  623,
+ /*   690 */   623,  895,  109,  895,  847,  671,  164,  122,  381,  383,
+ /*   700 */   373,  750,  672,  842,  122,   48,   48,  162,  174,   78,
+ /*   710 */   718,  842,  184,  752,  752,  754,  755,  402,   18,  885,
+ /*   720 */   885,  217,  155,  252,  358,  247,  357,  203,   75,   76,
+ /*   730 */   692,  122,  688,  189,  245,   77,  109,  687,  403,  327,
+ /*   740 */   381,  380,  869,   78,  109,  286,  362,  403,  399,    2,
+ /*   750 */   245,   85,  306,  307,  307,   30,   30,   84,   81,  176,
+ /*   760 */   330,  657,   75,   76,   48,   48,  869,  403,  330,   77,
+ /*   770 */   388,  886,  707,   23,  369,  760,  167,  753,  328,  109,
+ /*   780 */   748,  254,  399,    2,   10,   10,  339,  307,  307,  403,
+ /*   790 */   363,    9,    9,  216,  365,  403,  177,  177,  294,  381,
+ /*   800 */   361,  829,  829,  324,  388,  750,   48,   48,  368,  760,
+ /*   810 */   704,  753,   10,   10,  748,  658,  403,  752,  752,  754,
+ /*   820 */   755,  402,   18,  623,  623,  403,  198,  403,  338,  885,
+ /*   830 */   885,  670,  670,   48,   48,  315,  157,  156,  822,  750,
+ /*   840 */   822,  299,   47,   47,   10,   10,   66,   68,  185,  815,
+ /*   850 */   817,  752,  752,  754,  755,  402,   18,   95,  378,  146,
+ /*   860 */   403,  633,  633,  177,  177,  651,   75,   76,  376,  240,
+ /*   870 */     5,  356,  208,   77,  884,  368,  652,   34,   34,  642,
+ /*   880 */   338,  886,  706,  760,  403,  753,  399,    2,  748,  317,
+ /*   890 */   704,  307,  307,  705,  296,  229,  262,  704,  884,  403,
+ /*   900 */    24,   35,   35,  334,  623,  623,  805,  845,  388,  623,
+ /*   910 */   623,  815,  188,  760,  403,  753,   36,   36,  748,  239,
+ /*   920 */   178,  846,  403,  746,  403,  752,  752,  754,  848,  847,
+ /*   930 */   387,   37,   37,  403,  704,  320,  403,  668,  668,   38,
+ /*   940 */    38,   26,   26,  750,  403,  228,  165,  705,  403,  840,
+ /*   950 */    27,   27,  232,   29,   29,  752,  752,  754,  755,  402,
+ /*   960 */    18,   39,   39,  403,  234,   40,   40,  826,  263,  825,
+ /*   970 */   403,  704,  677,  403,  920,  322,  227,  403,  226,  403,
+ /*   980 */    41,   41,  109,  622,  287,  403,  323,   11,   11,  403,
+ /*   990 */    42,   42,  143,  403,   97,   97,   43,   43,  403,  746,
+ /*  1000 */   403,  256,   44,   44,  403,  338,   31,   31,  403,  673,
+ /*  1010 */    45,   45,  403,  746,  403,   46,   46,   32,   32,  403,
+ /*  1020 */   751,  112,  112,  251,  693,  113,  113,  403,  704,  114,
+ /*  1030 */   114,   52,   52,  403,  250,  403,   33,   33,  403,  676,
+ /*  1040 */   403,  208,  403,  884,   98,   98,  403,  623,  623,  258,
+ /*  1050 */    49,   49,   99,   99,  393,  100,  100,   96,   96,  111,
+ /*  1060 */   111,  403,  289,  108,  108,  403,  231,  884,  403,  746,
+ /*  1070 */   403,  746,  109,  403,  163,  403,  290,  403,  104,  104,
+ /*  1080 */   403,  169,  103,  103,  403,  101,  101,  102,  102,  191,
  /*  1090 */    51,   51,   53,   53,   50,   50,  107,   25,   25,    1,
- /*  1100 */   628,   28,   28,  624,  624,  365,  681,  684,  684,  622,
- /*  1110 */   161,  160,  159,  401,  288,  391,  395,  369,  399,  175,
- /*  1120 */   174,  337,  721,  722,  628,   74,  884,   72,  689,  110,
- /*  1130 */   262,  149,  292,  688,  301,  745,   20,  206,  332,  334,
- /*  1140 */   206,  206,  109,  237,   64,   66,  651,  650,  109,  109,
- /*  1150 */   349,  109,  212,  244,  822,   66,  822,  641,  641,  686,
- /*  1160 */   715,   69,  206,    7,  813,  813,  338,   19,  735,  809,
- /*  1170 */   626,  212,  106,  852,  757,  757,  319,  851,  153,  820,
- /*  1180 */   289,  814,  225,  168,  233,  838,  840,  837,  336,  342,
- /*  1190 */   343,  239,  354,  617,  242,  158,  662,  646,  247,  713,
- /*  1200 */   645,  746,  261,  695,  250,  390,  811,  266,  810,  267,
- /*  1210 */   272,  629,  154,  866,  615,  614,  616,  863,  135,  124,
- /*  1220 */   117,   64,  322,  825,  732,   55,  327,  230,  347,  187,
- /*  1230 */   147,  194,  144,  195,  126,  360,  196,  298,  643,  128,
- /*  1240 */   665,  129,  130,  131,  345,  282,  664,  139,  663,  375,
- /*  1250 */    63,    6,  742,   71,  842,  637,  302,  283,  636,  656,
- /*  1260 */    94,  249,  635,  875,  380,   65,  805,  655,  378,   21,
- /*  1270 */   864,  222,  607,  610,  309,  179,  819,  219,  279,  221,
- /*  1280 */   405,  406,  612,  611,  608,  311,  123,  817,  181,  393,
- /*  1290 */   741,  115,  397,  125,  120,  127,  186,  675,  116,  828,
- /*  1300 */   703,  133,  206,  132,  836,  898,  254,  326,  136,  134,
- /*  1310 */   105,  704,  256,  202,  702,   56,   57,   58,  258,  269,
- /*  1320 */   701,  260,  685,  268,  270,  271,   59,  839,  121,  835,
- /*  1330 */   791,  190,  192,   12,  209,  238,    8,  193,  148,  620,
- /*  1340 */   346,  197,  140,  210,  211,  251,  350,  355,  654,  204,
- /*  1350 */   118,   60,   13,  683,  245,   14,   61,   62,  170,  760,
- /*  1360 */   759,  789,   15,  385,  687,    4,  714,  368,  171,  173,
- /*  1370 */   205,  142,   69,  709,  166,   16,   66,   17,  804,  790,
- /*  1380 */   788,  793,  845,  214,  844,  386,  856,  150,  392,  275,
- /*  1390 */   857,  213,  151,  396,  792,  152,  604,  758,  627,   79,
- /*  1400 */  1155,  621,
+ /*  1100 */   627,   28,   28,  623,  623,  364,  680,  683,  683,  621,
+ /*  1110 */   161,  160,  159,  400,  287,  390,  394,  368,  398,  175,
+ /*  1120 */   174,  336,  720,  721,  627,   74,  883,   72,  688,  110,
+ /*  1130 */   261,  149,  291,  687,  300,  744,   20,  206,  331,  333,
+ /*  1140 */   206,  206,  109,  804,   64,   66,  650,  649,  109,  109,
+ /*  1150 */   348,  109,  212,  243,  821,   66,  821,  640,  640,  685,
+ /*  1160 */   714,   69,  206,    7,  812,  812,  337,   19,  734,  808,
+ /*  1170 */   625,  212,  106,  851,  756,  756,  318,  850,  153,  819,
+ /*  1180 */   288,  813,  225,  168,  233,  837,  839,  836,  335,  341,
+ /*  1190 */   342,  238,  353,  616,  241,  158,  661,  645,  246,  712,
+ /*  1200 */   644,  745,  260,  694,  249,  389,  810,  265,  809,  266,
+ /*  1210 */   271,  628,  154,  865,  614,  613,  615,  862,  135,  124,
+ /*  1220 */   117,   64,  321,  824,  731,   55,  326,  230,  346,  187,
+ /*  1230 */   147,  194,  144,  195,  126,  359,  196,  297,  642,  128,
+ /*  1240 */   664,  129,  130,  131,  344,  281,  663,  139,  662,  374,
+ /*  1250 */    63,    6,  741,   71,  841,  636,  301,  282,  635,  655,
+ /*  1260 */    94,  248,  634,  874,  379,   65,  654,   21,  377,  863,
+ /*  1270 */   222,  606,  609,  308,  179,  310,  123,  278,  219,  221,
+ /*  1280 */   404,  702,  405,  611,  392,  818,  610,  607,  816,  181,
+ /*  1290 */   115,  396,  740,  125,  120,  116,  127,  186,  674,  827,
+ /*  1300 */   253,  206,  132,  897,  105,  202,  133,  703,  835,  325,
+ /*  1310 */   255,  134,  136,  701,  700,   56,   57,  270,  257,  259,
+ /*  1320 */   684,  267,  268,  269,   58,   59,  121,  838,  190,  192,
+ /*  1330 */   790,  834,    8,  209,   12,  237,  619,  193,  148,  345,
+ /*  1340 */   197,  140,  210,  211,  250,  349,  354,  653,   60,   13,
+ /*  1350 */   204,  244,   14,   61,   62,  118,  682,  170,  759,  758,
+ /*  1360 */   788,   15,  205,  686,    4,  713,  367,  171,  173,  142,
+ /*  1370 */   708,   69,  384,   16,   66,  803,   17,  789,  385,  787,
+ /*  1380 */   792,  844,  843,  166,  391,  855,  150,  151,  213,  856,
+ /*  1390 */   274,  152,  395,  791,  757,  626,   79,  214,  620,  603,
+ /*  1400 */  1154,
 };
 static const YYCODETYPE yy_lookahead[] = {
  /*     0 */     5,    6,    7,    8,    9,   10,   11,   12,   13,   14,
@@ -667,24 +667,24 @@ static const YYCODETYPE yy_lookahead[] = {
  /*  1230 */   209,  148,   47,  148,  177,   84,  148,   63,   83,  180,
  /*  1240 */   162,  180,  180,  180,  165,  165,  162,  177,  162,  106,
  /*  1250 */    84,   47,  177,  121,  189,  162,   32,  165,  164,  170,
- /*  1260 */   112,  162,  162,  162,  107,  111,  189,  170,  110,   50,
- /*  1270 */    40,   35,    4,   36,    3,   42,   48,  144,  141,  144,
- /*  1280 */   150,  142,  142,  142,  142,   72,   43,   48,  101,  165,
- /*  1290 */    99,  153,  165,  114,   88,  102,   84,   46,  153,  127,
- /*  1300 */   204,   84,   50,  127,    1,  130,  203,  129,  114,  102,
- /*  1310 */   166,  204,  203,  166,  204,   16,   16,   16,  203,  191,
- /*  1320 */   204,  203,  193,  192,  190,  189,   16,   52,   88,    1,
- /*  1330 */   213,  105,  101,   47,  215,  124,   34,   84,   49,   46,
- /*  1340 */     7,   82,   47,  218,  218,   89,   66,   66,   54,   66,
- /*  1350 */    60,   47,   47,   95,   48,   47,   47,   50,  101,   48,
- /*  1360 */    48,   48,   47,   75,   48,   47,   52,   50,   48,   48,
- /*  1370 */   105,   47,   50,  104,   47,  105,   50,  105,   48,   48,
- /*  1380 */    48,   38,   48,  101,   48,   50,   48,   47,   49,   42,
- /*  1390 */    48,   50,   47,   49,   48,   47,    1,   48,   48,   47,
- /*  1400 */     0,   48,
+ /*  1260 */   112,  162,  162,  162,  107,  111,  170,   50,  110,   40,
+ /*  1270 */    35,    4,   36,    3,   42,   72,   43,  141,  144,  144,
+ /*  1280 */   150,  204,  142,  142,  165,   48,  142,  142,   48,  101,
+ /*  1290 */   153,  165,   99,  114,   88,  153,  102,   84,   46,  127,
+ /*  1300 */   203,   50,  127,  130,  166,  166,   84,  204,    1,  129,
+ /*  1310 */   203,  102,  114,  204,  204,   16,   16,  189,  203,  203,
+ /*  1320 */   193,  192,  191,  190,   16,   16,   88,   52,  105,  101,
+ /*  1330 */   213,    1,   34,  215,   47,  124,   46,   84,   49,    7,
+ /*  1340 */    82,   47,  218,  218,   89,   66,   66,   54,   47,   47,
+ /*  1350 */    66,   48,   47,   47,   50,   60,   95,  101,   48,   48,
+ /*  1360 */    48,   47,  105,   48,   47,   52,   50,   48,   48,   47,
+ /*  1370 */   104,   50,   75,  105,   50,   48,  105,   48,   50,   48,
+ /*  1380 */    38,   48,   48,   47,   49,   48,   47,   47,   50,   48,
+ /*  1390 */    42,   47,   49,   48,   48,   48,   47,  101,   48,    1,
+ /*  1400 */     0,
 };
-#define YY_SHIFT_USE_DFLT (1402)
-#define YY_SHIFT_COUNT    (408)
+#define YY_SHIFT_USE_DFLT (1401)
+#define YY_SHIFT_COUNT    (407)
 #define YY_SHIFT_MIN      (-82)
 #define YY_SHIFT_MAX      (1400)
 static const short yy_shift_ofst[] = {
@@ -699,11 +699,11 @@ static const short yy_shift_ofst[] = {
  /*    80 */   736,  736,  840,  736,  736,  736,  736,  736,  736,  736,
  /*    90 */   736,  736,  736,  736,  736,  736,   11,   30,   30,   30,
  /*   100 */    30,   30,  188,   37,   43,  661,  201,  201,  720,  695,
- /*   110 */   772,  -16, 1402, 1402, 1402,  645,  645,  633,  633,  826,
+ /*   110 */   772,  -16, 1401, 1401, 1401,  645,  645,  633,  633,  826,
  /*   120 */   221,  221,  858,  772,  317,  772,  772,  772,  772,  772,
  /*   130 */   772,  772,  772,  772,  772,  772,  772,  772,  772,  772,
  /*   140 */   772,  691,  772,  772,  772,  691,  695,  -82,  -82,  -82,
- /*   150 */   -82,  -82,  -82, 1402, 1402,  810,  242,  242,  285,  806,
+ /*   150 */   -82,  -82,  -82, 1401, 1401,  810,  242,  242,  285,  806,
  /*   160 */   806,  806,  119,  823,  668,  778,  868,  716,  911,  638,
  /*   170 */   996,  992,  992,  992,  853,  843, 1052, 1011,  637,  772,
  /*   180 */   772,  772,  772, 1031,  648,  648,  772,  772, 1114, 1031,
@@ -711,29 +711,29 @@ static const short yy_shift_ofst[] = {
  /*   200 */   593,  772,   36,  772, 1014,  772,  772,  648,  772, 1004,
  /*   210 */  1014, 1014,  772,  772,  772, 1076, 1033,  772, 1082,  772,
  /*   220 */   772,  772,  772, 1171, 1215, 1108, 1177, 1177, 1177, 1177,
- /*   230 */  1104, 1098, 1183, 1108, 1171, 1215, 1215, 1108, 1183, 1185,
- /*   240 */  1183, 1183, 1185, 1151, 1151, 1151, 1174, 1185, 1151, 1155,
- /*   250 */  1151, 1174, 1151, 1151, 1143, 1166, 1143, 1166, 1143, 1166,
- /*   260 */  1143, 1166, 1204, 1132, 1185, 1224, 1224, 1185, 1148, 1157,
- /*   270 */  1154, 1158, 1108, 1219, 1230, 1230, 1236, 1236, 1236, 1236,
- /*   280 */  1237, 1402, 1402, 1402, 1402,  152,  852, 1025, 1049, 1120,
- /*   290 */  1087, 1090, 1091, 1095, 1102, 1105, 1106, 1069,  725,  945,
- /*   300 */  1111, 1112, 1113, 1121,  723, 1039, 1122, 1123,  873, 1268,
- /*   310 */  1271, 1233, 1213, 1243, 1228, 1239, 1187, 1191, 1179, 1206,
- /*   320 */  1193, 1212, 1251, 1172, 1252, 1176, 1175, 1178, 1217, 1303,
- /*   330 */  1207, 1194, 1299, 1300, 1301, 1310, 1240, 1275, 1226, 1231,
- /*   340 */  1328, 1302, 1286, 1253, 1211, 1289, 1293, 1333, 1256, 1259,
- /*   350 */  1295, 1280, 1304, 1305, 1306, 1308, 1281, 1294, 1309, 1283,
- /*   360 */  1290, 1311, 1312, 1313, 1307, 1258, 1315, 1316, 1318, 1317,
- /*   370 */  1257, 1320, 1321, 1314, 1265, 1324, 1269, 1322, 1270, 1326,
- /*   380 */  1272, 1330, 1322, 1331, 1332, 1334, 1288, 1335, 1336, 1327,
- /*   390 */  1343, 1338, 1340, 1339, 1341, 1342, 1345, 1344, 1341, 1346,
- /*   400 */  1348, 1349, 1350, 1352, 1282, 1353, 1347, 1395, 1400,
+ /*   230 */  1104, 1098, 1183, 1108, 1171, 1215, 1215, 1183, 1185, 1183,
+ /*   240 */  1183, 1185, 1151, 1151, 1151, 1174, 1185, 1151, 1155, 1151,
+ /*   250 */  1174, 1151, 1151, 1143, 1166, 1143, 1166, 1143, 1166, 1143,
+ /*   260 */  1166, 1204, 1132, 1185, 1224, 1224, 1185, 1148, 1157, 1154,
+ /*   270 */  1158, 1108, 1217, 1229, 1229, 1235, 1235, 1235, 1235, 1236,
+ /*   280 */  1401, 1401, 1401, 1401,  152,  852, 1025, 1049, 1120, 1087,
+ /*   290 */  1090, 1091, 1095, 1102, 1105, 1106, 1069,  725,  945, 1111,
+ /*   300 */  1112, 1113, 1121,  723, 1039, 1122, 1123,  873, 1267, 1270,
+ /*   310 */  1232, 1203, 1233, 1237, 1240, 1188, 1193, 1179, 1206, 1194,
+ /*   320 */  1213, 1252, 1172, 1251, 1175, 1173, 1180, 1222, 1307, 1209,
+ /*   330 */  1198, 1299, 1300, 1308, 1309, 1238, 1275, 1223, 1228, 1330,
+ /*   340 */  1298, 1287, 1253, 1211, 1289, 1290, 1332, 1255, 1258, 1294,
+ /*   350 */  1279, 1301, 1302, 1303, 1305, 1280, 1293, 1306, 1284, 1295,
+ /*   360 */  1310, 1311, 1312, 1304, 1261, 1314, 1315, 1317, 1316, 1256,
+ /*   370 */  1319, 1320, 1313, 1257, 1322, 1266, 1321, 1268, 1324, 1271,
+ /*   380 */  1327, 1321, 1329, 1331, 1333, 1297, 1328, 1334, 1336, 1342,
+ /*   390 */  1337, 1339, 1335, 1338, 1341, 1340, 1343, 1338, 1345, 1344,
+ /*   400 */  1346, 1347, 1349, 1296, 1350, 1348, 1398, 1400,
 };
 #define YY_REDUCE_USE_DFLT (-69)
-#define YY_REDUCE_COUNT (284)
+#define YY_REDUCE_COUNT (283)
 #define YY_REDUCE_MIN   (-68)
-#define YY_REDUCE_MAX   (1147)
+#define YY_REDUCE_MAX   (1145)
 static const short yy_reduce_ofst[] = {
  /*     0 */   237,  503,  595,  124,  167,  440,  545,  604,  552,  397,
  /*    10 */   158,  547,  487,  624,  652,  646,  673,  684,  682,  456,
@@ -758,55 +758,55 @@ static const short yy_reduce_ofst[] = {
  /*   200 */  1023, 1054, 1032, 1055, 1041, 1056, 1058, 1000, 1060,  989,
  /*   210 */  1043, 1045, 1064, 1066,  877, 1022, 1026, 1068, 1067, 1071,
  /*   220 */  1072, 1073, 1074, 1010, 1057, 1035, 1059, 1061, 1062, 1063,
- /*   230 */   998, 1003, 1081, 1065, 1021, 1070, 1075, 1077, 1083, 1079,
- /*   240 */  1085, 1088, 1080, 1078, 1084, 1086, 1089, 1092, 1093, 1094,
- /*   250 */  1099, 1097, 1100, 1101, 1096, 1103, 1107, 1109, 1110, 1115,
- /*   260 */  1116, 1118, 1117, 1119, 1124, 1125, 1126, 1127, 1129, 1131,
- /*   270 */  1128, 1134, 1136, 1130, 1133, 1135, 1139, 1140, 1141, 1142,
- /*   280 */  1137, 1138, 1144, 1147, 1145,
+ /*   230 */   998, 1003, 1081, 1065, 1021, 1070, 1075, 1083, 1079, 1085,
+ /*   240 */  1088, 1080, 1078, 1084, 1086, 1089, 1092, 1093, 1094, 1099,
+ /*   250 */  1096, 1100, 1101, 1077, 1097, 1103, 1107, 1109, 1115, 1110,
+ /*   260 */  1116, 1117, 1118, 1119, 1124, 1125, 1126, 1127, 1129, 1131,
+ /*   270 */  1133, 1128, 1130, 1134, 1135, 1140, 1141, 1144, 1145, 1136,
+ /*   280 */  1137, 1138, 1139, 1142,
 };
 static const YYACTIONTYPE yy_default[] = {
- /*     0 */  1156, 1150, 1150, 1150, 1097, 1097, 1097, 1097, 1150,  993,
- /*    10 */  1020, 1020, 1198, 1198, 1198, 1198, 1198, 1198, 1096, 1198,
- /*    20 */  1198, 1198, 1198, 1150,  997, 1026, 1198, 1198, 1198, 1098,
- /*    30 */  1099, 1198, 1198, 1198, 1131, 1036, 1035, 1034, 1033, 1007,
- /*    40 */  1031, 1024, 1028, 1098, 1092, 1093, 1091, 1095, 1099, 1198,
- /*    50 */  1027, 1061, 1076, 1060, 1198, 1198, 1198, 1198, 1198, 1198,
- /*    60 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
- /*    70 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
- /*    80 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
- /*    90 */  1198, 1198, 1198, 1198, 1198, 1198, 1070, 1075, 1082, 1074,
- /*   100 */  1071, 1063, 1062, 1064, 1065,  964, 1198, 1198, 1066, 1198,
- /*   110 */  1198, 1067, 1079, 1078, 1077, 1165, 1164, 1198, 1198, 1104,
- /*   120 */  1198, 1198, 1198, 1198, 1150, 1198, 1198, 1198, 1198, 1198,
- /*   130 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
- /*   140 */  1198,  922, 1198, 1198, 1198,  922, 1198, 1150, 1150, 1150,
- /*   150 */  1150, 1150, 1150,  997,  988, 1198, 1198, 1198, 1198, 1198,
- /*   160 */  1198, 1198, 1198,  993, 1198, 1198, 1198, 1198, 1126, 1198,
- /*   170 */  1198,  993,  993,  993, 1198,  995, 1198,  977,  987, 1198,
- /*   180 */  1147, 1198, 1118, 1030, 1009, 1009, 1198, 1198, 1197, 1030,
- /*   190 */  1198, 1197, 1198, 1198, 1198, 1198, 1198, 1198,  939, 1198,
- /*   200 */  1176, 1198,  936, 1198, 1020, 1198, 1198, 1009, 1198, 1094,
- /*   210 */  1020, 1020, 1198, 1198, 1198,  994,  987, 1198, 1198, 1198,
- /*   220 */  1198, 1198, 1159, 1041,  967, 1030,  973,  973,  973,  973,
- /*   230 */  1130, 1194,  916, 1030, 1041,  967,  967, 1030,  916, 1105,
- /*   240 */   916,  916, 1105,  965,  965,  965,  954, 1105,  965,  939,
- /*   250 */   965,  954,  965,  965, 1013, 1008, 1013, 1008, 1013, 1008,
- /*   260 */  1013, 1008, 1100, 1198, 1105, 1109, 1109, 1105, 1025, 1014,
- /*   270 */  1023, 1021, 1030,  957, 1162, 1162, 1158, 1158, 1158, 1158,
- /*   280 */   906, 1171,  941,  941, 1171, 1198, 1198, 1198, 1166, 1112,
- /*   290 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
- /*   300 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1047, 1198,
- /*   310 */   903, 1198, 1198, 1198, 1198, 1198, 1189, 1198, 1198, 1198,
- /*   320 */  1198, 1198, 1198, 1198, 1129, 1128, 1198, 1198, 1198, 1198,
- /*   330 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1196,
- /*   340 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
- /*   350 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
- /*   360 */  1198, 1198, 1198, 1198, 1198,  979, 1198, 1198, 1198, 1180,
- /*   370 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1022, 1198, 1015,
- /*   380 */  1198, 1198, 1186, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
- /*   390 */  1198, 1198, 1198, 1198, 1152, 1198, 1198, 1198, 1151, 1198,
- /*   400 */  1198, 1198, 1198, 1198, 1198, 1198,  910, 1198, 1198,
+ /*     0 */  1155, 1149, 1149, 1149, 1096, 1096, 1096, 1096, 1149,  992,
+ /*    10 */  1019, 1019, 1197, 1197, 1197, 1197, 1197, 1197, 1095, 1197,
+ /*    20 */  1197, 1197, 1197, 1149,  996, 1025, 1197, 1197, 1197, 1097,
+ /*    30 */  1098, 1197, 1197, 1197, 1130, 1035, 1034, 1033, 1032, 1006,
+ /*    40 */  1030, 1023, 1027, 1097, 1091, 1092, 1090, 1094, 1098, 1197,
+ /*    50 */  1026, 1060, 1075, 1059, 1197, 1197, 1197, 1197, 1197, 1197,
+ /*    60 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
+ /*    70 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
+ /*    80 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
+ /*    90 */  1197, 1197, 1197, 1197, 1197, 1197, 1069, 1074, 1081, 1073,
+ /*   100 */  1070, 1062, 1061, 1063, 1064,  963, 1197, 1197, 1065, 1197,
+ /*   110 */  1197, 1066, 1078, 1077, 1076, 1164, 1163, 1197, 1197, 1103,
+ /*   120 */  1197, 1197, 1197, 1197, 1149, 1197, 1197, 1197, 1197, 1197,
+ /*   130 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
+ /*   140 */  1197,  921, 1197, 1197, 1197,  921, 1197, 1149, 1149, 1149,
+ /*   150 */  1149, 1149, 1149,  996,  987, 1197, 1197, 1197, 1197, 1197,
+ /*   160 */  1197, 1197, 1197,  992, 1197, 1197, 1197, 1197, 1125, 1197,
+ /*   170 */  1197,  992,  992,  992, 1197,  994, 1197,  976,  986, 1197,
+ /*   180 */  1146, 1197, 1117, 1029, 1008, 1008, 1197, 1197, 1196, 1029,
+ /*   190 */  1197, 1196, 1197, 1197, 1197, 1197, 1197, 1197,  938, 1197,
+ /*   200 */  1175, 1197,  935, 1197, 1019, 1197, 1197, 1008, 1197, 1093,
+ /*   210 */  1019, 1019, 1197, 1197, 1197,  993,  986, 1197, 1197, 1197,
+ /*   220 */  1197, 1197, 1158, 1040,  966, 1029,  972,  972,  972,  972,
+ /*   230 */  1129, 1193,  915, 1029, 1040,  966,  966,  915, 1104,  915,
+ /*   240 */   915, 1104,  964,  964,  964,  953, 1104,  964,  938,  964,
+ /*   250 */   953,  964,  964, 1012, 1007, 1012, 1007, 1012, 1007, 1012,
+ /*   260 */  1007, 1099, 1197, 1104, 1108, 1108, 1104, 1024, 1013, 1022,
+ /*   270 */  1020, 1029,  956, 1161, 1161, 1157, 1157, 1157, 1157,  905,
+ /*   280 */  1170,  940,  940, 1170, 1197, 1197, 1197, 1165, 1111, 1197,
+ /*   290 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
+ /*   300 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1046, 1197,  902,
+ /*   310 */  1197, 1197, 1197, 1197, 1197, 1188, 1197, 1197, 1197, 1197,
+ /*   320 */  1197, 1197, 1197, 1128, 1127, 1197, 1197, 1197, 1197, 1197,
+ /*   330 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1195, 1197,
+ /*   340 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
+ /*   350 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
+ /*   360 */  1197, 1197, 1197, 1197,  978, 1197, 1197, 1197, 1179, 1197,
+ /*   370 */  1197, 1197, 1197, 1197, 1197, 1197, 1021, 1197, 1014, 1197,
+ /*   380 */  1197, 1185, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
+ /*   390 */  1197, 1197, 1197, 1151, 1197, 1197, 1197, 1150, 1197, 1197,
+ /*   400 */  1197, 1197, 1197, 1197, 1197,  909, 1197, 1197,
 };
 /********** End of lemon-generated parsing tables *****************************/
 
@@ -1252,7 +1252,7 @@ static const char *const yyRuleName[] = {
  /* 198 */ "nexprlist ::= expr",
  /* 199 */ "paren_exprlist ::=",
  /* 200 */ "paren_exprlist ::= LP exprlist RP",
- /* 201 */ "cmd ::= createkw uniqueflag INDEX ifnotexists nm ON nm LP sortlist RP where_opt",
+ /* 201 */ "cmd ::= createkw uniqueflag INDEX ifnotexists nm ON nm LP sortlist RP",
  /* 202 */ "uniqueflag ::= UNIQUE",
  /* 203 */ "uniqueflag ::=",
  /* 204 */ "eidlist_opt ::=",
@@ -1995,7 +1995,7 @@ static const struct {
   { 195, 1 },
   { 213, 0 },
   { 213, 3 },
-  { 140, 11 },
+  { 140, 10 },
   { 217, 1 },
   { 217, 0 },
   { 165, 0 },
@@ -3400,12 +3400,12 @@ static void yy_reduce(
 {yymsp[-2].minor.yy382 = yymsp[-1].minor.yy382;}
 #line 3402 "parse.c"
         break;
-      case 201: /* cmd ::= createkw uniqueflag INDEX ifnotexists nm ON nm LP sortlist RP where_opt */
+      case 201: /* cmd ::= createkw uniqueflag INDEX ifnotexists nm ON nm LP sortlist RP */
 #line 1244 "parse.y"
 {
-  sqlite3CreateIndex(pParse, &yymsp[-6].minor.yy0, 
-                     sqlite3SrcListAppend(pParse->db,0,&yymsp[-4].minor.yy0), yymsp[-2].minor.yy382, yymsp[-9].minor.yy52,
-                      &yymsp[-10].minor.yy0, yymsp[0].minor.yy362, SQLITE_SO_ASC, yymsp[-7].minor.yy52, SQLITE_IDXTYPE_APPDEF);
+  sqlite3CreateIndex(pParse, &yymsp[-5].minor.yy0, 
+                     sqlite3SrcListAppend(pParse->db,0,&yymsp[-3].minor.yy0), yymsp[-1].minor.yy382, yymsp[-8].minor.yy52,
+                      &yymsp[-9].minor.yy0, 0, SQLITE_SO_ASC, yymsp[-6].minor.yy52, SQLITE_IDXTYPE_APPDEF);
 }
 #line 3411 "parse.c"
         break;
diff --git a/src/box/sql/parse.y b/src/box/sql/parse.y
index b078e20..e0b5a2e 100644
--- a/src/box/sql/parse.y
+++ b/src/box/sql/parse.y
@@ -1241,10 +1241,10 @@ paren_exprlist(A) ::= LP exprlist(X) RP.  {A = X;}
 ///////////////////////////// The CREATE INDEX command ///////////////////////
 //
 cmd ::= createkw(S) uniqueflag(U) INDEX ifnotexists(NE) nm(X)
-        ON nm(Y) LP sortlist(Z) RP where_opt(W). {
+        ON nm(Y) LP sortlist(Z) RP. {
   sqlite3CreateIndex(pParse, &X, 
                      sqlite3SrcListAppend(pParse->db,0,&Y), Z, U,
-                      &S, W, SQLITE_SO_ASC, NE, SQLITE_IDXTYPE_APPDEF);
+                      &S, 0, SQLITE_SO_ASC, NE, SQLITE_IDXTYPE_APPDEF);
 }
 
 %type uniqueflag {int}
diff --git a/test/sql-tap/analyze9.test.lua b/test/sql-tap/analyze9.test.lua
index 4ce575e..3668211 100755
--- a/test/sql-tap/analyze9.test.lua
+++ b/test/sql-tap/analyze9.test.lua
@@ -1111,7 +1111,7 @@ test:do_test(
         test:execsql([[
             DROP TABLE IF EXISTS t1;
             CREATE TABLE t1(id INTEGER PRIMARY KEY AUTOINCREMENT, a, b, c, d);
-            CREATE INDEX i1 ON t1(a, b) WHERE d IS NOT NULL;
+            CREATE INDEX i1 ON t1(a, b);
             INSERT INTO t1 VALUES(null, -1, -1, -1, NULL);
             INSERT INTO t1 SELECT null, 2*a,2*b,2*c,d FROM t1;
             INSERT INTO t1 SELECT null, 2*a,2*b,2*c,d FROM t1;
diff --git a/test/sql-tap/autoindex4.test.lua b/test/sql-tap/autoindex4.test.lua
index 45bae48..a567c5e 100755
--- a/test/sql-tap/autoindex4.test.lua
+++ b/test/sql-tap/autoindex4.test.lua
@@ -111,7 +111,7 @@ test:do_execsql_test(
 test:do_execsql_test(
     "autoindex4-3.1",
     [[
-        CREATE INDEX Items_x1 ON Items(ItemName,Name) WHERE ItemName = 'dummy';
+        CREATE INDEX Items_x1 ON Items(ItemName,Name);
 
         SELECT Items.ItemName
           FROM Items
diff --git a/test/sql-tap/fkey1.test.lua b/test/sql-tap/fkey1.test.lua
index 8749e1f..bca82d9 100755
--- a/test/sql-tap/fkey1.test.lua
+++ b/test/sql-tap/fkey1.test.lua
@@ -212,7 +212,7 @@ test:do_execsql_test(
     "fkey1-6.1",
     [[
         CREATE TABLE p1(id PRIMARY KEY, x, y);
-        CREATE UNIQUE INDEX p1x ON p1(x) WHERE y<2;
+        CREATE INDEX p1x ON p1(x);
         INSERT INTO p1 VALUES(1, 1, 1);
         CREATE TABLE c1(a PRIMARY KEY REFERENCES p1(x));
     ]], {
diff --git a/test/sql-tap/gh-2165-remove-support-partial-indexes.test.lua b/test/sql-tap/gh-2165-remove-support-partial-indexes.test.lua
new file mode 100644
index 0000000..d8210fc
--- /dev/null
+++ b/test/sql-tap/gh-2165-remove-support-partial-indexes.test.lua
@@ -0,0 +1,17 @@
+#!/usr/bin/env tarantool
+test = require("sqltester")
+
+test:plan(1)
+
+
+test:do_catchsql_test(
+    "partial-index-1",
+    [[
+        CREATE TABLE t1 (a INTEGER PRIMARY KEY, b INTEGER)
+        CREATE UNIQUE INDEX i ON t1 (a) WHERE a = 3;
+    ]], {
+        1, "keyword \"CREATE\" is reserved"
+    })
+
+--This test intended to be deleted in #2626
+test:finish_test()
diff --git a/test/sql-tap/index6.test.lua b/test/sql-tap/index6.test.lua
index 2aa97e8..069623f 100755
--- a/test/sql-tap/index6.test.lua
+++ b/test/sql-tap/index6.test.lua
@@ -225,7 +225,7 @@ test:do_execsql_test(
     "index6-6.0",
     [[
         CREATE TABLE t6(a,b, PRIMARY KEY (a,b));
-        CREATE INDEX t6b ON t6(b) WHERE b=1;
+        CREATE INDEX t6b ON t6(b);
         INSERT INTO t6(a,b) VALUES(123,456);
         SELECT * FROM t6;
     ]], {
@@ -262,7 +262,7 @@ test:do_execsql_test(
         CREATE TABLE t7a(id primary key, x);
         CREATE TABLE t7b(id primary key, y);
         INSERT INTO t7a VALUES(1, 1);
-        CREATE INDEX t7ax ON t7a(x) WHERE x=99;
+        CREATE INDEX t7ax ON t7a(x);
         SELECT x,y FROM t7a LEFT JOIN t7b ON (x=99) ORDER BY x;
     ]], {
         -- <index6-7.0>
@@ -318,7 +318,7 @@ test:do_execsql_test(
     [[
         CREATE TABLE t8a(id primary key, a,b);
         CREATE TABLE t8b(id primary key, x,y);
-        CREATE INDEX i8c ON t8b(y) WHERE x = 'value';
+        CREATE INDEX i8c ON t8b(y);
 
         INSERT INTO t8a VALUES(1, 1, 'one');
         INSERT INTO t8a VALUES(2, 2, 'two');
@@ -364,7 +364,7 @@ if (0 > 0)
         "index6-9.1",
         [[
             CREATE TABLE t9(a int, b int, c int);
-            CREATE INDEX t9ca ON t9(c,a) WHERE a in (10,12,20);
+            CREATE INDEX t9ca ON t9(c,a);
             INSERT INTO t9 VALUES(1,1,9),(10,2,35),(11,15,82),(20,19,5),(NULL,7,3);
             UPDATE t9 SET b=c WHERE a in (10,12,20);
             SELECT a,b,c,'|' FROM t9 ORDER BY a;
@@ -379,7 +379,7 @@ test:do_execsql_test(
     [[
         --DROP TABLE t9;
         CREATE TABLE t9(a int, b int, c int, PRIMARY KEY(a));
-        CREATE INDEX t9ca ON t9(c,a) WHERE a in (10,12,20);
+        CREATE INDEX t9ca ON t9(c,a);
         INSERT INTO t9 VALUES(1,1,9),(10,2,35),(11,15,82),(20,19,5);
         UPDATE t9 SET b=c WHERE a in (10,12,20);
         SELECT a,b,c,'|' FROM t9 ORDER BY a;
@@ -400,7 +400,7 @@ test:do_execsql_test(
           (2,3,4,5,6),
           (3,4,5,6,7),
           (1,2,3,8,9);
-        CREATE INDEX t10x ON t10(d) WHERE a=1 AND b=2 AND c=3;
+        CREATE INDEX t10x ON t10(d);
         SELECT e FROM t10 WHERE a=1 AND b=2 AND c=3 ORDER BY d;
     ]], {
         -- <index6-10.1>
diff --git a/test/sql-tap/index7.test.lua b/test/sql-tap/index7.test.lua
index c8f56eb..c194859 100755
--- a/test/sql-tap/index7.test.lua
+++ b/test/sql-tap/index7.test.lua
@@ -1,6 +1,6 @@
 #!/usr/bin/env tarantool
 test = require("sqltester")
-test:plan(5)
+test:plan(4)
 
 --!./tcltestrunner.lua
 -- 2013-11-04
@@ -261,7 +261,7 @@ test:do_execsql_test(
 test:do_execsql_test(
     "index7-6.2",
     [[
-        CREATE INDEX i4 ON t4(c) WHERE d='xyz';
+        CREATE INDEX i4 ON t4(c);
         SELECT a,b,c,d FROM (SELECT a,b FROM t5 WHERE a=1 AND b='xyz'), t4 WHERE c='abc';
     ]], {
         -- <index7-6.2>
@@ -291,14 +291,15 @@ test:do_eqp_test(
         -- </index7-6.4>
     })
 
-test:do_catchsql_test(
-    "index7-6.5",
-    [[
-        CREATE INDEX t5a ON t5(a) WHERE a=#1;
-    ]], {
-        -- <index7-6.5>
-        1, [[near "#1": syntax error]]
-        -- </index7-6.5>
-    })
-
+--test:do_catchsql_test(
+--    "index7-6.5",
+--    [[
+--        CREATE INDEX t5a ON t5(a) WHERE a=#1;
+--    ]], {
+--        -- <index7-6.5>
+--        1, [[near "#1": syntax error]]
+--        -- </index7-6.5>
+--    })
+-- this test checks incorrect syntax of partial indexes
+-- to be enabled after #2626
 test:finish_test()
-- 
2.7.4

^ permalink raw reply	[flat|nested] 3+ messages in thread

* [tarantool-patches] Re: [tarantool-patches] [PATCH v2] sql: remove support of partial indexes
  2018-04-18 20:03 [tarantool-patches] [PATCH v2] sql: remove support of partial indexes Gleb
@ 2018-04-23 17:30 ` GLEB SKIBA
  0 siblings, 0 replies; 3+ messages in thread
From: GLEB SKIBA @ 2018-04-23 17:30 UTC (permalink / raw)
  To: tarantool-patches

[-- Attachment #1: Type: text/plain, Size: 47336 bytes --]

Please see a new patch.


>Среда, 18 апреля 2018, 23:03 +03:00 от Gleb <dmarc-noreply@freelists.org>:
>
>Remove support partial indexes.
>Add test which checks inaccessibility of partial index syntax.
>Delete use partial index from tests.
>They can be enabled after #2626.
>
>Fixes #2165
>---
>Issue from  https://github.com/tarantool/tarantool/issues/2165 .
>Source from  https://github.com/tarantool/tarantool/tree/gh-2165-remove-support-partial-indexes .
>Changes in v2:
> -return tests which use partial.
> -delete "WHERE" from returned tests.
>
> src/box/sql/parse.c                                | 472 ++++++++++-----------
> src/box/sql/parse.y                                |   4 +-
> test/sql-tap/analyze9.test.lua                     |   2 +-
> test/sql-tap/autoindex4.test.lua                   |   2 +-
> test/sql-tap/fkey1.test.lua                        |   2 +-
> ...gh-2165-remove-support-partial-indexes.test.lua |  17 +
> test/sql-tap/index6.test.lua                       |  12 +-
> test/sql-tap/index7.test.lua                       |  25 +-
> 8 files changed, 277 insertions(+), 259 deletions(-)
> create mode 100644 test/sql-tap/gh-2165-remove-support-partial-indexes.test.lua
>
>diff --git a/src/box/sql/parse.c b/src/box/sql/parse.c
>index 5c0f0ea..f5612d4 100644
>--- a/src/box/sql/parse.c
>+++ b/src/box/sql/parse.c
>@@ -315,16 +315,16 @@ typedef union {
> #define sqlite3ParserARG_FETCH Parse *pParse = yypParser->pParse
> #define sqlite3ParserARG_STORE yypParser->pParse = pParse
> #define YYFALLBACK 1
>-#define YYNSTATE             409
>+#define YYNSTATE             408
> #define YYNRULE              297
>-#define YY_MAX_SHIFT         408
>-#define YY_MIN_SHIFTREDUCE   604
>-#define YY_MAX_SHIFTREDUCE   900
>-#define YY_MIN_REDUCE        901
>-#define YY_MAX_REDUCE        1197
>-#define YY_ERROR_ACTION      1198
>-#define YY_ACCEPT_ACTION     1199
>-#define YY_NO_ACTION         1200
>+#define YY_MAX_SHIFT         407
>+#define YY_MIN_SHIFTREDUCE   603
>+#define YY_MAX_SHIFTREDUCE   899
>+#define YY_MIN_REDUCE        900
>+#define YY_MAX_REDUCE        1196
>+#define YY_ERROR_ACTION      1197
>+#define YY_ACCEPT_ACTION     1198
>+#define YY_NO_ACTION         1199
> /************* End control #defines *******************************************/
> 
> /* Define the yytestcase() macro to be a no-op if is not already defined
>@@ -396,149 +396,149 @@ typedef union {
> **  yy_default[]       Default action for each state.
> **
> *********** Begin parsing tables **********************************************/
>-#define YY_ACTTAB_COUNT (1402)
>+#define YY_ACTTAB_COUNT (1401)
> static const YYACTIONTYPE yy_action[] = {
>- /*     0 */    91,   92,  285,   82,  771,  771,  783,  786,  775,  775,
>- /*    10 */    89,   89,   90,   90,   90,   90,  307,   88,   88,   88,
>- /*    20 */    88,   87,   87,   86,   86,   86,   85,  307,   90,   90,
>+ /*     0 */    91,   92,  284,   82,  770,  770,  782,  785,  774,  774,
>+ /*    10 */    89,   89,   90,   90,   90,   90,  306,   88,   88,   88,
>+ /*    20 */    88,   87,   87,   86,   86,   86,   85,  306,   90,   90,
>  /*    30 */    90,   90,   83,   88,   88,   88,   88,   87,   87,   86,
>- /*    40 */    86,   86,   85,  307,  208,  201,  885,   90,   90,   90,
>+ /*    40 */    86,   86,   85,  306,  208,  201,  884,   90,   90,   90,
>  /*    50 */    90,  122,   88,   88,   88,   88,   87,   87,   86,   86,
>- /*    60 */    86,   85,  307,   87,   87,   86,   86,   86,   85,  307,
>- /*    70 */   885,   86,   86,   86,   85,  307,   91,   92,  285,   82,
>- /*    80 */   771,  771,  783,  786,  775,  775,   89,   89,   90,   90,
>- /*    90 */    90,   90,  630,   88,   88,   88,   88,   87,   87,   86,
>- /*   100 */    86,   86,   85,  307,   91,   92,  285,   82,  771,  771,
>- /*   110 */   783,  786,  775,  775,   89,   89,   90,   90,   90,   90,
>- /*   120 */   287,   88,   88,   88,   88,   87,   87,   86,   86,   86,
>- /*   130 */    85,  307,  705,   91,   92,  285,   82,  771,  771,  783,
>- /*   140 */   786,  775,  775,   89,   89,   90,   90,   90,   90,   67,
>+ /*    60 */    86,   85,  306,   87,   87,   86,   86,   86,   85,  306,
>+ /*    70 */   884,   86,   86,   86,   85,  306,   91,   92,  284,   82,
>+ /*    80 */   770,  770,  782,  785,  774,  774,   89,   89,   90,   90,
>+ /*    90 */    90,   90,  629,   88,   88,   88,   88,   87,   87,   86,
>+ /*   100 */    86,   86,   85,  306,   91,   92,  284,   82,  770,  770,
>+ /*   110 */   782,  785,  774,  774,   89,   89,   90,   90,   90,   90,
>+ /*   120 */   286,   88,   88,   88,   88,   87,   87,   86,   86,   86,
>+ /*   130 */    85,  306,  704,   91,   92,  284,   82,  770,  770,  782,
>+ /*   140 */   785,  774,  774,   89,   89,   90,   90,   90,   90,   67,
>  /*   150 */    88,   88,   88,   88,   87,   87,   86,   86,   86,   85,
>- /*   160 */   307,  772,  772,  784,  787,  740,   93,  172,  280,  706,
>- /*   170 */   312,  278,  277,  276,  220,  274,  243,  633,  618,  721,
>- /*   180 */   722,  632,   91,   92,  285,   82,  771,  771,  783,  786,
>- /*   190 */   775,  775,   89,   89,   90,   90,   90,   90,  109,   88,
>- /*   200 */    88,   88,   88,   87,   87,   86,   86,   86,   85,  307,
>+ /*   160 */   306,  771,  771,  783,  786,  739,   93,  172,  279,  705,
>+ /*   170 */   311,  277,  276,  275,  220,  273,  242,  632,  617,  720,
>+ /*   180 */   721,  631,   91,   92,  284,   82,  770,  770,  782,  785,
>+ /*   190 */   774,  774,   89,   89,   90,   90,   90,   90,  109,   88,
>+ /*   200 */    88,   88,   88,   87,   87,   86,   86,   86,   85,  306,
>  /*   210 */    88,   88,   88,   88,   87,   87,   86,   86,   86,   85,
>- /*   220 */   307,  344,  165,  706,  341,  638,  286,  305,  304,  824,
>- /*   230 */   776,   91,   92,  285,   82,  771,  771,  783,  786,  775,
>- /*   240 */   775,   89,   89,   90,   90,   90,   90,  333,   88,   88,
>- /*   250 */    88,   88,   87,   87,   86,   86,   86,   85,  307,  182,
>- /*   260 */   743,  666,  645,  407,  407,  180,  313,  122,  137,  218,
>- /*   270 */   666,  119,  624,  624,  631,  679,  236,  330,  235,  877,
>- /*   280 */    91,   92,  285,   82,  771,  771,  783,  786,  775,  775,
>- /*   290 */    89,   89,   90,   90,   90,   90,  743,   88,   88,   88,
>- /*   300 */    88,   87,   87,   86,   86,   86,   85,  307,   22,  215,
>- /*   310 */   404,  183,  236,  320,  224,  761,  896,  754,  896,   54,
>- /*   320 */   749,  720,  705,  762,  122,  216,  366,   48,   48,   91,
>- /*   330 */    92,  285,   82,  771,  771,  783,  786,  775,  775,   89,
>- /*   340 */    89,   90,   90,   90,   90,  265,   88,   88,   88,   88,
>- /*   350 */    87,   87,   86,   86,   86,   85,  307,  753,  753,  755,
>- /*   360 */   223,  199,  382,  367,  356,  353,  352,  649,   84,   81,
>- /*   370 */   176,  699,  748, 1199,  408,    3,  351,  294,   91,   92,
>- /*   380 */   285,   82,  771,  771,  783,  786,  775,  775,   89,   89,
>- /*   390 */    90,   90,   90,   90,  317,   88,   88,   88,   88,   87,
>- /*   400 */    87,   86,   86,   86,   85,  307,   91,   92,  285,   82,
>- /*   410 */   771,  771,  783,  786,  775,  775,   89,   89,   90,   90,
>- /*   420 */    90,   90,  648,   88,   88,   88,   88,   87,   87,   86,
>- /*   430 */    86,   86,   85,  307,   91,   92,  285,   82,  771,  771,
>- /*   440 */   783,  786,  775,  775,   89,   89,   90,   90,   90,   90,
>+ /*   220 */   306,  343,  165,  705,  340,  637,  285,  304,  303,  823,
>+ /*   230 */   775,   91,   92,  284,   82,  770,  770,  782,  785,  774,
>+ /*   240 */   774,   89,   89,   90,   90,   90,   90,  332,   88,   88,
>+ /*   250 */    88,   88,   87,   87,   86,   86,   86,   85,  306,  182,
>+ /*   260 */   742,  665,  644,  406,  406,  180,  312,  122,  137,  218,
>+ /*   270 */   665,  119,  623,  623,  630,  678,  236,  329,  235,  876,
>+ /*   280 */    91,   92,  284,   82,  770,  770,  782,  785,  774,  774,
>+ /*   290 */    89,   89,   90,   90,   90,   90,  742,   88,   88,   88,
>+ /*   300 */    88,   87,   87,   86,   86,   86,   85,  306,   22,  215,
>+ /*   310 */   403,  183,  236,  319,  224,  760,  895,  753,  895,   54,
>+ /*   320 */   748,  719,  704,  761,  122,  216,  365,   48,   48,   91,
>+ /*   330 */    92,  284,   82,  770,  770,  782,  785,  774,  774,   89,
>+ /*   340 */    89,   90,   90,   90,   90,  264,   88,   88,   88,   88,
>+ /*   350 */    87,   87,   86,   86,   86,   85,  306,  752,  752,  754,
>+ /*   360 */   223,  199,  381,  366,  355,  352,  351,  648,   84,   81,
>+ /*   370 */   176,  698,  747, 1198,  407,    3,  350,  293,   91,   92,
>+ /*   380 */   284,   82,  770,  770,  782,  785,  774,  774,   89,   89,
>+ /*   390 */    90,   90,   90,   90,  316,   88,   88,   88,   88,   87,
>+ /*   400 */    87,   86,   86,   86,   85,  306,   91,   92,  284,   82,
>+ /*   410 */   770,  770,  782,  785,  774,  774,   89,   89,   90,   90,
>+ /*   420 */    90,   90,  647,   88,   88,   88,   88,   87,   87,   86,
>+ /*   430 */    86,   86,   85,  306,   91,   92,  284,   82,  770,  770,
>+ /*   440 */   782,  785,  774,  774,   89,   89,   90,   90,   90,   90,
>  /*   450 */   122,   88,   88,   88,   88,   87,   87,   86,   86,   86,
>- /*   460 */    85,  307,   91,   92,  285,   82,  771,  771,  783,  786,
>- /*   470 */   775,  775,   89,   89,   90,   90,   90,   90,  145,   88,
>- /*   480 */    88,   88,   88,   87,   87,   86,   86,   86,   85,  307,
>- /*   490 */  1150, 1150,   84,   81,  176,   70,   92,  285,   82,  771,
>- /*   500 */   771,  783,  786,  775,  775,   89,   89,   90,   90,   90,
>- /*   510 */    90,  647,   88,   88,   88,   88,   87,   87,   86,   86,
>- /*   520 */    86,   85,  307,   73,  207,  122,  402,  402,  402,   91,
>- /*   530 */    80,  285,   82,  771,  771,  783,  786,  775,  775,   89,
>- /*   540 */    89,   90,   90,   90,   90,  376,   88,   88,   88,   88,
>- /*   550 */    87,   87,   86,   86,   86,   85,  307,  285,   82,  771,
>- /*   560 */   771,  783,  786,  775,  775,   89,   89,   90,   90,   90,
>+ /*   460 */    85,  306,   91,   92,  284,   82,  770,  770,  782,  785,
>+ /*   470 */   774,  774,   89,   89,   90,   90,   90,   90,  145,   88,
>+ /*   480 */    88,   88,   88,   87,   87,   86,   86,   86,   85,  306,
>+ /*   490 */  1149, 1149,   84,   81,  176,   70,   92,  284,   82,  770,
>+ /*   500 */   770,  782,  785,  774,  774,   89,   89,   90,   90,   90,
>+ /*   510 */    90,  646,   88,   88,   88,   88,   87,   87,   86,   86,
>+ /*   520 */    86,   85,  306,   73,  207,  122,  401,  401,  401,   91,
>+ /*   530 */    80,  284,   82,  770,  770,  782,  785,  774,  774,   89,
>+ /*   540 */    89,   90,   90,   90,   90,  375,   88,   88,   88,   88,
>+ /*   550 */    87,   87,   86,   86,   86,   85,  306,  284,   82,  770,
>+ /*   560 */   770,  782,  785,  774,  774,   89,   89,   90,   90,   90,
>  /*   570 */    90,   78,   88,   88,   88,   88,   87,   87,   86,   86,
>- /*   580 */    86,   85,  307,  404,  306,  306,  306,  605,  310,  141,
>- /*   590 */    75,   76,  264,  624,  624,  692,  873,   77,  284,  315,
>- /*   600 */    48,   48,  305,  304,  640,   78,  265,   84,   81,  176,
>- /*   610 */   400,    2, 1097,  315,  314,  308,  308,  200,  199,  200,
>- /*   620 */   141,  356,  353,  352,   75,   76,  273,  624,  624,  281,
>- /*   630 */   404,   77,  389,  351,  387,  382,  372,  761,  303,  754,
>- /*   640 */   743, 1173,  749,  661,  400,    2,  404,   10,   10,  308,
>- /*   650 */   308,  891,  299,  895,  383,  373,  236,  330,  235,  371,
>- /*   660 */   893,  293,  894,   48,   48,  361,  389,  751,  348,  333,
>- /*   670 */   201,  761,  846,  754,  705,  315,  749,  296,  398,  753,
>- /*   680 */   753,  755,  756,  403,   18,  138,  847,  109,  404,  624,
>- /*   690 */   624,  896,  109,  896,  848,  672,  164,  122,  382,  384,
>- /*   700 */   374,  751,  673,  843,  122,   48,   48,  162,  174,   78,
>- /*   710 */   719,  843,  184,  753,  753,  755,  756,  403,   18,  886,
>- /*   720 */   886,  217,  155,  253,  359,  248,  358,  203,   75,   76,
>- /*   730 */   693,  122,  689,  189,  246,   77,  109,  688,  404,  328,
>- /*   740 */   382,  381,  870,   78,  109,  287,  363,  404,  400,    2,
>- /*   750 */   246,   85,  307,  308,  308,   30,   30,   84,   81,  176,
>- /*   760 */   331,  658,   75,   76,   48,   48,  870,  404,  331,   77,
>- /*   770 */   389,  887,  708,   23,  370,  761,  167,  754,  329,  109,
>- /*   780 */   749,  255,  400,    2,   10,   10,  340,  308,  308,  404,
>- /*   790 */   364,    9,    9,  216,  366,  404,  177,  177,  295,  382,
>- /*   800 */   362,  830,  830,  325,  389,  751,   48,   48,  369,  761,
>- /*   810 */   705,  754,   10,   10,  749,  659,  404,  753,  753,  755,
>- /*   820 */   756,  403,   18,  624,  624,  404,  198,  404,  339,  886,
>- /*   830 */   886,  671,  671,   48,   48,  316,  157,  156,  823,  751,
>- /*   840 */   823,  300,   47,   47,   10,   10,   66,   68,  185,  816,
>- /*   850 */   818,  753,  753,  755,  756,  403,   18,   95,  379,  146,
>- /*   860 */   404,  634,  634,  177,  177,  652,   75,   76,  377,  241,
>- /*   870 */     5,  357,  208,   77,  885,  369,  653,   34,   34,  643,
>- /*   880 */   339,  887,  707,  761,  404,  754,  400,    2,  749,  318,
>- /*   890 */   705,  308,  308,  706,  297,  229,  263,  705,  885,  404,
>- /*   900 */    24,   35,   35,  335,  624,  624,  806,  846,  389,  624,
>- /*   910 */   624,  816,  188,  761,  404,  754,   36,   36,  749,  240,
>- /*   920 */   178,  847,  404,  747,  404,  753,  753,  755,  849,  848,
>- /*   930 */   388,   37,   37,  404,  705,  321,  404,  669,  669,   38,
>- /*   940 */    38,   26,   26,  751,  404,  228,  165,  706,  404,  841,
>- /*   950 */    27,   27,  232,   29,   29,  753,  753,  755,  756,  403,
>- /*   960 */    18,   39,   39,  404,  234,   40,   40,  827,  264,  826,
>- /*   970 */   404,  705,  678,  404,  921,  323,  227,  404,  226,  404,
>- /*   980 */    41,   41,  109,  623,  288,  404,  324,   11,   11,  404,
>- /*   990 */    42,   42,  143,  404,   97,   97,   43,   43,  404,  747,
>- /*  1000 */   404,  257,   44,   44,  404,  339,   31,   31,  404,  674,
>- /*  1010 */    45,   45,  404,  747,  404,   46,   46,   32,   32,  404,
>- /*  1020 */   752,  112,  112,  252,  694,  113,  113,  404,  705,  114,
>- /*  1030 */   114,   52,   52,  404,  251,  404,   33,   33,  404,  677,
>- /*  1040 */   404,  208,  404,  885,   98,   98,  404,  624,  624,  259,
>- /*  1050 */    49,   49,   99,   99,  394,  100,  100,   96,   96,  111,
>- /*  1060 */   111,  404,  290,  108,  108,  404,  231,  885,  404,  747,
>- /*  1070 */   404,  747,  109,  404,  163,  404,  291,  404,  104,  104,
>- /*  1080 */   404,  169,  103,  103,  404,  101,  101,  102,  102,  191,
>+ /*   580 */    86,   85,  306,  403,  305,  305,  305,  604,  309,  141,
>+ /*   590 */    75,   76,  263,  623,  623,  691,  872,   77,  283,  314,
>+ /*   600 */    48,   48,  304,  303,  639,   78,  264,   84,   81,  176,
>+ /*   610 */   399,    2, 1096,  314,  313,  307,  307,  200,  199,  200,
>+ /*   620 */   141,  355,  352,  351,   75,   76,  272,  623,  623,  280,
>+ /*   630 */   403,   77,  388,  350,  386,  381,  371,  760,  302,  753,
>+ /*   640 */   742, 1172,  748,  660,  399,    2,  403,   10,   10,  307,
>+ /*   650 */   307,  890,  298,  894,  382,  372,  236,  329,  235,  370,
>+ /*   660 */   892,  292,  893,   48,   48,  360,  388,  750,  347,  332,
>+ /*   670 */   201,  760,  845,  753,  704,  314,  748,  295,  397,  752,
>+ /*   680 */   752,  754,  755,  402,   18,  138,  846,  109,  403,  623,
>+ /*   690 */   623,  895,  109,  895,  847,  671,  164,  122,  381,  383,
>+ /*   700 */   373,  750,  672,  842,  122,   48,   48,  162,  174,   78,
>+ /*   710 */   718,  842,  184,  752,  752,  754,  755,  402,   18,  885,
>+ /*   720 */   885,  217,  155,  252,  358,  247,  357,  203,   75,   76,
>+ /*   730 */   692,  122,  688,  189,  245,   77,  109,  687,  403,  327,
>+ /*   740 */   381,  380,  869,   78,  109,  286,  362,  403,  399,    2,
>+ /*   750 */   245,   85,  306,  307,  307,   30,   30,   84,   81,  176,
>+ /*   760 */   330,  657,   75,   76,   48,   48,  869,  403,  330,   77,
>+ /*   770 */   388,  886,  707,   23,  369,  760,  167,  753,  328,  109,
>+ /*   780 */   748,  254,  399,    2,   10,   10,  339,  307,  307,  403,
>+ /*   790 */   363,    9,    9,  216,  365,  403,  177,  177,  294,  381,
>+ /*   800 */   361,  829,  829,  324,  388,  750,   48,   48,  368,  760,
>+ /*   810 */   704,  753,   10,   10,  748,  658,  403,  752,  752,  754,
>+ /*   820 */   755,  402,   18,  623,  623,  403,  198,  403,  338,  885,
>+ /*   830 */   885,  670,  670,   48,   48,  315,  157,  156,  822,  750,
>+ /*   840 */   822,  299,   47,   47,   10,   10,   66,   68,  185,  815,
>+ /*   850 */   817,  752,  752,  754,  755,  402,   18,   95,  378,  146,
>+ /*   860 */   403,  633,  633,  177,  177,  651,   75,   76,  376,  240,
>+ /*   870 */     5,  356,  208,   77,  884,  368,  652,   34,   34,  642,
>+ /*   880 */   338,  886,  706,  760,  403,  753,  399,    2,  748,  317,
>+ /*   890 */   704,  307,  307,  705,  296,  229,  262,  704,  884,  403,
>+ /*   900 */    24,   35,   35,  334,  623,  623,  805,  845,  388,  623,
>+ /*   910 */   623,  815,  188,  760,  403,  753,   36,   36,  748,  239,
>+ /*   920 */   178,  846,  403,  746,  403,  752,  752,  754,  848,  847,
>+ /*   930 */   387,   37,   37,  403,  704,  320,  403,  668,  668,   38,
>+ /*   940 */    38,   26,   26,  750,  403,  228,  165,  705,  403,  840,
>+ /*   950 */    27,   27,  232,   29,   29,  752,  752,  754,  755,  402,
>+ /*   960 */    18,   39,   39,  403,  234,   40,   40,  826,  263,  825,
>+ /*   970 */   403,  704,  677,  403,  920,  322,  227,  403,  226,  403,
>+ /*   980 */    41,   41,  109,  622,  287,  403,  323,   11,   11,  403,
>+ /*   990 */    42,   42,  143,  403,   97,   97,   43,   43,  403,  746,
>+ /*  1000 */   403,  256,   44,   44,  403,  338,   31,   31,  403,  673,
>+ /*  1010 */    45,   45,  403,  746,  403,   46,   46,   32,   32,  403,
>+ /*  1020 */   751,  112,  112,  251,  693,  113,  113,  403,  704,  114,
>+ /*  1030 */   114,   52,   52,  403,  250,  403,   33,   33,  403,  676,
>+ /*  1040 */   403,  208,  403,  884,   98,   98,  403,  623,  623,  258,
>+ /*  1050 */    49,   49,   99,   99,  393,  100,  100,   96,   96,  111,
>+ /*  1060 */   111,  403,  289,  108,  108,  403,  231,  884,  403,  746,
>+ /*  1070 */   403,  746,  109,  403,  163,  403,  290,  403,  104,  104,
>+ /*  1080 */   403,  169,  103,  103,  403,  101,  101,  102,  102,  191,
>  /*  1090 */    51,   51,   53,   53,   50,   50,  107,   25,   25,    1,
>- /*  1100 */   628,   28,   28,  624,  624,  365,  681,  684,  684,  622,
>- /*  1110 */   161,  160,  159,  401,  288,  391,  395,  369,  399,  175,
>- /*  1120 */   174,  337,  721,  722,  628,   74,  884,   72,  689,  110,
>- /*  1130 */   262,  149,  292,  688,  301,  745,   20,  206,  332,  334,
>- /*  1140 */   206,  206,  109,  237,   64,   66,  651,  650,  109,  109,
>- /*  1150 */   349,  109,  212,  244,  822,   66,  822,  641,  641,  686,
>- /*  1160 */   715,   69,  206,    7,  813,  813,  338,   19,  735,  809,
>- /*  1170 */   626,  212,  106,  852,  757,  757,  319,  851,  153,  820,
>- /*  1180 */   289,  814,  225,  168,  233,  838,  840,  837,  336,  342,
>- /*  1190 */   343,  239,  354,  617,  242,  158,  662,  646,  247,  713,
>- /*  1200 */   645,  746,  261,  695,  250,  390,  811,  266,  810,  267,
>- /*  1210 */   272,  629,  154,  866,  615,  614,  616,  863,  135,  124,
>- /*  1220 */   117,   64,  322,  825,  732,   55,  327,  230,  347,  187,
>- /*  1230 */   147,  194,  144,  195,  126,  360,  196,  298,  643,  128,
>- /*  1240 */   665,  129,  130,  131,  345,  282,  664,  139,  663,  375,
>- /*  1250 */    63,    6,  742,   71,  842,  637,  302,  283,  636,  656,
>- /*  1260 */    94,  249,  635,  875,  380,   65,  805,  655,  378,   21,
>- /*  1270 */   864,  222,  607,  610,  309,  179,  819,  219,  279,  221,
>- /*  1280 */   405,  406,  612,  611,  608,  311,  123,  817,  181,  393,
>- /*  1290 */   741,  115,  397,  125,  120,  127,  186,  675,  116,  828,
>- /*  1300 */   703,  133,  206,  132,  836,  898,  254,  326,  136,  134,
>- /*  1310 */   105,  704,  256,  202,  702,   56,   57,   58,  258,  269,
>- /*  1320 */   701,  260,  685,  268,  270,  271,   59,  839,  121,  835,
>- /*  1330 */   791,  190,  192,   12,  209,  238,    8,  193,  148,  620,
>- /*  1340 */   346,  197,  140,  210,  211,  251,  350,  355,  654,  204,
>- /*  1350 */   118,   60,   13,  683,  245,   14,   61,   62,  170,  760,
>- /*  1360 */   759,  789,   15,  385,  687,    4,  714,  368,  171,  173,
>- /*  1370 */   205,  142,   69,  709,  166,   16,   66,   17,  804,  790,
>- /*  1380 */   788,  793,  845,  214,  844,  386,  856,  150,  392,  275,
>- /*  1390 */   857,  213,  151,  396,  792,  152,  604,  758,  627,   79,
>- /*  1400 */  1155,  621,
>+ /*  1100 */   627,   28,   28,  623,  623,  364,  680,  683,  683,  621,
>+ /*  1110 */   161,  160,  159,  400,  287,  390,  394,  368,  398,  175,
>+ /*  1120 */   174,  336,  720,  721,  627,   74,  883,   72,  688,  110,
>+ /*  1130 */   261,  149,  291,  687,  300,  744,   20,  206,  331,  333,
>+ /*  1140 */   206,  206,  109,  804,   64,   66,  650,  649,  109,  109,
>+ /*  1150 */   348,  109,  212,  243,  821,   66,  821,  640,  640,  685,
>+ /*  1160 */   714,   69,  206,    7,  812,  812,  337,   19,  734,  808,
>+ /*  1170 */   625,  212,  106,  851,  756,  756,  318,  850,  153,  819,
>+ /*  1180 */   288,  813,  225,  168,  233,  837,  839,  836,  335,  341,
>+ /*  1190 */   342,  238,  353,  616,  241,  158,  661,  645,  246,  712,
>+ /*  1200 */   644,  745,  260,  694,  249,  389,  810,  265,  809,  266,
>+ /*  1210 */   271,  628,  154,  865,  614,  613,  615,  862,  135,  124,
>+ /*  1220 */   117,   64,  321,  824,  731,   55,  326,  230,  346,  187,
>+ /*  1230 */   147,  194,  144,  195,  126,  359,  196,  297,  642,  128,
>+ /*  1240 */   664,  129,  130,  131,  344,  281,  663,  139,  662,  374,
>+ /*  1250 */    63,    6,  741,   71,  841,  636,  301,  282,  635,  655,
>+ /*  1260 */    94,  248,  634,  874,  379,   65,  654,   21,  377,  863,
>+ /*  1270 */   222,  606,  609,  308,  179,  310,  123,  278,  219,  221,
>+ /*  1280 */   404,  702,  405,  611,  392,  818,  610,  607,  816,  181,
>+ /*  1290 */   115,  396,  740,  125,  120,  116,  127,  186,  674,  827,
>+ /*  1300 */   253,  206,  132,  897,  105,  202,  133,  703,  835,  325,
>+ /*  1310 */   255,  134,  136,  701,  700,   56,   57,  270,  257,  259,
>+ /*  1320 */   684,  267,  268,  269,   58,   59,  121,  838,  190,  192,
>+ /*  1330 */   790,  834,    8,  209,   12,  237,  619,  193,  148,  345,
>+ /*  1340 */   197,  140,  210,  211,  250,  349,  354,  653,   60,   13,
>+ /*  1350 */   204,  244,   14,   61,   62,  118,  682,  170,  759,  758,
>+ /*  1360 */   788,   15,  205,  686,    4,  713,  367,  171,  173,  142,
>+ /*  1370 */   708,   69,  384,   16,   66,  803,   17,  789,  385,  787,
>+ /*  1380 */   792,  844,  843,  166,  391,  855,  150,  151,  213,  856,
>+ /*  1390 */   274,  152,  395,  791,  757,  626,   79,  214,  620,  603,
>+ /*  1400 */  1154,
> };
> static const YYCODETYPE yy_lookahead[] = {
>  /*     0 */     5,    6,    7,    8,    9,   10,   11,   12,   13,   14,
>@@ -667,24 +667,24 @@ static const YYCODETYPE yy_lookahead[] = {
>  /*  1230 */   209,  148,   47,  148,  177,   84,  148,   63,   83,  180,
>  /*  1240 */   162,  180,  180,  180,  165,  165,  162,  177,  162,  106,
>  /*  1250 */    84,   47,  177,  121,  189,  162,   32,  165,  164,  170,
>- /*  1260 */   112,  162,  162,  162,  107,  111,  189,  170,  110,   50,
>- /*  1270 */    40,   35,    4,   36,    3,   42,   48,  144,  141,  144,
>- /*  1280 */   150,  142,  142,  142,  142,   72,   43,   48,  101,  165,
>- /*  1290 */    99,  153,  165,  114,   88,  102,   84,   46,  153,  127,
>- /*  1300 */   204,   84,   50,  127,    1,  130,  203,  129,  114,  102,
>- /*  1310 */   166,  204,  203,  166,  204,   16,   16,   16,  203,  191,
>- /*  1320 */   204,  203,  193,  192,  190,  189,   16,   52,   88,    1,
>- /*  1330 */   213,  105,  101,   47,  215,  124,   34,   84,   49,   46,
>- /*  1340 */     7,   82,   47,  218,  218,   89,   66,   66,   54,   66,
>- /*  1350 */    60,   47,   47,   95,   48,   47,   47,   50,  101,   48,
>- /*  1360 */    48,   48,   47,   75,   48,   47,   52,   50,   48,   48,
>- /*  1370 */   105,   47,   50,  104,   47,  105,   50,  105,   48,   48,
>- /*  1380 */    48,   38,   48,  101,   48,   50,   48,   47,   49,   42,
>- /*  1390 */    48,   50,   47,   49,   48,   47,    1,   48,   48,   47,
>- /*  1400 */     0,   48,
>+ /*  1260 */   112,  162,  162,  162,  107,  111,  170,   50,  110,   40,
>+ /*  1270 */    35,    4,   36,    3,   42,   72,   43,  141,  144,  144,
>+ /*  1280 */   150,  204,  142,  142,  165,   48,  142,  142,   48,  101,
>+ /*  1290 */   153,  165,   99,  114,   88,  153,  102,   84,   46,  127,
>+ /*  1300 */   203,   50,  127,  130,  166,  166,   84,  204,    1,  129,
>+ /*  1310 */   203,  102,  114,  204,  204,   16,   16,  189,  203,  203,
>+ /*  1320 */   193,  192,  191,  190,   16,   16,   88,   52,  105,  101,
>+ /*  1330 */   213,    1,   34,  215,   47,  124,   46,   84,   49,    7,
>+ /*  1340 */    82,   47,  218,  218,   89,   66,   66,   54,   47,   47,
>+ /*  1350 */    66,   48,   47,   47,   50,   60,   95,  101,   48,   48,
>+ /*  1360 */    48,   47,  105,   48,   47,   52,   50,   48,   48,   47,
>+ /*  1370 */   104,   50,   75,  105,   50,   48,  105,   48,   50,   48,
>+ /*  1380 */    38,   48,   48,   47,   49,   48,   47,   47,   50,   48,
>+ /*  1390 */    42,   47,   49,   48,   48,   48,   47,  101,   48,    1,
>+ /*  1400 */     0,
> };
>-#define YY_SHIFT_USE_DFLT (1402)
>-#define YY_SHIFT_COUNT    (408)
>+#define YY_SHIFT_USE_DFLT (1401)
>+#define YY_SHIFT_COUNT    (407)
> #define YY_SHIFT_MIN      (-82)
> #define YY_SHIFT_MAX      (1400)
> static const short yy_shift_ofst[] = {
>@@ -699,11 +699,11 @@ static const short yy_shift_ofst[] = {
>  /*    80 */   736,  736,  840,  736,  736,  736,  736,  736,  736,  736,
>  /*    90 */   736,  736,  736,  736,  736,  736,   11,   30,   30,   30,
>  /*   100 */    30,   30,  188,   37,   43,  661,  201,  201,  720,  695,
>- /*   110 */   772,  -16, 1402, 1402, 1402,  645,  645,  633,  633,  826,
>+ /*   110 */   772,  -16, 1401, 1401, 1401,  645,  645,  633,  633,  826,
>  /*   120 */   221,  221,  858,  772,  317,  772,  772,  772,  772,  772,
>  /*   130 */   772,  772,  772,  772,  772,  772,  772,  772,  772,  772,
>  /*   140 */   772,  691,  772,  772,  772,  691,  695,  -82,  -82,  -82,
>- /*   150 */   -82,  -82,  -82, 1402, 1402,  810,  242,  242,  285,  806,
>+ /*   150 */   -82,  -82,  -82, 1401, 1401,  810,  242,  242,  285,  806,
>  /*   160 */   806,  806,  119,  823,  668,  778,  868,  716,  911,  638,
>  /*   170 */   996,  992,  992,  992,  853,  843, 1052, 1011,  637,  772,
>  /*   180 */   772,  772,  772, 1031,  648,  648,  772,  772, 1114, 1031,
>@@ -711,29 +711,29 @@ static const short yy_shift_ofst[] = {
>  /*   200 */   593,  772,   36,  772, 1014,  772,  772,  648,  772, 1004,
>  /*   210 */  1014, 1014,  772,  772,  772, 1076, 1033,  772, 1082,  772,
>  /*   220 */   772,  772,  772, 1171, 1215, 1108, 1177, 1177, 1177, 1177,
>- /*   230 */  1104, 1098, 1183, 1108, 1171, 1215, 1215, 1108, 1183, 1185,
>- /*   240 */  1183, 1183, 1185, 1151, 1151, 1151, 1174, 1185, 1151, 1155,
>- /*   250 */  1151, 1174, 1151, 1151, 1143, 1166, 1143, 1166, 1143, 1166,
>- /*   260 */  1143, 1166, 1204, 1132, 1185, 1224, 1224, 1185, 1148, 1157,
>- /*   270 */  1154, 1158, 1108, 1219, 1230, 1230, 1236, 1236, 1236, 1236,
>- /*   280 */  1237, 1402, 1402, 1402, 1402,  152,  852, 1025, 1049, 1120,
>- /*   290 */  1087, 1090, 1091, 1095, 1102, 1105, 1106, 1069,  725,  945,
>- /*   300 */  1111, 1112, 1113, 1121,  723, 1039, 1122, 1123,  873, 1268,
>- /*   310 */  1271, 1233, 1213, 1243, 1228, 1239, 1187, 1191, 1179, 1206,
>- /*   320 */  1193, 1212, 1251, 1172, 1252, 1176, 1175, 1178, 1217, 1303,
>- /*   330 */  1207, 1194, 1299, 1300, 1301, 1310, 1240, 1275, 1226, 1231,
>- /*   340 */  1328, 1302, 1286, 1253, 1211, 1289, 1293, 1333, 1256, 1259,
>- /*   350 */  1295, 1280, 1304, 1305, 1306, 1308, 1281, 1294, 1309, 1283,
>- /*   360 */  1290, 1311, 1312, 1313, 1307, 1258, 1315, 1316, 1318, 1317,
>- /*   370 */  1257, 1320, 1321, 1314, 1265, 1324, 1269, 1322, 1270, 1326,
>- /*   380 */  1272, 1330, 1322, 1331, 1332, 1334, 1288, 1335, 1336, 1327,
>- /*   390 */  1343, 1338, 1340, 1339, 1341, 1342, 1345, 1344, 1341, 1346,
>- /*   400 */  1348, 1349, 1350, 1352, 1282, 1353, 1347, 1395, 1400,
>+ /*   230 */  1104, 1098, 1183, 1108, 1171, 1215, 1215, 1183, 1185, 1183,
>+ /*   240 */  1183, 1185, 1151, 1151, 1151, 1174, 1185, 1151, 1155, 1151,
>+ /*   250 */  1174, 1151, 1151, 1143, 1166, 1143, 1166, 1143, 1166, 1143,
>+ /*   260 */  1166, 1204, 1132, 1185, 1224, 1224, 1185, 1148, 1157, 1154,
>+ /*   270 */  1158, 1108, 1217, 1229, 1229, 1235, 1235, 1235, 1235, 1236,
>+ /*   280 */  1401, 1401, 1401, 1401,  152,  852, 1025, 1049, 1120, 1087,
>+ /*   290 */  1090, 1091, 1095, 1102, 1105, 1106, 1069,  725,  945, 1111,
>+ /*   300 */  1112, 1113, 1121,  723, 1039, 1122, 1123,  873, 1267, 1270,
>+ /*   310 */  1232, 1203, 1233, 1237, 1240, 1188, 1193, 1179, 1206, 1194,
>+ /*   320 */  1213, 1252, 1172, 1251, 1175, 1173, 1180, 1222, 1307, 1209,
>+ /*   330 */  1198, 1299, 1300, 1308, 1309, 1238, 1275, 1223, 1228, 1330,
>+ /*   340 */  1298, 1287, 1253, 1211, 1289, 1290, 1332, 1255, 1258, 1294,
>+ /*   350 */  1279, 1301, 1302, 1303, 1305, 1280, 1293, 1306, 1284, 1295,
>+ /*   360 */  1310, 1311, 1312, 1304, 1261, 1314, 1315, 1317, 1316, 1256,
>+ /*   370 */  1319, 1320, 1313, 1257, 1322, 1266, 1321, 1268, 1324, 1271,
>+ /*   380 */  1327, 1321, 1329, 1331, 1333, 1297, 1328, 1334, 1336, 1342,
>+ /*   390 */  1337, 1339, 1335, 1338, 1341, 1340, 1343, 1338, 1345, 1344,
>+ /*   400 */  1346, 1347, 1349, 1296, 1350, 1348, 1398, 1400,
> };
> #define YY_REDUCE_USE_DFLT (-69)
>-#define YY_REDUCE_COUNT (284)
>+#define YY_REDUCE_COUNT (283)
> #define YY_REDUCE_MIN   (-68)
>-#define YY_REDUCE_MAX   (1147)
>+#define YY_REDUCE_MAX   (1145)
> static const short yy_reduce_ofst[] = {
>  /*     0 */   237,  503,  595,  124,  167,  440,  545,  604,  552,  397,
>  /*    10 */   158,  547,  487,  624,  652,  646,  673,  684,  682,  456,
>@@ -758,55 +758,55 @@ static const short yy_reduce_ofst[] = {
>  /*   200 */  1023, 1054, 1032, 1055, 1041, 1056, 1058, 1000, 1060,  989,
>  /*   210 */  1043, 1045, 1064, 1066,  877, 1022, 1026, 1068, 1067, 1071,
>  /*   220 */  1072, 1073, 1074, 1010, 1057, 1035, 1059, 1061, 1062, 1063,
>- /*   230 */   998, 1003, 1081, 1065, 1021, 1070, 1075, 1077, 1083, 1079,
>- /*   240 */  1085, 1088, 1080, 1078, 1084, 1086, 1089, 1092, 1093, 1094,
>- /*   250 */  1099, 1097, 1100, 1101, 1096, 1103, 1107, 1109, 1110, 1115,
>- /*   260 */  1116, 1118, 1117, 1119, 1124, 1125, 1126, 1127, 1129, 1131,
>- /*   270 */  1128, 1134, 1136, 1130, 1133, 1135, 1139, 1140, 1141, 1142,
>- /*   280 */  1137, 1138, 1144, 1147, 1145,
>+ /*   230 */   998, 1003, 1081, 1065, 1021, 1070, 1075, 1083, 1079, 1085,
>+ /*   240 */  1088, 1080, 1078, 1084, 1086, 1089, 1092, 1093, 1094, 1099,
>+ /*   250 */  1096, 1100, 1101, 1077, 1097, 1103, 1107, 1109, 1115, 1110,
>+ /*   260 */  1116, 1117, 1118, 1119, 1124, 1125, 1126, 1127, 1129, 1131,
>+ /*   270 */  1133, 1128, 1130, 1134, 1135, 1140, 1141, 1144, 1145, 1136,
>+ /*   280 */  1137, 1138, 1139, 1142,
> };
> static const YYACTIONTYPE yy_default[] = {
>- /*     0 */  1156, 1150, 1150, 1150, 1097, 1097, 1097, 1097, 1150,  993,
>- /*    10 */  1020, 1020, 1198, 1198, 1198, 1198, 1198, 1198, 1096, 1198,
>- /*    20 */  1198, 1198, 1198, 1150,  997, 1026, 1198, 1198, 1198, 1098,
>- /*    30 */  1099, 1198, 1198, 1198, 1131, 1036, 1035, 1034, 1033, 1007,
>- /*    40 */  1031, 1024, 1028, 1098, 1092, 1093, 1091, 1095, 1099, 1198,
>- /*    50 */  1027, 1061, 1076, 1060, 1198, 1198, 1198, 1198, 1198, 1198,
>- /*    60 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
>- /*    70 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
>- /*    80 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
>- /*    90 */  1198, 1198, 1198, 1198, 1198, 1198, 1070, 1075, 1082, 1074,
>- /*   100 */  1071, 1063, 1062, 1064, 1065,  964, 1198, 1198, 1066, 1198,
>- /*   110 */  1198, 1067, 1079, 1078, 1077, 1165, 1164, 1198, 1198, 1104,
>- /*   120 */  1198, 1198, 1198, 1198, 1150, 1198, 1198, 1198, 1198, 1198,
>- /*   130 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
>- /*   140 */  1198,  922, 1198, 1198, 1198,  922, 1198, 1150, 1150, 1150,
>- /*   150 */  1150, 1150, 1150,  997,  988, 1198, 1198, 1198, 1198, 1198,
>- /*   160 */  1198, 1198, 1198,  993, 1198, 1198, 1198, 1198, 1126, 1198,
>- /*   170 */  1198,  993,  993,  993, 1198,  995, 1198,  977,  987, 1198,
>- /*   180 */  1147, 1198, 1118, 1030, 1009, 1009, 1198, 1198, 1197, 1030,
>- /*   190 */  1198, 1197, 1198, 1198, 1198, 1198, 1198, 1198,  939, 1198,
>- /*   200 */  1176, 1198,  936, 1198, 1020, 1198, 1198, 1009, 1198, 1094,
>- /*   210 */  1020, 1020, 1198, 1198, 1198,  994,  987, 1198, 1198, 1198,
>- /*   220 */  1198, 1198, 1159, 1041,  967, 1030,  973,  973,  973,  973,
>- /*   230 */  1130, 1194,  916, 1030, 1041,  967,  967, 1030,  916, 1105,
>- /*   240 */   916,  916, 1105,  965,  965,  965,  954, 1105,  965,  939,
>- /*   250 */   965,  954,  965,  965, 1013, 1008, 1013, 1008, 1013, 1008,
>- /*   260 */  1013, 1008, 1100, 1198, 1105, 1109, 1109, 1105, 1025, 1014,
>- /*   270 */  1023, 1021, 1030,  957, 1162, 1162, 1158, 1158, 1158, 1158,
>- /*   280 */   906, 1171,  941,  941, 1171, 1198, 1198, 1198, 1166, 1112,
>- /*   290 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
>- /*   300 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1047, 1198,
>- /*   310 */   903, 1198, 1198, 1198, 1198, 1198, 1189, 1198, 1198, 1198,
>- /*   320 */  1198, 1198, 1198, 1198, 1129, 1128, 1198, 1198, 1198, 1198,
>- /*   330 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1196,
>- /*   340 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
>- /*   350 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
>- /*   360 */  1198, 1198, 1198, 1198, 1198,  979, 1198, 1198, 1198, 1180,
>- /*   370 */  1198, 1198, 1198, 1198, 1198, 1198, 1198, 1022, 1198, 1015,
>- /*   380 */  1198, 1198, 1186, 1198, 1198, 1198, 1198, 1198, 1198, 1198,
>- /*   390 */  1198, 1198, 1198, 1198, 1152, 1198, 1198, 1198, 1151, 1198,
>- /*   400 */  1198, 1198, 1198, 1198, 1198, 1198,  910, 1198, 1198,
>+ /*     0 */  1155, 1149, 1149, 1149, 1096, 1096, 1096, 1096, 1149,  992,
>+ /*    10 */  1019, 1019, 1197, 1197, 1197, 1197, 1197, 1197, 1095, 1197,
>+ /*    20 */  1197, 1197, 1197, 1149,  996, 1025, 1197, 1197, 1197, 1097,
>+ /*    30 */  1098, 1197, 1197, 1197, 1130, 1035, 1034, 1033, 1032, 1006,
>+ /*    40 */  1030, 1023, 1027, 1097, 1091, 1092, 1090, 1094, 1098, 1197,
>+ /*    50 */  1026, 1060, 1075, 1059, 1197, 1197, 1197, 1197, 1197, 1197,
>+ /*    60 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
>+ /*    70 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
>+ /*    80 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
>+ /*    90 */  1197, 1197, 1197, 1197, 1197, 1197, 1069, 1074, 1081, 1073,
>+ /*   100 */  1070, 1062, 1061, 1063, 1064,  963, 1197, 1197, 1065, 1197,
>+ /*   110 */  1197, 1066, 1078, 1077, 1076, 1164, 1163, 1197, 1197, 1103,
>+ /*   120 */  1197, 1197, 1197, 1197, 1149, 1197, 1197, 1197, 1197, 1197,
>+ /*   130 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
>+ /*   140 */  1197,  921, 1197, 1197, 1197,  921, 1197, 1149, 1149, 1149,
>+ /*   150 */  1149, 1149, 1149,  996,  987, 1197, 1197, 1197, 1197, 1197,
>+ /*   160 */  1197, 1197, 1197,  992, 1197, 1197, 1197, 1197, 1125, 1197,
>+ /*   170 */  1197,  992,  992,  992, 1197,  994, 1197,  976,  986, 1197,
>+ /*   180 */  1146, 1197, 1117, 1029, 1008, 1008, 1197, 1197, 1196, 1029,
>+ /*   190 */  1197, 1196, 1197, 1197, 1197, 1197, 1197, 1197,  938, 1197,
>+ /*   200 */  1175, 1197,  935, 1197, 1019, 1197, 1197, 1008, 1197, 1093,
>+ /*   210 */  1019, 1019, 1197, 1197, 1197,  993,  986, 1197, 1197, 1197,
>+ /*   220 */  1197, 1197, 1158, 1040,  966, 1029,  972,  972,  972,  972,
>+ /*   230 */  1129, 1193,  915, 1029, 1040,  966,  966,  915, 1104,  915,
>+ /*   240 */   915, 1104,  964,  964,  964,  953, 1104,  964,  938,  964,
>+ /*   250 */   953,  964,  964, 1012, 1007, 1012, 1007, 1012, 1007, 1012,
>+ /*   260 */  1007, 1099, 1197, 1104, 1108, 1108, 1104, 1024, 1013, 1022,
>+ /*   270 */  1020, 1029,  956, 1161, 1161, 1157, 1157, 1157, 1157,  905,
>+ /*   280 */  1170,  940,  940, 1170, 1197, 1197, 1197, 1165, 1111, 1197,
>+ /*   290 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
>+ /*   300 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1046, 1197,  902,
>+ /*   310 */  1197, 1197, 1197, 1197, 1197, 1188, 1197, 1197, 1197, 1197,
>+ /*   320 */  1197, 1197, 1197, 1128, 1127, 1197, 1197, 1197, 1197, 1197,
>+ /*   330 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1195, 1197,
>+ /*   340 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
>+ /*   350 */  1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
>+ /*   360 */  1197, 1197, 1197, 1197,  978, 1197, 1197, 1197, 1179, 1197,
>+ /*   370 */  1197, 1197, 1197, 1197, 1197, 1197, 1021, 1197, 1014, 1197,
>+ /*   380 */  1197, 1185, 1197, 1197, 1197, 1197, 1197, 1197, 1197, 1197,
>+ /*   390 */  1197, 1197, 1197, 1151, 1197, 1197, 1197, 1150, 1197, 1197,
>+ /*   400 */  1197, 1197, 1197, 1197, 1197,  909, 1197, 1197,
> };
> /********** End of lemon-generated parsing tables *****************************/
> 
>@@ -1252,7 +1252,7 @@ static const char *const yyRuleName[] = {
>  /* 198 */ "nexprlist ::= expr",
>  /* 199 */ "paren_exprlist ::=",
>  /* 200 */ "paren_exprlist ::= LP exprlist RP",
>- /* 201 */ "cmd ::= createkw uniqueflag INDEX ifnotexists nm ON nm LP sortlist RP where_opt",
>+ /* 201 */ "cmd ::= createkw uniqueflag INDEX ifnotexists nm ON nm LP sortlist RP",
>  /* 202 */ "uniqueflag ::= UNIQUE",
>  /* 203 */ "uniqueflag ::=",
>  /* 204 */ "eidlist_opt ::=",
>@@ -1995,7 +1995,7 @@ static const struct {
>   { 195, 1 },
>   { 213, 0 },
>   { 213, 3 },
>-  { 140, 11 },
>+  { 140, 10 },
>   { 217, 1 },
>   { 217, 0 },
>   { 165, 0 },
>@@ -3400,12 +3400,12 @@ static void yy_reduce(
> {yymsp[-2].minor.yy382 = yymsp[-1].minor.yy382;}
> #line 3402 "parse.c"
>         break;
>-      case 201: /* cmd ::= createkw uniqueflag INDEX ifnotexists nm ON nm LP sortlist RP where_opt */
>+      case 201: /* cmd ::= createkw uniqueflag INDEX ifnotexists nm ON nm LP sortlist RP */
> #line 1244 "parse.y"
> {
>-  sqlite3CreateIndex(pParse, &yymsp[-6].minor.yy0, 
>-                     sqlite3SrcListAppend(pParse->db,0,&yymsp[-4].minor.yy0), yymsp[-2].minor.yy382, yymsp[-9].minor.yy52,
>-                      &yymsp[-10].minor.yy0, yymsp[0].minor.yy362, SQLITE_SO_ASC, yymsp[-7].minor.yy52, SQLITE_IDXTYPE_APPDEF);
>+  sqlite3CreateIndex(pParse, &yymsp[-5].minor.yy0, 
>+                     sqlite3SrcListAppend(pParse->db,0,&yymsp[-3].minor.yy0), yymsp[-1].minor.yy382, yymsp[-8].minor.yy52,
>+                      &yymsp[-9].minor.yy0, 0, SQLITE_SO_ASC, yymsp[-6].minor.yy52, SQLITE_IDXTYPE_APPDEF);
> }
> #line 3411 "parse.c"
>         break;
>diff --git a/src/box/sql/parse.y b/src/box/sql/parse.y
>index b078e20..e0b5a2e 100644
>--- a/src/box/sql/parse.y
>+++ b/src/box/sql/parse.y
>@@ -1241,10 +1241,10 @@ paren_exprlist(A) ::= LP exprlist(X) RP.  {A = X;}
> ///////////////////////////// The CREATE INDEX command ///////////////////////
> //
> cmd ::= createkw(S) uniqueflag(U) INDEX ifnotexists(NE) nm(X)
>-        ON nm(Y) LP sortlist(Z) RP where_opt(W). {
>+        ON nm(Y) LP sortlist(Z) RP. {
>   sqlite3CreateIndex(pParse, &X, 
>                      sqlite3SrcListAppend(pParse->db,0,&Y), Z, U,
>-                      &S, W, SQLITE_SO_ASC, NE, SQLITE_IDXTYPE_APPDEF);
>+                      &S, 0, SQLITE_SO_ASC, NE, SQLITE_IDXTYPE_APPDEF);
> }
> 
> %type uniqueflag {int}
>diff --git a/test/sql-tap/analyze9.test.lua b/test/sql-tap/analyze9.test.lua
>index 4ce575e..3668211 100755
>--- a/test/sql-tap/analyze9.test.lua
>+++ b/test/sql-tap/analyze9.test.lua
>@@ -1111,7 +1111,7 @@ test:do_test(
>         test:execsql([[
>             DROP TABLE IF EXISTS t1;
>             CREATE TABLE t1(id INTEGER PRIMARY KEY AUTOINCREMENT, a, b, c, d);
>-            CREATE INDEX i1 ON t1(a, b) WHERE d IS NOT NULL;
>+            CREATE INDEX i1 ON t1(a, b);
>             INSERT INTO t1 VALUES(null, -1, -1, -1, NULL);
>             INSERT INTO t1 SELECT null, 2*a,2*b,2*c,d FROM t1;
>             INSERT INTO t1 SELECT null, 2*a,2*b,2*c,d FROM t1;
>diff --git a/test/sql-tap/autoindex4.test.lua b/test/sql-tap/autoindex4.test.lua
>index 45bae48..a567c5e 100755
>--- a/test/sql-tap/autoindex4.test.lua
>+++ b/test/sql-tap/autoindex4.test.lua
>@@ -111,7 +111,7 @@ test:do_execsql_test(
> test:do_execsql_test(
>     "autoindex4-3.1",
>     [[
>-        CREATE INDEX Items_x1 ON Items(ItemName,Name) WHERE ItemName = 'dummy';
>+        CREATE INDEX Items_x1 ON Items(ItemName,Name);
> 
>         SELECT Items.ItemName
>           FROM Items
>diff --git a/test/sql-tap/fkey1.test.lua b/test/sql-tap/fkey1.test.lua
>index 8749e1f..bca82d9 100755
>--- a/test/sql-tap/fkey1.test.lua
>+++ b/test/sql-tap/fkey1.test.lua
>@@ -212,7 +212,7 @@ test:do_execsql_test(
>     "fkey1-6.1",
>     [[
>         CREATE TABLE p1(id PRIMARY KEY, x, y);
>-        CREATE UNIQUE INDEX p1x ON p1(x) WHERE y<2;
>+        CREATE INDEX p1x ON p1(x);
>         INSERT INTO p1 VALUES(1, 1, 1);
>         CREATE TABLE c1(a PRIMARY KEY REFERENCES p1(x));
>     ]], {
>diff --git a/test/sql-tap/gh-2165-remove-support-partial-indexes.test.lua b/test/sql-tap/gh-2165-remove-support-partial-indexes.test.lua
>new file mode 100644
>index 0000000..d8210fc
>--- /dev/null
>+++ b/test/sql-tap/gh-2165-remove-support-partial-indexes.test.lua
>@@ -0,0 +1,17 @@
>+#!/usr/bin/env tarantool
>+test = require("sqltester")
>+
>+test:plan(1)
>+
>+
>+test:do_catchsql_test(
>+    "partial-index-1",
>+    [[
>+        CREATE TABLE t1 (a INTEGER PRIMARY KEY, b INTEGER)
>+        CREATE UNIQUE INDEX i ON t1 (a) WHERE a = 3;
>+    ]], {
>+        1, "keyword \"CREATE\" is reserved"
>+    })
>+
>+--This test intended to be deleted in #2626
>+test:finish_test()
>diff --git a/test/sql-tap/index6.test.lua b/test/sql-tap/index6.test.lua
>index 2aa97e8..069623f 100755
>--- a/test/sql-tap/index6.test.lua
>+++ b/test/sql-tap/index6.test.lua
>@@ -225,7 +225,7 @@ test:do_execsql_test(
>     "index6-6.0",
>     [[
>         CREATE TABLE t6(a,b, PRIMARY KEY (a,b));
>-        CREATE INDEX t6b ON t6(b) WHERE b=1;
>+        CREATE INDEX t6b ON t6(b);
>         INSERT INTO t6(a,b) VALUES(123,456);
>         SELECT * FROM t6;
>     ]], {
>@@ -262,7 +262,7 @@ test:do_execsql_test(
>         CREATE TABLE t7a(id primary key, x);
>         CREATE TABLE t7b(id primary key, y);
>         INSERT INTO t7a VALUES(1, 1);
>-        CREATE INDEX t7ax ON t7a(x) WHERE x=99;
>+        CREATE INDEX t7ax ON t7a(x);
>         SELECT x,y FROM t7a LEFT JOIN t7b ON (x=99) ORDER BY x;
>     ]], {
>         -- <index6-7.0>
>@@ -318,7 +318,7 @@ test:do_execsql_test(
>     [[
>         CREATE TABLE t8a(id primary key, a,b);
>         CREATE TABLE t8b(id primary key, x,y);
>-        CREATE INDEX i8c ON t8b(y) WHERE x = 'value';
>+        CREATE INDEX i8c ON t8b(y);
> 
>         INSERT INTO t8a VALUES(1, 1, 'one');
>         INSERT INTO t8a VALUES(2, 2, 'two');
>@@ -364,7 +364,7 @@ if (0 > 0)
>         "index6-9.1",
>         [[
>             CREATE TABLE t9(a int, b int, c int);
>-            CREATE INDEX t9ca ON t9(c,a) WHERE a in (10,12,20);
>+            CREATE INDEX t9ca ON t9(c,a);
>             INSERT INTO t9 VALUES(1,1,9),(10,2,35),(11,15,82),(20,19,5),(NULL,7,3);
>             UPDATE t9 SET b=c WHERE a in (10,12,20);
>             SELECT a,b,c,'|' FROM t9 ORDER BY a;
>@@ -379,7 +379,7 @@ test:do_execsql_test(
>     [[
>         --DROP TABLE t9;
>         CREATE TABLE t9(a int, b int, c int, PRIMARY KEY(a));
>-        CREATE INDEX t9ca ON t9(c,a) WHERE a in (10,12,20);
>+        CREATE INDEX t9ca ON t9(c,a);
>         INSERT INTO t9 VALUES(1,1,9),(10,2,35),(11,15,82),(20,19,5);
>         UPDATE t9 SET b=c WHERE a in (10,12,20);
>         SELECT a,b,c,'|' FROM t9 ORDER BY a;
>@@ -400,7 +400,7 @@ test:do_execsql_test(
>           (2,3,4,5,6),
>           (3,4,5,6,7),
>           (1,2,3,8,9);
>-        CREATE INDEX t10x ON t10(d) WHERE a=1 AND b=2 AND c=3;
>+        CREATE INDEX t10x ON t10(d);
>         SELECT e FROM t10 WHERE a=1 AND b=2 AND c=3 ORDER BY d;
>     ]], {
>         -- <index6-10.1>
>diff --git a/test/sql-tap/index7.test.lua b/test/sql-tap/index7.test.lua
>index c8f56eb..c194859 100755
>--- a/test/sql-tap/index7.test.lua
>+++ b/test/sql-tap/index7.test.lua
>@@ -1,6 +1,6 @@
> #!/usr/bin/env tarantool
> test = require("sqltester")
>-test:plan(5)
>+test:plan(4)
> 
> --!./tcltestrunner.lua
> -- 2013-11-04
>@@ -261,7 +261,7 @@ test:do_execsql_test(
> test:do_execsql_test(
>     "index7-6.2",
>     [[
>-        CREATE INDEX i4 ON t4(c) WHERE d='xyz';
>+        CREATE INDEX i4 ON t4(c);
>         SELECT a,b,c,d FROM (SELECT a,b FROM t5 WHERE a=1 AND b='xyz'), t4 WHERE c='abc';
>     ]], {
>         -- <index7-6.2>
>@@ -291,14 +291,15 @@ test:do_eqp_test(
>         -- </index7-6.4>
>     })
> 
>-test:do_catchsql_test(
>-    "index7-6.5",
>-    [[
>-        CREATE INDEX t5a ON t5(a) WHERE a=#1;
>-    ]], {
>-        -- <index7-6.5>
>-        1, [[near "#1": syntax error]]
>-        -- </index7-6.5>
>-    })
>-
>+--test:do_catchsql_test(
>+--    "index7-6.5",
>+--    [[
>+--        CREATE INDEX t5a ON t5(a) WHERE a=#1;
>+--    ]], {
>+--        -- <index7-6.5>
>+--        1, [[near "#1": syntax error]]
>+--        -- </index7-6.5>
>+--    })
>+-- this test checks incorrect syntax of partial indexes
>+-- to be enabled after #2626
> test:finish_test()
>-- 
>2.7.4
>
>
>
>




[-- Attachment #2: Type: text/html, Size: 53189 bytes --]

^ permalink raw reply	[flat|nested] 3+ messages in thread

* [tarantool-patches] [PATCH v2] sql: remove support of partial indexes
@ 2018-04-11 20:17 Gleb
  0 siblings, 0 replies; 3+ messages in thread
From: Gleb @ 2018-04-11 20:17 UTC (permalink / raw)
  To: tarantool-patches

Remove support partial indexes.
Add test which checks inaccessibility of partial index syntax.
Delete use partial index from tests.
Comment test which use partial index.
They can be enabled after #2626.

Fixes #2165
---
Issue from https://github.com/tarantool/tarantool/issues/2165.
Source from https://github.com/tarantool/tarantool/tree/gh-2165-remove-support-partial-indexes.
Changes in v2:
 -return tests which use partial.
 -delete "WHERE" from returned tests.

 src/box/sql/parse.c                                | 918 +++++++++++----------
 src/box/sql/parse.y                                |   4 +-
 test/sql-tap/analyze9.test.lua                     |   2 +-
 test/sql-tap/autoindex4.test.lua                   |   3 +-
 test/sql-tap/fkey1.test.lua                        |   2 +-
 ...gh-2165-remove-support-partial-indexes.test.lua |  17 +
 test/sql-tap/index7.test.lua                       |  24 +-
 test/sql-tap/suite.ini                             |   1 +
 8 files changed, 497 insertions(+), 474 deletions(-)
 create mode 100755 test/sql-tap/gh-2165-remove-support-partial-indexes.test.lua

diff --git a/src/box/sql/parse.c b/src/box/sql/parse.c
index 0019b77..8af15f1 100644
--- a/src/box/sql/parse.c
+++ b/src/box/sql/parse.c
@@ -315,16 +315,16 @@ typedef union {
 #define sqlite3ParserARG_FETCH Parse *pParse = yypParser->pParse
 #define sqlite3ParserARG_STORE yypParser->pParse = pParse
 #define YYFALLBACK 1
-#define YYNSTATE             412
+#define YYNSTATE             411
 #define YYNRULE              300
-#define YY_MAX_SHIFT         411
-#define YY_MIN_SHIFTREDUCE   608
-#define YY_MAX_SHIFTREDUCE   907
-#define YY_MIN_REDUCE        908
-#define YY_MAX_REDUCE        1207
-#define YY_ERROR_ACTION      1208
-#define YY_ACCEPT_ACTION     1209
-#define YY_NO_ACTION         1210
+#define YY_MAX_SHIFT         410
+#define YY_MIN_SHIFTREDUCE   607
+#define YY_MAX_SHIFTREDUCE   906
+#define YY_MIN_REDUCE        907
+#define YY_MAX_REDUCE        1206
+#define YY_ERROR_ACTION      1207
+#define YY_ACCEPT_ACTION     1208
+#define YY_NO_ACTION         1209
 /************* End control #defines *******************************************/
 
 /* Define the yytestcase() macro to be a no-op if is not already defined
@@ -396,149 +396,151 @@ typedef union {
 **  yy_default[]       Default action for each state.
 **
 *********** Begin parsing tables **********************************************/
-#define YY_ACTTAB_COUNT (1406)
+#define YY_ACTTAB_COUNT (1430)
 static const YYACTIONTYPE yy_action[] = {
- /*     0 */    91,   92,  287,   82,  775,  775,  787,  790,  779,  779,
- /*    10 */    89,   89,   90,   90,   90,   90,  309,   88,   88,   88,
- /*    20 */    88,   87,   87,   86,   86,   86,   85,  309,   90,   90,
+ /*     0 */    91,   92,  286,   82,  774,  774,  786,  789,  778,  778,
+ /*    10 */    89,   89,   90,   90,   90,   90,  308,   88,   88,   88,
+ /*    20 */    88,   87,   87,   86,   86,   86,   85,  308,   90,   90,
  /*    30 */    90,   90,   83,   88,   88,   88,   88,   87,   87,   86,
- /*    40 */    86,   86,   85,  309,  210,  122,  892,   90,   90,   90,
- /*    50 */    90,  634,   88,   88,   88,   88,   87,   87,   86,   86,
- /*    60 */    86,   85,  309,   87,   87,   86,   86,   86,   85,  309,
- /*    70 */   892,   86,   86,   86,   85,  309,   91,   92,  287,   82,
- /*    80 */   775,  775,  787,  790,  779,  779,   89,   89,   90,   90,
- /*    90 */    90,   90,  637,   88,   88,   88,   88,   87,   87,   86,
- /*   100 */    86,   86,   85,  309,   91,   92,  287,   82,  775,  775,
- /*   110 */   787,  790,  779,  779,   89,   89,   90,   90,   90,   90,
- /*   120 */   724,   88,   88,   88,   88,   87,   87,   86,   86,   86,
- /*   130 */    85,  309,  636,   91,   92,  287,   82,  775,  775,  787,
- /*   140 */   790,  779,  779,   89,   89,   90,   90,   90,   90,   67,
+ /*    40 */    86,   86,   85,  308,  210,  122,  891,   90,   90,   90,
+ /*    50 */    90,  633,   88,   88,   88,   88,   87,   87,   86,   86,
+ /*    60 */    86,   85,  308,   87,   87,   86,   86,   86,   85,  308,
+ /*    70 */   891,   86,   86,   86,   85,  308,   91,   92,  286,   82,
+ /*    80 */   774,  774,  786,  789,  778,  778,   89,   89,   90,   90,
+ /*    90 */    90,   90,  636,   88,   88,   88,   88,   87,   87,   86,
+ /*   100 */    86,   86,   85,  308,   91,   92,  286,   82,  774,  774,
+ /*   110 */   786,  789,  778,  778,   89,   89,   90,   90,   90,   90,
+ /*   120 */   723,   88,   88,   88,   88,   87,   87,   86,   86,   86,
+ /*   130 */    85,  308,  635,   91,   92,  286,   82,  774,  774,  786,
+ /*   140 */   789,  778,  778,   89,   89,   90,   90,   90,   90,   67,
  /*   150 */    88,   88,   88,   88,   87,   87,   86,   86,   86,   85,
- /*   160 */   309,  776,  776,  788,  791,  320,   93,   84,   81,  176,
- /*   170 */   307,  306, 1209,  411,    3,  723,  245,  609,  312,  725,
- /*   180 */   726,  376,   91,   92,  287,   82,  775,  775,  787,  790,
- /*   190 */   779,  779,   89,   89,   90,   90,   90,   90,  884,   88,
- /*   200 */    88,   88,   88,   87,   87,   86,   86,   86,   85,  309,
+ /*   160 */   308,  775,  775,  787,  790,  319,   93,   84,   81,  176,
+ /*   170 */   306,  305, 1208,  410,    3,  722,  244,  608,  311,  724,
+ /*   180 */   725,  375,   91,   92,  286,   82,  774,  774,  786,  789,
+ /*   190 */   778,  778,   89,   89,   90,   90,   90,   90,  883,   88,
+ /*   200 */    88,   88,   88,   87,   87,   86,   86,   86,   85,  308,
  /*   210 */    88,   88,   88,   88,   87,   87,   86,   86,   86,   85,
- /*   220 */   309,  122,   84,   81,  176,  642,  377, 1160, 1160,  828,
- /*   230 */   780,   91,   92,  287,   82,  775,  775,  787,  790,  779,
- /*   240 */   779,   89,   89,   90,   90,   90,   90,  364,   88,   88,
- /*   250 */    88,   88,   87,   87,   86,   86,   86,   85,  309,  903,
- /*   260 */   747,  903,  122,  410,  410,  172,  653,  710,  765,  220,
- /*   270 */   758,  119,  877,  753,  635,  683,  238,  333,  237,  652,
- /*   280 */    91,   92,  287,   82,  775,  775,  787,  790,  779,  779,
- /*   290 */    89,   89,   90,   90,   90,   90,  877,   88,   88,   88,
- /*   300 */    88,   87,   87,   86,   86,   86,   85,  309,   22,  747,
- /*   310 */   757,  757,  759,  201,  693,  651,  359,  356,  355,  692,
- /*   320 */   165,  710,  703,  766,  122,  238,  333,  237,  354,   91,
- /*   330 */    92,  287,   82,  775,  775,  787,  790,  779,  779,   89,
- /*   340 */    89,   90,   90,   90,   90,  747,   88,   88,   88,   88,
- /*   350 */    87,   87,   86,   86,   86,   85,  309,  696,   84,   81,
- /*   360 */   176,  238,  323,  226,  405,  405,  405,  670,  649,   84,
- /*   370 */    81,  176,  752,  122,  218,  369,  670,  340,   91,   92,
- /*   380 */   287,   82,  775,  775,  787,  790,  779,  779,   89,   89,
+ /*   220 */   308,  122,   84,   81,  176,  641,  376, 1159, 1159,  827,
+ /*   230 */   779,   91,   92,  286,   82,  774,  774,  786,  789,  778,
+ /*   240 */   778,   89,   89,   90,   90,   90,   90,  363,   88,   88,
+ /*   250 */    88,   88,   87,   87,   86,   86,   86,   85,  308,  902,
+ /*   260 */   746,  902,  122,  409,  409,  172,  652,  709,  764,  220,
+ /*   270 */   757,  119,  876,  752,  634,  682,  238,  332,  237,  651,
+ /*   280 */    91,   92,  286,   82,  774,  774,  786,  789,  778,  778,
+ /*   290 */    89,   89,   90,   90,   90,   90,  876,   88,   88,   88,
+ /*   300 */    88,   87,   87,   86,   86,   86,   85,  308,   22,  746,
+ /*   310 */   756,  756,  758,  201,  692,  650,  358,  355,  354,  691,
+ /*   320 */   165,  709,  702,  765,  122,  238,  332,  237,  353,   91,
+ /*   330 */    92,  286,   82,  774,  774,  786,  789,  778,  778,   89,
+ /*   340 */    89,   90,   90,   90,   90,  746,   88,   88,   88,   88,
+ /*   350 */    87,   87,   86,   86,   86,   85,  308,  695,   84,   81,
+ /*   360 */   176,  238,  322,  226,  404,  404,  404,  669,  648,   84,
+ /*   370 */    81,  176,  751,  122,  218,  368,  669,  339,   91,   92,
+ /*   380 */   286,   82,  774,  774,  786,  789,  778,  778,   89,   89,
  /*   390 */    90,   90,   90,   90,  209,   88,   88,   88,   88,   87,
- /*   400 */    87,   86,   86,   86,   85,  309,   91,   92,  287,   82,
- /*   410 */   775,  775,  787,  790,  779,  779,   89,   89,   90,   90,
- /*   420 */    90,   90,  341,   88,   88,   88,   88,   87,   87,   86,
- /*   430 */    86,   86,   85,  309,   91,   92,  287,   82,  775,  775,
- /*   440 */   787,  790,  779,  779,   89,   89,   90,   90,   90,   90,
- /*   450 */   379,   88,   88,   88,   88,   87,   87,   86,   86,   86,
- /*   460 */    85,  309,   91,   92,  287,   82,  775,  775,  787,  790,
- /*   470 */   779,  779,   89,   89,   90,   90,   90,   90,  145,   88,
- /*   480 */    88,   88,   88,   87,   87,   86,   86,   86,   85,  309,
- /*   490 */   308,  308,  308,   85,  309,   70,   92,  287,   82,  775,
- /*   500 */   775,  787,  790,  779,  779,   89,   89,   90,   90,   90,
+ /*   400 */    87,   86,   86,   86,   85,  308,   91,   92,  286,   82,
+ /*   410 */   774,  774,  786,  789,  778,  778,   89,   89,   90,   90,
+ /*   420 */    90,   90,  340,   88,   88,   88,   88,   87,   87,   86,
+ /*   430 */    86,   86,   85,  308,   91,   92,  286,   82,  774,  774,
+ /*   440 */   786,  789,  778,  778,   89,   89,   90,   90,   90,   90,
+ /*   450 */   378,   88,   88,   88,   88,   87,   87,   86,   86,   86,
+ /*   460 */    85,  308,   91,   92,  286,   82,  774,  774,  786,  789,
+ /*   470 */   778,  778,   89,   89,   90,   90,   90,   90,  145,   88,
+ /*   480 */    88,   88,   88,   87,   87,   86,   86,   86,   85,  308,
+ /*   490 */   307,  307,  307,   85,  308,   70,   92,  286,   82,  774,
+ /*   500 */   774,  786,  789,  778,  778,   89,   89,   90,   90,   90,
  /*   510 */    90,  164,   88,   88,   88,   88,   87,   87,   86,   86,
- /*   520 */    86,   85,  309,   73,  628,  628,  834,  834,  328,   91,
- /*   530 */    80,  287,   82,  775,  775,  787,  790,  779,  779,   89,
- /*   540 */    89,   90,   90,   90,   90,  390,   88,   88,   88,   88,
- /*   550 */    87,   87,   86,   86,   86,   85,  309,  287,   82,  775,
- /*   560 */   775,  787,  790,  779,  779,   89,   89,   90,   90,   90,
+ /*   520 */    86,   85,  308,   73,  627,  627,  833,  833,  327,   91,
+ /*   530 */    80,  286,   82,  774,  774,  786,  789,  778,  778,   89,
+ /*   540 */    89,   90,   90,   90,   90,  389,   88,   88,   88,   88,
+ /*   550 */    87,   87,   86,   86,   86,   85,  308,  286,   82,  774,
+ /*   560 */   774,  786,  789,  778,  778,   89,   89,   90,   90,   90,
  /*   570 */    90,   78,   88,   88,   88,   88,   87,   87,   86,   86,
- /*   580 */    86,   85,  309,  218,  369,  698,  141,  374,  301,  141,
- /*   590 */    75,   76,  275,  628,  628,  283,  282,   77,  286,  280,
- /*   600 */   279,  278,  222,  276,  850,   78,  622,  143,  628,  628,
- /*   610 */   403,    2, 1104,  298,  318,  310,  310,  202,  851,  202,
- /*   620 */   109,  342,  880,  407,   75,   76,  852,  676,  318,  317,
- /*   630 */   644,   77,  392,  182,  677,  162,  174,  765,  336,  758,
- /*   640 */    48,   48,  753,  347,  403,    2,  344,  407,  137,  310,
- /*   650 */   310,  407,  628,  628,  288,  386,  266,  219,  155,  255,
- /*   660 */   362,  250,  361,  205,   48,   48,  392,  755,   48,   48,
- /*   670 */   248,  765,  709,  758,  407,  302,  753,  675,  675,  757,
- /*   680 */   757,  759,  760,  406,   18,  673,  673,  184,  109,  847,
- /*   690 */   318,   48,   48,  180,  315,  122,  336,  122,  751,  385,
- /*   700 */   387,  755,  185,  385,  370,  190,  373,  307,  306,   78,
- /*   710 */   314,  628,  628,  757,  757,  759,  760,  406,   18,  210,
- /*   720 */   407,  892,  109,    9,    9,  331,  385,  375,   75,   76,
- /*   730 */   697,  122,  628,  628,  167,   77,  201,   48,   48,  359,
- /*   740 */   356,  355,  401,   78,  685,  892,  334,  267,  403,    2,
- /*   750 */    20,  354,  266,  310,  310,  372,  898,  744,  902,   23,
- /*   760 */   191,  327,   75,   76,  332,  900,  342,  901,  407,   77,
- /*   770 */   392,  267,  385,  384,  217,  765,  407,  758,  850,  296,
- /*   780 */   753,   19,  403,    2,   54,   10,   10,  310,  310,  407,
- /*   790 */   109,  338,  851,   48,   48,  407,  903,  366,  903,  295,
- /*   800 */   852,  391,  709,  305,  392,  755,   30,   30,  831,  765,
- /*   810 */   830,  758,   10,   10,  753,  407,  326,  757,  757,  759,
- /*   820 */   760,  406,   18,  177,  177,  407,  297,  407,  385,  365,
- /*   830 */   109,  407,   10,   10,  709,  372,  157,  156,  397,  755,
- /*   840 */   225,  367,   48,   48,   10,   10,  200,   68,   47,   47,
- /*   850 */   236,  757,  757,  759,  760,  406,   18,   95,  382,  231,
- /*   860 */   319,  638,  638,  847,  243,  656,   75,   76,  351,  756,
- /*   870 */   203,  360,  186,   77,  820,  822,  657,  380,  177,  177,
- /*   880 */   893,  893,  146,  765,  709,  758,  403,    2,  753,  203,
- /*   890 */   372,  310,  310,    5,  299,  210,  109,  892,  257,  893,
- /*   900 */   893,  810,  265,  709,  321,   74,  407,   72,  392,  230,
- /*   910 */   827,  407,  827,  765,  242,  758,  709,  407,  753,  254,
- /*   920 */   334,  892,  187,   34,   34,  757,  757,  759,   35,   35,
- /*   930 */   253,  407,  894,  712,   36,   36,  820,  110,  343,  149,
- /*   940 */   229,  853,  228,  755,  407,  289,  709,  234,   37,   37,
- /*   950 */   248,  894,  711,  259,  324,  757,  757,  759,  760,  406,
- /*   960 */    18,   38,   38,  407,  289,  407,  161,  160,  159,  407,
- /*   970 */   709,  407,    7,  407,  138,  407,  261,  407,  628,  628,
- /*   980 */    26,   26,   27,   27,  682,  407,   29,   29,   39,   39,
- /*   990 */    40,   40,   41,   41,   11,   11,  407,  709,  407,  693,
- /*  1000 */   407,  163,   42,   42,  692,  407,  342,  407,  678,  407,
- /*  1010 */   264,  407,  710,   97,   97,   43,   43,   44,   44,  407,
- /*  1020 */   751,  407,   31,   31,   45,   45,   46,   46,   32,   32,
- /*  1030 */   407, 1183,  407,  665,  407,  233,  112,  112,  113,  113,
- /*  1040 */   407,  751,  859,  407,  751,  407,  845,  114,  114,   52,
- /*  1050 */    52,   33,   33,  407,  858,  407,  681,   98,   98,  407,
- /*  1060 */    49,   49,   99,   99,  407,  165,  710,  407,  751,  407,
- /*  1070 */   100,  100,   96,   96,  169,  407,  111,  111,  407,  109,
- /*  1080 */   407,  108,  108,  292,  104,  104,  103,  103,  407,  109,
- /*  1090 */   193,  407,  101,  101,  407,  102,  102,   51,   51,  407,
- /*  1100 */   368,  626,  688,  688,  293,   53,   53,  294,   50,   50,
- /*  1110 */    24,   25,   25,  662,  628,  628,   28,   28,    1,  394,
- /*  1120 */   107,  398,  628,  628,  632,  627,  290,  402,  404,  290,
- /*  1130 */    66,  303,  175,  174,  109,  725,  726,   64,  891,  749,
- /*  1140 */   335,  208,  208,  337,  239,  208,   66,  352,  632,  214,
- /*  1150 */   856,  246,  109,   66,  109,  645,  645,  178,  655,  654,
- /*  1160 */   109,  316,  690,  647,   69,  824,  719,  663,  208,  291,
- /*  1170 */   817,  817,  813,  826,  214,  826,  630,  739,  106,  322,
- /*  1180 */   761,  761,  227,  818,  168,  235,  844,  842,  339,  841,
- /*  1190 */   153,  345,  346,  241,  621,  244,  357,  666,  650,  649,
- /*  1200 */   158,  252,  249,  717,  750,  263,  393,  699,  815,  268,
- /*  1210 */   814,  928,  269,  274,  873,  154,  135,  633,  619,  618,
- /*  1220 */   124,  620,  870,  117,   64,  736,  325,   55,  330,  829,
- /*  1230 */   126,  350,  232,  189,  196,  144,  128,  129,  197,  147,
- /*  1240 */   363,  198,  130,  300,  647,  131,  669,  139,  348,  746,
- /*  1250 */   378,  668,  284,    6,   63,  795,  846,   71,  211,  667,
- /*  1260 */   304,   94,  383,  285,  660,  640,   21,  641,   65,  251,
- /*  1270 */   639,  809,  659,  381,  882,  871,  224,  611,  614,  221,
- /*  1280 */   311,  396,  223,  408,  409,  616,  179,  615,  612,  281,
- /*  1290 */   115,  313,  400,  123,  181,  823,  821,  183,  745,  125,
- /*  1300 */   116,  120,  127,  679,  188,  832,  105,  204,  208,  132,
- /*  1310 */   133,  840,  329,  707,  905,  136,  256,  134,   56,  708,
- /*  1320 */   258,  273,  271,  689,  706,  260,  270,  705,  262,  272,
- /*  1330 */    57,   58,   59,  121,  843,  192,  839,  194,    8,  212,
- /*  1340 */    12,  240,  253,  195,  213,  148,  624,  349,  199,  353,
- /*  1350 */   140,  358,   60,   13,  206,  247,   14,  118,   61,  687,
- /*  1360 */   764,  763,  658,  170,  713,  793,   15,    4,   62,  691,
- /*  1370 */   207,  171,  371,  173,  142,   16,  718,   17,   69,   66,
- /*  1380 */   808,  794,  792,  797,  849,  216,  848,  389,  166,  215,
- /*  1390 */   863,  150,  395,  608,  864,  151,  399,  796,  152, 1165,
- /*  1400 */   762,  388,  631,   79,  277,  625,
+ /*   580 */    86,   85,  308,  218,  368,  697,  141,  373,  300,  141,
+ /*   590 */    75,   76,  274,  627,  627,  282,  281,   77,  285,  279,
+ /*   600 */   278,  277,  222,  275,  849,   78,  621,  143,  627,  627,
+ /*   610 */   402,    2, 1103,  297,  317,  309,  309,  202,  850,  202,
+ /*   620 */   109,  341,  879,  406,   75,   76,  851,  675,  317,  316,
+ /*   630 */   643,   77,  391,  182,  676,  162,  174,  764,  335,  757,
+ /*   640 */    48,   48,  752,  346,  402,    2,  343,  406,  137,  309,
+ /*   650 */   309,  406,  627,  627,  287,  385,  265,  219,  155,  254,
+ /*   660 */   361,  249,  360,  205,   48,   48,  391,  754,   48,   48,
+ /*   670 */   247,  764,  708,  757,  406,  301,  752,  674,  674,  756,
+ /*   680 */   756,  758,  759,  405,   18,  672,  672,  184,  109,  846,
+ /*   690 */   317,   48,   48,  180,  314,  122,  335,  122,  750,  384,
+ /*   700 */   386,  754,  185,  384,  369,  190,  372,  306,  305,   78,
+ /*   710 */   313,  627,  627,  756,  756,  758,  759,  405,   18,  210,
+ /*   720 */   406,  891,  109,    9,    9,  330,  384,  374,   75,   76,
+ /*   730 */   696,  122,  627,  627,  167,   77,  201,   48,   48,  358,
+ /*   740 */   355,  354,  400,   78,  684,  891,  333,  266,  402,    2,
+ /*   750 */    20,  353,  265,  309,  309,  371,  897,  743,  901,   23,
+ /*   760 */   191,  326,   75,   76,  331,  899,  341,  900,  406,   77,
+ /*   770 */   391,  266,  384,  383,  217,  764,  406,  757,  849,  295,
+ /*   780 */   752,   19,  402,    2,   54,   10,   10,  309,  309,  406,
+ /*   790 */   109,  337,  850,   48,   48,  406,  902,  365,  902,  294,
+ /*   800 */   851,  390,  708,  304,  391,  754,   30,   30,  830,  764,
+ /*   810 */   829,  757,   10,   10,  752,  406,  325,  756,  756,  758,
+ /*   820 */   759,  405,   18,  177,  177,  406,  296,  406,  384,  364,
+ /*   830 */   109,  406,   10,   10,  708,  371,  157,  156,  396,  754,
+ /*   840 */   225,  366,   48,   48,   10,   10,  200,   68,   47,   47,
+ /*   850 */   236,  756,  756,  758,  759,  405,   18,   95,  381,  231,
+ /*   860 */   318,  637,  637,  846,  242,  655,   75,   76,  350,  755,
+ /*   870 */   203,  359,  186,   77,  819,  821,  656,  379,  177,  177,
+ /*   880 */   892,  892,  146,  764,  708,  757,  402,    2,  752,  203,
+ /*   890 */   371,  309,  309,    5,  298,  210,  109,  891,  256,  892,
+ /*   900 */   892,  809,  264,  708,  320,   74,  406,   72,  391,  230,
+ /*   910 */   826,  406,  826,  764,  241,  757,  708,  406,  752,  253,
+ /*   920 */   333,  891,  187,   34,   34,  756,  756,  758,   35,   35,
+ /*   930 */   252,  406,  893,  711,   36,   36,  819,  110,  342,  149,
+ /*   940 */   229,  852,  228,  754,  406,  288,  708,  234,   37,   37,
+ /*   950 */   247,  893,  710,  258,  323,  756,  756,  758,  759,  405,
+ /*   960 */    18,   38,   38,  406,  288,  406,  161,  160,  159,  406,
+ /*   970 */   708,  406,    7,  406,  138,  406,  260,  406,  627,  627,
+ /*   980 */    26,   26,   27,   27,  681,  406,   29,   29,   39,   39,
+ /*   990 */    40,   40,   41,   41,   11,   11,  406,  708,  406,  692,
+ /*  1000 */   406,  163,   42,   42,  691,  406,  341,  406,  677,  406,
+ /*  1010 */   263,  406,  709,   97,   97,   43,   43,   44,   44,  406,
+ /*  1020 */   750,  406,   31,   31,   45,   45,   46,   46,   32,   32,
+ /*  1030 */   406, 1182,  406,  664,  406,  233,  112,  112,  113,  113,
+ /*  1040 */   406,  750,  858,  406,  750,  406,  844,  114,  114,   52,
+ /*  1050 */    52,   33,   33,  406,  857,  406,  680,   98,   98,  406,
+ /*  1060 */    49,   49,   99,   99,  406,  165,  709,  406,  750,  406,
+ /*  1070 */   100,  100,   96,   96,  169,  406,  111,  111,  406,  109,
+ /*  1080 */   406,  108,  108,  291,  104,  104,  103,  103,  406,  109,
+ /*  1090 */   193,  406,  101,  101,  406,  102,  102,   51,   51,  406,
+ /*  1100 */   367,  625,  687,  687,  292,   53,   53,  293,   50,   50,
+ /*  1110 */    24,   25,   25,  661,  627,  627,   28,   28,    1,  393,
+ /*  1120 */   107,  397,  627,  627,  631,  626,  289,  401,  403,  289,
+ /*  1130 */    66,  302,  175,  174,  109,  724,  725,   64,  890,  748,
+ /*  1140 */   334,  208,  208,  336,  808,  208,   66,  351,  631,  214,
+ /*  1150 */   855,  245,  109,   66,  109,  644,  644,  178,  654,  653,
+ /*  1160 */   109,  315,  689,  646,   69,  823,  718,  662,  208,  290,
+ /*  1170 */   816,  816,  812,  825,  214,  825,  629,  738,  106,  321,
+ /*  1180 */   760,  760,  227,  817,  168,  235,  843,  841,  338,  840,
+ /*  1190 */   153,  344,  345,  240,  620,  243,  356,  665,  649,  648,
+ /*  1200 */   158,  251,  248,  716,  749,  262,  392,  698,  814,  267,
+ /*  1210 */   813,  927,  268,  273,  872,  154,  135,  632,  618,  617,
+ /*  1220 */   124,  619,  869,  117,   64,  735,  324,   55,  329,  828,
+ /*  1230 */   126,  349,  232,  189,  196,  144,  128,  129,  197,  147,
+ /*  1240 */   362,  198,  130,  299,  668,  131,  667,  139,  347,  745,
+ /*  1250 */   646,  666,  283,  377,   63,    6,  845,   71,  211,  303,
+ /*  1260 */   640,   94,  284,   65,  659,  639,  382,  250,  380,  638,
+ /*  1270 */   881,   21,  658,  870,  224,  610,  613,  221,  223,  310,
+ /*  1280 */   408,  407,  615,  614,  611,  280,  179,  312,  395,  123,
+ /*  1290 */   181,  822,  399,  820,  183,  744,  115,  125,  120,  127,
+ /*  1300 */   188,  116,  678,  831,  208,  132,  133,  904,  328,  839,
+ /*  1310 */    56,  105,  204,  706,  134,  255,  136,  707,  257,   57,
+ /*  1320 */   705,  704,  269,  259,  261,  688,  270,  271,  272,   58,
+ /*  1330 */    59,  842,  194,  192,  838,  794,  121,   12,    8,  195,
+ /*  1340 */   148,  239,  623,  212,  213,  348,  252,  199,  140,  352,
+ /*  1350 */   246,  357,   60,   13,   14,  206,  686,   61,  118,  763,
+ /*  1360 */   762,  170,  712,  657,  792,   62,   15,  370,  690,    4,
+ /*  1370 */   717,  171,  173,  207,  142,   69,   66,   16,   17,  807,
+ /*  1380 */   793,  796,  791,  848,  607,  847,  388,  166,  394,  862,
+ /*  1390 */   276,  150,  215,  863,  151,  398,  387,  795,  152, 1164,
+ /*  1400 */   761,  630,   79,  909,  624,  909,  909,  909,  909,  909,
+ /*  1410 */   909,  909,  909,  909,  909,  909,  909,  909,  909,  909,
+ /*  1420 */   909,  909,  909,  909,  909,  909,  909,  909,  909,  216,
 };
 static const YYCODETYPE yy_lookahead[] = {
  /*     0 */     5,    6,    7,    8,    9,   10,   11,   12,   13,   14,
@@ -665,26 +667,28 @@ static const YYCODETYPE yy_lookahead[] = {
  /*  1210 */   163,  101,  143,  188,  146,  186,   47,  143,  143,  143,
  /*  1220 */   209,  143,  143,    5,  113,  189,   45,  121,  128,  225,
  /*  1230 */   177,   45,  224,  148,  148,   47,  180,  180,  148,  209,
- /*  1240 */    84,  148,  180,   63,   83,  180,  162,  177,  165,  177,
- /*  1250 */   106,  162,  165,   47,   84,  213,  189,  121,  215,  162,
- /*  1260 */    32,  112,  107,  165,  170,  164,   50,  162,  111,  162,
- /*  1270 */   162,  189,  170,  110,  162,   40,   35,    4,   36,  144,
- /*  1280 */     3,  165,  144,  150,  142,  142,   42,  142,  142,  141,
- /*  1290 */   153,   72,  165,   43,   84,   48,   48,  101,   99,  114,
- /*  1300 */   153,   88,  102,   46,   84,  127,  166,  166,   50,  127,
- /*  1310 */    84,    1,  129,  204,  130,  114,  203,  102,   16,  204,
- /*  1320 */   203,  189,  191,  193,  204,  203,  192,  204,  203,  190,
- /*  1330 */    16,   16,   16,   88,   52,  105,    1,  101,   34,  218,
- /*  1340 */    47,  124,   89,   84,  218,   49,   46,    7,   82,   66,
- /*  1350 */    47,   66,   47,   47,   66,   48,   47,   60,   47,   95,
- /*  1360 */    48,   48,   54,  101,  104,   48,   47,   47,   50,   48,
- /*  1370 */   105,   48,   50,   48,   47,  105,   52,  105,   50,   50,
- /*  1380 */    48,   48,   48,   38,   48,  101,   48,   50,   47,   50,
- /*  1390 */    48,   47,   49,    1,   48,   47,   49,   48,   47,    0,
- /*  1400 */    48,   75,   48,   47,   42,   48,
+ /*  1240 */    84,  148,  180,   63,  162,  180,  162,  177,  165,  177,
+ /*  1250 */    83,  162,  165,  106,   84,   47,  189,  121,  215,   32,
+ /*  1260 */   162,  112,  165,  111,  170,  164,  107,  162,  110,  162,
+ /*  1270 */   162,   50,  170,   40,   35,    4,   36,  144,  144,    3,
+ /*  1280 */   142,  150,  142,  142,  142,  141,   42,   72,  165,   43,
+ /*  1290 */    84,   48,  165,   48,  101,   99,  153,  114,   88,  102,
+ /*  1300 */    84,  153,   46,  127,   50,  127,   84,  130,  129,    1,
+ /*  1310 */    16,  166,  166,  204,  102,  203,  114,  204,  203,   16,
+ /*  1320 */   204,  204,  192,  203,  203,  193,  191,  190,  189,   16,
+ /*  1330 */    16,   52,  101,  105,    1,  213,   88,   47,   34,   84,
+ /*  1340 */    49,  124,   46,  218,  218,    7,   89,   82,   47,   66,
+ /*  1350 */    48,   66,   47,   47,   47,   66,   95,   47,   60,   48,
+ /*  1360 */    48,  101,  104,   54,   48,   50,   47,   50,   48,   47,
+ /*  1370 */    52,   48,   48,  105,   47,   50,   50,  105,  105,   48,
+ /*  1380 */    48,   38,   48,   48,    1,   48,   50,   47,   49,   48,
+ /*  1390 */    42,   47,   50,   48,   47,   49,   75,   48,   47,    0,
+ /*  1400 */    48,   48,   47,  230,   48,  230,  230,  230,  230,  230,
+ /*  1410 */   230,  230,  230,  230,  230,  230,  230,  230,  230,  230,
+ /*  1420 */   230,  230,  230,  230,  230,  230,  230,  230,  230,  101,
 };
-#define YY_SHIFT_USE_DFLT (1406)
-#define YY_SHIFT_COUNT    (411)
+#define YY_SHIFT_USE_DFLT (1430)
+#define YY_SHIFT_COUNT    (410)
 #define YY_SHIFT_MIN      (-88)
 #define YY_SHIFT_MAX      (1399)
 static const short yy_shift_ofst[] = {
@@ -699,11 +703,11 @@ static const short yy_shift_ofst[] = {
  /*    80 */   736,  736,  840,  736,  736,  736,  736,  736,  736,  736,
  /*    90 */   736,  736,  736,  736,  736,  736,   11,   30,   30,   30,
  /*   100 */    30,   30,  188,   37,   43,  861,  144,  144,  462,  485,
- /*   110 */   542,  -16, 1406, 1406, 1406,  581,  581,  565,  565,  821,
+ /*   110 */   542,  -16, 1430, 1430, 1430,  581,  581,  565,  565,  821,
  /*   120 */   601,  601,  473,  542,   88,  542,  542,  542,  542,  542,
  /*   130 */   542,  542,  542,  542,  542,  542,  542,  542,  542,  542,
  /*   140 */   542,  221,  542,  542,  542,  221,  485,  -88,  -88,  -88,
- /*   150 */   -88,  -88,  -88, 1406, 1406,  810,  195,  195,  237,  806,
+ /*   150 */   -88,  -88,  -88, 1430, 1430,  810,  195,  195,  237,  806,
  /*   160 */   806,  806,  217,  846,  829,  848,  739,  441,  752,  927,
  /*   170 */   557,  670,  670,  670, 1063,  962, 1071, 1006,  219,  542,
  /*   180 */   542,  542,  542,  542,  542, 1024,  174,  174,  542,  542,
@@ -711,28 +715,28 @@ static const short yy_shift_ofst[] = {
  /*   200 */  1080,  542,  983,  542,  880,  542, 1027,  542,  542,  174,
  /*   210 */   542,  784, 1027, 1027,  542,  542,  542, 1088,  904,  542,
  /*   220 */   890,  542,  542,  542,  542, 1169, 1218, 1111, 1181, 1181,
- /*   230 */  1181, 1181, 1106, 1100, 1186, 1111, 1169, 1218, 1218, 1111,
- /*   240 */  1186, 1188, 1186, 1186, 1188, 1156, 1156, 1156, 1180, 1188,
- /*   250 */  1156, 1161, 1156, 1180, 1156, 1156, 1144, 1170, 1144, 1170,
- /*   260 */  1144, 1170, 1144, 1170, 1206, 1136, 1188, 1228, 1228, 1188,
- /*   270 */  1149, 1155, 1157, 1163, 1111, 1216, 1235, 1235, 1241, 1241,
- /*   280 */  1241, 1241, 1242, 1406, 1406, 1406, 1406,  152,  816,  881,
- /*   290 */  1073,  734, 1091, 1092, 1095, 1096, 1099, 1103, 1104, 1081,
- /*   300 */  1077,  841, 1114, 1118, 1119, 1124,  795, 1058, 1128, 1129,
- /*   310 */  1110, 1273, 1277, 1244, 1219, 1250, 1210, 1247, 1248, 1196,
- /*   320 */  1199, 1185, 1213, 1200, 1220, 1257, 1178, 1258, 1182, 1184,
- /*   330 */  1183, 1226, 1310, 1215, 1201, 1302, 1314, 1315, 1316, 1245,
- /*   340 */  1282, 1230, 1236, 1335, 1304, 1293, 1259, 1217, 1296, 1300,
- /*   350 */  1340, 1253, 1266, 1303, 1283, 1305, 1306, 1307, 1309, 1285,
- /*   360 */  1308, 1311, 1288, 1297, 1312, 1313, 1317, 1318, 1264, 1319,
- /*   370 */  1321, 1320, 1322, 1262, 1323, 1325, 1324, 1265, 1327, 1260,
- /*   380 */  1328, 1270, 1329, 1272, 1332, 1328, 1333, 1334, 1336, 1326,
- /*   390 */  1337, 1338, 1341, 1345, 1342, 1344, 1343, 1339, 1346, 1348,
- /*   400 */  1347, 1339, 1349, 1351, 1352, 1354, 1356, 1284, 1357, 1362,
- /*   410 */  1392, 1399,
+ /*   230 */  1181, 1181, 1106, 1100, 1186, 1111, 1169, 1218, 1218, 1186,
+ /*   240 */  1188, 1186, 1186, 1188, 1156, 1156, 1156, 1180, 1188, 1156,
+ /*   250 */  1167, 1156, 1180, 1156, 1156, 1147, 1170, 1147, 1170, 1147,
+ /*   260 */  1170, 1147, 1170, 1208, 1136, 1188, 1227, 1227, 1188, 1149,
+ /*   270 */  1159, 1152, 1158, 1111, 1221, 1233, 1233, 1239, 1239, 1239,
+ /*   280 */  1239, 1240, 1430, 1430, 1430, 1430,  152,  816,  881, 1073,
+ /*   290 */   734, 1091, 1092, 1095, 1096, 1099, 1103, 1104, 1081, 1077,
+ /*   300 */   841, 1114, 1118, 1119, 1124,  795, 1058, 1128, 1129, 1110,
+ /*   310 */  1271, 1276, 1244, 1215, 1246, 1206, 1243, 1245, 1193, 1196,
+ /*   320 */  1183, 1210, 1197, 1216, 1256, 1176, 1254, 1178, 1177, 1179,
+ /*   330 */  1222, 1308, 1212, 1202, 1294, 1303, 1313, 1314, 1248, 1279,
+ /*   340 */  1228, 1231, 1333, 1304, 1290, 1255, 1217, 1291, 1296, 1338,
+ /*   350 */  1257, 1265, 1301, 1283, 1305, 1306, 1302, 1307, 1285, 1309,
+ /*   360 */  1310, 1289, 1298, 1311, 1312, 1316, 1315, 1261, 1319, 1320,
+ /*   370 */  1322, 1317, 1260, 1323, 1324, 1318, 1268, 1327, 1258, 1325,
+ /*   380 */  1272, 1326, 1273, 1331, 1325, 1332, 1334, 1335, 1321, 1336,
+ /*   390 */  1337, 1340, 1343, 1341, 1344, 1339, 1342, 1345, 1347, 1346,
+ /*   400 */  1342, 1349, 1351, 1352, 1353, 1355, 1328, 1356, 1348, 1383,
+ /*   410 */  1399,
 };
 #define YY_REDUCE_USE_DFLT (-110)
-#define YY_REDUCE_COUNT (286)
+#define YY_REDUCE_COUNT (285)
 #define YY_REDUCE_MIN   (-109)
 #define YY_REDUCE_MAX   (1148)
 static const short yy_reduce_ofst[] = {
@@ -759,56 +763,56 @@ static const short yy_reduce_ofst[] = {
  /*   200 */  1032, 1054, 1028, 1055, 1031, 1059, 1038, 1060, 1061, 1003,
  /*   210 */  1064,  990, 1045, 1047, 1066, 1069,  726, 1025, 1029, 1074,
  /*   220 */  1068, 1075, 1076, 1078, 1079, 1011, 1053, 1036, 1056, 1057,
- /*   230 */  1062, 1065, 1004, 1008, 1085, 1067, 1030, 1070, 1072, 1082,
- /*   240 */  1086, 1083, 1090, 1093, 1087, 1084, 1089, 1097, 1094, 1098,
- /*   250 */  1105, 1101, 1107, 1102, 1108, 1112, 1109, 1113, 1115, 1117,
- /*   260 */  1120, 1122, 1123, 1125, 1042, 1043, 1116, 1121, 1126, 1127,
- /*   270 */  1130, 1134, 1131, 1139, 1132, 1133, 1135, 1138, 1142, 1143,
- /*   280 */  1145, 1146, 1148, 1137, 1140, 1141, 1147,
+ /*   230 */  1062, 1065, 1004, 1008, 1085, 1067, 1030, 1070, 1072, 1086,
+ /*   240 */  1083, 1090, 1093, 1087, 1082, 1084, 1089, 1094, 1097, 1098,
+ /*   250 */  1101, 1105, 1102, 1107, 1108, 1109, 1112, 1113, 1115, 1116,
+ /*   260 */  1120, 1117, 1121, 1122, 1043, 1123, 1125, 1126, 1127, 1132,
+ /*   270 */  1130, 1135, 1137, 1139, 1131, 1133, 1134, 1138, 1140, 1141,
+ /*   280 */  1142, 1144, 1143, 1145, 1146, 1148,
 };
 static const YYACTIONTYPE yy_default[] = {
- /*     0 */  1166, 1160, 1160, 1160, 1104, 1104, 1104, 1104, 1160, 1000,
- /*    10 */  1027, 1027, 1208, 1208, 1208, 1208, 1208, 1208, 1103, 1208,
- /*    20 */  1208, 1208, 1208, 1160, 1004, 1033, 1208, 1208, 1208, 1105,
- /*    30 */  1106, 1208, 1208, 1208, 1138, 1043, 1042, 1041, 1040, 1014,
- /*    40 */  1038, 1031, 1035, 1105, 1099, 1100, 1098, 1102, 1106, 1208,
- /*    50 */  1034, 1068, 1083, 1067, 1208, 1208, 1208, 1208, 1208, 1208,
- /*    60 */  1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208,
- /*    70 */  1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208,
- /*    80 */  1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208,
- /*    90 */  1208, 1208, 1208, 1208, 1208, 1208, 1077, 1082, 1089, 1081,
- /*   100 */  1078, 1070, 1069, 1071, 1072,  971, 1208, 1208, 1073, 1208,
- /*   110 */  1208, 1074, 1086, 1085, 1084, 1175, 1174, 1208, 1208, 1111,
- /*   120 */  1208, 1208, 1208, 1208, 1160, 1208, 1208, 1208, 1208, 1208,
- /*   130 */  1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208,
- /*   140 */  1208,  929, 1208, 1208, 1208,  929, 1208, 1160, 1160, 1160,
- /*   150 */  1160, 1160, 1160, 1004,  995, 1208, 1208, 1208, 1208, 1208,
- /*   160 */  1208, 1208, 1208, 1000, 1208, 1208, 1208, 1208, 1133, 1208,
- /*   170 */  1208, 1000, 1000, 1000, 1208, 1002, 1208,  984,  994, 1208,
- /*   180 */  1157, 1208, 1154, 1208, 1125, 1037, 1016, 1016, 1208, 1208,
- /*   190 */  1207, 1037, 1208, 1207, 1208, 1208, 1208, 1208, 1208, 1208,
- /*   200 */   946, 1208, 1186, 1208,  943, 1208, 1027, 1208, 1208, 1016,
- /*   210 */  1208, 1101, 1027, 1027, 1208, 1208, 1208, 1001,  994, 1208,
- /*   220 */  1208, 1208, 1208, 1208, 1169, 1048,  974, 1037,  980,  980,
- /*   230 */   980,  980, 1137, 1204,  923, 1037, 1048,  974,  974, 1037,
- /*   240 */   923, 1112,  923,  923, 1112,  972,  972,  972,  961, 1112,
- /*   250 */   972,  946,  972,  961,  972,  972, 1020, 1015, 1020, 1015,
- /*   260 */  1020, 1015, 1020, 1015, 1107, 1208, 1112, 1116, 1116, 1112,
- /*   270 */  1032, 1021, 1030, 1028, 1037,  964, 1172, 1172, 1168, 1168,
- /*   280 */  1168, 1168,  913, 1181,  948,  948, 1181, 1208, 1208, 1208,
- /*   290 */  1176, 1119, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208,
- /*   300 */  1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208,
- /*   310 */  1054, 1208,  910, 1208, 1208, 1208, 1155, 1208, 1208, 1199,
- /*   320 */  1208, 1208, 1208, 1208, 1208, 1208, 1208, 1136, 1135, 1208,
- /*   330 */  1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208,
- /*   340 */  1208, 1208, 1206, 1208, 1208, 1208, 1208, 1208, 1208, 1208,
- /*   350 */  1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208,
- /*   360 */  1208, 1208, 1208, 1208, 1208, 1208, 1208, 1208,  986, 1208,
- /*   370 */  1208, 1208, 1190, 1208, 1208, 1208, 1208, 1208, 1208, 1208,
- /*   380 */  1029, 1208, 1022, 1208, 1208, 1196, 1208, 1208, 1208, 1208,
- /*   390 */  1208, 1208, 1208, 1208, 1208, 1208, 1208, 1162, 1208, 1208,
- /*   400 */  1208, 1161, 1208, 1208, 1208, 1208, 1208, 1208, 1208,  917,
- /*   410 */  1208, 1208,
+ /*     0 */  1165, 1159, 1159, 1159, 1103, 1103, 1103, 1103, 1159,  999,
+ /*    10 */  1026, 1026, 1207, 1207, 1207, 1207, 1207, 1207, 1102, 1207,
+ /*    20 */  1207, 1207, 1207, 1159, 1003, 1032, 1207, 1207, 1207, 1104,
+ /*    30 */  1105, 1207, 1207, 1207, 1137, 1042, 1041, 1040, 1039, 1013,
+ /*    40 */  1037, 1030, 1034, 1104, 1098, 1099, 1097, 1101, 1105, 1207,
+ /*    50 */  1033, 1067, 1082, 1066, 1207, 1207, 1207, 1207, 1207, 1207,
+ /*    60 */  1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207,
+ /*    70 */  1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207,
+ /*    80 */  1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207,
+ /*    90 */  1207, 1207, 1207, 1207, 1207, 1207, 1076, 1081, 1088, 1080,
+ /*   100 */  1077, 1069, 1068, 1070, 1071,  970, 1207, 1207, 1072, 1207,
+ /*   110 */  1207, 1073, 1085, 1084, 1083, 1174, 1173, 1207, 1207, 1110,
+ /*   120 */  1207, 1207, 1207, 1207, 1159, 1207, 1207, 1207, 1207, 1207,
+ /*   130 */  1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207,
+ /*   140 */  1207,  928, 1207, 1207, 1207,  928, 1207, 1159, 1159, 1159,
+ /*   150 */  1159, 1159, 1159, 1003,  994, 1207, 1207, 1207, 1207, 1207,
+ /*   160 */  1207, 1207, 1207,  999, 1207, 1207, 1207, 1207, 1132, 1207,
+ /*   170 */  1207,  999,  999,  999, 1207, 1001, 1207,  983,  993, 1207,
+ /*   180 */  1156, 1207, 1153, 1207, 1124, 1036, 1015, 1015, 1207, 1207,
+ /*   190 */  1206, 1036, 1207, 1206, 1207, 1207, 1207, 1207, 1207, 1207,
+ /*   200 */   945, 1207, 1185, 1207,  942, 1207, 1026, 1207, 1207, 1015,
+ /*   210 */  1207, 1100, 1026, 1026, 1207, 1207, 1207, 1000,  993, 1207,
+ /*   220 */  1207, 1207, 1207, 1207, 1168, 1047,  973, 1036,  979,  979,
+ /*   230 */   979,  979, 1136, 1203,  922, 1036, 1047,  973,  973,  922,
+ /*   240 */  1111,  922,  922, 1111,  971,  971,  971,  960, 1111,  971,
+ /*   250 */   945,  971,  960,  971,  971, 1019, 1014, 1019, 1014, 1019,
+ /*   260 */  1014, 1019, 1014, 1106, 1207, 1111, 1115, 1115, 1111, 1031,
+ /*   270 */  1020, 1029, 1027, 1036,  963, 1171, 1171, 1167, 1167, 1167,
+ /*   280 */  1167,  912, 1180,  947,  947, 1180, 1207, 1207, 1207, 1175,
+ /*   290 */  1118, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207,
+ /*   300 */  1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1053,
+ /*   310 */  1207,  909, 1207, 1207, 1207, 1154, 1207, 1207, 1198, 1207,
+ /*   320 */  1207, 1207, 1207, 1207, 1207, 1207, 1135, 1134, 1207, 1207,
+ /*   330 */  1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207,
+ /*   340 */  1207, 1205, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207,
+ /*   350 */  1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1207,
+ /*   360 */  1207, 1207, 1207, 1207, 1207, 1207, 1207,  985, 1207, 1207,
+ /*   370 */  1207, 1189, 1207, 1207, 1207, 1207, 1207, 1207, 1207, 1028,
+ /*   380 */  1207, 1021, 1207, 1207, 1195, 1207, 1207, 1207, 1207, 1207,
+ /*   390 */  1207, 1207, 1207, 1207, 1207, 1207, 1161, 1207, 1207, 1207,
+ /*   400 */  1160, 1207, 1207, 1207, 1207, 1207, 1207, 1207,  916, 1207,
+ /*   410 */  1207,
 };
 /********** End of lemon-generated parsing tables *****************************/
 
@@ -1254,7 +1258,7 @@ static const char *const yyRuleName[] = {
  /* 198 */ "nexprlist ::= expr",
  /* 199 */ "paren_exprlist ::=",
  /* 200 */ "paren_exprlist ::= LP exprlist RP",
- /* 201 */ "cmd ::= createkw uniqueflag INDEX ifnotexists nm ON nm LP sortlist RP where_opt",
+ /* 201 */ "cmd ::= createkw uniqueflag INDEX ifnotexists nm ON nm LP sortlist RP",
  /* 202 */ "uniqueflag ::= UNIQUE",
  /* 203 */ "uniqueflag ::=",
  /* 204 */ "eidlist_opt ::=",
@@ -1470,7 +1474,7 @@ static void yy_destructor(
 {
 #line 386 "parse.y"
 sqlite3SelectDelete(pParse->db, (yypminor->yy279));
-#line 1474 "parse.c"
+#line 1478 "parse.c"
 }
       break;
     case 160: /* term */
@@ -1478,7 +1482,7 @@ sqlite3SelectDelete(pParse->db, (yypminor->yy279));
 {
 #line 829 "parse.y"
 sqlite3ExprDelete(pParse->db, (yypminor->yy162).pExpr);
-#line 1482 "parse.c"
+#line 1486 "parse.c"
 }
       break;
     case 165: /* eidlist_opt */
@@ -1496,7 +1500,7 @@ sqlite3ExprDelete(pParse->db, (yypminor->yy162).pExpr);
 {
 #line 1261 "parse.y"
 sqlite3ExprListDelete(pParse->db, (yypminor->yy382));
-#line 1500 "parse.c"
+#line 1504 "parse.c"
 }
       break;
     case 181: /* fullname */
@@ -1506,7 +1510,7 @@ sqlite3ExprListDelete(pParse->db, (yypminor->yy382));
 {
 #line 613 "parse.y"
 sqlite3SrcListDelete(pParse->db, (yypminor->yy387));
-#line 1510 "parse.c"
+#line 1514 "parse.c"
 }
       break;
     case 184: /* with */
@@ -1514,7 +1518,7 @@ sqlite3SrcListDelete(pParse->db, (yypminor->yy387));
 {
 #line 1510 "parse.y"
 sqlite3WithDelete(pParse->db, (yypminor->yy151));
-#line 1518 "parse.c"
+#line 1522 "parse.c"
 }
       break;
     case 189: /* where_opt */
@@ -1526,7 +1530,7 @@ sqlite3WithDelete(pParse->db, (yypminor->yy151));
 {
 #line 738 "parse.y"
 sqlite3ExprDelete(pParse->db, (yypminor->yy362));
-#line 1530 "parse.c"
+#line 1534 "parse.c"
 }
       break;
     case 204: /* using_opt */
@@ -1535,7 +1539,7 @@ sqlite3ExprDelete(pParse->db, (yypminor->yy362));
 {
 #line 650 "parse.y"
 sqlite3IdListDelete(pParse->db, (yypminor->yy40));
-#line 1539 "parse.c"
+#line 1543 "parse.c"
 }
       break;
     case 221: /* trigger_cmd_list */
@@ -1543,14 +1547,14 @@ sqlite3IdListDelete(pParse->db, (yypminor->yy40));
 {
 #line 1384 "parse.y"
 sqlite3DeleteTriggerStep(pParse->db, (yypminor->yy427));
-#line 1547 "parse.c"
+#line 1551 "parse.c"
 }
       break;
     case 223: /* trigger_event */
 {
 #line 1370 "parse.y"
 sqlite3IdListDelete(pParse->db, (yypminor->yy10).b);
-#line 1554 "parse.c"
+#line 1558 "parse.c"
 }
       break;
 /********* End destructor definitions *****************************************/
@@ -1725,7 +1729,7 @@ static void yyStackOverflow(yyParser *yypParser){
 #line 41 "parse.y"
 
   sqlite3ErrorMsg(pParse, "parser stack overflow");
-#line 1729 "parse.c"
+#line 1733 "parse.c"
 /******** End %stack_overflow code ********************************************/
    sqlite3ParserARG_STORE; /* Suppress warning about unused %extra_argument var */
 }
@@ -2000,7 +2004,7 @@ static const struct {
   { 195, 1 },
   { 213, 0 },
   { 213, 3 },
-  { 140, 11 },
+  { 140, 10 },
   { 217, 1 },
   { 217, 0 },
   { 165, 0 },
@@ -2165,83 +2169,83 @@ static void yy_reduce(
       case 0: /* ecmd ::= explain cmdx SEMI */
 #line 111 "parse.y"
 { sqlite3FinishCoding(pParse); }
-#line 2169 "parse.c"
+#line 2173 "parse.c"
         break;
       case 1: /* ecmd ::= SEMI */
 #line 112 "parse.y"
 {
   sqlite3ErrorMsg(pParse, "syntax error: empty request");
 }
-#line 2176 "parse.c"
+#line 2180 "parse.c"
         break;
       case 2: /* explain ::= EXPLAIN */
 #line 117 "parse.y"
 { pParse->explain = 1; }
-#line 2181 "parse.c"
+#line 2185 "parse.c"
         break;
       case 3: /* explain ::= EXPLAIN QUERY PLAN */
 #line 118 "parse.y"
 { pParse->explain = 2; }
-#line 2186 "parse.c"
+#line 2190 "parse.c"
         break;
       case 4: /* cmd ::= BEGIN transtype trans_opt */
 #line 150 "parse.y"
 {sqlite3BeginTransaction(pParse, yymsp[-1].minor.yy52);}
-#line 2191 "parse.c"
+#line 2195 "parse.c"
         break;
       case 5: /* transtype ::= */
 #line 155 "parse.y"
 {yymsp[1].minor.yy52 = TK_DEFERRED;}
-#line 2196 "parse.c"
+#line 2200 "parse.c"
         break;
       case 6: /* transtype ::= DEFERRED */
 #line 156 "parse.y"
 {yymsp[0].minor.yy52 = yymsp[0].major; /*A-overwrites-X*/}
-#line 2201 "parse.c"
+#line 2205 "parse.c"
         break;
       case 7: /* cmd ::= COMMIT trans_opt */
       case 8: /* cmd ::= END trans_opt */ yytestcase(yyruleno==8);
 #line 157 "parse.y"
 {sqlite3CommitTransaction(pParse);}
-#line 2207 "parse.c"
+#line 2211 "parse.c"
         break;
       case 9: /* cmd ::= ROLLBACK trans_opt */
 #line 159 "parse.y"
 {sqlite3RollbackTransaction(pParse);}
-#line 2212 "parse.c"
+#line 2216 "parse.c"
         break;
       case 10: /* cmd ::= SAVEPOINT nm */
 #line 163 "parse.y"
 {
   sqlite3Savepoint(pParse, SAVEPOINT_BEGIN, &yymsp[0].minor.yy0);
 }
-#line 2219 "parse.c"
+#line 2223 "parse.c"
         break;
       case 11: /* cmd ::= RELEASE savepoint_opt nm */
 #line 166 "parse.y"
 {
   sqlite3Savepoint(pParse, SAVEPOINT_RELEASE, &yymsp[0].minor.yy0);
 }
-#line 2226 "parse.c"
+#line 2230 "parse.c"
         break;
       case 12: /* cmd ::= ROLLBACK trans_opt TO savepoint_opt nm */
 #line 169 "parse.y"
 {
   sqlite3Savepoint(pParse, SAVEPOINT_ROLLBACK, &yymsp[0].minor.yy0);
 }
-#line 2233 "parse.c"
+#line 2237 "parse.c"
         break;
       case 13: /* create_table ::= createkw TABLE ifnotexists nm */
 #line 176 "parse.y"
 {
    sqlite3StartTable(pParse,&yymsp[0].minor.yy0,yymsp[-1].minor.yy52);
 }
-#line 2240 "parse.c"
+#line 2244 "parse.c"
         break;
       case 14: /* createkw ::= CREATE */
 #line 179 "parse.y"
 {disableLookaside(pParse);}
-#line 2245 "parse.c"
+#line 2249 "parse.c"
         break;
       case 15: /* ifnotexists ::= */
       case 38: /* autoinc ::= */ yytestcase(yyruleno==38);
@@ -2252,19 +2256,19 @@ static void yy_reduce(
       case 208: /* collate ::= */ yytestcase(yyruleno==208);
 #line 182 "parse.y"
 {yymsp[1].minor.yy52 = 0;}
-#line 2256 "parse.c"
+#line 2260 "parse.c"
         break;
       case 16: /* ifnotexists ::= IF NOT EXISTS */
 #line 183 "parse.y"
 {yymsp[-2].minor.yy52 = 1;}
-#line 2261 "parse.c"
+#line 2265 "parse.c"
         break;
       case 17: /* create_table_args ::= LP columnlist conslist_opt RP */
 #line 185 "parse.y"
 {
   sqlite3EndTable(pParse,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy0,0,0);
 }
-#line 2268 "parse.c"
+#line 2272 "parse.c"
         break;
       case 18: /* create_table_args ::= AS select */
 #line 188 "parse.y"
@@ -2272,12 +2276,12 @@ static void yy_reduce(
   sqlite3EndTable(pParse,0,0,0,yymsp[0].minor.yy279);
   sqlite3SelectDelete(pParse->db, yymsp[0].minor.yy279);
 }
-#line 2276 "parse.c"
+#line 2280 "parse.c"
         break;
       case 19: /* columnname ::= nm typetoken */
 #line 194 "parse.y"
 {sqlite3AddColumn(pParse,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy0);}
-#line 2281 "parse.c"
+#line 2285 "parse.c"
         break;
       case 20: /* nm ::= ID|INDEXED */
 #line 225 "parse.y"
@@ -2286,50 +2290,50 @@ static void yy_reduce(
     sqlite3ErrorMsg(pParse, "keyword \"%T\" is reserved", &yymsp[0].minor.yy0);
   }
 }
-#line 2290 "parse.c"
+#line 2294 "parse.c"
         break;
       case 21: /* typetoken ::= */
       case 56: /* conslist_opt ::= */ yytestcase(yyruleno==56);
       case 92: /* as ::= */ yytestcase(yyruleno==92);
 #line 236 "parse.y"
 {yymsp[1].minor.yy0.n = 0; yymsp[1].minor.yy0.z = 0;}
-#line 2297 "parse.c"
+#line 2301 "parse.c"
         break;
       case 22: /* typetoken ::= typename LP signed RP */
 #line 238 "parse.y"
 {
   yymsp[-3].minor.yy0.n = (int)(&yymsp[0].minor.yy0.z[yymsp[0].minor.yy0.n] - yymsp[-3].minor.yy0.z);
 }
-#line 2304 "parse.c"
+#line 2308 "parse.c"
         break;
       case 23: /* typetoken ::= typename LP signed COMMA signed RP */
 #line 241 "parse.y"
 {
   yymsp[-5].minor.yy0.n = (int)(&yymsp[0].minor.yy0.z[yymsp[0].minor.yy0.n] - yymsp[-5].minor.yy0.z);
 }
-#line 2311 "parse.c"
+#line 2315 "parse.c"
         break;
       case 24: /* typename ::= typename ID|STRING */
 #line 246 "parse.y"
 {yymsp[-1].minor.yy0.n=yymsp[0].minor.yy0.n+(int)(yymsp[0].minor.yy0.z-yymsp[-1].minor.yy0.z);}
-#line 2316 "parse.c"
+#line 2320 "parse.c"
         break;
       case 25: /* ccons ::= CONSTRAINT nm */
       case 58: /* tcons ::= CONSTRAINT nm */ yytestcase(yyruleno==58);
 #line 255 "parse.y"
 {pParse->constraintName = yymsp[0].minor.yy0;}
-#line 2322 "parse.c"
+#line 2326 "parse.c"
         break;
       case 26: /* ccons ::= DEFAULT term */
       case 28: /* ccons ::= DEFAULT PLUS term */ yytestcase(yyruleno==28);
 #line 256 "parse.y"
 {sqlite3AddDefaultValue(pParse,&yymsp[0].minor.yy162);}
-#line 2328 "parse.c"
+#line 2332 "parse.c"
         break;
       case 27: /* ccons ::= DEFAULT LP expr RP */
 #line 257 "parse.y"
 {sqlite3AddDefaultValue(pParse,&yymsp[-1].minor.yy162);}
-#line 2333 "parse.c"
+#line 2337 "parse.c"
         break;
       case 29: /* ccons ::= DEFAULT MINUS term */
 #line 259 "parse.y"
@@ -2340,7 +2344,7 @@ static void yy_reduce(
   v.zEnd = yymsp[0].minor.yy162.zEnd;
   sqlite3AddDefaultValue(pParse,&v);
 }
-#line 2344 "parse.c"
+#line 2348 "parse.c"
         break;
       case 30: /* ccons ::= DEFAULT ID|INDEXED */
 #line 266 "parse.y"
@@ -2349,115 +2353,115 @@ static void yy_reduce(
   spanExpr(&v, pParse, TK_STRING, yymsp[0].minor.yy0);
   sqlite3AddDefaultValue(pParse,&v);
 }
-#line 2353 "parse.c"
+#line 2357 "parse.c"
         break;
       case 31: /* ccons ::= NOT NULL onconf */
 #line 276 "parse.y"
 {sqlite3AddNotNull(pParse, yymsp[0].minor.yy52);}
-#line 2358 "parse.c"
+#line 2362 "parse.c"
         break;
       case 32: /* ccons ::= PRIMARY KEY sortorder onconf autoinc */
 #line 278 "parse.y"
 {sqlite3AddPrimaryKey(pParse,0,yymsp[-1].minor.yy52,yymsp[0].minor.yy52,yymsp[-2].minor.yy52);}
-#line 2363 "parse.c"
+#line 2367 "parse.c"
         break;
       case 33: /* ccons ::= UNIQUE onconf */
 #line 279 "parse.y"
 {sqlite3CreateIndex(pParse,0,0,0,yymsp[0].minor.yy52,0,0,0,0,
                                    SQLITE_IDXTYPE_UNIQUE);}
-#line 2369 "parse.c"
+#line 2373 "parse.c"
         break;
       case 34: /* ccons ::= CHECK LP expr RP */
 #line 281 "parse.y"
 {sqlite3AddCheckConstraint(pParse,yymsp[-1].minor.yy162.pExpr);}
-#line 2374 "parse.c"
+#line 2378 "parse.c"
         break;
       case 35: /* ccons ::= REFERENCES nm eidlist_opt refargs */
 #line 283 "parse.y"
 {sqlite3CreateForeignKey(pParse,0,&yymsp[-2].minor.yy0,yymsp[-1].minor.yy382,yymsp[0].minor.yy52);}
-#line 2379 "parse.c"
+#line 2383 "parse.c"
         break;
       case 36: /* ccons ::= defer_subclause */
 #line 284 "parse.y"
 {sqlite3DeferForeignKey(pParse,yymsp[0].minor.yy52);}
-#line 2384 "parse.c"
+#line 2388 "parse.c"
         break;
       case 37: /* ccons ::= COLLATE ID|INDEXED */
 #line 285 "parse.y"
 {sqlite3AddCollateType(pParse, &yymsp[0].minor.yy0);}
-#line 2389 "parse.c"
+#line 2393 "parse.c"
         break;
       case 39: /* autoinc ::= AUTOINCR */
 #line 290 "parse.y"
 {yymsp[0].minor.yy52 = 1;}
-#line 2394 "parse.c"
+#line 2398 "parse.c"
         break;
       case 40: /* refargs ::= */
 #line 298 "parse.y"
 { yymsp[1].minor.yy52 = ON_CONFLICT_ACTION_NONE*0x0101; /* EV: R-19803-45884 */}
-#line 2399 "parse.c"
+#line 2403 "parse.c"
         break;
       case 41: /* refargs ::= refargs refarg */
 #line 299 "parse.y"
 { yymsp[-1].minor.yy52 = (yymsp[-1].minor.yy52 & ~yymsp[0].minor.yy107.mask) | yymsp[0].minor.yy107.value; }
-#line 2404 "parse.c"
+#line 2408 "parse.c"
         break;
       case 42: /* refarg ::= MATCH nm */
 #line 301 "parse.y"
 { yymsp[-1].minor.yy107.value = 0;     yymsp[-1].minor.yy107.mask = 0x000000; }
-#line 2409 "parse.c"
+#line 2413 "parse.c"
         break;
       case 43: /* refarg ::= ON INSERT refact */
 #line 302 "parse.y"
 { yymsp[-2].minor.yy107.value = 0;     yymsp[-2].minor.yy107.mask = 0x000000; }
-#line 2414 "parse.c"
+#line 2418 "parse.c"
         break;
       case 44: /* refarg ::= ON DELETE refact */
 #line 303 "parse.y"
 { yymsp[-2].minor.yy107.value = yymsp[0].minor.yy52;     yymsp[-2].minor.yy107.mask = 0x0000ff; }
-#line 2419 "parse.c"
+#line 2423 "parse.c"
         break;
       case 45: /* refarg ::= ON UPDATE refact */
 #line 304 "parse.y"
 { yymsp[-2].minor.yy107.value = yymsp[0].minor.yy52<<8;  yymsp[-2].minor.yy107.mask = 0x00ff00; }
-#line 2424 "parse.c"
+#line 2428 "parse.c"
         break;
       case 46: /* refact ::= SET NULL */
 #line 306 "parse.y"
 { yymsp[-1].minor.yy52 = OE_SetNull;  /* EV: R-33326-45252 */}
-#line 2429 "parse.c"
+#line 2433 "parse.c"
         break;
       case 47: /* refact ::= SET DEFAULT */
 #line 307 "parse.y"
 { yymsp[-1].minor.yy52 = OE_SetDflt;  /* EV: R-33326-45252 */}
-#line 2434 "parse.c"
+#line 2438 "parse.c"
         break;
       case 48: /* refact ::= CASCADE */
 #line 308 "parse.y"
 { yymsp[0].minor.yy52 = OE_Cascade;  /* EV: R-33326-45252 */}
-#line 2439 "parse.c"
+#line 2443 "parse.c"
         break;
       case 49: /* refact ::= RESTRICT */
 #line 309 "parse.y"
 { yymsp[0].minor.yy52 = OE_Restrict; /* EV: R-33326-45252 */}
-#line 2444 "parse.c"
+#line 2448 "parse.c"
         break;
       case 50: /* refact ::= NO ACTION */
 #line 310 "parse.y"
 { yymsp[-1].minor.yy52 = ON_CONFLICT_ACTION_NONE;     /* EV: R-33326-45252 */}
-#line 2449 "parse.c"
+#line 2453 "parse.c"
         break;
       case 51: /* defer_subclause ::= NOT DEFERRABLE init_deferred_pred_opt */
 #line 312 "parse.y"
 {yymsp[-2].minor.yy52 = 0;}
-#line 2454 "parse.c"
+#line 2458 "parse.c"
         break;
       case 52: /* defer_subclause ::= DEFERRABLE init_deferred_pred_opt */
       case 67: /* orconf ::= OR resolvetype */ yytestcase(yyruleno==67);
       case 138: /* insert_cmd ::= INSERT orconf */ yytestcase(yyruleno==138);
 #line 313 "parse.y"
 {yymsp[-1].minor.yy52 = yymsp[0].minor.yy52;}
-#line 2461 "parse.c"
+#line 2465 "parse.c"
         break;
       case 54: /* init_deferred_pred_opt ::= INITIALLY DEFERRED */
       case 71: /* ifexists ::= IF EXISTS */ yytestcase(yyruleno==71);
@@ -2466,33 +2470,33 @@ static void yy_reduce(
       case 209: /* collate ::= COLLATE ID|INDEXED */ yytestcase(yyruleno==209);
 #line 316 "parse.y"
 {yymsp[-1].minor.yy52 = 1;}
-#line 2470 "parse.c"
+#line 2474 "parse.c"
         break;
       case 55: /* init_deferred_pred_opt ::= INITIALLY IMMEDIATE */
 #line 317 "parse.y"
 {yymsp[-1].minor.yy52 = 0;}
-#line 2475 "parse.c"
+#line 2479 "parse.c"
         break;
       case 57: /* tconscomma ::= COMMA */
 #line 323 "parse.y"
 {pParse->constraintName.n = 0;}
-#line 2480 "parse.c"
+#line 2484 "parse.c"
         break;
       case 59: /* tcons ::= PRIMARY KEY LP sortlist autoinc RP onconf */
 #line 327 "parse.y"
 {sqlite3AddPrimaryKey(pParse,yymsp[-3].minor.yy382,yymsp[0].minor.yy52,yymsp[-2].minor.yy52,0);}
-#line 2485 "parse.c"
+#line 2489 "parse.c"
         break;
       case 60: /* tcons ::= UNIQUE LP sortlist RP onconf */
 #line 329 "parse.y"
 {sqlite3CreateIndex(pParse,0,0,yymsp[-2].minor.yy382,yymsp[0].minor.yy52,0,0,0,0,
                                        SQLITE_IDXTYPE_UNIQUE);}
-#line 2491 "parse.c"
+#line 2495 "parse.c"
         break;
       case 61: /* tcons ::= CHECK LP expr RP onconf */
 #line 332 "parse.y"
 {sqlite3AddCheckConstraint(pParse,yymsp[-2].minor.yy162.pExpr);}
-#line 2496 "parse.c"
+#line 2500 "parse.c"
         break;
       case 62: /* tcons ::= FOREIGN KEY LP eidlist RP REFERENCES nm eidlist_opt refargs defer_subclause_opt */
 #line 334 "parse.y"
@@ -2500,50 +2504,50 @@ static void yy_reduce(
     sqlite3CreateForeignKey(pParse, yymsp[-6].minor.yy382, &yymsp[-3].minor.yy0, yymsp[-2].minor.yy382, yymsp[-1].minor.yy52);
     sqlite3DeferForeignKey(pParse, yymsp[0].minor.yy52);
 }
-#line 2504 "parse.c"
+#line 2508 "parse.c"
         break;
       case 64: /* onconf ::= */
       case 66: /* orconf ::= */ yytestcase(yyruleno==66);
 #line 348 "parse.y"
 {yymsp[1].minor.yy52 = ON_CONFLICT_ACTION_DEFAULT;}
-#line 2510 "parse.c"
+#line 2514 "parse.c"
         break;
       case 65: /* onconf ::= ON CONFLICT resolvetype */
 #line 349 "parse.y"
 {yymsp[-2].minor.yy52 = yymsp[0].minor.yy52;}
-#line 2515 "parse.c"
+#line 2519 "parse.c"
         break;
       case 68: /* resolvetype ::= IGNORE */
 #line 353 "parse.y"
 {yymsp[0].minor.yy52 = ON_CONFLICT_ACTION_IGNORE;}
-#line 2520 "parse.c"
+#line 2524 "parse.c"
         break;
       case 69: /* resolvetype ::= REPLACE */
       case 139: /* insert_cmd ::= REPLACE */ yytestcase(yyruleno==139);
 #line 354 "parse.y"
 {yymsp[0].minor.yy52 = ON_CONFLICT_ACTION_REPLACE;}
-#line 2526 "parse.c"
+#line 2530 "parse.c"
         break;
       case 70: /* cmd ::= DROP TABLE ifexists fullname */
 #line 358 "parse.y"
 {
   sqlite3DropTable(pParse, yymsp[0].minor.yy387, 0, yymsp[-1].minor.yy52);
 }
-#line 2533 "parse.c"
+#line 2537 "parse.c"
         break;
       case 73: /* cmd ::= createkw VIEW ifnotexists nm eidlist_opt AS select */
 #line 369 "parse.y"
 {
   sqlite3CreateView(pParse, &yymsp[-6].minor.yy0, &yymsp[-3].minor.yy0, yymsp[-2].minor.yy382, yymsp[0].minor.yy279, yymsp[-4].minor.yy52);
 }
-#line 2540 "parse.c"
+#line 2544 "parse.c"
         break;
       case 74: /* cmd ::= DROP VIEW ifexists fullname */
 #line 372 "parse.y"
 {
   sqlite3DropTable(pParse, yymsp[0].minor.yy387, 1, yymsp[-1].minor.yy52);
 }
-#line 2547 "parse.c"
+#line 2551 "parse.c"
         break;
       case 75: /* cmd ::= select */
 #line 379 "parse.y"
@@ -2552,7 +2556,7 @@ static void yy_reduce(
   sqlite3Select(pParse, yymsp[0].minor.yy279, &dest);
   sqlite3SelectDelete(pParse->db, yymsp[0].minor.yy279);
 }
-#line 2556 "parse.c"
+#line 2560 "parse.c"
         break;
       case 76: /* select ::= with selectnowith */
 #line 416 "parse.y"
@@ -2566,7 +2570,7 @@ static void yy_reduce(
   }
   yymsp[-1].minor.yy279 = p; /*A-overwrites-W*/
 }
-#line 2570 "parse.c"
+#line 2574 "parse.c"
         break;
       case 77: /* selectnowith ::= selectnowith multiselect_op oneselect */
 #line 429 "parse.y"
@@ -2592,18 +2596,18 @@ static void yy_reduce(
   }
   yymsp[-2].minor.yy279 = pRhs;
 }
-#line 2596 "parse.c"
+#line 2600 "parse.c"
         break;
       case 78: /* multiselect_op ::= UNION */
       case 80: /* multiselect_op ::= EXCEPT|INTERSECT */ yytestcase(yyruleno==80);
 #line 452 "parse.y"
 {yymsp[0].minor.yy52 = yymsp[0].major; /*A-overwrites-OP*/}
-#line 2602 "parse.c"
+#line 2606 "parse.c"
         break;
       case 79: /* multiselect_op ::= UNION ALL */
 #line 453 "parse.y"
 {yymsp[-1].minor.yy52 = TK_ALL;}
-#line 2607 "parse.c"
+#line 2611 "parse.c"
         break;
       case 81: /* oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt */
 #line 457 "parse.y"
@@ -2637,14 +2641,14 @@ static void yy_reduce(
   }
 #endif /* SELECTRACE_ENABLED */
 }
-#line 2641 "parse.c"
+#line 2645 "parse.c"
         break;
       case 82: /* values ::= VALUES LP nexprlist RP */
 #line 491 "parse.y"
 {
   yymsp[-3].minor.yy279 = sqlite3SelectNew(pParse,yymsp[-1].minor.yy382,0,0,0,0,0,SF_Values,0,0);
 }
-#line 2648 "parse.c"
+#line 2652 "parse.c"
         break;
       case 83: /* values ::= values COMMA LP exprlist RP */
 #line 494 "parse.y"
@@ -2660,17 +2664,17 @@ static void yy_reduce(
     yymsp[-4].minor.yy279 = pLeft;
   }
 }
-#line 2664 "parse.c"
+#line 2668 "parse.c"
         break;
       case 84: /* distinct ::= DISTINCT */
 #line 511 "parse.y"
 {yymsp[0].minor.yy52 = SF_Distinct;}
-#line 2669 "parse.c"
+#line 2673 "parse.c"
         break;
       case 85: /* distinct ::= ALL */
 #line 512 "parse.y"
 {yymsp[0].minor.yy52 = SF_All;}
-#line 2674 "parse.c"
+#line 2678 "parse.c"
         break;
       case 87: /* sclp ::= */
       case 113: /* orderby_opt ::= */ yytestcase(yyruleno==113);
@@ -2680,7 +2684,7 @@ static void yy_reduce(
       case 204: /* eidlist_opt ::= */ yytestcase(yyruleno==204);
 #line 525 "parse.y"
 {yymsp[1].minor.yy382 = 0;}
-#line 2684 "parse.c"
+#line 2688 "parse.c"
         break;
       case 88: /* selcollist ::= sclp expr as */
 #line 526 "parse.y"
@@ -2689,7 +2693,7 @@ static void yy_reduce(
    if( yymsp[0].minor.yy0.n>0 ) sqlite3ExprListSetName(pParse, yymsp[-2].minor.yy382, &yymsp[0].minor.yy0, 1);
    sqlite3ExprListSetSpan(pParse,yymsp[-2].minor.yy382,&yymsp[-1].minor.yy162);
 }
-#line 2693 "parse.c"
+#line 2697 "parse.c"
         break;
       case 89: /* selcollist ::= sclp STAR */
 #line 531 "parse.y"
@@ -2697,7 +2701,7 @@ static void yy_reduce(
   Expr *p = sqlite3Expr(pParse->db, TK_ASTERISK, 0);
   yymsp[-1].minor.yy382 = sqlite3ExprListAppend(pParse, yymsp[-1].minor.yy382, p);
 }
-#line 2701 "parse.c"
+#line 2705 "parse.c"
         break;
       case 90: /* selcollist ::= sclp nm DOT STAR */
 #line 535 "parse.y"
@@ -2707,19 +2711,19 @@ static void yy_reduce(
   Expr *pDot = sqlite3PExpr(pParse, TK_DOT, pLeft, pRight);
   yymsp[-3].minor.yy382 = sqlite3ExprListAppend(pParse,yymsp[-3].minor.yy382, pDot);
 }
-#line 2711 "parse.c"
+#line 2715 "parse.c"
         break;
       case 91: /* as ::= AS nm */
       case 218: /* plus_num ::= PLUS INTEGER|FLOAT */ yytestcase(yyruleno==218);
       case 219: /* minus_num ::= MINUS INTEGER|FLOAT */ yytestcase(yyruleno==219);
 #line 546 "parse.y"
 {yymsp[-1].minor.yy0 = yymsp[0].minor.yy0;}
-#line 2718 "parse.c"
+#line 2722 "parse.c"
         break;
       case 93: /* from ::= */
 #line 560 "parse.y"
 {yymsp[1].minor.yy387 = sqlite3DbMallocZero(pParse->db, sizeof(*yymsp[1].minor.yy387));}
-#line 2723 "parse.c"
+#line 2727 "parse.c"
         break;
       case 94: /* from ::= FROM seltablist */
 #line 561 "parse.y"
@@ -2727,19 +2731,19 @@ static void yy_reduce(
   yymsp[-1].minor.yy387 = yymsp[0].minor.yy387;
   sqlite3SrcListShiftJoinType(yymsp[-1].minor.yy387);
 }
-#line 2731 "parse.c"
+#line 2735 "parse.c"
         break;
       case 95: /* stl_prefix ::= seltablist joinop */
 #line 569 "parse.y"
 {
    if( ALWAYS(yymsp[-1].minor.yy387 && yymsp[-1].minor.yy387->nSrc>0) ) yymsp[-1].minor.yy387->a[yymsp[-1].minor.yy387->nSrc-1].fg.jointype = (u8)yymsp[0].minor.yy52;
 }
-#line 2738 "parse.c"
+#line 2742 "parse.c"
         break;
       case 96: /* stl_prefix ::= */
 #line 572 "parse.y"
 {yymsp[1].minor.yy387 = 0;}
-#line 2743 "parse.c"
+#line 2747 "parse.c"
         break;
       case 97: /* seltablist ::= stl_prefix nm as indexed_opt on_opt using_opt */
 #line 574 "parse.y"
@@ -2747,7 +2751,7 @@ static void yy_reduce(
   yymsp[-5].minor.yy387 = sqlite3SrcListAppendFromTerm(pParse,yymsp[-5].minor.yy387,&yymsp[-4].minor.yy0,&yymsp[-3].minor.yy0,0,yymsp[-1].minor.yy362,yymsp[0].minor.yy40);
   sqlite3SrcListIndexedBy(pParse, yymsp[-5].minor.yy387, &yymsp[-2].minor.yy0);
 }
-#line 2751 "parse.c"
+#line 2755 "parse.c"
         break;
       case 98: /* seltablist ::= stl_prefix nm LP exprlist RP as on_opt using_opt */
 #line 579 "parse.y"
@@ -2755,14 +2759,14 @@ static void yy_reduce(
   yymsp[-7].minor.yy387 = sqlite3SrcListAppendFromTerm(pParse,yymsp[-7].minor.yy387,&yymsp[-6].minor.yy0,&yymsp[-2].minor.yy0,0,yymsp[-1].minor.yy362,yymsp[0].minor.yy40);
   sqlite3SrcListFuncArgs(pParse, yymsp[-7].minor.yy387, yymsp[-4].minor.yy382);
 }
-#line 2759 "parse.c"
+#line 2763 "parse.c"
         break;
       case 99: /* seltablist ::= stl_prefix LP select RP as on_opt using_opt */
 #line 585 "parse.y"
 {
     yymsp[-6].minor.yy387 = sqlite3SrcListAppendFromTerm(pParse,yymsp[-6].minor.yy387,0,&yymsp[-2].minor.yy0,yymsp[-4].minor.yy279,yymsp[-1].minor.yy362,yymsp[0].minor.yy40);
   }
-#line 2766 "parse.c"
+#line 2770 "parse.c"
         break;
       case 100: /* seltablist ::= stl_prefix LP seltablist RP as on_opt using_opt */
 #line 589 "parse.y"
@@ -2787,32 +2791,32 @@ static void yy_reduce(
       yymsp[-6].minor.yy387 = sqlite3SrcListAppendFromTerm(pParse,yymsp[-6].minor.yy387,0,&yymsp[-2].minor.yy0,pSubquery,yymsp[-1].minor.yy362,yymsp[0].minor.yy40);
     }
   }
-#line 2791 "parse.c"
+#line 2795 "parse.c"
         break;
       case 101: /* fullname ::= nm */
 #line 615 "parse.y"
 {yymsp[0].minor.yy387 = sqlite3SrcListAppend(pParse->db,0,&yymsp[0].minor.yy0); /*A-overwrites-X*/}
-#line 2796 "parse.c"
+#line 2800 "parse.c"
         break;
       case 102: /* joinop ::= COMMA|JOIN */
 #line 621 "parse.y"
 { yymsp[0].minor.yy52 = JT_INNER; }
-#line 2801 "parse.c"
+#line 2805 "parse.c"
         break;
       case 103: /* joinop ::= JOIN_KW JOIN */
 #line 623 "parse.y"
 {yymsp[-1].minor.yy52 = sqlite3JoinType(pParse,&yymsp[-1].minor.yy0,0,0);  /*X-overwrites-A*/}
-#line 2806 "parse.c"
+#line 2810 "parse.c"
         break;
       case 104: /* joinop ::= JOIN_KW join_nm JOIN */
 #line 625 "parse.y"
 {yymsp[-2].minor.yy52 = sqlite3JoinType(pParse,&yymsp[-2].minor.yy0,&yymsp[-1].minor.yy0,0); /*X-overwrites-A*/}
-#line 2811 "parse.c"
+#line 2815 "parse.c"
         break;
       case 105: /* joinop ::= JOIN_KW join_nm join_nm JOIN */
 #line 627 "parse.y"
 {yymsp[-3].minor.yy52 = sqlite3JoinType(pParse,&yymsp[-3].minor.yy0,&yymsp[-2].minor.yy0,&yymsp[-1].minor.yy0);/*X-overwrites-A*/}
-#line 2816 "parse.c"
+#line 2820 "parse.c"
         break;
       case 106: /* on_opt ::= ON expr */
       case 123: /* having_opt ::= HAVING expr */ yytestcase(yyruleno==123);
@@ -2820,7 +2824,7 @@ static void yy_reduce(
       case 192: /* case_else ::= ELSE expr */ yytestcase(yyruleno==192);
 #line 631 "parse.y"
 {yymsp[-1].minor.yy362 = yymsp[0].minor.yy162.pExpr;}
-#line 2824 "parse.c"
+#line 2828 "parse.c"
         break;
       case 107: /* on_opt ::= */
       case 122: /* having_opt ::= */ yytestcase(yyruleno==122);
@@ -2829,39 +2833,39 @@ static void yy_reduce(
       case 195: /* case_operand ::= */ yytestcase(yyruleno==195);
 #line 632 "parse.y"
 {yymsp[1].minor.yy362 = 0;}
-#line 2833 "parse.c"
+#line 2837 "parse.c"
         break;
       case 108: /* indexed_opt ::= */
 #line 645 "parse.y"
 {yymsp[1].minor.yy0.z=0; yymsp[1].minor.yy0.n=0;}
-#line 2838 "parse.c"
+#line 2842 "parse.c"
         break;
       case 109: /* indexed_opt ::= INDEXED BY nm */
 #line 646 "parse.y"
 {yymsp[-2].minor.yy0 = yymsp[0].minor.yy0;}
-#line 2843 "parse.c"
+#line 2847 "parse.c"
         break;
       case 110: /* indexed_opt ::= NOT INDEXED */
 #line 647 "parse.y"
 {yymsp[-1].minor.yy0.z=0; yymsp[-1].minor.yy0.n=1;}
-#line 2848 "parse.c"
+#line 2852 "parse.c"
         break;
       case 111: /* using_opt ::= USING LP idlist RP */
 #line 651 "parse.y"
 {yymsp[-3].minor.yy40 = yymsp[-1].minor.yy40;}
-#line 2853 "parse.c"
+#line 2857 "parse.c"
         break;
       case 112: /* using_opt ::= */
       case 140: /* idlist_opt ::= */ yytestcase(yyruleno==140);
 #line 652 "parse.y"
 {yymsp[1].minor.yy40 = 0;}
-#line 2859 "parse.c"
+#line 2863 "parse.c"
         break;
       case 114: /* orderby_opt ::= ORDER BY sortlist */
       case 121: /* groupby_opt ::= GROUP BY nexprlist */ yytestcase(yyruleno==121);
 #line 666 "parse.y"
 {yymsp[-2].minor.yy382 = yymsp[0].minor.yy382;}
-#line 2865 "parse.c"
+#line 2869 "parse.c"
         break;
       case 115: /* sortlist ::= sortlist COMMA expr sortorder */
 #line 667 "parse.y"
@@ -2869,7 +2873,7 @@ static void yy_reduce(
   yymsp[-3].minor.yy382 = sqlite3ExprListAppend(pParse,yymsp[-3].minor.yy382,yymsp[-1].minor.yy162.pExpr);
   sqlite3ExprListSetSortOrder(yymsp[-3].minor.yy382,yymsp[0].minor.yy52);
 }
-#line 2873 "parse.c"
+#line 2877 "parse.c"
         break;
       case 116: /* sortlist ::= expr sortorder */
 #line 671 "parse.y"
@@ -2877,42 +2881,42 @@ static void yy_reduce(
   yymsp[-1].minor.yy382 = sqlite3ExprListAppend(pParse,0,yymsp[-1].minor.yy162.pExpr); /*A-overwrites-Y*/
   sqlite3ExprListSetSortOrder(yymsp[-1].minor.yy382,yymsp[0].minor.yy52);
 }
-#line 2881 "parse.c"
+#line 2885 "parse.c"
         break;
       case 117: /* sortorder ::= ASC */
 #line 678 "parse.y"
 {yymsp[0].minor.yy52 = SQLITE_SO_ASC;}
-#line 2886 "parse.c"
+#line 2890 "parse.c"
         break;
       case 118: /* sortorder ::= DESC */
 #line 679 "parse.y"
 {yymsp[0].minor.yy52 = SQLITE_SO_DESC;}
-#line 2891 "parse.c"
+#line 2895 "parse.c"
         break;
       case 119: /* sortorder ::= */
 #line 680 "parse.y"
 {yymsp[1].minor.yy52 = SQLITE_SO_UNDEFINED;}
-#line 2896 "parse.c"
+#line 2900 "parse.c"
         break;
       case 124: /* limit_opt ::= */
 #line 705 "parse.y"
 {yymsp[1].minor.yy384.pLimit = 0; yymsp[1].minor.yy384.pOffset = 0;}
-#line 2901 "parse.c"
+#line 2905 "parse.c"
         break;
       case 125: /* limit_opt ::= LIMIT expr */
 #line 706 "parse.y"
 {yymsp[-1].minor.yy384.pLimit = yymsp[0].minor.yy162.pExpr; yymsp[-1].minor.yy384.pOffset = 0;}
-#line 2906 "parse.c"
+#line 2910 "parse.c"
         break;
       case 126: /* limit_opt ::= LIMIT expr OFFSET expr */
 #line 708 "parse.y"
 {yymsp[-3].minor.yy384.pLimit = yymsp[-2].minor.yy162.pExpr; yymsp[-3].minor.yy384.pOffset = yymsp[0].minor.yy162.pExpr;}
-#line 2911 "parse.c"
+#line 2915 "parse.c"
         break;
       case 127: /* limit_opt ::= LIMIT expr COMMA expr */
 #line 710 "parse.y"
 {yymsp[-3].minor.yy384.pOffset = yymsp[-2].minor.yy162.pExpr; yymsp[-3].minor.yy384.pLimit = yymsp[0].minor.yy162.pExpr;}
-#line 2916 "parse.c"
+#line 2920 "parse.c"
         break;
       case 128: /* cmd ::= with DELETE FROM fullname indexed_opt where_opt */
 #line 727 "parse.y"
@@ -2924,7 +2928,7 @@ static void yy_reduce(
   pParse->initiateTTrans = true;
   sqlite3DeleteFrom(pParse,yymsp[-2].minor.yy387,yymsp[0].minor.yy362);
 }
-#line 2928 "parse.c"
+#line 2932 "parse.c"
         break;
       case 131: /* cmd ::= with UPDATE orconf fullname indexed_opt SET setlist where_opt */
 #line 760 "parse.y"
@@ -2937,7 +2941,7 @@ static void yy_reduce(
   pParse->initiateTTrans = true;
   sqlite3Update(pParse,yymsp[-4].minor.yy387,yymsp[-1].minor.yy382,yymsp[0].minor.yy362,yymsp[-5].minor.yy52);
 }
-#line 2941 "parse.c"
+#line 2945 "parse.c"
         break;
       case 132: /* setlist ::= setlist COMMA nm EQ expr */
 #line 774 "parse.y"
@@ -2945,14 +2949,14 @@ static void yy_reduce(
   yymsp[-4].minor.yy382 = sqlite3ExprListAppend(pParse, yymsp[-4].minor.yy382, yymsp[0].minor.yy162.pExpr);
   sqlite3ExprListSetName(pParse, yymsp[-4].minor.yy382, &yymsp[-2].minor.yy0, 1);
 }
-#line 2949 "parse.c"
+#line 2953 "parse.c"
         break;
       case 133: /* setlist ::= setlist COMMA LP idlist RP EQ expr */
 #line 778 "parse.y"
 {
   yymsp[-6].minor.yy382 = sqlite3ExprListAppendVector(pParse, yymsp[-6].minor.yy382, yymsp[-3].minor.yy40, yymsp[0].minor.yy162.pExpr);
 }
-#line 2956 "parse.c"
+#line 2960 "parse.c"
         break;
       case 134: /* setlist ::= nm EQ expr */
 #line 781 "parse.y"
@@ -2960,7 +2964,7 @@ static void yy_reduce(
   yylhsminor.yy382 = sqlite3ExprListAppend(pParse, 0, yymsp[0].minor.yy162.pExpr);
   sqlite3ExprListSetName(pParse, yylhsminor.yy382, &yymsp[-2].minor.yy0, 1);
 }
-#line 2964 "parse.c"
+#line 2968 "parse.c"
   yymsp[-2].minor.yy382 = yylhsminor.yy382;
         break;
       case 135: /* setlist ::= LP idlist RP EQ expr */
@@ -2968,7 +2972,7 @@ static void yy_reduce(
 {
   yymsp[-4].minor.yy382 = sqlite3ExprListAppendVector(pParse, 0, yymsp[-3].minor.yy40, yymsp[0].minor.yy162.pExpr);
 }
-#line 2972 "parse.c"
+#line 2976 "parse.c"
         break;
       case 136: /* cmd ::= with insert_cmd INTO fullname idlist_opt select */
 #line 791 "parse.y"
@@ -2979,7 +2983,7 @@ static void yy_reduce(
   pParse->initiateTTrans = true;
   sqlite3Insert(pParse, yymsp[-2].minor.yy387, yymsp[0].minor.yy279, yymsp[-1].minor.yy40, yymsp[-4].minor.yy52);
 }
-#line 2983 "parse.c"
+#line 2987 "parse.c"
         break;
       case 137: /* cmd ::= with insert_cmd INTO fullname idlist_opt DEFAULT VALUES */
 #line 799 "parse.y"
@@ -2990,40 +2994,40 @@ static void yy_reduce(
   pParse->initiateTTrans = true;
   sqlite3Insert(pParse, yymsp[-3].minor.yy387, 0, yymsp[-2].minor.yy40, yymsp[-5].minor.yy52);
 }
-#line 2994 "parse.c"
+#line 2998 "parse.c"
         break;
       case 141: /* idlist_opt ::= LP idlist RP */
 #line 817 "parse.y"
 {yymsp[-2].minor.yy40 = yymsp[-1].minor.yy40;}
-#line 2999 "parse.c"
+#line 3003 "parse.c"
         break;
       case 142: /* idlist ::= idlist COMMA nm */
 #line 819 "parse.y"
 {yymsp[-2].minor.yy40 = sqlite3IdListAppend(pParse->db,yymsp[-2].minor.yy40,&yymsp[0].minor.yy0);}
-#line 3004 "parse.c"
+#line 3008 "parse.c"
         break;
       case 143: /* idlist ::= nm */
 #line 821 "parse.y"
 {yymsp[0].minor.yy40 = sqlite3IdListAppend(pParse->db,0,&yymsp[0].minor.yy0); /*A-overwrites-Y*/}
-#line 3009 "parse.c"
+#line 3013 "parse.c"
         break;
       case 144: /* expr ::= LP expr RP */
 #line 870 "parse.y"
 {spanSet(&yymsp[-2].minor.yy162,&yymsp[-2].minor.yy0,&yymsp[0].minor.yy0); /*A-overwrites-B*/  yymsp[-2].minor.yy162.pExpr = yymsp[-1].minor.yy162.pExpr;}
-#line 3014 "parse.c"
+#line 3018 "parse.c"
         break;
       case 145: /* term ::= NULL */
       case 149: /* term ::= FLOAT|BLOB */ yytestcase(yyruleno==149);
       case 150: /* term ::= STRING */ yytestcase(yyruleno==150);
 #line 871 "parse.y"
 {spanExpr(&yymsp[0].minor.yy162,pParse,yymsp[0].major,yymsp[0].minor.yy0);/*A-overwrites-X*/}
-#line 3021 "parse.c"
+#line 3025 "parse.c"
         break;
       case 146: /* expr ::= ID|INDEXED */
       case 147: /* expr ::= JOIN_KW */ yytestcase(yyruleno==147);
 #line 872 "parse.y"
 {spanExpr(&yymsp[0].minor.yy162,pParse,TK_ID,yymsp[0].minor.yy0); /*A-overwrites-X*/}
-#line 3027 "parse.c"
+#line 3031 "parse.c"
         break;
       case 148: /* expr ::= nm DOT nm */
 #line 874 "parse.y"
@@ -3033,7 +3037,7 @@ static void yy_reduce(
   spanSet(&yymsp[-2].minor.yy162,&yymsp[-2].minor.yy0,&yymsp[0].minor.yy0); /*A-overwrites-X*/
   yymsp[-2].minor.yy162.pExpr = sqlite3PExpr(pParse, TK_DOT, temp1, temp2);
 }
-#line 3037 "parse.c"
+#line 3041 "parse.c"
         break;
       case 151: /* term ::= INTEGER */
 #line 882 "parse.y"
@@ -3043,7 +3047,7 @@ static void yy_reduce(
   yylhsminor.yy162.zEnd = yymsp[0].minor.yy0.z + yymsp[0].minor.yy0.n;
   if( yylhsminor.yy162.pExpr ) yylhsminor.yy162.pExpr->flags |= EP_Leaf;
 }
-#line 3047 "parse.c"
+#line 3051 "parse.c"
   yymsp[0].minor.yy162 = yylhsminor.yy162;
         break;
       case 152: /* expr ::= VARIABLE */
@@ -3069,7 +3073,7 @@ static void yy_reduce(
     }
   }
 }
-#line 3073 "parse.c"
+#line 3077 "parse.c"
         break;
       case 153: /* expr ::= expr COLLATE ID|INDEXED */
 #line 909 "parse.y"
@@ -3077,7 +3081,7 @@ static void yy_reduce(
   yymsp[-2].minor.yy162.pExpr = sqlite3ExprAddCollateToken(pParse, yymsp[-2].minor.yy162.pExpr, &yymsp[0].minor.yy0, 1);
   yymsp[-2].minor.yy162.zEnd = &yymsp[0].minor.yy0.z[yymsp[0].minor.yy0.n];
 }
-#line 3081 "parse.c"
+#line 3085 "parse.c"
         break;
       case 154: /* expr ::= CAST LP expr AS typetoken RP */
 #line 914 "parse.y"
@@ -3086,7 +3090,7 @@ static void yy_reduce(
   yymsp[-5].minor.yy162.pExpr = sqlite3ExprAlloc(pParse->db, TK_CAST, &yymsp[-1].minor.yy0, 1);
   sqlite3ExprAttachSubtrees(pParse->db, yymsp[-5].minor.yy162.pExpr, yymsp[-3].minor.yy162.pExpr, 0);
 }
-#line 3090 "parse.c"
+#line 3094 "parse.c"
         break;
       case 155: /* expr ::= ID|INDEXED LP distinct exprlist RP */
 #line 920 "parse.y"
@@ -3100,7 +3104,7 @@ static void yy_reduce(
     yylhsminor.yy162.pExpr->flags |= EP_Distinct;
   }
 }
-#line 3104 "parse.c"
+#line 3108 "parse.c"
   yymsp[-4].minor.yy162 = yylhsminor.yy162;
         break;
       case 156: /* expr ::= ID|INDEXED LP STAR RP */
@@ -3109,7 +3113,7 @@ static void yy_reduce(
   yylhsminor.yy162.pExpr = sqlite3ExprFunction(pParse, 0, &yymsp[-3].minor.yy0);
   spanSet(&yylhsminor.yy162,&yymsp[-3].minor.yy0,&yymsp[0].minor.yy0);
 }
-#line 3113 "parse.c"
+#line 3117 "parse.c"
   yymsp[-3].minor.yy162 = yylhsminor.yy162;
         break;
       case 157: /* term ::= CTIME_KW */
@@ -3118,7 +3122,7 @@ static void yy_reduce(
   yylhsminor.yy162.pExpr = sqlite3ExprFunction(pParse, 0, &yymsp[0].minor.yy0);
   spanSet(&yylhsminor.yy162, &yymsp[0].minor.yy0, &yymsp[0].minor.yy0);
 }
-#line 3122 "parse.c"
+#line 3126 "parse.c"
   yymsp[0].minor.yy162 = yylhsminor.yy162;
         break;
       case 158: /* expr ::= LP nexprlist COMMA expr RP */
@@ -3133,7 +3137,7 @@ static void yy_reduce(
     sqlite3ExprListDelete(pParse->db, pList);
   }
 }
-#line 3137 "parse.c"
+#line 3141 "parse.c"
   yymsp[-4].minor.yy162 = yylhsminor.yy162;
         break;
       case 159: /* expr ::= expr AND expr */
@@ -3146,17 +3150,17 @@ static void yy_reduce(
       case 166: /* expr ::= expr CONCAT expr */ yytestcase(yyruleno==166);
 #line 974 "parse.y"
 {spanBinaryExpr(pParse,yymsp[-1].major,&yymsp[-2].minor.yy162,&yymsp[0].minor.yy162);}
-#line 3150 "parse.c"
+#line 3154 "parse.c"
         break;
       case 167: /* likeop ::= LIKE_KW|MATCH */
 #line 987 "parse.y"
 {yymsp[0].minor.yy0=yymsp[0].minor.yy0;/*A-overwrites-X*/}
-#line 3155 "parse.c"
+#line 3159 "parse.c"
         break;
       case 168: /* likeop ::= NOT LIKE_KW|MATCH */
 #line 988 "parse.y"
 {yymsp[-1].minor.yy0=yymsp[0].minor.yy0; yymsp[-1].minor.yy0.n|=0x80000000; /*yymsp[-1].minor.yy0-overwrite-yymsp[0].minor.yy0*/}
-#line 3160 "parse.c"
+#line 3164 "parse.c"
         break;
       case 169: /* expr ::= expr likeop expr */
 #line 989 "parse.y"
@@ -3171,7 +3175,7 @@ static void yy_reduce(
   yymsp[-2].minor.yy162.zEnd = yymsp[0].minor.yy162.zEnd;
   if( yymsp[-2].minor.yy162.pExpr ) yymsp[-2].minor.yy162.pExpr->flags |= EP_InfixFunc;
 }
-#line 3175 "parse.c"
+#line 3179 "parse.c"
         break;
       case 170: /* expr ::= expr likeop expr ESCAPE expr */
 #line 1000 "parse.y"
@@ -3187,17 +3191,17 @@ static void yy_reduce(
   yymsp[-4].minor.yy162.zEnd = yymsp[0].minor.yy162.zEnd;
   if( yymsp[-4].minor.yy162.pExpr ) yymsp[-4].minor.yy162.pExpr->flags |= EP_InfixFunc;
 }
-#line 3191 "parse.c"
+#line 3195 "parse.c"
         break;
       case 171: /* expr ::= expr ISNULL|NOTNULL */
 #line 1027 "parse.y"
 {spanUnaryPostfix(pParse,yymsp[0].major,&yymsp[-1].minor.yy162,&yymsp[0].minor.yy0);}
-#line 3196 "parse.c"
+#line 3200 "parse.c"
         break;
       case 172: /* expr ::= expr NOT NULL */
 #line 1028 "parse.y"
 {spanUnaryPostfix(pParse,TK_NOTNULL,&yymsp[-2].minor.yy162,&yymsp[0].minor.yy0);}
-#line 3201 "parse.c"
+#line 3205 "parse.c"
         break;
       case 173: /* expr ::= expr IS expr */
 #line 1049 "parse.y"
@@ -3205,7 +3209,7 @@ static void yy_reduce(
   spanBinaryExpr(pParse,TK_IS,&yymsp[-2].minor.yy162,&yymsp[0].minor.yy162);
   binaryToUnaryIfNull(pParse, yymsp[0].minor.yy162.pExpr, yymsp[-2].minor.yy162.pExpr, TK_ISNULL);
 }
-#line 3209 "parse.c"
+#line 3213 "parse.c"
         break;
       case 174: /* expr ::= expr IS NOT expr */
 #line 1053 "parse.y"
@@ -3213,29 +3217,29 @@ static void yy_reduce(
   spanBinaryExpr(pParse,TK_ISNOT,&yymsp[-3].minor.yy162,&yymsp[0].minor.yy162);
   binaryToUnaryIfNull(pParse, yymsp[0].minor.yy162.pExpr, yymsp[-3].minor.yy162.pExpr, TK_NOTNULL);
 }
-#line 3217 "parse.c"
+#line 3221 "parse.c"
         break;
       case 175: /* expr ::= NOT expr */
       case 176: /* expr ::= BITNOT expr */ yytestcase(yyruleno==176);
 #line 1077 "parse.y"
 {spanUnaryPrefix(&yymsp[-1].minor.yy162,pParse,yymsp[-1].major,&yymsp[0].minor.yy162,&yymsp[-1].minor.yy0);/*A-overwrites-B*/}
-#line 3223 "parse.c"
+#line 3227 "parse.c"
         break;
       case 177: /* expr ::= MINUS expr */
 #line 1081 "parse.y"
 {spanUnaryPrefix(&yymsp[-1].minor.yy162,pParse,TK_UMINUS,&yymsp[0].minor.yy162,&yymsp[-1].minor.yy0);/*A-overwrites-B*/}
-#line 3228 "parse.c"
+#line 3232 "parse.c"
         break;
       case 178: /* expr ::= PLUS expr */
 #line 1083 "parse.y"
 {spanUnaryPrefix(&yymsp[-1].minor.yy162,pParse,TK_UPLUS,&yymsp[0].minor.yy162,&yymsp[-1].minor.yy0);/*A-overwrites-B*/}
-#line 3233 "parse.c"
+#line 3237 "parse.c"
         break;
       case 179: /* between_op ::= BETWEEN */
       case 182: /* in_op ::= IN */ yytestcase(yyruleno==182);
 #line 1086 "parse.y"
 {yymsp[0].minor.yy52 = 0;}
-#line 3239 "parse.c"
+#line 3243 "parse.c"
         break;
       case 181: /* expr ::= expr between_op expr AND expr */
 #line 1088 "parse.y"
@@ -3251,7 +3255,7 @@ static void yy_reduce(
   exprNot(pParse, yymsp[-3].minor.yy52, &yymsp[-4].minor.yy162);
   yymsp[-4].minor.yy162.zEnd = yymsp[0].minor.yy162.zEnd;
 }
-#line 3255 "parse.c"
+#line 3259 "parse.c"
         break;
       case 184: /* expr ::= expr in_op LP exprlist RP */
 #line 1104 "parse.y"
@@ -3306,7 +3310,7 @@ static void yy_reduce(
     }
     yymsp[-4].minor.yy162.zEnd = &yymsp[0].minor.yy0.z[yymsp[0].minor.yy0.n];
   }
-#line 3310 "parse.c"
+#line 3314 "parse.c"
         break;
       case 185: /* expr ::= LP select RP */
 #line 1155 "parse.y"
@@ -3315,7 +3319,7 @@ static void yy_reduce(
     yymsp[-2].minor.yy162.pExpr = sqlite3PExpr(pParse, TK_SELECT, 0, 0);
     sqlite3PExprAddSelect(pParse, yymsp[-2].minor.yy162.pExpr, yymsp[-1].minor.yy279);
   }
-#line 3319 "parse.c"
+#line 3323 "parse.c"
         break;
       case 186: /* expr ::= expr in_op LP select RP */
 #line 1160 "parse.y"
@@ -3325,7 +3329,7 @@ static void yy_reduce(
     exprNot(pParse, yymsp[-3].minor.yy52, &yymsp[-4].minor.yy162);
     yymsp[-4].minor.yy162.zEnd = &yymsp[0].minor.yy0.z[yymsp[0].minor.yy0.n];
   }
-#line 3329 "parse.c"
+#line 3333 "parse.c"
         break;
       case 187: /* expr ::= expr in_op nm paren_exprlist */
 #line 1166 "parse.y"
@@ -3338,7 +3342,7 @@ static void yy_reduce(
     exprNot(pParse, yymsp[-2].minor.yy52, &yymsp[-3].minor.yy162);
     yymsp[-3].minor.yy162.zEnd = &yymsp[-1].minor.yy0.z[yymsp[-1].minor.yy0.n];
   }
-#line 3342 "parse.c"
+#line 3346 "parse.c"
         break;
       case 188: /* expr ::= EXISTS LP select RP */
 #line 1175 "parse.y"
@@ -3348,7 +3352,7 @@ static void yy_reduce(
     p = yymsp[-3].minor.yy162.pExpr = sqlite3PExpr(pParse, TK_EXISTS, 0, 0);
     sqlite3PExprAddSelect(pParse, p, yymsp[-1].minor.yy279);
   }
-#line 3352 "parse.c"
+#line 3356 "parse.c"
         break;
       case 189: /* expr ::= CASE case_operand case_exprlist case_else END */
 #line 1184 "parse.y"
@@ -3363,7 +3367,7 @@ static void yy_reduce(
     sqlite3ExprDelete(pParse->db, yymsp[-1].minor.yy362);
   }
 }
-#line 3367 "parse.c"
+#line 3371 "parse.c"
         break;
       case 190: /* case_exprlist ::= case_exprlist WHEN expr THEN expr */
 #line 1197 "parse.y"
@@ -3371,7 +3375,7 @@ static void yy_reduce(
   yymsp[-4].minor.yy382 = sqlite3ExprListAppend(pParse,yymsp[-4].minor.yy382, yymsp[-2].minor.yy162.pExpr);
   yymsp[-4].minor.yy382 = sqlite3ExprListAppend(pParse,yymsp[-4].minor.yy382, yymsp[0].minor.yy162.pExpr);
 }
-#line 3375 "parse.c"
+#line 3379 "parse.c"
         break;
       case 191: /* case_exprlist ::= WHEN expr THEN expr */
 #line 1201 "parse.y"
@@ -3379,118 +3383,118 @@ static void yy_reduce(
   yymsp[-3].minor.yy382 = sqlite3ExprListAppend(pParse,0, yymsp[-2].minor.yy162.pExpr);
   yymsp[-3].minor.yy382 = sqlite3ExprListAppend(pParse,yymsp[-3].minor.yy382, yymsp[0].minor.yy162.pExpr);
 }
-#line 3383 "parse.c"
+#line 3387 "parse.c"
         break;
       case 194: /* case_operand ::= expr */
 #line 1211 "parse.y"
 {yymsp[0].minor.yy362 = yymsp[0].minor.yy162.pExpr; /*A-overwrites-X*/}
-#line 3388 "parse.c"
+#line 3392 "parse.c"
         break;
       case 197: /* nexprlist ::= nexprlist COMMA expr */
 #line 1222 "parse.y"
 {yymsp[-2].minor.yy382 = sqlite3ExprListAppend(pParse,yymsp[-2].minor.yy382,yymsp[0].minor.yy162.pExpr);}
-#line 3393 "parse.c"
+#line 3397 "parse.c"
         break;
       case 198: /* nexprlist ::= expr */
 #line 1224 "parse.y"
 {yymsp[0].minor.yy382 = sqlite3ExprListAppend(pParse,0,yymsp[0].minor.yy162.pExpr); /*A-overwrites-Y*/}
-#line 3398 "parse.c"
+#line 3402 "parse.c"
         break;
       case 200: /* paren_exprlist ::= LP exprlist RP */
       case 205: /* eidlist_opt ::= LP eidlist RP */ yytestcase(yyruleno==205);
 #line 1232 "parse.y"
 {yymsp[-2].minor.yy382 = yymsp[-1].minor.yy382;}
-#line 3404 "parse.c"
+#line 3408 "parse.c"
         break;
-      case 201: /* cmd ::= createkw uniqueflag INDEX ifnotexists nm ON nm LP sortlist RP where_opt */
+      case 201: /* cmd ::= createkw uniqueflag INDEX ifnotexists nm ON nm LP sortlist RP */
 #line 1239 "parse.y"
 {
-  sqlite3CreateIndex(pParse, &yymsp[-6].minor.yy0, 
-                     sqlite3SrcListAppend(pParse->db,0,&yymsp[-4].minor.yy0), yymsp[-2].minor.yy382, yymsp[-9].minor.yy52,
-                      &yymsp[-10].minor.yy0, yymsp[0].minor.yy362, SQLITE_SO_ASC, yymsp[-7].minor.yy52, SQLITE_IDXTYPE_APPDEF);
+  sqlite3CreateIndex(pParse, &yymsp[-5].minor.yy0, 
+                     sqlite3SrcListAppend(pParse->db,0,&yymsp[-3].minor.yy0), yymsp[-1].minor.yy382, yymsp[-8].minor.yy52,
+                      &yymsp[-9].minor.yy0, 0, SQLITE_SO_ASC, yymsp[-6].minor.yy52, SQLITE_IDXTYPE_APPDEF);
 }
-#line 3413 "parse.c"
+#line 3417 "parse.c"
         break;
       case 202: /* uniqueflag ::= UNIQUE */
       case 243: /* raisetype ::= ABORT */ yytestcase(yyruleno==243);
 #line 1246 "parse.y"
 {yymsp[0].minor.yy52 = ON_CONFLICT_ACTION_ABORT;}
-#line 3419 "parse.c"
+#line 3423 "parse.c"
         break;
       case 203: /* uniqueflag ::= */
 #line 1247 "parse.y"
 {yymsp[1].minor.yy52 = ON_CONFLICT_ACTION_NONE;}
-#line 3424 "parse.c"
+#line 3428 "parse.c"
         break;
       case 206: /* eidlist ::= eidlist COMMA nm collate sortorder */
 #line 1290 "parse.y"
 {
   yymsp[-4].minor.yy382 = parserAddExprIdListTerm(pParse, yymsp[-4].minor.yy382, &yymsp[-2].minor.yy0, yymsp[-1].minor.yy52, yymsp[0].minor.yy52);
 }
-#line 3431 "parse.c"
+#line 3435 "parse.c"
         break;
       case 207: /* eidlist ::= nm collate sortorder */
 #line 1293 "parse.y"
 {
   yymsp[-2].minor.yy382 = parserAddExprIdListTerm(pParse, 0, &yymsp[-2].minor.yy0, yymsp[-1].minor.yy52, yymsp[0].minor.yy52); /*A-overwrites-Y*/
 }
-#line 3438 "parse.c"
+#line 3442 "parse.c"
         break;
       case 210: /* cmd ::= DROP INDEX ifexists fullname ON nm */
 #line 1304 "parse.y"
 {
     sqlite3DropIndex(pParse, yymsp[-2].minor.yy387, &yymsp[0].minor.yy0, yymsp[-3].minor.yy52);
 }
-#line 3445 "parse.c"
+#line 3449 "parse.c"
         break;
       case 211: /* cmd ::= PRAGMA nm */
 #line 1311 "parse.y"
 {
     sqlite3Pragma(pParse,&yymsp[0].minor.yy0,0,0,0,0);
 }
-#line 3452 "parse.c"
+#line 3456 "parse.c"
         break;
       case 212: /* cmd ::= PRAGMA nm EQ nmnum */
 #line 1314 "parse.y"
 {
     sqlite3Pragma(pParse,&yymsp[-2].minor.yy0,0,&yymsp[0].minor.yy0,0,0);
 }
-#line 3459 "parse.c"
+#line 3463 "parse.c"
         break;
       case 213: /* cmd ::= PRAGMA nm LP nmnum RP */
 #line 1317 "parse.y"
 {
     sqlite3Pragma(pParse,&yymsp[-3].minor.yy0,0,&yymsp[-1].minor.yy0,0,0);
 }
-#line 3466 "parse.c"
+#line 3470 "parse.c"
         break;
       case 214: /* cmd ::= PRAGMA nm EQ minus_num */
 #line 1320 "parse.y"
 {
     sqlite3Pragma(pParse,&yymsp[-2].minor.yy0,0,&yymsp[0].minor.yy0,0,1);
 }
-#line 3473 "parse.c"
+#line 3477 "parse.c"
         break;
       case 215: /* cmd ::= PRAGMA nm LP minus_num RP */
 #line 1323 "parse.y"
 {
     sqlite3Pragma(pParse,&yymsp[-3].minor.yy0,0,&yymsp[-1].minor.yy0,0,1);
 }
-#line 3480 "parse.c"
+#line 3484 "parse.c"
         break;
       case 216: /* cmd ::= PRAGMA nm EQ nm DOT nm */
 #line 1326 "parse.y"
 {
     sqlite3Pragma(pParse,&yymsp[-4].minor.yy0,0,&yymsp[0].minor.yy0,&yymsp[-2].minor.yy0,0);
 }
-#line 3487 "parse.c"
+#line 3491 "parse.c"
         break;
       case 217: /* cmd ::= PRAGMA */
 #line 1329 "parse.y"
 {
     sqlite3Pragma(pParse, 0,0,0,0,0);
 }
-#line 3494 "parse.c"
+#line 3498 "parse.c"
         break;
       case 220: /* cmd ::= createkw trigger_decl BEGIN trigger_cmd_list END */
 #line 1349 "parse.y"
@@ -3500,7 +3504,7 @@ static void yy_reduce(
   all.n = (int)(yymsp[0].minor.yy0.z - yymsp[-3].minor.yy0.z) + yymsp[0].minor.yy0.n;
   sqlite3FinishTrigger(pParse, yymsp[-1].minor.yy427, &all);
 }
-#line 3504 "parse.c"
+#line 3508 "parse.c"
         break;
       case 221: /* trigger_decl ::= TRIGGER ifnotexists nm trigger_time trigger_event ON fullname foreach_clause when_clause */
 #line 1358 "parse.y"
@@ -3508,48 +3512,48 @@ static void yy_reduce(
   sqlite3BeginTrigger(pParse, &yymsp[-6].minor.yy0, yymsp[-5].minor.yy52, yymsp[-4].minor.yy10.a, yymsp[-4].minor.yy10.b, yymsp[-2].minor.yy387, yymsp[0].minor.yy362, yymsp[-7].minor.yy52);
   yymsp[-8].minor.yy0 = yymsp[-6].minor.yy0; /*yymsp[-8].minor.yy0-overwrites-T*/
 }
-#line 3512 "parse.c"
+#line 3516 "parse.c"
         break;
       case 222: /* trigger_time ::= BEFORE */
 #line 1364 "parse.y"
 { yymsp[0].minor.yy52 = TK_BEFORE; }
-#line 3517 "parse.c"
+#line 3521 "parse.c"
         break;
       case 223: /* trigger_time ::= AFTER */
 #line 1365 "parse.y"
 { yymsp[0].minor.yy52 = TK_AFTER;  }
-#line 3522 "parse.c"
+#line 3526 "parse.c"
         break;
       case 224: /* trigger_time ::= INSTEAD OF */
 #line 1366 "parse.y"
 { yymsp[-1].minor.yy52 = TK_INSTEAD;}
-#line 3527 "parse.c"
+#line 3531 "parse.c"
         break;
       case 225: /* trigger_time ::= */
 #line 1367 "parse.y"
 { yymsp[1].minor.yy52 = TK_BEFORE; }
-#line 3532 "parse.c"
+#line 3536 "parse.c"
         break;
       case 226: /* trigger_event ::= DELETE|INSERT */
       case 227: /* trigger_event ::= UPDATE */ yytestcase(yyruleno==227);
 #line 1371 "parse.y"
 {yymsp[0].minor.yy10.a = yymsp[0].major; /*A-overwrites-X*/ yymsp[0].minor.yy10.b = 0;}
-#line 3538 "parse.c"
+#line 3542 "parse.c"
         break;
       case 228: /* trigger_event ::= UPDATE OF idlist */
 #line 1373 "parse.y"
 {yymsp[-2].minor.yy10.a = TK_UPDATE; yymsp[-2].minor.yy10.b = yymsp[0].minor.yy40;}
-#line 3543 "parse.c"
+#line 3547 "parse.c"
         break;
       case 229: /* when_clause ::= */
 #line 1380 "parse.y"
 { yymsp[1].minor.yy362 = 0; }
-#line 3548 "parse.c"
+#line 3552 "parse.c"
         break;
       case 230: /* when_clause ::= WHEN expr */
 #line 1381 "parse.y"
 { yymsp[-1].minor.yy362 = yymsp[0].minor.yy162.pExpr; }
-#line 3553 "parse.c"
+#line 3557 "parse.c"
         break;
       case 231: /* trigger_cmd_list ::= trigger_cmd_list trigger_cmd SEMI */
 #line 1385 "parse.y"
@@ -3558,7 +3562,7 @@ static void yy_reduce(
   yymsp[-2].minor.yy427->pLast->pNext = yymsp[-1].minor.yy427;
   yymsp[-2].minor.yy427->pLast = yymsp[-1].minor.yy427;
 }
-#line 3562 "parse.c"
+#line 3566 "parse.c"
         break;
       case 232: /* trigger_cmd_list ::= trigger_cmd SEMI */
 #line 1390 "parse.y"
@@ -3566,7 +3570,7 @@ static void yy_reduce(
   assert( yymsp[-1].minor.yy427!=0 );
   yymsp[-1].minor.yy427->pLast = yymsp[-1].minor.yy427;
 }
-#line 3570 "parse.c"
+#line 3574 "parse.c"
         break;
       case 233: /* trnm ::= nm DOT nm */
 #line 1401 "parse.y"
@@ -3576,7 +3580,7 @@ static void yy_reduce(
         "qualified table names are not allowed on INSERT, UPDATE, and DELETE "
         "statements within triggers");
 }
-#line 3580 "parse.c"
+#line 3584 "parse.c"
         break;
       case 234: /* tridxby ::= INDEXED BY nm */
 #line 1413 "parse.y"
@@ -3585,7 +3589,7 @@ static void yy_reduce(
         "the INDEXED BY clause is not allowed on UPDATE or DELETE statements "
         "within triggers");
 }
-#line 3589 "parse.c"
+#line 3593 "parse.c"
         break;
       case 235: /* tridxby ::= NOT INDEXED */
 #line 1418 "parse.y"
@@ -3594,27 +3598,27 @@ static void yy_reduce(
         "the NOT INDEXED clause is not allowed on UPDATE or DELETE statements "
         "within triggers");
 }
-#line 3598 "parse.c"
+#line 3602 "parse.c"
         break;
       case 236: /* trigger_cmd ::= UPDATE orconf trnm tridxby SET setlist where_opt */
 #line 1431 "parse.y"
 {yymsp[-6].minor.yy427 = sqlite3TriggerUpdateStep(pParse->db, &yymsp[-4].minor.yy0, yymsp[-1].minor.yy382, yymsp[0].minor.yy362, yymsp[-5].minor.yy52);}
-#line 3603 "parse.c"
+#line 3607 "parse.c"
         break;
       case 237: /* trigger_cmd ::= insert_cmd INTO trnm idlist_opt select */
 #line 1435 "parse.y"
 {yymsp[-4].minor.yy427 = sqlite3TriggerInsertStep(pParse->db, &yymsp[-2].minor.yy0, yymsp[-1].minor.yy40, yymsp[0].minor.yy279, yymsp[-4].minor.yy52);/*A-overwrites-R*/}
-#line 3608 "parse.c"
+#line 3612 "parse.c"
         break;
       case 238: /* trigger_cmd ::= DELETE FROM trnm tridxby where_opt */
 #line 1439 "parse.y"
 {yymsp[-4].minor.yy427 = sqlite3TriggerDeleteStep(pParse->db, &yymsp[-2].minor.yy0, yymsp[0].minor.yy362);}
-#line 3613 "parse.c"
+#line 3617 "parse.c"
         break;
       case 239: /* trigger_cmd ::= select */
 #line 1443 "parse.y"
 {yymsp[0].minor.yy427 = sqlite3TriggerSelectStep(pParse->db, yymsp[0].minor.yy279); /*A-overwrites-X*/}
-#line 3618 "parse.c"
+#line 3622 "parse.c"
         break;
       case 240: /* expr ::= RAISE LP IGNORE RP */
 #line 1446 "parse.y"
@@ -3625,7 +3629,7 @@ static void yy_reduce(
     yymsp[-3].minor.yy162.pExpr->affinity = ON_CONFLICT_ACTION_IGNORE;
   }
 }
-#line 3629 "parse.c"
+#line 3633 "parse.c"
         break;
       case 241: /* expr ::= RAISE LP raisetype COMMA STRING RP */
 #line 1453 "parse.y"
@@ -3636,85 +3640,85 @@ static void yy_reduce(
     yymsp[-5].minor.yy162.pExpr->affinity = (char)yymsp[-3].minor.yy52;
   }
 }
-#line 3640 "parse.c"
+#line 3644 "parse.c"
         break;
       case 242: /* raisetype ::= ROLLBACK */
 #line 1463 "parse.y"
 {yymsp[0].minor.yy52 = ON_CONFLICT_ACTION_ROLLBACK;}
-#line 3645 "parse.c"
+#line 3649 "parse.c"
         break;
       case 244: /* raisetype ::= FAIL */
 #line 1465 "parse.y"
 {yymsp[0].minor.yy52 = ON_CONFLICT_ACTION_FAIL;}
-#line 3650 "parse.c"
+#line 3654 "parse.c"
         break;
       case 245: /* cmd ::= DROP TRIGGER ifexists fullname */
 #line 1470 "parse.y"
 {
   sqlite3DropTrigger(pParse,yymsp[0].minor.yy387,yymsp[-1].minor.yy52);
 }
-#line 3657 "parse.c"
+#line 3661 "parse.c"
         break;
       case 246: /* cmd ::= REINDEX */
 #line 1477 "parse.y"
 {sqlite3Reindex(pParse, 0, 0);}
-#line 3662 "parse.c"
+#line 3666 "parse.c"
         break;
       case 247: /* cmd ::= REINDEX nm */
 #line 1478 "parse.y"
 {sqlite3Reindex(pParse, &yymsp[0].minor.yy0, 0);}
-#line 3667 "parse.c"
+#line 3671 "parse.c"
         break;
       case 248: /* cmd ::= REINDEX nm ON nm */
 #line 1479 "parse.y"
 {sqlite3Reindex(pParse, &yymsp[-2].minor.yy0, &yymsp[0].minor.yy0);}
-#line 3672 "parse.c"
+#line 3676 "parse.c"
         break;
       case 249: /* cmd ::= ANALYZE */
 #line 1484 "parse.y"
 {sqlite3Analyze(pParse, 0);}
-#line 3677 "parse.c"
+#line 3681 "parse.c"
         break;
       case 250: /* cmd ::= ANALYZE nm */
 #line 1485 "parse.y"
 {sqlite3Analyze(pParse, &yymsp[0].minor.yy0);}
-#line 3682 "parse.c"
+#line 3686 "parse.c"
         break;
       case 251: /* cmd ::= ALTER TABLE fullname RENAME TO nm */
 #line 1490 "parse.y"
 {
   sqlite3AlterRenameTable(pParse,yymsp[-3].minor.yy387,&yymsp[0].minor.yy0);
 }
-#line 3689 "parse.c"
+#line 3693 "parse.c"
         break;
       case 252: /* with ::= */
 #line 1513 "parse.y"
 {yymsp[1].minor.yy151 = 0;}
-#line 3694 "parse.c"
+#line 3698 "parse.c"
         break;
       case 253: /* with ::= WITH wqlist */
 #line 1515 "parse.y"
 { yymsp[-1].minor.yy151 = yymsp[0].minor.yy151; }
-#line 3699 "parse.c"
+#line 3703 "parse.c"
         break;
       case 254: /* with ::= WITH RECURSIVE wqlist */
 #line 1516 "parse.y"
 { yymsp[-2].minor.yy151 = yymsp[0].minor.yy151; }
-#line 3704 "parse.c"
+#line 3708 "parse.c"
         break;
       case 255: /* wqlist ::= nm eidlist_opt AS LP select RP */
 #line 1518 "parse.y"
 {
   yymsp[-5].minor.yy151 = sqlite3WithAdd(pParse, 0, &yymsp[-5].minor.yy0, yymsp[-4].minor.yy382, yymsp[-1].minor.yy279); /*A-overwrites-X*/
 }
-#line 3711 "parse.c"
+#line 3715 "parse.c"
         break;
       case 256: /* wqlist ::= wqlist COMMA nm eidlist_opt AS LP select RP */
 #line 1521 "parse.y"
 {
   yymsp[-7].minor.yy151 = sqlite3WithAdd(pParse, yymsp[-7].minor.yy151, &yymsp[-5].minor.yy0, yymsp[-4].minor.yy382, yymsp[-1].minor.yy279);
 }
-#line 3718 "parse.c"
+#line 3722 "parse.c"
         break;
       default:
       /* (257) input ::= ecmd */ yytestcase(yyruleno==257);
@@ -3825,7 +3829,7 @@ static void yy_syntax_error(
   } else {
     sqlite3ErrorMsg(pParse, "near \"%T\": syntax error", &TOKEN);
   }
-#line 3829 "parse.c"
+#line 3833 "parse.c"
 /************ End %syntax_error code ******************************************/
   sqlite3ParserARG_STORE; /* Suppress warning about unused %extra_argument variable */
 }
diff --git a/src/box/sql/parse.y b/src/box/sql/parse.y
index 914fc53..5fb2c89 100644
--- a/src/box/sql/parse.y
+++ b/src/box/sql/parse.y
@@ -1236,10 +1236,10 @@ paren_exprlist(A) ::= LP exprlist(X) RP.  {A = X;}
 ///////////////////////////// The CREATE INDEX command ///////////////////////
 //
 cmd ::= createkw(S) uniqueflag(U) INDEX ifnotexists(NE) nm(X)
-        ON nm(Y) LP sortlist(Z) RP where_opt(W). {
+        ON nm(Y) LP sortlist(Z) RP. {
   sqlite3CreateIndex(pParse, &X, 
                      sqlite3SrcListAppend(pParse->db,0,&Y), Z, U,
-                      &S, W, SQLITE_SO_ASC, NE, SQLITE_IDXTYPE_APPDEF);
+                      &S, 0, SQLITE_SO_ASC, NE, SQLITE_IDXTYPE_APPDEF);
 }
 
 %type uniqueflag {int}
diff --git a/test/sql-tap/analyze9.test.lua b/test/sql-tap/analyze9.test.lua
index 4ce575e..3668211 100755
--- a/test/sql-tap/analyze9.test.lua
+++ b/test/sql-tap/analyze9.test.lua
@@ -1111,7 +1111,7 @@ test:do_test(
         test:execsql([[
             DROP TABLE IF EXISTS t1;
             CREATE TABLE t1(id INTEGER PRIMARY KEY AUTOINCREMENT, a, b, c, d);
-            CREATE INDEX i1 ON t1(a, b) WHERE d IS NOT NULL;
+            CREATE INDEX i1 ON t1(a, b);
             INSERT INTO t1 VALUES(null, -1, -1, -1, NULL);
             INSERT INTO t1 SELECT null, 2*a,2*b,2*c,d FROM t1;
             INSERT INTO t1 SELECT null, 2*a,2*b,2*c,d FROM t1;
diff --git a/test/sql-tap/autoindex4.test.lua b/test/sql-tap/autoindex4.test.lua
index 45bae48..147e4dc 100755
--- a/test/sql-tap/autoindex4.test.lua
+++ b/test/sql-tap/autoindex4.test.lua
@@ -111,7 +111,7 @@ test:do_execsql_test(
 test:do_execsql_test(
     "autoindex4-3.1",
     [[
-        CREATE INDEX Items_x1 ON Items(ItemName,Name) WHERE ItemName = 'dummy';
+        CREATE INDEX Items_x1 ON Items(ItemName,Name);
 
         SELECT Items.ItemName
           FROM Items
@@ -126,4 +126,3 @@ test:do_execsql_test(
     })
 
 test:finish_test()
-
diff --git a/test/sql-tap/fkey1.test.lua b/test/sql-tap/fkey1.test.lua
index 8749e1f..36f47fe 100755
--- a/test/sql-tap/fkey1.test.lua
+++ b/test/sql-tap/fkey1.test.lua
@@ -212,7 +212,7 @@ test:do_execsql_test(
     "fkey1-6.1",
     [[
         CREATE TABLE p1(id PRIMARY KEY, x, y);
-        CREATE UNIQUE INDEX p1x ON p1(x) WHERE y<2;
+        CREATE UNIQUE INDEX p1x ON p1(x);
         INSERT INTO p1 VALUES(1, 1, 1);
         CREATE TABLE c1(a PRIMARY KEY REFERENCES p1(x));
     ]], {
diff --git a/test/sql-tap/gh-2165-remove-support-partial-indexes.test.lua b/test/sql-tap/gh-2165-remove-support-partial-indexes.test.lua
new file mode 100755
index 0000000..d8210fc
--- /dev/null
+++ b/test/sql-tap/gh-2165-remove-support-partial-indexes.test.lua
@@ -0,0 +1,17 @@
+#!/usr/bin/env tarantool
+test = require("sqltester")
+
+test:plan(1)
+
+
+test:do_catchsql_test(
+    "partial-index-1",
+    [[
+        CREATE TABLE t1 (a INTEGER PRIMARY KEY, b INTEGER)
+        CREATE UNIQUE INDEX i ON t1 (a) WHERE a = 3;
+    ]], {
+        1, "keyword \"CREATE\" is reserved"
+    })
+
+--This test intended to be deleted in #2626
+test:finish_test()
diff --git a/test/sql-tap/index7.test.lua b/test/sql-tap/index7.test.lua
index c8f56eb..84a4293 100755
--- a/test/sql-tap/index7.test.lua
+++ b/test/sql-tap/index7.test.lua
@@ -1,6 +1,6 @@
 #!/usr/bin/env tarantool
 test = require("sqltester")
-test:plan(5)
+test:plan(4)
 
 --!./tcltestrunner.lua
 -- 2013-11-04
@@ -261,7 +261,7 @@ test:do_execsql_test(
 test:do_execsql_test(
     "index7-6.2",
     [[
-        CREATE INDEX i4 ON t4(c) WHERE d='xyz';
+        CREATE INDEX i4 ON t4(c);
         SELECT a,b,c,d FROM (SELECT a,b FROM t5 WHERE a=1 AND b='xyz'), t4 WHERE c='abc';
     ]], {
         -- <index7-6.2>
@@ -291,14 +291,16 @@ test:do_eqp_test(
         -- </index7-6.4>
     })
 
-test:do_catchsql_test(
-    "index7-6.5",
-    [[
-        CREATE INDEX t5a ON t5(a) WHERE a=#1;
-    ]], {
-        -- <index7-6.5>
-        1, [[near "#1": syntax error]]
-        -- </index7-6.5>
-    })
+--test:do_catchsql_test(
+--    "index7-6.5",
+--    [[
+--        CREATE INDEX t5a ON t5(a) WHERE a=#1;
+--    ]], {
+--        -- <index7-6.5>
+--        1, [[near "#1": syntax error]]
+--        -- </index7-6.5>
+--    })
+-- this test checks incorrect syntax of partial indexes
+-- to be enabled after #2626
 
 test:finish_test()
diff --git a/test/sql-tap/suite.ini b/test/sql-tap/suite.ini
index 0bc9e83..d29c1b0 100644
--- a/test/sql-tap/suite.ini
+++ b/test/sql-tap/suite.ini
@@ -3,3 +3,4 @@ core = app
 description = Database tests with #! using TAP
 lua_libs = lua/sqltester.lua ../sql/lua/sql_tokenizer.lua ../box/lua/identifier.lua
 is_parallel = True
+disabled = index6.test.lua ; to be enabled after #2626
-- 
2.7.4

^ permalink raw reply	[flat|nested] 3+ messages in thread

end of thread, other threads:[~2018-04-23 17:30 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2018-04-18 20:03 [tarantool-patches] [PATCH v2] sql: remove support of partial indexes Gleb
2018-04-23 17:30 ` [tarantool-patches] " GLEB SKIBA
  -- strict thread matches above, loose matches on Subject: below --
2018-04-11 20:17 Gleb

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox