3 # The author disclaims copyright to this source code. In place of
4 # a legal notice, here is a blessing:
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.
10 #***********************************************************************
11 # This file implements regression tests for SQLite library. Specifically,
12 # it tests that the GLOB, LIKE and REGEXP operators are correctly exposed
13 # to virtual table implementations.
16 set testdir [file dirname $argv0]
17 source $testdir/tester.tcl
25 register_echo_module db
28 CREATE TABLE t6(a, b TEXT);
29 CREATE INDEX i6 ON t6(b, a);
30 CREATE VIRTUAL TABLE e6 USING echo(t6);
33 foreach {tn sql expect} {
34 1 "SELECT * FROM e6 WHERE b LIKE 'abc'" {
35 xBestIndex {SELECT rowid, a, b FROM 't6' WHERE b like ?}
36 xFilter {SELECT rowid, a, b FROM 't6' WHERE b like ?} abc
39 2 "SELECT * FROM e6 WHERE b GLOB 'abc'" {
40 xBestIndex {SELECT rowid, a, b FROM 't6' WHERE b glob ?}
41 xFilter {SELECT rowid, a, b FROM 't6' WHERE b glob ?} abc
52 #--------------------------------------------------------------------------
54 register_tclvar_module db
57 CREATE VIRTUAL TABLE vars USING tclvar;
58 SELECT * FROM vars WHERE name = 'xyz';
71 db func glob -argcount 2 gfunc
77 db func like -argcount 2 lfunc
83 db func regexp -argcount 2 rfunc
89 foreach ::tclvar_set_omit {0 1} {
90 foreach {tn expr res cnt} {
91 1 {value GLOB 'aban*'} {x3 abandon x4 abandonint} 2
92 2 {value LIKE '%ac%'} {x1 aback x7 backbone x8 backarrow} 300
93 3 {value REGEXP '^......$'} {x5 babble x6 baboon x9 castle} 30000
97 if {$::tclvar_set_omit} {set cnt 0}
99 do_test 2.$tclvar_set_omit.$tn.1 {
100 execsql "SELECT name, value FROM vars WHERE name MATCH 'x*' AND $expr"
103 do_test 2.$tclvar_set_omit.$tn.2 {
109 #-------------------------------------------------------------------------
113 register_fs_module db
114 do_execsql_test 3.0 {
115 SELECT name FROM fsdir WHERE dir = '.' AND name = 'test.db';
116 SELECT name FROM fsdir WHERE dir = '.' AND name = '.'
119 proc list_root_files {} {
120 if {$::tcl_platform(platform) eq "windows"} {
122 foreach name [glob -directory $::env(SystemDrive)/ -- *] {
123 if {[string index [file tail $name] 0] eq "."} continue
128 return [string map {/ {}} [glob /*]]
132 proc list_files { pattern } {
133 if {$::tcl_platform(platform) eq "windows"} {
135 foreach name [glob -nocomplain $pattern] {
136 if {[string index [file tail $name] 0] eq "."} continue
141 return [glob -nocomplain $pattern]
145 # Read all entries in the current directory.
147 proc contents {pattern} {
149 foreach f [list_files $pattern] {
151 if {[file isdir $f]} {
152 set res [concat $res [contents "$f/*"]]
158 set res [contents $pwd]
159 do_execsql_test 3.2 {
160 SELECT path FROM fstree WHERE path GLOB $pwd ORDER BY 1
163 # Add some sub-directories and files to the current directory.
166 catch { file delete -force subdir }
171 set dir [file dirname $path]
172 catch { file mkdir $dir }
173 set fd [open $path w]
174 puts -nonewline $fd [string repeat 1 $sz]
180 do_execsql_test 3.5 {
181 SELECT path, size FROM fstree WHERE path GLOB $pwd || '/subdir/*' ORDER BY 1
183 "$pwd/subdir/x1.txt" 143 \
184 "$pwd/subdir/x2.txt" 153 \
186 do_execsql_test 3.6 {
187 SELECT path, size FROM fstree WHERE path LIKE $pwd || '/subdir/%' ORDER BY 1
189 "$pwd/subdir/x1.txt" 143 \
190 "$pwd/subdir/x2.txt" 153 \
192 do_execsql_test 3.7 {
193 SELECT sum(size) FROM fstree WHERE path LIKE $pwd || '/subdir/%'
195 do_execsql_test 3.8 {
196 SELECT size FROM fstree WHERE path = $pwd || '/subdir/x1.txt'