**
** See also: [sqlite3_libversion()],
** [sqlite3_libversion_number()], [sqlite3_sourceid()],
** [sqlite_version()] and [sqlite_source_id()].
*/
#define SQLITE_VERSION        "3.28.0"
#define SQLITE_VERSION_NUMBER 3028000
#define SQLITE_SOURCE_ID      "2019-04-03 17:48:10 8d3af2010f4f652865f5c0d18e3bc793de05f8e75e75cc77786f61004b2ad28f"

/*
** CAPI3REF: Run-Time Library Version Numbers
** KEYWORDS: sqlite3_version sqlite3_sourceid
**
** These interfaces provide the same information as the [SQLITE_VERSION],
** [SQLITE_VERSION_NUMBER], and [SQLITE_SOURCE_ID] C preprocessor macros

** datatype of the value
** <tr><td><b>sqlite3_value_numeric_type&nbsp;&nbsp;</b>
** <td>&rarr;&nbsp;&nbsp;<td>Best numeric datatype of the value
** <tr><td><b>sqlite3_value_nochange&nbsp;&nbsp;</b>
** <td>&rarr;&nbsp;&nbsp;<td>True if the column is unchanged in an UPDATE
** against a virtual table.
** <tr><td><b>sqlite3_value_frombind&nbsp;&nbsp;</b>
** <td>&rarr;&nbsp;&nbsp;<td>True if value originated a bound parameter
** </table></blockquote>
**
** <b>Details:</b>
**
** These routines extract type, size, and content information from
** [protected sqlite3_value] objects.  Protected sqlite3_value objects
** are used to pass parameter information into implementation of

#define TK_TRUTH                          167
#define TK_REGISTER                       168
#define TK_VECTOR                         169
#define TK_SELECT_COLUMN                  170
#define TK_IF_NULL_ROW                    171
#define TK_ASTERISK                       172
#define TK_SPAN                           173
#define TK_END_OF_FILE                    174
#define TK_UNCLOSED_STRING                175
#define TK_SPACE                          176
#define TK_ILLEGAL                        177

/* The token codes above must all fit in 8 bits */
#define TKFLG_MASK           0xff  

/* Flags that can be added to a token code when it is not
** being stored in a u8: */
#define TKFLG_DONTFOLD       0x100  /* Omit constant folding optimizations */

/************** End of parse.h ***********************************************/
/************** Continuing where we left off in sqliteInt.h ******************/
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <assert.h>

/*
** Allowed values for sqlite3.mDbFlags
*/
#define DBFLAG_SchemaChange   0x0001  /* Uncommitted Hash table changes */
#define DBFLAG_PreferBuiltin  0x0002  /* Preference to built-in funcs */
#define DBFLAG_Vacuum         0x0004  /* Currently in a VACUUM */

#define DBFLAG_SchemaKnownOk  0x0008  /* Schema is known to be valid */

/*
** Bits of the sqlite3.dbOptFlags field that are used by the
** sqlite3_test_control(SQLITE_TESTCTRL_OPTIMIZATIONS,...) interface to
** selectively disable various optimizations.
*/
#define SQLITE_QueryFlattener 0x0001   /* Query flattening */

SQLITE_PRIVATE   void sqlite3TreeViewWinFunc(TreeView*, const Window*, u8);
#endif
#endif


SQLITE_PRIVATE void sqlite3SetString(char **, sqlite3*, const char*);
SQLITE_PRIVATE void sqlite3ErrorMsg(Parse*, const char*, ...);

SQLITE_PRIVATE void sqlite3Dequote(char*);
SQLITE_PRIVATE void sqlite3DequoteExpr(Expr*);
SQLITE_PRIVATE void sqlite3TokenInit(Token*,char*);
SQLITE_PRIVATE int sqlite3KeywordCode(const unsigned char*, int);
SQLITE_PRIVATE int sqlite3RunParser(Parse*, const char*, char **);
SQLITE_PRIVATE void sqlite3FinishCoding(Parse*);
SQLITE_PRIVATE int sqlite3GetTempReg(Parse*);

/*
** Clear any existing type flags from a Mem and replace them with f
*/
#define MemSetTypeFlag(p, f) \
   ((p)->flags = ((p)->flags&~(MEM_TypeMask|MEM_Zero))|f)







/*
** Return true if a memory cell is not marked as invalid.  This macro
** is for use inside assert() statements only.
*/
#ifdef SQLITE_DEBUG
#define memIsValid(M)  ((M)->flags & MEM_Undefined)==0
#endif

/*
** Set the StrAccum object to an error mode.
*/
static void setStrAccumError(StrAccum *p, u8 eError){
  assert( eError==SQLITE_NOMEM || eError==SQLITE_TOOBIG );
  p->accError = eError;
  if( p->mxAlloc ) sqlite3_str_reset(p);

}

/*
** Extra argument values from a PrintfArguments object
*/
static sqlite3_int64 getIntArg(PrintfArguments *p){
  if( p->nArg<=p->nUsed ) return 0;

SQLITE_PRIVATE void sqlite3Coverage(int x){
  static unsigned dummy = 0;
  dummy += (unsigned)x;
}
#endif

/*
** Give a callback to the test harness that can be used to simulate faults
** in places where it is difficult or expensive to do so purely by means
** of inputs.
**
** The intent of the integer argument is to let the fault simulator know
** which of multiple sqlite3FaultSim() calls has been hit.
**



** Return whatever integer value the test callback returns, or return
** SQLITE_OK if no test callback is installed.





*/
#ifndef SQLITE_UNTESTABLE
SQLITE_PRIVATE int sqlite3FaultSim(int iTest){
  int (*xCallback)(int) = sqlite3GlobalConfig.xTestCallback;
  return xCallback ? xCallback(iTest) : SQLITE_OK;
}
#endif

  }else{
    pParse->nErr++;
    sqlite3DbFree(db, pParse->zErrMsg);
    pParse->zErrMsg = zMsg;
    pParse->rc = SQLITE_ERROR;
  }
}














