📄 dump
字号:
1.69 (drh 24-May-02): // "seltablist" is a "Select Table List" - the content of the FROM clause1.69 (drh 24-May-02): // in a SELECT statement. "stl_prefix" is a prefix of this list.1.69 (drh 24-May-02): //1.69 (drh 24-May-02): stl_prefix(A) ::= seltablist(X) joinop(Y). {1.69 (drh 24-May-02): A = X;1.69 (drh 24-May-02): if( A && A->nSrc>0 ) A->a[A->nSrc-1].jointype = Y;1.69 (drh 24-May-02): }1.1 (drh 29-May-00): stl_prefix(A) ::= . {A = 0;}1.92 (drh 20-Mar-03): seltablist(A) ::= stl_prefix(X) nm(Y) dbnm(D) as(Z) on_opt(N) using_opt(U). {1.92 (drh 20-Mar-03): A = sqliteSrcListAppend(X,&Y,&D);1.69 (drh 24-May-02): if( Z.n ) sqliteSrcListAddAlias(A,&Z);1.69 (drh 24-May-02): if( N ){1.69 (drh 24-May-02): if( A && A->nSrc>1 ){ A->a[A->nSrc-2].pOn = N; }1.69 (drh 24-May-02): else { sqliteExprDelete(N); }1.69 (drh 24-May-02): }1.69 (drh 24-May-02): if( U ){1.69 (drh 24-May-02): if( A && A->nSrc>1 ){ A->a[A->nSrc-2].pUsing = U; }1.69 (drh 24-May-02): else { sqliteIdListDelete(U); }1.69 (drh 24-May-02): }1.49 (drh 18-Feb-02): }1.69 (drh 24-May-02): seltablist(A) ::= stl_prefix(X) LP select(S) RP as(Z) on_opt(N) using_opt(U). {1.92 (drh 20-Mar-03): A = sqliteSrcListAppend(X,0,0);1.68 (drh 24-May-02): A->a[A->nSrc-1].pSelect = S;1.69 (drh 24-May-02): if( Z.n ) sqliteSrcListAddAlias(A,&Z);1.69 (drh 24-May-02): if( N ){1.69 (drh 24-May-02): if( A && A->nSrc>1 ){ A->a[A->nSrc-2].pOn = N; }1.69 (drh 24-May-02): else { sqliteExprDelete(N); }1.69 (drh 24-May-02): }1.69 (drh 24-May-02): if( U ){1.69 (drh 24-May-02): if( A && A->nSrc>1 ){ A->a[A->nSrc-2].pUsing = U; }1.69 (drh 24-May-02): else { sqliteIdListDelete(U); }1.63 (drh 08-May-02): }1.27 (drh 04-Apr-01): }1.69 (drh 24-May-02): 1.92 (drh 20-Mar-03): %type dbnm {Token}1.92 (drh 20-Mar-03): dbnm(A) ::= . {A.z=0; A.n=0;}1.92 (drh 20-Mar-03): dbnm(A) ::= DOT nm(X). {A = X;}1.92 (drh 20-Mar-03): 1.69 (drh 24-May-02): %type joinop {int}1.69 (drh 24-May-02): %type joinop2 {int}1.69 (drh 24-May-02): joinop(X) ::= COMMA. { X = JT_INNER; }1.69 (drh 24-May-02): joinop(X) ::= JOIN. { X = JT_INNER; }1.76 (drh 01-Jul-02): joinop(X) ::= JOIN_KW(A) JOIN. { X = sqliteJoinType(pParse,&A,0,0); }1.76 (drh 01-Jul-02): joinop(X) ::= JOIN_KW(A) nm(B) JOIN. { X = sqliteJoinType(pParse,&A,&B,0); }1.76 (drh 01-Jul-02): joinop(X) ::= JOIN_KW(A) nm(B) nm(C) JOIN.1.76 (drh 01-Jul-02): { X = sqliteJoinType(pParse,&A,&B,&C); }1.69 (drh 24-May-02): 1.69 (drh 24-May-02): %type on_opt {Expr*}1.69 (drh 24-May-02): %destructor on_opt {sqliteExprDelete($$);}1.69 (drh 24-May-02): on_opt(N) ::= ON expr(E). {N = E;}1.69 (drh 24-May-02): on_opt(N) ::= . {N = 0;}1.69 (drh 24-May-02): 1.69 (drh 24-May-02): %type using_opt {IdList*}1.69 (drh 24-May-02): %destructor using_opt {sqliteIdListDelete($$);}1.69 (drh 24-May-02): using_opt(U) ::= USING LP idxlist(L) RP. {U = L;}1.69 (drh 24-May-02): using_opt(U) ::= . {U = 0;}1.69 (drh 24-May-02): 1.1 (drh 29-May-00): 1.1 (drh 29-May-00): %type orderby_opt {ExprList*}1.1 (drh 29-May-00): %destructor orderby_opt {sqliteExprListDelete($$);}1.1 (drh 29-May-00): %type sortlist {ExprList*}1.1 (drh 29-May-00): %destructor sortlist {sqliteExprListDelete($$);}1.1 (drh 29-May-00): %type sortitem {Expr*}1.1 (drh 29-May-00): %destructor sortitem {sqliteExprDelete($$);}1.1 (drh 29-May-00): 1.1 (drh 29-May-00): orderby_opt(A) ::= . {A = 0;}1.1 (drh 29-May-00): orderby_opt(A) ::= ORDER BY sortlist(X). {A = X;}1.74 (drh 17-Jun-02): sortlist(A) ::= sortlist(X) COMMA sortitem(Y) collate(C) sortorder(Z). {1.9 (drh 05-Jun-00): A = sqliteExprListAppend(X,Y,0);1.74 (drh 17-Jun-02): if( A ) A->a[A->nExpr-1].sortOrder = C+Z;1.9 (drh 05-Jun-00): }1.77 (drh 05-Jul-02): sortlist(A) ::= sortitem(Y) collate(C) sortorder(Z). {1.9 (drh 05-Jun-00): A = sqliteExprListAppend(0,Y,0);1.77 (drh 05-Jul-02): if( A ) A->a[0].sortOrder = C+Z;1.9 (drh 05-Jun-00): }1.5 (drh 31-May-00): sortitem(A) ::= expr(X). {A = X;}1.1 (drh 29-May-00): 1.1 (drh 29-May-00): %type sortorder {int}1.74 (drh 17-Jun-02): %type collate {int}1.1 (drh 29-May-00): 1.74 (drh 17-Jun-02): sortorder(A) ::= ASC. {A = SQLITE_SO_ASC;}1.74 (drh 17-Jun-02): sortorder(A) ::= DESC. {A = SQLITE_SO_DESC;}1.74 (drh 17-Jun-02): sortorder(A) ::= . {A = SQLITE_SO_ASC;}1.74 (drh 17-Jun-02): collate(C) ::= . {C = SQLITE_SO_UNK;}1.88 (drh 18-Jan-03): collate(C) ::= COLLATE id(X). {C = sqliteCollateType(X.z, X.n);}1.13 (drh 06-Jun-00): 1.13 (drh 06-Jun-00): %type groupby_opt {ExprList*}1.13 (drh 06-Jun-00): %destructor groupby_opt {sqliteExprListDelete($$);}1.22 (drh 19-Jun-00): groupby_opt(A) ::= . {A = 0;}1.13 (drh 06-Jun-00): groupby_opt(A) ::= GROUP BY exprlist(X). {A = X;}1.13 (drh 06-Jun-00): 1.13 (drh 06-Jun-00): %type having_opt {Expr*}1.13 (drh 06-Jun-00): %destructor having_opt {sqliteExprDelete($$);}1.22 (drh 19-Jun-00): having_opt(A) ::= . {A = 0;}1.13 (drh 06-Jun-00): having_opt(A) ::= HAVING expr(X). {A = X;}1.38 (drh 06-Nov-01): 1.68 (drh 24-May-02): %type limit_opt {struct LimitVal}1.99 (drh 16-Jul-03): limit_opt(A) ::= . {A.limit = -1; A.offset = 0;}1.99 (drh 16-Jul-03): limit_opt(A) ::= LIMIT signed(X). {A.limit = X; A.offset = 0;}1.99 (drh 16-Jul-03): limit_opt(A) ::= LIMIT signed(X) OFFSET signed(Y). 1.99 (drh 16-Jul-03): {A.limit = X; A.offset = Y;}1.99 (drh 16-Jul-03): limit_opt(A) ::= LIMIT signed(X) COMMA signed(Y). 1.99 (drh 16-Jul-03): {A.limit = Y; A.offset = X;}1.14 (drh 06-Jun-00): 1.34 (drh 06-Oct-01): /////////////////////////// The DELETE statement /////////////////////////////1.34 (drh 06-Oct-01): //1.92 (drh 20-Mar-03): cmd ::= DELETE FROM nm(X) dbnm(D) where_opt(Y). {1.92 (drh 20-Mar-03): sqliteDeleteFrom(pParse, sqliteSrcListAppend(0,&X,&D), Y);1.92 (drh 20-Mar-03): }1.1 (drh 29-May-00): 1.1 (drh 29-May-00): %type where_opt {Expr*}1.1 (drh 29-May-00): %destructor where_opt {sqliteExprDelete($$);}1.1 (drh 29-May-00): 1.1 (drh 29-May-00): where_opt(A) ::= . {A = 0;}1.1 (drh 29-May-00): where_opt(A) ::= WHERE expr(X). {A = X;}1.1 (drh 29-May-00): 1.1 (drh 29-May-00): %type setlist {ExprList*}1.1 (drh 29-May-00): %destructor setlist {sqliteExprListDelete($$);}1.1 (drh 29-May-00): 1.34 (drh 06-Oct-01): ////////////////////////// The UPDATE command ////////////////////////////////1.34 (drh 06-Oct-01): //1.92 (drh 20-Mar-03): cmd ::= UPDATE orconf(R) nm(X) dbnm(D) SET setlist(Y) where_opt(Z).1.92 (drh 20-Mar-03): {sqliteUpdate(pParse,sqliteSrcListAppend(0,&X,&D),Y,Z,R);}1.1 (drh 29-May-00): 1.76 (drh 01-Jul-02): setlist(A) ::= setlist(Z) COMMA nm(X) EQ expr(Y).1.1 (drh 29-May-00): {A = sqliteExprListAppend(Z,Y,&X);}1.76 (drh 01-Jul-02): setlist(A) ::= nm(X) EQ expr(Y). {A = sqliteExprListAppend(0,Y,&X);}1.1 (drh 29-May-00): 1.34 (drh 06-Oct-01): ////////////////////////// The INSERT command /////////////////////////////////1.34 (drh 06-Oct-01): //1.92 (drh 20-Mar-03): cmd ::= insert_cmd(R) INTO nm(X) dbnm(D) inscollist_opt(F) 1.92 (drh 20-Mar-03): VALUES LP itemlist(Y) RP.1.92 (drh 20-Mar-03): {sqliteInsert(pParse, sqliteSrcListAppend(0,&X,&D), Y, 0, F, R);}1.92 (drh 20-Mar-03): cmd ::= insert_cmd(R) INTO nm(X) dbnm(D) inscollist_opt(F) select(S).1.92 (drh 20-Mar-03): {sqliteInsert(pParse, sqliteSrcListAppend(0,&X,&D), 0, S, F, R);}1.46 (drh 02-Feb-02): 1.46 (drh 02-Feb-02): %type insert_cmd {int}1.46 (drh 02-Feb-02): insert_cmd(A) ::= INSERT orconf(R). {A = R;}1.46 (drh 02-Feb-02): insert_cmd(A) ::= REPLACE. {A = OE_Replace;}1.1 (drh 29-May-00): 1.1 (drh 29-May-00): 1.1 (drh 29-May-00): %type itemlist {ExprList*}1.1 (drh 29-May-00): %destructor itemlist {sqliteExprListDelete($$);}1.1 (drh 29-May-00): 1.50 (drh 18-Feb-02): itemlist(A) ::= itemlist(X) COMMA expr(Y). {A = sqliteExprListAppend(X,Y,0);}1.50 (drh 18-Feb-02): itemlist(A) ::= expr(X). {A = sqliteExprListAppend(0,X,0);}1.1 (drh 29-May-00): 1.23 (drh 21-Jun-00): %type inscollist_opt {IdList*}1.23 (drh 21-Jun-00): %destructor inscollist_opt {sqliteIdListDelete($$);}1.23 (drh 21-Jun-00): %type inscollist {IdList*}1.23 (drh 21-Jun-00): %destructor inscollist {sqliteIdListDelete($$);}1.23 (drh 21-Jun-00): 1.27 (drh 04-Apr-01): inscollist_opt(A) ::= . {A = 0;}1.27 (drh 04-Apr-01): inscollist_opt(A) ::= LP inscollist(X) RP. {A = X;}1.76 (drh 01-Jul-02): inscollist(A) ::= inscollist(X) COMMA nm(Y). {A = sqliteIdListAppend(X,&Y);}1.76 (drh 01-Jul-02): inscollist(A) ::= nm(Y). {A = sqliteIdListAppend(0,&Y);}1.1 (drh 29-May-00): 1.34 (drh 06-Oct-01): /////////////////////////// Expression Processing /////////////////////////////1.34 (drh 06-Oct-01): //1.1 (drh 29-May-00): %left OR.1.1 (drh 29-May-00): %left AND.1.8 (drh 03-Jun-00): %right NOT.1.11 (drh 06-Jun-00): %left EQ NE ISNULL NOTNULL IS LIKE GLOB BETWEEN IN.1.1 (drh 29-May-00): %left GT GE LT LE.1.36 (drh 12-Oct-01): %left BITAND BITOR LSHIFT RSHIFT.1.1 (drh 29-May-00): %left PLUS MINUS.1.37 (drh 13-Oct-01): %left STAR SLASH REM.1.21 (drh 16-Jun-00): %left CONCAT.1.82 (drh 24-Aug-02): %right UMINUS UPLUS BITNOT.1.85 (drh 27-Oct-02): %right ORACLE_OUTER_JOIN.1.1 (drh 29-May-00): 1.1 (drh 29-May-00): %type expr {Expr*}1.1 (drh 29-May-00): %destructor expr {sqliteExprDelete($$);}1.1 (drh 29-May-00): ⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -