Home
last modified time | relevance | path

Searched refs:limit (Results 1 – 25 of 66) sorted by relevance

123

/sqlite-3.40.0/test/
H A Dlimit.test34 do_test limit-1.0 {
37 do_test limit-1.1 {
40 do_test limit-1.2.1 {
61 do_test limit-1.3 {
70 do_test limit-1.5 {
73 do_test limit-1.6 {
76 do_test limit-1.7 {
411 set limit 10
417 set limit 5
424 set limit -1
[all …]
H A Dwherelimit.test93 # limit 5
99 # limit 5
106 # limit 5, offset 2
118 # limit -5 (no limit), offset 2
129 # limit -5 (no limit), offset -2 (no offset)
174 # limit 5
189 # limit -5 (no limit), offset 2
199 # limit -5 (no limit), offset -2 (no offset)
246 # limit 5
262 # limit -5 (no limit), offset 2
[all …]
H A Dsqllimits1.test206 # that the limit does not exceed the compile-time upper bound.
250 # Test cases sqllimits1-5.* test that the SQLITE_MAX_LENGTH limit
449 # Test cases sqllimits1-7.* test that the limit set using the
580 # Test cases sqllimits1-8.* test the SQLITE_MAX_COLUMN limit.
691 # limit is enforced. The limit refers to the number of terms in
747 # limit works as expected. The limit refers to the number of opcodes
753 # Test the SQLITE_LIMIT_FUNCTION_ARG limit works. Test case names
790 # Test cases sqllimits1-12.*: Test the SQLITE_MAX_ATTACHED limit.
816 # limit works.
837 # SQLITE_MAX_LIKE_PATTERN_LENGTH limit is enforced. This limit only
[all …]
H A Dquota.test63 upvar $limitvar limit
65 lappend ::quota [set limit] $size
66 if {[info exists ::quota_request_ok]} { set limit $size }
134 upvar $limitvar limit
135 lappend ::quota [set limit] $size
136 if {[info exists ::quota_request_ok]} { set limit $size }
218 upvar $limitvar limit
223 set limit 0
240 # Quotas are deleted when unused and when their limit is set to zero
H A Dwal7.test20 # Case 1: No size limit. Journal can get large.
48 # Case 2: Size limit at half the autocheckpoint size.
70 # Case 3: Size limit of zero.
93 # Case 4: Size limit set before going WAL
H A Dsort3.test69 # Sort roughly 20MB of data. Once with a mmap limit of 5MB and once without.
71 foreach {itest limit} {
75 sqlite3_test_control SQLITE_TESTCTRL_SORTER_MMAP db $limit
H A Dcapi3b.test25 # soft-heap-limit is set too low. So disable the soft heap limit
144 sqlite3_soft_heap_limit $cmdlinearg(soft-heap-limit)
H A Dquota2.test47 # that has gone over quota, (2) the quota limit, (3) the requested
60 upvar $limitvar limit
61 lappend ::quota [standard_path $filename] [set limit] $size
62 if {$::quota_request_ok} {set limit $size}
H A Dnulls1.test25 foreach {tn limit} {
30 SELECT a FROM t3 ORDER BY a nULLS FIRST $limit
34 SELECT a FROM t3 ORDER BY a nULLS LAST $limit
38 SELECT a FROM t3 ORDER BY a DESC nULLS FIRST $limit
42 SELECT a FROM t3 ORDER BY a DESC nULLS LAST $limit
H A Dcountofview.test28 select c from t2 union all select f from t3 limit 1 offset 1
33 select c from t2 union all select f from t3 limit 1 offset 1
H A Dmalloc5.test16 # the configured soft heap limit could cause sqlite to upgrade database
212 # The second test case sets the "soft-heap-limit" to 100,000 bytes (0.1 MB)
213 # and tests to see that this limit is not exceeded at any point during
217 # limit in variable ::soft_limit. The original value is restored after
255 # Restore the soft heap limit.
H A Dshell3.test122 SELECT * from t1 limit 1;
123 SELECT * from t2 limit 1;
H A Dindexfault.test66 # with default options and once with a 50KB soft-heap-limit.
164 # 3.2: As 7.1, but with a low (50KB) soft-heap-limit.
168 # 3.4: As 7.3, but with a low (50KB) soft-heap-limit.
H A Dexclusive2.test37 # moments. So disable the soft-heap-limit.
199 # this means 19 pages. We also need to disable the soft-heap-limit
322 sqlite3_soft_heap_limit $cmdlinearg(soft-heap-limit)
H A Dfts3auto.test136 proc fts3_zero_long_segments {tbl limit} {
141 WHERE length(block)>$limit
509 set limit [fts3_make_deferrable t1 c]
514 do_test 3.$tn.3 { fts3_zero_long_segments t1 $limit } {1}
552 set limit [fts3_make_deferrable t1 five]
555 expr {[fts3_zero_long_segments t1 $limit]>0}
H A Dfts3expr3.test160 # These exceed the depth limit.
168 # This also exceeds the depth limit.
H A Dmemdb.test73 set limit 10
74 for {set i 2} {$i<=$limit} {incr i} {
106 if {$i<$limit} {
H A Davtrans.test169 sqlite3_soft_heap_limit $cmdlinearg(soft-heap-limit)
862 set limit 20
864 set limit 40
869 for {set i 2} {$i<=$limit} {incr i} {
900 if {$i<$limit} {
H A Dtrans.test927 set limit 20
929 set limit 100
931 set limit 40
936 for {set i 2} {$i<=$limit} {incr i} {
967 if {$i<$limit} {
H A Dioerr3.test13 # in conjunction with very small soft-heap-limit values.
H A Dorderby6.test87 foreach {tx limit offset orderby} {
121 set sql1 "SELECT a FROM t1 ORDER BY $orderby LIMIT $limit OFFSET $offset;"
H A Dsoftheap1.test73 sqlite3_soft_heap_limit $cmdlinearg(soft-heap-limit)
H A DselectG.test13 # VALUE terms works and does not hit the SQLITE_LIMIT_COMPOUND_SELECT limit.
/sqlite-3.40.0/ext/fts5/tool/
H A Dloadfts5.tcl15 if {$::O(limit) && $::nRow>=$::O(limit)} break
58 set O(limit) 0
88 -limit {
90 set O(limit) [lindex $argv $i]
/sqlite-3.40.0/ext/misc/
H A Dfossildelta.c379 int limit = 250; in delta_create() local
383 while( iBlock>=0 && (limit--)>0 ){ in delta_create()
544 unsigned int limit; in delta_apply() local
550 limit = deltaGetInt(&zDelta, &lenDelta); in delta_apply()
569 if( total>limit ){ in delta_apply()
584 if( total>limit ){ in delta_apply()
607 if( total!=limit ){ in delta_apply()

123