Home
last modified time | relevance | path

Searched refs:UNIQUE (Results 1 – 25 of 122) sorted by relevance

12345

/external/chromium_org/third_party/sqlite/src/test/
DmallocC.test110 CREATE TABLE t1(a UNIQUE, b UNIQUE, c UNIQUE);
111 CREATE TABLE t2(a UNIQUE, b UNIQUE, c UNIQUE);
112 CREATE TABLE t3(a UNIQUE, b UNIQUE, c UNIQUE);
113 CREATE TABLE t4(a UNIQUE, b UNIQUE, c UNIQUE);
114 CREATE TABLE t5(a UNIQUE, b UNIQUE, c UNIQUE);
115 CREATE TABLE t6(a UNIQUE, b UNIQUE, c UNIQUE);
116 CREATE TABLE t7(a UNIQUE, b UNIQUE, c UNIQUE);
117 CREATE TABLE t8(a UNIQUE, b UNIQUE, c UNIQUE);
Dunique.test12 # focus of this file is testing the CREATE UNIQUE INDEX statement,
13 # and primary keys, and the UNIQUE constraint on table columns
36 b int UNIQUE,
89 CREATE UNIQUE INDEX i2 ON t2(a)
125 CREATE UNIQUE INDEX i2 ON t2(a);
135 # Test the UNIQUE keyword as used on two or more fields.
168 # Make sure NULLs are distinct as far as the UNIQUE tests are
173 CREATE TABLE t4(a UNIQUE, b, c, UNIQUE(b,c));
212 catchsql {CREATE UNIQUE INDEX i4a ON t4(a,b)}
215 catchsql {CREATE UNIQUE INDEX i4b ON t4(a,b,c)}
[all …]
Dtkt3824.test14 # When you use an "IS NULL" constraint on a UNIQUE index, the result
15 # is not necessarily UNIQUE. Make sure the optimizer does not assume
40 CREATE UNIQUE INDEX t1b ON t1(b);
60 CREATE UNIQUE INDEX t2bc ON t2(b,c);
82 CREATE UNIQUE INDEX t3y ON t3(y);
93 CREATE UNIQUE INDEX t4y ON t4(y);
Dpagerfault.test38 CREATE TABLE t1(a UNIQUE, b UNIQUE);
130 CREATE TABLE t1(a UNIQUE, b UNIQUE);
131 CREATE TABLE aux.t2(a UNIQUE, b UNIQUE);
198 CREATE TABLE t1(a UNIQUE, b UNIQUE);
265 CREATE TABLE t1(a UNIQUE, b UNIQUE);
311 # CREATE TABLE t1(x, y, UNIQUE(x, y));
489 CREATE TABLE xx(a, b, UNIQUE(a, b));
517 CREATE TABLE t1(x UNIQUE);
518 CREATE TABLE t2(y UNIQUE);
519 CREATE TABLE t3(z UNIQUE);
[all …]
Dindex.test420 a int UNIQUE,
423 UNIQUE(a,c)
440 } {1 {index associated with UNIQUE or PRIMARY KEY constraint cannot be dropped}}
553 # For example: "CREATE TABLE abc( x PRIMARY KEY, UNIQUE(x) );"
557 CREATE TABLE t7(c UNIQUE PRIMARY KEY);
564 CREATE TABLE t7(c UNIQUE PRIMARY KEY);
571 CREATE TABLE t7(c PRIMARY KEY, UNIQUE(c) );
578 CREATE TABLE t7(c, d , UNIQUE(c, d), PRIMARY KEY(c, d) );
585 CREATE TABLE t7(c, d , UNIQUE(c), PRIMARY KEY(c, d) );
598 CREATE TABLE t7(c, d UNIQUE, UNIQUE(c), PRIMARY KEY(c, d) );
[all …]
Din3.test189 CREATE UNIQUE INDEX t1_i1 ON t1(a); /* no affinity */
190 CREATE UNIQUE INDEX t1_i2 ON t1(b); /* numeric affinity */
191 CREATE UNIQUE INDEX t1_i3 ON t1(c); /* text affinity */
194 CREATE UNIQUE INDEX t2_i1 ON t2(x); /* no affinity */
195 CREATE UNIQUE INDEX t2_i2 ON t2(y); /* numeric affinity */
196 CREATE UNIQUE INDEX t2_i3 ON t2(z); /* text affinity */
242 CREATE UNIQUE INDEX t3_i ON t3(b, a);
263 execsql { CREATE UNIQUE INDEX t3_i2 ON t3(b) }
Dalter4.test76 CREATE TEMP TABLE t2(a, b, UNIQUE(a, b));
81 } {{CREATE TABLE t2(a, b, c REFERENCES t1(c), UNIQUE(a, b))}}
85 CREATE TEMPORARY TABLE t3(a, b, UNIQUE(a, b));
90 } {{CREATE TABLE t3(a, b, c VARCHAR(10, 20), UNIQUE(a, b))}}
113 ALTER TABLE t1 ADD c UNIQUE
115 } {1 {Cannot add a UNIQUE column}}
Dindex3.test20 # Ticket #1115. Make sure that when a UNIQUE index is created on a
35 CREATE UNIQUE INDEX i1 ON t1(a);
Dconflict.test30 CREATE TABLE t1(a, b, c, UNIQUE(a,b));
78 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c, UNIQUE(a,b));
123 CREATE TABLE t1(a, b, c INTEGER, PRIMARY KEY(c), UNIQUE(a,b));
173 # conf1 The conflict resolution algorithm on the UNIQUE constraint
196 CREATE TABLE t1(a,b,c,UNIQUE(a,b) $conf1);
280 # conf1 The conflict resolution algorithm on the UNIQUE constraint
323 CREATE TABLE t1(a,b,c, UNIQUE(a) $conf1);
461 a INTEGER UNIQUE ON CONFLICT IGNORE,
462 b INTEGER UNIQUE ON CONFLICT FAIL,
463 c INTEGER UNIQUE ON CONFLICT REPLACE,
[all …]
Dalter3.test91 CREATE TABLE t2(a, b, UNIQUE(a, b));
95 } {{CREATE TABLE t2(a, b, c REFERENCES t1(c), UNIQUE(a, b))}}
99 CREATE TABLE t3(a, b, UNIQUE(a, b));
103 } {{CREATE TABLE t3(a, b, c VARCHAR(10, 20), UNIQUE(a, b))}}
126 ALTER TABLE t1 ADD c UNIQUE
128 } {1 {Cannot add a UNIQUE column}}
DmallocH.test26 CREATE TABLE t1(x UNIQUE, y);
65 CREATE TABLE t1(a PRIMARY KEY, b UNIQUE);
Dfkey_malloc.test25 CREATE TABLE t1(a PRIMARY KEY, b UNIQUE);
36 CREATE TABLE t1(a, b, UNIQUE(a, b));
79 CREATE TABLE t1(x INTEGER PRIMARY KEY, y UNIQUE);
Dtkt1443.test64 label STR UNIQUE
84 user STRING UNIQUE,
94 userGroup STRING UNIQUE
153 CREATE UNIQUE INDEX PermissionsIdx
DmallocF.test43 CREATE TABLE t1(x PRIMARY KEY,y UNIQUE);
56 CREATE TABLE t1(x PRIMARY KEY,y UNIQUE);
De_createtable.test103 3.1 "CREATE TABLE t1(c1 text UNIQUE)" {}
104 3.2 "CREATE TABLE t1(c1 text CONSTRAINT un UNIQUE)" {}
124 PRIMARY KEY NOT NULL UNIQUE CHECK(c1 IS 'ten') DEFAULT 123 REFERENCES t1
129 REFERENCES t1 DEFAULT 123 CHECK(c1 IS 'ten') UNIQUE NOT NULL PRIMARY KEY
144 2.1 "CREATE TABLE t1(c1, c2, UNIQUE(c1))" {}
145 2.2 "CREATE TABLE t1(c1, c2, UNIQUE(c1, c2))" {}
146 2.3 "CREATE TABLE t1(c1, c2, UNIQUE(c1, c2) ON CONFLICT IGNORE)" {}
161 col3 INTEGER UNIQUE,
229 execsql { CREATE TABLE t3(i, j, UNIQUE(i, j) ) }
648 CREATE TABLE t9(p NOT NULL, q DOUBLE CHECK (q!=0), r STRING UNIQUE);
[all …]
Dtkt-f777251dc7a.test22 CREATE TEMP TABLE t1(x UNIQUE);
51 CREATE TEMP TABLE t1(x UNIQUE);
Dpagesize.test89 execsql {CREATE TABLE t1(x UNIQUE, y UNIQUE, z UNIQUE)}
Dtkt-cbd054fa6b.test26 CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT UNIQUE NOT NULL);
58 CREATE TABLE t1(a INTEGER PRIMARY KEY, b BLOB UNIQUE NOT NULL);
/external/clang/test/PCH/
Dvariables.c26 #define UNIQUE(x) PASTE1(x,__COUNTER__) macro
28 int UNIQUE(a); // a0
29 int UNIQUE(a); // a1
44 int UNIQUE(a); // a2
Dvariables.h22 #define UNIQUE(x) PASTE1(x,__COUNTER__) macro
24 int UNIQUE(a); // a0
25 int UNIQUE(a); // a1
/external/clang/test/Lexer/
Dcounter.c6 #define UNIQUE(x) PASTE1(x,__COUNTER__) macro
9 B: UNIQUE(foo);
10 C: UNIQUE(foo);
/external/jmdns/src/javax/jmdns/impl/tasks/state/
DCanceler.java104 …for (DNSRecord answer : this.getDns().getLocalHost().answers(DNSRecordClass.UNIQUE, this.getTTL())… in buildOutgoingForDNS()
117 …for (DNSRecord answer : info.answers(DNSRecordClass.UNIQUE, this.getTTL(), this.getDns().getLocalH… in buildOutgoingForInfo()
DAnnouncer.java104 …for (DNSRecord answer : this.getDns().getLocalHost().answers(DNSRecordClass.UNIQUE, this.getTTL())… in buildOutgoingForDNS()
117 …for (DNSRecord answer : info.answers(DNSRecordClass.UNIQUE, this.getTTL(), this.getDns().getLocalH… in buildOutgoingForInfo()
DRenewer.java105 …for (DNSRecord answer : this.getDns().getLocalHost().answers(DNSRecordClass.UNIQUE, this.getTTL())… in buildOutgoingForDNS()
118 …for (DNSRecord answer : info.answers(DNSRecordClass.UNIQUE, this.getTTL(), this.getDns().getLocalH… in buildOutgoingForInfo()
/external/jmdns/src/javax/jmdns/impl/
DDNSQuestion.java37 ….getLocalHost().getDNSAddressRecord(this.getRecordType(), DNSRecordClass.UNIQUE, DNSConstants.DNS_… in addAnswers()
61 ….getLocalHost().getDNSAddressRecord(this.getRecordType(), DNSRecordClass.UNIQUE, DNSConstants.DNS_… in addAnswers()
281 … answers.addAll(jmDNSImpl.getLocalHost().answers(DNSRecordClass.UNIQUE, DNSConstants.DNS_TTL)); in addAnswersForServiceInfo()
282 …answers.addAll(info.answers(DNSRecordClass.UNIQUE, DNSConstants.DNS_TTL, jmDNSImpl.getLocalHost())… in addAnswersForServiceInfo()

12345