/*
** Convert an SQL-style quoted string into a normal string by removing
** the quote characters.  The conversion is done in-place.  If the
** input does not begin with a quote character, then this routine
** is a no-op.
**

*/
static int freePage2(BtShared *pBt, MemPage *pMemPage, Pgno iPage){
  MemPage *pTrunk = 0;                /* Free-list trunk page */
  Pgno iTrunk = 0;                    /* Page number of free-list trunk page */ 
  MemPage *pPage1 = pBt->pPage1;      /* Local reference to page 1 */
  MemPage *pPage;                     /* Page being freed. May be NULL. */
  int rc;                             /* Return Code */
  int nFree;                          /* Initial number of pages on free-list */

  assert( sqlite3_mutex_held(pBt->mutex) );
  assert( CORRUPT_DB || iPage>1 );
  assert( !pMemPage || pMemPage->pgno==iPage );

  if( iPage<2 || iPage>pBt->nPage ){
    return SQLITE_CORRUPT_BKPT;

** If the given Mem* has a zero-filled tail, turn it into an ordinary
** blob stored in dynamically allocated space.
*/
#ifndef SQLITE_OMIT_INCRBLOB
SQLITE_PRIVATE int sqlite3VdbeMemExpandBlob(Mem *pMem){
  int nByte;
  assert( pMem->flags & MEM_Zero );
  assert( pMem->flags&MEM_Blob );

  assert( !sqlite3VdbeMemIsRowSet(pMem) );
  assert( pMem->db==0 || sqlite3_mutex_held(pMem->db->mutex) );

  /* Set nByte to the number of bytes required to store the expanded blob. */
  nByte = pMem->n + pMem->u.nZero;
  if( nByte<=0 ){

    nByte = 1;
  }
  if( sqlite3VdbeMemGrow(pMem, nByte, 1) ){
    return SQLITE_NOMEM_BKPT;
  }

  memset(&pMem->z[pMem->n], 0, pMem->u.nZero);

  */
  if( xDel==SQLITE_TRANSIENT ){
    u32 nAlloc = nByte;
    if( flags&MEM_Term ){
      nAlloc += (enc==SQLITE_UTF8?1:2);
    }
    if( nByte>iLimit ){
      return SQLITE_TOOBIG;
    }
    testcase( nAlloc==0 );
    testcase( nAlloc==31 );
    testcase( nAlloc==32 );
    if( sqlite3VdbeMemClearAndResize(pMem, (int)MAX(nAlloc,32)) ){
      return SQLITE_NOMEM_BKPT;
    }

  if( op==TK_AND && pParse->nErr==0 && !IN_RENAME_OBJECT ){
    /* Take advantage of short-circuit false optimization for AND */
    p = sqlite3ExprAnd(pParse->db, pLeft, pRight);
  }else{
    p = sqlite3DbMallocRawNN(pParse->db, sizeof(Expr));
    if( p ){
      memset(p, 0, sizeof(Expr));
      p->op = op & TKFLG_MASK;
      p->iAgg = -1;
    }
    sqlite3ExprAttachSubtrees(pParse->db, p, pLeft, pRight);
  }
  if( p ) {
    sqlite3ExprCheckHeight(pParse, p->nHeight);
  }

  Index *pIdx       /* The index that triggers the constraint */
){
  char *zErr;
  int j;
  StrAccum errMsg;
  Table *pTab = pIdx->pTable;

  sqlite3StrAccumInit(&errMsg, pParse->db, 0, 0, 200);

  if( pIdx->aColExpr ){
    sqlite3_str_appendf(&errMsg, "index '%q'", pIdx->zName);
  }else{
    for(j=0; j<pIdx->nKeyCol; j++){
      char *zCol;
      assert( pIdx->aiColumn[j]>=0 );
      zCol = pTab->aCol[pIdx->aiColumn[j]].zName;

    }
    for(pSrcIdx=pSrc->pIndex; pSrcIdx; pSrcIdx=pSrcIdx->pNext){
      if( xferCompatibleIndex(pDestIdx, pSrcIdx) ) break;
    }
    if( pSrcIdx==0 ){
      return 0;    /* pDestIdx has no corresponding index in pSrc */
    }







  }
#ifndef SQLITE_OMIT_CHECK
  if( pDest->pCheck && sqlite3ExprListCompare(pSrc->pCheck,pDest->pCheck,-1) ){
    return 0;   /* Tables have different CHECK constraints.  Ticket #2252 */
  }
#endif
#ifndef SQLITE_OMIT_FOREIGN_KEY

      addr1 = sqlite3VdbeAddOp2(v, OP_Rowid, iSrc, regRowid);
      sqlite3VdbeVerifyAbortable(v, onError);
      addr2 = sqlite3VdbeAddOp3(v, OP_NotExists, iDest, 0, regRowid);
      VdbeCoverage(v);
      sqlite3RowidConstraint(pParse, onError, pDest);
      sqlite3VdbeJumpHere(v, addr2);
      autoIncStep(pParse, regAutoinc, regRowid);
    }else if( pDest->pIndex==0 && !(db->mDbFlags & DBFLAG_Vacuum) ){
      addr1 = sqlite3VdbeAddOp2(v, OP_NewRowid, iDest, regRowid);
    }else{
      addr1 = sqlite3VdbeAddOp2(v, OP_Rowid, iSrc, regRowid);
      assert( (pDest->tabFlags & TF_Autoincrement)==0 );
    }
    sqlite3VdbeAddOp3(v, OP_RowData, iSrc, regData, 1);
    if( db->mDbFlags & DBFLAG_Vacuum ){

  sqlite3_str_errcode,
  sqlite3_str_length,
  sqlite3_str_value,
  /* Version 3.25.0 and later */
  sqlite3_create_window_function,
  /* Version 3.26.0 and later */
#ifdef SQLITE_ENABLE_NORMALIZE
  sqlite3_normalized_sql
#else
  0
#endif



};

/*
** Attempt to load an SQLite extension library contained in the file
** zFile.  The entry point is zProc.  zProc may be 0 in which case a
** default entry point name (sqlite3_extension_init) is used.  Use
** of the default name is recommended.

  sqlite3ExprDelete(pParse->db, pInto);
  return;
}

/*
** This routine implements the OP_Vacuum opcode of the VDBE.
*/
SQLITE_PRIVATE int sqlite3RunVacuum(
  char **pzErrMsg,        /* Write error message here */
  sqlite3 *db,            /* Database connection */
  int iDb,                /* Which attached DB to vacuum */
  sqlite3_value *pOut     /* Write results here, if not NULL. VACUUM INTO */
){
  int rc = SQLITE_OK;     /* Return code from service routines */
  Btree *pMain;           /* The database being vacuumed */

  int nRes;               /* Bytes of reserved space at the end of each page */
  int nDb;                /* Number of attached databases */
  const char *zDbMain;    /* Schema name of database to vacuum */
  const char *zOut;       /* Name of output file */

  if( !db->autoCommit ){
    sqlite3SetString(pzErrMsg, db, "cannot VACUUM from within a transaction");
    return SQLITE_ERROR;
  }
  if( db->nVdbeActive>1 ){
    sqlite3SetString(pzErrMsg, db,"cannot VACUUM - SQL statements in progress");
    return SQLITE_ERROR;
  }
  saved_openFlags = db->openFlags;
  if( pOut ){
    if( sqlite3_value_type(pOut)!=SQLITE_TEXT ){
      sqlite3SetString(pzErrMsg, db, "non-text filename");
      return SQLITE_ERROR;
    }

    sqlite3_file *id = sqlite3PagerFile(sqlite3BtreePager(pTemp));
    i64 sz = 0;
    if( id->pMethods!=0 && (sqlite3OsFileSize(id, &sz)!=SQLITE_OK || sz>0) ){
      rc = SQLITE_ERROR;
      sqlite3SetString(pzErrMsg, db, "output file already exists");
      goto end_of_vacuum;
    }

  }
  nRes = sqlite3BtreeGetOptimalReserve(pMain);

  /* A VACUUM cannot change the pagesize of an encrypted database. */
#ifdef SQLITE_HAS_CODEC
  if( db->nextPagesize ){
    extern void sqlite3CodecGetKey(sqlite3*, int, void**, int*);

        if( (pWC->a[iTerm].wtFlags & (TERM_VIRTUAL|TERM_CODED))!=0 ) continue;
        if( (pWC->a[iTerm].eOperator & WO_ALL)==0 ) continue;
        testcase( pWC->a[iTerm].wtFlags & TERM_ORINFO );
        pExpr = sqlite3ExprDup(db, pExpr, 0);
        pAndExpr = sqlite3ExprAnd(db, pAndExpr, pExpr);
      }
      if( pAndExpr ){





        pAndExpr = sqlite3PExpr(pParse, TK_AND|TKFLG_DONTFOLD, 0, pAndExpr);
      }
    }

    /* Run a separate WHERE clause for each term of the OR clause.  After
    ** eliminating duplicates from other WHERE clauses, the action for each
    ** sub-WHERE clause is to to invoke the main loop body as a subroutine.
    */

    ){
      sqlite3ErrorMsg(pParse, "syntax error after column name \"%.*s\"",
                         pIdToken->n, pIdToken->z);
    }
    sqlite3ExprListSetName(pParse, p, pIdToken, 1);
    return p;
  }




/**************** End of %include directives **********************************/
/* These constants specify the various numeric values for terminal symbols
** in a format understandable to "makeheaders".  This section is blank unless
** "lemon" is run with the "-m" command-line option.
***************** Begin makeheaders token definitions *************************/
/**************** End makeheaders token definitions ***************************/

**    YY_MAX_REDUCE      Maximum value for reduce actions
*/
#ifndef INTERFACE
# define INTERFACE 1
#endif
/************* Begin control #defines *****************************************/
#define YYCODETYPE unsigned short int
#define YYNOCODE 284
#define YYACTIONTYPE unsigned short int
#define YYWILDCARD 95
#define sqlite3ParserTOKENTYPE Token
typedef union {
  int yyinit;
  sqlite3ParserTOKENTYPE yy0;
  u8 yy10;
  const char* yy104;
  Expr* yy130;
  SrcList* yy147;

  IdList* yy200;
  struct FrameBound yy273;


  Window* yy395;
  int yy420;
  Upsert* yy426;
  ExprList* yy442;

  Select* yy491;
  struct TrigEvent yy498;
  With* yy523;
  TriggerStep* yy524;
  struct {int value; int mask;} yy527;
} YYMINORTYPE;
#ifndef YYSTACKDEPTH
#define YYSTACKDEPTH 100
#endif
#define sqlite3ParserARG_SDECL
#define sqlite3ParserARG_PDECL
#define sqlite3ParserARG_PARAM
#define sqlite3ParserARG_FETCH
#define sqlite3ParserARG_STORE
#define sqlite3ParserCTX_SDECL Parse *pParse;
#define sqlite3ParserCTX_PDECL ,Parse *pParse
#define sqlite3ParserCTX_PARAM ,pParse
#define sqlite3ParserCTX_FETCH Parse *pParse=yypParser->pParse;
#define sqlite3ParserCTX_STORE yypParser->pParse=pParse;
#define YYFALLBACK 1
#define YYNSTATE             541
#define YYNRULE              375
#define YYNTOKEN             159
#define YY_MAX_SHIFT         540
#define YY_MIN_SHIFTREDUCE   784
#define YY_MAX_SHIFTREDUCE   1158
#define YY_ERROR_ACTION      1159
#define YY_ACCEPT_ACTION     1160
#define YY_NO_ACTION         1161
#define YY_MIN_REDUCE        1162

**  yy_reduce_ofst[]   For each state, the offset into yy_action for
**                     shifting non-terminals after a reduce.
**  yy_default[]       Default action for each state.
**
*********** Begin parsing tables **********************************************/
#define YY_ACTTAB_COUNT (2142)
static const YYACTIONTYPE yy_action[] = {
 /*     0 */   388,  112,  109,  209,  535,  190,  442,  259, 1160,    1,
 /*    10 */     1,  540,    2, 1164,  535, 1292, 1500,  371,  289,  384,
 /*    20 */   134, 1484, 1427, 1164, 1202,   69,   69, 1241,  289,  492,
 /*    30 */   134,  915,  382,  296,  175,   42,   42, 1241,  242,  916,
 /*    40 */   112,  109,  209,  119,  120,  110, 1136, 1136,  981,  984,
 /*    50 */   974,  974,  117,  117,  118,  118,  118,  118, 1291,  264,
 /*    60 */   264,  264,  264,  112,  109,  209,  112,  109,  209,  264,
 /*    70 */   264, 1115,  532, 1134,  532,  176,  270,  453,  239,  206,
 /*    80 */   379,  450,  532,  356,  380,  219,  118,  118,  118,  118,
 /*    90 */   111,  444,  535, 1233, 1233,  219,  116,  116,  116,  116,
 /*   100 */   115,  115,  114,  114,  114,  113,  415,  258,  258,  112,
 /*   110 */   109,  209, 1115,   42,   42,  419,  384, 1391, 1504, 1115,
 /*   120 */   532, 1115, 1116, 1117, 1134,  419, 1463,  351,  116,  116,
 /*   130 */   116,  116,  115,  115,  114,  114,  114,  113,  415,  961,
 /*   140 */   119,  120,  110, 1136, 1136,  981,  984,  974,  974,  117,
 /*   150 */   117,  118,  118,  118,  118,  952, 1228, 1207, 1115,  951,
 /*   160 */   412,  411, 1115, 1116, 1117, 1228,  535,  876, 1140, 1115,
 /*   170 */  1116, 1117,  875, 1142,  941,  114,  114,  114,  113,  415,
 /*   180 */  1089, 1141, 1089,  118,  118,  118,  118,   42,   42,  202,
 /*   190 */   951,  951,  953,  116,  116,  116,  116,  115,  115,  114,
 /*   200 */   114,  114,  113,  415, 1465, 1143,  350, 1143, 1115, 1116,
 /*   210 */  1117,  231,  415,  384,  472,  469,  468,  412,  411,  442,
 /*   220 */    96,  311,  430,  299,  467,  116,  116,  116,  116,  115,
 /*   230 */   115,  114,  114,  114,  113,  415,  160,  119,  120,  110,
 /*   240 */  1136, 1136,  981,  984,  974,  974,  117,  117,  118,  118,
 /*   250 */   118,  118,  115,  115,  114,  114,  114,  113,  415,  529,
 /*   260 */   529,  529, 1143,  121, 1143,  116,  116,  116,  116,  115,
 /*   270 */   115,  114,  114,  114,  113,  415,  941,  337, 1463,  506,
 /*   280 */   491, 1067, 1530,  384,  160, 1530,  288,  526, 1115,  274,
 /*   290 */   116,  116,  116,  116,  115,  115,  114,  114,  114,  113,
 /*   300 */   415,   16,   16,  406,  535,   93,  512,  119,  120,  110,
 /*   310 */  1136, 1136,  981,  984,  974,  974,  117,  117,  118,  118,
 /*   320 */   118,  118,  141,  311,  231,   54,   54,  472,  469,  468,
 /*   330 */   427,   79,  368, 1156,  288,  526,   32,  467, 1115, 1116,
 /*   340 */  1117, 1323, 1480,  540,    2, 1164,  971,  971,  982,  985,
 /*   350 */   289,  384,  134,  459, 1065,  533,   80,  870,  870, 1241,
 /*   360 */   116,  116,  116,  116,  115,  115,  114,  114,  114,  113,
 /*   370 */   415,  818,   82, 1115, 1476,  119,  120,  110, 1136, 1136,
 /*   380 */   981,  984,  974,  974,  117,  117,  118,  118,  118,  118,
 /*   390 */   403,  264,  264,  238,  535, 1426,  250,  267,  336,  475,
 /*   400 */   331,  474,  236,  459,  532, 1157,  961,  459,  329,  397,
 /*   410 */   373,  513, 1450,  159,  975,   70,   70,  219,  413,  413,
 /*   420 */   413,  818,  952, 1115, 1116, 1117,  951,  534,  116,  116,
 /*   430 */   116,  116,  115,  115,  114,  114,  114,  113,  415, 1115,
 /*   440 */   535,  442,  264,  264, 1115, 1390,  535,  419,  384,  422,
 /*   450 */  1115,  517,  326, 1245,  304,  532, 1084,  951,  951,  953,
 /*   460 */   493,   70,   70,  167,  509,  532, 1084,   70,   70, 1084,
 /*   470 */   440,  535,  119,  120,  110, 1136, 1136,  981,  984,  974,
 /*   480 */   974,  117,  117,  118,  118,  118,  118,  881,  535, 1115,
 /*   490 */  1116, 1117,   55,   55, 1115, 1116, 1117,  517,  288,  526,
 /*   500 */  1115, 1116, 1117,  517,  420,  494,  516,  113,  415,   13,
 /*   510 */    13,  275,  482,  836,  349,  301,  535,  303,  500,    5,
 /*   520 */   480, 1457,  138,  395,    6,  116,  116,  116,  116,  115,
 /*   530 */   115,  114,  114,  114,  113,  415, 1458,   13,   13,    6,
 /*   540 */   535, 1024, 1115,  535,  473,  384,  535,  435,  312,  822,
 /*   550 */  1084,  400,  837,  159,  518,  181, 1115,  483,  502,  811,
 /*   560 */  1084,   70,   70, 1084,   70,   70, 1115,   50,   50,  119,
 /*   570 */   120,  110, 1136, 1136,  981,  984,  974,  974,  117,  117,
 /*   580 */   118,  118,  118,  118,   95,  338,  264,  264, 1115,  264,
 /*   590 */   264,  302, 1115, 1116, 1117,  495,    3,  498,  535,  532,
 /*   600 */   517,  404,  532,  484,  801,  287, 1115, 1116, 1117,  519,
 /*   610 */   811,  337,  501,   12,  535,  381, 1115, 1116, 1117,   70,
 /*   620 */    70,  401,  116,  116,  116,  116,  115,  115,  114,  114,
 /*   630 */   114,  113,  415, 1115, 1084,   13,   13,  535, 1115, 1116,
 /*   640 */  1117, 1115,  384,  902, 1084, 1211,  815, 1084,  393,  402,
 /*   650 */   160,  435,  312, 1532,  369,  284,  143,  297,   70,   70,
 /*   660 */   510, 1457,  337,  433,    6,  901,  119,  120,  110, 1136,
 /*   670 */  1136,  981,  984,  974,  974,  117,  117,  118,  118,  118,
 /*   680 */   118, 1045,  426, 1115, 1116, 1117,  449,  535,   12,  264,
 /*   690 */   264, 1115, 1116, 1117,  285,  535, 1046,  265,  265, 1004,
 /*   700 */   288,  526,  532,  789,  790,  791,  190,  140,   70,   70,
 /*   710 */   532, 1047, 1323,  535,  309,  298,   13,   13,  383,  116,
 /*   720 */   116,  116,  116,  115,  115,  114,  114,  114,  113,  415,
 /*   730 */   277,  535,  856,  190,   13,   13, 1383,  497,  278,  384,
 /*   740 */   278,  362,  857, 1100,  410,  376,  264,  264,  184,  900,
 /*   750 */  1210, 1239,   70,   70, 1182, 1455,  187,  535,    6,  532,
 /*   760 */   535,  434,  207,  119,  120,  110, 1136, 1136,  981,  984,
 /*   770 */   974,  974,  117,  117,  118,  118,  118,  118,   13,   13,
 /*   780 */   398,   13,   13,  264,  264,  393,  264,  264,  414, 1185,
 /*   790 */   390,  425,  185, 1396, 1084,  514,  532,  485,    9,  532,
 /*   800 */   242,  464, 1067, 1531, 1084,  488, 1531, 1084,  425,  424,
 /*   810 */  1396, 1398,  520, 1029, 1029,  456,  116,  116,  116,  116,
 /*   820 */   115,  115,  114,  114,  114,  113,  415,  535,  235,  264,
 /*   830 */   264,  508,  535,  393,  208, 1134,  384,  264,  264,  448,
 /*   840 */   962,  448,  532,  261,  264,  264,  900,  507,   15,   15,
 /*   850 */   532, 1026,  271,   44,   44, 1026, 1095,  532,  535,  900,
 /*   860 */   119,  120,  110, 1136, 1136,  981,  984,  974,  974,  117,
 /*   870 */   117,  118,  118,  118,  118, 1065,  425, 1045, 1396,   56,
 /*   880 */    56,  535,  368, 1066, 1231, 1231, 1134,  454,  535,  324,
 /*   890 */   389,  355, 1046,  234,  233,  232,  512,  459,  459,  459,
 /*   900 */   272,  448,   57,   57, 1095, 1438,  329, 1047,  535,   58,
 /*   910 */    58,  421,  477,  116,  116,  116,  116,  115,  115,  114,
 /*   920 */   114,  114,  113,  415, 1323,  535,  515,  535,  523,   59,
 /*   930 */    59,  208,  273,  384,  310, 1435, 1323,  946,  876, 1240,
 /*   940 */  1236,  317, 1456,  875,  136,    6,   60,   60,   61,   61,
 /*   950 */   319,  535,  322,  384,  535, 1157,  900,  119,  120,  110,
 /*   960 */  1136, 1136,  981,  984,  974,  974,  117,  117,  118,  118,
 /*   970 */   118,  118,   45,   45,  535,   46,   46,  119,  120,  110,
 /*   980 */  1136, 1136,  981,  984,  974,  974,  117,  117,  118,  118,
 /*   990 */   118,  118,  399,  338,  276,   48,   48,  337, 1477,  479,
 /*  1000 */   535,  107, 1451,  535,  455,  535, 1119,   95, 1338,  235,
 /*  1010 */   116,  116,  116,  116,  115,  115,  114,  114,  114,  113,
 /*  1020 */   415,   49,   49,  123,   62,   62,   63,   63,  535,  408,
 /*  1030 */   116,  116,  116,  116,  115,  115,  114,  114,  114,  113,
 /*  1040 */   415,  535,  142,  535,  481,  535, 1323,  535, 1503,   64,
 /*  1050 */    64,  845, 1454, 1337,  535,    6,  535, 1119,  535,  357,
 /*  1060 */   535,  353,   14,   14,   65,   65,  125,  125,   66,   66,
 /*  1070 */   535,  389,  535,  291,  535,   51,   51,   67,   67,   68,
 /*  1080 */    68,   52,   52,  292, 1453,   98,  535,    6,  535,  481,
 /*  1090 */   535,  147,  147,  148,  148,   75,   75,  535,  915,  535,
 /*  1100 */   827,  201,  200,  528,  390,  384,  916,   53,   53,   71,
 /*  1110 */    71,  126,  126,  515,  409,  288,  526,  216,   72,   72,
 /*  1120 */   127,  127,  391,  161,  535,  384,  535,  263,  206,  119,
 /*  1130 */   120,  110, 1136, 1136,  981,  984,  974,  974,  117,  117,
 /*  1140 */   118,  118,  118,  118,  535,  128,  128,  124,  124,  119,
 /*  1150 */   120,  110, 1136, 1136,  981,  984,  974,  974,  117,  117,
 /*  1160 */   118,  118,  118,  118,  446,  146,  146,  102, 1209,  100,
 /*  1170 */  1133,  212,  139,  535,   38,  437, 1062,  308,  535,  370,
 /*  1180 */    95,  295,  116,  116,  116,  116,  115,  115,  114,  114,
 /*  1190 */   114,  113,  415,  535,  145,  145,  535,  938,  535,  132,
 /*  1200 */   132,  535,  116,  116,  116,  116,  115,  115,  114,  114,
 /*  1210 */   114,  113,  415,  535,  131,  131, 1151,  129,  129,  130,
 /*  1220 */   130,   30,   74,   74,  535,   17,  535,  218,  535,  943,
 /*  1230 */   441, 1277,  241,  241,   76,   76,  443,  101,  313,  241,
 /*  1240 */   465,   95, 1023,  237, 1023,   73,   73,   43,   43,   47,
 /*  1250 */    47,  335,   31,  327,  447,  266,   95,  384, 1276,  835,
 /*  1260 */   834,  334,  193, 1007,  436,  429,  237,  825,  842,  843,
 /*  1270 */  1011,  909,  873,  955,  241,  107, 1022,  384, 1022,  197,
 /*  1280 */  1441,  119,  120,  110, 1136, 1136,  981,  984,  974,  974,
 /*  1290 */   117,  117,  118,  118,  118,  118,  809,  305, 1264,  137,
 /*  1300 */  1415,  119,  108,  110, 1136, 1136,  981,  984,  974,  974,
 /*  1310 */   117,  117,  118,  118,  118,  118,  874,  522,  825,  107,
 /*  1320 */   283, 1011, 1414, 1470,  955,  451,  314, 1273,  318,  321,
 /*  1330 */   323,  325, 1224, 1208,  116,  116,  116,  116,  115,  115,
 /*  1340 */   114,  114,  114,  113,  415,  330,  339,  340, 1285, 1322,
 /*  1350 */  1260, 1271,  521, 1328,  116,  116,  116,  116,  115,  115,
 /*  1360 */   114,  114,  114,  113,  415, 1191,  256, 1493, 1184, 1173,
 /*  1370 */   460, 1172, 1174, 1257,  384,  342, 1487,  344,  346,  199,
 /*  1380 */   195,  367,   11,  211,  307,  445, 1307,  428, 1315,  375,
 /*  1390 */   203, 1207,  470,  188,  384,  189,  525, 1490, 1151,  120,
 /*  1400 */   110, 1136, 1136,  981,  984,  974,  974,  117,  117,  118,
 /*  1410 */   118,  118,  118,  333, 1387, 1386,  245,  300,  348, 1434,
 /*  1420 */   110, 1136, 1136,  981,  984,  974,  974,  117,  117,  118,
 /*  1430 */   118,  118,  118,  198,  360,  163, 1432, 1148,   78,   81,
 /*  1440 */   392,   82, 1392,  439,  173,  105,  527,  157,    4,  165,
 /*  1450 */  1312,  116,  116,  116,  116,  115,  115,  114,  114,  114,
 /*  1460 */   113,  415,  530,   93,   35,  431,  432, 1304,  168,  463,
 /*  1470 */   221,  116,  116,  116,  116,  115,  115,  114,  114,  114,
 /*  1480 */   113,  415,  169,  170,  171,  416,  372,  438, 1318,  177,
 /*  1490 */   452,  374,   36,  225, 1381,   87,  458,  524,  257, 1403,
 /*  1500 */   316,  105,  527,  227,    4,  182,  461,  160,  320,  228,
 /*  1510 */   377, 1175,  229,  476,  405, 1227, 1226, 1225,  530,  827,
 /*  1520 */   961, 1218,  378, 1199, 1198,  407,  103,  103,  281, 1217,
 /*  1530 */     8,  332, 1197,  104, 1502,  416,  537,  536,  282,  487,
 /*  1540 */   951,  416,  490,  496, 1268,   92,  341,  243,  244, 1461,
 /*  1550 */  1269, 1267,  122,  524, 1266,  515,   10,  288,  526,  343,
 /*  1560 */   352, 1460,  354,   99,  504,   94,  499,  251, 1181,  503,
 /*  1570 */   194,  951,  951,  953,  954,   27,  961, 1250,  345,  347,
 /*  1580 */  1249,  358,  103,  103,  359,   34,  538, 1110, 1367,  104,
 /*  1590 */   255,  416,  537,  536,  539, 1170,  951,  286,  252,  254,
 /*  1600 */   149, 1165, 1419,  135, 1420,  785,  279, 1418,  417, 1417,
 /*  1610 */  1195,  196,  150,  290,  210,  269,  151, 1021,  133, 1194,
 /*  1620 */  1019,  935,  162,  386,  387,   77, 1192,  951,  951,  953,
 /*  1630 */   954,   27, 1479, 1104,  418,  164,  153,  268,  217,  166,
 /*  1640 */   859,  306,  366,  366,  365,  253,  363,  220, 1035,  798,
 /*  1650 */   172,  939,  105,  527,  155,    4,  394,  174,  396,   83,
 /*  1660 */    84,   85,  213,   86,  294, 1038,  156,  223,  222,  530,
 /*  1670 */  1034,  144,  293,   18,  224,  241,  315, 1027, 1145,  178,
 /*  1680 */   457,  226,   37,  179,  800,  334,  462,  230,  328,  466,
 /*  1690 */   180,  471,  416,   88,   19,   20,   89,  280,  838,  158,
 /*  1700 */   191,  478,  215, 1097,  524,   90,  204,  192,  987,   91,
 /*  1710 */   152, 1070,   39,  154, 1071,  504,  486,   40,  489,  205,
 /*  1720 */   505,  260,  105,  527,  214,    4,  908,  961,  262,  183,
 /*  1730 */   240,   21,  903,  103,  103,  107,   22, 1086,   23,  530,
 /*  1740 */   104, 1074,  416,  537,  536,   24, 1088,  951,   25, 1093,
 /*  1750 */  1090, 1094,    7,   33,  511,  186,   26, 1002,  385,   95,
 /*  1760 */   988,  986,  416,  288,  526,  990, 1044,  246, 1043,  247,
 /*  1770 */   991,   28,   41,  106,  524,  956,  810,   29,  951,  951,
 /*  1780 */   953,  954,   27,  531,  869,  504,  423,  248,  249, 1495,
 /*  1790 */   503, 1494,  361,  364, 1105, 1161, 1161,  961, 1161, 1161,
 /*  1800 */  1161, 1161, 1161,  103,  103, 1161, 1161, 1161, 1161, 1161,
 /*  1810 */   104, 1161,  416,  537,  536, 1104,  418,  951, 1161,  268,
 /*  1820 */  1161, 1161, 1161, 1161,  366,  366,  365,  253,  363, 1161,
 /*  1830 */  1161,  798, 1161, 1161, 1161, 1161,  105,  527, 1161,    4,
 /*  1840 */  1161, 1161, 1161, 1161,  213, 1161,  294, 1161,  951,  951,
 /*  1850 */   953,  954,   27,  530,  293, 1161, 1161, 1161, 1161, 1161,
 /*  1860 */  1161, 1161, 1161, 1161, 1161, 1161, 1161, 1161, 1161, 1161,

 /*  2100 */  1161, 1161, 1161, 1161, 1161, 1161, 1161, 1161, 1161, 1161,
 /*  2110 */  1161, 1161, 1161,  385, 1161, 1161, 1161, 1161,  288,  526,
 /*  2120 */  1161, 1161, 1161, 1161, 1161, 1161, 1161, 1161, 1161, 1161,
 /*  2130 */  1161, 1161, 1161, 1161, 1161, 1161, 1161, 1161, 1161, 1161,
 /*  2140 */  1161,  423,
};
static const YYCODETYPE yy_lookahead[] = {
 /*     0 */   172,  242,  243,  244,  167,  167,  167,  186,  159,  160,
 /*    10 */   161,  162,  163,  164,  167,  191,  187,  179,  169,   19,
 /*    20 */   171,  162,  263,  164,  195,  188,  189,  178,  169,  178,
 /*    30 */   171,   31,  188,  167,   22,  188,  189,  178,   24,   39,
 /*    40 */   242,  243,  244,   43,   44,   45,   46,   47,   48,   49,
 /*    50 */    50,   51,   52,   53,   54,   55,   56,   57,  191,  210,
 /*    60 */   211,  210,  211,  242,  243,  244,  242,  243,  244,  210,
 /*    70 */   211,   59,  223,   59,  223,   22,  237,  249,  227,  228,
 /*    80 */   188,  253,  223,  246,  188,  236,   54,   55,   56,   57,
 /*    90 */    58,  167,  167,  206,  207,  236,   96,   97,   98,   99,
 /*   100 */   100,  101,  102,  103,  104,  105,  106,  210,  211,  242,
 /*   110 */   243,  244,   59,  188,  189,  266,   19,  251,  201,   59,
 /*   120 */   223,  109,  110,  111,  110,  266,  279,  280,   96,   97,
 /*   130 */    98,   99,  100,  101,  102,  103,  104,  105,  106,   94,
 /*   140 */    43,   44,   45,   46,   47,   48,   49,   50,   51,   52,
 /*   150 */    53,   54,   55,   56,   57,  110,  195,  196,   59,  114,
 /*   160 */   100,  101,  109,  110,  111,  204,  167,  128,  108,  109,
 /*   170 */   110,  111,  133,  113,   73,  102,  103,  104,  105,  106,
 /*   180 */    83,  121,   85,   54,   55,   56,   57,  188,  189,   26,
 /*   190 */   145,  146,  147,   96,   97,   98,   99,  100,  101,  102,
 /*   200 */   103,  104,  105,  106,  279,  145,  281,  147,  109,  110,
 /*   210 */   111,  112,  106,   19,  115,  116,  117,  100,  101,  167,
 /*   220 */    26,  120,  121,  122,  125,   96,   97,   98,   99,  100,
 /*   230 */   101,  102,  103,  104,  105,  106,   81,   43,   44,   45,
 /*   240 */    46,   47,   48,   49,   50,   51,   52,   53,   54,   55,
 /*   250 */    56,   57,  100,  101,  102,  103,  104,  105,  106,  183,
 /*   260 */   184,  185,  145,   69,  147,   96,   97,   98,   99,  100,
 /*   270 */   101,  102,  103,  104,  105,  106,   73,  167,  279,  280,
 /*   280 */   167,   22,   23,   19,   81,   26,  131,  132,   59,  237,
 /*   290 */    96,   97,   98,   99,  100,  101,  102,  103,  104,  105,
 /*   300 */   106,  188,  189,   19,  167,  142,  167,   43,   44,   45,
 /*   310 */    46,   47,   48,   49,   50,   51,   52,   53,   54,   55,
 /*   320 */    56,   57,  212,  120,  112,  188,  189,  115,  116,  117,
 /*   330 */   238,   67,   22,   23,  131,  132,   22,  125,  109,  110,
 /*   340 */   111,  167,  161,  162,  163,  164,   46,   47,   48,   49,
 /*   350 */   169,   19,  171,  167,   95,  127,   24,  129,  130,  178,
 /*   360 */    96,   97,   98,   99,  100,  101,  102,  103,  104,  105,
 /*   370 */   106,   59,  143,   59,  167,   43,   44,   45,   46,   47,
 /*   380 */    48,   49,   50,   51,   52,   53,   54,   55,   56,   57,
 /*   390 */   106,  210,  211,   26,  167,  209,  112,  113,  114,  115,
 /*   400 */   116,  117,  118,  167,  223,   95,   94,  167,  124,  235,
 /*   410 */   178,  272,  273,  167,  114,  188,  189,  236,  183,  184,
 /*   420 */   185,  109,  110,  109,  110,  111,  114,  167,   96,   97,
 /*   430 */    98,   99,  100,  101,  102,  103,  104,  105,  106,   59,
 /*   440 */   167,  167,  210,  211,   59,  209,  167,  266,   19,  209,
 /*   450 */    59,  224,   23,  211,   16,  223,   76,  145,  146,  147,
 /*   460 */   233,  188,  189,   72,   84,  223,   86,  188,  189,   89,
 /*   470 */   238,  167,   43,   44,   45,   46,   47,   48,   49,   50,
 /*   480 */    51,   52,   53,   54,   55,   56,   57,  102,  167,  109,
 /*   490 */   110,  111,  188,  189,  109,  110,  111,  224,  131,  132,
 /*   500 */   109,  110,  111,  224,  264,   19,  233,  105,  106,  188,
 /*   510 */   189,  237,  233,   35,  167,   77,  167,   79,  138,   22,
 /*   520 */   274,  275,   22,  202,  278,   96,   97,   98,   99,  100,
 /*   530 */   101,  102,  103,  104,  105,  106,  275,  188,  189,  278,
 /*   540 */   167,   11,   59,  167,   66,   19,  167,  121,  122,   23,
 /*   550 */    76,  202,   74,  167,  178,   72,   59,  178,   84,   59,
 /*   560 */    86,  188,  189,   89,  188,  189,   59,  188,  189,   43,
 /*   570 */    44,   45,   46,   47,   48,   49,   50,   51,   52,   53,
 /*   580 */    54,   55,   56,   57,   26,  167,  210,  211,   59,  210,
 /*   590 */   211,  153,  109,  110,  111,  109,   22,  224,  167,  223,
 /*   600 */   224,  123,  223,  224,   21,  215,  109,  110,  111,  233,
 /*   610 */   110,  167,  138,  186,  167,  225,  109,  110,  111,  188,
 /*   620 */   189,  203,   96,   97,   98,   99,  100,  101,  102,  103,
 /*   630 */   104,  105,  106,   59,   76,  188,  189,  167,  109,  110,
 /*   640 */   111,   59,   19,  136,   86,  197,   23,   89,  167,  202,
 /*   650 */    81,  121,  122,  269,  270,  224,  212,  178,  188,  189,
 /*   660 */   274,  275,  167,   80,  278,  136,   43,   44,   45,   46,
 /*   670 */    47,   48,   49,   50,   51,   52,   53,   54,   55,   56,
 /*   680 */    57,   12,  113,  109,  110,  111,  259,  167,  186,  210,
 /*   690 */   211,  109,  110,  111,  224,  167,   27,  210,  211,  116,
 /*   700 */   131,  132,  223,    7,    8,    9,  167,  212,  188,  189,
 /*   710 */   223,   42,  167,  167,  178,  234,  188,  189,  179,   96,
 /*   720 */    97,   98,   99,  100,  101,  102,  103,  104,  105,  106,
 /*   730 */   202,  167,   63,  167,  188,  189,  153,  167,  199,   19,
 /*   740 */   201,  175,   73,   23,  224,  179,  210,  211,  202,   26,
 /*   750 */   197,  178,  188,  189,  178,  275,  254,  167,  278,  223,
 /*   760 */   167,  259,  167,   43,   44,   45,   46,   47,   48,   49,
 /*   770 */    50,   51,   52,   53,   54,   55,   56,   57,  188,  189,
 /*   780 */   235,  188,  189,  210,  211,  167,  210,  211,  224,  181,
 /*   790 */   182,  167,  202,  167,   76,  202,  223,  178,   22,  223,
 /*   800 */    24,   19,   22,   23,   86,  178,   26,   89,  184,  185,
 /*   810 */   184,  185,  178,  120,  121,  122,   96,   97,   98,   99,
 /*   820 */   100,  101,  102,  103,  104,  105,  106,  167,   46,  210,
 /*   830 */   211,   66,  167,  167,  111,   59,   19,  210,  211,  167,
 /*   840 */    23,  167,  223,   23,  210,  211,   26,   82,  188,  189,
 /*   850 */   223,   29,  234,  188,  189,   33,   91,  223,  167,  136,
 /*   860 */    43,   44,   45,   46,   47,   48,   49,   50,   51,   52,
 /*   870 */    53,   54,   55,   56,   57,   95,  252,   12,  252,  188,
 /*   880 */   189,  167,   22,   23,  206,  207,  110,   65,  167,   16,
 /*   890 */   108,  167,   27,  120,  121,  122,  167,  167,  167,  167,
 /*   900 */   234,  167,  188,  189,  139,  167,  124,   42,  167,  188,
 /*   910 */   189,  167,  102,   96,   97,   98,   99,  100,  101,  102,
 /*   920 */   103,  104,  105,  106,  167,  167,  138,  167,   63,  188,
 /*   930 */   189,  111,  260,   19,  260,  167,  167,   23,  128,  209,
 /*   940 */   209,  209,  275,  133,  156,  278,  188,  189,  188,  189,
 /*   950 */    77,  167,   79,   19,  167,   95,  136,   43,   44,   45,
 /*   960 */    46,   47,   48,   49,   50,   51,   52,   53,   54,   55,
 /*   970 */    56,   57,  188,  189,  167,  188,  189,   43,   44,   45,
 /*   980 */    46,   47,   48,   49,   50,   51,   52,   53,   54,   55,
 /*   990 */    56,   57,  235,  167,  260,  188,  189,  167,  157,  158,
 /*  1000 */   167,   26,  273,  167,  235,  167,   59,   26,  241,   46,
 /*  1010 */    96,   97,   98,   99,  100,  101,  102,  103,  104,  105,
 /*  1020 */   106,  188,  189,   22,  188,  189,  188,  189,  167,  203,
 /*  1030 */    96,   97,   98,   99,  100,  101,  102,  103,  104,  105,
 /*  1040 */   106,  167,  212,  167,  277,  167,  167,  167,   23,  188,
 /*  1050 */   189,   26,  275,  241,  167,  278,  167,  110,  167,  220,
 /*  1060 */   167,  222,  188,  189,  188,  189,  188,  189,  188,  189,
 /*  1070 */   167,  108,  167,  167,  167,  188,  189,  188,  189,  188,
 /*  1080 */   189,  188,  189,  167,  275,  151,  167,  278,  167,  277,
 /*  1090 */   167,  188,  189,  188,  189,  188,  189,  167,   31,  167,
 /*  1100 */   119,  100,  101,  181,  182,   19,   39,  188,  189,  188,
 /*  1110 */   189,  188,  189,  138,  235,  131,  132,   24,  188,  189,
 /*  1120 */   188,  189,  267,  268,  167,   19,  167,  227,  228,   43,
 /*  1130 */    44,   45,   46,   47,   48,   49,   50,   51,   52,   53,
 /*  1140 */    54,   55,   56,   57,  167,  188,  189,  188,  189,   43,
 /*  1150 */    44,   45,   46,   47,   48,   49,   50,   51,   52,   53,
 /*  1160 */    54,   55,   56,   57,   19,  188,  189,  150,  197,  152,
 /*  1170 */    26,   15,   22,  167,   24,  122,   23,   23,  167,   26,
 /*  1180 */    26,  167,   96,   97,   98,   99,  100,  101,  102,  103,
 /*  1190 */   104,  105,  106,  167,  188,  189,  167,  144,  167,  188,
 /*  1200 */   189,  167,   96,   97,   98,   99,  100,  101,  102,  103,
 /*  1210 */   104,  105,  106,  167,  188,  189,   60,  188,  189,  188,
 /*  1220 */   189,   22,  188,  189,  167,   22,  167,  134,  167,   23,
 /*  1230 */    23,  167,   26,   26,  188,  189,   23,  151,   23,   26,
 /*  1240 */    23,   26,  145,   26,  147,  188,  189,  188,  189,  188,
 /*  1250 */   189,  114,   53,   23,  109,   22,   26,   19,  167,  113,
 /*  1260 */   114,  124,   24,   23,   61,  167,   26,   59,    7,    8,
 /*  1270 */    59,   23,   23,   59,   26,   26,  145,   19,  147,  135,
 /*  1280 */   167,   43,   44,   45,   46,   47,   48,   49,   50,   51,
 /*  1290 */    52,   53,   54,   55,   56,   57,   23,  167,  229,   26,
 /*  1300 */   167,   43,   44,   45,   46,   47,   48,   49,   50,   51,
 /*  1310 */    52,   53,   54,   55,   56,   57,   23,  207,  110,   26,
 /*  1320 */   226,  110,  167,  283,  110,  167,  167,  167,  167,  167,
 /*  1330 */   167,  167,  167,  167,   96,   97,   98,   99,  100,  101,
 /*  1340 */   102,  103,  104,  105,  106,  167,  167,  167,  167,  167,
 /*  1350 */   167,  167,  167,  167,   96,   97,   98,   99,  100,  101,
 /*  1360 */   102,  103,  104,  105,  106,  167,  255,  134,  167,  167,
 /*  1370 */   256,  167,  167,  226,   19,  226,  167,  226,  226,  186,
 /*  1380 */   213,  165,  214,  265,  261,  261,  217,  230,  217,  217,
 /*  1390 */   200,  196,  192,  220,   19,  220,  248,  170,   60,   44,
 /*  1400 */    45,   46,   47,   48,   49,   50,   51,   52,   53,   54,
 /*  1410 */    55,   56,   57,  191,  191,  191,  134,  230,  230,  174,
 /*  1420 */    45,   46,   47,   48,   49,   50,   51,   52,   53,   54,
 /*  1430 */    55,   56,   57,  214,  216,  265,  174,   38,  262,  262,
 /*  1440 */   174,  143,  251,  108,   22,   19,   20,   43,   22,  205,
 /*  1450 */   240,   96,   97,   98,   99,  100,  101,  102,  103,  104,
 /*  1460 */   105,  106,   36,  142,  239,   18,  174,  217,  208,   18,
 /*  1470 */   173,   96,   97,   98,   99,  100,  101,  102,  103,  104,
 /*  1480 */   105,  106,  208,  208,  208,   59,  217,  217,  205,  205,
 /*  1490 */   174,  240,  239,  173,  217,  150,   62,   71,  174,  258,
 /*  1500 */   257,   19,   20,  173,   22,   22,  193,   81,  174,  173,
 /*  1510 */   193,  174,  173,  108,   64,  190,  190,  190,   36,  119,
 /*  1520 */    94,  198,  193,  190,  192,  106,  100,  101,  250,  198,
 /*  1530 */    48,  190,  190,  107,  190,  109,  110,  111,  250,  193,
 /*  1540 */   114,   59,  193,  137,  232,  108,  231,  174,   88,  282,
 /*  1550 */   232,  232,  141,   71,  232,  138,   22,  131,  132,  231,
 /*  1560 */   220,  282,  174,  150,   82,  140,  139,   25,  177,   87,
 /*  1570 */   219,  145,  146,  147,  148,  149,   94,  221,  231,  231,
 /*  1580 */   221,  218,  100,  101,  217,   26,  176,   13,  245,  107,
 /*  1590 */     6,  109,  110,  111,  166,  166,  114,  247,  168,  168,
 /*  1600 */   180,  166,  186,  194,  186,    4,  194,  186,    3,  186,
 /*  1610 */   186,   22,  180,  155,   15,   93,  180,   23,   16,  186,
 /*  1620 */    23,  132,  268,  271,  271,  186,  186,  145,  146,  147,
 /*  1630 */   148,  149,    0,    1,    2,  143,  123,    5,   24,  135,
 /*  1640 */    20,   16,   10,   11,   12,   13,   14,  137,    1,   17,
 /*  1650 */   135,  144,   19,   20,  123,   22,   61,  143,   37,   53,
 /*  1660 */    53,   53,   30,   53,   32,  109,  123,  134,   34,   36,
 /*  1670 */     1,    5,   40,   22,  108,   26,  153,   68,   75,   68,
 /*  1680 */    41,  134,   24,  108,   20,  124,   19,  118,   23,   67,
 /*  1690 */    22,   67,   59,   22,   22,   22,   22,   67,   28,   37,
 /*  1700 */    23,   22,   70,   23,   71,  142,  157,   23,   23,   26,
 /*  1710 */    78,   23,   22,   81,   23,   82,   24,   22,   24,  134,
 /*  1720 */    87,   23,   19,   20,   92,   22,  109,   94,   23,   22,
 /*  1730 */    34,   34,  136,  100,  101,   26,   34,   85,   34,   36,
 /*  1740 */   107,   23,  109,  110,  111,   34,   83,  114,   34,   90,
 /*  1750 */    75,   75,   44,   22,   24,   26,   34,   23,  126,   26,
 /*  1760 */    23,   23,   59,  131,  132,   23,   23,   26,   23,   22,
 /*  1770 */    11,   22,   22,   22,   71,   23,   23,   22,  145,  146,
 /*  1780 */   147,  148,  149,   26,  128,   82,  154,  134,  134,  134,
 /*  1790 */    87,  134,   23,   15,    1,  284,  284,   94,  284,  284,
 /*  1800 */   284,  284,  284,  100,  101,  284,  284,  284,  284,  284,
 /*  1810 */   107,  284,  109,  110,  111,    1,    2,  114,  284,    5,
 /*  1820 */   284,  284,  284,  284,   10,   11,   12,   13,   14,  284,
 /*  1830 */   284,   17,  284,  284,  284,  284,   19,   20,  284,   22,
 /*  1840 */   284,  284,  284,  284,   30,  284,   32,  284,  145,  146,
 /*  1850 */   147,  148,  149,   36,   40,  284,  284,  284,  284,  284,
 /*  1860 */   284,  284,  284,  284,  284,  284,  284,  284,  284,  284,
 /*  1870 */   284,  284,  284,  284,  284,  284,   59,  284,  284,  284,
 /*  1880 */   284,  284,  284,  284,   70,  284,  284,  284,   71,  284,
 /*  1890 */   284,  284,   78,  284,  284,   81,   19,   20,  284,   22,
 /*  1900 */   284,  284,  284,  284,  284,  284,   92,  284,  284,  284,
 /*  1910 */   284,   94,  284,   36,  284,  284,  284,  100,  101,  102,
 /*  1920 */   284,  284,  284,  284,  107,  284,  109,  110,  111,  284,
 /*  1930 */   284,  114,  284,  284,  284,  284,   59,  284,  284,  284,
 /*  1940 */   126,  284,  284,  284,  284,  131,  132,  284,   71,  284,
 /*  1950 */   284,  284,  284,  284,  284,  284,   19,   20,  284,   22,
 /*  1960 */   284,  284,  145,  146,  147,  148,  149,  284,  154,  284,
 /*  1970 */   284,   94,  284,   36,  284,  284,  284,  100,  101,  284,
 /*  1980 */   284,  284,  284,  284,  107,  284,  109,  110,  111,  284,
 /*  1990 */   284,  114,    5,  284,  284,  284,   59,   10,   11,   12,
 /*  2000 */    13,   14,  284,  284,   17,  284,  284,  284,   71,  284,
 /*  2010 */   284,  284,  284,  284,  284,  284,  284,   30,  284,   32,
 /*  2020 */   284,  284,  145,  146,  147,  148,  149,   40,  284,  284,
 /*  2030 */   284,   94,  284,  284,  284,  284,  284,  100,  101,  284,
 /*  2040 */   284,  284,  284,  284,  107,  284,  109,  110,  111,  284,
 /*  2050 */   284,  114,  284,  284,  284,  284,  284,   70,  284,  284,
 /*  2060 */   284,  284,  284,  284,  284,   78,  284,  284,   81,  284,
 /*  2070 */   284,  284,  284,  284,  284,  284,  284,  284,  284,   92,
 /*  2080 */   284,  284,  145,  146,  147,  148,  149,  284,  284,  284,
 /*  2090 */   284,  284,  284,  284,  284,  284,  284,  284,  284,  284,
 /*  2100 */   284,  284,  284,  284,  284,  284,  284,  284,  284,  284,
 /*  2110 */   284,  284,  284,  126,  284,  284,  284,  284,  131,  132,
 /*  2120 */   284,  284,  284,  284,  284,  284,  284,  284,  284,  284,
 /*  2130 */   284,  284,  284,  284,  284,  284,  284,  284,  284,  284,
 /*  2140 */   284,  154,  284,  284,  284,  284,  284,  284,  284,  284,
 /*  2150 */   284,  284,

};
#define YY_SHIFT_COUNT    (540)
#define YY_SHIFT_MIN      (0)
#define YY_SHIFT_MAX      (1987)
static const unsigned short int yy_shift_ofst[] = {
 /*     0 */  1814, 1632, 1987, 1426, 1426,  155, 1482, 1633, 1703, 1877,
 /*    10 */  1877, 1877,  203,    0,    0,  264, 1106, 1877, 1877, 1877,
 /*    20 */  1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877,
 /*    30 */    60,   60,  380,  380,   99,  569,  155,  155,  155,  155,
 /*    40 */   155,  155,   97,  194,  332,  429,  526,  623,  720,  817,
 /*    50 */   914,  934, 1086, 1238, 1106, 1106, 1106, 1106, 1106, 1106,
 /*    60 */  1106, 1106, 1106, 1106, 1106, 1106, 1106, 1106, 1106, 1106,
 /*    70 */  1106, 1106, 1258, 1106, 1355, 1375, 1375, 1817, 1877, 1877,
 /*    80 */  1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877,
 /*    90 */  1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877,
 /*   100 */  1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877,
 /*   110 */  1937, 1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877, 1877,
 /*   120 */  1877, 1877, 1877, 1877,   32,  129,  129,  129,  129,  129,
 /*   130 */   169,  152,   73,  582,  583,  782,  582,  117,  117,  582,
 /*   140 */   367,  367,  367,  367,  426,  402,  106, 2142, 2142,  284,
 /*   150 */   284,  284,  229,   12,  391,   12,   12,  669,  669,  474,
 /*   160 */   483,  259,  780,  582,  582,  582,  582,  582,  582,  582,
 /*   170 */   582,  582,  582,  582,  582,  582,  582,  582,  582,  582,
 /*   180 */   582,  582,  582,  582,  558,  558,  582,  530,  718,  718,
 /*   190 */   947,  841,  841,  947,  788,  984, 2142, 2142, 2142,  312,
 /*   200 */    45,   45,   53,  212,  314,  385,  497,  507,  529,  574,
 /*   210 */   582,  582,  582,  582,  582,  582,  582,  582,  582,  101,
 /*   220 */   582,  582,  582,  582,  582,  582,  582,  582,  582,  582,
 /*   230 */   582,  582,  478,  478,  478,  582,  582,  582,  582,  820,
 /*   240 */   582,  582,  582,  776,  765,  582,  582,  865,  582,  582,
 /*   250 */   582,  582,  582,  582,  582,  582,  693,  822,  228,   14,
 /*   260 */    14,   14,   14,  723,  228,  228,  810, 1001,  696, 1156,
 /*   270 */   163,  486,  486, 1145,  163,  163, 1145,  981, 1025,  963,
 /*   280 */  1067, 1067, 1067,  486,  975,  975, 1017, 1144,   39, 1150,
 /*   290 */  1338, 1282, 1282, 1399, 1399, 1282, 1298, 1335, 1422, 1404,
 /*   300 */  1321, 1447, 1447, 1447, 1447, 1282, 1451, 1321, 1321, 1335,
 /*   310 */  1422, 1404, 1404, 1321, 1282, 1451, 1345, 1434, 1282, 1451,
 /*   320 */  1483, 1282, 1451, 1282, 1451, 1483, 1405, 1405, 1405, 1450,
 /*   330 */  1483, 1405, 1400, 1405, 1450, 1405, 1405, 1483, 1419, 1419,
 /*   340 */  1483, 1406, 1437, 1406, 1437, 1406, 1437, 1406, 1437, 1282,
 /*   350 */  1460, 1460, 1411, 1417, 1534, 1282, 1413, 1411, 1425, 1427,
 /*   360 */  1321, 1542, 1559, 1574, 1574, 1584, 1584, 1584, 2142, 2142,
 /*   370 */  2142, 2142, 2142, 2142, 2142, 2142, 2142, 2142, 2142, 2142,
 /*   380 */  2142, 2142, 2142, 2142,  300,  438,  310,  860,  873,  773,
 /*   390 */   500, 1153, 1199, 1093, 1053, 1154, 1203, 1206, 1207, 1213,
 /*   400 */  1215, 1217, 1230, 1208, 1146, 1261, 1137, 1211, 1240, 1248,
 /*   410 */  1249, 1097, 1131, 1273, 1293, 1214, 1233, 1601, 1605, 1589,
 /*   420 */  1458, 1599, 1522, 1602, 1594, 1597, 1489, 1492, 1513, 1614,
 /*   430 */  1504, 1620, 1510, 1625, 1647, 1515, 1507, 1531, 1595, 1621,
 /*   440 */  1514, 1606, 1607, 1608, 1610, 1543, 1556, 1634, 1533, 1669,
 /*   450 */  1666, 1651, 1566, 1523, 1609, 1649, 1611, 1603, 1639, 1547,
 /*   460 */  1575, 1658, 1664, 1667, 1561, 1569, 1668, 1622, 1671, 1672,
 /*   470 */  1665, 1673, 1624, 1670, 1674, 1630, 1662, 1677, 1563, 1679,
 /*   480 */  1680, 1549, 1684, 1685, 1683, 1688, 1690, 1692, 1691, 1695,
 /*   490 */  1694, 1585, 1698, 1705, 1617, 1696, 1707, 1596, 1709, 1697,
 /*   500 */  1702, 1704, 1711, 1652, 1675, 1663, 1708, 1676, 1659, 1714,
 /*   510 */  1718, 1731, 1730, 1729, 1733, 1722, 1734, 1709, 1737, 1738,
 /*   520 */  1742, 1743, 1741, 1745, 1747, 1759, 1749, 1750, 1752, 1753,
 /*   530 */  1751, 1755, 1757, 1656, 1653, 1654, 1655, 1657, 1769, 1778,
 /*   540 */  1793,
};
#define YY_REDUCE_COUNT (383)
#define YY_REDUCE_MIN   (-241)
#define YY_REDUCE_MAX   (1440)
static const short yy_reduce_ofst[] = {
 /*     0 */  -151,  181, -141,  376,  379, -149, -153,  -75,   -1,  227,
 /*    10 */   273,  279,  232, -176, -133, -241, -179,  321,  349,  447,
 /*    20 */   528,  373,  546,  590,  431,  470,  593, -163,  520,  564,
 /*    30 */   624,  626,  246,  386,  539,  479,  536,  573,  576,  619,
 /*    40 */   627,  634, -202, -202, -202, -202, -202, -202, -202, -202,
 /*    50 */  -202, -202, -202, -202, -202, -202, -202, -202, -202, -202,
 /*    60 */  -202, -202, -202, -202, -202, -202, -202, -202, -202, -202,
 /*    70 */  -202, -202, -202, -202, -202, -202, -202,  113,  137,  304,
 /*    80 */   660,  665,  691,  714,  721,  741,  758,  760,  784,  787,
 /*    90 */   807,  833,  836,  838,  861,  874,  876,  878,  880,  887,
 /*   100 */   889,  891,  893,  903,  905,  907,  919,  921,  923,  930,
 /*   110 */   932,  957,  959,  977, 1006, 1011, 1026, 1029, 1031, 1034,
 /*   120 */  1046, 1057, 1059, 1061, -202, -202, -202, -202, -202, -202,
 /*   130 */  -202, -202, -202,  240, -172,  -39,  139,   76,  235,  566,
 /*   140 */  -103,  487, -103,  487,  502, -202, -202, -202, -202, -171,
 /*   150 */  -171, -171, -134, -161,  110,   52,  274, -113,  678,  261,
 /*   160 */   444,  384,  384, -162,  481,  618,  666,  495,  186,  236,
 /*   170 */   730,  731,  672,  174,  674,  545,  757,  734,  769,  732,
 /*   180 */   418,  830,  826,  879,  480,  667,  729,  427,  777,  809,
 /*   190 */   608,  767,  812,  922,  839,  242,  855,  900,  390, -156,
 /*   200 */  -108, -104,  -76,  -83,  207,  260,  347,  570,  595,  724,
 /*   210 */   738,  744,  768,  906,  916, 1014, 1064, 1091, 1098,   92,
 /*   220 */  1113, 1130, 1133, 1155, 1158, 1159, 1160, 1161, 1162, 1163,
 /*   230 */  1164, 1165,  448,  553,  971, 1166, 1178, 1179, 1180, 1069,
 /*   240 */  1181, 1182, 1183, 1094, 1040, 1184, 1185, 1110, 1186,  260,
 /*   250 */  1198, 1201, 1202, 1204, 1205, 1209, 1114, 1111, 1167, 1147,
 /*   260 */  1149, 1151, 1152, 1069, 1167, 1167, 1168, 1193, 1216, 1118,
 /*   270 */  1169, 1157, 1187, 1123, 1171, 1172, 1124, 1200, 1190, 1195,
 /*   280 */  1222, 1223, 1224, 1188, 1173, 1175, 1148, 1218, 1219, 1227,
 /*   290 */  1170, 1245, 1262, 1176, 1177, 1266, 1191, 1210, 1225, 1244,
 /*   300 */  1250, 1260, 1274, 1275, 1276, 1292, 1297, 1269, 1270, 1251,
 /*   310 */  1253, 1283, 1284, 1277, 1316, 1320, 1241, 1243, 1324, 1330,
 /*   320 */  1313, 1334, 1336, 1337, 1339, 1317, 1325, 1326, 1327, 1323,
 /*   330 */  1329, 1333, 1332, 1341, 1331, 1342, 1344, 1346, 1278, 1288,
 /*   340 */  1349, 1312, 1315, 1318, 1328, 1319, 1347, 1322, 1348, 1373,
 /*   350 */  1267, 1279, 1356, 1340, 1343, 1388, 1350, 1359, 1351, 1363,
 /*   360 */  1367, 1391, 1410, 1430, 1431, 1428, 1429, 1435, 1352, 1353,
 /*   370 */  1354, 1420, 1416, 1418, 1421, 1423, 1432, 1409, 1412, 1424,
 /*   380 */  1433, 1439, 1440, 1436,
};
static const YYACTIONTYPE yy_default[] = {
 /*     0 */  1536, 1536, 1536, 1376, 1159, 1265, 1159, 1159, 1159, 1376,
 /*    10 */  1376, 1376, 1159, 1295, 1295, 1429, 1190, 1159, 1159, 1159,
 /*    20 */  1159, 1159, 1159, 1159, 1159, 1159, 1159, 1375, 1159, 1159,
 /*    30 */  1159, 1159, 1459, 1459, 1159, 1159, 1159, 1159, 1159, 1159,
 /*    40 */  1159, 1159, 1159, 1301, 1159, 1159, 1159, 1159, 1159, 1377,

  /*  152 */ "ELSE",
  /*  153 */ "INDEX",
  /*  154 */ "ALTER",
  /*  155 */ "ADD",
  /*  156 */ "WINDOW",
  /*  157 */ "OVER",
  /*  158 */ "FILTER",
  /*  159 */ "input",
  /*  160 */ "cmdlist",
  /*  161 */ "ecmd",
  /*  162 */ "cmdx",
  /*  163 */ "explain",
  /*  164 */ "cmd",
  /*  165 */ "transtype",
  /*  166 */ "trans_opt",
  /*  167 */ "nm",
  /*  168 */ "savepoint_opt",
  /*  169 */ "create_table",
  /*  170 */ "create_table_args",
  /*  171 */ "createkw",
  /*  172 */ "temp",
  /*  173 */ "ifnotexists",
  /*  174 */ "dbnm",
  /*  175 */ "columnlist",
  /*  176 */ "conslist_opt",
  /*  177 */ "table_options",
  /*  178 */ "select",
  /*  179 */ "columnname",
  /*  180 */ "carglist",
  /*  181 */ "typetoken",
  /*  182 */ "typename",
  /*  183 */ "signed",
  /*  184 */ "plus_num",
  /*  185 */ "minus_num",
  /*  186 */ "scanpt",
  /*  187 */ "ccons",
  /*  188 */ "term",
  /*  189 */ "expr",
  /*  190 */ "onconf",
  /*  191 */ "sortorder",
  /*  192 */ "autoinc",
  /*  193 */ "eidlist_opt",
  /*  194 */ "refargs",
  /*  195 */ "defer_subclause",
  /*  196 */ "refarg",
  /*  197 */ "refact",
  /*  198 */ "init_deferred_pred_opt",
  /*  199 */ "conslist",
  /*  200 */ "tconscomma",
  /*  201 */ "tcons",
  /*  202 */ "sortlist",
  /*  203 */ "eidlist",
  /*  204 */ "defer_subclause_opt",
  /*  205 */ "orconf",
  /*  206 */ "resolvetype",
  /*  207 */ "raisetype",
  /*  208 */ "ifexists",
  /*  209 */ "fullname",
  /*  210 */ "selectnowith",
  /*  211 */ "oneselect",
  /*  212 */ "wqlist",

















  /*  213 */ "multiselect_op",
  /*  214 */ "distinct",
  /*  215 */ "selcollist",
  /*  216 */ "from",
  /*  217 */ "where_opt",
  /*  218 */ "groupby_opt",
  /*  219 */ "having_opt",
  /*  220 */ "orderby_opt",
  /*  221 */ "limit_opt",
  /*  222 */ "window_clause",
  /*  223 */ "values",
  /*  224 */ "nexprlist",
  /*  225 */ "sclp",
  /*  226 */ "as",
  /*  227 */ "seltablist",
  /*  228 */ "stl_prefix",
  /*  229 */ "joinop",
  /*  230 */ "indexed_opt",
  /*  231 */ "on_opt",
  /*  232 */ "using_opt",
  /*  233 */ "exprlist",
  /*  234 */ "xfullname",
  /*  235 */ "idlist",
  /*  236 */ "with",
  /*  237 */ "setlist",
  /*  238 */ "insert_cmd",
  /*  239 */ "idlist_opt",
  /*  240 */ "upsert",
  /*  241 */ "over_clause",
  /*  242 */ "likeop",
  /*  243 */ "between_op",
  /*  244 */ "in_op",
  /*  245 */ "paren_exprlist",
  /*  246 */ "case_operand",
  /*  247 */ "case_exprlist",
  /*  248 */ "case_else",
  /*  249 */ "uniqueflag",
  /*  250 */ "collate",
  /*  251 */ "vinto",
  /*  252 */ "nmnum",
  /*  253 */ "trigger_decl",
  /*  254 */ "trigger_cmd_list",
  /*  255 */ "trigger_time",
  /*  256 */ "trigger_event",
  /*  257 */ "foreach_clause",
  /*  258 */ "when_clause",
  /*  259 */ "trigger_cmd",
  /*  260 */ "trnm",
  /*  261 */ "tridxby",
  /*  262 */ "database_kw_opt",
  /*  263 */ "key_opt",
  /*  264 */ "add_column_fullname",
  /*  265 */ "kwcolumn_opt",
  /*  266 */ "create_vtab",
  /*  267 */ "vtabarglist",
  /*  268 */ "vtabarg",
  /*  269 */ "vtabargtoken",
  /*  270 */ "lp",
  /*  271 */ "anylist",
  /*  272 */ "windowdefn_list",
  /*  273 */ "windowdefn",
  /*  274 */ "window",
  /*  275 */ "frame_opt",
  /*  276 */ "part_opt",
  /*  277 */ "filter_opt",
  /*  278 */ "range_or_rows",
  /*  279 */ "frame_bound",
  /*  280 */ "frame_bound_s",
  /*  281 */ "frame_bound_e",
  /*  282 */ "frame_exclude_opt",
  /*  283 */ "frame_exclude",
};
#endif /* defined(YYCOVERAGE) || !defined(NDEBUG) */

#ifndef NDEBUG
/* For tracing reduce actions, the names of all rules are required.
*/
static const char *const yyRuleName[] = {

    ** being destroyed before it is finished parsing.
    **
    ** Note: during a reduce, the only symbols destroyed are those
    ** which appear on the RHS of the rule, but which are *not* used
    ** inside the C code.
    */
/********* Begin destructor definitions ***************************************/
    case 178: /* select */
    case 210: /* selectnowith */
    case 211: /* oneselect */
    case 223: /* values */
{
sqlite3SelectDelete(pParse->db, (yypminor->yy491));
}
      break;
    case 188: /* term */
    case 189: /* expr */
    case 217: /* where_opt */
    case 219: /* having_opt */
    case 231: /* on_opt */
    case 246: /* case_operand */
    case 248: /* case_else */
    case 251: /* vinto */
    case 258: /* when_clause */
    case 263: /* key_opt */
    case 277: /* filter_opt */
{
sqlite3ExprDelete(pParse->db, (yypminor->yy130));
}
      break;
    case 193: /* eidlist_opt */
    case 202: /* sortlist */
    case 203: /* eidlist */
    case 215: /* selcollist */
    case 218: /* groupby_opt */
    case 220: /* orderby_opt */
    case 224: /* nexprlist */
    case 225: /* sclp */
    case 233: /* exprlist */
    case 237: /* setlist */
    case 245: /* paren_exprlist */
    case 247: /* case_exprlist */
    case 276: /* part_opt */
{
sqlite3ExprListDelete(pParse->db, (yypminor->yy442));
}
      break;
    case 209: /* fullname */
    case 216: /* from */
    case 227: /* seltablist */
    case 228: /* stl_prefix */
    case 234: /* xfullname */
{
sqlite3SrcListDelete(pParse->db, (yypminor->yy147));
}
      break;
    case 212: /* wqlist */
{
sqlite3WithDelete(pParse->db, (yypminor->yy523));
}
      break;
    case 222: /* window_clause */
    case 272: /* windowdefn_list */
{
sqlite3WindowListDelete(pParse->db, (yypminor->yy395));
}
      break;
    case 232: /* using_opt */
    case 235: /* idlist */
    case 239: /* idlist_opt */
{
sqlite3IdListDelete(pParse->db, (yypminor->yy200));
}
      break;
    case 241: /* over_clause */
    case 273: /* windowdefn */
    case 274: /* window */
    case 275: /* frame_opt */
{
sqlite3WindowDelete(pParse->db, (yypminor->yy395));
}
      break;
    case 254: /* trigger_cmd_list */
    case 259: /* trigger_cmd */
{
sqlite3DeleteTriggerStep(pParse->db, (yypminor->yy524));
}
      break;
    case 256: /* trigger_event */
{
sqlite3IdListDelete(pParse->db, (yypminor->yy498).b);
}
      break;
    case 279: /* frame_bound */
    case 280: /* frame_bound_s */
    case 281: /* frame_bound_e */
{
sqlite3ExprDelete(pParse->db, (yypminor->yy273).pExpr);
}
      break;
/********* End destructor definitions *****************************************/
    default:  break;   /* If no destructor action specified: do nothing */
  }
}

  yytos->minor.yy0 = yyMinor;
  yyTraceShift(yypParser, yyNewState, "Shift");
}

