Home
last modified time | relevance | path

Searched refs:pattern (Results 1 – 25 of 33) sorted by relevance

12

/sqlite-3.40.0/ext/fts5/test/
H A Dfts5prefix.test117 proc gmatch {col pattern} {
122 proc ghl {col pattern} {
139 foreach {tn pattern} {
164 "SELECT ghl($col, '$pattern') FROM t3 WHERE gmatch($col, '$pattern')"
176 set expr "gmatch($col1, '$pattern') OR gmatch($col2, '$pattern')"
183 set resq "SELECT ghl($col1, '$pattern'), ghl($col2, '$pattern')"
259 proc gmatch {col pattern} {
263 foreach {tn col pattern} {
268 set query "$col : $pattern"
284 proc gmatch {col pattern} {
[all …]
/sqlite-3.40.0/test/
H A Dtkt1443.test124 Items.Item as trove, UP.pattern as pattern
128 PerItems.item as pattern
144 ORDER BY +trove, +pattern
156 Items.Item as trove, UP.pattern as pattern
160 PerItems.item as pattern
176 ORDER BY +trove, +pattern
H A Dbc_common.tcl11 set pattern "$self?*"
13 set pattern [string map {\.exe {}} $pattern]
15 foreach file [glob -nocomplain $pattern] {
H A Dquota-glob.test20 catch { unset pattern }
24 foreach {testnum pattern text ans} {
81 sqlite3_quota_glob $::pattern $::text
84 sqlite3_quota_glob $::pattern [string map {/ \\} $::text]
H A DvtabH.test164 proc list_files { pattern } {
167 eval lappend names [glob -nocomplain -- $pattern]
176 return [sort_files [glob -nocomplain -- $pattern]]
202 proc contents {pattern} {
204 foreach f [list_files $pattern] {
H A Dsqllimits1.test754 # match the pattern "sqllimits1-11.*".
843 # maximum length of the pattern argument to the LIKE or GLOB operators.
847 # against the pattern).
853 set ::pattern [string repeat "A%" [expr $max/2]]
856 SELECT $::string LIKE $::pattern;
861 set ::pattern [string repeat "A%" [expr {($max/2) + 1}]]
864 SELECT $::string LIKE $::pattern;
866 } {1 {LIKE or GLOB pattern too complex}}
H A Dspeed1p.explain149 foreach pattern $::list {
150 db eval {SELECT count(*), avg(b) FROM t1 WHERE c LIKE $pattern}
153 explain {SELECT count(*), avg(b) FROM t1 WHERE c LIKE $pattern}
H A Dlike.test215 # The like optimization works even when the pattern is a bound parameter
287 # Partial optimization when the pattern does not end in '%'
317 # No optimization when the pattern begins with a wildcard.
622 # characters of the like pattern that happen to be quote characters.
961 # A COLLATE clause on the pattern does not change the result of a
987 # Adding a COLLATE clause to the pattern of a LIKE operator does nothing
H A Dfts4langid.test162 proc rowid_list {pattern} {
166 if {[string match "*$pattern*" $x] || [string match "*$pattern*" $y]} {
H A Dspeed1p.test145 foreach pattern $::list {
146 db eval {SELECT count(*), avg(b) FROM t1 WHERE c LIKE $pattern}
H A Din3.test70 # match the pattern ("SELECT <column> FROM <table>"), the following do
87 # not exactly match the pattern "SELECT <column> FROM <table>", in
H A Dbestindex3.test143 # Test the same pattern works with ordinary tables.
H A Dshell1.test296 # LIKE pattern TABLE.
410 # matching LIKE pattern TABLE.
572 # LIKE pattern TABLE.
664 # LIKE pattern TABLE.
H A De_expr.test905 # EVIDENCE-OF: R-16584-60189 The LIKE operator does a pattern matching
909 # operator contains the pattern and the left hand operand contains the
910 # string to match against the pattern.
915 # EVIDENCE-OF: R-55406-38524 A percent symbol ("%") in the LIKE pattern
922 # EVIDENCE-OF: R-30433-25443 An underscore ("_") in the LIKE pattern
969 # pattern to include literal percent or underscore characters.
H A Dlike3.test117 # the pattern '/%' or begins with the escape character.
H A Dpermutations.test1240 set pattern [string map {% *} [lindex $argv $i]]
1241 if {[string range $pattern 0 0]=="-"} break
1244 if {[lsearch $files $f]<0 && [string match $pattern $tail]} {
/sqlite-3.40.0/tool/
H A Dsoak1.tcl32 proc generate_makefile {pattern} { argument
40 foreach x $pattern {
54 proc scenario {id title pattern} { argument
58 generate_makefile $pattern
H A Dspaceanal.tcl127 set pattern $root_filename
128 append pattern {[0-3][0-9][0-9]}
129 foreach f [glob -nocomplain $pattern] {
134 set pattern [file rootname $root_filename]
135 append pattern {.[0-3][0-9][0-9]}
136 foreach f [glob -nocomplain $pattern] {
H A Dmkvsix.tcl580 set pattern {^#define\s+SQLITE_VERSION\s+"(.*)"$}
583 if {![regexp -line -- $pattern $data dummy version]} then {
H A Dgenfkey.README114 All triggers generated by this command have names that match the pattern
117 in the database with a name that matches this pattern. This allows the
/sqlite-3.40.0/contrib/
H A Dsqlitecon.tcl278 set pattern %
279 regexp {^.[a-z]+ +([^ ]+)} $cmd all pattern
282 set cmd "SELECT sql FROM sqlite_master WHERE tbl_name LIKE '$pattern'
284 WHERE tbl_name LIKE '$pattern' AND sql NOT NULL"
288 WHERE tbl_name LIKE '$pattern' AND sql NOT NULL"
292 set pattern %
293 regexp {^.[a-z]+ +([^ ]+)} $cmd all pattern
296 set cmd "SELECT sql FROM sqlite_master WHERE name LIKE '$pattern'
298 WHERE name LIKE '$pattern' AND sql NOT NULL"
302 WHERE name LIKE '$pattern' AND sql NOT NULL"
/sqlite-3.40.0/ext/rtree/
H A DrtreeE.test33 /* A tight pattern of small boxes near 0,0 */
39 /* A looser pattern of small boxes near 100, 0 */
45 /* A looser pattern of larger boxes near 0, 200 */
/sqlite-3.40.0/ext/icu/
H A DREADME.txt98 <string> REGEXP <re-pattern>
145 pattern in bytes (irrespective of encoding). The default value is
/sqlite-3.40.0/doc/
H A Dpager-invariants.txt66 (10) The pattern of bits in bytes 24 through 39 shall not repeat in less
/sqlite-3.40.0/ext/rbu/
H A Drbuvacuum2.test201 # The result pattern might be 00xxx or 0oxxx depending on which

12