Home
last modified time | relevance | path

Searched refs:str (Results 1 – 25 of 74) sorted by relevance

123

/sqlite-3.40.0/test/
H A Dalterqf.test48 5 {CREATE TABLE xyz(a CHECK (a!="str"), b AS (a||"str"))}
49 {CREATE TABLE xyz(a CHECK (a!='str'), b AS (a||'str'))}
51 6 {CREATE INDEX i1 ON t1(a || "str", "b", "val")}
52 {CREATE INDEX i1 ON t1(a || 'str', "b", 'val')}
67 SELECT max("str", new."a") FROM t1
68 WHERE group_concat("b", ",") OVER (ORDER BY c||"str");
69 UPDATE t1 SET c= b + "str";
75 SELECT max('str', new."a") FROM t1
76 WHERE group_concat("b", ',') OVER (ORDER BY c||'str');
77 UPDATE t1 SET c= b + 'str';
H A DcorruptF.test26 proc str {i} { format %08d $i }
36 db func str str
44 INSERT INTO t1 VALUES(str(1));
45 INSERT INTO t1 SELECT str(rowid+1) FROM t1;
46 INSERT INTO t1 SELECT str(rowid+2) FROM t1;
47 INSERT INTO t1 SELECT str(rowid+4) FROM t1;
48 INSERT INTO t1 SELECT str(rowid+8) FROM t1;
49 INSERT INTO t1 SELECT str(rowid+16) FROM t1;
50 INSERT INTO t1 SELECT str(rowid+32) FROM t1;
51 INSERT INTO t1 SELECT str(rowid+64) FROM t1;
H A Dcapi3e.test34 # Return the UTF-16 representation of the supplied UTF-8 string $str.
36 proc utf16 {str {nt 1}} {
37 set r [encoding convertto unicode $str]
44 # Return the UTF-8 representation of the supplied UTF-16 string $str.
45 proc utf8 {str} {
46 # If $str ends in two 0x00 0x00 bytes, knock these off before
48 binary scan $str \c* vals
50 set str [binary format \c* [lrange $vals 0 end-2]]
53 set r [encoding convertfrom unicode $str]
H A Dincrvacuum.test140 CREATE TABLE tbl2(str);
141 INSERT INTO tbl2 VALUES($::str);
178 INSERT INTO tbl2 VALUES($::str);
220 INSERT INTO tbl1 VALUES($::str);
230 INSERT INTO tbl1 VALUES($::str);
755 INSERT INTO t1 VALUES('a', $str);
756 INSERT INTO t1 VALUES('b', $str);
757 INSERT INTO t1 VALUES('c', $str);
758 INSERT INTO t1 VALUES('d', $str);
759 INSERT INTO t1 VALUES('e', $str);
[all …]
H A Dfts4lastrowid.test25 CREATE VIRTUAL TABLE t1 USING fts4(str);
45 INSERT INTO t1(rowid, str) VALUES(-22, 'some more text');
51 INSERT INTO t1(rowid, str) VALUES(45, 'some more text');
52 INSERT INTO t1(rowid, str) VALUES(46, 'some more text');
53 INSERT INTO t1(rowid, str) VALUES(222, 'some more text');
67 INSERT INTO t1(rowid, str) SELECT rowid+10, x FROM x1;
H A Dprefixes.test76 WITH finder(str) AS (
81 WHERE k<=substr($INPUT, 1, prefix_length(finder.str, $INPUT))
82 ) FROM finder WHERE length(finder.str)>0
84 SELECT str FROM finder WHERE length(str)==prefix_length(str, $INPUT) LIMIT 1
H A Denc.test52 # $str is a string to use for testing (encoded in UTF-8, as normal for TCL).
81 proc test_conversion {testname str} {
84 set utf16le_sqlite3 [test_translate $str UTF8 UTF16LE]
85 set utf16le_tcl [encoding convertto unicode $str]
94 set utf16be_sqlite3 [test_translate $str UTF8 UTF16BE]
95 set utf16be_tcl [encoding convertto unicode $str]
110 do_bincmp_test $testname.3 $utf8_sqlite3 [binarize $str]
115 do_bincmp_test $testname.4.le $utf8_sqlite3 [binarize $str]
120 do_bincmp_test $testname.4.be $utf8_sqlite3 [binarize $str]
H A Dsortfault.test49 set str [string repeat a 1000]
59 SELECT 1, $::str
61 SELECT x+1, $::str FROM r
78 SELECT 100, $::str
80 SELECT x-1, $::str FROM r
90 set str2 [string repeat $str 10]
H A Dwapp.tcl175 proc wappInt-decode-url {str} {
176 set str [string map [list + { } "\\" "\\\\" \[ \\\[ \] \\\]] $str]
179 $str {[encoding convertfrom utf-8 [binary decode hex \1\2\3]]} str
182 $str {[encoding convertfrom utf-8 [binary decode hex \1\2]]} str
183 regsub -all -- {%([0-7][A-Fa-f0-9])} $str {\\u00\1} str
184 return [subst -novar $str]
H A DanalyzeF.test38 proc str {a} { return $a }
39 db func str str
59 9 "x = str('19') AND y = str('4')" {t1y (y=?)}
60 10 "x = str('4') AND y = str('19')" {t1y (y=?)}
H A Dvtab5.test81 CREATE TABLE strings(str COLLATE NOCASE);
86 SELECT str FROM strings ORDER BY 1;
92 SELECT str FROM echo_strings ORDER BY 1;
97 SELECT str||'' FROM echo_strings ORDER BY 1;
131 CREATE INDEX echo_strings_i ON echo_strings(str);
H A Dmalloc_common.tcl610 set str [join $answers " OR "]
621 if {[lsearch -exact $answers $res]>=0} { set res $str }
623 do_test "$name.$zName.$iLimit.$iFail" [list set {} $res] $str
677 set str [join $answers " OR "]
690 set res $str
692 do_test $name.$zName.$iFail [list set {} $res] $str
H A Dnumcast.test27 foreach {idx str rval ival} {
38 db eval {SELECT CAST($str AS real)}
41 db eval {SELECT CAST($str AS integer)}
H A DmallocK.test165 proc str {a} { return $a }
166 db func str -deterministic str
169 execsql { SELECT * FROM x2 WHERE x = str('19') AND y = str('4') }
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5unicode3.test121 set str {CREATE VIRTUAL TABLE f3 USING fts5(a, tokenize=}
122 append str {"unicode61 separators '}
124 append str [format %c $i]
126 append str {'");}
127 execsql $str
130 set str {CREATE VIRTUAL TABLE f5 USING fts5(a, tokenize=}
131 append str {"unicode61 tokenchars '}
133 append str [format %c $i]
135 append str {'");}
136 execsql $str
H A Dfts5rowid.test113 foreach str $strlist { execsql { INSERT INTO x2 VALUES($str) } }
118 set str [lindex $strlist $tn]
120 SELECT rowid FROM x2 WHERE x2 MATCH $str
144 foreach str $strlist { execsql { INSERT INTO x3 VALUES($str) } }
149 set str [lindex $strlist $tn]
151 SELECT rowid FROM x3 WHERE x3 MATCH $str
175 foreach str $strlist { execsql { INSERT INTO x4 VALUES($str) } }
H A Dfts5lastrowid.test25 CREATE VIRTUAL TABLE t1 USING fts5(str);
45 INSERT INTO t1(rowid, str) VALUES(-22, 'some more text');
51 INSERT INTO t1(rowid, str) VALUES(45, 'some more text');
52 INSERT INTO t1(rowid, str) VALUES(46, 'some more text');
53 INSERT INTO t1(rowid, str) VALUES(222, 'some more text');
67 INSERT INTO t1(rowid, str) SELECT rowid+10, x FROM x1;
H A Dfts5fault5.test52 set str [string repeat "abc " 50]
55 INSERT INTO tt(rowid, x) SELECT i, $str FROM ii;
85 set str [string repeat "$i " 50]
86 execsql { INSERT INTO tt VALUES($str) }
87 execsql { INSERT INTO tt2 VALUES($str) }
/sqlite-3.40.0/src/
H A Dfunc.c281 StrAccum str; in printfFunc() local
293 n = str.nChar; in printfFunc()
1127 sqlite3_str str; in quoteFunc() local
1132 sqlite3QuoteValue(&str,argv[0]); in quoteFunc()
1133 sqlite3_result_text(context, sqlite3StrAccumFinish(&str), str.nChar, in quoteFunc()
1135 if( str.accError!=SQLITE_OK ){ in quoteFunc()
1874 pGCC->str.nChar = 0; in groupConcatInverse()
1876 pGCC->str.nChar -= nVS; in groupConcatInverse()
1877 memmove(pGCC->str.zText, &pGCC->str.zText[nVS], pGCC->str.nChar); in groupConcatInverse()
1879 if( pGCC->str.nChar==0 ){ in groupConcatInverse()
[all …]
H A Dwherecode.c151 str.printfFlags = SQLITE_PRINTF_INTERNAL; in sqlite3WhereExplainOneScan()
174 sqlite3_str_append(&str, " USING ", 7); in sqlite3WhereExplainOneScan()
176 explainIndexRange(&str, pLoop); in sqlite3WhereExplainOneScan()
208 sqlite3_str_appendf(&str, " LEFT-JOIN"); in sqlite3WhereExplainOneScan()
215 sqlite3_str_append(&str, " (~1 row)", 9); in sqlite3WhereExplainOneScan()
218 zMsg = sqlite3StrAccumFinish(&str); in sqlite3WhereExplainOneScan()
252 str.printfFlags = SQLITE_PRINTF_INTERNAL; in sqlite3WhereExplainBloomFilter()
260 sqlite3_str_appendf(&str, "rowid=?"); in sqlite3WhereExplainBloomFilter()
266 sqlite3_str_appendf(&str, "%s=?", z); in sqlite3WhereExplainBloomFilter()
269 sqlite3_str_append(&str, ")", 1); in sqlite3WhereExplainBloomFilter()
[all …]
H A Dtclsqlite.c643 Tcl_DString str; in DbTraceHandler() local
645 Tcl_DStringInit(&str); in DbTraceHandler()
647 Tcl_DStringAppendElement(&str, zSql); in DbTraceHandler()
649 Tcl_DStringFree(&str); in DbTraceHandler()
738 Tcl_DString str; in DbProfileHandler() local
742 Tcl_DStringInit(&str); in DbProfileHandler()
745 Tcl_DStringAppendElement(&str, zTm); in DbProfileHandler()
747 Tcl_DStringFree(&str); in DbProfileHandler()
1102 Tcl_DString str; in auth_callback() local
1152 Tcl_DStringInit(&str); in auth_callback()
[all …]
/sqlite-3.40.0/ext/wasm/common/
H A DSqliteTestUtil.js137 processUrlArgs: function(str) {
142 else str = (''+window.location.search).substring(1);
144 if( ! str ) return false;
145 … str = (''+str).split(/#/,2)[0]; // remove #... to avoid it being added as part of the last value.
147 const sp = str.split(/&+/);
H A Dwhwasmutil.js767 target.jstrlen = function(str){ argument
769 if('string'!==typeof str) return null;
770 const n = str.length;
773 let u = str.charCodeAt(i);
775 u = 0x10000 + ((u & 0x3FF) << 10) | (str.charCodeAt(++i) & 0x3FF);
905 target.jstrToUintArray = (str, addNul=false)=>{ argument
906 return cache.utf8Encoder.encode(addNul ? (str+"\0") : str);
/sqlite-3.40.0/ext/misc/
H A Dzipfile.c953 z_stream str; in zipfileInflate() local
954 memset(&str, 0, sizeof(str)); in zipfileInflate()
957 str.avail_in = nIn; in zipfileInflate()
959 str.avail_out = nOut; in zipfileInflate()
974 inflateEnd(&str); in zipfileInflate()
997 z_stream str; in zipfileDeflate() local
1000 memset(&str, 0, sizeof(str)); in zipfileDeflate()
1002 str.avail_in = nIn; in zipfileDeflate()
1011 str.next_out = aOut; in zipfileDeflate()
1012 str.avail_out = nAlloc; in zipfileDeflate()
[all …]
/sqlite-3.40.0/ext/wasm/jaccwabyt/
H A Djaccwabyt.js475 const __allocCString = function(str){ argument
476 const u = __utf8Encoder.encode(str);
478 if(!mem) toss("Allocation error while duplicating string:",str);
494 const __setMemberCString = function(obj, memberName, str){ argument
499 const mem = __allocCString(str);
543 setMemberCString: rop(function(memberName, str){ argument
544 return __setMemberCString(this, memberName, str);

123