Lines Matching refs:X
70 #define yytestcase(X) testcase(X) argument
165 transtype(A) ::= DEFERRED(X). {A = @X; /*A-overwrites-X*/} in transtype()
166 transtype(A) ::= IMMEDIATE(X). {A = @X; /*A-overwrites-X*/} in transtype()
167 transtype(A) ::= EXCLUSIVE(X). {A = @X; /*A-overwrites-X*/} in transtype()
168 cmd ::= COMMIT|END(X) trans_opt. {sqlite3EndTransaction(pParse,@X);}
169 cmd ::= ROLLBACK(X) trans_opt. {sqlite3EndTransaction(pParse,@X);} in ROLLBACK() argument
173 cmd ::= SAVEPOINT nm(X). { in nm() argument
174 sqlite3Savepoint(pParse, SAVEPOINT_BEGIN, &X); in nm()
176 cmd ::= RELEASE savepoint_opt nm(X). { in nm() argument
177 sqlite3Savepoint(pParse, SAVEPOINT_RELEASE, &X); in nm()
179 cmd ::= ROLLBACK trans_opt TO savepoint_opt nm(X). { in nm() argument
180 sqlite3Savepoint(pParse, SAVEPOINT_ROLLBACK, &X); in nm()
199 create_table_args ::= LP columnlist conslist_opt(X) RP(E) table_option_set(F). { in conslist_opt() argument
200 sqlite3EndTable(pParse,&X,&E,F,0); in conslist_opt()
210 table_option_set(A) ::= table_option_set(X) COMMA table_option(Y). {A = X|Y;} in table_option_set()
211 table_option(A) ::= WITHOUT nm(X). { in table_option()
212 if( X.n==5 && sqlite3_strnicmp(X.z,"rowid",5)==0 ){ in table_option()
216 sqlite3ErrorMsg(pParse, "unknown table option: %.*s", X.n, X.z); in table_option()
219 table_option(A) ::= nm(X). { in table_option()
220 if( X.n==6 && sqlite3_strnicmp(X.z,"strict",6)==0 ){ in table_option()
224 sqlite3ErrorMsg(pParse, "unknown table option: %.*s", X.n, X.z); in table_option()
358 ccons ::= CONSTRAINT nm(X). {pParse->constraintName = X;} in nm() argument
359 ccons ::= DEFAULT scantok(A) term(X). in scantok()
360 {sqlite3AddDefaultValue(pParse,X,A.z,&A.z[A.n]);} in scantok()
361 ccons ::= DEFAULT LP(A) expr(X) RP(Z). in LP()
362 {sqlite3AddDefaultValue(pParse,X,A.z+1,Z.z);} in LP()
363 ccons ::= DEFAULT PLUS(A) scantok(Z) term(X). in PLUS()
364 {sqlite3AddDefaultValue(pParse,X,A.z,&Z.z[Z.n]);} in PLUS()
365 ccons ::= DEFAULT MINUS(A) scantok(Z) term(X). { in MINUS()
366 Expr *p = sqlite3PExpr(pParse, TK_UMINUS, X, 0); in MINUS()
369 ccons ::= DEFAULT scantok id(X). { in id() argument
370 Expr *p = tokenExpr(pParse, TK_STRING, X); in id()
375 sqlite3AddDefaultValue(pParse,p,X.z,X.z+X.n); in id()
387 ccons ::= CHECK LP(A) expr(X) RP(B). {sqlite3AddCheckConstraint(pParse,X,A.z,B.z);} in LP()
399 autoinc(X) ::= . {X = 0;} in autoinc() argument
400 autoinc(X) ::= AUTOINCR. {X = 1;} in autoinc() argument
413 refarg(A) ::= ON DELETE refact(X). { A.value = X; A.mask = 0x0000ff; }
414 refarg(A) ::= ON UPDATE refact(X). { A.value = X<<8; A.mask = 0x00ff00; }
423 defer_subclause(A) ::= DEFERRABLE init_deferred_pred_opt(X). {A = X;}
435 tcons ::= CONSTRAINT nm(X). {pParse->constraintName = X;}
436 tcons ::= PRIMARY KEY LP sortlist(X) autoinc(I) RP onconf(R).
437 {sqlite3AddPrimaryKey(pParse,X,R,I,0);}
438 tcons ::= UNIQUE LP sortlist(X) RP onconf(R).
439 {sqlite3CreateIndex(pParse,0,0,0,X,R,0,0,0,0,
459 onconf(A) ::= ON CONFLICT resolvetype(X). {A = X;}
461 orconf(A) ::= OR resolvetype(X). {A = X;}
468 cmd ::= DROP TABLE ifexists(E) fullname(X). {
469 sqlite3DropTable(pParse, X, 0, E);
478 cmd ::= createkw(X) temp(T) VIEW ifnotexists(E) nm(Y) dbnm(Z) eidlist_opt(C)
480 sqlite3CreateView(pParse, &X, &Y, &Z, C, S, T, E);
482 cmd ::= DROP VIEW ifexists(E) fullname(X). {
483 sqlite3DropTable(pParse, X, 1, E);
489 cmd ::= select(X). {
491 sqlite3Select(pParse, X, &dest);
492 sqlite3SelectDelete(pParse->db, X);
551 select(A) ::= WITH wqlist(W) selectnowith(X). {A = attachWithToSelect(pParse,X,W);}
552 select(A) ::= WITH RECURSIVE wqlist(W) selectnowith(X).
553 {A = attachWithToSelect(pParse,X,W);}
555 select(A) ::= selectnowith(X). {
556 Select *p = X;
593 oneselect(A) ::= SELECT distinct(D) selcollist(W) from(X) where_opt(Y)
596 A = sqlite3SelectNew(pParse,W,X,Y,P,Q,Z,D,L);
599 oneselect(A) ::= SELECT distinct(D) selcollist(W) from(X) where_opt(Y)
602 A = sqlite3SelectNew(pParse,W,X,Y,P,Q,Z,D,L);
616 values(A) ::= VALUES LP nexprlist(X) RP. {
617 A = sqlite3SelectNew(pParse,X,0,0,0,0,0,SF_Values,0);
651 selcollist(A) ::= sclp(A) scanpt(B) expr(X) scanpt(Z) as(Y). {
652 A = sqlite3ExprListAppend(pParse, A, X);
660 selcollist(A) ::= sclp(A) scanpt nm(X) DOT STAR. {
662 Expr *pLeft = tokenExpr(pParse, TK_ID, X);
671 as(X) ::= AS nm(Y). {X = Y;}
672 as(X) ::= ids(X).
673 as(X) ::= . {X.n = 0; X.z = 0;}
686 from(A) ::= FROM seltablist(X). {
687 A = X;
748 dbnm(A) ::= DOT nm(X). {A = X;}
752 fullname(A) ::= nm(X). {
753 A = sqlite3SrcListAppend(pParse,0,&X,0);
754 if( IN_RENAME_OBJECT && A ) sqlite3RenameTokenMap(pParse, A->a[0].zName, &X);
756 fullname(A) ::= nm(X) DOT nm(Y). {
757 A = sqlite3SrcListAppend(pParse,0,&X,&Y);
763 xfullname(A) ::= nm(X).
764 {A = sqlite3SrcListAppend(pParse,0,&X,0); /*A-overwrites-X*/}
765 xfullname(A) ::= nm(X) DOT nm(Y).
766 {A = sqlite3SrcListAppend(pParse,0,&X,&Y); /*A-overwrites-X*/}
767 xfullname(A) ::= nm(X) DOT nm(Y) AS nm(Z). {
768 A = sqlite3SrcListAppend(pParse,0,&X,&Y); /*A-overwrites-X*/
771 xfullname(A) ::= nm(X) AS nm(Z). {
772 A = sqlite3SrcListAppend(pParse,0,&X,0); /*A-overwrites-X*/
777 joinop(X) ::= COMMA|JOIN. { X = JT_INNER; }
778 joinop(X) ::= JOIN_KW(A) JOIN.
779 {X = sqlite3JoinType(pParse,&A,0,0); /*X-overwrites-A*/}
780 joinop(X) ::= JOIN_KW(A) nm(B) JOIN.
781 {X = sqlite3JoinType(pParse,&A,&B,0); /*X-overwrites-A*/}
782 joinop(X) ::= JOIN_KW(A) nm(B) nm(C) JOIN.
783 {X = sqlite3JoinType(pParse,&A,&B,&C);/*X-overwrites-A*/}
822 indexed_by(A) ::= INDEXED BY nm(X). {A = X;}
836 orderby_opt(A) ::= ORDER BY sortlist(X). {A = X;}
837 sortlist(A) ::= sortlist(A) COMMA expr(Y) sortorder(Z) nulls(X). {
839 sqlite3ExprListSetSortOrder(A,Z,X);
841 sortlist(A) ::= expr(Y) sortorder(Z) nulls(X). {
843 sqlite3ExprListSetSortOrder(A,Z,X);
860 groupby_opt(A) ::= GROUP BY nexprlist(X). {A = X;}
865 having_opt(A) ::= HAVING expr(X). {A = X;}
878 limit_opt(A) ::= LIMIT expr(X).
879 {A = sqlite3PExpr(pParse,TK_LIMIT,X,0);}
880 limit_opt(A) ::= LIMIT expr(X) OFFSET expr(Y).
881 {A = sqlite3PExpr(pParse,TK_LIMIT,X,Y);}
882 limit_opt(A) ::= LIMIT expr(X) COMMA expr(Y).
883 {A = sqlite3PExpr(pParse,TK_LIMIT,Y,X);}
888 cmd ::= with DELETE FROM xfullname(X) indexed_opt(I) where_opt_ret(W)
890 sqlite3SrcListIndexedBy(pParse, X, &I);
898 sqlite3DeleteFrom(pParse,X,W,O,L);
901 cmd ::= with DELETE FROM xfullname(X) indexed_opt(I) where_opt_ret(W). {
902 sqlite3SrcListIndexedBy(pParse, X, &I);
903 sqlite3DeleteFrom(pParse,X,W,0,0);
913 where_opt(A) ::= WHERE expr(X). {A = X;}
915 where_opt_ret(A) ::= WHERE expr(X). {A = X;}
916 where_opt_ret(A) ::= RETURNING selcollist(X).
917 {sqlite3AddReturning(pParse,X); A = 0;}
918 where_opt_ret(A) ::= WHERE expr(X) RETURNING selcollist(Y).
919 {sqlite3AddReturning(pParse,Y); A = X;}
924 cmd ::= with UPDATE orconf(R) xfullname(X) indexed_opt(I) SET setlist(Y) from(F)
926 sqlite3SrcListIndexedBy(pParse, X, &I);
937 X = sqlite3SrcListAppendList(pParse, X, pFromClause);
947 sqlite3Update(pParse,X,Y,W,R,O,L,0);
950 cmd ::= with UPDATE orconf(R) xfullname(X) indexed_opt(I) SET setlist(Y) from(F)
952 sqlite3SrcListIndexedBy(pParse, X, &I);
964 X = sqlite3SrcListAppendList(pParse, X, pFromClause);
966 sqlite3Update(pParse,X,Y,W,R,0,0,0);
975 setlist(A) ::= setlist(A) COMMA nm(X) EQ expr(Y). {
977 sqlite3ExprListSetName(pParse, A, &X, 1);
979 setlist(A) ::= setlist(A) COMMA LP idlist(X) RP EQ expr(Y). {
980 A = sqlite3ExprListAppendVector(pParse, A, X, Y);
982 setlist(A) ::= nm(X) EQ expr(Y). {
984 sqlite3ExprListSetName(pParse, A, &X, 1);
986 setlist(A) ::= LP idlist(X) RP EQ expr(Y). {
987 A = sqlite3ExprListAppendVector(pParse, 0, X, Y);
992 cmd ::= with insert_cmd(R) INTO xfullname(X) idlist_opt(F) select(S)
994 sqlite3Insert(pParse, X, S, F, R, U);
996 cmd ::= with insert_cmd(R) INTO xfullname(X) idlist_opt(F) DEFAULT VALUES returning.
998 sqlite3Insert(pParse, X, 0, F, R, 0);
1009 upsert(A) ::= RETURNING selcollist(X). { A = 0; sqlite3AddReturning(pParse,X); }
1020 returning ::= RETURNING selcollist(X). {sqlite3AddReturning(pParse,X);}
1033 idlist_opt(A) ::= LP idlist(X) RP. {A = X;}
1086 expr(A) ::= LP expr(X) RP. {A = X;}
1087 expr(A) ::= id(X). {A=tokenExpr(pParse,TK_ID,X); /*A-overwrites-X*/}
1088 expr(A) ::= JOIN_KW(X). {A=tokenExpr(pParse,TK_ID,X); /*A-overwrites-X*/}
1089 expr(A) ::= nm(X) DOT nm(Y). {
1090 Expr *temp1 = tokenExpr(pParse,TK_ID,X);
1094 expr(A) ::= nm(X) DOT nm(Y) DOT nm(Z). {
1095 Expr *temp1 = tokenExpr(pParse,TK_ID,X);
1104 term(A) ::= NULL|FLOAT|BLOB(X). {A=tokenExpr(pParse,@X,X); /*A-overwrites-X*/}
1105 term(A) ::= STRING(X). {A=tokenExpr(pParse,@X,X); /*A-overwrites-X*/}
1106 term(A) ::= INTEGER(X). {
1107 A = sqlite3ExprAlloc(pParse->db, TK_INTEGER, &X, 1);
1108 if( A ) A->w.iOfst = (int)(X.z - pParse->zTail);
1110 expr(A) ::= VARIABLE(X). {
1111 if( !(X.z[0]=='#' && sqlite3Isdigit(X.z[1])) ){
1112 u32 n = X.n;
1113 A = tokenExpr(pParse, TK_VARIABLE, X);
1119 Token t = X; /*A-overwrites-X*/
1141 expr(A) ::= id(X) LP distinct(D) exprlist(Y) RP. {
1142 A = sqlite3ExprFunction(pParse, Y, &X, D);
1144 expr(A) ::= id(X) LP STAR RP. {
1145 A = sqlite3ExprFunction(pParse, 0, &X, 0);
1149 expr(A) ::= id(X) LP distinct(D) exprlist(Y) RP filter_over(Z). {
1150 A = sqlite3ExprFunction(pParse, Y, &X, D);
1153 expr(A) ::= id(X) LP STAR RP filter_over(Z). {
1154 A = sqlite3ExprFunction(pParse, 0, &X, 0);
1163 expr(A) ::= LP nexprlist(X) COMMA expr(Y) RP. {
1164 ExprList *pList = sqlite3ExprListAppend(pParse, X, Y);
1190 likeop(A) ::= NOT LIKE_KW|MATCH(X). {A=X; A.n|=0x80000000; /*A-overwrite-X*/}
1252 expr(A) ::= NOT(B) expr(X).
1253 {A = sqlite3PExpr(pParse, @B, X, 0);/*A-overwrites-B*/}
1254 expr(A) ::= BITNOT(B) expr(X).
1255 {A = sqlite3PExpr(pParse, @B, X, 0);/*A-overwrites-B*/}
1256 expr(A) ::= PLUS|MINUS(B) expr(X). [BITNOT] {
1257 A = sqlite3PExpr(pParse, @B==TK_PLUS ? TK_UPLUS : TK_UMINUS, X, 0);
1270 expr(A) ::= expr(A) between_op(N) expr(X) AND expr(Y). [BETWEEN] {
1271 ExprList *pList = sqlite3ExprListAppend(pParse,0, X);
1324 expr(A) ::= LP select(X) RP. {
1326 sqlite3PExprAddSelect(pParse, A, X);
1349 expr(A) ::= CASE case_operand(X) case_exprlist(Y) case_else(Z) END. {
1350 A = sqlite3PExpr(pParse, TK_CASE, X, 0);
1371 case_else(A) ::= ELSE expr(X). {A = X;}
1375 case_operand(A) ::= expr(X). {A = X; /*A-overwrites-X*/}
1396 paren_exprlist(A) ::= LP exprlist(X) RP. {A = X;}
1402 cmd ::= createkw(S) uniqueflag(U) INDEX ifnotexists(NE) nm(X) dbnm(D)
1404 sqlite3CreateIndex(pParse, &X, &D,
1463 eidlist_opt(A) ::= LP eidlist(X) RP. {A = X;}
1478 cmd ::= DROP INDEX ifexists(E) fullname(X). {sqlite3DropIndex(pParse, X, E);}
1486 cmd ::= VACUUM nm(X) vinto(Y). {sqlite3Vacuum(pParse,&X,Y);}
1487 vinto(A) ::= INTO expr(X). {A = X;}
1494 cmd ::= PRAGMA nm(X) dbnm(Z). {sqlite3Pragma(pParse,&X,&Z,0,0);}
1495 cmd ::= PRAGMA nm(X) dbnm(Z) EQ nmnum(Y). {sqlite3Pragma(pParse,&X,&Z,&Y,0);}
1496 cmd ::= PRAGMA nm(X) dbnm(Z) LP nmnum(Y) RP. {sqlite3Pragma(pParse,&X,&Z,&Y,0);}
1497 cmd ::= PRAGMA nm(X) dbnm(Z) EQ minus_num(Y).
1498 {sqlite3Pragma(pParse,&X,&Z,&Y,1);}
1499 cmd ::= PRAGMA nm(X) dbnm(Z) LP minus_num(Y) RP.
1500 {sqlite3Pragma(pParse,&X,&Z,&Y,1);}
1509 plus_num(A) ::= PLUS number(X). {A = X;}
1511 minus_num(A) ::= MINUS number(X). {A = X;}
1531 trigger_time(A) ::= BEFORE|AFTER(X). { A = @X; /*A-overwrites-X*/ }
1537 trigger_event(A) ::= DELETE|INSERT(X). {A.a = @X; /*A-overwrites-X*/ A.b = 0;}
1538 trigger_event(A) ::= UPDATE(X). {A.a = @X; /*A-overwrites-X*/ A.b = 0;}
1539 trigger_event(A) ::= UPDATE OF idlist(X).{A.a = TK_UPDATE; A.b = X;}
1547 when_clause(A) ::= WHEN expr(X). { A = X; }
1551 trigger_cmd_list(A) ::= trigger_cmd_list(A) trigger_cmd(X) SEMI. {
1553 A->pLast->pNext = X;
1554 A->pLast = X;
1567 trnm(A) ::= nm DOT nm(X). {
1568 A = X;
1596 UPDATE(B) orconf(R) trnm(X) tridxby SET setlist(Y) from(F) where_opt(Z) scanpt(E).
1597 {A = sqlite3TriggerUpdateStep(pParse, &X, F, Y, Z, R, B.z, E);}
1601 trnm(X) idlist_opt(F) select(S) upsert(U) scanpt(Z). {
1602 A = sqlite3TriggerInsertStep(pParse,&X,F,S,R,U,B,Z);/*A-overwrites-R*/
1605 trigger_cmd(A) ::= DELETE(B) FROM trnm(X) tridxby where_opt(Y) scanpt(E).
1606 {A = sqlite3TriggerDeleteStep(pParse, &X, Y, B.z, E);}
1609 trigger_cmd(A) ::= scanpt(B) select(X) scanpt(E).
1610 {A = sqlite3TriggerSelectStep(pParse->db, X, B, E); /*A-overwrites-X*/}
1635 cmd ::= DROP TRIGGER ifexists(NOERR) fullname(X). {
1636 sqlite3DropTrigger(pParse,X,NOERR);
1652 key_opt(A) ::= KEY expr(X). { A = X; }
1661 cmd ::= REINDEX nm(X) dbnm(Y). {sqlite3Reindex(pParse, &X, &Y);}
1667 cmd ::= ANALYZE nm(X) dbnm(Y). {sqlite3Analyze(pParse, &X, &Y);}
1673 cmd ::= ALTER TABLE fullname(X) RENAME TO nm(Z). {
1674 sqlite3AlterRenameTable(pParse,X,&Z);
1681 cmd ::= ALTER TABLE fullname(X) DROP kwcolumn_opt nm(Y). {
1682 sqlite3AlterDropColumn(pParse, X, &Y);
1685 add_column_fullname ::= fullname(X). {
1687 sqlite3AlterBeginAddColumn(pParse, X);
1689 cmd ::= ALTER TABLE fullname(X) RENAME kwcolumn_opt nm(Y) TO nm(Z). {
1690 sqlite3AlterRenameColumn(pParse, X, &Y, &Z);
1702 cmd ::= create_vtab LP vtabarglist RP(X). {sqlite3VtabFinishParse(pParse,&X);}
1704 nm(X) dbnm(Y) USING nm(Z). {
1705 sqlite3VtabBeginParse(pParse, &X, &Y, &Z, E);
1711 vtabargtoken ::= ANY(X). {sqlite3VtabArgExtend(pParse,&X);}
1712 vtabargtoken ::= lp anylist RP(X). {sqlite3VtabArgExtend(pParse,&X);}
1713 lp ::= LP(X). {sqlite3VtabArgExtend(pParse,&X);}
1735 wqitem(A) ::= nm(X) eidlist_opt(Y) wqas(M) LP select(Z) RP. {
1736 A = sqlite3CteNew(pParse, &X, Y, Z, M); /*A-overwrites-X*/
1738 wqlist(A) ::= wqitem(X). {
1739 A = sqlite3WithAdd(pParse, 0, X); /*A-overwrites-X*/
1741 wqlist(A) ::= wqlist(A) COMMA wqitem(X). {
1742 A = sqlite3WithAdd(pParse, A, X);
1765 windowdefn(A) ::= nm(X) AS LP window(Y) RP. {
1767 Y->zName = sqlite3DbStrNDup(pParse->db, X.z, X.n);
1799 window(A) ::= PARTITION BY nexprlist(X) orderby_opt(Y) frame_opt(Z). {
1800 A = sqlite3WindowAssemble(pParse, Z, X, Y, 0);
1802 window(A) ::= nm(W) PARTITION BY nexprlist(X) orderby_opt(Y) frame_opt(Z). {
1803 A = sqlite3WindowAssemble(pParse, Z, X, Y, &W);
1821 frame_opt(A) ::= range_or_rows(X) frame_bound_s(Y) frame_exclude_opt(Z). {
1822 A = sqlite3WindowAlloc(pParse, X, Y.eType, Y.pExpr, TK_CURRENT, 0, Z);
1824 frame_opt(A) ::= range_or_rows(X) BETWEEN frame_bound_s(Y) AND
1826 A = sqlite3WindowAlloc(pParse, X, Y.eType, Y.pExpr, Z.eType, Z.pExpr, W);
1829 range_or_rows(A) ::= RANGE|ROWS|GROUPS(X). {A = @X; /*A-overwrites-X*/}
1831 frame_bound_s(A) ::= frame_bound(X). {A = X;}
1832 frame_bound_s(A) ::= UNBOUNDED(X) PRECEDING. {A.eType = @X; A.pExpr = 0;}
1833 frame_bound_e(A) ::= frame_bound(X). {A = X;}
1834 frame_bound_e(A) ::= UNBOUNDED(X) FOLLOWING. {A.eType = @X; A.pExpr = 0;}
1836 frame_bound(A) ::= expr(X) PRECEDING|FOLLOWING(Y).
1837 {A.eType = @Y; A.pExpr = X;}
1838 frame_bound(A) ::= CURRENT(X) ROW. {A.eType = @X; A.pExpr = 0;}
1842 frame_exclude_opt(A) ::= EXCLUDE frame_exclude(X). {A = X;}
1845 frame_exclude(A) ::= NO(X) OTHERS. {A = @X; /*A-overwrites-X*/}
1846 frame_exclude(A) ::= CURRENT(X) ROW. {A = @X; /*A-overwrites-X*/}
1847 frame_exclude(A) ::= GROUP|TIES(X). {A = @X; /*A-overwrites-X*/}
1886 filter_clause(A) ::= FILTER LP WHERE expr(X) RP. { A = X; }