/* For rule J, yyRuleInfoLhs[J] contains the symbol on the left-hand side
** of that rule */
static const YYCODETYPE yyRuleInfoLhs[] = {
   163,  /* (0) explain ::= EXPLAIN */
   163,  /* (1) explain ::= EXPLAIN QUERY PLAN */
   162,  /* (2) cmdx ::= cmd */
   164,  /* (3) cmd ::= BEGIN transtype trans_opt */
   165,  /* (4) transtype ::= */
   165,  /* (5) transtype ::= DEFERRED */
   165,  /* (6) transtype ::= IMMEDIATE */
   165,  /* (7) transtype ::= EXCLUSIVE */
   164,  /* (8) cmd ::= COMMIT|END trans_opt */
   164,  /* (9) cmd ::= ROLLBACK trans_opt */
   164,  /* (10) cmd ::= SAVEPOINT nm */
   164,  /* (11) cmd ::= RELEASE savepoint_opt nm */
   164,  /* (12) cmd ::= ROLLBACK trans_opt TO savepoint_opt nm */
   169,  /* (13) create_table ::= createkw temp TABLE ifnotexists nm dbnm */
   171,  /* (14) createkw ::= CREATE */
   173,  /* (15) ifnotexists ::= */
   173,  /* (16) ifnotexists ::= IF NOT EXISTS */
   172,  /* (17) temp ::= TEMP */
   172,  /* (18) temp ::= */
   170,  /* (19) create_table_args ::= LP columnlist conslist_opt RP table_options */
   170,  /* (20) create_table_args ::= AS select */
   177,  /* (21) table_options ::= */
   177,  /* (22) table_options ::= WITHOUT nm */
   179,  /* (23) columnname ::= nm typetoken */
   181,  /* (24) typetoken ::= */
   181,  /* (25) typetoken ::= typename LP signed RP */
   181,  /* (26) typetoken ::= typename LP signed COMMA signed RP */
   182,  /* (27) typename ::= typename ID|STRING */
   186,  /* (28) scanpt ::= */
   187,  /* (29) ccons ::= CONSTRAINT nm */
   187,  /* (30) ccons ::= DEFAULT scanpt term scanpt */
   187,  /* (31) ccons ::= DEFAULT LP expr RP */
   187,  /* (32) ccons ::= DEFAULT PLUS term scanpt */
   187,  /* (33) ccons ::= DEFAULT MINUS term scanpt */
   187,  /* (34) ccons ::= DEFAULT scanpt ID|INDEXED */
   187,  /* (35) ccons ::= NOT NULL onconf */
   187,  /* (36) ccons ::= PRIMARY KEY sortorder onconf autoinc */
   187,  /* (37) ccons ::= UNIQUE onconf */
   187,  /* (38) ccons ::= CHECK LP expr RP */
   187,  /* (39) ccons ::= REFERENCES nm eidlist_opt refargs */
   187,  /* (40) ccons ::= defer_subclause */
   187,  /* (41) ccons ::= COLLATE ID|STRING */
   192,  /* (42) autoinc ::= */
   192,  /* (43) autoinc ::= AUTOINCR */
   194,  /* (44) refargs ::= */
   194,  /* (45) refargs ::= refargs refarg */
   196,  /* (46) refarg ::= MATCH nm */
   196,  /* (47) refarg ::= ON INSERT refact */
   196,  /* (48) refarg ::= ON DELETE refact */
   196,  /* (49) refarg ::= ON UPDATE refact */
   197,  /* (50) refact ::= SET NULL */
   197,  /* (51) refact ::= SET DEFAULT */
   197,  /* (52) refact ::= CASCADE */
   197,  /* (53) refact ::= RESTRICT */
   197,  /* (54) refact ::= NO ACTION */
   195,  /* (55) defer_subclause ::= NOT DEFERRABLE init_deferred_pred_opt */
   195,  /* (56) defer_subclause ::= DEFERRABLE init_deferred_pred_opt */
   198,  /* (57) init_deferred_pred_opt ::= */
   198,  /* (58) init_deferred_pred_opt ::= INITIALLY DEFERRED */
   198,  /* (59) init_deferred_pred_opt ::= INITIALLY IMMEDIATE */
   176,  /* (60) conslist_opt ::= */
   200,  /* (61) tconscomma ::= COMMA */
   201,  /* (62) tcons ::= CONSTRAINT nm */
   201,  /* (63) tcons ::= PRIMARY KEY LP sortlist autoinc RP onconf */
   201,  /* (64) tcons ::= UNIQUE LP sortlist RP onconf */
   201,  /* (65) tcons ::= CHECK LP expr RP onconf */
   201,  /* (66) tcons ::= FOREIGN KEY LP eidlist RP REFERENCES nm eidlist_opt refargs defer_subclause_opt */
   204,  /* (67) defer_subclause_opt ::= */
   190,  /* (68) onconf ::= */
   190,  /* (69) onconf ::= ON CONFLICT resolvetype */
   205,  /* (70) orconf ::= */
   205,  /* (71) orconf ::= OR resolvetype */
   206,  /* (72) resolvetype ::= IGNORE */
   206,  /* (73) resolvetype ::= REPLACE */
   164,  /* (74) cmd ::= DROP TABLE ifexists fullname */
   208,  /* (75) ifexists ::= IF EXISTS */
   208,  /* (76) ifexists ::= */
   164,  /* (77) cmd ::= createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS select */
   164,  /* (78) cmd ::= DROP VIEW ifexists fullname */
   164,  /* (79) cmd ::= select */
   178,  /* (80) select ::= WITH wqlist selectnowith */
   178,  /* (81) select ::= WITH RECURSIVE wqlist selectnowith */
   178,  /* (82) select ::= selectnowith */
   210,  /* (83) selectnowith ::= selectnowith multiselect_op oneselect */
   213,  /* (84) multiselect_op ::= UNION */
   213,  /* (85) multiselect_op ::= UNION ALL */
   213,  /* (86) multiselect_op ::= EXCEPT|INTERSECT */
   211,  /* (87) oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt */
   211,  /* (88) oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt */
   223,  /* (89) values ::= VALUES LP nexprlist RP */
   223,  /* (90) values ::= values COMMA LP nexprlist RP */
   214,  /* (91) distinct ::= DISTINCT */
   214,  /* (92) distinct ::= ALL */
   214,  /* (93) distinct ::= */
   225,  /* (94) sclp ::= */
   215,  /* (95) selcollist ::= sclp scanpt expr scanpt as */
   215,  /* (96) selcollist ::= sclp scanpt STAR */
   215,  /* (97) selcollist ::= sclp scanpt nm DOT STAR */
   226,  /* (98) as ::= AS nm */
   226,  /* (99) as ::= */
   216,  /* (100) from ::= */
   216,  /* (101) from ::= FROM seltablist */
   228,  /* (102) stl_prefix ::= seltablist joinop */
   228,  /* (103) stl_prefix ::= */
   227,  /* (104) seltablist ::= stl_prefix nm dbnm as indexed_opt on_opt using_opt */
   227,  /* (105) seltablist ::= stl_prefix nm dbnm LP exprlist RP as on_opt using_opt */
   227,  /* (106) seltablist ::= stl_prefix LP select RP as on_opt using_opt */
   227,  /* (107) seltablist ::= stl_prefix LP seltablist RP as on_opt using_opt */
   174,  /* (108) dbnm ::= */
   174,  /* (109) dbnm ::= DOT nm */
   209,  /* (110) fullname ::= nm */
   209,  /* (111) fullname ::= nm DOT nm */
   234,  /* (112) xfullname ::= nm */
   234,  /* (113) xfullname ::= nm DOT nm */
   234,  /* (114) xfullname ::= nm DOT nm AS nm */
   234,  /* (115) xfullname ::= nm AS nm */
   229,  /* (116) joinop ::= COMMA|JOIN */
   229,  /* (117) joinop ::= JOIN_KW JOIN */
   229,  /* (118) joinop ::= JOIN_KW nm JOIN */
   229,  /* (119) joinop ::= JOIN_KW nm nm JOIN */
   231,  /* (120) on_opt ::= ON expr */
   231,  /* (121) on_opt ::= */
   230,  /* (122) indexed_opt ::= */
   230,  /* (123) indexed_opt ::= INDEXED BY nm */
   230,  /* (124) indexed_opt ::= NOT INDEXED */
   232,  /* (125) using_opt ::= USING LP idlist RP */
   232,  /* (126) using_opt ::= */
   220,  /* (127) orderby_opt ::= */
   220,  /* (128) orderby_opt ::= ORDER BY sortlist */
   202,  /* (129) sortlist ::= sortlist COMMA expr sortorder */
   202,  /* (130) sortlist ::= expr sortorder */
   191,  /* (131) sortorder ::= ASC */
   191,  /* (132) sortorder ::= DESC */
   191,  /* (133) sortorder ::= */
   218,  /* (134) groupby_opt ::= */
   218,  /* (135) groupby_opt ::= GROUP BY nexprlist */
   219,  /* (136) having_opt ::= */
   219,  /* (137) having_opt ::= HAVING expr */
   221,  /* (138) limit_opt ::= */
   221,  /* (139) limit_opt ::= LIMIT expr */
   221,  /* (140) limit_opt ::= LIMIT expr OFFSET expr */
   221,  /* (141) limit_opt ::= LIMIT expr COMMA expr */
   164,  /* (142) cmd ::= with DELETE FROM xfullname indexed_opt where_opt */
   217,  /* (143) where_opt ::= */
   217,  /* (144) where_opt ::= WHERE expr */
   164,  /* (145) cmd ::= with UPDATE orconf xfullname indexed_opt SET setlist where_opt */
   237,  /* (146) setlist ::= setlist COMMA nm EQ expr */
   237,  /* (147) setlist ::= setlist COMMA LP idlist RP EQ expr */
   237,  /* (148) setlist ::= nm EQ expr */
   237,  /* (149) setlist ::= LP idlist RP EQ expr */
   164,  /* (150) cmd ::= with insert_cmd INTO xfullname idlist_opt select upsert */
   164,  /* (151) cmd ::= with insert_cmd INTO xfullname idlist_opt DEFAULT VALUES */
   240,  /* (152) upsert ::= */
   240,  /* (153) upsert ::= ON CONFLICT LP sortlist RP where_opt DO UPDATE SET setlist where_opt */
   240,  /* (154) upsert ::= ON CONFLICT LP sortlist RP where_opt DO NOTHING */
   240,  /* (155) upsert ::= ON CONFLICT DO NOTHING */
   238,  /* (156) insert_cmd ::= INSERT orconf */
   238,  /* (157) insert_cmd ::= REPLACE */
   239,  /* (158) idlist_opt ::= */
   239,  /* (159) idlist_opt ::= LP idlist RP */
   235,  /* (160) idlist ::= idlist COMMA nm */
   235,  /* (161) idlist ::= nm */
   189,  /* (162) expr ::= LP expr RP */
   189,  /* (163) expr ::= ID|INDEXED */
   189,  /* (164) expr ::= JOIN_KW */
   189,  /* (165) expr ::= nm DOT nm */
   189,  /* (166) expr ::= nm DOT nm DOT nm */
   188,  /* (167) term ::= NULL|FLOAT|BLOB */
   188,  /* (168) term ::= STRING */
   188,  /* (169) term ::= INTEGER */
   189,  /* (170) expr ::= VARIABLE */
   189,  /* (171) expr ::= expr COLLATE ID|STRING */
   189,  /* (172) expr ::= CAST LP expr AS typetoken RP */
   189,  /* (173) expr ::= ID|INDEXED LP distinct exprlist RP */
   189,  /* (174) expr ::= ID|INDEXED LP STAR RP */
   189,  /* (175) expr ::= ID|INDEXED LP distinct exprlist RP over_clause */
   189,  /* (176) expr ::= ID|INDEXED LP STAR RP over_clause */
   188,  /* (177) term ::= CTIME_KW */
   189,  /* (178) expr ::= LP nexprlist COMMA expr RP */
   189,  /* (179) expr ::= expr AND expr */
   189,  /* (180) expr ::= expr OR expr */
   189,  /* (181) expr ::= expr LT|GT|GE|LE expr */
   189,  /* (182) expr ::= expr EQ|NE expr */
   189,  /* (183) expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT expr */
   189,  /* (184) expr ::= expr PLUS|MINUS expr */
   189,  /* (185) expr ::= expr STAR|SLASH|REM expr */
   189,  /* (186) expr ::= expr CONCAT expr */
   242,  /* (187) likeop ::= NOT LIKE_KW|MATCH */
   189,  /* (188) expr ::= expr likeop expr */
   189,  /* (189) expr ::= expr likeop expr ESCAPE expr */
   189,  /* (190) expr ::= expr ISNULL|NOTNULL */
   189,  /* (191) expr ::= expr NOT NULL */
   189,  /* (192) expr ::= expr IS expr */
   189,  /* (193) expr ::= expr IS NOT expr */
   189,  /* (194) expr ::= NOT expr */
   189,  /* (195) expr ::= BITNOT expr */
   189,  /* (196) expr ::= PLUS|MINUS expr */
   243,  /* (197) between_op ::= BETWEEN */
   243,  /* (198) between_op ::= NOT BETWEEN */
   189,  /* (199) expr ::= expr between_op expr AND expr */
   244,  /* (200) in_op ::= IN */
   244,  /* (201) in_op ::= NOT IN */
   189,  /* (202) expr ::= expr in_op LP exprlist RP */
   189,  /* (203) expr ::= LP select RP */
   189,  /* (204) expr ::= expr in_op LP select RP */
   189,  /* (205) expr ::= expr in_op nm dbnm paren_exprlist */
   189,  /* (206) expr ::= EXISTS LP select RP */
   189,  /* (207) expr ::= CASE case_operand case_exprlist case_else END */
   247,  /* (208) case_exprlist ::= case_exprlist WHEN expr THEN expr */
   247,  /* (209) case_exprlist ::= WHEN expr THEN expr */
   248,  /* (210) case_else ::= ELSE expr */
   248,  /* (211) case_else ::= */
   246,  /* (212) case_operand ::= expr */
   246,  /* (213) case_operand ::= */
   233,  /* (214) exprlist ::= */
   224,  /* (215) nexprlist ::= nexprlist COMMA expr */
   224,  /* (216) nexprlist ::= expr */
   245,  /* (217) paren_exprlist ::= */
   245,  /* (218) paren_exprlist ::= LP exprlist RP */
   164,  /* (219) cmd ::= createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP sortlist RP where_opt */
   249,  /* (220) uniqueflag ::= UNIQUE */
   249,  /* (221) uniqueflag ::= */
   193,  /* (222) eidlist_opt ::= */
   193,  /* (223) eidlist_opt ::= LP eidlist RP */
   203,  /* (224) eidlist ::= eidlist COMMA nm collate sortorder */
   203,  /* (225) eidlist ::= nm collate sortorder */
   250,  /* (226) collate ::= */
   250,  /* (227) collate ::= COLLATE ID|STRING */
   164,  /* (228) cmd ::= DROP INDEX ifexists fullname */
   164,  /* (229) cmd ::= VACUUM vinto */
   164,  /* (230) cmd ::= VACUUM nm vinto */
   251,  /* (231) vinto ::= INTO expr */
   251,  /* (232) vinto ::= */
   164,  /* (233) cmd ::= PRAGMA nm dbnm */
   164,  /* (234) cmd ::= PRAGMA nm dbnm EQ nmnum */
   164,  /* (235) cmd ::= PRAGMA nm dbnm LP nmnum RP */
   164,  /* (236) cmd ::= PRAGMA nm dbnm EQ minus_num */
   164,  /* (237) cmd ::= PRAGMA nm dbnm LP minus_num RP */
   184,  /* (238) plus_num ::= PLUS INTEGER|FLOAT */
   185,  /* (239) minus_num ::= MINUS INTEGER|FLOAT */
   164,  /* (240) cmd ::= createkw trigger_decl BEGIN trigger_cmd_list END */
   253,  /* (241) trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause */
   255,  /* (242) trigger_time ::= BEFORE|AFTER */
   255,  /* (243) trigger_time ::= INSTEAD OF */
   255,  /* (244) trigger_time ::= */
   256,  /* (245) trigger_event ::= DELETE|INSERT */
   256,  /* (246) trigger_event ::= UPDATE */
   256,  /* (247) trigger_event ::= UPDATE OF idlist */
   258,  /* (248) when_clause ::= */
   258,  /* (249) when_clause ::= WHEN expr */
   254,  /* (250) trigger_cmd_list ::= trigger_cmd_list trigger_cmd SEMI */
   254,  /* (251) trigger_cmd_list ::= trigger_cmd SEMI */
   260,  /* (252) trnm ::= nm DOT nm */
   261,  /* (253) tridxby ::= INDEXED BY nm */
   261,  /* (254) tridxby ::= NOT INDEXED */
   259,  /* (255) trigger_cmd ::= UPDATE orconf trnm tridxby SET setlist where_opt scanpt */
   259,  /* (256) trigger_cmd ::= scanpt insert_cmd INTO trnm idlist_opt select upsert scanpt */
   259,  /* (257) trigger_cmd ::= DELETE FROM trnm tridxby where_opt scanpt */
   259,  /* (258) trigger_cmd ::= scanpt select scanpt */
   189,  /* (259) expr ::= RAISE LP IGNORE RP */
   189,  /* (260) expr ::= RAISE LP raisetype COMMA nm RP */
   207,  /* (261) raisetype ::= ROLLBACK */
   207,  /* (262) raisetype ::= ABORT */
   207,  /* (263) raisetype ::= FAIL */
   164,  /* (264) cmd ::= DROP TRIGGER ifexists fullname */
   164,  /* (265) cmd ::= ATTACH database_kw_opt expr AS expr key_opt */
   164,  /* (266) cmd ::= DETACH database_kw_opt expr */
   263,  /* (267) key_opt ::= */
   263,  /* (268) key_opt ::= KEY expr */
   164,  /* (269) cmd ::= REINDEX */
   164,  /* (270) cmd ::= REINDEX nm dbnm */
   164,  /* (271) cmd ::= ANALYZE */
   164,  /* (272) cmd ::= ANALYZE nm dbnm */
   164,  /* (273) cmd ::= ALTER TABLE fullname RENAME TO nm */
   164,  /* (274) cmd ::= ALTER TABLE add_column_fullname ADD kwcolumn_opt columnname carglist */
   264,  /* (275) add_column_fullname ::= fullname */
   164,  /* (276) cmd ::= ALTER TABLE fullname RENAME kwcolumn_opt nm TO nm */
   164,  /* (277) cmd ::= create_vtab */
   164,  /* (278) cmd ::= create_vtab LP vtabarglist RP */
   266,  /* (279) create_vtab ::= createkw VIRTUAL TABLE ifnotexists nm dbnm USING nm */
   268,  /* (280) vtabarg ::= */
   269,  /* (281) vtabargtoken ::= ANY */
   269,  /* (282) vtabargtoken ::= lp anylist RP */
   270,  /* (283) lp ::= LP */
   236,  /* (284) with ::= WITH wqlist */
   236,  /* (285) with ::= WITH RECURSIVE wqlist */
   212,  /* (286) wqlist ::= nm eidlist_opt AS LP select RP */
   212,  /* (287) wqlist ::= wqlist COMMA nm eidlist_opt AS LP select RP */
   272,  /* (288) windowdefn_list ::= windowdefn */
   272,  /* (289) windowdefn_list ::= windowdefn_list COMMA windowdefn */
   273,  /* (290) windowdefn ::= nm AS LP window RP */
   274,  /* (291) window ::= PARTITION BY nexprlist orderby_opt frame_opt */
   274,  /* (292) window ::= nm PARTITION BY nexprlist orderby_opt frame_opt */
   274,  /* (293) window ::= ORDER BY sortlist frame_opt */
   274,  /* (294) window ::= nm ORDER BY sortlist frame_opt */
   274,  /* (295) window ::= frame_opt */
   274,  /* (296) window ::= nm frame_opt */
   275,  /* (297) frame_opt ::= */
   275,  /* (298) frame_opt ::= range_or_rows frame_bound_s frame_exclude_opt */
   275,  /* (299) frame_opt ::= range_or_rows BETWEEN frame_bound_s AND frame_bound_e frame_exclude_opt */
   278,  /* (300) range_or_rows ::= RANGE|ROWS|GROUPS */
   280,  /* (301) frame_bound_s ::= frame_bound */
   280,  /* (302) frame_bound_s ::= UNBOUNDED PRECEDING */
   281,  /* (303) frame_bound_e ::= frame_bound */
   281,  /* (304) frame_bound_e ::= UNBOUNDED FOLLOWING */
   279,  /* (305) frame_bound ::= expr PRECEDING|FOLLOWING */
   279,  /* (306) frame_bound ::= CURRENT ROW */
   282,  /* (307) frame_exclude_opt ::= */
   282,  /* (308) frame_exclude_opt ::= EXCLUDE frame_exclude */
   283,  /* (309) frame_exclude ::= NO OTHERS */
   283,  /* (310) frame_exclude ::= CURRENT ROW */
   283,  /* (311) frame_exclude ::= GROUP|TIES */
   222,  /* (312) window_clause ::= WINDOW windowdefn_list */
   241,  /* (313) over_clause ::= filter_opt OVER LP window RP */
   241,  /* (314) over_clause ::= filter_opt OVER nm */
   277,  /* (315) filter_opt ::= */
   277,  /* (316) filter_opt ::= FILTER LP WHERE expr RP */
   159,  /* (317) input ::= cmdlist */
   160,  /* (318) cmdlist ::= cmdlist ecmd */
   160,  /* (319) cmdlist ::= ecmd */
   161,  /* (320) ecmd ::= SEMI */
   161,  /* (321) ecmd ::= cmdx SEMI */
   161,  /* (322) ecmd ::= explain cmdx */
   166,  /* (323) trans_opt ::= */
   166,  /* (324) trans_opt ::= TRANSACTION */
   166,  /* (325) trans_opt ::= TRANSACTION nm */
   168,  /* (326) savepoint_opt ::= SAVEPOINT */
   168,  /* (327) savepoint_opt ::= */
   164,  /* (328) cmd ::= create_table create_table_args */
   175,  /* (329) columnlist ::= columnlist COMMA columnname carglist */
   175,  /* (330) columnlist ::= columnname carglist */
   167,  /* (331) nm ::= ID|INDEXED */
   167,  /* (332) nm ::= STRING */
   167,  /* (333) nm ::= JOIN_KW */
   181,  /* (334) typetoken ::= typename */
   182,  /* (335) typename ::= ID|STRING */
   183,  /* (336) signed ::= plus_num */
   183,  /* (337) signed ::= minus_num */
   180,  /* (338) carglist ::= carglist ccons */
   180,  /* (339) carglist ::= */
   187,  /* (340) ccons ::= NULL onconf */
   176,  /* (341) conslist_opt ::= COMMA conslist */
   199,  /* (342) conslist ::= conslist tconscomma tcons */
   199,  /* (343) conslist ::= tcons */
   200,  /* (344) tconscomma ::= */
   204,  /* (345) defer_subclause_opt ::= defer_subclause */
   206,  /* (346) resolvetype ::= raisetype */
   210,  /* (347) selectnowith ::= oneselect */
   211,  /* (348) oneselect ::= values */
   225,  /* (349) sclp ::= selcollist COMMA */
   226,  /* (350) as ::= ID|STRING */
   189,  /* (351) expr ::= term */
   242,  /* (352) likeop ::= LIKE_KW|MATCH */
   233,  /* (353) exprlist ::= nexprlist */
   252,  /* (354) nmnum ::= plus_num */
   252,  /* (355) nmnum ::= nm */
   252,  /* (356) nmnum ::= ON */
   252,  /* (357) nmnum ::= DELETE */
   252,  /* (358) nmnum ::= DEFAULT */
   184,  /* (359) plus_num ::= INTEGER|FLOAT */
   257,  /* (360) foreach_clause ::= */
   257,  /* (361) foreach_clause ::= FOR EACH ROW */
   260,  /* (362) trnm ::= nm */
   261,  /* (363) tridxby ::= */
   262,  /* (364) database_kw_opt ::= DATABASE */
   262,  /* (365) database_kw_opt ::= */
   265,  /* (366) kwcolumn_opt ::= */
   265,  /* (367) kwcolumn_opt ::= COLUMNKW */
   267,  /* (368) vtabarglist ::= vtabarg */
   267,  /* (369) vtabarglist ::= vtabarglist COMMA vtabarg */
   268,  /* (370) vtabarg ::= vtabarg vtabargtoken */
   271,  /* (371) anylist ::= */
   271,  /* (372) anylist ::= anylist LP anylist RP */
   271,  /* (373) anylist ::= anylist ANY */
   236,  /* (374) with ::= */
};

