Lines Matching refs:UNIQUE
7831 ** <li> ^(Column zColumn is part of an index, PRIMARY KEY or UNIQUE
12101 ** violation (e.g. NOT NULL or UNIQUE), the conflict handler function is
12266 ** a UNIQUE, CHECK or NOT NULL constraint), the conflict handler is
17611 #define COLFLAG_UNIQUE 0x0008 /* Column def contains "UNIQUE" or "PK" */
17929 ** a UNIQUE constraint violation are removed so that the new insert or
18102 unsigned idxType:2; /* 0:Normal 1:UNIQUE, 2:PRIMARY KEY, 3:IPK */
18104 unsigned uniqNotNull:1; /* True if UNIQUE and NOT NULL for all columns */
18129 #define SQLITE_IDXTYPE_UNIQUE 1 /* Implements a UNIQUE constraint */
18136 /* Return true if index X is a UNIQUE index */
18799 Index *pUpsertIdx; /* UNIQUE constraint specified by pUpsertTarget */
19201 ** Also used to hold redundant UNIQUE constraints
91461 ** 2: UNIQUE constraint failed: P4
91510 static const char * const azType[] = { "NOT NULL", "UNIQUE", "CHECK",
99825 ** CREATE UNIQUE INDEX statement.
102506 ** turn is used to verify uniqueness when constructing a UNIQUE INDEX.
108514 ** a UNIQUE constraint or index.
112676 /* Check that the new column is not specified as PRIMARY KEY or UNIQUE.
112686 "Cannot add a UNIQUE column");
114484 ** constrained by a UNIQUE constraint. */
114487 (pTab->aCol[iCol].colFlags&COLFLAG_PRIMKEY) ? "PRIMARY KEY" : "UNIQUE",
115778 /* For a single-column UNIQUE index, once we have found a non-NULL
118800 ** PRIMARY KEY or UNIQUE keywords are parsed. Those keywords will cause
119089 /* Set the uniqNotNull flag on any UNIQUE or PK indexes already created
119251 ** indexes and PRIMARY KEY constraints and in UNIQUE constraints. Example:
119253 ** CREATE TABLE xyz(a,b,c,d,e,PRIMARY KEY('a'),UNIQUE('b','c' COLLATE trim)
119803 ** (6) Replace the rowid tail on all automatically generated UNIQUE
119905 /* Update the in-memory representation of all UNIQUE indices by converting
121273 /* Most CREATE INDEX and REINDEX statements that are not UNIQUE can not
121287 ** not work for UNIQUE constraint indexes on WITHOUT ROWID tables
121365 ** UNIQUE constraint. If pTable and pIndex are NULL, use pParse->pNewTable
121504 ** dealing with a primary key or UNIQUE constraint. We have to invent our
121659 "UNIQUE constraints");
121752 ** result of a PRIMARY KEY or UNIQUE clause on a column definition, or
121753 ** a PRIMARY KEY or UNIQUE clause following the column definitions.
121757 ** CREATE TABLE t(x, y, UNIQUE(x, y));
121764 ** Two UNIQUE or PRIMARY KEY constraints are considered equivalent
121846 ** index is an implied index for a UNIQUE or PRIMARY KEY constraint) then
121854 ** or UNIQUE index in a CREATE TABLE statement. Since the table
121886 onError==OE_None ? "" : " UNIQUE", n, pName->z);
121888 /* An automatic index created by a PRIMARY KEY or UNIQUE constraint */
122056 sqlite3ErrorMsg(pParse, "index associated with UNIQUE "
122807 ** Code an OP_Halt due to UNIQUE or PRIMARY KEY constraint violation.
127269 ** table are collectively subject to a UNIQUE or PRIMARY KEY constraint.
127292 ** UNIQUE or PRIMARY KEY constraint, or
127355 /* pIdx is a UNIQUE index (or a PRIMARY KEY) and has the right number
130229 ** CHECK, and UNIQUE constraints are all checked. If a constraint fails,
130258 ** UNIQUE REPLACE The other row that conflicts with the row
130478 /* UNIQUE and PRIMARY KEY constraints should be handled in the following
130643 ** to some other UNIQUE constraint is FAIL or IGNORE, then we need
130645 ** the UNIQUE constraints have run.
130754 /* Test all UNIQUE constraints by creating entries for each UNIQUE
130767 int iThisCur; /* Cursor for this UNIQUE index */
130768 int addrUniqueOk; /* Jump here if the UNIQUE constraint is satisfied */
130841 continue; /* pIdx is not a UNIQUE index */
130919 ** For a UNIQUE index, only conflict if the PRIMARY KEY values
131402 int destHasUniqueIdx = 0; /* True if pDest has a UNIQUE index */
136232 /* For UNIQUE indexes, verify that only one entry exists with the
137310 ** was created to be the PRIMARY KEY or to fulfill a UNIQUE
141991 ** CREATE TABLE t2(x INT UNIQUE);
149397 "PRIMARY KEY or UNIQUE constraint", zWhich);
149439 ** If pIdx is NULL, then the UNIQUE constraint that failed was the IPK.
149449 Index *pIdx, /* The UNIQUE constraint that failed */
151734 #define SQLITE_BLDF1_UNIQUE 0x0002 /* All keys of a UNIQUE index used */
157169 ** 1. The index is itself UNIQUE, and
158970 ** UNIQUE constraint) with one or more == constraints is better
160917 u8 distinctColumns; /* True if the loop has UNIQUE NOT NULL columns */
160951 ** UNIQUE since a UNIQUE column or index can have multiple rows that
160953 ** To be order-distinct, the columns must be UNIQUE and NOT NULL.
160955 ** The rowid for a table is always UNIQUE and NOT NULL so whenever the
161067 ** terms imply that the index is not UNIQUE NOT NULL in which case
167577 0, /* UNIQUE => nothing */
167850 /* 123 */ "UNIQUE",
168093 /* 40 */ "ccons ::= UNIQUE onconf",
168122 /* 69 */ "tcons ::= UNIQUE LP sortlist RP onconf",
168291 /* 238 */ "uniqueflag ::= UNIQUE",
169004 215, /* (40) ccons ::= UNIQUE onconf */
169033 230, /* (69) tcons ::= UNIQUE LP sortlist RP onconf */
169202 281, /* (238) uniqueflag ::= UNIQUE */
169414 -2, /* (40) ccons ::= UNIQUE onconf */
169443 -5, /* (69) tcons ::= UNIQUE LP sortlist RP onconf */
169612 -1, /* (238) uniqueflag ::= UNIQUE */
169991 case 40: /* ccons ::= UNIQUE onconf */
170073 case 69: /* tcons ::= UNIQUE LP sortlist RP onconf */
170871 case 238: /* uniqueflag ::= UNIQUE */
172115 ** 126: UPDATE UNIQUE
172204 testcase( i==63 ); /* UNIQUE */
181338 /* If using a docid=? or rowid=? strategy, set the UNIQUE flag. */
204144 "UNIQUE constraint failed: %s.%s", pRtree->zName, zCol
208238 ** pass unnoticed, or result in SQLITE_CONSTRAINT errors (due to UNIQUE
208350 ** have no PRIMARY KEY or UNIQUE constraints, but each column should have
208355 ** CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT, c UNIQUE);
209804 "SELECT name, rootpage, sql IS NULL OR substr(8, 6)=='UNIQUE' "
210918 ** same schema as the actual target table (less any UNIQUE constraints).
246152 sql = sqlite3_mprintf("SELECT 'CREATE UNIQUE INDEX %s.' || substr(sql,21) FROM sqlite_master WHERE sql LIKE 'CREATE UNIQUE INDEX %%';", dbName);