Home
last modified time | relevance | path

Searched refs:key (Results 1 – 25 of 152) sorted by relevance

1234567

/sqlite-3.40.0/test/
H A De_fkey.test585 # affinity of the parent key column is applied to the child key value
623 # EVIDENCE-OF: R-13435-26311 Usually, the parent key of a foreign key
755 # the primary key of the parent without specifying the primary key
903 # key constraint that maps the column to the primary key of
1489 # key constraint.
1883 } {{key two}}
2101 # update operation on the parent key to each dependent child key.
2146 # update operation on the parent key to each dependent child key.
2439 } {key}
2528 # foreign key constraints, the definitions of the foreign key
[all …]
H A Dorderby5.test144 CREATE TABLE Records(typeID INTEGER, key TEXT COLLATE nocase, value TEXT);
145 CREATE INDEX RecordsIndex ON Records(typeID, key, value);
149 SELECT typeID, key, value FROM Records
150 WHERE typeID = 2 AND key = 'x'
151 ORDER BY key, value;
155 SELECT typeID, key, value FROM Records
156 WHERE typeID = 2 AND (key = 'x' COLLATE binary)
157 ORDER BY key, value;
161 SELECT typeID, key, value FROM Records
163 ORDER BY key, value;
H A Dtkt1449.test35 …text(50) not null, PERMISSIONBITS int not null, constraint PK_ACLS primary key (ISSUEID, OBJECTID,…
42 …xt(25) null, CONTENTID text(100) not null, constraint PK_DETACHEDATTACHMENTS primary key (TQUNID));
44 …SNODEIDSEQNOKEY text(100) null, DEPENDSACLVERSION int null, constraint PK_DQ primary key (TQUNID));
47 …(300) not null, DELETEFOLDERWHENEMPTY text(1) null, constraint PK_FILEMORGUE primary key (TQUNID));
51 …(ID int not null, VALUE text(300) not null, constraint PK_GLOBALSTRINGPROPERTIES primary key (ID));
52 …ENVELOPESTREAM blob not null, PAYLOADSTREAM blob not null, constraint PK_IMQ primary key (TQUNID));
53 …null, DATECREATED text(25) not null, constraint PK_INVITATIONNODES primary key (INVITATIONID, RECI…
57 …SAGEBLOB blob not null, RECEIVEDDATE text(25) not null, constraint PK_KMTPMSG primary key (MSGID));
59 … not null, ENVELOPE text null, MESSAGEBLOB blob not null, constraint PK_KMTPQ primary key (MSGID));
62 … null, SYNCSEQNO int not null, LASTMSGDATE text(25) null, constraint PK_LSBN primary key (TQUNID));
[all …]
H A Dintpkey.test21 # Create a table with a primary key and a datatype other than
30 # There should be an index associated with the primary key
39 # Now create a table with an integer primary key and verify that
51 # Insert some records into the new table. Specify the primary key
52 # and verify that the key is used as the record number.
101 # the integer primary key.
119 # Make sure SELECT statements are able to use the primary key column
134 # Try to insert a non-integer value into the primary key field. This
387 # table that contains an integer primary key.
456 # Check insert of NULL for primary key
[all …]
H A Dtkt3841.test28 CREATE TABLE table2 (key TEXT, x TEXT);
29 CREATE TABLE list (key TEXT, value TEXT);
44 WHERE list.key = table2.key)
H A Dmisc4.test103 CREATE TABLE Table1(ID integer primary key, Value TEXT);
142 create table a(key varchar, data varchar);
143 create table b(key varchar, period integer);
153 from a, (select key,sum(period) from b group by key) as x
154 where a.key=x.key order by 1 desc;
H A Djson101.test269 # fullkey is always the same as path+key (with appropriate formatting)
272 SELECT j2.rowid, jx.rowid, fullkey, path, key
274 WHERE fullkey!=(path || CASE WHEN typeof(key)=='integer' THEN '['||key||']'
275 ELSE '.'||key END);
278 SELECT j2.rowid, jx.rowid, fullkey, path, key
280 WHERE fullkey!=(path || CASE WHEN typeof(key)=='integer' THEN '['||key||']'
281 ELSE '.'||key END);
289 SELECT j2.rowid, jx.rowid, fullkey, path, key
294 SELECT j2.rowid, jx.rowid, fullkey, path, key
299 SELECT j2.rowid, jx.rowid, fullkey, path, key
[all …]
H A Dfts3rnd.test151 foreach key [lsort -integer [array names ::t1]] {
152 set value $::t1($key)
155 if {[regexp $reg " $col "]} { lappend ret $key ; break }
177 foreach key [array names ::t1] {
178 set value $::t1($key)
179 set a($key) [list]
182 lappend a($key) $hit
205 foreach {key value} [array get ::t1] {
224 #puts "MATCH($key): $v"
225 lappend ret $key
H A Dfkey2.test34 # immediate foreign key constraint is violated.
236 # Use a collation sequence on the parent key.
248 # Use the parent key collation even if it is default and the child key
270 # deferred foreign key constraint logic works.
509 INSERT INTO t2 VALUES('key', 'hello');
515 } {1 {cannot open foreign key column for writing}}
708 } {/1 {foreign key mismatch - "c" referencing "."}/}
736 } {1 {foreign key mismatch - "t2" referencing "t1"}}
1261 } {1 {foreign key mismatch - "cc" referencing "pp"}}
1577 # foreign key constraints. But not the child key of immediate constraints.
[all …]
H A Dtable.test152 f3 varchar(30) primary key,
329 key int,
348 } {desc a asc b key 9 14_vac 0 fuzzy_dog_12 xyz begin hi end y'all}
365 } {desc a asc b key 9 14_vac 0 fuzzy_dog_12 xyz begin hi end y'all}
373 "key" INT,
422 } {desc a asc b key 9 14_vac 0 fuzzy_dog_12 xyz begin hi end y'all}
478 # Check the foreign key syntax.
563 } {1 {unknown column "x" in foreign key definition}}
571 } {1 {unknown column "x" in foreign key definition}}
580 a integer primary key,
[all …]
H A De_createtable.test187 # 1: Explicit parent-key columns.
188 # 2: Implicit child-key columns.
1119 # key is Ok, and two or more primary keys is an error.
1129 table "t5" has more than one primary key
1188 # primary key values, that is a constraint violation.
1749 # primary key.
1774 CREATE TABLE t6(pk INT primary key);
1775 CREATE TABLE t7(pk BIGINT primary key);
1776 CREATE TABLE t8(pk SHORT INTEGER primary key);
1777 CREATE TABLE t9(pk UNSIGNED INTEGER primary key);
[all …]
H A Dwithout_rowid3.test35 # immediate foreign key constraint is violated.
220 # Same test using a regular primary key with integer affinity.
236 # Use a collation sequence on the parent key.
248 # Use the parent key collation even if it is default and the child key
270 # deferred foreign key constraint logic works.
509 INSERT INTO t2 VALUES('key', 'hello');
689 } {/1 {foreign key mismatch - "c" referencing "."}/}
701 } {1 {unknown column "rowid" in foreign key definition}}
717 } {1 {foreign key mismatch - "t2" referencing "t1"}}
1236 } {1 {foreign key mismatch - "cc" referencing "pp"}}
[all …]
H A Dlaststmtchanges.test106 create table t1 (k integer primary key);
107 create table t2 (k integer primary key, v1, v2);
217 create temp table t1 (k integer primary key);
218 create temp table t2 (k integer primary key);
221 create temp table n1 (k integer primary key, n);
222 create temp table n2 (k integer primary key, n);
H A Dtkt3419.test25 create table a(id integer primary key);
26 create table b(id integer primary key, a_id integer);
27 create table c(id integer primary key, b_id integer);
/sqlite-3.40.0/src/
H A Dtest_pcache.c156 p->a[i].key = 0; in testpcacheCreate()
192 unsigned key, in testpcacheFetch() argument
203 if( p->a[i].key==key ){ in testpcacheFetch()
243 if( p->a[j].key==0 ){ in testpcacheFetch()
244 p->a[j].key = key; in testpcacheFetch()
271 p->a[j].key = key; in testpcacheFetch()
318 p->a[i].key = 0; in testpcacheUnpin()
350 if( p->a[i].key==newKey ){ in testpcacheRekey()
353 p->a[i].key = 0; in testpcacheRekey()
368 p->a[i].key = newKey; in testpcacheRekey()
[all …]
/sqlite-3.40.0/tool/
H A Dgenfkey.README4 The SQLite library is capable of parsing SQL foreign key constraints
9 extracts foreign key definitions from an existing SQLite database and
11 the foreign key constraints.
15 An SQL foreign key is a constraint that requires that each row in
25 primary key columns or subject to a UNIQUE constraint. There is no such
30 "MATCH FULL". "MATCH NONE" means that if any of the key columns in
69 a parent table has a composite primary key, then any child table
85 does not support recursive CASCADE or SET NULL foreign key
90 table A with a CASCADE or SET NULL foreign key constraint).
103 a foreign key that refers to a parent table that does not exist, or
[all …]
H A Dstack_usage.tcl26 set key [list $curfunc $other]
27 set callpair($key) 1
52 foreach key [array names callpair] {
53 foreach {from to} $key break
H A Dgenfkey.test255 Error in table t5: foreign key columns do not exist
256 Error in table t8: foreign key columns do not exist
257 Error in table t4: implicit mapping to composite primary key
258 Error in table t1: implicit mapping to non-existant primary key
259 Error in table t2: implicit mapping to non-existant primary key
260 Error in table t6: foreign key is not unique
261 Error in table t7: foreign key is not unique
276 CREATE TABLE t13 (c1, foreign key(c1) references "t.3"(c1));
/sqlite-3.40.0/ext/lsm1/lsm-test/
H A Dlsmtest_tdb2.cc263 MDB_val key; in test_mdb_write() local
268 key.mv_size = nKey; in test_mdb_write()
269 key.mv_data = pKey; in test_mdb_write()
287 MDB_val key; in test_mdb_delete() local
290 key.mv_size = nKey; in test_mdb_delete()
291 key.mv_data = pKey; in test_mdb_delete()
314 MDB_val key; in test_mdb_fetch() local
317 key.mv_size = nKey; in test_mdb_fetch()
318 key.mv_data = pKey; in test_mdb_fetch()
354 MDB_val key = {0, 0}; in test_mdb_scan() local
[all …]
/sqlite-3.40.0/ext/fts3/
H A Dfts3_unicode2.c133 unsigned int key = (((unsigned int)c)<<10) | 0x000003FF; in sqlite3FtsUnicodeIsalnum() local
139 if( key >= aEntry[iTest] ){ in sqlite3FtsUnicodeIsalnum()
146 assert( aEntry[0]<key ); in sqlite3FtsUnicodeIsalnum()
147 assert( key>=aEntry[iRes] ); in sqlite3FtsUnicodeIsalnum()
206 unsigned int key = (((unsigned int)c)<<3) | 0x00000007; in remove_diacritic() local
212 if( key >= aDia[iTest] ){ in remove_diacritic()
219 assert( key>=aDia[iRes] ); in remove_diacritic()
/sqlite-3.40.0/ext/session/
H A Dsession5.test374 DELETE FROM t1 WHERE a = 'key';
376 INSERT INTO t1 VALUES('key', 'xxx');
378 {INSERT t1 0 X. {} {t key t value}}
383 DELETE FROM t1 WHERE a = 'key';
390 DELETE FROM t1 WHERE a = 'key';
392 INSERT INTO t1 VALUES('key', 'www');
396 {DELETE t1 0 X. {t key t value} {}}
399 DELETE FROM t1 WHERE a = 'key';
401 INSERT INTO t1 VALUES('key', 'ttt');
403 DELETE FROM t1 WHERE a = 'key';
[all …]
/sqlite-3.40.0/ext/wasm/jaccwabyt/
H A Djaccwabyt.js349 if(v.key===memberName){ m = v; break; }
441 const addr = obj[m.key];
500 obj[m.key] = mem;
584 f.sigCheck = function(obj, name, key,sig){ argument
585 if(Object.prototype.hasOwnProperty.call(obj, key)){
593 const key = ctor.memberKey(name);
594 f.sigCheck(ctor.prototype, name, key, descr.signature);
595 descr.key = key;
599 const xPropName = sPropName(ctor.prototype.structName,key);
626 prop.set = __propThrowOnSet(ctor.prototype.structName,key);
[all …]
/sqlite-3.40.0/ext/rtree/
H A DREADME27 The leftmost column is always the pimary key and contains 64-bit
61 * Inserting a NULL value into the primary key column has the
64 an unused integer key value to the new record. Usually, this
65 is one greater than the largest primary key value currently
68 * Attempting to insert a duplicate primary key value fails with
86 R-trees support fast lookup by primary key value (O(logN), like
91 is the key advantage to using r-tree tables instead of creating
/sqlite-3.40.0/autoconf/tea/win/
H A Dnmakehlp.c557 char * key; member
563 list_insert(list_item_t **listPtrPtr, const char *key, const char *value) in list_insert() argument
567 itemPtr->key = strdup(key); in list_insert()
586 free(tmpPtr->key); in list_free()
649 fprintf(stderr, "% 3d '%s' => '%s'\n", n, p->key, p->value); in SubstituteFile()
661 char *m = strstr(szBuffer, p->key); in SubstituteFile()
669 op += strlen(p->key); in SubstituteFile()
/sqlite-3.40.0/ext/wasm/fiddle/
H A Dfiddle.js35 if(!f.key) f.key = 'storage.access.check';
37 obj.setItem(f.key, 'f');
38 const x = obj.getItem(f.key);
39 obj.removeItem(f.key);
40 if(x!=='f') throw new Error(f.key+" failed")

1234567