| /sqlite-3.40.0/src/ |
| H A D | test_md5.c | 61 unsigned char in[64]; member
218 byteReverse(ctx->in, 16); in MD5Update()
236 memcpy(ctx->in, buf, len); in MD5Update()
252 p = ctx->in + count; in MD5Final()
266 memset(ctx->in, 0, 56); in MD5Final()
271 byteReverse(ctx->in, 14); in MD5Final()
353 FILE *in; in md5file_cmd() local
373 in = fopen(argv[1],"rb"); in md5file_cmd()
374 if( in==0 ){ in md5file_cmd()
379 fseek(in, ofst, SEEK_SET); in md5file_cmd()
[all …]
|
| /sqlite-3.40.0/test/ |
| H A D | in.test | 21 do_test in-1.0 {
37 do_test in-1.1 {
40 do_test in-1.2 {
43 do_test in-1.3 {
46 do_test in-1.4 {
49 do_test in-1.6 {
52 do_test in-1.7 {
67 do_test in-2.1 {
70 do_test in-2.2 {
73 do_test in-2.3 {
[all …]
|
| H A D | threadtest3.c | 148 unsigned char in[64]; member
191 MD5STEP(F1, a, b, c, d, in[ 0]+0xd76aa478, 7); in MD5Transform()
307 byteReverse(ctx->u.in, 16); in MD5Update()
316 memcpy(ctx->u.in, buf, 64); in MD5Update()
317 byteReverse(ctx->u.in, 16); in MD5Update()
325 memcpy(ctx->u.in, buf, len); in MD5Update()
341 p = ctx->u.in + count; in MD5Final()
351 byteReverse(ctx->u.in, 16); in MD5Final()
355 memset(ctx->u.in, 0, 56); in MD5Final()
360 byteReverse(ctx->u.in, 14); in MD5Final()
[all …]
|
| H A D | randexpr1.test | 143 …in (t1.d,coalesce((select max(11) from t1 where f not between 13 and c-coalesce((select max(d) fro…
146 …in (t1.d,coalesce((select max(11) from t1 where f not between 13 and c-coalesce((select max(d) fro…
149 …in (t1.d,coalesce((select max(11) from t1 where f not between 13 and c-coalesce((select max(d) fro…
1121 …in (e,(17),t1.d))) or not exists(select 1 from t1 where e not in (d,t1.f,11) and -t1.a>t1.b) or t…
1124 …in (e,(17),t1.d))) or not exists(select 1 from t1 where e not in (d,t1.f,11) and -t1.a>t1.b) or t…
1127 …in (e,(17),t1.d))) or not exists(select 1 from t1 where e not in (d,t1.f,11) and -t1.a>t1.b) or t…
1709 …in (select case case coalesce((select max(t1.b) from t1 where t1.f not between case when -b in (1…
1712 …in (select case case coalesce((select max(t1.b) from t1 where t1.f not between case when -b in (1…
1715 …in (select case case coalesce((select max(t1.b) from t1 where t1.f not between case when -b in (1…
5510 …in (coalesce((select d from t1 where t1.a not in (t1.c+f, -f,19) and t1.b in (select max(t1.d)+min…
[all …]
|
| H A D | shell5.test | 90 close $in
100 close $in
109 close $in
118 close $in
131 close $in
141 close $in
152 close $in
167 close $in
180 close $in
196 close $in
[all …]
|
| H A D | strict2.test | 51 } {{non-INT value in t1.a}}
55 } {{non-INT value in t1.a}}
59 } {{non-INT value in t1.a}}
63 } {{non-INT value in t1nn.a}}
67 } {{non-INT value in t1nn.a}}
71 } {{non-INT value in t1nn.a}}
97 } {{NULL value in t1nn.b}}
103 } {{non-TEXT value in t1.c}}
107 } {{non-TEXT value in t1.c}}
111 } {{non-TEXT value in t1.c}}
[all …]
|
| H A D | alterdropcol2.test | 91 error in table x1 after drop column: no such column: c
102 error in index idx after drop column: no such column: z 1
110 error in index idx after drop column: no such column: a
121 error in index i1 after drop column: no such column: a
132 error in table x1234 after drop column: no such column: a
143 error in table c1 after drop column: unknown column "v" in foreign key definition
153 error in table c1 after drop column: no such column: v
160 error in table c1 after drop column: no such column: u
174 error in trigger tr1 after drop column: no such column: new.w
182 error in view v1 after drop column: no such column: w
[all …]
|
| H A D | genesis.tcl | 206 …SERT INTO t1(docid,words) VALUES(1007022,'All in whose nostrils was the breath of life, of all tha…
219 INSERT INTO t1(docid,words) VALUES(1008011,'And the dove came in to him in the evening; and, lo, in…
345 INSERT INTO t1(docid,words) VALUES(1013002,'And Abram was very rich in cattle, in silver, and in go…
366 …in the fourteenth year came Chedorlaomer, and the kings that were with him, and smote the Rephaims…
400 …cid,words) VALUES(1015015,'And thou shalt go to thy fathers in peace; thou shalt be buried in a go…
450 …) VALUES(1018001,'And the LORD appeared unto him in the plains of Mamre: and he sat in the tent do…
512 …t up out of Zoar, and dwelt in the mountain, and his two daughters with him; for he feared to dwel…
1109 …NTO t1(docid,words) VALUES(1037001,'And Jacob dwelt in the land wherein his father was a stranger,…
1242 …NSERT INTO t1(docid,words) VALUES(1041022,'And I saw in my dream, and, behold, seven ears came up …
1257 INSERT INTO t1(docid,words) VALUES(1041037,'And the thing was good in the eyes of Pharaoh, and in t…
[all …]
|
| H A D | strict1.test | 57 } {1 {cannot store TEXT value in INT column t1.a}}
60 } {1 {cannot store TEXT value in INTEGER column t1.b}}
63 } {1 {cannot store TEXT value in BLOB column t1.c}}
66 } {1 {cannot store BLOB value in TEXT column t1.d}}
69 } {1 {cannot store TEXT value in REAL column t1.e}}
78 } {1 {cannot store REAL value in INT column t1.a}}
81 } {1 {cannot store BLOB value in INT column t1.a}}
96 } {1 {cannot store TEXT value in BLOB column t1.c}}
105 } {1 {cannot store BLOB value in TEXT column t1.d}}
114 } {1 {cannot store TEXT value in REAL column t1.e}}
[all …]
|
| H A D | ossshell.c | 39 FILE *in; in main() local
70 in = fopen(zFilename, "rb"); in main()
71 if( in==0 ){ in main()
76 fseek(in, 0, SEEK_END); in main()
77 sz = ftell(in); in main()
78 rewind(in); in main()
84 if( fread(zBuf, sz, 1, in)!=1 ){ in main()
96 fclose(in); in main()
|
| H A D | pragma.test | 413 set in [open test.db r]
416 seek $in 0
418 close $in
435 } {{*** in database t2 ***
449 } {{*** in database t2 ***
455 } {{*** in database t2 ***
463 } {{*** in database t2 ***
549 …} {{non-unique entry in index t1a} {NULL value in t1x.a} {non-unique entry in index t1a} {NULL val…
552 } {{non-unique entry in index t1a} {NULL value in t1x.a} {non-unique entry in index t1a}}
555 } {{non-unique entry in index t1a} {NULL value in t1x.a}}
[all …]
|
| H A D | percentile.test | 28 foreach {in out} {
37 do_test percentile-1.1.$in {
38 execsql {SELECT percentile(x,$in) FROM t1}
47 foreach {in out} {
56 do_test percentile-1.3.$in {
57 execsql {SELECT percentile(x,$in) FROM t1}
70 # Input values in a random order
78 foreach {in out} {
87 do_test percentile-1.7.$in {
195 foreach {in out} {
[all …]
|
| H A D | date2.test | 12 # focus of this file is testing date and time functions used in
33 } {1 {non-deterministic use of date() in a CHECK constraint}}
46 } {1 {non-deterministic use of date() in a generated column}}
55 } {1 {non-deterministic use of date() in an index}}
68 } {1 {non-deterministic use of datetime() in an index}}
94 } {1 {non-deterministic use of date() in an index}}
102 } {1 {non-deterministic use of date() in an index}}
131 } {1 {non-deterministic use of datetime() in an index}}
134 } {1 {non-deterministic use of datetime() in an index}}
161 } {1 {non-deterministic use of julianday() in an index}}
[all …]
|
| H A D | fts2g.test | 8 # merging functions in the FTS2 module query logic.
33 # Empty left in docListExceptMerge().
38 # Empty right in docListExceptMerge().
43 # Empty left in docListPhraseMerge().
48 # Empty right in docListPhraseMerge().
53 # Empty left in docListOrMerge().
58 # Empty right in docListOrMerge().
63 # Empty left in docListAndMerge().
68 # Empty right in docListAndMerge().
87 # Empty left and right in docListOrMerge(). Each term matches neither
|
| /sqlite-3.40.0/doc/ |
| H A D | json-enhancements.md | 3 This document summaries enhancements to the SQLite JSON support added in
48 The type system in SQLite is more general. Functions in SQLite are able
58 functionality in SQLite.
63 in a bold font.
105 operand, in addition to a full JSON path expression.
107 Thus, a -> or ->> operator that works on MySQL will work in
108 SQLite. And a -> or ->> operator that works in PG will work in SQLite.
118 <tr><th>SQL expression <th>Works in MySQL?<th>Works in PG?<th>Works in SQLite
126 in SQLite. The json_extract() function, and all other built-in SQLite
136 The implementation was in a source file named ext/misc/json1.c in the
[all …]
|
| H A D | trusted-schema.md | 10 with expressions in the index list or in the WHERE clause. If the
16 The changes in this branch strive to make it easier for high-privilege
30 Direct-only elements, in contrast, might have cause side-effects and
32 in elements of the schema such as CHECK constraint, DEFAULT values,
33 generated columns, index expressions, or in the WHERE clause of a
38 Application-defined functions and virtual tables go in as Normal unless
47 is no harm in an attacker running the abs() function.
65 go in as "Normal" by default. For optimal security, we want those risky
68 functions and vtabs go in as Normal, but the application can switch them
112 <li> _builtin_ → 1 for built-in functions. 0 otherwise.
[all …]
|
| /sqlite-3.40.0/ |
| H A D | README.md | 19 found in a footer on the check-in comment for authorized mirrors.
20 The official check-in name can also be seen in the `manifest.uuid` file
22 Git-name, when communicating about an SQLite check-in.
33 * Latest trunk check-in as
44 tag or hash prefix in place of "release" in the URLs of the previous
73 First create a directory in which to place
144 Full-text search engine is in **ext/fts3**. The R-Tree engine is in
226 individual source file exceeds 32K lines in length.
230 SQLite is modular in design.
232 for details. Other documents that are useful in
[all …]
|
| H A D | aclocal.m4 | 71 [case `pwd` in
127 case $cc_temp in
197 case $host_os in
617 case $[1] in
1228 case $host in
1284 case $host in
1303 case $host in
3085 case $LD in
3278 case $host in
6438 case $p in
[all …]
|
| /sqlite-3.40.0/tool/ |
| H A D | mksqlite3internalh.tcl | 29 set in [open tsrc/sqlite3.h]
32 while {![eof $in]} {
33 set line [gets $in]
34 if {$line=="" && [eof $in]} break
38 close $in
101 set in [open $filename r]
102 while {![eof $in]} {
103 set line [gets $in]
123 close $in
|
| H A D | cg_anno.tcl | 10 set in [open "|cg_annotate --show=Ir --auto=yes --context=40 $argv" r]
16 while {![eof $in]} {
17 set line [string map {\t { }} [gets $in]]
49 close $in
50 set in [open sqlite3.c]
54 set pattern2 {^/\*+ Continuing where we left off in ([^ ]+) \*}
55 while {![eof $in]} {
56 set line [gets $in]
66 close $in
|
| H A D | genfkey.README | 15 An SQL foreign key is a constraint that requires that each row in
16 the "child" table corresponds to a row in the "parent" table. For
22 implies that for each row in table "child", there must be a row in
24 is true. The columns in the parent table are required to be either the
30 "MATCH FULL". "MATCH NONE" means that if any of the key columns in
33 must be true for every row of the child table in the above example is
40 Attempting to insert or update a row in the child table so that the
41 affected row violates this constraint results in an exception being
44 The effect of attempting to delete or update a row in the parent table
53 that the constraint becomes untrue for one or more rows in
[all …]
|
| H A D | mksqlite3h.tcl | 49 set in [open $TOP/VERSION]
50 set zVersion [string trim [read $in]]
51 close $in
104 set in [open $file]
105 if {![regexp {sqlite\.h\.in} $file]} {
108 while {![eof $in]} {
110 set line [string trimright [gets $in]]
151 close $in
152 if {![regexp {sqlite\.h\.in} $file]} {
|
| H A D | spaceanal.tcl | 220 nentry int, -- Number of entries in the BTree
608 statline {Page size in bytes} $pageSize
615 statline {Number of tables in the database} $ntable
624 statline {Size of the file in bytes} $file_bytes
705 Page size in bytes
710 Number of pages in the whole file
719 the total number of pages in the file.
725 divided by the total number of pages in the file.
732 Number of tables in the database
739 The total number of indices in the database.
[all …]
|
| /sqlite-3.40.0/autoconf/tea/tclconfig/ |
| H A D | tcl.m4 | 77 for i in \
157 for i in \
239 for i in \
316 for i in \
551 # in the Tcl build directory or the tclsh installed in a bin
609 # in the Tk build directory or the wish installed in a bin
1545 # files in compat/*.c is being linked in.
2787 case $i in
2796 # in Makefile.in as well
3286 for i in \
[all …]
|
| /sqlite-3.40.0/autoconf/ |
| H A D | INSTALL | 8 are permitted in any medium without royalty provided the copyright
20 below. The lack of an optional feature in a given package is not
22 in *note Makefile Conventions: (standards)Makefile Conventions.
46 The file `configure.ac' (or `configure.in') is used to create
104 by setting variables in the command line or in the environment. Here
119 source code in the directory that `configure' is in and in `..'. This
245 On Solaris, don't put `/usr/ucb' early in your `PATH'. This
248 in your `PATH', put it _after_ `/usr/bin'.
300 Variables not defined in a site shell script can be set in the
309 overridden in the site shell script).
[all …]
|