Lines Matching defs:distinct
8071 ** pointer will work here as long as it is distinct from SQLITE_STATIC
9869 #define SQLITE_DistinctOpt 0x80 /* DISTINCT using indexes */
9875 ** than being distinct from one another.
10408 tRowcnt nDLt; /* Est. number of distinct keys less than this sample */
10462 int iDistinct; /* Ephemeral table used to enforce DISTINCT */
10596 #define EP_Distinct 0x0010 /* Aggregate function with DISTINCT keyword */
10967 #define SF_Distinct 0x01 /* Output should be DISTINCT */
16788 u32 currentCount; /* Current number of distinct checkouts */
35895 ** a hash table that will hold up to BITVEC_MXHASH distinct values.
36727 ** Since there cannot be more than 2^31 distinct pages in a database,
57793 pDestDb, SQLITE_ERROR, "source and destination must be distinct"
68218 ** See also: Found, NotFound, Distinct, SeekLt, SeekGt, SeekLe
68231 ** See also: Found, NotFound, Distinct, SeekLt, SeekGe, SeekLe
68244 ** See also: Found, NotFound, Distinct, SeekGt, SeekGe, SeekLe
68257 ** See also: Found, NotFound, Distinct, SeekGt, SeekGe, SeekLt
75750 return 0; /* No DISTINCT keyword and no aggregate functions */
79358 ** number of distinct left-most entries in the index that are less than
79363 ** integer will be the number of prior index entires that are distinct in
79365 ** entries that are distinct in the first two columns. The third integer
79366 ** will be the number of prior index entries that are distinct in the first
79710 int regNumDLt = iMem++; /* Number of distinct keys less than regSample */
79803 ** Number of distinct entries in index considering the
79911 ** rows of the table the index will select. If D is the count of distinct
83971 ** considered distinct and both result in separate indices.
89326 ** if <table2> and <table1> are distinct tables but have identical
90628 return 0; /* SELECT may not be DISTINCT */
94559 int isDistinct, /* true if the DISTINCT keyword is present */
94980 ** form a distinct entry. iTab is a sorting index that holds previously
94985 ** stack if the top N elements are not distinct.
94990 int addrRepeat, /* Jump to here if not distinct */
95045 int distinct, /* If >=0, make sure results are distinct */
95052 int hasDistinct; /* True if the DISTINCT keyword is present */
95061 hasDistinct = distinct>=0;
95094 /* If the DISTINCT keyword was present on the SELECT statement
95101 codeDistinct(pParse, distinct, iContinue, nColumn, regResult);
95252 ** index to implement a DISTINCT test.
95310 ** where xxx is one of "DISTINCT", "ORDER BY" or "GROUP BY". Exactly which
97131 ** (4) The subquery is not DISTINCT.
97133 ** (**) At one point restrictions (4) and (5) defined a subset of DISTINCT
97135 ** (4) has since been expanded to exclude all DISTINCT subqueries.
97138 ** DISTINCT.
97175 ** * is not an aggregate or DISTINCT query, and
97182 ** operators have an implied DISTINCT which is disallowed by
97199 ** DISTINCT. (See ticket [752e1646fc]).
97311 ** that make up the compound SELECT are allowed to be aggregate or distinct
97559 /* The flattened query is distinct if either the inner or the
97560 ** outer query is distinct.
98065 sqlite3ErrorMsg(pParse, "DISTINCT aggregates must have exactly one "
98270 int isDistinct; /* True if the DISTINCT keyword is present */
98271 int distinct; /* Table to use for the distinct set */
98295 ** DISTINCT so it can be removed too. */
98439 /* If the query is DISTINCT with an ORDER BY but is not an aggregate, and
98443 ** SELECT DISTINCT xyz FROM ... ORDER BY xyz
98450 ** used for both the ORDER BY and DISTINCT processing. As originally
98452 ** BY and DISTINCT, and an index or separate temp-table for the other.
98498 /* Open a virtual index to use for the distinct set.
98502 distinct = pParse->nTab++;
98504 addrDistinctIndex = sqlite3VdbeAddOp4(v, OP_OpenEphemeral, distinct, 0, 0,
98508 distinct = addrDistinctIndex = -1;
98539 distinct = -1;
98574 selectInnerLoop(pParse, p, pEList, 0, 0, pOrderBy, distinct, pDest,
98708 isDistinct && !(p->selFlags&SF_Distinct)?"DISTINCT":"GROUP BY");
98840 distinct, pDest,
98981 if( distinct>=0 ){
98982 explainTempTable(pParse, "DISTINCT");
99027 sqlite3ExplainPrintf(pVdbe, "DISTINCT ");
102798 #define WHERE_DISTINCT 0x40000000 /* Correct order for DISTINCT */
103995 ** DISTINCT qualifier. In other words, it tests whether or not using this
104001 ** SELECT DISTINCT a, b, c FROM tbl WHERE a = ?
104010 ExprList *pDistinct, /* The DISTINCT expressions */
104019 /* Loop through all the expressions in the distinct list. If any of them
104053 ** Return true if the DISTINCT expression-list passed as the third argument
104054 ** is redundant. A DISTINCT list is redundant if the database contains a
104055 ** UNIQUE index that guarantees that the result of the query will be distinct
104070 ** this query, then it will not be possible to show that the DISTINCT
104086 ** the DISTINCT qualifier redundant. It does so if:
104106 /* This index implies that the DISTINCT qualifier is redundant. */
105412 ExprList *pDistinct, /* The select-list if query is DISTINCT */
105548 int nInMul = 1; /* Number of distinct equalities to lookup */
105552 int bDist = !!pDistinct; /* True if index cannot help with DISTINCT */
105635 /* If there is a DISTINCT qualifier and this index will scan rows in
105636 ** order of the DISTINCT expressions, clear bDist and set the appropriate
107152 ExprList *pDistinct, /* The select-list for DISTINCT queries - or NULL */
107213 /* Disable the DISTINCT optimization if SQLITE_DistinctOpt is set via
107284 /* Check if the DISTINCT qualifier, if there is one, is redundant.
107286 ** WHERE_DISTINCT_UNIQUE to tell the caller to ignore the DISTINCT.
107376 ExprList *pDist; /* DISTINCT clause for index to optimize */
108739 "SELECT", "DISTINCT", "DOT", "FROM",
108759 "distinct", "selcollist", "from", "where_opt",
108898 /* 118 */ "oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt",
108899 /* 119 */ "distinct ::= DISTINCT",
108900 /* 120 */ "distinct ::= ALL",
108901 /* 121 */ "distinct ::=",
108976 /* 196 */ "expr ::= ID LP distinct exprlist RP",
109946 case 120: /* distinct ::= ALL */ yytestcase(yyruleno==120);
109947 case 121: /* distinct ::= */ yytestcase(yyruleno==121);
109957 case 119: /* distinct ::= DISTINCT */ yytestcase(yyruleno==119);
110187 case 118: /* oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt */
110489 case 196: /* expr ::= ID LP distinct exprlist RP */
111567 testcase( i==99 ); /* DISTINCT */
125347 /* 27 */ "SELECT DISTINCT level / (1024 * ?) FROM %Q.'%q_segdir'",
