drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 1 | /* |
drh | b19a2bc | 2001-09-16 00:13:26 +0000 | [diff] [blame] | 2 | ** 2001 September 15 |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 3 | ** |
drh | b19a2bc | 2001-09-16 00:13:26 +0000 | [diff] [blame] | 4 | ** The author disclaims copyright to this source code. In place of |
| 5 | ** a legal notice, here is a blessing: |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 6 | ** |
drh | b19a2bc | 2001-09-16 00:13:26 +0000 | [diff] [blame] | 7 | ** May you do good and not evil. |
| 8 | ** May you find forgiveness for yourself and forgive others. |
| 9 | ** May you share freely, never taking more than you give. |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 10 | ** |
| 11 | ************************************************************************* |
| 12 | ** This file contains SQLite's grammar for SQL. Process this file |
| 13 | ** using the lemon parser generator to generate C code that runs |
| 14 | ** the parser. Lemon will also generate a header file containing |
| 15 | ** numeric codes for all of the tokens. |
| 16 | ** |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 17 | ** @(#) $Id: parse.y,v 1.34 2001/10/06 16:33:03 drh Exp $ |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 18 | */ |
| 19 | %token_prefix TK_ |
| 20 | %token_type {Token} |
drh | f57b14a | 2001-09-14 18:54:08 +0000 | [diff] [blame] | 21 | %default_type {Token} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 22 | %extra_argument {Parse *pParse} |
| 23 | %syntax_error { |
drh | c837e70 | 2000-06-08 16:26:24 +0000 | [diff] [blame] | 24 | sqliteSetString(&pParse->zErrMsg,"syntax error",0); |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 25 | pParse->sErrToken = TOKEN; |
| 26 | } |
| 27 | %name sqliteParser |
| 28 | %include { |
| 29 | #include "sqliteInt.h" |
| 30 | #include "parse.h" |
| 31 | } |
| 32 | |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 33 | // These are extra tokens used by the lexer but never seen by the |
| 34 | // parser. We put them in a rule so that the parser generator will |
drh | 6206d50 | 2000-06-19 19:09:08 +0000 | [diff] [blame] | 35 | // add them to the parse.h output file. |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 36 | // |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 37 | %nonassoc END_OF_FILE ILLEGAL SPACE UNCLOSED_STRING COMMENT FUNCTION |
| 38 | COLUMN AGG_FUNCTION. |
| 39 | |
| 40 | // Input is zero or more commands. |
| 41 | input ::= cmdlist. |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 42 | |
| 43 | // A list of commands is zero or more commands |
| 44 | // |
| 45 | cmdlist ::= ecmd. |
| 46 | cmdlist ::= cmdlist SEMI ecmd. |
| 47 | ecmd ::= explain cmd. {sqliteExec(pParse);} |
| 48 | ecmd ::= cmd. {sqliteExec(pParse);} |
| 49 | ecmd ::= . |
| 50 | explain ::= EXPLAIN. {pParse->explain = 1;} |
| 51 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 52 | ///////////////////// Begin and end transactions. //////////////////////////// |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 53 | // |
| 54 | cmd ::= BEGIN trans_opt. {sqliteBeginTransaction(pParse);} |
| 55 | trans_opt ::= . |
| 56 | trans_opt ::= TRANSACTION. |
| 57 | trans_opt ::= TRANSACTION ids. |
| 58 | cmd ::= COMMIT trans_opt. {sqliteCommitTransaction(pParse);} |
| 59 | cmd ::= END trans_opt. {sqliteCommitTransaction(pParse);} |
| 60 | cmd ::= ROLLBACK trans_opt. {sqliteRollbackTransaction(pParse);} |
| 61 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 62 | ///////////////////// The CREATE TABLE statement //////////////////////////// |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 63 | // |
| 64 | cmd ::= create_table create_table_args. |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 65 | create_table ::= CREATE(X) TABLE ids(Y). {sqliteStartTable(pParse,&X,&Y);} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 66 | create_table_args ::= LP columnlist conslist_opt RP(X). |
| 67 | {sqliteEndTable(pParse,&X);} |
| 68 | columnlist ::= columnlist COMMA column. |
| 69 | columnlist ::= column. |
| 70 | |
| 71 | // About the only information used for a column is the name of the |
| 72 | // column. The type is always just "text". But the code will accept |
| 73 | // an elaborate typename. Perhaps someday we'll do something with it. |
| 74 | // |
| 75 | column ::= columnid type carglist. |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 76 | columnid ::= ids(X). {sqliteAddColumn(pParse,&X);} |
| 77 | |
| 78 | // An IDENTIFIER can be a generic identifier, or one of several |
| 79 | // keywords. Any non-standard keyword can also be an identifier. |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 80 | // We also make DESC and identifier since it comes up so often (as |
| 81 | // an abbreviation of "description"). |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 82 | // |
drh | 982cef7 | 2000-05-30 16:27:03 +0000 | [diff] [blame] | 83 | %type id {Token} |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 84 | id(A) ::= DESC(X). {A = X;} |
| 85 | id(A) ::= ASC(X). {A = X;} |
| 86 | id(A) ::= DELIMITERS(X). {A = X;} |
| 87 | id(A) ::= EXPLAIN(X). {A = X;} |
| 88 | id(A) ::= VACUUM(X). {A = X;} |
| 89 | id(A) ::= BEGIN(X). {A = X;} |
| 90 | id(A) ::= END(X). {A = X;} |
drh | f57b14a | 2001-09-14 18:54:08 +0000 | [diff] [blame] | 91 | id(A) ::= PRAGMA(X). {A = X;} |
| 92 | id(A) ::= CLUSTER(X). {A = X;} |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 93 | id(A) ::= ID(X). {A = X;} |
| 94 | |
| 95 | // And "ids" is an identifer-or-string. |
| 96 | // |
| 97 | %type ids {Token} |
| 98 | ids(A) ::= id(X). {A = X;} |
| 99 | ids(A) ::= STRING(X). {A = X;} |
| 100 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 101 | type ::= . |
| 102 | type ::= typename(X). {sqliteAddColumnType(pParse,&X,&X);} |
| 103 | type ::= typename(X) LP signed RP(Y). {sqliteAddColumnType(pParse,&X,&Y);} |
| 104 | type ::= typename(X) LP signed COMMA signed RP(Y). |
| 105 | {sqliteAddColumnType(pParse,&X,&Y);} |
| 106 | %type typename {Token} |
| 107 | typename(A) ::= ids(X). {A = X;} |
| 108 | typename(A) ::= typename(X) ids. {A = X;} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 109 | signed ::= INTEGER. |
| 110 | signed ::= PLUS INTEGER. |
| 111 | signed ::= MINUS INTEGER. |
| 112 | carglist ::= carglist carg. |
| 113 | carglist ::= . |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 114 | carg ::= CONSTRAINT ids ccons. |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 115 | carg ::= ccons. |
drh | 7020f65 | 2000-06-03 18:06:52 +0000 | [diff] [blame] | 116 | carg ::= DEFAULT STRING(X). {sqliteAddDefaultValue(pParse,&X,0);} |
| 117 | carg ::= DEFAULT ID(X). {sqliteAddDefaultValue(pParse,&X,0);} |
| 118 | carg ::= DEFAULT INTEGER(X). {sqliteAddDefaultValue(pParse,&X,0);} |
| 119 | carg ::= DEFAULT PLUS INTEGER(X). {sqliteAddDefaultValue(pParse,&X,0);} |
| 120 | carg ::= DEFAULT MINUS INTEGER(X). {sqliteAddDefaultValue(pParse,&X,1);} |
| 121 | carg ::= DEFAULT FLOAT(X). {sqliteAddDefaultValue(pParse,&X,0);} |
| 122 | carg ::= DEFAULT PLUS FLOAT(X). {sqliteAddDefaultValue(pParse,&X,0);} |
| 123 | carg ::= DEFAULT MINUS FLOAT(X). {sqliteAddDefaultValue(pParse,&X,1);} |
| 124 | carg ::= DEFAULT NULL. |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 125 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 126 | // In addition to the type name, we also care about the primary key and |
| 127 | // UNIQUE constraints. |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 128 | // |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 129 | ccons ::= NOT NULL. {sqliteAddNotNull(pParse);} |
drh | 717e640 | 2001-09-27 03:22:32 +0000 | [diff] [blame] | 130 | ccons ::= PRIMARY KEY sortorder. {sqliteCreateIndex(pParse,0,0,0,1,0,0);} |
drh | adbca9c | 2001-09-27 15:11:53 +0000 | [diff] [blame] | 131 | ccons ::= UNIQUE. {sqliteCreateIndex(pParse,0,0,0,1,0,0);} |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 132 | ccons ::= CHECK LP expr RP. |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 133 | |
| 134 | // For the time being, the only constraint we care about is the primary |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 135 | // key and UNIQUE. Both create indices. |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 136 | // |
| 137 | conslist_opt ::= . |
| 138 | conslist_opt ::= COMMA conslist. |
| 139 | conslist ::= conslist COMMA tcons. |
drh | a2e1bb5 | 2001-01-04 14:20:18 +0000 | [diff] [blame] | 140 | conslist ::= conslist tcons. |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 141 | conslist ::= tcons. |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 142 | tcons ::= CONSTRAINT ids. |
drh | 717e640 | 2001-09-27 03:22:32 +0000 | [diff] [blame] | 143 | tcons ::= PRIMARY KEY LP idxlist(X) RP. {sqliteCreateIndex(pParse,0,0,X,1,0,0);} |
drh | adbca9c | 2001-09-27 15:11:53 +0000 | [diff] [blame] | 144 | tcons ::= UNIQUE LP idxlist(X) RP. {sqliteCreateIndex(pParse,0,0,X,1,0,0);} |
drh | a2e1bb5 | 2001-01-04 14:20:18 +0000 | [diff] [blame] | 145 | tcons ::= CHECK expr. |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 146 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 147 | ////////////////////////// The DROP TABLE ///////////////////////////////////// |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 148 | // |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 149 | cmd ::= DROP TABLE ids(X). {sqliteDropTable(pParse,&X);} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 150 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 151 | //////////////////////// The SELECT statement ///////////////////////////////// |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 152 | // |
drh | 9bb61fe | 2000-06-05 16:01:39 +0000 | [diff] [blame] | 153 | cmd ::= select(X). { |
drh | fef5208 | 2000-06-06 01:50:43 +0000 | [diff] [blame] | 154 | sqliteSelect(pParse, X, SRT_Callback, 0); |
drh | 9bb61fe | 2000-06-05 16:01:39 +0000 | [diff] [blame] | 155 | sqliteSelectDelete(X); |
| 156 | } |
drh | efb7251 | 2000-05-31 20:00:52 +0000 | [diff] [blame] | 157 | |
drh | 9bb61fe | 2000-06-05 16:01:39 +0000 | [diff] [blame] | 158 | %type select {Select*} |
| 159 | %destructor select {sqliteSelectDelete($$);} |
drh | 82c3d63 | 2000-06-06 21:56:07 +0000 | [diff] [blame] | 160 | %type oneselect {Select*} |
| 161 | %destructor oneselect {sqliteSelectDelete($$);} |
drh | 9bb61fe | 2000-06-05 16:01:39 +0000 | [diff] [blame] | 162 | |
drh | 82c3d63 | 2000-06-06 21:56:07 +0000 | [diff] [blame] | 163 | select(A) ::= oneselect(X). {A = X;} |
| 164 | select(A) ::= select(X) joinop(Y) oneselect(Z). { |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 165 | if( Z ){ |
drh | 82c3d63 | 2000-06-06 21:56:07 +0000 | [diff] [blame] | 166 | Z->op = Y; |
| 167 | Z->pPrior = X; |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 168 | } |
| 169 | A = Z; |
drh | 82c3d63 | 2000-06-06 21:56:07 +0000 | [diff] [blame] | 170 | } |
| 171 | %type joinop {int} |
| 172 | joinop(A) ::= UNION. {A = TK_UNION;} |
| 173 | joinop(A) ::= UNION ALL. {A = TK_ALL;} |
| 174 | joinop(A) ::= INTERSECT. {A = TK_INTERSECT;} |
| 175 | joinop(A) ::= EXCEPT. {A = TK_EXCEPT;} |
| 176 | oneselect(A) ::= SELECT distinct(D) selcollist(W) from(X) where_opt(Y) |
| 177 | groupby_opt(P) having_opt(Q) orderby_opt(Z). { |
drh | 2282792 | 2000-06-06 17:27:05 +0000 | [diff] [blame] | 178 | A = sqliteSelectNew(W,X,Y,P,Q,Z,D); |
drh | 9bb61fe | 2000-06-05 16:01:39 +0000 | [diff] [blame] | 179 | } |
| 180 | |
| 181 | // The "distinct" nonterminal is true (1) if the DISTINCT keyword is |
| 182 | // present and false (0) if it is not. |
| 183 | // |
drh | efb7251 | 2000-05-31 20:00:52 +0000 | [diff] [blame] | 184 | %type distinct {int} |
drh | efb7251 | 2000-05-31 20:00:52 +0000 | [diff] [blame] | 185 | distinct(A) ::= DISTINCT. {A = 1;} |
drh | fef5208 | 2000-06-06 01:50:43 +0000 | [diff] [blame] | 186 | distinct(A) ::= ALL. {A = 0;} |
drh | efb7251 | 2000-05-31 20:00:52 +0000 | [diff] [blame] | 187 | distinct(A) ::= . {A = 0;} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 188 | |
drh | 9bb61fe | 2000-06-05 16:01:39 +0000 | [diff] [blame] | 189 | // selcollist is a list of expressions that are to become the return |
| 190 | // values of the SELECT statement. In the case of "SELECT * FROM ..." |
| 191 | // the selcollist value is NULL. |
| 192 | // |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 193 | %type selcollist {ExprList*} |
| 194 | %destructor selcollist {sqliteExprListDelete($$);} |
| 195 | %type sclp {ExprList*} |
| 196 | %destructor sclp {sqliteExprListDelete($$);} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 197 | sclp(A) ::= selcollist(X) COMMA. {A = X;} |
| 198 | sclp(A) ::= . {A = 0;} |
drh | 9bb61fe | 2000-06-05 16:01:39 +0000 | [diff] [blame] | 199 | selcollist(A) ::= STAR. {A = 0;} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 200 | selcollist(A) ::= sclp(P) expr(X). {A = sqliteExprListAppend(P,X,0);} |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 201 | selcollist(A) ::= sclp(P) expr(X) as ids(Y). {A = sqliteExprListAppend(P,X,&Y);} |
drh | 9bb61fe | 2000-06-05 16:01:39 +0000 | [diff] [blame] | 202 | as ::= . |
| 203 | as ::= AS. |
| 204 | |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 205 | |
| 206 | %type seltablist {IdList*} |
| 207 | %destructor seltablist {sqliteIdListDelete($$);} |
| 208 | %type stl_prefix {IdList*} |
| 209 | %destructor stl_prefix {sqliteIdListDelete($$);} |
| 210 | %type from {IdList*} |
| 211 | %destructor from {sqliteIdListDelete($$);} |
| 212 | |
| 213 | from(A) ::= FROM seltablist(X). {A = X;} |
| 214 | stl_prefix(A) ::= seltablist(X) COMMA. {A = X;} |
| 215 | stl_prefix(A) ::= . {A = 0;} |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 216 | seltablist(A) ::= stl_prefix(X) ids(Y). {A = sqliteIdListAppend(X,&Y);} |
| 217 | seltablist(A) ::= stl_prefix(X) ids(Y) as ids(Z). { |
| 218 | A = sqliteIdListAppend(X,&Y); |
| 219 | sqliteIdListAddAlias(A,&Z); |
| 220 | } |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 221 | |
| 222 | %type orderby_opt {ExprList*} |
| 223 | %destructor orderby_opt {sqliteExprListDelete($$);} |
| 224 | %type sortlist {ExprList*} |
| 225 | %destructor sortlist {sqliteExprListDelete($$);} |
| 226 | %type sortitem {Expr*} |
| 227 | %destructor sortitem {sqliteExprDelete($$);} |
| 228 | |
| 229 | orderby_opt(A) ::= . {A = 0;} |
| 230 | orderby_opt(A) ::= ORDER BY sortlist(X). {A = X;} |
drh | 9bb61fe | 2000-06-05 16:01:39 +0000 | [diff] [blame] | 231 | sortlist(A) ::= sortlist(X) COMMA sortitem(Y) sortorder(Z). { |
| 232 | A = sqliteExprListAppend(X,Y,0); |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 233 | if( A ) A->a[A->nExpr-1].sortOrder = Z; /* 0=ascending, 1=decending */ |
drh | 9bb61fe | 2000-06-05 16:01:39 +0000 | [diff] [blame] | 234 | } |
| 235 | sortlist(A) ::= sortitem(Y) sortorder(Z). { |
| 236 | A = sqliteExprListAppend(0,Y,0); |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 237 | if( A ) A->a[0].sortOrder = Z; |
drh | 9bb61fe | 2000-06-05 16:01:39 +0000 | [diff] [blame] | 238 | } |
drh | da9d6c4 | 2000-05-31 18:20:14 +0000 | [diff] [blame] | 239 | sortitem(A) ::= expr(X). {A = X;} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 240 | |
| 241 | %type sortorder {int} |
| 242 | |
| 243 | sortorder(A) ::= ASC. {A = 0;} |
| 244 | sortorder(A) ::= DESC. {A = 1;} |
| 245 | sortorder(A) ::= . {A = 0;} |
| 246 | |
drh | 2282792 | 2000-06-06 17:27:05 +0000 | [diff] [blame] | 247 | %type groupby_opt {ExprList*} |
| 248 | %destructor groupby_opt {sqliteExprListDelete($$);} |
drh | 6206d50 | 2000-06-19 19:09:08 +0000 | [diff] [blame] | 249 | groupby_opt(A) ::= . {A = 0;} |
drh | 2282792 | 2000-06-06 17:27:05 +0000 | [diff] [blame] | 250 | groupby_opt(A) ::= GROUP BY exprlist(X). {A = X;} |
| 251 | |
| 252 | %type having_opt {Expr*} |
| 253 | %destructor having_opt {sqliteExprDelete($$);} |
drh | 6206d50 | 2000-06-19 19:09:08 +0000 | [diff] [blame] | 254 | having_opt(A) ::= . {A = 0;} |
drh | 2282792 | 2000-06-06 17:27:05 +0000 | [diff] [blame] | 255 | having_opt(A) ::= HAVING expr(X). {A = X;} |
| 256 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 257 | /////////////////////////// The DELETE statement ///////////////////////////// |
| 258 | // |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 259 | cmd ::= DELETE FROM ids(X) where_opt(Y). |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 260 | {sqliteDeleteFrom(pParse, &X, Y);} |
| 261 | |
| 262 | %type where_opt {Expr*} |
| 263 | %destructor where_opt {sqliteExprDelete($$);} |
| 264 | |
| 265 | where_opt(A) ::= . {A = 0;} |
| 266 | where_opt(A) ::= WHERE expr(X). {A = X;} |
| 267 | |
| 268 | %type setlist {ExprList*} |
| 269 | %destructor setlist {sqliteExprListDelete($$);} |
| 270 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 271 | ////////////////////////// The UPDATE command //////////////////////////////// |
| 272 | // |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 273 | cmd ::= UPDATE ids(X) SET setlist(Y) where_opt(Z). |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 274 | {sqliteUpdate(pParse,&X,Y,Z);} |
| 275 | |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 276 | setlist(A) ::= setlist(Z) COMMA ids(X) EQ expr(Y). |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 277 | {A = sqliteExprListAppend(Z,Y,&X);} |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 278 | setlist(A) ::= ids(X) EQ expr(Y). {A = sqliteExprListAppend(0,Y,&X);} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 279 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 280 | ////////////////////////// The INSERT command ///////////////////////////////// |
| 281 | // |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 282 | cmd ::= INSERT INTO ids(X) inscollist_opt(F) VALUES LP itemlist(Y) RP. |
drh | 5974a30 | 2000-06-07 14:42:26 +0000 | [diff] [blame] | 283 | {sqliteInsert(pParse, &X, Y, 0, F);} |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 284 | cmd ::= INSERT INTO ids(X) inscollist_opt(F) select(S). |
drh | 5974a30 | 2000-06-07 14:42:26 +0000 | [diff] [blame] | 285 | {sqliteInsert(pParse, &X, 0, S, F);} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 286 | |
| 287 | |
| 288 | %type itemlist {ExprList*} |
| 289 | %destructor itemlist {sqliteExprListDelete($$);} |
| 290 | %type item {Expr*} |
| 291 | %destructor item {sqliteExprDelete($$);} |
| 292 | |
| 293 | itemlist(A) ::= itemlist(X) COMMA item(Y). {A = sqliteExprListAppend(X,Y,0);} |
| 294 | itemlist(A) ::= item(X). {A = sqliteExprListAppend(0,X,0);} |
| 295 | item(A) ::= INTEGER(X). {A = sqliteExpr(TK_INTEGER, 0, 0, &X);} |
drh | 7020f65 | 2000-06-03 18:06:52 +0000 | [diff] [blame] | 296 | item(A) ::= PLUS INTEGER(X). {A = sqliteExpr(TK_INTEGER, 0, 0, &X);} |
| 297 | item(A) ::= MINUS INTEGER(X). { |
drh | 6e142f5 | 2000-06-08 13:36:40 +0000 | [diff] [blame] | 298 | A = sqliteExpr(TK_UMINUS, 0, 0, 0); |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 299 | if( A ) A->pLeft = sqliteExpr(TK_INTEGER, 0, 0, &X); |
drh | 7020f65 | 2000-06-03 18:06:52 +0000 | [diff] [blame] | 300 | } |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 301 | item(A) ::= FLOAT(X). {A = sqliteExpr(TK_FLOAT, 0, 0, &X);} |
drh | 7020f65 | 2000-06-03 18:06:52 +0000 | [diff] [blame] | 302 | item(A) ::= PLUS FLOAT(X). {A = sqliteExpr(TK_FLOAT, 0, 0, &X);} |
| 303 | item(A) ::= MINUS FLOAT(X). { |
drh | 6e142f5 | 2000-06-08 13:36:40 +0000 | [diff] [blame] | 304 | A = sqliteExpr(TK_UMINUS, 0, 0, 0); |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 305 | if( A ) A->pLeft = sqliteExpr(TK_FLOAT, 0, 0, &X); |
drh | 7020f65 | 2000-06-03 18:06:52 +0000 | [diff] [blame] | 306 | } |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 307 | item(A) ::= STRING(X). {A = sqliteExpr(TK_STRING, 0, 0, &X);} |
drh | 8be5113 | 2000-06-03 19:19:41 +0000 | [diff] [blame] | 308 | item(A) ::= NULL. {A = sqliteExpr(TK_NULL, 0, 0, 0);} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 309 | |
drh | 967e8b7 | 2000-06-21 13:59:10 +0000 | [diff] [blame] | 310 | %type inscollist_opt {IdList*} |
| 311 | %destructor inscollist_opt {sqliteIdListDelete($$);} |
| 312 | %type inscollist {IdList*} |
| 313 | %destructor inscollist {sqliteIdListDelete($$);} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 314 | |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 315 | inscollist_opt(A) ::= . {A = 0;} |
| 316 | inscollist_opt(A) ::= LP inscollist(X) RP. {A = X;} |
| 317 | inscollist(A) ::= inscollist(X) COMMA ids(Y). {A = sqliteIdListAppend(X,&Y);} |
| 318 | inscollist(A) ::= ids(Y). {A = sqliteIdListAppend(0,&Y);} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 319 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 320 | /////////////////////////// Expression Processing ///////////////////////////// |
| 321 | // |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 322 | %left OR. |
| 323 | %left AND. |
drh | 8be5113 | 2000-06-03 19:19:41 +0000 | [diff] [blame] | 324 | %right NOT. |
drh | fef5208 | 2000-06-06 01:50:43 +0000 | [diff] [blame] | 325 | %left EQ NE ISNULL NOTNULL IS LIKE GLOB BETWEEN IN. |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 326 | %left GT GE LT LE. |
| 327 | %left PLUS MINUS. |
drh | 31884b0 | 2000-06-09 14:14:32 +0000 | [diff] [blame] | 328 | %left STAR SLASH. |
drh | 0040077 | 2000-06-16 20:51:26 +0000 | [diff] [blame] | 329 | %left CONCAT. |
drh | 8be5113 | 2000-06-03 19:19:41 +0000 | [diff] [blame] | 330 | %right UMINUS. |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 331 | |
| 332 | %type expr {Expr*} |
| 333 | %destructor expr {sqliteExprDelete($$);} |
| 334 | |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 335 | expr(A) ::= LP(B) expr(X) RP(E). {A = X; sqliteExprSpan(A,&B,&E);} |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 336 | expr(A) ::= NULL(X). {A = sqliteExpr(TK_NULL, 0, 0, &X);} |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 337 | expr(A) ::= id(X). {A = sqliteExpr(TK_ID, 0, 0, &X);} |
| 338 | expr(A) ::= ids(X) DOT ids(Y). { |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 339 | Expr *temp1 = sqliteExpr(TK_ID, 0, 0, &X); |
| 340 | Expr *temp2 = sqliteExpr(TK_ID, 0, 0, &Y); |
| 341 | A = sqliteExpr(TK_DOT, temp1, temp2, 0); |
| 342 | } |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 343 | expr(A) ::= INTEGER(X). {A = sqliteExpr(TK_INTEGER, 0, 0, &X);} |
| 344 | expr(A) ::= FLOAT(X). {A = sqliteExpr(TK_FLOAT, 0, 0, &X);} |
| 345 | expr(A) ::= STRING(X). {A = sqliteExpr(TK_STRING, 0, 0, &X);} |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 346 | expr(A) ::= ID(X) LP exprlist(Y) RP(E). { |
| 347 | A = sqliteExprFunction(Y, &X); |
| 348 | sqliteExprSpan(A,&X,&E); |
| 349 | } |
| 350 | expr(A) ::= ID(X) LP STAR RP(E). { |
| 351 | A = sqliteExprFunction(0, &X); |
| 352 | sqliteExprSpan(A,&X,&E); |
| 353 | } |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 354 | expr(A) ::= expr(X) AND expr(Y). {A = sqliteExpr(TK_AND, X, Y, 0);} |
| 355 | expr(A) ::= expr(X) OR expr(Y). {A = sqliteExpr(TK_OR, X, Y, 0);} |
| 356 | expr(A) ::= expr(X) LT expr(Y). {A = sqliteExpr(TK_LT, X, Y, 0);} |
| 357 | expr(A) ::= expr(X) GT expr(Y). {A = sqliteExpr(TK_GT, X, Y, 0);} |
| 358 | expr(A) ::= expr(X) LE expr(Y). {A = sqliteExpr(TK_LE, X, Y, 0);} |
| 359 | expr(A) ::= expr(X) GE expr(Y). {A = sqliteExpr(TK_GE, X, Y, 0);} |
| 360 | expr(A) ::= expr(X) NE expr(Y). {A = sqliteExpr(TK_NE, X, Y, 0);} |
| 361 | expr(A) ::= expr(X) EQ expr(Y). {A = sqliteExpr(TK_EQ, X, Y, 0);} |
drh | dce2cbe | 2000-05-31 02:27:49 +0000 | [diff] [blame] | 362 | expr(A) ::= expr(X) LIKE expr(Y). {A = sqliteExpr(TK_LIKE, X, Y, 0);} |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 363 | expr(A) ::= expr(X) NOT LIKE expr(Y). { |
| 364 | A = sqliteExpr(TK_LIKE, X, Y, 0); |
| 365 | A = sqliteExpr(TK_NOT, A, 0, 0); |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 366 | sqliteExprSpan(A,&X->span,&Y->span); |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 367 | } |
drh | fef5208 | 2000-06-06 01:50:43 +0000 | [diff] [blame] | 368 | expr(A) ::= expr(X) GLOB expr(Y). {A = sqliteExpr(TK_GLOB,X,Y,0);} |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 369 | expr(A) ::= expr(X) NOT GLOB expr(Y). { |
| 370 | A = sqliteExpr(TK_GLOB, X, Y, 0); |
| 371 | A = sqliteExpr(TK_NOT, A, 0, 0); |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 372 | sqliteExprSpan(A,&X->span,&Y->span); |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 373 | } |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 374 | expr(A) ::= expr(X) PLUS expr(Y). {A = sqliteExpr(TK_PLUS, X, Y, 0);} |
| 375 | expr(A) ::= expr(X) MINUS expr(Y). {A = sqliteExpr(TK_MINUS, X, Y, 0);} |
| 376 | expr(A) ::= expr(X) STAR expr(Y). {A = sqliteExpr(TK_STAR, X, Y, 0);} |
| 377 | expr(A) ::= expr(X) SLASH expr(Y). {A = sqliteExpr(TK_SLASH, X, Y, 0);} |
drh | 0040077 | 2000-06-16 20:51:26 +0000 | [diff] [blame] | 378 | expr(A) ::= expr(X) CONCAT expr(Y). {A = sqliteExpr(TK_CONCAT, X, Y, 0);} |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 379 | expr(A) ::= expr(X) ISNULL(E). { |
| 380 | A = sqliteExpr(TK_ISNULL, X, 0, 0); |
| 381 | sqliteExprSpan(A,&X->span,&E); |
| 382 | } |
drh | 33048c0 | 2001-10-01 14:29:22 +0000 | [diff] [blame] | 383 | expr(A) ::= expr(X) IS NULL(E). { |
| 384 | A = sqliteExpr(TK_ISNULL, X, 0, 0); |
| 385 | sqliteExprSpan(A,&X->span,&E); |
| 386 | } |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 387 | expr(A) ::= expr(X) NOTNULL(E). { |
| 388 | A = sqliteExpr(TK_NOTNULL, X, 0, 0); |
| 389 | sqliteExprSpan(A,&X->span,&E); |
| 390 | } |
drh | 33048c0 | 2001-10-01 14:29:22 +0000 | [diff] [blame] | 391 | expr(A) ::= expr(X) NOT NULL(E). { |
| 392 | A = sqliteExpr(TK_NOTNULL, X, 0, 0); |
| 393 | sqliteExprSpan(A,&X->span,&E); |
| 394 | } |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 395 | expr(A) ::= NOT(B) expr(X). { |
| 396 | A = sqliteExpr(TK_NOT, X, 0, 0); |
| 397 | sqliteExprSpan(A,&B,&X->span); |
| 398 | } |
| 399 | expr(A) ::= MINUS(B) expr(X). [UMINUS] { |
| 400 | A = sqliteExpr(TK_UMINUS, X, 0, 0); |
| 401 | sqliteExprSpan(A,&B,&X->span); |
| 402 | } |
| 403 | expr(A) ::= PLUS(B) expr(X). [UMINUS] { |
| 404 | A = X; |
| 405 | sqliteExprSpan(A,&B,&X->span); |
| 406 | } |
| 407 | expr(A) ::= LP(B) select(X) RP(E). { |
drh | 19a775c | 2000-06-05 18:54:46 +0000 | [diff] [blame] | 408 | A = sqliteExpr(TK_SELECT, 0, 0, 0); |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 409 | if( A ) A->pSelect = X; |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 410 | sqliteExprSpan(A,&B,&E); |
drh | 19a775c | 2000-06-05 18:54:46 +0000 | [diff] [blame] | 411 | } |
drh | fef5208 | 2000-06-06 01:50:43 +0000 | [diff] [blame] | 412 | expr(A) ::= expr(W) BETWEEN expr(X) AND expr(Y). { |
| 413 | ExprList *pList = sqliteExprListAppend(0, X, 0); |
| 414 | pList = sqliteExprListAppend(pList, Y, 0); |
| 415 | A = sqliteExpr(TK_BETWEEN, W, 0, 0); |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 416 | if( A ) A->pList = pList; |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 417 | sqliteExprSpan(A,&W->span,&Y->span); |
drh | fef5208 | 2000-06-06 01:50:43 +0000 | [diff] [blame] | 418 | } |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 419 | expr(A) ::= expr(W) NOT BETWEEN expr(X) AND expr(Y). { |
| 420 | ExprList *pList = sqliteExprListAppend(0, X, 0); |
| 421 | pList = sqliteExprListAppend(pList, Y, 0); |
| 422 | A = sqliteExpr(TK_BETWEEN, W, 0, 0); |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 423 | if( A ) A->pList = pList; |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 424 | A = sqliteExpr(TK_NOT, A, 0, 0); |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 425 | sqliteExprSpan(A,&W->span,&Y->span); |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 426 | } |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 427 | expr(A) ::= expr(X) IN LP exprlist(Y) RP(E). { |
drh | fef5208 | 2000-06-06 01:50:43 +0000 | [diff] [blame] | 428 | A = sqliteExpr(TK_IN, X, 0, 0); |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 429 | if( A ) A->pList = Y; |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 430 | sqliteExprSpan(A,&X->span,&E); |
drh | fef5208 | 2000-06-06 01:50:43 +0000 | [diff] [blame] | 431 | } |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 432 | expr(A) ::= expr(X) IN LP select(Y) RP(E). { |
drh | fef5208 | 2000-06-06 01:50:43 +0000 | [diff] [blame] | 433 | A = sqliteExpr(TK_IN, X, 0, 0); |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 434 | if( A ) A->pSelect = Y; |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 435 | sqliteExprSpan(A,&X->span,&E); |
drh | fef5208 | 2000-06-06 01:50:43 +0000 | [diff] [blame] | 436 | } |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 437 | expr(A) ::= expr(X) NOT IN LP exprlist(Y) RP(E). { |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 438 | A = sqliteExpr(TK_IN, X, 0, 0); |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 439 | if( A ) A->pList = Y; |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 440 | A = sqliteExpr(TK_NOT, A, 0, 0); |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 441 | sqliteExprSpan(A,&X->span,&E); |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 442 | } |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 443 | expr(A) ::= expr(X) NOT IN LP select(Y) RP(E). { |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 444 | A = sqliteExpr(TK_IN, X, 0, 0); |
drh | daffd0e | 2001-04-11 14:28:42 +0000 | [diff] [blame] | 445 | if( A ) A->pSelect = Y; |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 446 | A = sqliteExpr(TK_NOT, A, 0, 0); |
drh | e1b6a5b | 2000-07-29 13:06:59 +0000 | [diff] [blame] | 447 | sqliteExprSpan(A,&X->span,&E); |
drh | 4794b98 | 2000-06-06 13:54:14 +0000 | [diff] [blame] | 448 | } |
drh | fef5208 | 2000-06-06 01:50:43 +0000 | [diff] [blame] | 449 | |
| 450 | |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 451 | |
| 452 | %type exprlist {ExprList*} |
| 453 | %destructor exprlist {sqliteExprListDelete($$);} |
| 454 | %type expritem {Expr*} |
| 455 | %destructor expritem {sqliteExprDelete($$);} |
| 456 | |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 457 | exprlist(A) ::= exprlist(X) COMMA expritem(Y). |
| 458 | {A = sqliteExprListAppend(X,Y,0);} |
| 459 | exprlist(A) ::= expritem(X). {A = sqliteExprListAppend(0,X,0);} |
| 460 | expritem(A) ::= expr(X). {A = X;} |
| 461 | expritem(A) ::= . {A = 0;} |
drh | cce7d17 | 2000-05-31 15:34:51 +0000 | [diff] [blame] | 462 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 463 | ///////////////////////////// The CREATE INDEX command /////////////////////// |
| 464 | // |
drh | 717e640 | 2001-09-27 03:22:32 +0000 | [diff] [blame] | 465 | cmd ::= CREATE(S) uniqueflag(U) INDEX ids(X) ON ids(Y) LP idxlist(Z) RP(E). |
| 466 | {sqliteCreateIndex(pParse, &X, &Y, Z, U, &S, &E);} |
| 467 | |
| 468 | %type uniqueflag {int} |
| 469 | uniqueflag(A) ::= UNIQUE. { A = 1; } |
| 470 | uniqueflag(A) ::= . { A = 0; } |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 471 | |
| 472 | %type idxlist {IdList*} |
| 473 | %destructor idxlist {sqliteIdListDelete($$);} |
| 474 | %type idxitem {Token} |
| 475 | |
| 476 | idxlist(A) ::= idxlist(X) COMMA idxitem(Y). |
| 477 | {A = sqliteIdListAppend(X,&Y);} |
| 478 | idxlist(A) ::= idxitem(Y). |
| 479 | {A = sqliteIdListAppend(0,&Y);} |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 480 | idxitem(A) ::= ids(X). {A = X;} |
drh | 348784e | 2000-05-29 20:41:49 +0000 | [diff] [blame] | 481 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 482 | ///////////////////////////// The CREATE INDEX command /////////////////////// |
| 483 | // |
| 484 | |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 485 | cmd ::= DROP INDEX ids(X). {sqliteDropIndex(pParse, &X);} |
drh | 982cef7 | 2000-05-30 16:27:03 +0000 | [diff] [blame] | 486 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 487 | |
| 488 | ///////////////////////////// The DROP INDEX command ///////////////////////// |
| 489 | // |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 490 | cmd ::= COPY ids(X) FROM ids(Y) USING DELIMITERS STRING(Z). |
drh | 982cef7 | 2000-05-30 16:27:03 +0000 | [diff] [blame] | 491 | {sqliteCopy(pParse,&X,&Y,&Z);} |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 492 | cmd ::= COPY ids(X) FROM ids(Y). |
drh | 982cef7 | 2000-05-30 16:27:03 +0000 | [diff] [blame] | 493 | {sqliteCopy(pParse,&X,&Y,0);} |
drh | dce2cbe | 2000-05-31 02:27:49 +0000 | [diff] [blame] | 494 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 495 | ///////////////////////////// The VACUUM command ///////////////////////////// |
| 496 | // |
drh | dce2cbe | 2000-05-31 02:27:49 +0000 | [diff] [blame] | 497 | cmd ::= VACUUM. {sqliteVacuum(pParse,0);} |
drh | c4a3c77 | 2001-04-04 11:48:57 +0000 | [diff] [blame] | 498 | cmd ::= VACUUM ids(X). {sqliteVacuum(pParse,&X);} |
drh | f57b14a | 2001-09-14 18:54:08 +0000 | [diff] [blame] | 499 | |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 500 | ///////////////////////////// The PRAGMA command ///////////////////////////// |
| 501 | // |
drh | f57b14a | 2001-09-14 18:54:08 +0000 | [diff] [blame] | 502 | cmd ::= PRAGMA ids(X) EQ ids(Y). {sqlitePragma(pParse,&X,&Y,0);} |
| 503 | cmd ::= PRAGMA ids(X) EQ ON(Y). {sqlitePragma(pParse,&X,&Y,0);} |
| 504 | cmd ::= PRAGMA ids(X) EQ plus_num(Y). {sqlitePragma(pParse,&X,&Y,0);} |
| 505 | cmd ::= PRAGMA ids(X) EQ minus_num(Y). {sqlitePragma(pParse,&X,&Y,1);} |
drh | 382c024 | 2001-10-06 16:33:02 +0000 | [diff] [blame^] | 506 | cmd ::= PRAGMA ids(X) LP ids(Y) RP. {sqlitePragma(pParse,&X,&Y,0);} |
drh | f57b14a | 2001-09-14 18:54:08 +0000 | [diff] [blame] | 507 | plus_num(A) ::= plus_opt number(X). {A = X;} |
| 508 | minus_num(A) ::= MINUS number(X). {A = X;} |
| 509 | number(A) ::= INTEGER(X). {A = X;} |
| 510 | number(A) ::= FLOAT(X). {A = X;} |
| 511 | plus_opt ::= PLUS. |
| 512 | plus_opt ::= . |