Home
last modified time | relevance | path

Searched refs:empty (Results 1 – 25 of 101) sorted by relevance

12345

/sqlite-3.40.0/test/
H A Demptytable.test12 # Test cases to show that a join involving an empty table is very fast.
24 CREATE TABLE empty(x);
39 SELECT count(*) FROM t1, t1, t1, t1, t1, t1, empty;
43 SELECT count(*) FROM t1, t1 LEFT JOIN empty;
46 SELECT count(*) FROM t1, t1 LEFT JOIN t1, empty;
H A Dwal4.test11 # Verify that an empty database and a non-empty WAL file do not
47 # Result should be zero rows (empty db file).
H A Dsavepoint5.test12 # Verify that a SAVEPOINT on a new, empty database followed by a
14 # empty database.
H A Dfts3expr5.test30 # Various forms of empty phrase expressions.
53 # Various forms of empty phrase expressions.
H A Dtkt-80e031a00f.test13 # resolved. That ticket is about IN and NOT IN operators with empty-set
23 # EVIDENCE-OF: R-52275-55503 When the right operand is an empty set, the
29 # operator to be an empty list but most other SQL database engines and
80 # contains NULL Right operand is an empty set Left operand found within
H A Dcorrupt9.test39 # zero of the freelist is empty.
53 if {$offset==0} {error "Freelist is empty"}
H A Denc2.test439 # 1: Open an empty database file assuming UTF-16 encoding.
493 # Test that the encoding of an empty database may still be set after the
494 # (empty) schema has been initialized.
556 # attached databases are empty.
H A Dincrvacuum.test30 # Test the pragma on an empty database.
88 # Test the pragma on a non-empty database. It is possible to toggle
364 # Build some test data. Two tables are created in an empty
690 # statement when the database is empty, but doesn't execute it until
807 # Reopen db to ensure the page-cache is empty.
H A De_blobwrite.test47 # Tcl sqlite3_blob_write() wrapper uses an empty string in place of
70 # SQLITE_OK, the Tcl wrapper returns an empty string. If the underlying
H A Dfts2.test47 # Files to include in the test. If this list is empty then everything
H A DmallocAll.test45 # Files to include in the test. If this list is empty then everything
H A Dwhere2.test376 -- occur and the comparison is false. The result is an empty set.
428 # the OR optimization to be used again. The result is now an empty
436 # the OR optimization to be used again. The result is now an empty
444 # the OR optimization to be used again. The result is now an empty
452 # But we should still get the same empty-set result as in where2-6.9.
H A Dautoinc.test36 # The database is initially empty.
54 # The SQLITE_SEQUENCE table is initially empty
553 # an empty insert - an INSERT INTO ... SELECT ... where the SELECT
554 # clause returns an empty set.
H A Dfts2h.test55 # No hits at all. Returns empty doclists from termSelect().
H A Dfts3ah.test50 # No hits at all. Returns empty doclists from termSelect().
H A De_uri.test132 # must be either an empty string or the string "localhost".
134 # EVIDENCE-OF: R-17482-00398 If the authority is not an empty string or
195 # EVIDENCE-OF: R-52293-58497 If this option is set to an empty string
H A Dwal8.test15 # Specifically, it tests the case where a connection opens an empty
H A Dfts2p.test79 } {1 {dump_doclist: empty second argument}}
85 } {1 {dump_doclist: empty second argument}}
H A Dminmax2.test163 # Make sure the min(x) and max(x) optimizations work on empty tables
164 # including empty tables with indices. Ticket #296.
H A Dtkt1644.test60 # the statement is recompiled and refers to the empty temp table.
H A Dfts2g.test28 # No hits at all. Returns empty doclists from termSelect().
H A Dincrblob.test155 # Open and close the db to make sure the page cache is empty.
178 # Open and close the db to make sure the page cache is empty.
208 # Open and close the db to make sure the page cache is empty.
H A Dfts3ag.test28 # No hits at all. Returns empty doclists from termSelect().
/sqlite-3.40.0/src/
H A Din-operator.md14 it must be a non-empty list. But if the RHS is a subquery, it can be an
15 empty set.
105 first. If the RHS is empty, this step is a no-op.
/sqlite-3.40.0/ext/rtree/
H A Drtreedoc3.test112 error "priority queue is empty!"
243 # empty.
245 error "priority queue is not empty!"

12345