Home
last modified time | relevance | path

Searched refs:time (Results 1 – 25 of 174) sorted by relevance

1234567

/sqlite-3.40.0/test/
H A Ddate3.test12 # focus of this file is testing date and time functions.
18 # Skip this whole file if date and time functions are omitted
19 # at compile-time
33 # EVIDENCE-OF: R-45708-63005 unixepoch(time-value, modifier, modifier,
52 # even if the input time-value has millisecond precision.
56 # EVIDENCE-OF: R-05412-24332 If the time-value is numeric (the
93 # time-values.
98 # with date/time values even in cases where it is not known if the
111 # it immediately follows a time value in the DDDDDDDDDD format.
127 # time-value number to be interpreted as a julian-day number.
[all …]
H A Dwalsetlk.test102 set us [lindex [time { catch {db eval "BEGIN EXCLUSIVE"} }] 0]
119 set us [lindex [time { catch {db eval "PRAGMA wal_checkpoint=RESTART"} }] 0]
132 set us [lindex [time { catch {db eval "PRAGMA wal_checkpoint=RESTART"} }] 0]
151 set us [lindex [time { catch {db eval "PRAGMA wal_checkpoint=RESTART"} }] 0]
164 set us [lindex [time { catch {db eval "PRAGMA wal_checkpoint=RESTART"} }] 0]
178 set us [lindex [time { catch {db eval "PRAGMA wal_checkpoint=RESTART"} }] 0]
H A Dbusy2.test43 set us [lindex [time { catch { sql1 { BEGIN EXCLUSIVE } } }] 0]
97 set us [lindex [time {
106 set us [lindex [time {
115 set us [lindex [time {
124 set us [lindex [time {
138 # the next time an SQLITE_BUSY is encountered.
H A Ddate.test12 # focus of this file is testing date and time functions.
24 # Skip this whole file if date and time functions are omitted
25 # at compile-time
107 datetest 2.16 time('12:34:56.43') 12:34:56
253 # (3) The function fails for the specific date/time value
295 } {1 {local time unavailable}}
307 # Date-time functions that contain NULL arguments return a NULL
313 datetest 7.4 {time(null)} NULL
314 datetest 7.5 {time('now',null)} NULL
315 datetest 7.6 {time('now','localtime',null)} NULL
[all …]
H A Damatch1.test80 puts "Query against fts4aux: [time {
85 puts "Query against ordinary table: [time {
90 puts "Temp table initialized from fts4aux: [time {
95 puts "Query against temp table: [time {
H A Dselect2.test66 set t1 [time {
77 puts "time with cache: $::t1"
81 set t2 [time {
92 puts "time without cache: $t2"
H A Dasync4.test132 set T1 [lindex [time {
139 set T2 [lindex [time {
150 set T1 [lindex [time {
H A Dtkt-bd484a090c.test31 } {1 {local time unavailable}}
34 } {1 {local time unavailable}}
H A Dctime.test13 # This file implements tests for the compile time diagnostic
191 # This assumes there is at least 1 compile time option
199 # This assumes there is at least 1 compile time option
H A Dfts3cov.test27 # stored and reused each subsequent time a block is read. This test case
220 # The query is compiled the first time this operation is required and
222 # preparing and executing this query for the first time.
233 # First time.
240 # Second time.
277 # pending-terms table must be flushed each time a document with a docid
357 INSERT INTO t12 VALUES('one which was appropriate at the time');
H A Dfunc3.test119 # during run-time (that is, during calls to sqlite3_step()).
150 # run-time (that is, during calls to sqlite3_step()).
194 # run-time (that is, during calls to sqlite3_step()).
H A Dthread004.test61 # repeatedly. Each time this happens, the in-memory schema used by
65 # over again. Each time it is called, the database schema is loaded
H A Ddate2.test12 # focus of this file is testing date and time functions used in
19 # Skip this whole file if date and time functions are omitted
20 # at compile-time
H A Dshell5.test151 puts $in "5|Now is the time for all good men to come to the aid of their country."
159 } {0 {Now is the time for all good men to come to the aid of their country.}}
166 puts $in "6|'Now is the time for all good men to come to the aid of their country.'"
174 } {0 {'Now is the time for all good men to come to the aid of their country.'}}
179 puts $in "7|\"Now is the time for all good men to come to the aid of their country.\""
187 } {0 {Now is the time for all good men to come to the aid of their country.}}
H A Dwalprotocol2.test78 # Same again, but with a busy-handler. This time, following the
80 # whole thing retried from the beginning. This time it succeeds.
H A Dmutex1.test40 # is called at the wrong time. And that the first time sqlite3_initialize
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5rank.test134 INSERT INTO z1 VALUES('wrinkle in time');
135 SELECT * FROM z1 WHERE z1 MATCH 'wrinkle in time OR a wrinkle in time';
136 } {{wrinkle in time}}
145 INSERT INTO VTest (Title, Author) VALUES ('wrinkle in time', 'Bill Smith');
148 VTest MATCH 'wrinkle in time OR a wrinkle in time' ORDER BY rank;
149 } {{wrinkle in time} {Bill Smith}}
/sqlite-3.40.0/ext/wasm/api/
H A Dsqlite3-opfs-async-proxy.js72 const r = (m)=>(m.count = m.time = m.wait = 0);
78 s.count = s.time = 0;
80 s.count = s.time = 0;
87 t += m.time;
89 m.avgTime = (m.count && m.time) ? (m.time / m.count) : 0;
300 metrics[__mTimer.op].time += performance.now() - __mTimer.start
686 metrics.s11n.deserialize.time += performance.now() - t;
722 metrics.s11n.serialize.time += performance.now() - t;
H A Dsqlite3-api-opfs.js140 t += m.time;
142 m.avgTime = (m.count && m.time) ? (m.time / m.count) : 0;
154 const r = (m)=>(m.count = m.time = m.wait = 0);
160 s.count = s.time = 0;
162 s.count = s.time = 0;
501 metrics.s11n.deserialize.time += performance.now() - t;
550 metrics.s11n.serialize.time += performance.now() - t;
660 metrics[opTimer.op].time += performance.now() - opTimer.start
/sqlite-3.40.0/doc/
H A Djson-enhancements.md11 -DSQLITE_OMIT_JSON compile-time option.
135 that could be optionally included at compile-time, or loaded at run-time.
138 -DSQLITE_ENABLE_JSON1 compile-time option was used.
142 No special compile-time options are needed to load JSON into the build.
143 Instead, there is a new -DSQLITE_OMIT_JSON compile-time option to leave
H A Dvfs-shm.txt33 wal-index information can be appended at any time. The
56 the same time.
64 time. Or, an implementation might combine READ and READ_FULL into
H A Dvdbesort-memory.md33 in one page at a time.
46 Each time a key is added the sorter (and an allocation made),
/sqlite-3.40.0/ext/repair/
H A DREADME.md9 off-line for such a long time.
15 active development at the time of this writing (2017-10-12). If and when
/sqlite-3.40.0/autoconf/
H A DINSTALL71 this time using the binaries in their final installed location.
115 same time, by placing the object files for each architecture in their
123 architecture at a time in the source code directory. After you have
138 may have to build one architecture at a time and combine the results
176 time for the entire installation to be relocated. The approach of
190 at `configure' time.
229 HP-UX `make' updates targets which have the same time stamps as
/sqlite-3.40.0/ext/expert/
H A DREADME.md20 1. The SQL queries are prepared a second time. If the planner uses any
72 the user database. For a large database, this may be prohibitively time

1234567