Home
last modified time | relevance | path

Searched refs:val (Results 1 – 25 of 77) sorted by relevance

1234

/sqlite-3.40.0/test/
H A Ddecimal.test54 CREATE TABLE t1(seq INTEGER PRIMARY KEY, val TEXT);
71 AND decimal_cmp(a.val,b.val)>=0;
77 AND decimal_cmp(a.val,b.val)==0;
83 AND decimal_cmp(a.val,b.val)<=0;
86 SELECT seq FROM t1 ORDER BY val COLLATE decimal;
93 CREATE TABLE t3(seq INTEGER PRIMARY KEY, val TEXT);
95 INSERT INTO t3(seq, val) SELECT x, x FROM c;
98 SELECT decimal(val) FROM t3 ORDER BY seq;
108 SELECT decimal_sum(val) FROM t3;
111 SELECT decimal_sum(decimal_add(val,val||'e+10')) FROM t3;
[all …]
H A Dtkt3493.test23 CREATE TABLE A (id INTEGER PRIMARY KEY AUTOINCREMENT, val TEXT);
26 CREATE TABLE B (id INTEGER PRIMARY KEY AUTOINCREMENT, val TEXT);
39 WHEN B.val = 1 THEN 'XYZ'
40 ELSE A.val
52 WHEN B.val = 1 THEN 'XYZ'
53 ELSE A.val
63 SELECT b.val, CASE WHEN b.val = 1 THEN 'xyz' ELSE b.val END AS col1 FROM b;
69 b.val,
70 CASE WHEN b.val = 1 THEN 'xyz' ELSE b.val END AS col1
77 b.val,
[all …]
H A DwindowC.test53 SELECT group_concat('val', x) OVER ( ORDER BY i $win ) AS val FROM x1
55 if {[string range $val 0 2]!="val"
56 || [string range $val end-2 end]!="val"
58 error "unexpected return value: $val"
H A Dcorrupt4.test106 binary scan $bin S val
107 set val
112 binary scan $bin I val
113 set val
115 proc put4byte {fd offset val} {
117 set bin [binary format I $val]
H A Dwapp.tcl309 proc wapp-content-security-policy {val} {
314 dict set wapp .csp $val
726 foreach {nm val} [dict get $wapp .new-cookies] {
731 set val [wappInt-enc-url $val]
732 puts $chan "Set-Cookie: $nm=$val; HttpOnly; Path=/\r"
828 foreach {nm val} [split $hdr \000] {
830 dict set W $nm $val
959 if {[regexp {^.D([^=]+)=(.*)$} $term all var val]} {
960 set ::$var $val
H A Dtypes.test81 foreach val $values {
82 set lit [lindex $val 0]
89 } [lrange $val 1 end]
100 foreach val $values {
101 set lit [lindex $val 0]
108 } [lrange $val 1 end]
119 foreach val $values {
120 set lit [lindex $val 0]
126 } [lrange $val 1 end]
H A Denc4.test63 foreach val $vals {
65 set part [expr $init + [string range $val 0 [expr $x-1]]]
69 sqlite3_bind_text $S 1 $val $x
76 sqlite3_bind_text16 $S 1 [encoding convertto unicode $val] [expr $x*2]
H A De_blobclose.test96 proc val {} {
100 db func val val
106 execsql { INSERT INTO x1 VALUES(15, val()) }
119 execsql { SELECT a, val() FROM x1 LIMIT 1 }
H A Dtkt2332.test33 set val "[expr rand()][expr rand()][expr rand()][expr rand()][expr rand()]"
35 [string repeat $val [expr ($Len/[string length $val])+1]] 0 [expr $Len-1]
H A Dfts4growth2.test35 proc tt {val} {
38 WHERE docid IN (SELECT docid FROM t1 WHERE (rowid-1)%4==$val+0);
42 SELECT docid, words FROM t1 WHERE (rowid%4)==$val+0;
H A Dalterqf.test45 4 {CREATE VIEW v1 AS SELECT "val", count("b") FROM t1 GROUP BY "abc"}
46 {CREATE VIEW v1 AS SELECT 'val', count("b") FROM t1 GROUP BY 'abc'}
51 6 {CREATE INDEX i1 ON t1(a || "str", "b", "val")}
52 {CREATE INDEX i1 ON t1(a || 'str', "b", 'val')}
/sqlite-3.40.0/ext/wasm/api/
H A Dsqlite3-api-oo1.js1251 affirmSupportedBindType(val);
1254 switch((null===val || undefined===val) ? BindTypes.null : bindType){
1264 else if('bigint'===typeof val){
1265 if(!util.bigIntFits64(val)){
1266 f._tooBigInt(val);
1270 val = Number(val);
1273 f._tooBigInt(val);
1276 val = Number(val);
1283 rc = m(stmt.pointer, ndx, val);
1290 if('string'===typeof val){
[all …]
H A Dsqlite3-api-glue.js229 const __udfSetResult = function(pCtx, val){ argument
231 switch(typeof val) {
236 capi.sqlite3_result_int(pCtx, val ? 1 : 0);
240 if(util.bigIntFits64(val)) capi.sqlite3_result_int64(pCtx, val);
242 }else if(util.bigIntFits32(val)){
244 }else if(util.bigIntFitsDouble(val)){
251 (util.isInt32(val)
253 : capi.sqlite3_result_double)(pCtx, val);
263 }else if(util.isBindableTypedArray(val)){
266 pCtx, pBlob, val.byteLength,
[all …]
/sqlite-3.40.0/src/
H A Dtest_hexio.c205 int val; in hexio_get_int() local
228 val = (aNum[0]<<24) | (aNum[1]<<16) | (aNum[2]<<8) | aNum[3]; in hexio_get_int()
229 Tcl_SetObjResult(interp, Tcl_NewIntObj(val)); in hexio_get_int()
245 int val; in hexio_render_int16() local
253 aNum[0] = val>>8; in hexio_render_int16()
254 aNum[1] = val; in hexio_render_int16()
272 int val; in hexio_render_int32() local
280 aNum[0] = val>>24; in hexio_render_int32()
281 aNum[1] = val>>16; in hexio_render_int32()
282 aNum[2] = val>>8; in hexio_render_int32()
[all …]
H A Dtest5.c70 Mem val; in test_value_overhead() local
81 val.flags = MEM_Str|MEM_Term|MEM_Static; in test_value_overhead()
82 val.z = "hello world"; in test_value_overhead()
83 val.enc = SQLITE_UTF8; in test_value_overhead()
87 sqlite3_value_text(&val); in test_value_overhead()
H A Dhwtime.h51 unsigned long val;
52 __asm__ __volatile__ ("rdtsc" : "=A" (val));
53 return val;
H A Dvdbeapi.c1219 const void *val; in sqlite3_column_blob() local
1220 val = sqlite3_value_blob( columnMem(pStmt,i) ); in sqlite3_column_blob()
1226 return val; in sqlite3_column_blob()
1231 return val; in sqlite3_column_bytes()
1236 return val; in sqlite3_column_bytes16()
1241 return val; in sqlite3_column_double()
1244 int val = sqlite3_value_int( columnMem(pStmt,i) ); in sqlite3_column_int() local
1246 return val; in sqlite3_column_int()
1251 return val; in sqlite3_column_int64()
1256 return val; in sqlite3_column_text()
[all …]
/sqlite-3.40.0/ext/lsm1/lsm-test/
H A Dlsmtest_tdb2.cc262 MDB_val val; in test_mdb_write() local
266 val.mv_size = nVal; in test_mdb_write()
267 val.mv_data = pVal; in test_mdb_write()
273 rc = mdb_put(txn, pMdb->dbi, &key, &val, 0); in test_mdb_write()
322 MDB_val val = {0, 0}; in test_mdb_fetch() local
323 rc = mdb_get(txn, pMdb->dbi, &key, &val); in test_mdb_fetch()
329 *ppVal = val.mv_data; in test_mdb_fetch()
330 *pnVal = val.mv_size; in test_mdb_fetch()
355 MDB_val val = {0, 0}; in test_mdb_scan() local
359 while( mdb_cursor_get(csr, &key, &val, op)==0 ){ in test_mdb_scan()
[all …]
/sqlite-3.40.0/ext/lsm1/
H A Dlsm_vtab.c934 lsm1_vblob val; in lsm1Update() local
961 memset(&val, 0, sizeof(val)); in lsm1Update()
967 lsm1VblobAppendVarint(&val, SQLITE_NULL); in lsm1Update()
973 lsm1VblobAppendVarint(&val, v*6); in lsm1Update()
977 lsm1VblobAppend(&val, pSpace, n); in lsm1Update()
984 lsm1VblobAppend(&val, (u8*)&r, sizeof(r)); in lsm1Update()
989 lsm1VblobAppendVarint(&val, n*6 + SQLITE_BLOB); in lsm1Update()
995 lsm1VblobAppendVarint(&val, n*6 + SQLITE_TEXT); in lsm1Update()
1001 if( val.errNoMem ){ in lsm1Update()
1004 rc = lsm_insert(p->pDb, pKey, nKey, val.a, val.n); in lsm1Update()
[all …]
/sqlite-3.40.0/tool/
H A Dshowshm.c64 int val = aData[ofst]; in print_decode_line() local
73 val = val*256 + aData[ofst+j]; in print_decode_line()
85 memcpy(&val, aData+ofst, 4); in print_decode_line()
94 sprintf(&zBuf[i], " 0x%08x", val); in print_decode_line()
96 sprintf(&zBuf[i], " %9d", val); in print_decode_line()
H A Dshowjournal.c53 unsigned val = aData[ofst]; in print_decode_line() local
62 val = val*256 + aData[ofst+j]; in print_decode_line()
66 sprintf(&zBuf[i], " %10u", val); in print_decode_line()
68 return val; in print_decode_line()
H A Dmkpragmatab.tcl448 foreach {id val} [split $line :] break
449 set val [string trim $val]
452 set name $val
453 set type [string toupper $val]
455 set type $val
460 set arg $val
462 set cols $val
464 lappend if $val
466 foreach term [split $val] {
H A Dmkopcodeh.tcl96 set val $tk($sym)
97 set op($name) $val
98 set used($val) 1
99 set sameas($val) $sym
100 set def($val) $name
/sqlite-3.40.0/ext/session/
H A Dtest_session.c312 int val; in test_session_cmd() local
313 if( Tcl_GetIntFromObj(interp, objv[2], &val) ) return TCL_ERROR; in test_session_cmd()
314 val = sqlite3session_enable(pSession, val); in test_session_cmd()
315 Tcl_SetObjResult(interp, Tcl_NewBooleanObj(val)); in test_session_cmd()
320 int val; in test_session_cmd() local
321 if( Tcl_GetIntFromObj(interp, objv[2], &val) ) return TCL_ERROR; in test_session_cmd()
322 val = sqlite3session_indirect(pSession, val); in test_session_cmd()
323 Tcl_SetObjResult(interp, Tcl_NewBooleanObj(val)); in test_session_cmd()
328 int val; in test_session_cmd() local
329 val = sqlite3session_isempty(pSession); in test_session_cmd()
[all …]
/sqlite-3.40.0/ext/wasm/fiddle/
H A Dfiddle.js765 const newOpt = function(lbl,val){ argument
767 if(Array.isArray(val)) val = val.join('');
768 o.value = val;
769 if(!val) o.setAttribute('disabled',true);

1234