Home
last modified time | relevance | path

Searched refs:R (Results 1 – 25 of 131) sorted by relevance

123456

/sqlite-3.40.0/test/
H A Dtestrunner.tcl53 set R(schema) {
254 global R
268 global R
305 global R
344 global R
375 set R(iNextMsg) 1
377 global R
406 global R
538 global R
550 global R
[all …]
H A Ddate3.test33 # EVIDENCE-OF: R-45708-63005 unixepoch(time-value, modifier, modifier,
43 # EVIDENCE-OF: R-30877-63179 The unixepoch() function returns a unix
51 # EVIDENCE-OF: R-62992-54137 The unixepoch() always returns an integer,
56 # EVIDENCE-OF: R-05412-24332 If the time-value is numeric (the
61 # EVIDENCE-OF: R-56763-40111 If the value is between 0.0 and
66 # EVIDENCE-OF: R-07289-49223 For numeric values outside of the range of
71 # EVIDENCE-OF: R-20795-34947 Other numeric values are out of range and
92 # EVIDENCE-OF: R-38886-35357 The 'auto' modifier is a no-op for text
97 # EVIDENCE-OF: R-53132-26856 The 'auto' modifier can be used to work
126 # EVIDENCE-OF: R-32483-36353 The 'julianday' modifier forces the
[all …]
H A De_expr.test92 # X-EVIDENCE-OF: R-38759-38789 Operators IS and IS NOT have the same
194 # EVIDENCE-OF: R-53670-03373 The unary operator + is a no-op.
216 # EVIDENCE-OF: R-03679-60639 Equals can be either = or ==.
368 # X-EVIDENCE-OF: R-36231-30731 The COLLATE operator has a higher
448 # EVIDENCE-OF: R-09593-03321 BLOB literals are string literals
452 # EVIDENCE-OF: R-19836-11244 Example: X'53514C697465'
836 # EVIDENCE-OF: R-40079-54503 The BETWEEN operator is logically
942 # EVIDENCE-OF: R-44381-11669 the expression
1011 # EVIDENCE-OF: R-22868-25880 The LIKE operator can be made case
1553 # EVIDENCE-OF: R-22662-28218 If there is no prefix that can be
[all …]
H A Dfts3first.test43 INSERT INTO x1(docid,a,b,c) VALUES(2, 'B P M O I', 'R P H W S', 'R J L L E');
44 INSERT INTO x1(docid,a,b,c) VALUES(3, 'U R Q M L', 'M J K A V', 'Q W J T J');
45 INSERT INTO x1(docid,a,b,c) VALUES(4, 'N J C Y N', 'R U D X V', 'B O U A Q');
47 INSERT INTO x1(docid,a,b,c) VALUES(6, 'M R G U T', 'U V I Q P', 'X Y D L S');
48 INSERT INTO x1(docid,a,b,c) VALUES(7, 'D Y P O I', 'X J P K R', 'V O T H V');
49 INSERT INTO x1(docid,a,b,c) VALUES(8, 'R Y D L R', 'U U E S J', 'N W L M R');
52 INSERT INTO x1(docid,a,b,c) VALUES(11, 'T E R Q B', 'C I B C B', 'F Z U W R');
55 INSERT INTO x1(docid,a,b,c) VALUES(14, 'K H A B L', 'S R C C Z', 'D W E H J');
59 INSERT INTO x1(docid,a,b,c) VALUES(18, 'A J M O Q', 'L G Y Y A', 'G N M R N');
101 2 {^X} {{[X] Y D L S} {[X] J P K R} {[X] S B X Y}}
[all …]
H A Dfts4content.test98 INSERT INTO t2 VALUES('N R O R H J R H G M D I U U B O M P A U'); -- 4
101 INSERT INTO t2 VALUES('S Z S R I Q U A P W R X H K C Z U L S P'); -- 7
102 INSERT INTO t2 VALUES('J C H N R C K R V N M O F Z M Z A I H W'); -- 8
103 INSERT INTO t2 VALUES('O Y G I S J U U W O D Z F J K N R P R L'); -- 9
104 INSERT INTO t2 VALUES('B G L K U R U P V X Z I H V R W C Q A S'); -- 10
110 INSERT INTO t2 VALUES('M I W P J S H R J D Q I C G P C T P H R'); -- 16
113 INSERT INTO t2 VALUES('R F S R Y O F Q E I E G H C B H R X Y N'); -- 19
222 INSERT INTO ft3(rowid, x, y) VALUES(12, 'R Z M R J', 'X G I M Z');
223 INSERT INTO ft3(rowid, x, y) VALUES(13, 'L X N N X', 'R R N S T');
482 INSERT INTO ft8(docid, x) VALUES(16, 'R Y D O R');
[all …]
H A De_walckpt.test50 # EVIDENCE-OF: R-60567-47780 Unless it returns SQLITE_MISUSE, the
88 # EVIDENCE-OF: R-36706-10507 The PRAGMA wal_checkpoint command can be
91 # EVIDENCE-OF: R-41613-20553 The sqlite3_wal_checkpoint(D,X) is
150 # EVIDENCE-OF: R-49787-09095 The sqlite3_wal_checkpoint_v2(D,X,M,L,C)
158 # EVIDENCE-OF: R-00653-06026 If parameter zDb is NULL or points to a
190 # EVIDENCE-OF: R-38207-48996 If zDb is not NULL (or a zero length
236 # EVIDENCE-OF: R-10421-19736 If any other process is running a
462 # Which is part of R-16333-64433 above.
490 # EVIDENCE-OF: R-59171-47567 This mode blocks (it invokes the
543 # EVIDENCE-OF: R-12410-31217 This mode works the same way as
[all …]
H A Dwithout_rowid5.test23 # EVIDENCE-OF: R-36924-43758 By default, every row in SQLite has a
27 # EVIDENCE-OF: R-32341-39358 However if the phrase "WITHOUT ROWID" is
48 # EVIDENCE-OF: R-00217-01605 To create a WITHOUT ROWID table, simply add
64 # EVIDENCE-OF: R-24770-17719 As with all SQL syntax, the case of the
99 # EVIDENCE-OF: R-01418-51310 However, only "rowid" works as the keyword
115 # EVIDENCE-OF: R-58033-17334 An error is raised if a CREATE TABLE
118 # EVIDENCE-OF: R-63443-09418 Every WITHOUT ROWID table must have a
131 # EVIDENCE-OF: R-48230-36247 The special behaviors associated "INTEGER
147 # EVIDENCE-OF: R-33142-02092 AUTOINCREMENT does not work on WITHOUT
164 # EVIDENCE-OF: R-27472-62612 But WITHOUT ROWID tables do follow the
[all …]
H A De_uri.test50 # EVIDENCE-OF: R-35840-33204 If URI filename interpretation is enabled,
54 # EVIDENCE-OF: R-27632-24205 URI filename interpretation is enabled if
131 # EVIDENCE-OF: R-06842-00595 If the URI contains an authority, then it
154 # EVIDENCE-OF: R-45981-25528 The fragment component of a URI, if
172 # EVIDENCE-OF: R-28659-11035 If the path begins with a '/' character,
175 # EVIDENCE-OF: R-46234-61323 If the path does not begin with a '/'
195 # EVIDENCE-OF: R-52293-58497 If this option is set to an empty string
239 # EVIDENCE-OF: R-48365-36308 Specifying an unknown VFS is an error.
250 # EVIDENCE-OF: R-44013-13102 The mode parameter may be set to either
369 # EVIDENCE-OF: R-31773-41793 If sqlite3_open_v2() is used and the
[all …]
H A De_wal.test22 # EVIDENCE-OF: R-58297-14483 WAL databases can be created, read, and
26 # EVIDENCE-OF: R-00449-33772 This feature allows WAL databases to be
81 # EVIDENCE-OF: R-31969-57825 If EXCLUSIVE locking mode is set prior to
96 # EVIDENCE-OF: R-36328-16367 In that case, the database connection
111 # EVIDENCE-OF: R-63522-46088 The only way to change out of EXCLUSIVE
134 # EVIDENCE-OF: R-57239-11845 If NORMAL locking mode is in effect for the
149 # EVIDENCE-OF: R-13779-07711 As long as exactly one connection is using
183 # EVIDENCE-OF: R-46197-42811 This means that the underlying VFS must
186 # EVIDENCE-OF: R-55316-21772 If the VFS does not support shared-memory
217 # EVIDENCE-OF: R-02535-05811 One can explicitly change out of WAL mode
[all …]
H A De_fkey.test190 # EVIDENCE-OF: R-11255-19907
433 # EVIDENCE-OF: R-16127-35442
477 # EVIDENCE-OF: R-15958-50233
671 # EVIDENCE-OF: R-27484-01467
818 # EVIDENCE-OF: R-19353-43643
965 # EVIDENCE-OF: R-00279-52283
1093 # EVIDENCE-OF: R-14553-34013
1184 # EVIDENCE-OF: R-24676-09859
1364 # EVIDENCE-OF: R-12782-61841
1371 # EVIDENCE-OF: R-09005-28791
[all …]
H A De_select.test383 # EVIDENCE-OF: R-49872-03192 If the join-operator is "CROSS JOIN",
425 # EVIDENCE-OF: R-59089-25828 The columns of the cartesian product
513 # EVIDENCE-OF: R-38465-03616 If there is an ON clause then the ON
551 # EVIDENCE-OF: R-22776-52830 For each pair of named columns, the
565 # EVIDENCE-OF: R-38422-04402 The column from the dataset on the
659 # EVIDENCE-OF: R-04932-55942 If the NATURAL keyword is in the
817 # EVIDENCE-OF: R-44324-41166 It is also an error to use a "*" or
913 # EVIDENCE-OF: R-26684-40576 Each non-aggregate expression in the
1136 # EVIDENCE-OF: R-53735-47017 If the expression is an aggregate
1164 # EVIDENCE-OF: R-19334-12811 Each group of input dataset rows
[all …]
H A De_fts3.test273 } [concat $R(2) $R(4) $R(5) $R(6) $R(7) $R(8)]
276 } [concat $R(2) $R(3) $R(4) $R(5) $R(6) $R(7) $R(8) $R(9)]
279 } [concat $R(5)]
282 } [concat $R(6)]
285 } [concat $R(8)]
288 } [concat $R(8) $R(9)]
290 unset R
328 } [list $R(3)]
331 } [list $R(3)]
334 } [list $R(1) $R(2) $R(3)]
[all …]
H A Dalterdropcol2.test23 # EVIDENCE-OF: R-58318-35349 The DROP COLUMN syntax is used to remove an
55 # EVIDENCE-OF: R-24098-10282 The DROP COLUMN command only works if the column
60 # EVIDENCE-OF: R-52436-31752 The column is a PRIMARY KEY or part of one.
77 # EVIDENCE-OF: R-43412-16016 The column has a UNIQUE constraint.
94 # EVIDENCE-OF: R-46731-08965 The column is indexed.
113 # EVIDENCE-OF: R-46731-08965 The column is indexed.
124 # EVIDENCE-OF: R-47838-03249 The column is named in a table or column
135 # EVIDENCE-OF: R-55640-01652 The column is used in a foreign key constraint.
146 # EVIDENCE-OF: R-20795-39479 The column is used in the expression of a
163 # EVIDENCE-OF: R-01515-49025 The column appears in a trigger or view.
[all …]
H A De_walhook.test19 # EVIDENCE-OF: R-00752-43975 The sqlite3_wal_hook() function is used to
60 # EVIDENCE-OF: R-65366-15139 The callback is invoked by SQLite after the
77 # EVIDENCE-OF: R-44294-52863 The third parameter is the name of the
81 # EVIDENCE-OF: R-18913-19355 The fourth parameter is the number of pages
116 # EVIDENCE-OF: R-14034-00929 If an error code is returned, that error
140 # EVIDENCE-OF: R-10466-53920 Calling sqlite3_wal_hook() replaces any
164 # EVIDENCE-OF: R-57445-43425 Note that the sqlite3_wal_autocheckpoint()
182 # EVIDENCE-OF: R-52629-38967 The first parameter passed to the callback
192 # EVIDENCE-OF: R-23378-42536 The second is a copy of the database
H A De_blobopen.test73 # EVIDENCE-OF: R-37639-55938 This interfaces opens a handle to the BLOB
108 # EVIDENCE-OF: R-27234-05761 Parameter zDb is not the filename that
127 # EVIDENCE-OF: R-50854-53979 If the flags parameter is non-zero, then
207 # EVIDENCE-OF: R-08940-21305 Unless it returns SQLITE_MISUSE, this
241 # EVIDENCE-OF: R-31204-44780 Database zDb does not exist
247 # EVIDENCE-OF: R-40134-30296 Table zTable is a WITHOUT ROWID table
251 # EVIDENCE-OF: R-56376-21261 Column zColumn does not exist
254 # EVIDENCE-OF: R-28258-23166 Row iRow is not present in the table
304 # EVIDENCE-OF: R-08940-21305 Unless it returns SQLITE_MISUSE, this
342 # EVIDENCE-OF: R-48367-20048 Calls to sqlite3_blob_read() and
[all …]
/sqlite-3.40.0/ext/rtree/
H A Drtreedoc.test51 # EVIDENCE-OF: R-15060-13876 A 1-dimensional R*Tree thus has 3 columns.
55 # EVIDENCE-OF: R-19353-19546 A 2-dimensional R*Tree has 5 columns.
59 # EVIDENCE-OF: R-13615-19528 A 3-dimensional R*Tree has 7 columns.
65 # EVIDENCE-OF: R-53479-41922 A 4-dimensional R*Tree has 9 columns.
71 # EVIDENCE-OF: R-13981-28768 And a 5-dimensional R*Tree has 11 columns.
80 # EVIDENCE-OF: R-61533-25862 The SQLite R*Tree implementation does not
96 # EVIDENCE-OF: R-16717-50504 Each R*Tree index is a virtual table with
113 # EVIDENCE-OF: R-17874-21123 The first column of an SQLite R*Tree is
283 # EVIDENCE-OF: R-15142-18077 A new R*Tree index is created as follows:
701 # EVIDENCE-OF: R-55979-39402 It is the nature of the Guttman R-Tree
[all …]
H A Drtreedoc2.test34 # EVIDENCE-OF: R-35254-48865 A call to one of the above APIs creates a
61 # EVIDENCE-OF: R-61427-46983
81 # EVIDENCE-OF: R-59634-51678 When that SQL function appears on the
111 # EVIDENCE-OF: R-02424-24769 The second argument is the number of
113 # R*Tree.
115 # EVIDENCE-OF: R-40260-16838 The number of coordinates is 2 for a
116 # 1-dimensional R*Tree, 4 for a 2-dimensional R*Tree, 6 for a
117 # 3-dimensional R*Tree, and so forth.
146 # EVIDENCE-OF: R-28051-48608 If xGeom returns anything other than
203 # EVIDENCE-OF: R-31246-29731 The pContext member of the
[all …]
/sqlite-3.40.0/ext/recover/
H A Drecoverold.test40 set R [sqlite3_recover_init db main test.db2]
41 $R config lostandfound lost_and_found
42 $R run
43 $R finish
59 $R config lostandfound lost_and_found
60 $R run
61 $R finish
174 $R config lostandfound lost_and_found
175 $R config freelistcorrupt 1
176 $R run
[all …]
H A Drecover1.test46 $R config testdb rstate.db
47 $R run
48 $R finish
62 $R config rowids 1
63 $R run
64 $R finish
206 $R config lostandfound ""
207 $R config invalid xyz
210 $R run
211 $R run
[all …]
H A Drecovercorrupt2.test33 $R run
34 $R finish
54 $R run
55 $R finish
95 $R run
96 $R finish
137 $R run
138 $R finish
158 catch { $R run }
159 list [catch { $R finish } msg] $msg
[all …]
H A Drecoverfault.test50 set R [sqlite3_recover_init db main test.db2]
51 $R run
52 $R finish
75 set R [sqlite3_recover_init db main test.db2]
76 $R config lostandfound lost_and_found
77 $R run
78 $R finish
H A Drecoverslowidx.test32 set R [sqlite3_recover_init_sql db main my_sql_hook]
33 while {[$R step]==0} { }
34 $R finish
59 set R [sqlite3_recover_init_sql db main my_sql_hook]
60 $R config slowindexes 1
61 while {[$R step]==0} { }
62 $R finish
H A Drecoversql.test32 set R [sqlite3_recover_init_sql db main sql_hook]
33 $R run
34 $R finish
43 set R [sqlite3_recover_init_sql db main sql_hook]
44 $R run
47 list [catch { $R finish } msg] $msg
H A Drecoverfault2.test53 set R [sqlite3_recover_init_sql db main my_sql_hook]
54 $R run
55 $R finish
85 set R [sqlite3_recover_init_sql db main my_sql_hook]
86 $R run
87 $R finish
/sqlite-3.40.0/ext/session/
H A Dsessionfault2.test214 sqlite3rebaser_create R
215 R configure $::rebase
216 R rebase $::C1
219 catch { R delete }
228 sqlite3rebaser_create R
229 R configure $::rebase
230 R rebase $::C1
233 catch { R delete }
275 R configure $::rebase1
276 R configure $::rebase2
[all …]

123456