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 */
35906 ** a hash table that will hold up to BITVEC_MXHASH distinct values.
36738 ** Since there cannot be more than 2^31 distinct pages in a database,
57804 pDestDb, SQLITE_ERROR, "source and destination must be distinct"
68229 ** See also: Found, NotFound, Distinct, SeekLt, SeekGt, SeekLe
68242 ** See also: Found, NotFound, Distinct, SeekLt, SeekGe, SeekLe
68255 ** See also: Found, NotFound, Distinct, SeekGt, SeekGe, SeekLe
68268 ** See also: Found, NotFound, Distinct, SeekGt, SeekGe, SeekLt
75761 return 0; /* No DISTINCT keyword and no aggregate functions */
79369 ** number of distinct left-most entries in the index that are less than
79374 ** integer will be the number of prior index entires that are distinct in
79376 ** entries that are distinct in the first two columns. The third integer
79377 ** will be the number of prior index entries that are distinct in the first
79721 int regNumDLt = iMem++; /* Number of distinct keys less than regSample */
79814 ** Number of distinct entries in index considering the
79922 ** rows of the table the index will select. If D is the count of distinct
83982 ** considered distinct and both result in separate indices.
89337 ** if <table2> and <table1> are distinct tables but have identical
90639 return 0; /* SELECT may not be DISTINCT */
94570 int isDistinct, /* true if the DISTINCT keyword is present */
94991 ** form a distinct entry. iTab is a sorting index that holds previously
94996 ** stack if the top N elements are not distinct.
95001 int addrRepeat, /* Jump to here if not distinct */
95056 int distinct, /* If >=0, make sure results are distinct */
95063 int hasDistinct; /* True if the DISTINCT keyword is present */
95072 hasDistinct = distinct>=0;
95105 /* If the DISTINCT keyword was present on the SELECT statement
95112 codeDistinct(pParse, distinct, iContinue, nColumn, regResult);
95263 ** index to implement a DISTINCT test.
95321 ** where xxx is one of "DISTINCT", "ORDER BY" or "GROUP BY". Exactly which
97142 ** (4) The subquery is not DISTINCT.
97144 ** (**) At one point restrictions (4) and (5) defined a subset of DISTINCT
97146 ** (4) has since been expanded to exclude all DISTINCT subqueries.
97149 ** DISTINCT.
97186 ** * is not an aggregate or DISTINCT query, and
97193 ** operators have an implied DISTINCT which is disallowed by
97210 ** DISTINCT. (See ticket [752e1646fc]).
97322 ** that make up the compound SELECT are allowed to be aggregate or distinct
97570 /* The flattened query is distinct if either the inner or the
97571 ** outer query is distinct.
98076 sqlite3ErrorMsg(pParse, "DISTINCT aggregates must have exactly one "
98281 int isDistinct; /* True if the DISTINCT keyword is present */
98282 int distinct; /* Table to use for the distinct set */
98306 ** DISTINCT so it can be removed too. */
98450 /* If the query is DISTINCT with an ORDER BY but is not an aggregate, and
98454 ** SELECT DISTINCT xyz FROM ... ORDER BY xyz
98461 ** used for both the ORDER BY and DISTINCT processing. As originally
98463 ** BY and DISTINCT, and an index or separate temp-table for the other.
98509 /* Open a virtual index to use for the distinct set.
98513 distinct = pParse->nTab++;
98515 addrDistinctIndex = sqlite3VdbeAddOp4(v, OP_OpenEphemeral, distinct, 0, 0,
98519 distinct = addrDistinctIndex = -1;
98550 distinct = -1;
98585 selectInnerLoop(pParse, p, pEList, 0, 0, pOrderBy, distinct, pDest,
98719 isDistinct && !(p->selFlags&SF_Distinct)?"DISTINCT":"GROUP BY");
98851 distinct, pDest,
98992 if( distinct>=0 ){
98993 explainTempTable(pParse, "DISTINCT");
99038 sqlite3ExplainPrintf(pVdbe, "DISTINCT ");
102809 #define WHERE_DISTINCT 0x40000000 /* Correct order for DISTINCT */
104006 ** DISTINCT qualifier. In other words, it tests whether or not using this
104012 ** SELECT DISTINCT a, b, c FROM tbl WHERE a = ?
104021 ExprList *pDistinct, /* The DISTINCT expressions */
104030 /* Loop through all the expressions in the distinct list. If any of them
104064 ** Return true if the DISTINCT expression-list passed as the third argument
104065 ** is redundant. A DISTINCT list is redundant if the database contains a
104066 ** UNIQUE index that guarantees that the result of the query will be distinct
104081 ** this query, then it will not be possible to show that the DISTINCT
104097 DISTINCT qualifier redundant. It does so if:
104117 /* This index implies that the DISTINCT qualifier is redundant. */
105423 ExprList *pDistinct, /* The select-list if query is DISTINCT */
105559 int nInMul = 1; /* Number of distinct equalities to lookup */
105563 int bDist = !!pDistinct; /* True if index cannot help with DISTINCT */
105646 /* If there is a DISTINCT qualifier and this index will scan rows in
105647 ** order of the DISTINCT expressions, clear bDist and set the appropriate
107163 ExprList *pDistinct, /* The select-list for DISTINCT queries - or NULL */
107224 /* Disable the DISTINCT optimization if SQLITE_DistinctOpt is set via
107295 /* Check if the DISTINCT qualifier, if there is one, is redundant.
107297 ** WHERE_DISTINCT_UNIQUE to tell the caller to ignore the DISTINCT.
107387 ExprList *pDist; /* DISTINCT clause for index to optimize */
108750 "SELECT", "DISTINCT", "DOT", "FROM",
108770 "distinct", "selcollist", "from", "where_opt",
108909 /* 118 */ "oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt",
108910 /* 119 */ "distinct ::= DISTINCT",
108911 /* 120 */ "distinct ::= ALL",
108912 /* 121 */ "distinct ::=",
108987 /* 196 */ "expr ::= ID LP distinct exprlist RP",
109957 case 120: /* distinct ::= ALL */ yytestcase(yyruleno==120);
109958 case 121: /* distinct ::= */ yytestcase(yyruleno==121);
109968 case 119: /* distinct ::= DISTINCT */ yytestcase(yyruleno==119);
110198 case 118: /* oneselect ::= SELECT distinct selcollist from where_opt groupby_opt having_opt orderby_opt limit_opt */
110500 case 196: /* expr ::= ID LP distinct exprlist RP */
111578 testcase( i==99 ); /* DISTINCT */
125376 /* 27 */ "SELECT DISTINCT level / (1024 * ?) FROM %Q.'%q_segdir'",
