Home
last modified time | relevance | path

Searched refs:text (Results 1 – 25 of 217) sorted by relevance

123456789

/sqlite-3.40.0/test/
H A Dtkt1449.test36 …text(50) not null, PREVMODONNODEID text(50) null, ISSUEID text(50) not null, OBJECTID text(50) not…
38 …text(36) not null, OBJECTID text(50) null, ISSUEID text(50) null, DATASTREAM blob not null, CONTEN…
46 …text(50) not null, PREVMODONNODEID text(50) null, ISSUEID text(50) not null, OBJECTID text(50) not…
48 …text(50) not null, PREVMODONNODEID text(50) null, ISSUEID text(50) not null, OBJECTID text(50) not…
54 …text(50) not null, SENDERNODEID text(50) not null, RECIPIENTEMAILADDR text(200) not null, RECIPIEN…
60 …text(50) not null, PREVMODONNODEID text(50) null, ISSUEID text(50) not null, OBJECTID text(50) not…
64 …CREATE TABLE NODEREG(NODEID text(50) not null, USERID text(50) null, CREATETIME text(25) not null,…
66 …text(50) not null, OBJECTID text(50) not null, NODEID text(50) not null, USERID text(50) null, NOD…
69 …ITIONS(PARTITIONID text(50) not null, NAME text(100) not null, LDAPDN text(300) not null, SERVERNO…
72 …text(50) not null, PREVMODONNODEID text(50) null, ISSUEID text(50) not null, OBJECTID text(50) not…
[all …]
H A Dtkt-a8a0d2996a.test24 } {text text}
27 } {text text}
30 } {text text}
33 } {text text}
36 } {text text}
41 } {text text}
44 } {text text}
47 } {text text}
50 } {text text}
53 } {text text}
[all …]
H A Dptrchng.test59 SELECT pointer_change(y, 'text', 'noop', 'blob') FROM t1 WHERE x=1
64 SELECT pointer_change(y, 'blob', 'noop', 'text') FROM t1 WHERE x=1
70 SELECT pointer_change(y, 'text', 'noop', 'text16') FROM t1 WHERE x=1
91 SELECT pointer_change(y, 'text', 'noop', 'blob') FROM t1 WHERE x=3
96 SELECT pointer_change(y, 'blob', 'noop', 'text') FROM t1 WHERE x=3
127 SELECT pointer_change(y, 'text', 'noop', 'blob') FROM t1 WHERE x=2
132 SELECT pointer_change(y, 'blob', 'noop', 'text') FROM t1 WHERE x=2
159 SELECT pointer_change(y, 'text', 'noop', 'blob') FROM t1 WHERE x=4
164 SELECT pointer_change(y, 'blob', 'noop', 'text') FROM t1 WHERE x=4
194 SELECT pointer_change(y, 'text', 'bytes', 'text') FROM t1
[all …]
H A Dtypes.test12 # it tests that the different storage classes (integer, real, text etc.)
48 CREATE TABLE t1(i integer, n numeric, t text, o blob);
59 { 5.0 integer integer text real }
60 { 5.1 real real text real }
61 { 5 integer integer text integer }
62 { '5.0' integer integer text text }
63 { '5.1' real real text text }
64 { '-5.0' integer integer text text }
65 { '-5.0' integer integer text text }
66 { '5' integer integer text text }
[all …]
H A Dtransitive1.test141 …nSeconds double, totalTimeInSeconds double, thumbNailImage text, player text, playerState text, ty…
142 …text, strContent text, strScraper text, strHash text, scanRecursive integer, useFolderNames bool, …
145 …nteger primary key, idPath integer, strFilename text, playCount integer, lastPlayed text, dateAdde…
147 …text,c01 text,c02 text,c03 text,c04 text,c05 text,c06 text,c07 text,c08 text,c09 text,c10 text,c11…
150 …text/80379-4.jpg</thumb><thumb aspect="banner">http://thetvdb.com/banners/text/80379-2.jpg</thumb>…
169 …text,c01 text,c02 text,c03 text,c04 text,c05 text,c06 text,c07 text,c08 text,c09 text,c10 text,c11…
H A Dtable.test24 two text
32 two text
153 f4 text,
154 f5 text,
155 f6 text,
156 f7 text,
157 f8 text,
158 f9 text,
159 f10 text,
160 f11 text,
[all …]
H A Dcast.test35 execsql {SELECT CAST(x'616263' AS text)}
39 } text
66 execsql {SELECT CAST(NULL AS text)}
96 execsql {SELECT CAST(123 AS text)}
99 execsql {SELECT typeof(CAST(123 AS text))}
100 } text
126 execsql {SELECT CAST(123.456 AS text)}
130 } text
154 } text
156 execsql {SELECT CAST('123abc' AS text)}
[all …]
H A Denc3.test14 # to the native text representation.
64 SELECT CAST(a AS text) FROM t2 WHERE CAST(a AS text) LIKE 'abc%';
69 SELECT CAST(x'61006200630064006500' AS text);
75 WHERE CAST(a AS text) LIKE CAST(x'610062002500' AS text);
101 } {1 {attached databases must use the same text encoding as main database}}
H A DtriggerC.test473 1 integer 1 text 1 integer 1.0 real
475 1 integer 1 text 1 integer 1.0 real
512 -1 integer 7 text 7 integer 7.0 real
513 1 integer 7 text 7 integer 7.0 real
514 1 integer 7 text 7 integer 7.0 real
515 1 integer 8 text 8 integer 8.0 real
516 1 integer 7 text 7 integer 7.0 real
517 1 integer 8 text 8 integer 8.0 real
523 1 integer 8 text 8 integer 8.0 real
524 2 integer 8 text 8 integer 8.0 real
[all …]
H A Dnan.test97 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
103 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
109 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
115 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
121 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
127 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
132 SELECT CAST(x AS text), typeof(x) FROM t1;
250 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
255 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
308 db eval {SELECT CAST(x AS text), typeof(x) FROM t1}
[all …]
H A Dbind.test264 # UTF-8 text
275 } {text text text}
313 } {text text text}
320 # UTF-16 text
332 } {text text text}
357 } {text text text}
604 # Test the ability to bind text that contains embedded '\000' characters.
619 } {text 3 'abc' 10 X'6162630078797A007071'}
H A Dcollate4.test219 cksort {SELECT a FROM collate4t1 ORDER BY a COLLATE text}
228 cksort {SELECT a FROM collate4t1 ORDER BY a, b COLLATE text}
250 cksort {SELECT a FROM collate4t2 ORDER BY a COLLATE text}
259 cksort {SELECT a FROM collate4t2 ORDER BY a, b COLLATE text}
280 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text}
283 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b}
289 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text, b COLLATE text}
292 cksort {SELECT a FROM collate4t3 ORDER BY a COLLATE text DESC}
299 ORDER BY a COLLATE text DESC, b COLLATE nocase}
303 ORDER BY a COLLATE text DESC, b COLLATE nocase DESC}
[all …]
H A Dfts4lastrowid.test45 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');
H A Djson102.test170 } {{text}}
362 4 {"six"} json six text six text \
363 5 {[7,8]} json {[7,8]} text {[7,8]} json \
364 6 {{"b":9}} json {{"b":9}} text {{"b":9}} json \
385 3 {"six"} json six text six text \
386 4 {[7,8]} json {[7,8]} text {[7,8]} json \
387 5 {{"b":9}} json {{"b":9}} text {{"b":9}} json \
H A Dfts2n.test22 set text {
40 INSERT INTO t1(rowid, c) VALUES(1, $text);
112 # Version of text without "lorem".
113 regsub -all {[Ll]orem} $text '' ntext
118 INSERT INTO t2(rowid, c) VALUES(1, $text);
153 set bigtext $text
169 INSERT INTO t3(rowid, c) VALUES(1, $text);
H A Dtkt-8454a207b9.test14 # that a negative default value on an added text column actually comes
34 } {-123.0 text}
40 } {-123.5 text}
46 } {0 text}
H A Dfts3an.test22 set text {
40 INSERT INTO t1(rowid, c) VALUES(1, $text);
112 # Version of text without "lorem".
113 regsub -all {[Ll]orem} $text '' ntext
118 INSERT INTO t2(rowid, c) VALUES(1, $text);
153 set bigtext $text
169 INSERT INTO t3(rowid, c) VALUES(1, $text);
H A Daffinity2.test40 } {1 integer 2 text 03 text}
46 } {1 text 2 text 03 text}
H A Dquota-glob.test21 catch { unset text }
24 foreach {testnum pattern text ans} {
81 sqlite3_quota_glob $::pattern $::text
84 sqlite3_quota_glob $::pattern [string map {/ \\} $::text]
/sqlite-3.40.0/ext/wasm/common/
H A DSqliteTestUtil.js184 setStatus: function f(text){
186 f.last = { text: '', step: 0 }; property
193 if(text === f.last.text) return;
194 f.last.text = text;
200 if(text) {
202 f.ui.status.innerText = text;
/sqlite-3.40.0/ext/wasm/fiddle/
H A Dfiddle-worker.js353 setStatus: function f(text){
354 if(!f.last) f.last = { step: 0, text: '' };
355 else if(text === f.last.text) return;
356 f.last.text = text;
359 data:{step: ++f.last.step, text: text||null} property
H A Dfiddle.js231 echo: function f(text) {
241 if(arguments.length > 1) text = Array.prototype.slice.call(arguments).join(' ');
242 else if(1===arguments.length && Array.isArray(text)) text = text.join(' ');
248 if(null===text){/*special case: clear output*/
255 if(this.config.echoToConsole) console.log(text);
256 if(this.jqTerm) this.jqTerm.echo(text);
257 f._.value += text + "\n";
367 if(msg.text){
369 f.ui.status.innerText = msg.text;
/sqlite-3.40.0/ext/fts3/
H A DREADME.content4 Normally, in order to create a full-text index on a dataset, the FTS4
9 designed to extend FTS4 to support the creation of full-text indexes where:
18 the full-text index, the content option can sometimes be used to achieve
73 to the content table does not affect the full-text index. It is the
75 full-text index are consistent.
103 -- the text values "i j" and "k l".
105 -- The query uses the full-text index to discover that the MATCH
113 -- time containing the text values "xxx" and "yyy". This is because the
114 -- full-text index still indicates that the row with docid=3 matches
140 some users may wish to use database triggers to keep the full-text index
[all …]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5lastrowid.test45 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');
H A Dfts5synonym.test79 proc tcl_tokenize {tflags text} {
81 foreach {w iStart iEnd} [fts5_tokenize_split $text] {
103 proc tcl_tokenize {tflags text} {
104 foreach {w iStart iEnd} [fts5_tokenize_split $text] {
115 proc tcl_tokenize {tflags text} {
116 foreach {w iStart iEnd} [fts5_tokenize_split $text] {
283 proc tcl_tokenize {tflags text} {
284 foreach {w iStart iEnd} [fts5_tokenize_split $text] {
388 proc tcl_tokenize {tflags text} {
389 foreach {w iStart iEnd} [fts5_tokenize_split $text] {

123456789