Lines Matching refs:expr
7444 ** <blockquote>column OP expr</blockquote>
7451 ** expr on the right-hand side can be evaluated (and thus the constraint
7454 ** ^The optimizer automatically inverts terms of the form "expr OP column"
18480 ** name. An expr/name combination can be used in several ways, such
18481 ** as the list of "expr AS ID" fields following a "SELECT" or in the
18482 ** list of "ID = expr" items in an UPDATE. A list of expressions can
18779 ** pUpsertSet is the list of column=expr terms of the UPDATE statement.
19131 int iSelfTab; /* Table associated with an index on expr, or negative
19726 Expr *pStart; /* Expression for "<expr> PRECEDING" */
19727 Expr *pEnd; /* Expression for "<expr> FOLLOWING" */
32043 sqlite3TreeViewLine(pView, "EXISTS-expr flags=0x%x", pExpr->flags);
32049 sqlite3TreeViewLine(pView, "subquery-expr flags=0x%x", pExpr->flags);
68654 #define IfNotOmitAV(expr) (expr)
68656 #define IfNotOmitAV(expr) 0
84261 sqlite3_str_appendf(p, "%s", "expr");
103543 ** any expr callbacks and SELECT callbacks that come from subqueries.
104572 ** "expr IS NOT NULL" --> "TRUE"
104573 ** "expr IS NULL" --> "FALSE"
104575 ** if we can prove that "expr" is never NULL. Call this the
105813 /************** Begin file expr.c ********************************************/
108939 /* Case 1: expr IN (SELECT ...)
108982 /* Case 2: expr IN (exprlist)
108985 ** store it in the temporary table. If <expr> is a column, then use
108986 ** that columns affinity when building index keys. If <expr> is not
109269 VdbeNoopComment((v, "begin IN expr"));
109288 /* Code the LHS, the <expr> from "<expr> IN (...)". If the LHS is a
109470 VdbeComment((v, "end IN expr"));
109883 VdbeComment((v, "%s expr-column %d", p->zIdxName, p->iIdxCol));
109892 VdbeComment((v, "%s expr-column %d", p->zIdxName, p->iIdxCol));
112325 /************** End of expr.c ************************************************/
115563 VdbeComment((v,"%s.expr(%d)",pIdx->zName, k));
137688 ** expr.c is trying to resolve a reference to a transient table (i.e. one
139053 ** distinct aggregates ("SELECT count(DISTINCT <expr>) ..."). Three strategies
139584 /* If we are creating a set for an "expr IN (SELECT ...)" construct,
141491 /* If we are creating a set for an "expr IN (SELECT ...)".
142006 ExprList *pCList; /* Collation sequences for replacement expr */
142672 ** SELECT <expr-list> FROM (<sub-query>) <where-clause>
147093 ** in pEList is of the format <id>=<expr>. If any of the entries
151535 ** X <op> <expr>
151546 ** (t1.X <op> <expr>) OR (t1.Y <op> <expr>) OR ....
151582 int leftCursor; /* Cursor number of X in "X <op> <expr>" */
151585 int leftColumn; /* Column number of X in "X <op> <expr>" */
151956 if( i==XN_EXPR ) return "<expr>";
152460 printf("For indexing, change the IN expr:\n");
152472 ** term can be either X=expr or X IN (...). pTerm is the term to be
152481 ** For a constraint of the form X=expr, the expression is evaluated in
155028 ** 1. column MATCH expr SQLITE_INDEX_CONSTRAINT_MATCH
155029 ** 2. column GLOB expr SQLITE_INDEX_CONSTRAINT_GLOB
155030 ** 3. column LIKE expr SQLITE_INDEX_CONSTRAINT_LIKE
155031 ** 4. column REGEXP expr SQLITE_INDEX_CONSTRAINT_REGEXP
155032 ** 5. column != expr SQLITE_INDEX_CONSTRAINT_NE
155033 ** 6. expr != column SQLITE_INDEX_CONSTRAINT_NE
155034 ** 7. column IS NOT expr SQLITE_INDEX_CONSTRAINT_ISNOT
155035 ** 8. expr IS NOT column SQLITE_INDEX_CONSTRAINT_ISNOT
155040 ** "expr" expression (even though in forms (6) and (8) the column is on the
155276 ** If all subterms are of the form T.C=expr for some single column of C and
155305 ** "T.C <op> <expr>" where C is any column of table T and
155463 ** "table.column=expr" for some single table. The one bit that is set
155733 ** If the expression is of the form "<expr> <op> X" it gets commuted
155734 ** to the standard form of "X <op> <expr>".
156150 ** current expression is of the form "column OP expr" where OP
156972 ** for terms of the form "X <op> <expr>" where X is column iColumn of table
156980 ** "Y <op> <expr>". The number of levels of transitivity is limited,
157026 ** Search for a term in the WHERE clause that is of the form "X <op> <expr>"
157035 ** The term returned might by Y=<expr> if there is another constraint in
157040 ** other equivalent values. Hence a search for X will return <expr> if X=A1
157041 ** and A1=A2 and A2=A3 and ... and A9=A10 and A10=<expr>.
157043 ** If there are multiple terms in the WHERE clause of the form "X <op> <expr>"
157044 ** then try for the one with no dependencies on <expr> - in other words where
157045 ** <expr> is a constant expression of some kind. Only return entries of
157047 ** the form "X <op> <const-expr>" exist. If no terms with a constant RHS
158244 int *pbDone /* Set to true if at least one expr. value extracted */
163238 ** lead(expr [, offset [, default]])
163239 ** lag(expr [, offset [, default]])
163240 ** first_value(expr)
163241 ** last_value(expr)
163242 ** nth_value(expr, N)
164333 ** <expr> PRECEDING
164335 ** <expr> FOLLOWING
164595 ** A "PRECEDING <expr>" (eCond==0) or "FOLLOWING <expr>" (eCond==1) or the
165636 ** differently from the above - "BETWEEN <expr> PRECEDING AND <expr> PRECEDING"
165637 ** and "BETWEEN <expr> FOLLOWING AND <expr> FOLLOWING". These are special
165833 ** expression (there is only ever 1 for a RANGE that uses an <expr> FOLLOWING
165834 ** or <expr PRECEDING) read from cursor csr.
165928 int regStart = 0; /* Value of <expr> PRECEDING */
165929 int regEnd = 0; /* Value of <expr> FOLLOWING */
165996 /* If the window frame contains an "<expr> PRECEDING" or "<expr> FOLLOWING"
165998 ** <expr>. */
166070 VdbeCoverageNeverNullIf(v, op==OP_Ge); /* NeverNull because bound <expr> */
167944 /* 217 */ "expr",
168087 /* 34 */ "ccons ::= DEFAULT LP expr RP",
168094 /* 41 */ "ccons ::= CHECK LP expr RP",
168098 /* 45 */ "generated ::= LP expr RP",
168099 /* 46 */ "generated ::= LP expr RP ID",
168123 /* 70 */ "tcons ::= CHECK LP expr RP onconf",
168153 /* 100 */ "selcollist ::= sclp scanpt expr scanpt as",
168179 /* 126 */ "on_using ::= ON expr",
168187 /* 134 */ "sortlist ::= sortlist COMMA expr sortorder nulls",
168188 /* 135 */ "sortlist ::= expr sortorder nulls",
168198 /* 145 */ "having_opt ::= HAVING expr",
168200 /* 147 */ "limit_opt ::= LIMIT expr",
168201 /* 148 */ "limit_opt ::= LIMIT expr OFFSET expr",
168202 /* 149 */ "limit_opt ::= LIMIT expr COMMA expr",
168205 /* 152 */ "where_opt ::= WHERE expr",
168207 /* 154 */ "where_opt_ret ::= WHERE expr",
168209 /* 156 */ "where_opt_ret ::= WHERE expr RETURNING selcollist",
168211 /* 158 */ "setlist ::= setlist COMMA nm EQ expr",
168212 /* 159 */ "setlist ::= setlist COMMA LP idlist RP EQ expr",
168213 /* 160 */ "setlist ::= nm EQ expr",
168214 /* 161 */ "setlist ::= LP idlist RP EQ expr",
168230 /* 177 */ "expr ::= LP expr RP",
168231 /* 178 */ "expr ::= ID|INDEXED",
168232 /* 179 */ "expr ::= JOIN_KW",
168233 /* 180 */ "expr ::= nm DOT nm",
168234 /* 181 */ "expr ::= nm DOT nm DOT nm",
168238 /* 185 */ "expr ::= VARIABLE",
168239 /* 186 */ "expr ::= expr COLLATE ID|STRING",
168240 /* 187 */ "expr ::= CAST LP expr AS typetoken RP",
168241 /* 188 */ "expr ::= ID|INDEXED LP distinct exprlist RP",
168242 /* 189 */ "expr ::= ID|INDEXED LP STAR RP",
168243 /* 190 */ "expr ::= ID|INDEXED LP distinct exprlist RP filter_over",
168244 /* 191 */ "expr ::= ID|INDEXED LP STAR RP filter_over",
168246 /* 193 */ "expr ::= LP nexprlist COMMA expr RP",
168247 /* 194 */ "expr ::= expr AND expr",
168248 /* 195 */ "expr ::= expr OR expr",
168249 /* 196 */ "expr ::= expr LT|GT|GE|LE expr",
168250 /* 197 */ "expr ::= expr EQ|NE expr",
168251 /* 198 */ "expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT expr",
168252 /* 199 */ "expr ::= expr PLUS|MINUS expr",
168253 /* 200 */ "expr ::= expr STAR|SLASH|REM expr",
168254 /* 201 */ "expr ::= expr CONCAT expr",
168256 /* 203 */ "expr ::= expr likeop expr",
168257 /* 204 */ "expr ::= expr likeop expr ESCAPE expr",
168258 /* 205 */ "expr ::= expr ISNULL|NOTNULL",
168259 /* 206 */ "expr ::= expr NOT NULL",
168260 /* 207 */ "expr ::= expr IS expr",
168261 /* 208 */ "expr ::= expr IS NOT expr",
168262 /* 209 */ "expr ::= expr IS NOT DISTINCT FROM expr",
168263 /* 210 */ "expr ::= expr IS DISTINCT FROM expr",
168264 /* 211 */ "expr ::= NOT expr",
168265 /* 212 */ "expr ::= BITNOT expr",
168266 /* 213 */ "expr ::= PLUS|MINUS expr",
168267 /* 214 */ "expr ::= expr PTR expr",
168270 /* 217 */ "expr ::= expr between_op expr AND expr",
168273 /* 220 */ "expr ::= expr in_op LP exprlist RP",
168274 /* 221 */ "expr ::= LP select RP",
168275 /* 222 */ "expr ::= expr in_op LP select RP",
168276 /* 223 */ "expr ::= expr in_op nm dbnm paren_exprlist",
168277 /* 224 */ "expr ::= EXISTS LP select RP",
168278 /* 225 */ "expr ::= CASE case_operand case_exprlist case_else END",
168279 /* 226 */ "case_exprlist ::= case_exprlist WHEN expr THEN expr",
168280 /* 227 */ "case_exprlist ::= WHEN expr THEN expr",
168281 /* 228 */ "case_else ::= ELSE expr",
168283 /* 230 */ "case_operand ::= expr",
168286 /* 233 */ "nexprlist ::= nexprlist COMMA expr",
168287 /* 234 */ "nexprlist ::= expr",
168302 /* 249 */ "vinto ::= INTO expr",
168320 /* 267 */ "when_clause ::= WHEN expr",
168330 /* 277 */ "expr ::= RAISE LP IGNORE RP",
168331 /* 278 */ "expr ::= RAISE LP raisetype COMMA nm RP",
168336 /* 283 */ "cmd ::= ATTACH database_kw_opt expr AS expr key_opt",
168337 /* 284 */ "cmd ::= DETACH database_kw_opt expr",
168339 /* 286 */ "key_opt ::= KEY expr",
168381 /* 328 */ "frame_bound ::= expr PRECEDING|FOLLOWING",
168394 /* 341 */ "filter_clause ::= FILTER LP WHERE expr RP",
168434 /* 381 */ "expr ::= term",
168592 case 217: /* expr */
168998 215, /* (34) ccons ::= DEFAULT LP expr RP */
169005 215, /* (41) ccons ::= CHECK LP expr RP */
169009 224, /* (45) generated ::= LP expr RP */
169010 224, /* (46) generated ::= LP expr RP ID */
169034 230, /* (70) tcons ::= CHECK LP expr RP onconf */
169064 244, /* (100) selcollist ::= sclp scanpt expr scanpt as */
169090 259, /* (126) on_using ::= ON expr */
169098 231, /* (134) sortlist ::= sortlist COMMA expr sortorder nulls */
169099 231, /* (135) sortlist ::= expr sortorder nulls */
169109 248, /* (145) having_opt ::= HAVING expr */
169111 250, /* (147) limit_opt ::= LIMIT expr */
169112 250, /* (148) limit_opt ::= LIMIT expr OFFSET expr */
169113 250, /* (149) limit_opt ::= LIMIT expr COMMA expr */
169116 246, /* (152) where_opt ::= WHERE expr */
169118 267, /* (154) where_opt_ret ::= WHERE expr */
169120 267, /* (156) where_opt_ret ::= WHERE expr RETURNING selcollist */
169122 268, /* (158) setlist ::= setlist COMMA nm EQ expr */
169123 268, /* (159) setlist ::= setlist COMMA LP idlist RP EQ expr */
169124 268, /* (160) setlist ::= nm EQ expr */
169125 268, /* (161) setlist ::= LP idlist RP EQ expr */
169141 217, /* (177) expr ::= LP expr RP */
169142 217, /* (178) expr ::= ID|INDEXED */
169143 217, /* (179) expr ::= JOIN_KW */
169144 217, /* (180) expr ::= nm DOT nm */
169145 217, /* (181) expr ::= nm DOT nm DOT nm */
169149 217, /* (185) expr ::= VARIABLE */
169150 217, /* (186) expr ::= expr COLLATE ID|STRING */
169151 217, /* (187) expr ::= CAST LP expr AS typetoken RP */
169152 217, /* (188) expr ::= ID|INDEXED LP distinct exprlist RP */
169153 217, /* (189) expr ::= ID|INDEXED LP STAR RP */
169154 217, /* (190) expr ::= ID|INDEXED LP distinct exprlist RP filter_over */
169155 217, /* (191) expr ::= ID|INDEXED LP STAR RP filter_over */
169157 217, /* (193) expr ::= LP nexprlist COMMA expr RP */
169158 217, /* (194) expr ::= expr AND expr */
169159 217, /* (195) expr ::= expr OR expr */
169160 217, /* (196) expr ::= expr LT|GT|GE|LE expr */
169161 217, /* (197) expr ::= expr EQ|NE expr */
169162 217, /* (198) expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT expr */
169163 217, /* (199) expr ::= expr PLUS|MINUS expr */
169164 217, /* (200) expr ::= expr STAR|SLASH|REM expr */
169165 217, /* (201) expr ::= expr CONCAT expr */
169167 217, /* (203) expr ::= expr likeop expr */
169168 217, /* (204) expr ::= expr likeop expr ESCAPE expr */
169169 217, /* (205) expr ::= expr ISNULL|NOTNULL */
169170 217, /* (206) expr ::= expr NOT NULL */
169171 217, /* (207) expr ::= expr IS expr */
169172 217, /* (208) expr ::= expr IS NOT expr */
169173 217, /* (209) expr ::= expr IS NOT DISTINCT FROM expr */
169174 217, /* (210) expr ::= expr IS DISTINCT FROM expr */
169175 217, /* (211) expr ::= NOT expr */
169176 217, /* (212) expr ::= BITNOT expr */
169177 217, /* (213) expr ::= PLUS|MINUS expr */
169178 217, /* (214) expr ::= expr PTR expr */
169181 217, /* (217) expr ::= expr between_op expr AND expr */
169184 217, /* (220) expr ::= expr in_op LP exprlist RP */
169185 217, /* (221) expr ::= LP select RP */
169186 217, /* (222) expr ::= expr in_op LP select RP */
169187 217, /* (223) expr ::= expr in_op nm dbnm paren_exprlist */
169188 217, /* (224) expr ::= EXISTS LP select RP */
169189 217, /* (225) expr ::= CASE case_operand case_exprlist case_else END */
169190 279, /* (226) case_exprlist ::= case_exprlist WHEN expr THEN expr */
169191 279, /* (227) case_exprlist ::= WHEN expr THEN expr */
169192 280, /* (228) case_else ::= ELSE expr */
169194 278, /* (230) case_operand ::= expr */
169197 253, /* (233) nexprlist ::= nexprlist COMMA expr */
169198 253, /* (234) nexprlist ::= expr */
169213 283, /* (249) vinto ::= INTO expr */
169231 290, /* (267) when_clause ::= WHEN expr */
169241 217, /* (277) expr ::= RAISE LP IGNORE RP */
169242 217, /* (278) expr ::= RAISE LP raisetype COMMA nm RP */
169247 190, /* (283) cmd ::= ATTACH database_kw_opt expr AS expr key_opt */
169248 190, /* (284) cmd ::= DETACH database_kw_opt expr */
169250 295, /* (286) key_opt ::= KEY expr */
169292 314, /* (328) frame_bound ::= expr PRECEDING|FOLLOWING */
169305 311, /* (341) filter_clause ::= FILTER LP WHERE expr RP */
169345 217, /* (381) expr ::= term */
169408 -4, /* (34) ccons ::= DEFAULT LP expr RP */
169415 -4, /* (41) ccons ::= CHECK LP expr RP */
169419 -3, /* (45) generated ::= LP expr RP */
169420 -4, /* (46) generated ::= LP expr RP ID */
169444 -5, /* (70) tcons ::= CHECK LP expr RP onconf */
169474 -5, /* (100) selcollist ::= sclp scanpt expr scanpt as */
169500 -2, /* (126) on_using ::= ON expr */
169508 -5, /* (134) sortlist ::= sortlist COMMA expr sortorder nulls */
169509 -3, /* (135) sortlist ::= expr sortorder nulls */
169519 -2, /* (145) having_opt ::= HAVING expr */
169521 -2, /* (147) limit_opt ::= LIMIT expr */
169522 -4, /* (148) limit_opt ::= LIMIT expr OFFSET expr */
169523 -4, /* (149) limit_opt ::= LIMIT expr COMMA expr */
169526 -2, /* (152) where_opt ::= WHERE expr */
169528 -2, /* (154) where_opt_ret ::= WHERE expr */
169530 -4, /* (156) where_opt_ret ::= WHERE expr RETURNING selcollist */
169532 -5, /* (158) setlist ::= setlist COMMA nm EQ expr */
169533 -7, /* (159) setlist ::= setlist COMMA LP idlist RP EQ expr */
169534 -3, /* (160) setlist ::= nm EQ expr */
169535 -5, /* (161) setlist ::= LP idlist RP EQ expr */
169551 -3, /* (177) expr ::= LP expr RP */
169552 -1, /* (178) expr ::= ID|INDEXED */
169553 -1, /* (179) expr ::= JOIN_KW */
169554 -3, /* (180) expr ::= nm DOT nm */
169555 -5, /* (181) expr ::= nm DOT nm DOT nm */
169559 -1, /* (185) expr ::= VARIABLE */
169560 -3, /* (186) expr ::= expr COLLATE ID|STRING */
169561 -6, /* (187) expr ::= CAST LP expr AS typetoken RP */
169562 -5, /* (188) expr ::= ID|INDEXED LP distinct exprlist RP */
169563 -4, /* (189) expr ::= ID|INDEXED LP STAR RP */
169564 -6, /* (190) expr ::= ID|INDEXED LP distinct exprlist RP filter_over */
169565 -5, /* (191) expr ::= ID|INDEXED LP STAR RP filter_over */
169567 -5, /* (193) expr ::= LP nexprlist COMMA expr RP */
169568 -3, /* (194) expr ::= expr AND expr */
169569 -3, /* (195) expr ::= expr OR expr */
169570 -3, /* (196) expr ::= expr LT|GT|GE|LE expr */
169571 -3, /* (197) expr ::= expr EQ|NE expr */
169572 -3, /* (198) expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT expr */
169573 -3, /* (199) expr ::= expr PLUS|MINUS expr */
169574 -3, /* (200) expr ::= expr STAR|SLASH|REM expr */
169575 -3, /* (201) expr ::= expr CONCAT expr */
169577 -3, /* (203) expr ::= expr likeop expr */
169578 -5, /* (204) expr ::= expr likeop expr ESCAPE expr */
169579 -2, /* (205) expr ::= expr ISNULL|NOTNULL */
169580 -3, /* (206) expr ::= expr NOT NULL */
169581 -3, /* (207) expr ::= expr IS expr */
169582 -4, /* (208) expr ::= expr IS NOT expr */
169583 -6, /* (209) expr ::= expr IS NOT DISTINCT FROM expr */
169584 -5, /* (210) expr ::= expr IS DISTINCT FROM expr */
169585 -2, /* (211) expr ::= NOT expr */
169586 -2, /* (212) expr ::= BITNOT expr */
169587 -2, /* (213) expr ::= PLUS|MINUS expr */
169588 -3, /* (214) expr ::= expr PTR expr */
169591 -5, /* (217) expr ::= expr between_op expr AND expr */
169594 -5, /* (220) expr ::= expr in_op LP exprlist RP */
169595 -3, /* (221) expr ::= LP select RP */
169596 -5, /* (222) expr ::= expr in_op LP select RP */
169597 -5, /* (223) expr ::= expr in_op nm dbnm paren_exprlist */
169598 -4, /* (224) expr ::= EXISTS LP select RP */
169599 -5, /* (225) expr ::= CASE case_operand case_exprlist case_else END */
169600 -5, /* (226) case_exprlist ::= case_exprlist WHEN expr THEN expr */
169601 -4, /* (227) case_exprlist ::= WHEN expr THEN expr */
169602 -2, /* (228) case_else ::= ELSE expr */
169604 -1, /* (230) case_operand ::= expr */
169607 -3, /* (233) nexprlist ::= nexprlist COMMA expr */
169608 -1, /* (234) nexprlist ::= expr */
169623 -2, /* (249) vinto ::= INTO expr */
169641 -2, /* (267) when_clause ::= WHEN expr */
169651 -4, /* (277) expr ::= RAISE LP IGNORE RP */
169652 -6, /* (278) expr ::= RAISE LP raisetype COMMA nm RP */
169657 -6, /* (283) cmd ::= ATTACH database_kw_opt expr AS expr key_opt */
169658 -3, /* (284) cmd ::= DETACH database_kw_opt expr */
169660 -2, /* (286) key_opt ::= KEY expr */
169702 -2, /* (328) frame_bound ::= expr PRECEDING|FOLLOWING */
169715 -5, /* (341) filter_clause ::= FILTER LP WHERE expr RP */
169755 -1, /* (381) expr ::= term */
169963 case 34: /* ccons ::= DEFAULT LP expr RP */
169995 case 41: /* ccons ::= CHECK LP expr RP */
170007 case 45: /* generated ::= LP expr RP */
170010 case 46: /* generated ::= LP expr RP ID */
170077 case 70: /* tcons ::= CHECK LP expr RP onconf */
170216 case 100: /* selcollist ::= sclp scanpt expr scanpt as */
170361 case 126: /* on_using ::= ON expr */
170380 case 134: /* sortlist ::= sortlist COMMA expr sortorder nulls */
170386 case 135: /* sortlist ::= expr sortorder nulls */
170417 case 145: /* having_opt ::= HAVING expr */
170418 case 152: /* where_opt ::= WHERE expr */ yytestcase(yyruleno==152);
170419 case 154: /* where_opt_ret ::= WHERE expr */ yytestcase(yyruleno==154);
170420 case 228: /* case_else ::= ELSE expr */ yytestcase(yyruleno==228);
170421 case 249: /* vinto ::= INTO expr */ yytestcase(yyruleno==249);
170424 case 147: /* limit_opt ::= LIMIT expr */
170427 case 148: /* limit_opt ::= LIMIT expr OFFSET expr */
170430 case 149: /* limit_opt ::= LIMIT expr COMMA expr */
170442 case 156: /* where_opt_ret ::= WHERE expr RETURNING selcollist */
170464 case 158: /* setlist ::= setlist COMMA nm EQ expr */
170470 case 159: /* setlist ::= setlist COMMA LP idlist RP EQ expr */
170475 case 160: /* setlist ::= nm EQ expr */
170482 case 161: /* setlist ::= LP idlist RP EQ expr */
170530 case 177: /* expr ::= LP expr RP */
170533 case 178: /* expr ::= ID|INDEXED */
170534 case 179: /* expr ::= JOIN_KW */ yytestcase(yyruleno==179);
170537 case 180: /* expr ::= nm DOT nm */
170545 case 181: /* expr ::= nm DOT nm DOT nm */
170569 case 185: /* expr ::= VARIABLE */
170591 case 186: /* expr ::= expr COLLATE ID|STRING */
170596 case 187: /* expr ::= CAST LP expr AS typetoken RP */
170602 case 188: /* expr ::= ID|INDEXED LP distinct exprlist RP */
170608 case 189: /* expr ::= ID|INDEXED LP STAR RP */
170614 case 190: /* expr ::= ID|INDEXED LP distinct exprlist RP filter_over */
170621 case 191: /* expr ::= ID|INDEXED LP STAR RP filter_over */
170634 case 193: /* expr ::= LP nexprlist COMMA expr RP */
170648 case 194: /* expr ::= expr AND expr */
170651 case 195: /* expr ::= expr OR expr */
170652 case 196: /* expr ::= expr LT|GT|GE|LE expr */ yytestcase(yyruleno==196);
170653 case 197: /* expr ::= expr EQ|NE expr */ yytestcase(yyruleno==197);
170654 case 198: /* expr ::= expr BITAND|BITOR|LSHIFT|RSHIFT expr */ yytestcase(yyruleno==198);
170655 case 199: /* expr ::= expr PLUS|MINUS expr */ yytestcase(yyruleno==199);
170656 case 200: /* expr ::= expr STAR|SLASH|REM expr */ yytestcase(yyruleno==200);
170657 case 201: /* expr ::= expr CONCAT expr */ yytestcase(yyruleno==201);
170663 case 203: /* expr ::= expr likeop expr */
170675 case 204: /* expr ::= expr likeop expr ESCAPE expr */
170688 case 205: /* expr ::= expr ISNULL|NOTNULL */
170691 case 206: /* expr ::= expr NOT NULL */
170694 case 207: /* expr ::= expr IS expr */
170700 case 208: /* expr ::= expr IS NOT expr */
170706 case 209: /* expr ::= expr IS NOT DISTINCT FROM expr */
170712 case 210: /* expr ::= expr IS DISTINCT FROM expr */
170718 case 211: /* expr ::= NOT expr */
170719 case 212: /* expr ::= BITNOT expr */ yytestcase(yyruleno==212);
170722 case 213: /* expr ::= PLUS|MINUS expr */
170728 case 214: /* expr ::= expr PTR expr */
170740 case 217: /* expr ::= expr between_op expr AND expr */
170753 case 220: /* expr ::= expr in_op LP exprlist RP */
170794 case 221: /* expr ::= LP select RP */
170800 case 222: /* expr ::= expr in_op LP select RP */
170807 case 223: /* expr ::= expr in_op nm dbnm paren_exprlist */
170817 case 224: /* expr ::= EXISTS LP select RP */
170824 case 225: /* expr ::= CASE case_operand case_exprlist case_else END */
170836 case 226: /* case_exprlist ::= case_exprlist WHEN expr THEN expr */
170842 case 227: /* case_exprlist ::= WHEN expr THEN expr */
170848 case 230: /* case_operand ::= expr */
170851 case 233: /* nexprlist ::= nexprlist COMMA expr */
170854 case 234: /* nexprlist ::= expr */
170946 case 267: /* when_clause ::= WHEN expr */
170947 case 286: /* key_opt ::= KEY expr */ yytestcase(yyruleno==286);
171003 case 277: /* expr ::= RAISE LP IGNORE RP */
171011 case 278: /* expr ::= RAISE LP raisetype COMMA nm RP */
171030 case 283: /* cmd ::= ATTACH database_kw_opt expr AS expr key_opt */
171035 case 284: /* cmd ::= DETACH database_kw_opt expr */
171211 case 328: /* frame_bound ::= expr PRECEDING|FOLLOWING */
171268 case 341: /* filter_clause ::= FILTER LP WHERE expr RP */
171311 /* (381) expr ::= term (OPTIMIZED OUT) */ assert(yyruleno!=381);
183808 int *pnOr, /* OUT: Total number of OR nodes in expr. */
187488 ** fts3_exprtest(<tokenizer>, <expr>, <column 1>, ...);
187519 "Usage: fts3_exprtest(tokenizer, expr, col1, ...", -1
190001 Fts3PhraseToken *pToken; /* Pointer to corresponding expr token */
195298 ** "INSERT INTO tbl(tbl) VALUES(<expr>)"
195300 ** Argument pVal contains the result of <expr>. Currently the only
223213 /* 17 */ "expr",
223230 /* 0 */ "input ::= expr",
223237 /* 7 */ "expr ::= expr AND expr",
223238 /* 8 */ "expr ::= expr OR expr",
223239 /* 9 */ "expr ::= expr NOT expr",
223240 /* 10 */ "expr ::= colset COLON LP expr RP",
223241 /* 11 */ "expr ::= LP expr RP",
223242 /* 12 */ "expr ::= exprlist",
223388 case 17: /* expr */
223700 16, /* (0) input ::= expr */
223707 17, /* (7) expr ::= expr AND expr */
223708 17, /* (8) expr ::= expr OR expr */
223709 17, /* (9) expr ::= expr NOT expr */
223710 17, /* (10) expr ::= colset COLON LP expr RP */
223711 17, /* (11) expr ::= LP expr RP */
223712 17, /* (12) expr ::= exprlist */
223733 -1, /* (0) input ::= expr */
223740 -3, /* (7) expr ::= expr AND expr */
223741 -3, /* (8) expr ::= expr OR expr */
223742 -3, /* (9) expr ::= expr NOT expr */
223743 -5, /* (10) expr ::= colset COLON LP expr RP */
223744 -3, /* (11) expr ::= LP expr RP */
223745 -1, /* (12) expr ::= exprlist */
223802 case 0: /* input ::= expr */
223836 case 7: /* expr ::= expr AND expr */
223842 case 8: /* expr ::= expr OR expr */
223848 case 9: /* expr ::= expr NOT expr */
223854 case 10: /* expr ::= colset COLON LP expr RP */
223861 case 11: /* expr ::= LP expr RP */
223864 case 12: /* expr ::= exprlist */
236989 ** <tbl> MATCH <expr> AND rowid BETWEEN $iFirstRowid AND $iLastRowid
238162 ** processing for a "... MATCH <expr> ORDER BY rank" query (ePlan is