Home
last modified time | relevance | path

Searched refs:total (Results 1 – 25 of 54) sorted by relevance

123

/sqlite-3.40.0/tool/
H A Dspaceanal.tcl471 statline {Percentage of total database} $total_pages_percent
719 the total number of pages in the file.
725 divided by the total number of pages in the file.
739 The total number of indices in the database.
759 divided by the total file size.
761 Percentage of total database
839 The total number of overflow pages used for this category.
845 total number of bytes on index pages.
851 total number of bytes on primary pages.
857 total number of bytes on overflow pages.
[all …]
/sqlite-3.40.0/test/
H A Dmutex1.test31 set var(total) 0
34 incr var(total) $value
69 set counters(total)
78 # list $counters(total) $counters(static_main)
79 expr {$counters(total)>0}
89 list $counters(total) $counters(static_main)
160 if {$key ne "total" && $value > 0} {
H A Dselect8.test31 SELECT DISTINCT artist,sum(timesplayed) AS total
37 SELECT DISTINCT artist,sum(timesplayed) AS total
45 SELECT DISTINCT artist,sum(timesplayed) AS total
53 SELECT DISTINCT artist,sum(timesplayed) AS total
H A Ddbstatus.test93 # 2. Execute the SQL to create the database schema. Measure the total
97 # 3. Drop all tables in the database schema. Measure the total memory
107 # same as the difference in total memory in steps 2 and 3.
109 # b) Step 4 reports the same amount of schema and total memory used as
112 # c) Step 5 reports the same amount of schema and total memory used as
249 # 2. Prepare a bunch of SQL statements. Measure the total heap and
253 # 3. Finalize all prepared statements. Measure the total memory
263 # same as the difference in total memory in steps 2 and 3.
265 # b) Step 4 reports the same amount of schema and total memory used as
268 # c) Step 5 reports the same amount of schema and total memory used as
H A Dwindow1.test428 SELECT emp, region, total FROM (
430 emp, region, total,
433 ) WHERE rank<=2 ORDER BY region, total DESC
443 SELECT emp, region, sum(total) OVER win FROM sales
444 WINDOW win AS (PARTITION BY region ORDER BY total)
483 PARTITION BY region ORDER BY total
500 PARTITION BY region ORDER BY total
513 SELECT sum(total) OVER (
1302 SELECT total(d) OVER (ORDER BY c)
1949 + total(a) OVER()
[all …]
H A Daggnested.test284 # At one point, aggregate "total()" in the query below was being processed
288 SELECT ( SELECT total( (SELECT b FROM x1) ) ) FROM x2;
292 SELECT ( SELECT total( (SELECT 2 FROM x1) ) ) FROM x2;
303 SELECT total( (SELECT a FROM t1) )
H A Dwindow4.tcl364 CREATE TABLE t8(t INT, total INT);
371 SELECT NTILE(256) OVER (ORDER BY total) - 1 AS nt FROM t8;
375 CREATE VIEW v8 AS SELECT NTILE(256) OVER (ORDER BY total) - 1 AS nt FROM t8;
384 SELECT NTILE(256) OVER (ORDER BY total) - 1 AS nt FROM t8
H A Dnotify2.test118 (SELECT b FROM xxx WHERE a=(SELECT max(a) FROM xxx))==total(a)
122 INSERT INTO xxx SELECT NULL, total(a) FROM xxx;
217 # Count the total number of succesful writes.
H A Dsync2.test60 # on the db file. 3 in total.
71 # 2 on the journal, 1 on the db file. 4 in total.
H A Dpageropt.test116 # the three overflow pages of t1 for a total of 5 pages.
196 # reads total. But only page1, the t1 root, and the trunk of the
H A Dskipscan2.test103 # Add 8 more people, bringing the total to 34. Then the number of
128 # Add 2 more people, bringing the total to 36. Then the number of
H A Dnull.test105 # The sum of zero entries is a NULL, but the total of zero entries is 0.
109 SELECT sum(b), total(b) FROM t1 WHERE b<0
H A Dfunc.test802 SELECT sum(x), total(x) FROM t5;
808 SELECT sum(x), total(x) FROM t5
814 SELECT sum(x), total(x) FROM t5
820 SELECT sum(x), total(x) FROM t5
850 SELECT total(x) - ((1<<62)*2.0+1) FROM t6
863 SELECT total(x) - ((1<<62)*2+1) FROM t6
H A Dvacuummem.test31 # this causes the total memory usage to drop much more than expected,
H A Dfuzzer2.test31 # strings. In total, (26^4)-(26^2) mappings (the subtracted term represents
H A Dsort5.test79 # each a bit over 100 bytes in size. In total a little more than 1MiB
H A Dfts2e.test23 # which are used for the rowid. There are a total of 30 INSERT and
H A Dfts1e.test23 # which are used for the rowid. There are a total of 30 INSERT and
H A Dfts1f.test23 # which are used for the rowid. There are a total of 31 INSERT,
H A Dfts3ae.test23 # which are used for the rowid. There are a total of 30 INSERT and
H A Dfts2f.test23 # which are used for the rowid. There are a total of 31 INSERT,
H A Dfts3af.test23 # which are used for the rowid. There are a total of 31 INSERT,
/sqlite-3.40.0/ext/misc/
H A Dfossildelta.c545 unsigned int total = 0; in delta_apply() local
568 total += cnt; in delta_apply()
569 if( total>limit ){ in delta_apply()
583 total += cnt; in delta_apply()
584 if( total>limit ){ in delta_apply()
602 if( cnt!=checksum(zOrigOut, total) ){ in delta_apply()
607 if( total!=limit ){ in delta_apply()
611 return total; in delta_apply()
/sqlite-3.40.0/src/
H A Din-operator.md34 NULL values then we say that it is a "total-NULL". If the LHS contains
36 For a scalar, there is no difference between a partial-NULL and a total-NULL.
38 a total-NULL if it contains one or more rows that contain only NULL values.
/sqlite-3.40.0/ext/wasm/fiddle/
H A Dfiddle.js582 const status = {loaded: 0, total: 0}; property
588 SF.echo("Loading progress:",ev.loaded,"of",ev.total,"bytes.");

123