Debian Codegraph @

ext/fts5/test/fts5contentless5.test

raw
1 # 2023 August 7
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 fts5contentless5
17
18 # If SQLITE_ENABLE_FTS5 is not defined, omit this file.
19 ifcapable !fts5 {
20 finish_test
21 return
22 }
23 unset -nocomplain res
24
25 do_execsql_test 1.0 {
26 CREATE VIRTUAL TABLE t1 USING fts5(a, b, c, content='', contentless_delete=1);
27 INSERT INTO t1 VALUES('A', 'B', 'C');
28 INSERT INTO t1 VALUES('D', 'E', 'F');
29 INSERT INTO t1 VALUES('G', 'H', 'I');
30 }
31
32 do_execsql_test 1.01 {
33 CREATE TABLE t2(x, y);
34 INSERT INTO t2 VALUES('x', 'y');
35 }
36
37 # explain_i "UPDATE t1 SET a='a' WHERE t1.rowid=1"
38 #breakpoint
39 #explain_i "UPDATE t1 SET a='a' FROM t2 WHERE t1.rowid=1 AND b IS NULL"
40
41 #breakpoint
42 #explain_i "UPDATE t1 SET a='a' WHERE b IS NULL AND rowid=?"
43
44 foreach {tn up err} {
45 1 "UPDATE t1 SET a='a', b='b', c='c' WHERE rowid=1" 0
46 2 "UPDATE t1 SET a='a', b='b' WHERE rowid=1" 1
47 3 "UPDATE t1 SET b='b', c='c' WHERE rowid=1" 1
48 4 "UPDATE t1 SET a='a', c='c' WHERE rowid=1" 1
49 5 "UPDATE t1 SET a='a', c='c' WHERE t1.rowid=1 AND b IS NULL" 1
50 6 "UPDATE t1 SET a='a' FROM t2 WHERE t1.rowid=1" 1
51 7 "UPDATE t1 SET a='a', b='b', c='c' FROM t2 WHERE t1.rowid=1" 0
52 } {
53
54 set res(0) {0 {}}
55 set res(1) {1 {cannot UPDATE a subset of columns on fts5 contentless-delete table: t1}}
56 do_catchsql_test 1.$tn $up $res($err)
57 }
58
59 #-------------------------------------------------------------------------
60 reset_db
61
62 proc random {n} { expr {abs(int(rand()*$n))} }
63 proc select_one {list} {
64 set n [llength $list]
65 lindex $list [random $n]
66 }
67 proc vocab {} {
68 list abc def ghi jkl mno pqr stu vwx yza
69 }
70 proc term {} {
71 select_one [vocab]
72 }
73 proc document {} {
74 set nTerm [expr [random 3] + 7]
75 set doc ""
76 for {set ii 0} {$ii < $nTerm} {incr ii} {
77 lappend doc [term]
78 }
79 set doc
80 }
81 db func document document
82
83 do_execsql_test 2.0 {
84 CREATE VIRTUAL TABLE ft USING fts5(a, contentless_delete=1, content='');
85 INSERT INTO ft(ft, rank) VALUES('pgsz', 64);
86 }
87
88 do_test 2.1 {
89 for {set ii 1} {$ii < 12} {incr ii} {
90 db transaction {
91 for {set jj 0} {$jj < 10} {incr jj} {
92 set doc [document]
93 execsql { INSERT INTO ft VALUES($doc); }
94 }
95 }
96 }
97 } {}
98
99 do_test 2.2 {
100 foreach r [db eval {SELECT rowid FROM ft}] {
101 execsql { DELETE FROM ft WHERE rowid=$r }
102 }
103 } {}
104
105 set doc [document]
106 do_execsql_test 2.3 {
107 INSERT INTO ft VALUES($doc)
108 }
109
110
111 finish_test