Home
last modified time | relevance | path

Searched refs:is (Results 1 – 25 of 1433) sorted by relevance

12345678910>>...58

/sqlite-3.40.0/src/
H A Dsqlite.h.in59 ** The SQLITE_STDCALL macro is no longer used and is now deprecated.
1777 ** is invoked.
2310 ** it is not disabled, 1 if it is.
3547 ** VFS is an error. ^If sqlite3_open_v2() is used and the vfs option is
4483 ** is negative, then the length of the string is
6384 ** of connection D is read-only, 0 if it is read/write, or -1 if N is not
6635 ** This interface is omitted if SQLite is compiled with
7598 ** [SQLITE_ERROR] is returned and no data is read. ^If N or iOffset is
7673 ** ^If there is no match, a NULL pointer is returned.
8949 ** is invoked (if one is specified). ^If the
[all …]
H A Din-operator.md13 on the right is called the RHS (right-hand side). If the RHS is a list
37 The RHS is a partial-NULL if any row contains a NULL value. The RHS is
39 The LHS is called "non-NULL" if it contains no NULL values. The RHS is
68 3. If the null-flag is true, return NULL.
75 is the algorithm that is implemented in SQLite.
86 This is the INDEX_NOOP optimization and is only undertaken if the
87 IN operator is used for membership testing. If the IN operator is
90 2. Check the LHS to see if it is a partial-NULL and if it is, jump
94 an exact match is found, return TRUE.
96 4. If the RHS is non-NULL then return FALSE.
[all …]
/sqlite-3.40.0/test/
H A Dfts3c.test4 # a legal notice, here is a blessing:
85 check_doclist fts3c-1.0.2.2 0 0 is {[1 0[1]]}
99 check_doclist fts3c-1.0.4.2 0 2 is {[3 0[1]]}
128 check_doclist_all fts3c-1.1.1.2 is {[3 0[1]]}
134 check_terms fts3c-1.1.2 0 0 {a is test this}
146 check_terms fts3c-1.1.4 0 2 {a is test this}
152 check_terms fts3c-1.1.5 0 3 {a is test this}
154 check_doclist fts3c-1.1.5.2 0 3 is {[1]}
184 check_doclist_all fts3c-1.2.1.2 is {}
190 check_terms fts3c-1.2.2 0 0 {a is test this}
[all …]
H A Dfts2q.test4 # a legal notice, here is a blessing:
20 # If SQLITE_ENABLE_FTS2 is not defined, omit this file.
114 check_terms_all fts2q-1.1 {a is test this}
116 check_doclist_all fts2q-1.1.2 is {[1 0[1]]}
120 check_terms fts2q-1.2 0 0 {a is test this}
122 check_doclist fts2q-1.2.2 0 0 is {[1 0[1]]}
127 # Test results when everything is optimized manually.
234 UPDATE t1 SET c = 'This is a test' WHERE rowid = 1;
236 UPDATE t1 SET c = 'This is a test' WHERE rowid = 3;
275 check_terms fts2q-4.3 0 1 {a four is test this}
[all …]
H A Dcorrupt6.test23 # value is nonzero.
82 # corruption is detected.
94 # corruption is detected.
117 # corruption is detected.
129 # corruption is detected.
152 # corruption is detected.
164 # corruption is detected.
176 # corruption is detected.
188 # corruption is detected.
200 # corruption is detected.
[all …]
H A Dfts2p.test4 # a legal notice, here is a blessing:
187 check_doclist fts2p-1.0.2.2 0 0 is {[1 0[1]]}
201 check_doclist fts2p-1.0.4.2 0 2 is {[3 0[1]]}
236 check_terms fts2p-1.1.2 0 0 {a is test this}
248 check_terms fts2p-1.1.4 0 2 {a is test this}
254 check_terms fts2p-1.1.5 0 3 {a is test this}
256 check_doclist fts2p-1.1.5.2 0 3 is {[1]}
286 check_doclist_all fts2p-1.2.1.2 is {}
292 check_terms fts2p-1.2.2 0 0 {a is test this}
304 check_terms fts2p-1.2.4 0 2 {a is test this}
[all …]
H A Dfts3d.test4 # a legal notice, here is a blessing:
19 # If SQLITE_ENABLE_FTS3 is not defined, omit this file.
74 check_terms_all fts3d-1.1 {a is test this}
76 check_doclist_all fts3d-1.1.2 is {[1 0[1]]}
80 check_terms fts3d-1.2 0 0 {a is test this}
82 check_doclist fts3d-1.2.2 0 0 is {[1 0[1]]}
87 # Test results when everything is optimized manually.
194 UPDATE t1 SET c = 'This is a test' WHERE rowid = 1;
196 UPDATE t1 SET c = 'This is a test' WHERE rowid = 3;
236 check_terms fts3d-4.3 0 1 {a four is test this}
[all …]
H A Dnotify1.test4 # a legal notice, here is a blessing:
28 # and that it is invoked.
41 } {1 {database table is locked}}
72 } {1 {database table is locked}}
124 } {1 {database table is locked: t1}}
130 } {1 {database table is locked: t2}}
134 } {1 {database is deadlocked}}
177 } {1 {database is deadlocked}}
242 # is handled correctly.
461 } {1 {database table is locked}}
[all …]
H A De_uri.test4 # a legal notice, here is a blessing:
155 # present, is ignored.
157 # It is difficult to test that something is ignored correctly. So these tests
177 # path is interpreted as a relative path.
193 # The above is tested by cases 1.* below.
196 # the default VFS object is used.
198 # The above is tested by cases 2.* below.
205 # The above is tested by cases 3.* below.
252 # value is an error
270 # EVIDENCE-OF: R-43036-46756 If "ro" is specified, then the database is
[all …]
H A De_walckpt.test4 # a legal notice, here is a blessing:
48 # following requirement is violated:
191 # string) and is not the name of any attached database, SQLITE_ERROR is
198 # database that is not in WAL mode, SQLITE_OK is returned and both
238 # SQLITE_BUSY is returned.
503 # immediately, and a busy-handler is configured, it is invoked and the
549 # is met. The second part is tested below. If the checkpoint mode
679 # an attached database, processing is abandoned and the error code is
727 # EVIDENCE-OF: R-16642-42503 If pnLog is not NULL, then *pnLog is set to
732 # EVIDENCE-OF: R-10514-25250 If pnCkpt is not NULL,then *pnCkpt is set
[all …]
H A Dio.test4 # a legal notice, here is a blessing:
45 # is committed.
150 # The single fsync() is the database file. Only one page is reported as
164 # Test that the journal file is not created and the change-counter is
186 # is set.
210 # is executed.
216 # BEGIN IMMEDIATE and the INSERT is omitted.
301 # size is larger than the page-size.
442 # Normally, when the SAFE_APPEND flag is not set, there is another fsync()
524 # journal file is give by:
[all …]
H A Dcorrupt3.test4 # a legal notice, here is a blessing:
22 # value is nonzero.
56 } 1024 ;# The page size is 1024
59 } 0 ;# Unused bytes per page is 0
62 } 3 ;# Overflow page is 3
65 } 0 ;# First chained overflow is 0
70 # corruption is detected.
97 } [list 1 {database disk image is malformed}]
104 Page 3 is never used}}}
112 } [list 1 {database disk image is malformed}]
[all …]
H A Dwalnoshm.test4 # a legal notice, here is a blessing:
13 # using the xShm primitives if the connection is in exclusive-mode.
71 # and convert it to rollback mode if it is set to use
117 } {1 {database is locked}}
120 # This is to test that [db2] is not holding a PENDING lock (which can
128 } {1 {database is locked}}
147 # 3.1: Test that if locking_mode=EXCLUSIVE is set after the wal file is
148 # opened, it is possible to drop back to locking_mode=NORMAL.
150 # 3.2: Test that if locking_mode=EXCLUSIVE is set before the wal file is
151 # opened, it is not.
[all …]
H A Dsuperlock.test4 # a legal notice, here is a blessing:
22 # 1.*: Test superlock on a rollback database. Test that once the db is
27 # Test that once the db is superlocked, it is not possible to read,
42 # superlock is released.
58 do_catchsql_test 1.3 { SELECT * FROM t1 } {1 {database is locked}}
127 } {1 {database is locked}}
141 } {1 {database is locked}}
145 } {1 {database is locked}}
149 } {1 {database is locked}}
186 # file is also exchanged.
[all …]
H A De_walhook.test4 # a legal notice, here is a blessing:
19 # EVIDENCE-OF: R-00752-43975 The sqlite3_wal_hook() function is used to
20 # register a callback that is invoked each time data is committed to a
23 # 1.1: shows that the wal-hook is not invoked in rollback mode.
24 # 1.2: but is invoked in wal mode.
77 # EVIDENCE-OF: R-44294-52863 The third parameter is the name of the
129 } {1 {database is locked}}
183 # function when it is invoked is a copy of the third parameter passed to
186 # This is tricky to test using the tcl interface. However, the
192 # EVIDENCE-OF: R-23378-42536 The second is a copy of the database
[all …]
H A De_blobclose.test4 # a legal notice, here is a blessing:
34 # It's not clear how to test that a blob handle really is closed.
36 # Assume here that if the SHARED lock on the db file is released,
49 # statements, the current transaction is committed.
51 # 2.1.*: Transaction is not committed if there are other open
54 # 2.2.*: Transaction is not committed if not in auto-commit mode.
62 sqlite3_blob_open db main x1 b -10000 0 B4 ;# B4 is read-only!
147 } {SQLITE_BUSY {database is locked}}
150 # Even if this routine returns an error code, the handle is still
154 # is closed, even though blob_close() returned SQLITE_BUSY.
[all …]
H A Dpragma.test436 Page 4 is never used
437 Page 5 is never used
456 Page 4 is never used
457 Page 5 is never used
464 Page 4 is never used
465 Page 5 is never used
472 Page 4 is never used
473 Page 5 is never used
480 Page 4 is never used
488 Page 4 is never used
[all …]
/sqlite-3.40.0/ext/userauth/
H A Duser-auth.txt60 required database, the call sequence is:
64 /* Database is now usable */
67 call sequence is:
72 /* Database is now usable */
78 database that is an authentication-required database is checked using
95 the call sequence is:
101 sequence is:
145 interface. The second argument is the sqlite_user.pw value and is supplied
147 The result of sqlite_crypt(X,Y) is another blob which is the value that
154 password X, sqlite_crypt(X,NULL) is run. A new random salt is selected
[all …]
/sqlite-3.40.0/ext/async/
H A DREADME.txt4 by WAL-mode. This module is no longer supported or maintained. The
5 code is retained for historical reference only.
11 Since writing to the file-system is usually very slow compared with CPU
37 it is happening at its usual slow pace in the background.
92 If file-locking is enabled (it is enabled by default), then connections
94 However concurrency is reduced as follows:
98 lock is not released until after all relevant operations
101 time after a "COMMIT" or "ROLLBACK" is issued.
105 locked out of the database. This is because when a BEGIN
106 is executed, a database lock is established immediately. But
[all …]
/sqlite-3.40.0/ext/wasm/jaccwabyt/
H A Djaccwabyt.md87 because it is the most widespread WASM toolchain, but this code is
290 is NUL-terminated. If that is _not_ the case for a given string
467 `Module._malloc()`. That is, it is passed the number of bytes to
505 `console.log` is used but by default no debug output is generated.
531 argument is optional, otherwise it is required.
590 "external" object. That is the case when a pointer is passed to a
623 strings. If an entry is a function, it is called as described
647 member. If its signature is `s` then it is assumed to refer to a
649 such. If its signature is not one of those then an exception is
650 thrown. If its address is 0, `null` is returned. See also:
[all …]
/sqlite-3.40.0/ext/wasm/api/
H A DREADME.md3 This is the README for the files `sqlite3-*.js` and
4 `sqlite3-wasm.c`. This collection of files is used to build a
5 single-file distribution of the sqlite3 WASM API. It is broken into
10 OO#1 API is not needed.
22 The overall idea is that the following files get concatenated
23 together, in the listed order, the resulting file is loaded by a
36 more portable to arbitrary WASM toolchains. This API is
39 to support this tree but is standalone and maintained together
65 this is an optional component, offering one of any number of
70 and runs the Worker #1 API which is implemented in
[all …]
/sqlite-3.40.0/ext/rtree/
H A Drtreedoc3.test4 # a legal notice, here is a blessing:
12 # The focus of this file is testing the r-tree extension.
30 # as a list. Each cell is itself a list of the following form:
57 # the root node of an r-tree, this value is the height of the tree.
88 # the list is unimportant - it is just used as a set here. Each element
89 # in the priority queue is itself a list. The first element is the
112 error "priority queue is empty!"
185 # Check level is as expected
210 # returned to the priority queue. Otherwise it is discarded.
225 # EVIDENCE-OF: R-13214-54017 If that entry is a leaf (meaning that it is
[all …]
/sqlite-3.40.0/tool/
H A Dgenfkey.README4 The SQLite library is capable of parsing SQL foreign key constraints
15 An SQL foreign key is a constraint that requires that each row in
24 is true. The columns in the parent table are required to be either the
50 and "RESTRICT" is used instead.
54 the child table is not allowed. An exception is thrown.
59 row is being updated).
68 * Implicit mapping to composite primary keys is not supported. If
76 is supported:
82 error when the program is run (see below).
93 detected as errors when the program is run. Buyer beware.
[all …]
/sqlite-3.40.0/doc/
H A Dvdbesort-memory.md6 Memory allocation is slightly different depending on:
8 * whether or not SQLITE_CONFIG_SMALL_MALLOC is set, and
13 Assuming SQLITE_CONFIG_SMALL_MALLOC is not set, keys passed to the sorter are
14 added to an in-memory buffer. This buffer is grown using sqlite3Realloc() as
17 then this buffer is allowed to grow up to 2MB in size.
22 the temp file, the buffer is reused to accumulate the next batch of keys.
28 and used, where nWorker is the number of configured worker threads.
40 This case is similar to the above, except that instead of accumulating
46 Each time a key is added the sorter (and an allocation made),
47 sqlite3HeapNearlyFull() is called. If it returns true, the current
[all …]
H A Djson-enhancements.md17 Both operators are similar to json_extract(). The left operand is
18 JSON and the right operand is a JSON path expression (possibly abbreviated
22 The difference between -> and ->> (and json_extract()) is as follows:
28 is selected, that object or array is rendered as text. If a JSON
29 value is selected, that value is converted into its corresponding
33 array is selected, or a primitive SQL datatype when a JSON value
34 is selected. This is different from MySQL, in which json_extract()
35 always returns JSON, but the difference is retained because it has
114 In the following table, assume that "value1" is a JSON object and
115 "value2" is a JSON array.
[all …]

12345678910>>...58