Lines Matching refs:UNIQUE
6495 ** in a UNIQUE index. This is the way PostgreSQL, Oracle, DB2, MySQL,
6500 ** a UNIQUE index. In this mode, you can only have a single NULL entry
6501 ** for a column declared UNIQUE. This is the way Informix and SQL Server
8829 ** a UNIQUE constraint violation are removed so that the new insert or
8936 u8 autoIndex; /* True if is automatically created (ex: by UNIQUE) */
61633 ** has a UNIQUE constraint or UNIQUE index.
64613 /* Check that the new column is not specified as PRIMARY KEY or UNIQUE.
64622 sqlite3ErrorMsg(pParse, "Cannot add a UNIQUE column");
67056 ** PRIMARY KEY or UNIQUE keywords are parsed. Those keywords will cause
68571 ** UNIQUE constraint. If pTable and pIndex are NULL, use pParse->pNewTable
68697 ** dealing with a primary key or UNIQUE constraint. We have to invent our
68866 ** result of a PRIMARY KEY or UNIQUE clause on a column definition, or
68867 ** a PRIMARY KEY or UNIQUE clause following the column definitions.
68871 ** CREATE TABLE t(x, y, UNIQUE(x, y));
68878 ** Two UNIQUE or PRIMARY KEY constraints are considered equivalent
68954 ** or UNIQUE constraint of a CREATE TABLE statement. Since the table
68979 onError==OE_None ? "" : " UNIQUE",
68983 /* An automatic index created by a PRIMARY KEY or UNIQUE constraint */
69109 sqlite3ErrorMsg(pParse, "index associated with UNIQUE "
72678 ** table are collectively subject to a UNIQUE or PRIMARY KEY constraint.
72701 ** UNIQUE or PRIMARY KEY constraint, or
72762 /* pIdx is a UNIQUE index (or a PRIMARY KEY) and has the right number
74821 ** CHECK, and UNIQUE constraints are all checked. If a constraint fails,
74849 ** UNIQUE REPLACE The other row that conflicts with the row
75022 /* Test all UNIQUE constraints by creating entries for each UNIQUE
75051 continue; /* pIdx is not a UNIQUE index */
75339 int destHasUniqueIdx = 0; /* True if pDest has a UNIQUE index */
75475 ** Or if the destination has a UNIQUE index and is not empty,
78221 ** was created to be the PRIMARY KEY or to fulfill a UNIQUE
85423 "SELECT 'CREATE UNIQUE INDEX vacuum_db.' || substr(sql,21) "
85424 " FROM sqlite_master WHERE sql LIKE 'CREATE UNIQUE INDEX %'");
87869 ** ASC or DESC. (Terms of the ORDER BY clause past the end of a UNIQUE
87988 ** and the index is UNIQUE and no terms on the tail of the ORDER BY
91554 "UNIQUE", "CHECK", "REFERENCES", "AUTOINCR",
91665 /* 65 */ "ccons ::= UNIQUE onconf",
91695 /* 95 */ "tcons ::= UNIQUE LP idxlist RP onconf",
91845 /* 245 */ "uniqueflag ::= UNIQUE",
92878 case 65: /* ccons ::= UNIQUE onconf */
92939 case 95: /* tcons ::= UNIQUE LP idxlist RP onconf */
93503 case 245: /* uniqueflag ::= UNIQUE */
94288 testcase( i==46 ); /* UNIQUE */