dump

SQLite 2.8.6 源代码,用来在Linux/Unix/Windows上编译安装.它是一个小型的数据库,但是非常好用,速度也快,一般的数据库查询之类的操作据统计比MySQL,PostgreSQL

1.84         (drh      22-Oct-02): expr(A) ::= LP(B) expr(X) RP(E). {A = X; sqliteExprSpan(A,&B,&E); }
1.24         (drh      29-Jul-00): expr(A) ::= NULL(X).             {A = sqliteExpr(TK_NULL, 0, 0, &X);}
1.76         (drh      01-Jul-02): expr(A) ::= ID(X).               {A = sqliteExpr(TK_ID, 0, 0, &X);}
1.76         (drh      01-Jul-02): expr(A) ::= JOIN_KW(X).          {A = sqliteExpr(TK_ID, 0, 0, &X);}
1.76         (drh      01-Jul-02): expr(A) ::= nm(X) DOT nm(Y). {
1.24         (drh      29-Jul-00):   Expr *temp1 = sqliteExpr(TK_ID, 0, 0, &X);
1.24         (drh      29-Jul-00):   Expr *temp2 = sqliteExpr(TK_ID, 0, 0, &Y);
1.24         (drh      29-Jul-00):   A = sqliteExpr(TK_DOT, temp1, temp2, 0);
1.24         (drh      29-Jul-00): }
1.93         (drh      27-Mar-03): expr(A) ::= nm(X) DOT nm(Y) DOT nm(Z). {
1.93         (drh      27-Mar-03):   Expr *temp1 = sqliteExpr(TK_ID, 0, 0, &X);
1.93         (drh      27-Mar-03):   Expr *temp2 = sqliteExpr(TK_ID, 0, 0, &Y);
1.93         (drh      27-Mar-03):   Expr *temp3 = sqliteExpr(TK_ID, 0, 0, &Z);
1.93         (drh      27-Mar-03):   Expr *temp4 = sqliteExpr(TK_DOT, temp2, temp3, 0);
1.93         (drh      27-Mar-03):   A = sqliteExpr(TK_DOT, temp1, temp4, 0);
1.93         (drh      27-Mar-03): }
1.85         (drh      27-Oct-02): expr(A) ::= expr(B) ORACLE_OUTER_JOIN. 
1.85         (drh      27-Oct-02):                              {A = B; ExprSetProperty(A,EP_Oracle8Join);}
1.1          (drh      29-May-00): expr(A) ::= INTEGER(X).      {A = sqliteExpr(TK_INTEGER, 0, 0, &X);}
1.1          (drh      29-May-00): expr(A) ::= FLOAT(X).        {A = sqliteExpr(TK_FLOAT, 0, 0, &X);}
1.1          (drh      29-May-00): expr(A) ::= STRING(X).       {A = sqliteExpr(TK_STRING, 0, 0, &X);}
1.24         (drh      29-Jul-00): expr(A) ::= ID(X) LP exprlist(Y) RP(E). {
1.24         (drh      29-Jul-00):   A = sqliteExprFunction(Y, &X);
1.24         (drh      29-Jul-00):   sqliteExprSpan(A,&X,&E);
1.24         (drh      29-Jul-00): }
1.24         (drh      29-Jul-00): expr(A) ::= ID(X) LP STAR RP(E). {
1.24         (drh      29-Jul-00):   A = sqliteExprFunction(0, &X);
1.24         (drh      29-Jul-00):   sqliteExprSpan(A,&X,&E);
1.24         (drh      29-Jul-00): }
1.1          (drh      29-May-00): expr(A) ::= expr(X) AND expr(Y).   {A = sqliteExpr(TK_AND, X, Y, 0);}
1.1          (drh      29-May-00): expr(A) ::= expr(X) OR expr(Y).    {A = sqliteExpr(TK_OR, X, Y, 0);}
1.1          (drh      29-May-00): expr(A) ::= expr(X) LT expr(Y).    {A = sqliteExpr(TK_LT, X, Y, 0);}
1.1          (drh      29-May-00): expr(A) ::= expr(X) GT expr(Y).    {A = sqliteExpr(TK_GT, X, Y, 0);}
1.1          (drh      29-May-00): expr(A) ::= expr(X) LE expr(Y).    {A = sqliteExpr(TK_LE, X, Y, 0);}
1.1          (drh      29-May-00): expr(A) ::= expr(X) GE expr(Y).    {A = sqliteExpr(TK_GE, X, Y, 0);}
1.1          (drh      29-May-00): expr(A) ::= expr(X) NE expr(Y).    {A = sqliteExpr(TK_NE, X, Y, 0);}
1.1          (drh      29-May-00): expr(A) ::= expr(X) EQ expr(Y).    {A = sqliteExpr(TK_EQ, X, Y, 0);}
1.36         (drh      12-Oct-01): expr(A) ::= expr(X) BITAND expr(Y). {A = sqliteExpr(TK_BITAND, X, Y, 0);}
1.36         (drh      12-Oct-01): expr(A) ::= expr(X) BITOR expr(Y).  {A = sqliteExpr(TK_BITOR, X, Y, 0);}
1.36         (drh      12-Oct-01): expr(A) ::= expr(X) LSHIFT expr(Y). {A = sqliteExpr(TK_LSHIFT, X, Y, 0);}
1.36         (drh      12-Oct-01): expr(A) ::= expr(X) RSHIFT expr(Y). {A = sqliteExpr(TK_RSHIFT, X, Y, 0);}
1.62         (drh      20-Apr-02): expr(A) ::= expr(X) likeop(OP) expr(Y).  [LIKE]  {
1.62         (drh      20-Apr-02):   ExprList *pList = sqliteExprListAppend(0, Y, 0);
1.62         (drh      20-Apr-02):   pList = sqliteExprListAppend(pList, X, 0);
1.82         (drh      24-Aug-02):   A = sqliteExprFunction(pList, 0);
1.82         (drh      24-Aug-02):   if( A ) A->op = OP;
1.84         (drh      22-Oct-02):   sqliteExprSpan(A, &X->span, &Y->span);
1.62         (drh      20-Apr-02): }
1.62         (drh      20-Apr-02): expr(A) ::= expr(X) NOT likeop(OP) expr(Y). [LIKE] {
1.62         (drh      20-Apr-02):   ExprList *pList = sqliteExprListAppend(0, Y, 0);
1.62         (drh      20-Apr-02):   pList = sqliteExprListAppend(pList, X, 0);
1.82         (drh      24-Aug-02):   A = sqliteExprFunction(pList, 0);
1.82         (drh      24-Aug-02):   if( A ) A->op = OP;
1.12         (drh      06-Jun-00):   A = sqliteExpr(TK_NOT, A, 0, 0);
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&X->span,&Y->span);
1.12         (drh      06-Jun-00): }
1.82         (drh      24-Aug-02): %type likeop {int}
1.82         (drh      24-Aug-02): likeop(A) ::= LIKE. {A = TK_LIKE;}
1.82         (drh      24-Aug-02): likeop(A) ::= GLOB. {A = TK_GLOB;}
1.1          (drh      29-May-00): expr(A) ::= expr(X) PLUS expr(Y).  {A = sqliteExpr(TK_PLUS, X, Y, 0);}
1.1          (drh      29-May-00): expr(A) ::= expr(X) MINUS expr(Y). {A = sqliteExpr(TK_MINUS, X, Y, 0);}
1.1          (drh      29-May-00): expr(A) ::= expr(X) STAR expr(Y).  {A = sqliteExpr(TK_STAR, X, Y, 0);}
1.1          (drh      29-May-00): expr(A) ::= expr(X) SLASH expr(Y). {A = sqliteExpr(TK_SLASH, X, Y, 0);}
1.37         (drh      13-Oct-01): expr(A) ::= expr(X) REM expr(Y).   {A = sqliteExpr(TK_REM, X, Y, 0);}
1.21         (drh      16-Jun-00): expr(A) ::= expr(X) CONCAT expr(Y). {A = sqliteExpr(TK_CONCAT, X, Y, 0);}
1.24         (drh      29-Jul-00): expr(A) ::= expr(X) ISNULL(E). {
1.24         (drh      29-Jul-00):   A = sqliteExpr(TK_ISNULL, X, 0, 0);
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&X->span,&E);
1.24         (drh      29-Jul-00): }
1.33         (drh      01-Oct-01): expr(A) ::= expr(X) IS NULL(E). {
1.33         (drh      01-Oct-01):   A = sqliteExpr(TK_ISNULL, X, 0, 0);
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&X->span,&E);
1.33         (drh      01-Oct-01): }
1.24         (drh      29-Jul-00): expr(A) ::= expr(X) NOTNULL(E). {
1.33         (drh      01-Oct-01):   A = sqliteExpr(TK_NOTNULL, X, 0, 0);
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&X->span,&E);
1.33         (drh      01-Oct-01): }
1.33         (drh      01-Oct-01): expr(A) ::= expr(X) NOT NULL(E). {
1.24         (drh      29-Jul-00):   A = sqliteExpr(TK_NOTNULL, X, 0, 0);
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&X->span,&E);
1.24         (drh      29-Jul-00): }
1.36         (drh      12-Oct-01): expr(A) ::= expr(X) IS NOT NULL(E). {
1.36         (drh      12-Oct-01):   A = sqliteExpr(TK_NOTNULL, X, 0, 0);
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&X->span,&E);
1.36         (drh      12-Oct-01): }
1.24         (drh      29-Jul-00): expr(A) ::= NOT(B) expr(X). {
1.24         (drh      29-Jul-00):   A = sqliteExpr(TK_NOT, X, 0, 0);
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&B,&X->span);
1.36         (drh      12-Oct-01): }
1.36         (drh      12-Oct-01): expr(A) ::= BITNOT(B) expr(X). {
1.36         (drh      12-Oct-01):   A = sqliteExpr(TK_BITNOT, X, 0, 0);
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&B,&X->span);
1.24         (drh      29-Jul-00): }
1.24         (drh      29-Jul-00): expr(A) ::= MINUS(B) expr(X). [UMINUS] {
1.24         (drh      29-Jul-00):   A = sqliteExpr(TK_UMINUS, X, 0, 0);
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&B,&X->span);
1.24         (drh      29-Jul-00): }
1.82         (drh      24-Aug-02): expr(A) ::= PLUS(B) expr(X). [UPLUS] {
1.82         (drh      24-Aug-02):   A = sqliteExpr(TK_UPLUS, X, 0, 0);
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&B,&X->span);
1.24         (drh      29-Jul-00): }
1.24         (drh      29-Jul-00): expr(A) ::= LP(B) select(X) RP(E). {
1.10         (drh      05-Jun-00):   A = sqliteExpr(TK_SELECT, 0, 0, 0);
1.28         (drh      11-Apr-01):   if( A ) A->pSelect = X;
1.24         (drh      29-Jul-00):   sqliteExprSpan(A,&B,&E);
1.10         (drh      05-Jun-00): }
1.11         (drh      06-Jun-00): expr(A) ::= expr(W) BETWEEN expr(X) AND expr(Y). {
1.11         (drh      06-Jun-00):   ExprList *pList = sqliteExprListAppend(0, X, 0);
1.11         (drh      06-Jun-00):   pList = sqliteExprListAppend(pList, Y, 0);
1.11         (drh      06-Jun-00):   A = sqliteExpr(TK_BETWEEN, W, 0, 0);
1.28         (drh      11-Apr-01):   if( A ) A->pList = pList;
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&W->span,&Y->span);
1.11         (drh      06-Jun-00): }
1.12         (drh      06-Jun-00): expr(A) ::= expr(W) NOT BETWEEN expr(X) AND expr(Y). {
1.12         (drh      06-Jun-00):   ExprList *pList = sqliteExprListAppend(0, X, 0);
1.12         (drh      06-Jun-00):   pList = sqliteExprListAppend(pList, Y, 0);
1.12         (drh      06-Jun-00):   A = sqliteExpr(TK_BETWEEN, W, 0, 0);
1.28         (drh      11-Apr-01):   if( A ) A->pList = pList;
1.12         (drh      06-Jun-00):   A = sqliteExpr(TK_NOT, A, 0, 0);
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&W->span,&Y->span);
1.12         (drh      06-Jun-00): }
1.24         (drh      29-Jul-00): expr(A) ::= expr(X) IN LP exprlist(Y) RP(E).  {
1.11         (drh      06-Jun-00):   A = sqliteExpr(TK_IN, X, 0, 0);
1.28         (drh      11-Apr-01):   if( A ) A->pList = Y;
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&X->span,&E);
1.11         (drh      06-Jun-00): }
1.24         (drh      29-Jul-00): expr(A) ::= expr(X) IN LP select(Y) RP(E).  {
1.11         (drh      06-Jun-00):   A = sqliteExpr(TK_IN, X, 0, 0);
1.28         (drh      11-Apr-01):   if( A ) A->pSelect = Y;
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&X->span,&E);
1.12         (drh      06-Jun-00): }
1.24         (drh      29-Jul-00): expr(A) ::= expr(X) NOT IN LP exprlist(Y) RP(E).  {
1.12         (drh      06-Jun-00):   A = sqliteExpr(TK_IN, X, 0, 0);
1.28         (drh      11-Apr-01):   if( A ) A->pList = Y;
1.12         (drh      06-Jun-00):   A = sqliteExpr(TK_NOT, A, 0, 0);
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&X->span,&E);
1.12         (drh      06-Jun-00): }
1.24         (drh      29-Jul-00): expr(A) ::= expr(X) NOT IN LP select(Y) RP(E).  {
1.12         (drh      06-Jun-00):   A = sqliteExpr(TK_IN, X, 0, 0);
1.28         (drh      11-Apr-01):   if( A ) A->pSelect = Y;
1.12         (drh      06-Jun-00):   A = sqliteExpr(TK_NOT, A, 0, 0);
1.84         (drh      22-Oct-02):   sqliteExprSpan(A,&X->span,&E);
1.11         (drh      06-Jun-00): }
1.11         (drh      06-Jun-00): 
1.58         (drh      24-Mar-02): /* CASE expressions */
1.58         (drh      24-Mar-02): expr(A) ::= CASE(C) case_operand(X) case_exprlist(Y) case_else(Z) END(E). {
1.58         (drh      24-Mar-02):   A = sqliteExpr(TK_CASE, X, Z, 0);
1.58         (drh      24-Mar-02):   if( A ) A->pList = Y;
1.58         (drh      24-Mar-02):   sqliteExprSpan(A, &C, &E);
1.58         (drh      24-Mar-02): }
1.58         (drh      24-Mar-02): %type case_exprlist {ExprList*}
1.58         (drh      24-Mar-02): %destructor case_exprlist {sqliteExprListDelete($$);}
1.58         (drh      24-Mar-02): case_exprlist(A) ::= case_exprlist(X) WHEN expr(Y) THEN expr(Z). {
1.58         (drh      24-Mar-02):   A = sqliteExprListAppend(X, Y, 0);
1.58         (drh      24-Mar-02):   A = sqliteExprListAppend(A, Z, 0);
1.58         (drh      24-Mar-02): }
1.58         (drh      24-Mar-02): case_exprlist(A) ::= WHEN expr(Y) THEN expr(Z). {
1.58         (drh      24-Mar-02):   A = sqliteExprListAppend(0, Y, 0);
1.58         (drh      24-Mar-02):   A = sqliteExprListAppend(A, Z, 0);
1.58         (drh      24-Mar-02): }
1.58         (drh      24-Mar-02): %type case_else {Expr*}
1.58         (drh      24-Mar-02): case_else(A) ::=  ELSE expr(X).         {A = X;}
1.58         (drh      24-Mar-02): case_else(A) ::=  .                     {A = 0;} 
1.58         (drh      24-Mar-02): %type case_operand {Expr*}
1.58         (drh      24-Mar-02): case_operand(A) ::= expr(X).            {A = X;} 
1.58         (drh      24-Mar-02): case_operand(A) ::= .                   {A = 0;} 
1.1          (drh      29-May-00): 
1.1          (drh      29-May-00): %type exprlist {ExprList*}
1.1          (drh      29-May-00): %destructor exprlist {sqliteExprListDelete($$);}
1.1          (drh      29-May-00): %type expritem {Expr*}
1.1          (drh      29-May-00): %destructor expritem {sqliteExprDelete($$);}
1.1          (drh      29-May-00): 
1.1          (drh      29-May-00): exprlist(A) ::= exprlist(X) COMMA expritem(Y). 
1.1          (drh      29-May-00):    {A = sqliteExprListAppend(X,Y,0);}