Home
last modified time | relevance | path

Searched refs:quote (Results 1 – 25 of 106) sorted by relevance

12345

/sqlite-3.40.0/ext/lsm1/test/
H A Dlsm1_simple.test35 SELECT a, quote(b), quote(c), quote(d) FROM x1;
38 SELECT a, quote(lsm1_key), quote(lsm1_value) FROM x1;
43 SELECT a, quote(b), quote(c), quote(d) FROM x1;
48 SELECT a, quote(b), quote(c), quote(d) FROM x1;
51 SELECT quote(lsm1_key), printf('0x%x',a) FROM x1 WHERE a > 100000000;
56 SELECT a, quote(b), quote(c), quote(d) FROM x1;
86 SELECT quote(a), quote(b), quote(c), quote(d), '|' FROM x1;
89 SELECT quote(a), quote(lsm1_key), quote(lsm1_value), '|' FROM x1;
92 SELECT quote(a), quote(lsm1_key), quote(lsm1_value) FROM x1 WHERE a='12';
/sqlite-3.40.0/test/
H A Dquote.test19 set testprefix quote
23 do_test quote-1.0 {
29 do_test quote-1.1 {
32 do_test quote-1.2.1 {
35 do_test quote-1.2.2 {
38 do_test quote-1.2.3 {
41 do_test quote-1.3 {
46 do_test quote-1.3.1 {
67 do_test quote-1.4 {
73 do_test quote-1.5 {
[all …]
H A DwindowA.test36 SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
52 SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
68 SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
84 SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
100 SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
116 SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
132 SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
148 SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
164 SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
180 SELECT a, b, quote(d), group_concat(b,'') OVER w1 FROM t1
[all …]
H A Daffinity2.test95 SELECT quote(- x'ce'), quote(t0.c0), quote(- x'ce' >= t0.c0) FROM t0;
101 SELECT quote(+-+x'ce'), quote(t0.c0), quote(+-+x'ce' >= t0.c0) FROM t0;
107 SELECT quote(- 'ce'), quote(t0.c0), quote(- 'ce' >= t0.c0) FROM t0;
113 SELECT quote(+-+'ce'), quote(t0.c0), quote(+-+'ce' >= t0.c0) FROM t0;
H A Dtclsqlite.test736 SELECT quote( add_i(2, 3) );
737 SELECT quote( add_r(2, 3) );
738 SELECT quote( add_t(2, 3) );
739 SELECT quote( add_b(2, 3) );
740 SELECT quote( add_a(2, 3) );
752 SELECT quote( ret_i(2.5) );
753 SELECT quote( ret_r(2.5) );
754 SELECT quote( ret_t(2.5) );
755 SELECT quote( ret_b(2.5) );
756 SELECT quote( ret_a(2.5) );
[all …]
H A Ddbpage.test39 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage('main') ORDER BY pgno;
42 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage WHERE pgno=2;
45 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage WHERE pgno=4;
48 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage WHERE pgno=5;
51 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage WHERE pgno=0;
58 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage('aux1');
78 SELECT pgno, quote(substr(data,1,5)) FROM sqlite_dbpage('main') ORDER BY pgno;
H A Dfunc7.test25 SELECT quote(ceil(NULL)), ceil('-99.99');
204 SELECT round(ln(2),7), quote(ln(-2));
211 SELECT log(2,65536), log(10,100), quote(log(1,100)), quote(log(0,100));
214 SELECT log2(65536), quote(log2(-100)), quote(log2(0));
217 SELECT round(log10(2),7), log10(100), quote(log10(-100));
241 SELECT sqrt(4), round(sqrt(20),7), quote(sqrt(-16));
H A Dimposter1.test57 old.rowid, quote(old.a), quote(old.b), quote(old.c),
58 quote(old.d)));
63 new.rowid, quote(new.a), quote(new.b), quote(new.c),
64 quote(new.d)));
H A Dlike3.test81 SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY x;
84 SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY x DESC;
87 SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY +x DESC;
90 SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY x ASC;
93 SELECT quote(x) FROM t3 WHERE x LIKE 'ab%' ORDER BY +x ASC;
100 SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY x;
103 SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY x DESC;
106 SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY +x DESC;
109 SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY x ASC;
112 SELECT quote(x) FROM t4 WHERE x LIKE 'ab%' ORDER BY +x ASC;
H A Din6.test97 SELECT quote(v5) FROM v0 LEFT JOIN v3 ON v4 = NULL AND v5 IN(0);
110 SELECT quote(a), quote(b), '|' FROM t1 WHERE b in (SELECT a FROM t1) AND a=0;
115 SELECT quote(x), quote(a), quote(b), 'x'
H A Datof1.test47 # Verify that round-trip real->text->real conversions using the quote()
51 set y [db eval {SELECT $x=CAST(quote($x) AS real)}]
53 db eval {SELECT real2hex($x) a, real2hex(CAST(quote($x) AS real)) b} {}
55 puts [format {QUOTE: %16s %s} {} [db eval {SELECT quote($x)}]]
56 db eval {SELECT CAST(quote($x) AS real) c} {}
H A Dfts3prefix.test228 SELECT md5sum(quote(root)) FROM t1_segdir;
229 } [db eval {SELECT md5sum(quote(root)) FROM t2_segdir}]
239 SELECT md5sum(quote(root)) FROM t1_segdir;
240 } [db eval {SELECT md5sum(quote(root)) FROM t2_segdir}]
250 set one [db eval {SELECT md5sum(quote(root)) FROM t1_segdir}]
251 set two [db eval {SELECT md5sum(quote(root)) FROM t2_segdir}]
263 SELECT md5sum(quote(root)) FROM t1_segdir;
264 } [db eval {SELECT md5sum(quote(root)) FROM t2_segdir}]
274 SELECT md5sum(quote(root)) FROM t1_segdir;
275 } [db eval {SELECT md5sum(quote(root)) FROM t2_segdir}]
H A Ddbdata.test37 SELECT pgno, cell, field, quote(value) FROM sqlite_dbdata WHERE pgno=2;
49 SELECT pgno, cell, field, quote(value) FROM sqlite_dbdata;
77 SELECT quote(value) FROM sqlite_dbdata WHERE pgno=2 AND cell=0 AND field=1;
79 } [db one {SELECT quote(b) FROM t1}]
H A Dfts4record.test35 SELECT quote(root) FROM t1_segdir
44 select quote(
81 SELECT quote(root) FROM t1_segdir
101 SELECT quote(root) FROM t1_segdir
H A Djson105.test24 do_execsql_test json105-1.$testnum "SELECT quote(json_extract(j,$path)) FROM t1" $result
39 do_execsql_test json105-2.$testnum "SELECT quote(json_remove(j,$path)) FROM t1" $result
56 do_execsql_test json105-3.$testnum "SELECT quote(json_insert(j,$x)) FROM t1" $result
66 do_execsql_test json105-4.$testnum "SELECT quote(json_set(j,$x)) FROM t1" $result
82 do_execsql_test json105-5.$testnum "SELECT quote(json_replace(j,$x)) FROM t1" $result
H A Denc3.test37 SELECT quote(x) || ' ' || quote(y) FROM t1
50 SELECT quote(x) || ' ' || quote(y) FROM t1
H A Dfts4merge.test156 SELECT quote(value) FROM t4_stat WHERE rowid=1
203 do_execsql_test 5.4 {SELECT quote(value) from t1_stat WHERE rowid=1} {X'010F'}
210 do_execsql_test 5.6 {SELECT quote(value) from t1_stat WHERE rowid=1} {X'010F'}
214 SELECT quote(value) from t1_stat WHERE rowid=1;
226 SELECT quote(value) from t1_stat WHERE rowid=1;
245 SELECT quote(value) from t1_stat WHERE rowid=1;
253 SELECT quote(value) from t1_stat WHERE rowid=1;
H A Dfts3conf.test143 SELECT quote(matchinfo(t3, 'na')) FROM t3 WHERE t3 MATCH 'one'
148 SELECT quote(matchinfo(t3, 'na')) FROM t3 WHERE t3 MATCH 'four'
153 SELECT quote(matchinfo(t3, 'na')) FROM t3 WHERE t3 MATCH 'six'
158 SELECT quote(matchinfo(t3, 'na')) FROM t3 WHERE t3 MATCH 'six'
163 SELECT quote(matchinfo(t3, 'na')) FROM t3 WHERE t3 MATCH 'six'
168 SELECT quote(matchinfo(t3, 'na')) FROM t3 WHERE t3 MATCH 'one'
179 SELECT quote(matchinfo(t3, 'na')) FROM t3 WHERE t3 MATCH 'one'
H A Dfts4aa.test205 SELECT quote(matchinfo(t1, 'l')) FROM t1 WHERE t1 MATCH 'X Y';
214 SELECT quote(matchinfo(t1,'a')) FROM t1 WHERE t1 MATCH 'one two';
218 SELECT quote(matchinfo(t1,'a')) FROM t1 WHERE t1 MATCH 'one two';
222 SELECT quote(matchinfo(t1,'a')) FROM t1 WHERE t1 MATCH 'one two';
226 SELECT quote(matchinfo(t1,'a')) FROM t1 WHERE t1 MATCH 'one two';
242 SELECT quote(matchinfo(f,'pnax')) from f where f match '0 1';
H A De_createtable.test836 SELECT quote(x), quote(y), quote(z) FROM t1 ORDER BY rowid DESC LIMIT 1;
842 SELECT quote(a), quote(b), quote(c) FROM t2 ORDER BY rowid DESC LIMIT 1;
848 SELECT quote(o), quote(t) FROM t3 ORDER BY rowid DESC LIMIT 1;
863 SELECT quote(x), quote(y), quote(z) FROM t1
925 SELECT quote(a), quote(b), quote(c), quote(d), quote(e), quote(f),
926 quote(g), quote(h), quote(i), quote(j), quote(k)
962 SELECT quote(a), quote(b), quote(c), quote(d), quote(e) FROM t5;
982 SELECT quote(a), quote(b) FROM t6;
986 SELECT quote(a), quote(b) FROM t6;
990 SELECT quote(a), quote(b) FROM t6;
[all …]
H A Duserauth01.test29 SELECT quote(x) FROM t1 ORDER BY x;
39 SELECT quote(x) FROM t1 ORDER BY x;
52 SELECT quote(x) FROM t1 ORDER BY x;
67 SELECT quote(x) FROM t1 ORDER BY x;
92 SELECT quote(x) FROM t1 ORDER BY x;
/sqlite-3.40.0/ext/misc/
H A Ddbdump.c94 static void appendText(DText *p, char const *zAppend, char quote){ in appendText() argument
100 if( quote ){ in appendText()
103 if( zAppend[i]==quote ) len++; in appendText()
118 if( quote ){ in appendText()
120 *zCsr++ = quote; in appendText()
123 if( zAppend[i]==quote ) *zCsr++ = quote; in appendText()
125 *zCsr++ = quote; in appendText()
/sqlite-3.40.0/tool/
H A Dspaceanal.tcl188 db eval {SELECT quote(name) || ',' ||
189 quote(path) || ',' ||
190 quote(pageno) || ',' ||
191 quote(pagetype) || ',' ||
192 quote(ncell) || ',' ||
193 quote(payload) || ',' ||
194 quote(unused) || ',' ||
196 quote(pgoffset) || ',' ||
337 proc quote {txt} {
679 set qn [quote $tbl]
[all …]
/sqlite-3.40.0/src/
H A Dtest_osinst.c840 char quote; /* Quote character (if any ) */ in dequote() local
841 quote = z[0]; in dequote()
842 if( quote=='[' || quote=='\'' || quote=='"' || quote=='`' ){ in dequote()
845 if( quote=='[' ) quote = ']'; in dequote()
847 if( z[iIn]==quote ){ in dequote()
848 if( z[iIn+1]!=quote ) break; in dequote()
849 z[iOut++] = quote; in dequote()
/sqlite-3.40.0/ext/fts5/
H A Dfts5_config.c189 char quote; /* Quote character (if any ) */ in sqlite3Fts5Dequote() local
192 quote = z[0]; in sqlite3Fts5Dequote()
193 if( quote=='[' || quote=='\'' || quote=='"' || quote=='`' ){ in sqlite3Fts5Dequote()

12345