/* For rule J, yyRuleInfoNRhs[J] contains the negative of the number
** of symbols on the right-hand side of that rule. */
static const signed char yyRuleInfoNRhs[] = {
   -1,  /* (0) explain ::= EXPLAIN */
   -3,  /* (1) explain ::= EXPLAIN QUERY PLAN */

      case 1: /* explain ::= EXPLAIN QUERY PLAN */
{ pParse->explain = 2; }
        break;
      case 2: /* cmdx ::= cmd */
{ sqlite3FinishCoding(pParse); }
        break;
      case 3: /* cmd ::= BEGIN transtype trans_opt */
{sqlite3BeginTransaction(pParse, yymsp[-1].minor.yy420);}
        break;
      case 4: /* transtype ::= */
{yymsp[1].minor.yy420 = TK_DEFERRED;}
        break;
      case 5: /* transtype ::= DEFERRED */
      case 6: /* transtype ::= IMMEDIATE */ yytestcase(yyruleno==6);
      case 7: /* transtype ::= EXCLUSIVE */ yytestcase(yyruleno==7);
      case 300: /* range_or_rows ::= RANGE|ROWS|GROUPS */ yytestcase(yyruleno==300);
{yymsp[0].minor.yy420 = yymsp[0].major; /*A-overwrites-X*/}
        break;
      case 8: /* cmd ::= COMMIT|END trans_opt */
      case 9: /* cmd ::= ROLLBACK trans_opt */ yytestcase(yyruleno==9);
{sqlite3EndTransaction(pParse,yymsp[-1].major);}
        break;
      case 10: /* cmd ::= SAVEPOINT nm */
{

      case 12: /* cmd ::= ROLLBACK trans_opt TO savepoint_opt nm */
{
  sqlite3Savepoint(pParse, SAVEPOINT_ROLLBACK, &yymsp[0].minor.yy0);
}
        break;
      case 13: /* create_table ::= createkw temp TABLE ifnotexists nm dbnm */
{
   sqlite3StartTable(pParse,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy0,yymsp[-4].minor.yy420,0,0,yymsp[-2].minor.yy420);
}
        break;
      case 14: /* createkw ::= CREATE */
{disableLookaside(pParse);}
        break;
      case 15: /* ifnotexists ::= */
      case 18: /* temp ::= */ yytestcase(yyruleno==18);
      case 21: /* table_options ::= */ yytestcase(yyruleno==21);
      case 42: /* autoinc ::= */ yytestcase(yyruleno==42);
      case 57: /* init_deferred_pred_opt ::= */ yytestcase(yyruleno==57);
      case 67: /* defer_subclause_opt ::= */ yytestcase(yyruleno==67);
      case 76: /* ifexists ::= */ yytestcase(yyruleno==76);
      case 93: /* distinct ::= */ yytestcase(yyruleno==93);
      case 226: /* collate ::= */ yytestcase(yyruleno==226);
{yymsp[1].minor.yy420 = 0;}
        break;
      case 16: /* ifnotexists ::= IF NOT EXISTS */
{yymsp[-2].minor.yy420 = 1;}
        break;
      case 17: /* temp ::= TEMP */
      case 43: /* autoinc ::= AUTOINCR */ yytestcase(yyruleno==43);
{yymsp[0].minor.yy420 = 1;}
        break;
      case 19: /* create_table_args ::= LP columnlist conslist_opt RP table_options */
{
  sqlite3EndTable(pParse,&yymsp[-2].minor.yy0,&yymsp[-1].minor.yy0,yymsp[0].minor.yy420,0);
}
        break;
      case 20: /* create_table_args ::= AS select */
{
  sqlite3EndTable(pParse,0,0,0,yymsp[0].minor.yy491);
  sqlite3SelectDelete(pParse->db, yymsp[0].minor.yy491);
}
        break;
      case 22: /* table_options ::= WITHOUT nm */
{
  if( yymsp[0].minor.yy0.n==5 && sqlite3_strnicmp(yymsp[0].minor.yy0.z,"rowid",5)==0 ){
    yymsp[-1].minor.yy420 = TF_WithoutRowid | TF_NoVisibleRowid;
  }else{
    yymsp[-1].minor.yy420 = 0;
    sqlite3ErrorMsg(pParse, "unknown table option: %.*s", yymsp[0].minor.yy0.n, yymsp[0].minor.yy0.z);
  }
}
        break;
      case 23: /* columnname ::= nm typetoken */
{sqlite3AddColumn(pParse,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy0);}
        break;

        break;
      case 27: /* typename ::= typename ID|STRING */
{yymsp[-1].minor.yy0.n=yymsp[0].minor.yy0.n+(int)(yymsp[0].minor.yy0.z-yymsp[-1].minor.yy0.z);}
        break;
      case 28: /* scanpt ::= */
{
  assert( yyLookahead!=YYNOCODE );
  yymsp[1].minor.yy104 = yyLookaheadToken.z;
}
        break;
      case 29: /* ccons ::= CONSTRAINT nm */
      case 62: /* tcons ::= CONSTRAINT nm */ yytestcase(yyruleno==62);
{pParse->constraintName = yymsp[0].minor.yy0;}
        break;
      case 30: /* ccons ::= DEFAULT scanpt term scanpt */
{sqlite3AddDefaultValue(pParse,yymsp[-1].minor.yy130,yymsp[-2].minor.yy104,yymsp[0].minor.yy104);}
        break;
      case 31: /* ccons ::= DEFAULT LP expr RP */
{sqlite3AddDefaultValue(pParse,yymsp[-1].minor.yy130,yymsp[-2].minor.yy0.z+1,yymsp[0].minor.yy0.z);}
        break;
      case 32: /* ccons ::= DEFAULT PLUS term scanpt */
{sqlite3AddDefaultValue(pParse,yymsp[-1].minor.yy130,yymsp[-2].minor.yy0.z,yymsp[0].minor.yy104);}
        break;
      case 33: /* ccons ::= DEFAULT MINUS term scanpt */
{
  Expr *p = sqlite3PExpr(pParse, TK_UMINUS, yymsp[-1].minor.yy130, 0);
  sqlite3AddDefaultValue(pParse,p,yymsp[-2].minor.yy0.z,yymsp[0].minor.yy104);
}
        break;
      case 34: /* ccons ::= DEFAULT scanpt ID|INDEXED */
{
  Expr *p = tokenExpr(pParse, TK_STRING, yymsp[0].minor.yy0);
  if( p ){
    sqlite3ExprIdToTrueFalse(p);
    testcase( p->op==TK_TRUEFALSE && sqlite3ExprTruthValue(p) );
  }
    sqlite3AddDefaultValue(pParse,p,yymsp[0].minor.yy0.z,yymsp[0].minor.yy0.z+yymsp[0].minor.yy0.n);
}
        break;
      case 35: /* ccons ::= NOT NULL onconf */
{sqlite3AddNotNull(pParse, yymsp[0].minor.yy420);}
        break;
      case 36: /* ccons ::= PRIMARY KEY sortorder onconf autoinc */
{sqlite3AddPrimaryKey(pParse,0,yymsp[-1].minor.yy420,yymsp[0].minor.yy420,yymsp[-2].minor.yy420);}
        break;
      case 37: /* ccons ::= UNIQUE onconf */
{sqlite3CreateIndex(pParse,0,0,0,0,yymsp[0].minor.yy420,0,0,0,0,
                                   SQLITE_IDXTYPE_UNIQUE);}
        break;
      case 38: /* ccons ::= CHECK LP expr RP */
{sqlite3AddCheckConstraint(pParse,yymsp[-1].minor.yy130);}
        break;
      case 39: /* ccons ::= REFERENCES nm eidlist_opt refargs */
{sqlite3CreateForeignKey(pParse,0,&yymsp[-2].minor.yy0,yymsp[-1].minor.yy442,yymsp[0].minor.yy420);}
        break;
      case 40: /* ccons ::= defer_subclause */
{sqlite3DeferForeignKey(pParse,yymsp[0].minor.yy420);}
        break;
      case 41: /* ccons ::= COLLATE ID|STRING */
{sqlite3AddCollateType(pParse, &yymsp[0].minor.yy0);}
        break;
      case 44: /* refargs ::= */
{ yymsp[1].minor.yy420 = OE_None*0x0101; /* EV: R-19803-45884 */}
        break;
      case 45: /* refargs ::= refargs refarg */
{ yymsp[-1].minor.yy420 = (yymsp[-1].minor.yy420 & ~yymsp[0].minor.yy527.mask) | yymsp[0].minor.yy527.value; }
        break;
      case 46: /* refarg ::= MATCH nm */
{ yymsp[-1].minor.yy527.value = 0;     yymsp[-1].minor.yy527.mask = 0x000000; }
        break;
      case 47: /* refarg ::= ON INSERT refact */
{ yymsp[-2].minor.yy527.value = 0;     yymsp[-2].minor.yy527.mask = 0x000000; }
        break;
      case 48: /* refarg ::= ON DELETE refact */
{ yymsp[-2].minor.yy527.value = yymsp[0].minor.yy420;     yymsp[-2].minor.yy527.mask = 0x0000ff; }
        break;
      case 49: /* refarg ::= ON UPDATE refact */
{ yymsp[-2].minor.yy527.value = yymsp[0].minor.yy420<<8;  yymsp[-2].minor.yy527.mask = 0x00ff00; }
        break;
      case 50: /* refact ::= SET NULL */
{ yymsp[-1].minor.yy420 = OE_SetNull;  /* EV: R-33326-45252 */}
        break;
      case 51: /* refact ::= SET DEFAULT */
{ yymsp[-1].minor.yy420 = OE_SetDflt;  /* EV: R-33326-45252 */}
        break;
      case 52: /* refact ::= CASCADE */
{ yymsp[0].minor.yy420 = OE_Cascade;  /* EV: R-33326-45252 */}
        break;
      case 53: /* refact ::= RESTRICT */
{ yymsp[0].minor.yy420 = OE_Restrict; /* EV: R-33326-45252 */}
        break;
      case 54: /* refact ::= NO ACTION */
{ yymsp[-1].minor.yy420 = OE_None;     /* EV: R-33326-45252 */}
        break;
      case 55: /* defer_subclause ::= NOT DEFERRABLE init_deferred_pred_opt */
{yymsp[-2].minor.yy420 = 0;}
        break;
      case 56: /* defer_subclause ::= DEFERRABLE init_deferred_pred_opt */
      case 71: /* orconf ::= OR resolvetype */ yytestcase(yyruleno==71);
      case 156: /* insert_cmd ::= INSERT orconf */ yytestcase(yyruleno==156);
{yymsp[-1].minor.yy420 = yymsp[0].minor.yy420;}
        break;
      case 58: /* init_deferred_pred_opt ::= INITIALLY DEFERRED */
      case 75: /* ifexists ::= IF EXISTS */ yytestcase(yyruleno==75);
      case 198: /* between_op ::= NOT BETWEEN */ yytestcase(yyruleno==198);
      case 201: /* in_op ::= NOT IN */ yytestcase(yyruleno==201);
      case 227: /* collate ::= COLLATE ID|STRING */ yytestcase(yyruleno==227);
{yymsp[-1].minor.yy420 = 1;}
        break;
      case 59: /* init_deferred_pred_opt ::= INITIALLY IMMEDIATE */
{yymsp[-1].minor.yy420 = 0;}
        break;
      case 61: /* tconscomma ::= COMMA */
{pParse->constraintName.n = 0;}
        break;
      case 63: /* tcons ::= PRIMARY KEY LP sortlist autoinc RP onconf */
{sqlite3AddPrimaryKey(pParse,yymsp[-3].minor.yy442,yymsp[0].minor.yy420,yymsp[-2].minor.yy420,0);}
        break;
      case 64: /* tcons ::= UNIQUE LP sortlist RP onconf */
{sqlite3CreateIndex(pParse,0,0,0,yymsp[-2].minor.yy442,yymsp[0].minor.yy420,0,0,0,0,
                                       SQLITE_IDXTYPE_UNIQUE);}
        break;
      case 65: /* tcons ::= CHECK LP expr RP onconf */
{sqlite3AddCheckConstraint(pParse,yymsp[-2].minor.yy130);}
        break;
      case 66: /* tcons ::= FOREIGN KEY LP eidlist RP REFERENCES nm eidlist_opt refargs defer_subclause_opt */
{
    sqlite3CreateForeignKey(pParse, yymsp[-6].minor.yy442, &yymsp[-3].minor.yy0, yymsp[-2].minor.yy442, yymsp[-1].minor.yy420);
    sqlite3DeferForeignKey(pParse, yymsp[0].minor.yy420);
}
        break;
      case 68: /* onconf ::= */
      case 70: /* orconf ::= */ yytestcase(yyruleno==70);
{yymsp[1].minor.yy420 = OE_Default;}
        break;
      case 69: /* onconf ::= ON CONFLICT resolvetype */
{yymsp[-2].minor.yy420 = yymsp[0].minor.yy420;}
        break;
      case 72: /* resolvetype ::= IGNORE */
{yymsp[0].minor.yy420 = OE_Ignore;}
        break;
      case 73: /* resolvetype ::= REPLACE */
      case 157: /* insert_cmd ::= REPLACE */ yytestcase(yyruleno==157);
{yymsp[0].minor.yy420 = OE_Replace;}
        break;
      case 74: /* cmd ::= DROP TABLE ifexists fullname */
{
  sqlite3DropTable(pParse, yymsp[0].minor.yy147, 0, yymsp[-1].minor.yy420);
}
        break;
      case 77: /* cmd ::= createkw temp VIEW ifnotexists nm dbnm eidlist_opt AS select */
{
  sqlite3CreateView(pParse, &yymsp[-8].minor.yy0, &yymsp[-4].minor.yy0, &yymsp[-3].minor.yy0, yymsp[-2].minor.yy442, yymsp[0].minor.yy491, yymsp[-7].minor.yy420, yymsp[-5].minor.yy420);
}
        break;
      case 78: /* cmd ::= DROP VIEW ifexists fullname */
{
  sqlite3DropTable(pParse, yymsp[0].minor.yy147, 1, yymsp[-1].minor.yy420);
}
        break;
      case 79: /* cmd ::= select */
{
  SelectDest dest = {SRT_Output, 0, 0, 0, 0, 0};
  sqlite3Select(pParse, yymsp[0].minor.yy491, &dest);
  sqlite3SelectDelete(pParse->db, yymsp[0].minor.yy491);
}
        break;
      case 80: /* select ::= WITH wqlist selectnowith */
{
  Select *p = yymsp[0].minor.yy491;
  if( p ){
    p->pWith = yymsp[-1].minor.yy523;
    parserDoubleLinkSelect(pParse, p);
  }else{
    sqlite3WithDelete(pParse->db, yymsp[-1].minor.yy523);
  }
  yymsp[-2].minor.yy491 = p;
}
        break;
      case 81: /* select ::= WITH RECURSIVE wqlist selectnowith */
{
  Select *p = yymsp[0].minor.yy491;
  if( p ){
    p->pWith = yymsp[-1].minor.yy523;
    parserDoubleLinkSelect(pParse, p);
  }else{
    sqlite3WithDelete(pParse->db, yymsp[-1].minor.yy523);
  }
  yymsp[-3].minor.yy491 = p;
}
        break;
      case 82: /* select ::= selectnowith */
{
  Select *p = yymsp[0].minor.yy491;
  if( p ){
    parserDoubleLinkSelect(pParse, p);
  }
  yymsp[0].minor.yy491 = p; /*A-overwrites-X*/
}
        break;
      case 83: /* selectnowith ::= selectnowith multiselect_op oneselect */
{
  Select *pRhs = yymsp[0].minor.yy491;
  Select *pLhs = yymsp[-2].minor.yy491;
  if( pRhs && pRhs->pPrior ){
    SrcList *pFrom;
    Token x;
    x.n = 0;
    parserDoubleLinkSelect(pParse, pRhs);
    pFrom = sqlite3SrcListAppendFromTerm(pParse,0,0,0,&x,pRhs,0,0);
    pRhs = sqlite3SelectNew(pParse,0,pFrom,0,0,0,0,0,0);
  }
  if( pRhs ){
    pRhs->op = (u8)yymsp[-1].minor.yy420;
    pRhs->pPrior = pLhs;
    if( ALWAYS(pLhs) ) pLhs->selFlags &= ~SF_MultiValue;
    pRhs->selFlags &= ~SF_MultiValue;
    if( yymsp[-1].minor.yy420!=TK_ALL ) pParse->hasCompound = 1;
  }else{
    sqlite3SelectDelete(pParse->db, pLhs);
  }
  yymsp[-2].minor.yy491 = pRhs;
}
        break;
      case 84: /* multiselect_op ::= UNION */
      case 86: /* multiselect_op ::= EXCEPT|INTERSECT */ yytestcase(yyruleno==86);
{yymsp[0].minor.yy420 = yymsp[0].major; /*A-overwrites-OP*/}
        break;
      case 85: /* multiselect_op ::= UNION ALL */
{yymsp[-1].minor.yy420 = TK_ALL;}
        break;
      case 87: /* oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt */
{
  yymsp[-8].minor.yy491 = sqlite3SelectNew(pParse,yymsp[-6].minor.yy442,yymsp[-5].minor.yy147,yymsp[-4].minor.yy130,yymsp[-3].minor.yy442,yymsp[-2].minor.yy130,yymsp[-1].minor.yy442,yymsp[-7].minor.yy420,yymsp[0].minor.yy130);
}
        break;
      case 88: /* oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt window_clause orderby_opt limit_opt */
{
  yymsp[-9].minor.yy491 = sqlite3SelectNew(pParse,yymsp[-7].minor.yy442,yymsp[-6].minor.yy147,yymsp[-5].minor.yy130,yymsp[-4].minor.yy442,yymsp[-3].minor.yy130,yymsp[-1].minor.yy442,yymsp[-8].minor.yy420,yymsp[0].minor.yy130);
  if( yymsp[-9].minor.yy491 ){
    yymsp[-9].minor.yy491->pWinDefn = yymsp[-2].minor.yy395;
  }else{
    sqlite3WindowListDelete(pParse->db, yymsp[-2].minor.yy395);
  }
}
        break;
      case 89: /* values ::= VALUES LP nexprlist RP */
{
  yymsp[-3].minor.yy491 = sqlite3SelectNew(pParse,yymsp[-1].minor.yy442,0,0,0,0,0,SF_Values,0);
}
        break;
      case 90: /* values ::= values COMMA LP nexprlist RP */
{
  Select *pRight, *pLeft = yymsp[-4].minor.yy491;
  pRight = sqlite3SelectNew(pParse,yymsp[-1].minor.yy442,0,0,0,0,0,SF_Values|SF_MultiValue,0);
  if( ALWAYS(pLeft) ) pLeft->selFlags &= ~SF_MultiValue;
  if( pRight ){
    pRight->op = TK_ALL;
    pRight->pPrior = pLeft;
    yymsp[-4].minor.yy491 = pRight;
  }else{
    yymsp[-4].minor.yy491 = pLeft;
  }
}
        break;
      case 91: /* distinct ::= DISTINCT */
{yymsp[0].minor.yy420 = SF_Distinct;}
        break;
      case 92: /* distinct ::= ALL */
{yymsp[0].minor.yy420 = SF_All;}
        break;
      case 94: /* sclp ::= */
      case 127: /* orderby_opt ::= */ yytestcase(yyruleno==127);
      case 134: /* groupby_opt ::= */ yytestcase(yyruleno==134);
      case 214: /* exprlist ::= */ yytestcase(yyruleno==214);
      case 217: /* paren_exprlist ::= */ yytestcase(yyruleno==217);
      case 222: /* eidlist_opt ::= */ yytestcase(yyruleno==222);
{yymsp[1].minor.yy442 = 0;}
        break;
      case 95: /* selcollist ::= sclp scanpt expr scanpt as */
{
   yymsp[-4].minor.yy442 = sqlite3ExprListAppend(pParse, yymsp[-4].minor.yy442, yymsp[-2].minor.yy130);
   if( yymsp[0].minor.yy0.n>0 ) sqlite3ExprListSetName(pParse, yymsp[-4].minor.yy442, &yymsp[0].minor.yy0, 1);
   sqlite3ExprListSetSpan(pParse,yymsp[-4].minor.yy442,yymsp[-3].minor.yy104,yymsp[-1].minor.yy104);
}
        break;
      case 96: /* selcollist ::= sclp scanpt STAR */
{
  Expr *p = sqlite3Expr(pParse->db, TK_ASTERISK, 0);
  yymsp[-2].minor.yy442 = sqlite3ExprListAppend(pParse, yymsp[-2].minor.yy442, p);
}
        break;
      case 97: /* selcollist ::= sclp scanpt nm DOT STAR */
{
  Expr *pRight = sqlite3PExpr(pParse, TK_ASTERISK, 0, 0);
  Expr *pLeft = sqlite3ExprAlloc(pParse->db, TK_ID, &yymsp[-2].minor.yy0, 1);
  Expr *pDot = sqlite3PExpr(pParse, TK_DOT, pLeft, pRight);
  yymsp[-4].minor.yy442 = sqlite3ExprListAppend(pParse,yymsp[-4].minor.yy442, pDot);
}
        break;
      case 98: /* as ::= AS nm */
      case 109: /* dbnm ::= DOT nm */ yytestcase(yyruleno==109);
      case 238: /* plus_num ::= PLUS INTEGER|FLOAT */ yytestcase(yyruleno==238);
      case 239: /* minus_num ::= MINUS INTEGER|FLOAT */ yytestcase(yyruleno==239);
{yymsp[-1].minor.yy0 = yymsp[0].minor.yy0;}
        break;
      case 100: /* from ::= */
{yymsp[1].minor.yy147 = sqlite3DbMallocZero(pParse->db, sizeof(*yymsp[1].minor.yy147));}
        break;
      case 101: /* from ::= FROM seltablist */
{
  yymsp[-1].minor.yy147 = yymsp[0].minor.yy147;
  sqlite3SrcListShiftJoinType(yymsp[-1].minor.yy147);
}
        break;
      case 102: /* stl_prefix ::= seltablist joinop */
{
   if( ALWAYS(yymsp[-1].minor.yy147 && yymsp[-1].minor.yy147->nSrc>0) ) yymsp[-1].minor.yy147->a[yymsp[-1].minor.yy147->nSrc-1].fg.jointype = (u8)yymsp[0].minor.yy420;
}
        break;
      case 103: /* stl_prefix ::= */
{yymsp[1].minor.yy147 = 0;}
        break;
      case 104: /* seltablist ::= stl_prefix nm dbnm as indexed_opt on_opt using_opt */
{
  yymsp[-6].minor.yy147 = sqlite3SrcListAppendFromTerm(pParse,yymsp[-6].minor.yy147,&yymsp[-5].minor.yy0,&yymsp[-4].minor.yy0,&yymsp[-3].minor.yy0,0,yymsp[-1].minor.yy130,yymsp[0].minor.yy200);
  sqlite3SrcListIndexedBy(pParse, yymsp[-6].minor.yy147, &yymsp[-2].minor.yy0);
}
        break;
      case 105: /* seltablist ::= stl_prefix nm dbnm LP exprlist RP as on_opt using_opt */
{
  yymsp[-8].minor.yy147 = sqlite3SrcListAppendFromTerm(pParse,yymsp[-8].minor.yy147,&yymsp[-7].minor.yy0,&yymsp[-6].minor.yy0,&yymsp[-2].minor.yy0,0,yymsp[-1].minor.yy130,yymsp[0].minor.yy200);
  sqlite3SrcListFuncArgs(pParse, yymsp[-8].minor.yy147, yymsp[-4].minor.yy442);
}
        break;
      case 106: /* seltablist ::= stl_prefix LP select RP as on_opt using_opt */
{
    yymsp[-6].minor.yy147 = sqlite3SrcListAppendFromTerm(pParse,yymsp[-6].minor.yy147,0,0,&yymsp[-2].minor.yy0,yymsp[-4].minor.yy491,yymsp[-1].minor.yy130,yymsp[0].minor.yy200);
  }
        break;
      case 107: /* seltablist ::= stl_prefix LP seltablist RP as on_opt using_opt */
{
    if( yymsp[-6].minor.yy147==0 && yymsp[-2].minor.yy0.n==0 && yymsp[-1].minor.yy130==0 && yymsp[0].minor.yy200==0 ){
      yymsp[-6].minor.yy147 = yymsp[-4].minor.yy147;
    }else if( yymsp[-4].minor.yy147->nSrc==1 ){
      yymsp[-6].minor.yy147 = sqlite3SrcListAppendFromTerm(pParse,yymsp[-6].minor.yy147,0,0,&yymsp[-2].minor.yy0,0,yymsp[-1].minor.yy130,yymsp[0].minor.yy200);
      if( yymsp[-6].minor.yy147 ){
        struct SrcList_item *pNew = &yymsp[-6].minor.yy147->a[yymsp[-6].minor.yy147->nSrc-1];
        struct SrcList_item *pOld = yymsp[-4].minor.yy147->a;
        pNew->zName = pOld->zName;
        pNew->zDatabase = pOld->zDatabase;
        pNew->pSelect = pOld->pSelect;
        if( pOld->fg.isTabFunc ){
          pNew->u1.pFuncArg = pOld->u1.pFuncArg;
          pOld->u1.pFuncArg = 0;
          pOld->fg.isTabFunc = 0;
          pNew->fg.isTabFunc = 1;
        }
        pOld->zName = pOld->zDatabase = 0;
        pOld->pSelect = 0;
      }
      sqlite3SrcListDelete(pParse->db, yymsp[-4].minor.yy147);
    }else{
      Select *pSubquery;
      sqlite3SrcListShiftJoinType(yymsp[-4].minor.yy147);
      pSubquery = sqlite3SelectNew(pParse,0,yymsp[-4].minor.yy147,0,0,0,0,SF_NestedFrom,0);
      yymsp[-6].minor.yy147 = sqlite3SrcListAppendFromTerm(pParse,yymsp[-6].minor.yy147,0,0,&yymsp[-2].minor.yy0,pSubquery,yymsp[-1].minor.yy130,yymsp[0].minor.yy200);
    }
  }
        break;
      case 108: /* dbnm ::= */
      case 122: /* indexed_opt ::= */ yytestcase(yyruleno==122);
{yymsp[1].minor.yy0.z=0; yymsp[1].minor.yy0.n=0;}
        break;
      case 110: /* fullname ::= nm */
{
  yylhsminor.yy147 = sqlite3SrcListAppend(pParse,0,&yymsp[0].minor.yy0,0);
  if( IN_RENAME_OBJECT && yylhsminor.yy147 ) sqlite3RenameTokenMap(pParse, yylhsminor.yy147->a[0].zName, &yymsp[0].minor.yy0);
}
  yymsp[0].minor.yy147 = yylhsminor.yy147;
        break;
      case 111: /* fullname ::= nm DOT nm */
{
  yylhsminor.yy147 = sqlite3SrcListAppend(pParse,0,&yymsp[-2].minor.yy0,&yymsp[0].minor.yy0);
  if( IN_RENAME_OBJECT && yylhsminor.yy147 ) sqlite3RenameTokenMap(pParse, yylhsminor.yy147->a[0].zName, &yymsp[0].minor.yy0);
}
  yymsp[-2].minor.yy147 = yylhsminor.yy147;
        break;
      case 112: /* xfullname ::= nm */
{yymsp[0].minor.yy147 = sqlite3SrcListAppend(pParse,0,&yymsp[0].minor.yy0,0); /*A-overwrites-X*/}
        break;
      case 113: /* xfullname ::= nm DOT nm */
{yymsp[-2].minor.yy147 = sqlite3SrcListAppend(pParse,0,&yymsp[-2].minor.yy0,&yymsp[0].minor.yy0); /*A-overwrites-X*/}
        break;
      case 114: /* xfullname ::= nm DOT nm AS nm */
{
   yymsp[-4].minor.yy147 = sqlite3SrcListAppend(pParse,0,&yymsp[-4].minor.yy0,&yymsp[-2].minor.yy0); /*A-overwrites-X*/
   if( yymsp[-4].minor.yy147 ) yymsp[-4].minor.yy147->a[0].zAlias = sqlite3NameFromToken(pParse->db, &yymsp[0].minor.yy0);
}
        break;
      case 115: /* xfullname ::= nm AS nm */
{  
   yymsp[-2].minor.yy147 = sqlite3SrcListAppend(pParse,0,&yymsp[-2].minor.yy0,0); /*A-overwrites-X*/
   if( yymsp[-2].minor.yy147 ) yymsp[-2].minor.yy147->a[0].zAlias = sqlite3NameFromToken(pParse->db, &yymsp[0].minor.yy0);
}
        break;
      case 116: /* joinop ::= COMMA|JOIN */
{ yymsp[0].minor.yy420 = JT_INNER; }
        break;
      case 117: /* joinop ::= JOIN_KW JOIN */
{yymsp[-1].minor.yy420 = sqlite3JoinType(pParse,&yymsp[-1].minor.yy0,0,0);  /*X-overwrites-A*/}
        break;
      case 118: /* joinop ::= JOIN_KW nm JOIN */
{yymsp[-2].minor.yy420 = sqlite3JoinType(pParse,&yymsp[-2].minor.yy0,&yymsp[-1].minor.yy0,0); /*X-overwrites-A*/}
        break;
      case 119: /* joinop ::= JOIN_KW nm nm JOIN */
{yymsp[-3].minor.yy420 = sqlite3JoinType(pParse,&yymsp[-3].minor.yy0,&yymsp[-2].minor.yy0,&yymsp[-1].minor.yy0);/*X-overwrites-A*/}
        break;
      case 120: /* on_opt ::= ON expr */
      case 137: /* having_opt ::= HAVING expr */ yytestcase(yyruleno==137);
      case 144: /* where_opt ::= WHERE expr */ yytestcase(yyruleno==144);
      case 210: /* case_else ::= ELSE expr */ yytestcase(yyruleno==210);
      case 231: /* vinto ::= INTO expr */ yytestcase(yyruleno==231);
{yymsp[-1].minor.yy130 = yymsp[0].minor.yy130;}
        break;
      case 121: /* on_opt ::= */
      case 136: /* having_opt ::= */ yytestcase(yyruleno==136);
      case 138: /* limit_opt ::= */ yytestcase(yyruleno==138);
      case 143: /* where_opt ::= */ yytestcase(yyruleno==143);
      case 211: /* case_else ::= */ yytestcase(yyruleno==211);
      case 213: /* case_operand ::= */ yytestcase(yyruleno==213);
      case 232: /* vinto ::= */ yytestcase(yyruleno==232);
{yymsp[1].minor.yy130 = 0;}
        break;
      case 123: /* indexed_opt ::= INDEXED BY nm */
{yymsp[-2].minor.yy0 = yymsp[0].minor.yy0;}
        break;
      case 124: /* indexed_opt ::= NOT INDEXED */
{yymsp[-1].minor.yy0.z=0; yymsp[-1].minor.yy0.n=1;}
        break;
      case 125: /* using_opt ::= USING LP idlist RP */
{yymsp[-3].minor.yy200 = yymsp[-1].minor.yy200;}
        break;
      case 126: /* using_opt ::= */
      case 158: /* idlist_opt ::= */ yytestcase(yyruleno==158);
{yymsp[1].minor.yy200 = 0;}
        break;
      case 128: /* orderby_opt ::= ORDER BY sortlist */
      case 135: /* groupby_opt ::= GROUP BY nexprlist */ yytestcase(yyruleno==135);
{yymsp[-2].minor.yy442 = yymsp[0].minor.yy442;}
        break;
      case 129: /* sortlist ::= sortlist COMMA expr sortorder */
{
  yymsp[-3].minor.yy442 = sqlite3ExprListAppend(pParse,yymsp[-3].minor.yy442,yymsp[-1].minor.yy130);
  sqlite3ExprListSetSortOrder(yymsp[-3].minor.yy442,yymsp[0].minor.yy420);
}
        break;
      case 130: /* sortlist ::= expr sortorder */
{
  yymsp[-1].minor.yy442 = sqlite3ExprListAppend(pParse,0,yymsp[-1].minor.yy130); /*A-overwrites-Y*/
  sqlite3ExprListSetSortOrder(yymsp[-1].minor.yy442,yymsp[0].minor.yy420);
}
        break;
      case 131: /* sortorder ::= ASC */
{yymsp[0].minor.yy420 = SQLITE_SO_ASC;}
        break;
      case 132: /* sortorder ::= DESC */
{yymsp[0].minor.yy420 = SQLITE_SO_DESC;}
        break;
      case 133: /* sortorder ::= */
{yymsp[1].minor.yy420 = SQLITE_SO_UNDEFINED;}
        break;
      case 139: /* limit_opt ::= LIMIT expr */
{yymsp[-1].minor.yy130 = sqlite3PExpr(pParse,TK_LIMIT,yymsp[0].minor.yy130,0);}
        break;
      case 140: /* limit_opt ::= LIMIT expr OFFSET expr */
{yymsp[-3].minor.yy130 = sqlite3PExpr(pParse,TK_LIMIT,yymsp[-2].minor.yy130,yymsp[0].minor.yy130);}
        break;
      case 141: /* limit_opt ::= LIMIT expr COMMA expr */
{yymsp[-3].minor.yy130 = sqlite3PExpr(pParse,TK_LIMIT,yymsp[0].minor.yy130,yymsp[-2].minor.yy130);}
        break;
      case 142: /* cmd ::= with DELETE FROM xfullname indexed_opt where_opt */
{
  sqlite3SrcListIndexedBy(pParse, yymsp[-2].minor.yy147, &yymsp[-1].minor.yy0);
  sqlite3DeleteFrom(pParse,yymsp[-2].minor.yy147,yymsp[0].minor.yy130,0,0);
}
        break;
      case 145: /* cmd ::= with UPDATE orconf xfullname indexed_opt SET setlist where_opt */
{
  sqlite3SrcListIndexedBy(pParse, yymsp[-4].minor.yy147, &yymsp[-3].minor.yy0);
  sqlite3ExprListCheckLength(pParse,yymsp[-1].minor.yy442,"set list"); 
  sqlite3Update(pParse,yymsp[-4].minor.yy147,yymsp[-1].minor.yy442,yymsp[0].minor.yy130,yymsp[-5].minor.yy420,0,0,0);
}
        break;
      case 146: /* setlist ::= setlist COMMA nm EQ expr */
{
  yymsp[-4].minor.yy442 = sqlite3ExprListAppend(pParse, yymsp[-4].minor.yy442, yymsp[0].minor.yy130);
  sqlite3ExprListSetName(pParse, yymsp[-4].minor.yy442, &yymsp[-2].minor.yy0, 1);
}
        break;
      case 147: /* setlist ::= setlist COMMA LP idlist RP EQ expr */
{
  yymsp[-6].minor.yy442 = sqlite3ExprListAppendVector(pParse, yymsp[-6].minor.yy442, yymsp[-3].minor.yy200, yymsp[0].minor.yy130);
}
        break;
      case 148: /* setlist ::= nm EQ expr */
{
  yylhsminor.yy442 = sqlite3ExprListAppend(pParse, 0, yymsp[0].minor.yy130);
  sqlite3ExprListSetName(pParse, yylhsminor.yy442, &yymsp[-2].minor.yy0, 1);
}
  yymsp[-2].minor.yy442 = yylhsminor.yy442;
        break;
      case 149: /* setlist ::= LP idlist RP EQ expr */
{
  yymsp[-4].minor.yy442 = sqlite3ExprListAppendVector(pParse, 0, yymsp[-3].minor.yy200, yymsp[0].minor.yy130);
}
        break;
      case 150: /* cmd ::= with insert_cmd INTO xfullname idlist_opt select upsert */
{
  sqlite3Insert(pParse, yymsp[-3].minor.yy147, yymsp[-1].minor.yy491, yymsp[-2].minor.yy200, yymsp[-5].minor.yy420, yymsp[0].minor.yy426);
}
        break;
      case 151: /* cmd ::= with insert_cmd INTO xfullname idlist_opt DEFAULT VALUES */
{
  sqlite3Insert(pParse, yymsp[-3].minor.yy147, 0, yymsp[-2].minor.yy200, yymsp[-5].minor.yy420, 0);
}
        break;
      case 152: /* upsert ::= */
{ yymsp[1].minor.yy426 = 0; }
        break;
      case 153: /* upsert ::= ON CONFLICT LP sortlist RP where_opt DO UPDATE SET setlist where_opt */
{ yymsp[-10].minor.yy426 = sqlite3UpsertNew(pParse->db,yymsp[-7].minor.yy442,yymsp[-5].minor.yy130,yymsp[-1].minor.yy442,yymsp[0].minor.yy130);}
        break;
      case 154: /* upsert ::= ON CONFLICT LP sortlist RP where_opt DO NOTHING */
{ yymsp[-7].minor.yy426 = sqlite3UpsertNew(pParse->db,yymsp[-4].minor.yy442,yymsp[-2].minor.yy130,0,0); }
        break;
      case 155: /* upsert ::= ON CONFLICT DO NOTHING */
{ yymsp[-3].minor.yy426 = sqlite3UpsertNew(pParse->db,0,0,0,0); }
        break;
      case 159: /* idlist_opt ::= LP idlist RP */
{yymsp[-2].minor.yy200 = yymsp[-1].minor.yy200;}
        break;
      case 160: /* idlist ::= idlist COMMA nm */
{yymsp[-2].minor.yy200 = sqlite3IdListAppend(pParse,yymsp[-2].minor.yy200,&yymsp[0].minor.yy0);}
        break;
      case 161: /* idlist ::= nm */
{yymsp[0].minor.yy200 = sqlite3IdListAppend(pParse,0,&yymsp[0].minor.yy0); /*A-overwrites-Y*/}
        break;
      case 162: /* expr ::= LP expr RP */
{yymsp[-2].minor.yy130 = yymsp[-1].minor.yy130;}
        break;
      case 163: /* expr ::= ID|INDEXED */
      case 164: /* expr ::= JOIN_KW */ yytestcase(yyruleno==164);
{yymsp[0].minor.yy130=tokenExpr(pParse,TK_ID,yymsp[0].minor.yy0); /*A-overwrites-X*/}
        break;
      case 165: /* expr ::= nm DOT nm */
{
  Expr *temp1 = sqlite3ExprAlloc(pParse->db, TK_ID, &yymsp[-2].minor.yy0, 1);
  Expr *temp2 = sqlite3ExprAlloc(pParse->db, TK_ID, &yymsp[0].minor.yy0, 1);
  if( IN_RENAME_OBJECT ){
    sqlite3RenameTokenMap(pParse, (void*)temp2, &yymsp[0].minor.yy0);
    sqlite3RenameTokenMap(pParse, (void*)temp1, &yymsp[-2].minor.yy0);
  }
  yylhsminor.yy130 = sqlite3PExpr(pParse, TK_DOT, temp1, temp2);
}
  yymsp[-2].minor.yy130 = yylhsminor.yy130;
        break;
      case 166: /* expr ::= nm DOT nm DOT nm */
{
  Expr *temp1 = sqlite3ExprAlloc(pParse->db, TK_ID, &yymsp[-4].minor.yy0, 1);
  Expr *temp2 = sqlite3ExprAlloc(pParse->db, TK_ID, &yymsp[-2].minor.yy0, 1);
  Expr *temp3 = sqlite3ExprAlloc(pParse->db, TK_ID, &yymsp[0].minor.yy0, 1);
  Expr *temp4 = sqlite3PExpr(pParse, TK_DOT, temp2, temp3);
  if( IN_RENAME_OBJECT ){
    sqlite3RenameTokenMap(pParse, (void*)temp3, &yymsp[0].minor.yy0);
    sqlite3RenameTokenMap(pParse, (void*)temp2, &yymsp[-2].minor.yy0);
  }
  yylhsminor.yy130 = sqlite3PExpr(pParse, TK_DOT, temp1, temp4);
}
  yymsp[-4].minor.yy130 = yylhsminor.yy130;
        break;
      case 167: /* term ::= NULL|FLOAT|BLOB */
      case 168: /* term ::= STRING */ yytestcase(yyruleno==168);
{yymsp[0].minor.yy130=tokenExpr(pParse,yymsp[0].major,yymsp[0].minor.yy0); /*A-overwrites-X*/}
        break;
      case 169: /* term ::= INTEGER */
{
  yylhsminor.yy130 = sqlite3ExprAlloc(pParse->db, TK_INTEGER, &yymsp[0].minor.yy0, 1);
}
  yymsp[0].minor.yy130 = yylhsminor.yy130;
        break;
      case 170: /* expr ::= VARIABLE */
{
  if( !(yymsp[0].minor.yy0.z[0]=='#' && sqlite3Isdigit(yymsp[0].minor.yy0.z[1])) ){
    u32 n = yymsp[0].minor.yy0.n;
    yymsp[0].minor.yy130 = tokenExpr(pParse, TK_VARIABLE, yymsp[0].minor.yy0);
    sqlite3ExprAssignVarNumber(pParse, yymsp[0].minor.yy130, n);
  }else{
    /* When doing a nested parse, one can include terms in an expression
    ** that look like this:   #1 #2 ...  These terms refer to registers
    ** in the virtual machine.  #N is the N-th register. */
    Token t = yymsp[0].minor.yy0; /*A-overwrites-X*/
    assert( t.n>=2 );
    if( pParse->nested==0 ){
      sqlite3ErrorMsg(pParse, "near \"%T\": syntax error", &t);
      yymsp[0].minor.yy130 = 0;
    }else{
      yymsp[0].minor.yy130 = sqlite3PExpr(pParse, TK_REGISTER, 0, 0);
      if( yymsp[0].minor.yy130 ) sqlite3GetInt32(&t.z[1], &yymsp[0].minor.yy130->iTable);
    }
  }
}
        break;
      case 171: /* expr ::= expr COLLATE ID|STRING */
{
  yymsp[-2].minor.yy130 = sqlite3ExprAddCollateToken(pParse, yymsp[-2].minor.yy130, &yymsp[0].minor.yy0, 1);
}
        break;
      case 172: /* expr ::= CAST LP expr AS typetoken RP */
{
  yymsp[-5].minor.yy130 = sqlite3ExprAlloc(pParse->db, TK_CAST, &yymsp[-1].minor.yy0, 1);
  sqlite3ExprAttachSubtrees(pParse->db, yymsp[-5].minor.yy130, yymsp[-3].minor.yy130, 0);
}
        break;
      case 173: /* expr ::= ID|INDEXED LP distinct exprlist RP */
{
  yylhsminor.yy130 = sqlite3ExprFunction(pParse, yymsp[-1].minor.yy442, &yymsp[-4].minor.yy0, yymsp[-2].minor.yy420);
}
  yymsp[-4].minor.yy130 = yylhsminor.yy130;
        break;
      case 174: /* expr ::= ID|INDEXED LP STAR RP */
{
  yylhsminor.yy130 = sqlite3ExprFunction(pParse, 0, &yymsp[-3].minor.yy0, 0);
}
  yymsp[-3].minor.yy130 = yylhsminor.yy130;
        break;
      case 175: /* expr ::= ID|INDEXED LP distinct exprlist RP over_clause */
{
  yylhsminor.yy130 = sqlite3ExprFunction(pParse, yymsp[-2].minor.yy442, &yymsp[-5].minor.yy0, yymsp[-3].minor.yy420);
  sqlite3WindowAttach(pParse, yylhsminor.yy130, yymsp[0].minor.yy395);
}
  yymsp[-5].minor.yy130 = yylhsminor.yy130;
        break;
      case 176: /* expr ::= ID|INDEXED LP STAR RP over_clause */
{
  yylhsminor.yy130 = sqlite3ExprFunction(pParse, 0, &yymsp[-4].minor.yy0, 0);
  sqlite3WindowAttach(pParse, yylhsminor.yy130, yymsp[0].minor.yy395);
}
  yymsp[-4].minor.yy130 = yylhsminor.yy130;
        break;
      case 177: /* term ::= CTIME_KW */
{
  yylhsminor.yy130 = sqlite3ExprFunction(pParse, 0, &yymsp[0].minor.yy0, 0);
}
  yymsp[0].minor.yy130 = yylhsminor.yy130;
        break;
      case 178: /* expr ::= LP nexprlist COMMA expr RP */
{
  ExprList *pList = sqlite3ExprListAppend(pParse, yymsp[-3].minor.yy442, yymsp[-1].minor.yy130);
  yymsp[-4].minor.yy130 = sqlite3PExpr(pParse, TK_VECTOR, 0, 0);
  if( yymsp[-4].minor.yy130 ){
    yymsp[-4].minor.yy130->x.pList = pList;
  }else{
    sqlite3ExprListDelete(pParse->db, pList);
  }
}
        break;
      case 179: /* expr ::= expr AND expr */
      case 180: /* expr ::= expr OR expr */ yytestcase(yyruleno==180);
      case 181: /* expr ::= expr LT|GT|GE|LE expr */ yytestcase(yyruleno==181);
      case 182: /* expr ::= expr EQ|NE expr */ yytestcase(yyruleno==182);
      case 183: /* expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT expr */ yytestcase(yyruleno==183);
      case 184: /* expr ::= expr PLUS|MINUS expr */ yytestcase(yyruleno==184);
      case 185: /* expr ::= expr STAR|SLASH|REM expr */ yytestcase(yyruleno==185);
      case 186: /* expr ::= expr CONCAT expr */ yytestcase(yyruleno==186);
{yymsp[-2].minor.yy130=sqlite3PExpr(pParse,yymsp[-1].major,yymsp[-2].minor.yy130,yymsp[0].minor.yy130);}
        break;
      case 187: /* likeop ::= NOT LIKE_KW|MATCH */
{yymsp[-1].minor.yy0=yymsp[0].minor.yy0; yymsp[-1].minor.yy0.n|=0x80000000; /*yymsp[-1].minor.yy0-overwrite-yymsp[0].minor.yy0*/}
        break;
      case 188: /* expr ::= expr likeop expr */
{
  ExprList *pList;
  int bNot = yymsp[-1].minor.yy0.n & 0x80000000;
  yymsp[-1].minor.yy0.n &= 0x7fffffff;
  pList = sqlite3ExprListAppend(pParse,0, yymsp[0].minor.yy130);
  pList = sqlite3ExprListAppend(pParse,pList, yymsp[-2].minor.yy130);
  yymsp[-2].minor.yy130 = sqlite3ExprFunction(pParse, pList, &yymsp[-1].minor.yy0, 0);
  if( bNot ) yymsp[-2].minor.yy130 = sqlite3PExpr(pParse, TK_NOT, yymsp[-2].minor.yy130, 0);
  if( yymsp[-2].minor.yy130 ) yymsp[-2].minor.yy130->flags |= EP_InfixFunc;
}
        break;
      case 189: /* expr ::= expr likeop expr ESCAPE expr */
{
  ExprList *pList;
  int bNot = yymsp[-3].minor.yy0.n & 0x80000000;
  yymsp[-3].minor.yy0.n &= 0x7fffffff;
  pList = sqlite3ExprListAppend(pParse,0, yymsp[-2].minor.yy130);
  pList = sqlite3ExprListAppend(pParse,pList, yymsp[-4].minor.yy130);
  pList = sqlite3ExprListAppend(pParse,pList, yymsp[0].minor.yy130);
  yymsp[-4].minor.yy130 = sqlite3ExprFunction(pParse, pList, &yymsp[-3].minor.yy0, 0);
  if( bNot ) yymsp[-4].minor.yy130 = sqlite3PExpr(pParse, TK_NOT, yymsp[-4].minor.yy130, 0);
  if( yymsp[-4].minor.yy130 ) yymsp[-4].minor.yy130->flags |= EP_InfixFunc;
}
        break;
      case 190: /* expr ::= expr ISNULL|NOTNULL */
{yymsp[-1].minor.yy130 = sqlite3PExpr(pParse,yymsp[0].major,yymsp[-1].minor.yy130,0);}
        break;
      case 191: /* expr ::= expr NOT NULL */
{yymsp[-2].minor.yy130 = sqlite3PExpr(pParse,TK_NOTNULL,yymsp[-2].minor.yy130,0);}
        break;
      case 192: /* expr ::= expr IS expr */
{
  yymsp[-2].minor.yy130 = sqlite3PExpr(pParse,TK_IS,yymsp[-2].minor.yy130,yymsp[0].minor.yy130);
  binaryToUnaryIfNull(pParse, yymsp[0].minor.yy130, yymsp[-2].minor.yy130, TK_ISNULL);
}
        break;
      case 193: /* expr ::= expr IS NOT expr */
{
  yymsp[-3].minor.yy130 = sqlite3PExpr(pParse,TK_ISNOT,yymsp[-3].minor.yy130,yymsp[0].minor.yy130);
  binaryToUnaryIfNull(pParse, yymsp[0].minor.yy130, yymsp[-3].minor.yy130, TK_NOTNULL);
}
        break;
      case 194: /* expr ::= NOT expr */
      case 195: /* expr ::= BITNOT expr */ yytestcase(yyruleno==195);
{yymsp[-1].minor.yy130 = sqlite3PExpr(pParse, yymsp[-1].major, yymsp[0].minor.yy130, 0);/*A-overwrites-B*/}
        break;
      case 196: /* expr ::= PLUS|MINUS expr */
{
  yymsp[-1].minor.yy130 = sqlite3PExpr(pParse, yymsp[-1].major==TK_PLUS ? TK_UPLUS : TK_UMINUS, yymsp[0].minor.yy130, 0);
  /*A-overwrites-B*/
}
        break;
      case 197: /* between_op ::= BETWEEN */
      case 200: /* in_op ::= IN */ yytestcase(yyruleno==200);
{yymsp[0].minor.yy420 = 0;}
        break;
      case 199: /* expr ::= expr between_op expr AND expr */
{
  ExprList *pList = sqlite3ExprListAppend(pParse,0, yymsp[-2].minor.yy130);
  pList = sqlite3ExprListAppend(pParse,pList, yymsp[0].minor.yy130);
  yymsp[-4].minor.yy130 = sqlite3PExpr(pParse, TK_BETWEEN, yymsp[-4].minor.yy130, 0);
  if( yymsp[-4].minor.yy130 ){
    yymsp[-4].minor.yy130->x.pList = pList;
  }else{
    sqlite3ExprListDelete(pParse->db, pList);
  } 
  if( yymsp[-3].minor.yy420 ) yymsp[-4].minor.yy130 = sqlite3PExpr(pParse, TK_NOT, yymsp[-4].minor.yy130, 0);
}
        break;
      case 202: /* expr ::= expr in_op LP exprlist RP */
{
    if( yymsp[-1].minor.yy442==0 ){
      /* Expressions of the form
      **
      **      expr1 IN ()
      **      expr1 NOT IN ()
      **
      ** simplify to constants 0 (false) and 1 (true), respectively,
      ** regardless of the value of expr1.
      */
      if( IN_RENAME_OBJECT==0 ){
        sqlite3ExprDelete(pParse->db, yymsp[-4].minor.yy130);
        yymsp[-4].minor.yy130 = sqlite3ExprAlloc(pParse->db, TK_INTEGER,&sqlite3IntTokens[yymsp[-3].minor.yy420],1);
      }
    }else if( yymsp[-1].minor.yy442->nExpr==1 ){
      /* Expressions of the form:
      **
      **      expr1 IN (?1)
      **      expr1 NOT IN (?2)
      **
      ** with exactly one value on the RHS can be simplified to something
      ** like this:
      **
      **      expr1 == ?1
      **      expr1 <> ?2
      **
      ** But, the RHS of the == or <> is marked with the EP_Generic flag
      ** so that it may not contribute to the computation of comparison
      ** affinity or the collating sequence to use for comparison.  Otherwise,
      ** the semantics would be subtly different from IN or NOT IN.
      */
      Expr *pRHS = yymsp[-1].minor.yy442->a[0].pExpr;
      yymsp[-1].minor.yy442->a[0].pExpr = 0;
      sqlite3ExprListDelete(pParse->db, yymsp[-1].minor.yy442);
      /* pRHS cannot be NULL because a malloc error would have been detected
      ** before now and control would have never reached this point */
      if( ALWAYS(pRHS) ){
        pRHS->flags &= ~EP_Collate;
        pRHS->flags |= EP_Generic;
      }
      yymsp[-4].minor.yy130 = sqlite3PExpr(pParse, yymsp[-3].minor.yy420 ? TK_NE : TK_EQ, yymsp[-4].minor.yy130, pRHS);
    }else{
      yymsp[-4].minor.yy130 = sqlite3PExpr(pParse, TK_IN, yymsp[-4].minor.yy130, 0);
      if( yymsp[-4].minor.yy130 ){
        yymsp[-4].minor.yy130->x.pList = yymsp[-1].minor.yy442;
        sqlite3ExprSetHeightAndFlags(pParse, yymsp[-4].minor.yy130);
      }else{
        sqlite3ExprListDelete(pParse->db, yymsp[-1].minor.yy442);
      }
      if( yymsp[-3].minor.yy420 ) yymsp[-4].minor.yy130 = sqlite3PExpr(pParse, TK_NOT, yymsp[-4].minor.yy130, 0);
    }
  }
        break;
      case 203: /* expr ::= LP select RP */
{
    yymsp[-2].minor.yy130 = sqlite3PExpr(pParse, TK_SELECT, 0, 0);
    sqlite3PExprAddSelect(pParse, yymsp[-2].minor.yy130, yymsp[-1].minor.yy491);
  }
        break;
      case 204: /* expr ::= expr in_op LP select RP */
{
    yymsp[-4].minor.yy130 = sqlite3PExpr(pParse, TK_IN, yymsp[-4].minor.yy130, 0);
    sqlite3PExprAddSelect(pParse, yymsp[-4].minor.yy130, yymsp[-1].minor.yy491);
    if( yymsp[-3].minor.yy420 ) yymsp[-4].minor.yy130 = sqlite3PExpr(pParse, TK_NOT, yymsp[-4].minor.yy130, 0);
  }
        break;
      case 205: /* expr ::= expr in_op nm dbnm paren_exprlist */
{
    SrcList *pSrc = sqlite3SrcListAppend(pParse, 0,&yymsp[-2].minor.yy0,&yymsp[-1].minor.yy0);
    Select *pSelect = sqlite3SelectNew(pParse, 0,pSrc,0,0,0,0,0,0);
    if( yymsp[0].minor.yy442 )  sqlite3SrcListFuncArgs(pParse, pSelect ? pSrc : 0, yymsp[0].minor.yy442);
    yymsp[-4].minor.yy130 = sqlite3PExpr(pParse, TK_IN, yymsp[-4].minor.yy130, 0);
    sqlite3PExprAddSelect(pParse, yymsp[-4].minor.yy130, pSelect);
    if( yymsp[-3].minor.yy420 ) yymsp[-4].minor.yy130 = sqlite3PExpr(pParse, TK_NOT, yymsp[-4].minor.yy130, 0);
  }
        break;
      case 206: /* expr ::= EXISTS LP select RP */
{
    Expr *p;
    p = yymsp[-3].minor.yy130 = sqlite3PExpr(pParse, TK_EXISTS, 0, 0);
    sqlite3PExprAddSelect(pParse, p, yymsp[-1].minor.yy491);
  }
        break;
      case 207: /* expr ::= CASE case_operand case_exprlist case_else END */
{
  yymsp[-4].minor.yy130 = sqlite3PExpr(pParse, TK_CASE, yymsp[-3].minor.yy130, 0);
  if( yymsp[-4].minor.yy130 ){
    yymsp[-4].minor.yy130->x.pList = yymsp[-1].minor.yy130 ? sqlite3ExprListAppend(pParse,yymsp[-2].minor.yy442,yymsp[-1].minor.yy130) : yymsp[-2].minor.yy442;
    sqlite3ExprSetHeightAndFlags(pParse, yymsp[-4].minor.yy130);
  }else{
    sqlite3ExprListDelete(pParse->db, yymsp[-2].minor.yy442);
    sqlite3ExprDelete(pParse->db, yymsp[-1].minor.yy130);
  }
}
        break;
      case 208: /* case_exprlist ::= case_exprlist WHEN expr THEN expr */
{
  yymsp[-4].minor.yy442 = sqlite3ExprListAppend(pParse,yymsp[-4].minor.yy442, yymsp[-2].minor.yy130);
  yymsp[-4].minor.yy442 = sqlite3ExprListAppend(pParse,yymsp[-4].minor.yy442, yymsp[0].minor.yy130);
}
        break;
      case 209: /* case_exprlist ::= WHEN expr THEN expr */
{
  yymsp[-3].minor.yy442 = sqlite3ExprListAppend(pParse,0, yymsp[-2].minor.yy130);
  yymsp[-3].minor.yy442 = sqlite3ExprListAppend(pParse,yymsp[-3].minor.yy442, yymsp[0].minor.yy130);
}
        break;
      case 212: /* case_operand ::= expr */
{yymsp[0].minor.yy130 = yymsp[0].minor.yy130; /*A-overwrites-X*/}
        break;
      case 215: /* nexprlist ::= nexprlist COMMA expr */
{yymsp[-2].minor.yy442 = sqlite3ExprListAppend(pParse,yymsp[-2].minor.yy442,yymsp[0].minor.yy130);}
        break;
      case 216: /* nexprlist ::= expr */
{yymsp[0].minor.yy442 = sqlite3ExprListAppend(pParse,0,yymsp[0].minor.yy130); /*A-overwrites-Y*/}
        break;
      case 218: /* paren_exprlist ::= LP exprlist RP */
      case 223: /* eidlist_opt ::= LP eidlist RP */ yytestcase(yyruleno==223);
{yymsp[-2].minor.yy442 = yymsp[-1].minor.yy442;}
        break;
      case 219: /* cmd ::= createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP sortlist RP where_opt */
{
  sqlite3CreateIndex(pParse, &yymsp[-7].minor.yy0, &yymsp[-6].minor.yy0, 
                     sqlite3SrcListAppend(pParse,0,&yymsp[-4].minor.yy0,0), yymsp[-2].minor.yy442, yymsp[-10].minor.yy420,
                      &yymsp[-11].minor.yy0, yymsp[0].minor.yy130, SQLITE_SO_ASC, yymsp[-8].minor.yy420, SQLITE_IDXTYPE_APPDEF);
  if( IN_RENAME_OBJECT && pParse->pNewIndex ){
    sqlite3RenameTokenMap(pParse, pParse->pNewIndex->zName, &yymsp[-4].minor.yy0);
  }
}
        break;
      case 220: /* uniqueflag ::= UNIQUE */
      case 262: /* raisetype ::= ABORT */ yytestcase(yyruleno==262);
{yymsp[0].minor.yy420 = OE_Abort;}
        break;
      case 221: /* uniqueflag ::= */
{yymsp[1].minor.yy420 = OE_None;}
        break;
      case 224: /* eidlist ::= eidlist COMMA nm collate sortorder */
{
  yymsp[-4].minor.yy442 = parserAddExprIdListTerm(pParse, yymsp[-4].minor.yy442, &yymsp[-2].minor.yy0, yymsp[-1].minor.yy420, yymsp[0].minor.yy420);
}
        break;
      case 225: /* eidlist ::= nm collate sortorder */
{
  yymsp[-2].minor.yy442 = parserAddExprIdListTerm(pParse, 0, &yymsp[-2].minor.yy0, yymsp[-1].minor.yy420, yymsp[0].minor.yy420); /*A-overwrites-Y*/
}
        break;
      case 228: /* cmd ::= DROP INDEX ifexists fullname */
{sqlite3DropIndex(pParse, yymsp[0].minor.yy147, yymsp[-1].minor.yy420);}
        break;
      case 229: /* cmd ::= VACUUM vinto */
{sqlite3Vacuum(pParse,0,yymsp[0].minor.yy130);}
        break;
      case 230: /* cmd ::= VACUUM nm vinto */
{sqlite3Vacuum(pParse,&yymsp[-1].minor.yy0,yymsp[0].minor.yy130);}
        break;
      case 233: /* cmd ::= PRAGMA nm dbnm */
{sqlite3Pragma(pParse,&yymsp[-1].minor.yy0,&yymsp[0].minor.yy0,0,0);}
        break;
      case 234: /* cmd ::= PRAGMA nm dbnm EQ nmnum */
{sqlite3Pragma(pParse,&yymsp[-3].minor.yy0,&yymsp[-2].minor.yy0,&yymsp[0].minor.yy0,0);}
        break;

{sqlite3Pragma(pParse,&yymsp[-4].minor.yy0,&yymsp[-3].minor.yy0,&yymsp[-1].minor.yy0,1);}
        break;
      case 240: /* cmd ::= createkw trigger_decl BEGIN trigger_cmd_list END */
{
  Token all;
  all.z = yymsp[-3].minor.yy0.z;
  all.n = (int)(yymsp[0].minor.yy0.z - yymsp[-3].minor.yy0.z) + yymsp[0].minor.yy0.n;
  sqlite3FinishTrigger(pParse, yymsp[-1].minor.yy524, &all);
}
        break;
      case 241: /* trigger_decl ::= temp TRIGGER ifnotexists nm dbnm trigger_time trigger_event ON fullname foreach_clause when_clause */
{
  sqlite3BeginTrigger(pParse, &yymsp[-7].minor.yy0, &yymsp[-6].minor.yy0, yymsp[-5].minor.yy420, yymsp[-4].minor.yy498.a, yymsp[-4].minor.yy498.b, yymsp[-2].minor.yy147, yymsp[0].minor.yy130, yymsp[-10].minor.yy420, yymsp[-8].minor.yy420);
  yymsp[-10].minor.yy0 = (yymsp[-6].minor.yy0.n==0?yymsp[-7].minor.yy0:yymsp[-6].minor.yy0); /*A-overwrites-T*/
}
        break;
      case 242: /* trigger_time ::= BEFORE|AFTER */
{ yymsp[0].minor.yy420 = yymsp[0].major; /*A-overwrites-X*/ }
        break;
      case 243: /* trigger_time ::= INSTEAD OF */
{ yymsp[-1].minor.yy420 = TK_INSTEAD;}
        break;
      case 244: /* trigger_time ::= */
{ yymsp[1].minor.yy420 = TK_BEFORE; }
        break;
      case 245: /* trigger_event ::= DELETE|INSERT */
      case 246: /* trigger_event ::= UPDATE */ yytestcase(yyruleno==246);
{yymsp[0].minor.yy498.a = yymsp[0].major; /*A-overwrites-X*/ yymsp[0].minor.yy498.b = 0;}
        break;
      case 247: /* trigger_event ::= UPDATE OF idlist */
{yymsp[-2].minor.yy498.a = TK_UPDATE; yymsp[-2].minor.yy498.b = yymsp[0].minor.yy200;}
        break;
      case 248: /* when_clause ::= */
      case 267: /* key_opt ::= */ yytestcase(yyruleno==267);
      case 315: /* filter_opt ::= */ yytestcase(yyruleno==315);
{ yymsp[1].minor.yy130 = 0; }
        break;
      case 249: /* when_clause ::= WHEN expr */
      case 268: /* key_opt ::= KEY expr */ yytestcase(yyruleno==268);
{ yymsp[-1].minor.yy130 = yymsp[0].minor.yy130; }
        break;
      case 250: /* trigger_cmd_list ::= trigger_cmd_list trigger_cmd SEMI */
{
  assert( yymsp[-2].minor.yy524!=0 );
  yymsp[-2].minor.yy524->pLast->pNext = yymsp[-1].minor.yy524;
  yymsp[-2].minor.yy524->pLast = yymsp[-1].minor.yy524;
}
        break;
      case 251: /* trigger_cmd_list ::= trigger_cmd SEMI */
{ 
  assert( yymsp[-1].minor.yy524!=0 );
  yymsp[-1].minor.yy524->pLast = yymsp[-1].minor.yy524;
}
        break;
      case 252: /* trnm ::= nm DOT nm */
{
  yymsp[-2].minor.yy0 = yymsp[0].minor.yy0;
  sqlite3ErrorMsg(pParse, 
        "qualified table names are not allowed on INSERT, UPDATE, and DELETE "

{
  sqlite3ErrorMsg(pParse,
        "the NOT INDEXED clause is not allowed on UPDATE or DELETE statements "
        "within triggers");
}
        break;
      case 255: /* trigger_cmd ::= UPDATE orconf trnm tridxby SET setlist where_opt scanpt */
{yylhsminor.yy524 = sqlite3TriggerUpdateStep(pParse, &yymsp[-5].minor.yy0, yymsp[-2].minor.yy442, yymsp[-1].minor.yy130, yymsp[-6].minor.yy420, yymsp[-7].minor.yy0.z, yymsp[0].minor.yy104);}
  yymsp[-7].minor.yy524 = yylhsminor.yy524;
        break;
      case 256: /* trigger_cmd ::= scanpt insert_cmd INTO trnm idlist_opt select upsert scanpt */
{
   yylhsminor.yy524 = sqlite3TriggerInsertStep(pParse,&yymsp[-4].minor.yy0,yymsp[-3].minor.yy200,yymsp[-2].minor.yy491,yymsp[-6].minor.yy420,yymsp[-1].minor.yy426,yymsp[-7].minor.yy104,yymsp[0].minor.yy104);/*yylhsminor.yy524-overwrites-yymsp[-6].minor.yy420*/
}
  yymsp[-7].minor.yy524 = yylhsminor.yy524;
        break;
      case 257: /* trigger_cmd ::= DELETE FROM trnm tridxby where_opt scanpt */
{yylhsminor.yy524 = sqlite3TriggerDeleteStep(pParse, &yymsp[-3].minor.yy0, yymsp[-1].minor.yy130, yymsp[-5].minor.yy0.z, yymsp[0].minor.yy104);}
  yymsp[-5].minor.yy524 = yylhsminor.yy524;
        break;
      case 258: /* trigger_cmd ::= scanpt select scanpt */
{yylhsminor.yy524 = sqlite3TriggerSelectStep(pParse->db, yymsp[-1].minor.yy491, yymsp[-2].minor.yy104, yymsp[0].minor.yy104); /*yylhsminor.yy524-overwrites-yymsp[-1].minor.yy491*/}
  yymsp[-2].minor.yy524 = yylhsminor.yy524;
        break;
      case 259: /* expr ::= RAISE LP IGNORE RP */
{
  yymsp[-3].minor.yy130 = sqlite3PExpr(pParse, TK_RAISE, 0, 0); 
  if( yymsp[-3].minor.yy130 ){
    yymsp[-3].minor.yy130->affinity = OE_Ignore;
  }
}
        break;
      case 260: /* expr ::= RAISE LP raisetype COMMA nm RP */
{
  yymsp[-5].minor.yy130 = sqlite3ExprAlloc(pParse->db, TK_RAISE, &yymsp[-1].minor.yy0, 1); 
  if( yymsp[-5].minor.yy130 ) {
    yymsp[-5].minor.yy130->affinity = (char)yymsp[-3].minor.yy420;
  }
}
        break;
      case 261: /* raisetype ::= ROLLBACK */
{yymsp[0].minor.yy420 = OE_Rollback;}
        break;
      case 263: /* raisetype ::= FAIL */
{yymsp[0].minor.yy420 = OE_Fail;}
        break;
      case 264: /* cmd ::= DROP TRIGGER ifexists fullname */
{
  sqlite3DropTrigger(pParse,yymsp[0].minor.yy147,yymsp[-1].minor.yy420);
}
        break;
      case 265: /* cmd ::= ATTACH database_kw_opt expr AS expr key_opt */
{
  sqlite3Attach(pParse, yymsp[-3].minor.yy130, yymsp[-1].minor.yy130, yymsp[0].minor.yy130);
}
        break;
      case 266: /* cmd ::= DETACH database_kw_opt expr */
{
  sqlite3Detach(pParse, yymsp[0].minor.yy130);
}
        break;
      case 269: /* cmd ::= REINDEX */
{sqlite3Reindex(pParse, 0, 0);}
        break;
      case 270: /* cmd ::= REINDEX nm dbnm */
{sqlite3Reindex(pParse, &yymsp[-1].minor.yy0, &yymsp[0].minor.yy0);}
        break;
      case 271: /* cmd ::= ANALYZE */
{sqlite3Analyze(pParse, 0, 0);}
        break;
      case 272: /* cmd ::= ANALYZE nm dbnm */
{sqlite3Analyze(pParse, &yymsp[-1].minor.yy0, &yymsp[0].minor.yy0);}
        break;
      case 273: /* cmd ::= ALTER TABLE fullname RENAME TO nm */
{
  sqlite3AlterRenameTable(pParse,yymsp[-3].minor.yy147,&yymsp[0].minor.yy0);
}
        break;
      case 274: /* cmd ::= ALTER TABLE add_column_fullname ADD kwcolumn_opt columnname carglist */
{
  yymsp[-1].minor.yy0.n = (int)(pParse->sLastToken.z-yymsp[-1].minor.yy0.z) + pParse->sLastToken.n;
  sqlite3AlterFinishAddColumn(pParse, &yymsp[-1].minor.yy0);
}
        break;
      case 275: /* add_column_fullname ::= fullname */
{
  disableLookaside(pParse);
  sqlite3AlterBeginAddColumn(pParse, yymsp[0].minor.yy147);
}
        break;
      case 276: /* cmd ::= ALTER TABLE fullname RENAME kwcolumn_opt nm TO nm */
{
  sqlite3AlterRenameColumn(pParse, yymsp[-5].minor.yy147, &yymsp[-2].minor.yy0, &yymsp[0].minor.yy0);
}
        break;
      case 277: /* cmd ::= create_vtab */
{sqlite3VtabFinishParse(pParse,0);}
        break;
      case 278: /* cmd ::= create_vtab LP vtabarglist RP */
{sqlite3VtabFinishParse(pParse,&yymsp[0].minor.yy0);}
        break;
      case 279: /* create_vtab ::= createkw VIRTUAL TABLE ifnotexists nm dbnm USING nm */
{
    sqlite3VtabBeginParse(pParse, &yymsp[-3].minor.yy0, &yymsp[-2].minor.yy0, &yymsp[0].minor.yy0, yymsp[-4].minor.yy420);
}
        break;
      case 280: /* vtabarg ::= */
{sqlite3VtabArgInit(pParse);}
        break;
      case 281: /* vtabargtoken ::= ANY */
      case 282: /* vtabargtoken ::= lp anylist RP */ yytestcase(yyruleno==282);
      case 283: /* lp ::= LP */ yytestcase(yyruleno==283);
{sqlite3VtabArgExtend(pParse,&yymsp[0].minor.yy0);}
        break;
      case 284: /* with ::= WITH wqlist */
      case 285: /* with ::= WITH RECURSIVE wqlist */ yytestcase(yyruleno==285);
{ sqlite3WithPush(pParse, yymsp[0].minor.yy523, 1); }
        break;
      case 286: /* wqlist ::= nm eidlist_opt AS LP select RP */
{
  yymsp[-5].minor.yy523 = sqlite3WithAdd(pParse, 0, &yymsp[-5].minor.yy0, yymsp[-4].minor.yy442, yymsp[-1].minor.yy491); /*A-overwrites-X*/
}
        break;
      case 287: /* wqlist ::= wqlist COMMA nm eidlist_opt AS LP select RP */
{
  yymsp[-7].minor.yy523 = sqlite3WithAdd(pParse, yymsp[-7].minor.yy523, &yymsp[-5].minor.yy0, yymsp[-4].minor.yy442, yymsp[-1].minor.yy491);
}
        break;
      case 288: /* windowdefn_list ::= windowdefn */
{ yylhsminor.yy395 = yymsp[0].minor.yy395; }
  yymsp[0].minor.yy395 = yylhsminor.yy395;
        break;
      case 289: /* windowdefn_list ::= windowdefn_list COMMA windowdefn */
{
  assert( yymsp[0].minor.yy395!=0 );
  sqlite3WindowChain(pParse, yymsp[0].minor.yy395, yymsp[-2].minor.yy395);
  yymsp[0].minor.yy395->pNextWin = yymsp[-2].minor.yy395;
  yylhsminor.yy395 = yymsp[0].minor.yy395;
}
  yymsp[-2].minor.yy395 = yylhsminor.yy395;
        break;
      case 290: /* windowdefn ::= nm AS LP window RP */
{
  if( ALWAYS(yymsp[-1].minor.yy395) ){
    yymsp[-1].minor.yy395->zName = sqlite3DbStrNDup(pParse->db, yymsp[-4].minor.yy0.z, yymsp[-4].minor.yy0.n);
  }
  yylhsminor.yy395 = yymsp[-1].minor.yy395;
}
  yymsp[-4].minor.yy395 = yylhsminor.yy395;
        break;
      case 291: /* window ::= PARTITION BY nexprlist orderby_opt frame_opt */
{
  yymsp[-4].minor.yy395 = sqlite3WindowAssemble(pParse, yymsp[0].minor.yy395, yymsp[-2].minor.yy442, yymsp[-1].minor.yy442, 0);
}
        break;
      case 292: /* window ::= nm PARTITION BY nexprlist orderby_opt frame_opt */
{
  yylhsminor.yy395 = sqlite3WindowAssemble(pParse, yymsp[0].minor.yy395, yymsp[-2].minor.yy442, yymsp[-1].minor.yy442, &yymsp[-5].minor.yy0);
}
  yymsp[-5].minor.yy395 = yylhsminor.yy395;
        break;
      case 293: /* window ::= ORDER BY sortlist frame_opt */
{
  yymsp[-3].minor.yy395 = sqlite3WindowAssemble(pParse, yymsp[0].minor.yy395, 0, yymsp[-1].minor.yy442, 0);
}
        break;
      case 294: /* window ::= nm ORDER BY sortlist frame_opt */
{
  yylhsminor.yy395 = sqlite3WindowAssemble(pParse, yymsp[0].minor.yy395, 0, yymsp[-1].minor.yy442, &yymsp[-4].minor.yy0);
}
  yymsp[-4].minor.yy395 = yylhsminor.yy395;
        break;
      case 295: /* window ::= frame_opt */
{
  yylhsminor.yy395 = yymsp[0].minor.yy395;
}
  yymsp[0].minor.yy395 = yylhsminor.yy395;
        break;
      case 296: /* window ::= nm frame_opt */
{
  yylhsminor.yy395 = sqlite3WindowAssemble(pParse, yymsp[0].minor.yy395, 0, 0, &yymsp[-1].minor.yy0);
}
  yymsp[-1].minor.yy395 = yylhsminor.yy395;
        break;
      case 297: /* frame_opt ::= */
{ 
  yymsp[1].minor.yy395 = sqlite3WindowAlloc(pParse, 0, TK_UNBOUNDED, 0, TK_CURRENT, 0, 0);
}
        break;
      case 298: /* frame_opt ::= range_or_rows frame_bound_s frame_exclude_opt */
{ 
  yylhsminor.yy395 = sqlite3WindowAlloc(pParse, yymsp[-2].minor.yy420, yymsp[-1].minor.yy273.eType, yymsp[-1].minor.yy273.pExpr, TK_CURRENT, 0, yymsp[0].minor.yy10);
}
  yymsp[-2].minor.yy395 = yylhsminor.yy395;
        break;
      case 299: /* frame_opt ::= range_or_rows BETWEEN frame_bound_s AND frame_bound_e frame_exclude_opt */
{ 
  yylhsminor.yy395 = sqlite3WindowAlloc(pParse, yymsp[-5].minor.yy420, yymsp[-3].minor.yy273.eType, yymsp[-3].minor.yy273.pExpr, yymsp[-1].minor.yy273.eType, yymsp[-1].minor.yy273.pExpr, yymsp[0].minor.yy10);
}
  yymsp[-5].minor.yy395 = yylhsminor.yy395;
        break;
      case 301: /* frame_bound_s ::= frame_bound */
      case 303: /* frame_bound_e ::= frame_bound */ yytestcase(yyruleno==303);
{yylhsminor.yy273 = yymsp[0].minor.yy273;}
  yymsp[0].minor.yy273 = yylhsminor.yy273;
        break;
      case 302: /* frame_bound_s ::= UNBOUNDED PRECEDING */
      case 304: /* frame_bound_e ::= UNBOUNDED FOLLOWING */ yytestcase(yyruleno==304);
      case 306: /* frame_bound ::= CURRENT ROW */ yytestcase(yyruleno==306);
{yylhsminor.yy273.eType = yymsp[-1].major; yylhsminor.yy273.pExpr = 0;}
  yymsp[-1].minor.yy273 = yylhsminor.yy273;
        break;
      case 305: /* frame_bound ::= expr PRECEDING|FOLLOWING */
{yylhsminor.yy273.eType = yymsp[0].major; yylhsminor.yy273.pExpr = yymsp[-1].minor.yy130;}
  yymsp[-1].minor.yy273 = yylhsminor.yy273;
        break;
      case 307: /* frame_exclude_opt ::= */
{yymsp[1].minor.yy10 = 0;}
        break;
      case 308: /* frame_exclude_opt ::= EXCLUDE frame_exclude */
{yymsp[-1].minor.yy10 = yymsp[0].minor.yy10;}
        break;
      case 309: /* frame_exclude ::= NO OTHERS */
      case 310: /* frame_exclude ::= CURRENT ROW */ yytestcase(yyruleno==310);
{yymsp[-1].minor.yy10 = yymsp[-1].major; /*A-overwrites-X*/}
        break;
      case 311: /* frame_exclude ::= GROUP|TIES */
{yymsp[0].minor.yy10 = yymsp[0].major; /*A-overwrites-X*/}
        break;
      case 312: /* window_clause ::= WINDOW windowdefn_list */
{ yymsp[-1].minor.yy395 = yymsp[0].minor.yy395; }
        break;
      case 313: /* over_clause ::= filter_opt OVER LP window RP */
{
  yylhsminor.yy395 = yymsp[-1].minor.yy395;
  assert( yylhsminor.yy395!=0 );
  yylhsminor.yy395->pFilter = yymsp[-4].minor.yy130;
}
  yymsp[-4].minor.yy395 = yylhsminor.yy395;
        break;
      case 314: /* over_clause ::= filter_opt OVER nm */
{
  yylhsminor.yy395 = (Window*)sqlite3DbMallocZero(pParse->db, sizeof(Window));
  if( yylhsminor.yy395 ){
    yylhsminor.yy395->zName = sqlite3DbStrNDup(pParse->db, yymsp[0].minor.yy0.z, yymsp[0].minor.yy0.n);
    yylhsminor.yy395->pFilter = yymsp[-2].minor.yy130;
  }else{
    sqlite3ExprDelete(pParse->db, yymsp[-2].minor.yy130);
  }
}
  yymsp[-2].minor.yy395 = yylhsminor.yy395;
        break;
      case 316: /* filter_opt ::= FILTER LP WHERE expr RP */
{ yymsp[-4].minor.yy130 = yymsp[-1].minor.yy130; }
        break;
      default:
      /* (317) input ::= cmdlist */ yytestcase(yyruleno==317);
      /* (318) cmdlist ::= cmdlist ecmd */ yytestcase(yyruleno==318);
      /* (319) cmdlist ::= ecmd (OPTIMIZED OUT) */ assert(yyruleno!=319);
      /* (320) ecmd ::= SEMI */ yytestcase(yyruleno==320);
      /* (321) ecmd ::= cmdx SEMI */ yytestcase(yyruleno==321);