Lines Matching refs:X
91 create_table ::= CREATE(X) temp(T) TABLE nm(Y). { in CREATE() argument
92 sqliteStartTable(pParse,&X,&Y,T,0); in CREATE()
97 create_table_args ::= LP columnlist conslist_opt RP(X). { in RP() argument
98 sqliteEndTable(pParse,&X,0); in RP()
112 columnid ::= nm(X). {sqliteAddColumn(pParse,&X);} in nm() argument
118 id(A) ::= ID(X). {A = X;} in id()
150 ids(A) ::= ID(X). {A = X;} in ids()
151 ids(A) ::= STRING(X). {A = X;} in ids()
156 nm(A) ::= ID(X). {A = X;} in nm()
157 nm(A) ::= STRING(X). {A = X;} in nm()
158 nm(A) ::= JOIN_KW(X). {A = X;} in nm()
161 type ::= typename(X). {sqliteAddColumnType(pParse,&X,&X);} in typename() argument
162 type ::= typename(X) LP signed RP(Y). {sqliteAddColumnType(pParse,&X,&Y);} in typename() argument
163 type ::= typename(X) LP signed COMMA signed RP(Y). in typename() argument
164 {sqliteAddColumnType(pParse,&X,&Y);} in typename()
166 typename(A) ::= ids(X). {A = X;} in typename()
167 typename(A) ::= typename(X) ids. {A = X;} in typename()
169 signed(A) ::= INTEGER(X). { A = atoi(X.z); } in INTEGER() argument
170 signed(A) ::= PLUS INTEGER(X). { A = atoi(X.z); } in INTEGER() argument
171 signed(A) ::= MINUS INTEGER(X). { A = -atoi(X.z); } in INTEGER() argument
176 carg ::= DEFAULT STRING(X). {sqliteAddDefaultValue(pParse,&X,0);} in STRING() argument
177 carg ::= DEFAULT ID(X). {sqliteAddDefaultValue(pParse,&X,0);} in ID() argument
178 carg ::= DEFAULT INTEGER(X). {sqliteAddDefaultValue(pParse,&X,0);} in INTEGER() argument
179 carg ::= DEFAULT PLUS INTEGER(X). {sqliteAddDefaultValue(pParse,&X,0);} in INTEGER() argument
180 carg ::= DEFAULT MINUS INTEGER(X). {sqliteAddDefaultValue(pParse,&X,1);} in INTEGER() argument
181 carg ::= DEFAULT FLOAT(X). {sqliteAddDefaultValue(pParse,&X,0);} in FLOAT() argument
182 carg ::= DEFAULT PLUS FLOAT(X). {sqliteAddDefaultValue(pParse,&X,0);} in FLOAT() argument
183 carg ::= DEFAULT MINUS FLOAT(X). {sqliteAddDefaultValue(pParse,&X,1);} in FLOAT() argument
208 refargs(A) ::= refargs(X) refarg(Y). { A = (X & Y.mask) | Y.value; } in refargs()
211 refarg(A) ::= ON DELETE refact(X). { A.value = X; A.mask = 0x0000ff; }
212 refarg(A) ::= ON UPDATE refact(X). { A.value = X<<8; A.mask = 0x00ff00; }
213 refarg(A) ::= ON INSERT refact(X). { A.value = X<<16; A.mask = 0xff0000; }
220 defer_subclause(A) ::= NOT DEFERRABLE init_deferred_pred_opt(X). {A = X;}
221 defer_subclause(A) ::= DEFERRABLE init_deferred_pred_opt(X). {A = X;}
236 tcons ::= PRIMARY KEY LP idxlist(X) RP onconf(R).
237 {sqliteAddPrimaryKey(pParse,X,R);}
238 tcons ::= UNIQUE LP idxlist(X) RP onconf(R).
239 {sqliteCreateIndex(pParse,0,0,X,R,0,0);}
248 defer_subclause_opt(A) ::= defer_subclause(X). {A = X;}
257 onconf(A) ::= ON CONFLICT resolvetype(X). { A = X; }
259 orconf(A) ::= OR resolvetype(X). { A = X; }
268 cmd ::= DROP TABLE nm(X). {sqliteDropTable(pParse,&X,0);}
272 cmd ::= CREATE(X) temp(T) VIEW nm(Y) AS select(S). {
273 sqliteCreateView(pParse, &X, &Y, S, T);
275 cmd ::= DROP VIEW nm(X). {
276 sqliteDropTable(pParse, &X, 1);
281 cmd ::= select(X). {
282 sqliteSelect(pParse, X, SRT_Callback, 0, 0, 0, 0);
283 sqliteSelectDelete(X);
291 select(A) ::= oneselect(X). {A = X;}
292 select(A) ::= select(X) multiselect_op(Y) oneselect(Z). {
295 Z->pPrior = X;
304 oneselect(A) ::= SELECT distinct(D) selcollist(W) from(X) where_opt(Y)
306 A = sqliteSelectNew(W,X,Y,P,Q,Z,D,L.limit,L.offset);
326 sclp(A) ::= selcollist(X) COMMA. {A = X;}
328 selcollist(A) ::= sclp(P) expr(X) as(Y). {
329 A = sqliteExprListAppend(P,X,Y.n?&Y:0);
334 selcollist(A) ::= sclp(P) nm(X) DOT STAR. {
336 Expr *pLeft = sqliteExpr(TK_ID, 0, 0, &X);
344 as(X) ::= AS nm(Y). { X = Y; }
345 as(X) ::= ids(Y). { X = Y; }
346 as(X) ::= . { X.n = 0; }
359 from(A) ::= FROM seltablist(X). {A = X;}
364 stl_prefix(A) ::= seltablist(X) joinop(Y). {
365 A = X;
369 seltablist(A) ::= stl_prefix(X) nm(Y) dbnm(D) as(Z) on_opt(N) using_opt(U). {
370 A = sqliteSrcListAppend(X,&Y,&D);
381 seltablist(A) ::= stl_prefix(X) LP seltablist_paren(S) RP
383 A = sqliteSrcListAppend(X,0,0);
409 dbnm(A) ::= DOT nm(X). {A = X;}
413 joinop(X) ::= COMMA. { X = JT_INNER; }
414 joinop(X) ::= JOIN. { X = JT_INNER; }
415 joinop(X) ::= JOIN_KW(A) JOIN. { X = sqliteJoinType(pParse,&A,0,0); }
416 joinop(X) ::= JOIN_KW(A) nm(B) JOIN. { X = sqliteJoinType(pParse,&A,&B,0); }
417 joinop(X) ::= JOIN_KW(A) nm(B) nm(C) JOIN.
418 { X = sqliteJoinType(pParse,&A,&B,&C); }
439 orderby_opt(A) ::= ORDER BY sortlist(X). {A = X;}
440 sortlist(A) ::= sortlist(X) COMMA sortitem(Y) collate(C) sortorder(Z). {
441 A = sqliteExprListAppend(X,Y,0);
448 sortitem(A) ::= expr(X). {A = X;}
457 collate(C) ::= COLLATE id(X). {C = sqliteCollateType(X.z, X.n);}
462 groupby_opt(A) ::= GROUP BY exprlist(X). {A = X;}
467 having_opt(A) ::= HAVING expr(X). {A = X;}
471 limit_opt(A) ::= LIMIT signed(X). {A.limit = X; A.offset = 0;}
472 limit_opt(A) ::= LIMIT signed(X) OFFSET signed(Y).
473 {A.limit = X; A.offset = Y;}
474 limit_opt(A) ::= LIMIT signed(X) COMMA signed(Y).
475 {A.limit = Y; A.offset = X;}
479 cmd ::= DELETE FROM nm(X) dbnm(D) where_opt(Y). {
480 sqliteDeleteFrom(pParse, sqliteSrcListAppend(0,&X,&D), Y);
487 where_opt(A) ::= WHERE expr(X). {A = X;}
494 cmd ::= UPDATE orconf(R) nm(X) dbnm(D) SET setlist(Y) where_opt(Z).
495 {sqliteUpdate(pParse,sqliteSrcListAppend(0,&X,&D),Y,Z,R);}
497 setlist(A) ::= setlist(Z) COMMA nm(X) EQ expr(Y).
498 {A = sqliteExprListAppend(Z,Y,&X);}
499 setlist(A) ::= nm(X) EQ expr(Y). {A = sqliteExprListAppend(0,Y,&X);}
503 cmd ::= insert_cmd(R) INTO nm(X) dbnm(D) inscollist_opt(F)
505 {sqliteInsert(pParse, sqliteSrcListAppend(0,&X,&D), Y, 0, F, R);}
506 cmd ::= insert_cmd(R) INTO nm(X) dbnm(D) inscollist_opt(F) select(S).
507 {sqliteInsert(pParse, sqliteSrcListAppend(0,&X,&D), 0, S, F, R);}
517 itemlist(A) ::= itemlist(X) COMMA expr(Y). {A = sqliteExprListAppend(X,Y,0);}
518 itemlist(A) ::= expr(X). {A = sqliteExprListAppend(0,X,0);}
526 inscollist_opt(A) ::= LP inscollist(X) RP. {A = X;}
527 inscollist(A) ::= inscollist(X) COMMA nm(Y). {A = sqliteIdListAppend(X,&Y);}
536 expr(A) ::= LP(B) expr(X) RP(E). {A = X; sqliteExprSpan(A,&B,&E); }
537 expr(A) ::= NULL(X). {A = sqliteExpr(TK_NULL, 0, 0, &X);}
538 expr(A) ::= ID(X). {A = sqliteExpr(TK_ID, 0, 0, &X);}
539 expr(A) ::= JOIN_KW(X). {A = sqliteExpr(TK_ID, 0, 0, &X);}
540 expr(A) ::= nm(X) DOT nm(Y). {
541 Expr *temp1 = sqliteExpr(TK_ID, 0, 0, &X);
545 expr(A) ::= nm(X) DOT nm(Y) DOT nm(Z). {
546 Expr *temp1 = sqliteExpr(TK_ID, 0, 0, &X);
552 expr(A) ::= INTEGER(X). {A = sqliteExpr(TK_INTEGER, 0, 0, &X);}
553 expr(A) ::= FLOAT(X). {A = sqliteExpr(TK_FLOAT, 0, 0, &X);}
554 expr(A) ::= STRING(X). {A = sqliteExpr(TK_STRING, 0, 0, &X);}
555 expr(A) ::= VARIABLE(X). {
556 A = sqliteExpr(TK_VARIABLE, 0, 0, &X);
559 expr(A) ::= ID(X) LP exprlist(Y) RP(E). {
560 A = sqliteExprFunction(Y, &X);
561 sqliteExprSpan(A,&X,&E);
563 expr(A) ::= ID(X) LP STAR RP(E). {
564 A = sqliteExprFunction(0, &X);
565 sqliteExprSpan(A,&X,&E);
567 expr(A) ::= expr(X) AND expr(Y). {A = sqliteExpr(TK_AND, X, Y, 0);}
568 expr(A) ::= expr(X) OR expr(Y). {A = sqliteExpr(TK_OR, X, Y, 0);}
569 expr(A) ::= expr(X) LT expr(Y). {A = sqliteExpr(TK_LT, X, Y, 0);}
570 expr(A) ::= expr(X) GT expr(Y). {A = sqliteExpr(TK_GT, X, Y, 0);}
571 expr(A) ::= expr(X) LE expr(Y). {A = sqliteExpr(TK_LE, X, Y, 0);}
572 expr(A) ::= expr(X) GE expr(Y). {A = sqliteExpr(TK_GE, X, Y, 0);}
573 expr(A) ::= expr(X) NE expr(Y). {A = sqliteExpr(TK_NE, X, Y, 0);}
574 expr(A) ::= expr(X) EQ expr(Y). {A = sqliteExpr(TK_EQ, X, Y, 0);}
575 expr(A) ::= expr(X) BITAND expr(Y). {A = sqliteExpr(TK_BITAND, X, Y, 0);}
576 expr(A) ::= expr(X) BITOR expr(Y). {A = sqliteExpr(TK_BITOR, X, Y, 0);}
577 expr(A) ::= expr(X) LSHIFT expr(Y). {A = sqliteExpr(TK_LSHIFT, X, Y, 0);}
578 expr(A) ::= expr(X) RSHIFT expr(Y). {A = sqliteExpr(TK_RSHIFT, X, Y, 0);}
579 expr(A) ::= expr(X) likeop(OP) expr(Y). [LIKE] {
581 pList = sqliteExprListAppend(pList, X, 0);
584 sqliteExprSpan(A, &X->span, &Y->span);
586 expr(A) ::= expr(X) NOT likeop(OP) expr(Y). [LIKE] {
588 pList = sqliteExprListAppend(pList, X, 0);
592 sqliteExprSpan(A,&X->span,&Y->span);
597 expr(A) ::= expr(X) PLUS expr(Y). {A = sqliteExpr(TK_PLUS, X, Y, 0);}
598 expr(A) ::= expr(X) MINUS expr(Y). {A = sqliteExpr(TK_MINUS, X, Y, 0);}
599 expr(A) ::= expr(X) STAR expr(Y). {A = sqliteExpr(TK_STAR, X, Y, 0);}
600 expr(A) ::= expr(X) SLASH expr(Y). {A = sqliteExpr(TK_SLASH, X, Y, 0);}
601 expr(A) ::= expr(X) REM expr(Y). {A = sqliteExpr(TK_REM, X, Y, 0);}
602 expr(A) ::= expr(X) CONCAT expr(Y). {A = sqliteExpr(TK_CONCAT, X, Y, 0);}
603 expr(A) ::= expr(X) ISNULL(E). {
604 A = sqliteExpr(TK_ISNULL, X, 0, 0);
605 sqliteExprSpan(A,&X->span,&E);
607 expr(A) ::= expr(X) IS NULL(E). {
608 A = sqliteExpr(TK_ISNULL, X, 0, 0);
609 sqliteExprSpan(A,&X->span,&E);
611 expr(A) ::= expr(X) NOTNULL(E). {
612 A = sqliteExpr(TK_NOTNULL, X, 0, 0);
613 sqliteExprSpan(A,&X->span,&E);
615 expr(A) ::= expr(X) NOT NULL(E). {
616 A = sqliteExpr(TK_NOTNULL, X, 0, 0);
617 sqliteExprSpan(A,&X->span,&E);
619 expr(A) ::= expr(X) IS NOT NULL(E). {
620 A = sqliteExpr(TK_NOTNULL, X, 0, 0);
621 sqliteExprSpan(A,&X->span,&E);
623 expr(A) ::= NOT(B) expr(X). {
624 A = sqliteExpr(TK_NOT, X, 0, 0);
625 sqliteExprSpan(A,&B,&X->span);
627 expr(A) ::= BITNOT(B) expr(X). {
628 A = sqliteExpr(TK_BITNOT, X, 0, 0);
629 sqliteExprSpan(A,&B,&X->span);
631 expr(A) ::= MINUS(B) expr(X). [UMINUS] {
632 A = sqliteExpr(TK_UMINUS, X, 0, 0);
633 sqliteExprSpan(A,&B,&X->span);
635 expr(A) ::= PLUS(B) expr(X). [UPLUS] {
636 A = sqliteExpr(TK_UPLUS, X, 0, 0);
637 sqliteExprSpan(A,&B,&X->span);
639 expr(A) ::= LP(B) select(X) RP(E). {
641 if( A ) A->pSelect = X;
644 expr(A) ::= expr(W) BETWEEN expr(X) AND expr(Y). {
645 ExprList *pList = sqliteExprListAppend(0, X, 0);
651 expr(A) ::= expr(W) NOT BETWEEN expr(X) AND expr(Y). {
652 ExprList *pList = sqliteExprListAppend(0, X, 0);
659 expr(A) ::= expr(X) IN LP exprlist(Y) RP(E). {
660 A = sqliteExpr(TK_IN, X, 0, 0);
662 sqliteExprSpan(A,&X->span,&E);
664 expr(A) ::= expr(X) IN LP select(Y) RP(E). {
665 A = sqliteExpr(TK_IN, X, 0, 0);
667 sqliteExprSpan(A,&X->span,&E);
669 expr(A) ::= expr(X) NOT IN LP exprlist(Y) RP(E). {
670 A = sqliteExpr(TK_IN, X, 0, 0);
673 sqliteExprSpan(A,&X->span,&E);
675 expr(A) ::= expr(X) NOT IN LP select(Y) RP(E). {
676 A = sqliteExpr(TK_IN, X, 0, 0);
679 sqliteExprSpan(A,&X->span,&E);
681 expr(A) ::= expr(X) IN nm(Y) dbnm(D). {
683 A = sqliteExpr(TK_IN, X, 0, 0);
685 sqliteExprSpan(A,&X->span,D.z?&D:&Y);
687 expr(A) ::= expr(X) NOT IN nm(Y) dbnm(D). {
689 A = sqliteExpr(TK_IN, X, 0, 0);
692 sqliteExprSpan(A,&X->span,D.z?&D:&Y);
697 expr(A) ::= CASE(C) case_operand(X) case_exprlist(Y) case_else(Z) END(E). {
698 A = sqliteExpr(TK_CASE, X, Z, 0);
704 case_exprlist(A) ::= case_exprlist(X) WHEN expr(Y) THEN expr(Z). {
705 A = sqliteExprListAppend(X, Y, 0);
713 case_else(A) ::= ELSE expr(X). {A = X;}
716 case_operand(A) ::= expr(X). {A = X;}
724 exprlist(A) ::= exprlist(X) COMMA expritem(Y).
725 {A = sqliteExprListAppend(X,Y,0);}
726 exprlist(A) ::= expritem(X). {A = sqliteExprListAppend(0,X,0);}
727 expritem(A) ::= expr(X). {A = X;}
732 cmd ::= CREATE(S) uniqueflag(U) INDEX nm(X)
737 sqliteCreateIndex(pParse, &X, pSrc, Z, U, &S, &E);
751 idxlist_opt(A) ::= LP idxlist(X) RP. {A = X;}
752 idxlist(A) ::= idxlist(X) COMMA idxitem(Y). {A = sqliteIdListAppend(X,&Y);}
754 idxitem(A) ::= nm(X) sortorder. {A = X;}
759 cmd ::= DROP INDEX nm(X) dbnm(Y). {
760 sqliteDropIndex(pParse, sqliteSrcListAppend(0,&X,&Y));
766 cmd ::= COPY orconf(R) nm(X) dbnm(D) FROM nm(Y) USING DELIMITERS STRING(Z).
767 {sqliteCopy(pParse,sqliteSrcListAppend(0,&X,&D),&Y,&Z,R);}
768 cmd ::= COPY orconf(R) nm(X) dbnm(D) FROM nm(Y).
769 {sqliteCopy(pParse,sqliteSrcListAppend(0,&X,&D),&Y,0,R);}
774 cmd ::= VACUUM nm(X). {sqliteVacuum(pParse,&X);}
778 cmd ::= PRAGMA ids(X) EQ nm(Y). {sqlitePragma(pParse,&X,&Y,0);}
779 cmd ::= PRAGMA ids(X) EQ ON(Y). {sqlitePragma(pParse,&X,&Y,0);}
780 cmd ::= PRAGMA ids(X) EQ plus_num(Y). {sqlitePragma(pParse,&X,&Y,0);}
781 cmd ::= PRAGMA ids(X) EQ minus_num(Y). {sqlitePragma(pParse,&X,&Y,1);}
782 cmd ::= PRAGMA ids(X) LP nm(Y) RP. {sqlitePragma(pParse,&X,&Y,0);}
783 cmd ::= PRAGMA ids(X). {sqlitePragma(pParse,&X,&X,0);}
784 plus_num(A) ::= plus_opt number(X). {A = X;}
785 minus_num(A) ::= MINUS number(X). {A = X;}
786 number(A) ::= INTEGER(X). {A = X;}
787 number(A) ::= FLOAT(X). {A = X;}
817 trigger_event(A) ::= UPDATE OF inscollist(X). {A.a = TK_UPDATE; A.b = X; }
826 when_clause(A) ::= WHEN expr(X). { A = X; }
830 trigger_cmd_list(A) ::= trigger_cmd(X) SEMI trigger_cmd_list(Y). {
831 X->pNext = Y;
832 A = X;
839 trigger_cmd(A) ::= UPDATE orconf(R) nm(X) SET setlist(Y) where_opt(Z).
840 { A = sqliteTriggerUpdateStep(&X, Y, Z, R); }
843 trigger_cmd(A) ::= insert_cmd(R) INTO nm(X) inscollist_opt(F)
845 {A = sqliteTriggerInsertStep(&X, F, Y, 0, R);}
847 trigger_cmd(A) ::= insert_cmd(R) INTO nm(X) inscollist_opt(F) select(S).
848 {A = sqliteTriggerInsertStep(&X, F, 0, S, R);}
851 trigger_cmd(A) ::= DELETE FROM nm(X) where_opt(Y).
852 {A = sqliteTriggerDeleteStep(&X, Y);}
855 trigger_cmd(A) ::= select(X). {A = sqliteTriggerSelectStep(X); }
858 expr(A) ::= RAISE(X) LP IGNORE RP(Y). {
861 sqliteExprSpan(A, &X, &Y);
863 expr(A) ::= RAISE(X) LP ROLLBACK COMMA nm(Z) RP(Y). {
866 sqliteExprSpan(A, &X, &Y);
868 expr(A) ::= RAISE(X) LP ABORT COMMA nm(Z) RP(Y). {
871 sqliteExprSpan(A, &X, &Y);
873 expr(A) ::= RAISE(X) LP FAIL COMMA nm(Z) RP(Y). {
876 sqliteExprSpan(A, &X, &Y);
880 cmd ::= DROP TRIGGER nm(X) dbnm(D). {
881 sqliteDropTrigger(pParse,sqliteSrcListAppend(0,&X,&D));
889 key_opt(A) ::= USING ids(X). { A = X; }