Searched refs:deferred (Results 1 – 23 of 23) sorted by relevance
49 # -deferred TOKENLIST65 set deferred [list]69 -deferred {70 ifcapable fts4_deferred { set deferred $v }73 error "bad option \"$k\": must be -deferred"78 get_near_results $tbl $match $deferred aHit256 if {[llength $deferred] && [llength $expr]==1} {261 if {[lsearch $deferred $tok]>=0} {488 # Some test cases involving deferred tokens.709 # returns 2, so B is deferred in this case.[all …]
13 # This file test deferred foreign key constraint processing to make16 # a subsequent statement to fail a deferred constraint with impunity.
54 # 2016-03-04: statement-journal open deferred70 # 2016-03-04: statement-journal open deferred
12 # This file contains a very simple test to show that the deferred tokens53 # be deferred because of the very large associated doclist.
1308 # any number of deferred foreign key constraints.1340 # executing. In this case deferred constraints behave the same as1366 # Test that an FK constraint is made deferred by adding the following1389 # classified as either immediate or deferred.1521 # deferred foreign key constraints.1525 # deferred foreign key constraint.1560 # satisfying deferred foreign key constraints. It may be rolled back.1601 # Test that if a COMMIT operation fails due to deferred foreign key 1855 # would with a deferred constraint.2685 # EVIDENCE-OF: R-05903-08460 If a deferred foreign key constraint is[all …]
44 deferred
37 # Get a deferred lock on the database using one connection. The
27 # fkey2-1.*: Simple tests to check that immediate and deferred foreign key 30 # fkey2-2.*: Tests to verify that deferred foreign keys work inside31 # explicit transactions (i.e that processing really is deferred).270 # deferred foreign key constraint logic works.367 # the deferred constraint counter is correctly reset to the value it 1357 INSERT INTO cc VALUES('see', 4); -- Violates deferred constraint1432 # Whereas statements that violate deferred FK constraints return the number1576 # An insert on the parent table must read the child key of any deferred1592 # As must an insert on the child table of a deferred constraint.
28 # without_rowid3-1.*: Simple tests to check that immediate and deferred foreign key 31 # without_rowid3-2.*: Tests to verify that deferred foreign keys work inside32 # explicit transactions (i.e that processing really is deferred).270 # deferred foreign key constraint logic works.367 # the deferred constraint counter is correctly reset to the value it 1332 INSERT INTO cc VALUES('see', 4); -- Violates deferred constraint1494 # Whereas statements that violate deferred FK constraints return the number1638 # An insert on the parent table must read the child key of any deferred1654 # As must an insert on the child table of a deferred constraint.
453 # 2016-03-04: The statement-journal open is deferred462 # 2016-03-04: The statement-journal open is deferred
32 # This block of tests - fts3defer2-1.* - test the interaction of deferred NEAR
21 # OFF so that foreign key constraints are only deferred if they are
72 # This test no longer functions due to the deferred computation of
122 # Note: Token 'in' is being deferred in the following query.
105 # Test that notindexed columns are not scanned for deferred tokens.
386 db transaction deferred {}397 } {1 {bad transaction type "xyzzy": must be deferred, exclusive, or immediate}}
621 # deferred seek of the OP_Seek is not resolved prior to reaching the OP_Delete.
263 # It used to be that the second 'a' token would be deferred. That doesn't
98 # Note: This test is no longer meaningful due to the deferred computation
1024 INSERT INTO t1(docid,words) VALUES(1034019,'And the young man deferred not to do the thing, because…
251 # It used to be that the second 'a' token would be deferred. That doesn't
3122 int sqlite3VdbeCheckFk(Vdbe *p, int deferred){ in sqlite3VdbeCheckFk() argument3124 if( (deferred && (db->nDeferredCons+db->nDeferredImmCons)>0) in sqlite3VdbeCheckFk()3125 || (!deferred && p->nFkConstraint>0) in sqlite3VdbeCheckFk()
1109 ** means all subsequent write operations will be deferred and done6480 ** to modify the database connection must be deferred until after the6608 ** to modify the database connection must be deferred until after the8502 ** all foreign key constraints (deferred or immediate) have been