Debian Codegraph @

ext/fts5/test/fts5contentless4.test

raw
1 # 2023 July 21
2 #
3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
5 #
6 # May you do good and not evil.
7 # May you find forgiveness for yourself and forgive others.
8 # May you share freely, never taking more than you give.
9 #
10 #***********************************************************************
11 #
12 # This file contains tests for the content= and content_rowid= options.
13 #
14
15 source [file join [file dirname [info script]] fts5_common.tcl]
16 set testprefix fts5contentless4
17
18 # If SQLITE_ENABLE_FTS5 is not defined, omit this file.
19 ifcapable !fts5 {
20 finish_test
21 return
22 }
23
24 proc document {n} {
25 set vocab [list A B C D E F G H I J K L M N O P Q R S T U V W X Y Z]
26 set ret [list]
27 for {set ii 0} {$ii < $n} {incr ii} {
28 lappend ret [lindex $vocab [expr int(rand()*[llength $vocab])]]
29 }
30 set ret
31 }
32 db func document document
33
34 do_execsql_test 1.0 {
35 CREATE VIRTUAL TABLE ft USING fts5(x, content='', contentless_delete=1);
36 INSERT INTO ft(ft, rank) VALUES('pgsz', 240);
37 WITH s(i) AS (
38 SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<1000
39 )
40 INSERT INTO ft SELECT document(12) FROM s;
41 }
42
43 do_execsql_test 1.1 {
44 INSERT INTO ft(ft) VALUES('optimize');
45 }
46
47 do_execsql_test 1.2 {
48 SELECT level, segment, nentry, nentrytombstone FROM fts5_structure((
49 SELECT block FROM ft_data WHERE id=10
50 ))
51 } {0 0 1000 0}
52
53 do_execsql_test 1.3 {
54 DELETE FROM ft WHERE rowid < 50
55 }
56
57 do_execsql_test 1.4 {
58 SELECT level, segment, nentry, nentrytombstone FROM fts5_structure((
59 SELECT block FROM ft_data WHERE id=10
60 ))
61 } {0 0 1000 49}
62
63 do_execsql_test 1.5 {
64 DELETE FROM ft WHERE rowid < 1000
65 }
66
67 do_execsql_test 1.6 {
68 SELECT level, segment, nentry, nentrytombstone FROM fts5_structure((
69 SELECT block FROM ft_data WHERE id=10
70 ))
71 } {1 0 1 0}
72
73 #--------------------------------------------------------------------------
74 reset_db
75 db func document document
76
77 do_execsql_test 2.0 {
78 CREATE VIRTUAL TABLE ft USING fts5(x, content='', contentless_delete=1);
79 }
80
81 do_test 2.1 {
82 for {set ii 0} {$ii < 5000} {incr ii} {
83 execsql { INSERT INTO ft VALUES( document(12) ) }
84 }
85 } {}
86
87 do_execsql_test 2.2 {
88 SELECT sum(nentry) - sum(nentrytombstone) FROM fts5_structure((
89 SELECT block FROM ft_data WHERE id=10
90 ))
91 } {5000}
92
93 for {set ii 5000} {$ii >= 0} {incr ii -100} {
94 do_execsql_test 2.3.$ii {
95 DELETE FROM ft WHERE rowid > $ii
96 }
97 do_execsql_test 2.3.$ii.2 {
98 SELECT
99 CAST((total(nentry) - total(nentrytombstone)) AS integer)
100 FROM
101 fts5_structure( (SELECT block FROM ft_data WHERE id=10) )
102 } $ii
103 }
104
105 execsql_pp {
106 SELECT * FROM fts5_structure((
107 SELECT block FROM ft_data WHERE id=10
108 ))
109 }
110
111 do_test 2.4 {
112 for {set ii 0} {$ii < 5000} {incr ii} {
113 execsql { INSERT INTO ft VALUES( document(12) ) }
114 }
115 } {}
116
117 for {set ii 1} {$ii <= 5000} {incr ii 10} {
118 do_execsql_test 2.3.$ii {
119 DELETE FROM ft WHERE rowid = $ii;
120 INSERT INTO ft VALUES( document(12) );
121 INSERT INTO ft(ft, rank) VALUES('merge', -10);
122 }
123
124 do_execsql_test 2.3.$ii.2 {
125 SELECT
126 CAST((total(nentry) - total(nentrytombstone)) AS integer)
127 FROM
128 fts5_structure( (SELECT block FROM ft_data WHERE id=10) )
129 } 5000
130 }
131
132 #-------------------------------------------------------------------------
133 reset_db
134 db func document document
135 do_execsql_test 3.0 {
136 CREATE VIRTUAL TABLE ft USING fts5(x, content='', contentless_delete=1);
137 WITH s(i) AS (
138 SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<100
139 )
140 INSERT INTO ft SELECT document(12) FROM s;
141 }
142
143 do_catchsql_test 3.1 {
144 INSERT INTO ft(ft, rank) VALUES('deletemerge', 'text');
145 } {1 {SQL logic error}}
146 do_catchsql_test 3.2 {
147 INSERT INTO ft(ft, rank) VALUES('deletemerge', 50);
148 } {0 {}}
149 do_execsql_test 3.3 {
150 SELECT * FROM ft_config WHERE k='deletemerge'
151 } {deletemerge 50}
152 do_catchsql_test 3.4 {
153 INSERT INTO ft(ft, rank) VALUES('deletemerge', 101);
154 } {0 {}}
155 do_execsql_test 3.5 {
156 SELECT * FROM ft_config WHERE k='deletemerge'
157 } {deletemerge 101}
158
159 do_execsql_test 3.6 {
160 DELETE FROM ft WHERE rowid<95
161 }
162
163 do_execsql_test 3.7 {
164 SELECT nentrytombstone, nentry FROM fts5_structure((
165 SELECT block FROM ft_data WHERE id=10
166 ))
167 } {94 100}
168
169 do_execsql_test 3.8 {
170 DELETE FROM ft WHERE rowid=95
171 }
172
173 do_execsql_test 3.9 {
174 SELECT nentrytombstone, nentry FROM fts5_structure((
175 SELECT block FROM ft_data WHERE id=10
176 ))
177 } {95 100}
178
179 do_execsql_test 3.10 {
180 DELETE FROM ft;
181 WITH s(i) AS (
182 SELECT 1 UNION ALL SELECT i+1 FROM s WHERE i<100
183 )
184 INSERT INTO ft SELECT document(12) FROM s;
185 INSERT INTO ft(ft, rank) VALUES('deletemerge', 50);
186 }
187
188 do_execsql_test 3.11 {
189 DELETE FROM ft WHERE rowid<95
190 }
191
192 do_execsql_test 3.12 {
193 SELECT nentrytombstone, nentry FROM fts5_structure((
194 SELECT block FROM ft_data WHERE id=10
195 ))
196 } {0 6}
197
198 #-------------------------------------------------------------------------
199 reset_db
200 db func document document
201 do_execsql_test 4.0 {
202 CREATE VIRTUAL TABLE x1 USING fts5(x, content='', contentless_delete=1);
203 INSERT INTO x1(x1, rank) VALUES('usermerge', 16);
204 INSERT INTO x1(x1, rank) VALUES('deletemerge', 40);
205 INSERT INTO x1 VALUES('one');
206 INSERT INTO x1 VALUES('two');
207 INSERT INTO x1 VALUES('three');
208 INSERT INTO x1 VALUES('four');
209 INSERT INTO x1 VALUES('five');
210 INSERT INTO x1 VALUES('six');
211 INSERT INTO x1 VALUES('seven');
212 INSERT INTO x1 VALUES('eight');
213 INSERT INTO x1 VALUES('nine');
214 INSERT INTO x1 VALUES('ten');
215 }
216
217 do_execsql_test 4.1 {
218 SELECT level, segment FROM fts5_structure((
219 SELECT block FROM x1_data WHERE id=10
220 ))
221 } {
222 0 0 0 1 0 2 0 3 0 4 0 5 0 6 0 7 0 8 0 9
223 }
224
225 for {set ii 1} {$ii < 4} {incr ii} {
226 do_execsql_test 4.2.$ii {
227 DELETE FROM x1 WHERE rowid = $ii;
228 INSERT INTO x1(x1, rank) VALUES('merge', 5);
229 SELECT level, segment FROM fts5_structure((
230 SELECT block FROM x1_data WHERE id=10
231 ))
232 } {
233 0 0 0 1 0 2 0 3 0 4 0 5 0 6 0 7 0 8 0 9
234 }
235 }
236
237 do_execsql_test 4.3 {
238 DELETE FROM x1 WHERE rowid = $ii;
239 INSERT INTO x1(x1, rank) VALUES('merge', 5);
240 SELECT level, segment, nentry FROM fts5_structure((
241 SELECT block FROM x1_data WHERE id=10
242 ))
243 } {
244 1 0 6
245 }
246
247 finish_test