Home
last modified time | relevance | path

Searched refs:first (Results 1 – 25 of 249) sorted by relevance

12345678910

/sqlite-3.40.0/test/
H A Dtkt-a7b7803e.test24 INSERT INTO t1 VALUES(0,'first'),(99,'fuzzy');
29 } {1 first}
46 SELECT (a=99) AS x, (t1.b='first') AS y, *
51 } {0 1 0 first 1 0 99 fuzzy}
54 SELECT (M.a=99) AS x, M.b, (N.b='first') AS y, N.b
59 } {0 first 1 first 1 fuzzy 1 first 1 fuzzy 0 fuzzy}
62 SELECT (M.a=99) AS x, M.b, (N.b='first') AS y, N.b
67 } {1 fuzzy 1 first}
70 SELECT (M.a=99) AS x, M.b, (N.b='first') AS y, N.b
74 } {1 fuzzy 1 first}
[all …]
H A DjoinA.test73 ORDER BY 1 nulls first, 3 nulls first;
84 ORDER BY 1 nulls first, 3 nulls first;
99 ORDER BY 1 nulls first, 3 nulls first;
113 ORDER BY 1 nulls first, 3 nulls first;
128 ORDER BY 1 nulls first, 3 nulls first;
143 ORDER BY 1 nulls first, 3 nulls first;
158 ORDER BY 1 nulls first, 3 nulls first;
177 ORDER BY 1 nulls first, 3 nulls first;
195 ORDER BY 1 nulls first, 3 nulls first;
H A Dconflict3.test46 # Insert two rows where the second conflicts on C. The first row show go
76 # Insert two rows where the second conflicts on C. The first row show go
106 # Insert two rows where the second conflicts on C. The first row show go
136 # Insert two rows where the second conflicts on C. The first row show go
166 # Insert two rows where the second conflicts on C. The first row show go
196 # Insert two rows where the second conflicts on C. The first row show go
226 # Insert two rows where the second conflicts on C. The first row show go
256 # Insert two rows where the second conflicts on C. The first row show go
286 # Insert two rows where the second conflicts on C. The first row show go
316 # Insert two rows where the second conflicts on C. The first row show go
[all …]
H A DcorruptD.test36 # 1. The page header field that contains the offset to the first
39 # 2. The first two bytes of all but the last free block on the free-block
51 # 6. The first few bytes of each cell determine the size of the cell
109 # containing the offset of the first free block in a page.
125 # in the first 2 byte of each free-block on the free-list.
H A De_wal.test24 # locking_mode is set to EXCLUSIVE before the first attempted access.
82 # the first WAL-mode database access, then SQLite never attempts to call
112 # locking mode is to first change out of WAL journal mode.
135 # first WAL-mode database access, then the shared-memory wal-index is
165 # is omitted, when the locking mode is EXCLUSIVE prior to the first
H A Dtkt3810.test23 # Create a table using the first database connection.
46 # but the first connection does not yet know this. Then try to create a TEMP
47 # trigger in the first connection that references the table that was dropped.
H A Dcrash8.test60 # When the first process accessed the database again, it was rolling back
62 # was loaded before the second process made its first, successful,
83 # the first journal-header and set of subsequent records written by the
84 # first, successful, change. The second process crashes before it can
87 # When the first process accessed the database again, it was rolling back
89 # and subsequent journal-headers written by the first, successful, change.
131 # file if the sector-size field in the first journal file header is
H A Dtestrunner.tcl188 set first [lindex $patternlist 0]
189 if {$first=="all"} { set first "full" }
212 } elseif {[info exists ::testspec($first)]} {
213 set clist $first
429 if {$n==1 || ($n==2 && [string first [lindex $args 0] -nonewline]==0)} {
H A Drollback.test118 # Also, fix the first journal-header in the journal-file. Because the
120 # start of the first journal-header has not been written by SQLite.
127 # point the first query would attempt a hot rollback, attempt to open
H A Dcorrupt9.test38 # Return the offset to the first (trunk) page of the freelist. Return
47 # This procedure looks at the first trunk page of the freelist and
49 # of the first entry.
/sqlite-3.40.0/src/
H A Dhash.c25 pNew->first = 0; in sqlite3HashInit()
39 elem = pH->first; in sqlite3HashClear()
40 pH->first = 0; in sqlite3HashClear()
89 else { pH->first = pNew; } in insertElement()
92 pNew->next = pH->first; in insertElement()
93 if( pH->first ){ pH->first->prev = pNew; } in insertElement()
95 pH->first = pNew; in insertElement()
134 for(elem=pH->first, pH->first=0; elem; elem = next_elem){ in rehash()
165 elem = pH->first; in findElementWithHash()
191 pH->first = elem->next; in removeElementGivenHash()
[all …]
H A Dhash.h46 HashElem *first; /* The first element of the array */ member
85 #define sqliteHashFirst(H) ((H)->first)
/sqlite-3.40.0/ext/fts3/
H A Dfts3_hash.c64 pNew->first = 0; in sqlite3Fts3HashInit()
78 elem = pH->first; in sqlite3Fts3HashClear()
79 pH->first = 0; in sqlite3Fts3HashClear()
177 else { pH->first = pNew; } in fts3HashInsertElement()
180 pNew->next = pH->first; in fts3HashInsertElement()
181 if( pH->first ){ pH->first->prev = pNew; } in fts3HashInsertElement()
183 pH->first = pNew; in fts3HashInsertElement()
208 for(elem=pH->first, pH->first=0; elem; elem = next_elem){ in fts3Rehash()
257 pH->first = elem->next; in fts3RemoveElementByHash()
276 assert( pH->first==0 ); in fts3RemoveElementByHash()
H A Dfts3_hash.h36 Fts3HashElem *first; /* The first element of the array */ member
101 #define fts3HashFirst(H) ((H)->first)
/sqlite-3.40.0/ext/fts2/
H A Dfts2_hash.c66 pNew->first = 0; in sqlite3Fts2HashInit()
80 elem = pH->first; in sqlite3Fts2HashClear()
81 pH->first = 0; in sqlite3Fts2HashClear()
179 else { pH->first = pNew; } in insertElement()
182 pNew->next = pH->first; in insertElement()
183 if( pH->first ){ pH->first->prev = pNew; } in insertElement()
185 pH->first = pNew; in insertElement()
208 for(elem=pH->first, pH->first=0; elem; elem = next_elem){ in rehash()
256 pH->first = elem->next; in removeElementGivenHash()
275 assert( pH->first==0 ); in removeElementGivenHash()
H A Dfts2_hash.h36 fts2HashElem *first; /* The first element of the array */ member
99 #define fts2HashFirst(H) ((H)->first)
/sqlite-3.40.0/ext/fts1/
H A Dft_hash.c50 pNew->first = 0; in HashInit()
66 elem = pH->first; in HashClear()
67 pH->first = 0; in HashClear()
214 else { pH->first = pNew; } in insertElement()
217 pNew->next = pH->first; in insertElement()
218 if( pH->first ){ pH->first->prev = pNew; } in insertElement()
220 pH->first = pNew; in insertElement()
243 for(elem=pH->first, pH->first=0; elem; elem = next_elem){ in rehash()
291 pH->first = elem->next; in removeElementGivenHash()
310 assert( pH->first==0 ); in removeElementGivenHash()
H A Dfts1_hash.c57 pNew->first = 0; in sqlite3Fts1HashInit()
73 elem = pH->first; in sqlite3Fts1HashClear()
74 pH->first = 0; in sqlite3Fts1HashClear()
172 else { pH->first = pNew; } in insertElement()
175 pNew->next = pH->first; in insertElement()
176 if( pH->first ){ pH->first->prev = pNew; } in insertElement()
178 pH->first = pNew; in insertElement()
201 for(elem=pH->first, pH->first=0; elem; elem = next_elem){ in rehash()
249 pH->first = elem->next; in removeElementGivenHash()
268 assert( pH->first==0 ); in removeElementGivenHash()
H A Dft_hash.h36 HashElem *first; /* The first element of the array */ member
100 #define HashFirst(H) ((H)->first)
H A Dfts1_hash.h36 fts1HashElem *first; /* The first element of the array */ member
101 #define fts1HashFirst(H) ((H)->first)
/sqlite-3.40.0/ext/fts5/tool/
H A Dfts5txt2db.tcl33 is split on whitespace characters to form a list of tokens. The first N1
34 tokens are used for the first column of the first row, where N1 is the first
36 the first row, and so on. Rows are added to the table until the entire list
/sqlite-3.40.0/tool/
H A Dstack_usage.tcl93 set first [lindex $m 0]
94 puts [format {%6d %s %d} $depth $first $stkdepth($first)]
H A Dsqltclsh.c.in9 ** (2) If the first argument is a readable file, try to open that file
13 ** (3) If the first argument is a readable file with a ".tcl" extension,
/sqlite-3.40.0/ext/fts3/unicode/
H A Dmkunicode.tcl185 ** The most significant 22 bits in each 32-bit value contain the first
569 proc categories_switch {Cvar first lSecond} {
572 append ret "case '$first':\n"
575 append ret " case '$s': aArray\[$C($first$s)\] = 1; break;\n"
579 append ret " aArray\[$C($first$s)\] = 1;\n"
637 set first [lindex $lMap 0 0]
663 lappend lEntries [list $first $class $nRepeat]
665 set first $codepoint
671 lappend lEntries [list $first $class $nRepeat]
/sqlite-3.40.0/ext/fts5/test/
H A Dfts5config.test79 proc first {cmd A} { return $A }
80 sqlite3_fts5_create_function db first first
95 set func [string map {' ''} "first($arg)"]

12345678910