database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-11-15 11:41:13 +03:00
Code Activity
29,836 Commits 1,608 Branches 185 Tags
json-opt
Commit Graph

19158 Commits

Author SHA1 Message Date
drh
18839217da Add an OS method for making copies of file descriptors. This fixes the 
crash tests. (CVS 2786)

FossilOrigin-Name: 57a674fc71512f11393b8eb595961ec9465ba4e1
 2005-11-26 03:43:23 +00:00
drh
9c06c95309 Modify the OS layer so that I/O routines are called through a virtual function 
table.  The os_test.c module has been replaced by test6.c.  The crash tests
are busted now and need to be fixed. (CVS 2785)

FossilOrigin-Name: 1f69aec285dd8e26bd739d5e44bb50fe03a9682a
 2005-11-26 00:25:00 +00:00
danielk1977
d7c03f7485 Add the compilation option SQLITE_DISABLE_DIRSYNC (CVS 2782) 
FossilOrigin-Name: f1298bb103aad46c737741d89d33c4c2904aec68
 2005-11-25 10:38:22 +00:00
danielk1977
26c5d79f60 If SQLITE_DISABLE_LFS is defined, omit the bigfile tests. (CVS 2781) 
FossilOrigin-Name: f882a516da18f45dbb668078d0d8240d930e1180
 2005-11-25 09:01:23 +00:00
danielk1977
0964b23a99 Check the return code of full_fsync() when used to sync a directory fd. (CVS 2780) 
FossilOrigin-Name: 84aae3b0ae7381710ff0bc9881cbde3559bb580b
 2005-11-25 08:47:57 +00:00
drh
94c1f6f731 Preserve 64-bit last insert rowids across triggers. (CVS 2779) 
FossilOrigin-Name: 4dd7cfaa587fd5f76a0b60db0f02d5f57f801564
 2005-11-25 02:43:50 +00:00
drh
91636d58c0 The --enable-cross-thread-connect configuration option or the 
-DSQLITE_ALLOW_XTHREAD_CONNECT compile-time option permits database
connections to be moved across threads.  This will cause latch-ups
and failures on some linux systems such as RedHat-9.  Do not use these
options if you want a portable build. (CVS 2778)

FossilOrigin-Name: 84aa4d58001ed943295f21f429c58c3c99b771d8
 2005-11-24 23:14:00 +00:00
drh
22465ced29 Make sure sqliteInt.h is included before any system includes. 
This is required for QNX.  Ticket #1478. (CVS 2777)

FossilOrigin-Name: ab76453553bea7c2371b35e7643a98967bb04582
 2005-11-24 22:33:05 +00:00
drh
fa3b19ef3d Reduce the number of distinct token symbols in the parser so that the parser 
can store tokens in a single byte and thus be smaller in size. (CVS 2776)

FossilOrigin-Name: 2dfc9863919c9eb1fd1064ab2817d752dd7f9293
 2005-11-24 22:22:29 +00:00
drh
31beae983e Comment changes. No changes to code. (CVS 2775) 
FossilOrigin-Name: 786e23b2959c6103bfc0b45535afc49f22bc8a67
 2005-11-24 14:34:36 +00:00
drh
3a4a2d40e1 Fix a comment in btree.c. No code changes. (CVS 2774) 
FossilOrigin-Name: 0d8bd133a7530fb56ecb742472865f5a72a0ea5e
 2005-11-24 14:24:28 +00:00
drh
3eda040be9 Fix incorrect type conversions when copying from a table into itself. 
Ticket #1536. (CVS 2773)

FossilOrigin-Name: a2e55a3828d74d78b0b76f956a537a0d906f3191
 2005-11-24 13:15:32 +00:00
drh
32daab6cb0 Less verbose output when EXPLAIN QUERY PLAN identifies use of the primary key. (CVS 2772) 
FossilOrigin-Name: 5045f09933f57e4ae897969710b19d09b7af6022
 2005-11-21 12:48:24 +00:00
drh
36d649303f The EXPLAIN QUERY PLAN now identifies when tables use the integer primary key. (CVS 2771) 
FossilOrigin-Name: 80721e2c9033abb2e9eed32892c4e486c293e1fa
 2005-11-21 12:46:27 +00:00
drh
4efc083f57 Fix a problem with the sorting of literals in a compound query. Ticket #1501. (CVS 2770) 
FossilOrigin-Name: b3882b434a1ef7d8d636c7c5917b9e8f0d2952fb
 2005-11-16 13:47:50 +00:00
drh
7e56e71125 Do not allow aggregate functions in a WHERE clause. Ticket #1514. (CVS 2769) 
FossilOrigin-Name: bb866ed880c33ec9ce6ded8ebdbb459fedf9c257
 2005-11-16 12:53:15 +00:00
drh
ed2df7fb68 Avoid unnecessary strlen() calls in the OP_String opcode. (CVS 2768) 
FossilOrigin-Name: 2e195e96bcbad104da09ebe6cef617e0e9ef1884
 2005-11-16 04:34:32 +00:00
drh
a0943e6666 Fix a bug in UTF-16 handling introduced by the previous check-in. (CVS 2767) 
FossilOrigin-Name: 25fa16a2e1f324790f4b293df5d7142575034428
 2005-11-15 02:14:00 +00:00
drh
8a51256c0c Create separate affinities for INTEGER and REAL. (CVS 2766) 
FossilOrigin-Name: ce06c123d0c5663dbaf263c2e0aaf5d9cdeb2ccd
 2005-11-14 22:29:05 +00:00
drh
fd405314d3 About 0.5KiB of additional compression in the parser tables. (CVS 2764) 
FossilOrigin-Name: f39974ebd81f274dc4cf6cf94e6e87ee7b4a0814
 2005-11-06 04:06:59 +00:00
drh
152410fade Work around a bug in MSVC++. Ticket #1513. (CVS 2763) 
FossilOrigin-Name: 6331860e7754be6e0d2a484d66427947c0781dd6
 2005-11-05 15:11:22 +00:00
drh
8a9f38feb2 Remove a C++-ism that slipped into the code during the recent CHECK 
enhancements.  Ticket #1513. (CVS 2762)

FossilOrigin-Name: e66289b52f56c8242aa264a9365c834cd820e988
 2005-11-05 15:07:55 +00:00
drh
c9ac5caa45 VACUUM works even on an empty database. Ticket #1512. (CVS 2760) 
FossilOrigin-Name: 1b6bf4188e8ebf55cf1972b7081f6d31bf525555
 2005-11-04 22:03:30 +00:00
drh
c01be744bc sqlite3_column_int() and similar routines return 0 or 0.0 on an 
out-of-memory condition, not some mysterious error code. (CVS 2759)

FossilOrigin-Name: 7780f5e9d504926f11bd0662c03c88c76fb1d416
 2005-11-03 14:29:55 +00:00
drh
4284fb0778 Prohibit parameters in CHECK constraint expressions. (CVS 2758) 
FossilOrigin-Name: bb94ef64b227839a0ef4156985e2f5a061a78e2c
 2005-11-03 12:33:28 +00:00
drh
0cd2d4c9a1 Add the ignore_check_constraints pragma. VACUUM works even on a database 
that contains table entries that violate check constraints. (CVS 2757)

FossilOrigin-Name: be83bfee0211396a0038ffb125897199bea9a73f
 2005-11-03 02:15:02 +00:00
drh
06f6541e2f Disallow subqueries in CHECK constraints. (CVS 2756) 
FossilOrigin-Name: db27afc4cdc5b51c1fa0e83dbd6d4a4a69c5b642
 2005-11-03 02:03:13 +00:00
drh
6275b88b9e CHECK constraints that evaluate to NULL pass. (CVS 2755) 
FossilOrigin-Name: 55b314a22c69fbe129b024e953f3230b67eaaa87
 2005-11-03 01:22:30 +00:00
drh
ffe07b2dc1 First cut at supporting CHECK constraints. Everything appears to work, 
but much more testing is needed as well as documentation. (CVS 2754)

FossilOrigin-Name: 2313d912baeca0fd516d524f16708953de483729
 2005-11-03 00:41:17 +00:00
drh
8df447f0e6 Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now 
of type real, though an integer representation is still sometimes used
internally for efficiency. (CVS 2753)

FossilOrigin-Name: e0d6f61c7de2c03b8fd17ef37cf1a0add36ee618
 2005-11-01 15:48:24 +00:00
drh
b127612933 Fix the shift operators so that they work with 64-bit quantities. (CVS 2752) 
FossilOrigin-Name: 0d3357b5f65887f7db03db2ae021f28f480f90e4
 2005-10-29 15:48:30 +00:00
drh
eef8b55832 Report an error if the input SQL contains an unterminated string. 
Ticket #1497. (CVS 2751)

FossilOrigin-Name: c9c476dd836c49255eabc6cce83064974c079ce3
 2005-10-23 11:29:40 +00:00
drh
d9cb6ac02f Changes to prevent various compiler warnings. (CVS 2750) 
FossilOrigin-Name: e261b8b09a529a3e67dc27c3b83b660bcb32e195
 2005-10-20 07:28:17 +00:00
drh
b37df7b928 Attempt to fix the SQLite core so that no floating point operations are used 
anywhere if SQLITE_OMIT_FLOATING_POINT is defined at compile-time.  This
is useful to people who use SQLite on embedded processors that lack
floating point support. (CVS 2749)

FossilOrigin-Name: a0bdb584680ce6400d9e8c57db9d91197cc7b776
 2005-10-13 02:09:49 +00:00
drh
ec7429ae27 More efficient handling of the LIMIT clause. Scalar subqueries and EXISTS 
on compound SELECT statements now working properly.  Ticket #1473. (CVS 2747)

FossilOrigin-Name: edca8913ca012fc0c17343a27f819de95147b1bd
 2005-10-06 16:53:14 +00:00
drh
23cc57f6a3 Check-in (2744) as incomplete and broke pragma integrity_check. This 
completes the change and fixes the problem. (CVS 2746)

FossilOrigin-Name: 4862eaafd875eb1069076864c7cad600a76620c7
 2005-10-06 13:59:26 +00:00
drh
b59005e5a3 Make sure pragma integrity_check does not report "ok" after first finding 
a bunch of errors. (CVS 2744)

FossilOrigin-Name: efec04dedfff8b92527b42e59cc32b4f69031021
 2005-10-05 11:41:48 +00:00
drh
cc43cabcb0 Fix an assert or memory leak that occurs when trying to EXPLAIN a statement 
other than a SELECT that outputs results.  Examples of such statements
include PRAGMA integrity_check or INSERT/DELETE/UPDATE with PRAGMA
count_changes=ON. (CVS 2743)

FossilOrigin-Name: 533a85eee2370aafe204ff3eed50eb7fc0149e83
 2005-10-05 11:35:09 +00:00
drh
29bc461550 Changes to support TEA on cygwin. (CVS 2742) 
FossilOrigin-Name: e80fecc986f1fe93e127398b081054766c5383cf
 2005-10-05 10:40:15 +00:00
drh
f2f23916ec Another attempt to get fdatasync to be ignored on non-conforming posix systems. 
Now a system has to opt-in for fdatasync instead of opt-out.
Ticket #1467. (CVS 2741)

FossilOrigin-Name: 115340d4e85f1bbbab657edbb504284343d86e2c
 2005-10-05 10:29:36 +00:00
drh
ff55c3585c Add the SQLITE_OMIT_GET_TABLE compile-time flag. (CVS 2740) 
FossilOrigin-Name: 6d4bc8f83b228b3804fffcb17ac57e1f754fa9cd
 2005-10-05 02:13:40 +00:00
drh
762e584e2c The hash tables deallocate when empty in order to avoid nuisanse complaints 
from valgrind.  Added tests to verify no hash table memory leaks in os_unix.c. (CVS 2738)

FossilOrigin-Name: 080eadca582a49a069a76ed113ec15e9bce2955a
 2005-10-03 15:11:08 +00:00
drh
8e647b8191 Fix an uninitialized structure member that was causing a malfunction when 
you used deeply nested and very complex views.  Ticket #1449. (CVS 2733)

FossilOrigin-Name: 352cc9f53b7724621ecbf3a6362f34c31a18cce8
 2005-09-23 21:11:53 +00:00
drh
c035e6e4ab Optionally call fdatasync() instead of fsync() only if _POSIX_SYNCHRONIZED_IO 
is positive, which should only be the case on operating systems that
actually support fdatasync(). (CVS 2732)

FossilOrigin-Name: a9b341dccffaf324a64139d6f482599258ef7009
 2005-09-22 15:45:04 +00:00
drh
de29e3e9be Add VM code comments on the group-by processing. Extra group-by test case. (CVS 2731) 
FossilOrigin-Name: 655e75ac7d96b05c118226c5b70443da2df319ec
 2005-09-20 18:13:23 +00:00
drh
d654be803f Code cleanup and simplification. Three new Mem opcodes added. 
The sqlite3VdbeJumpHere function added. (CVS 2730)

FossilOrigin-Name: 2471957feee57538e5e1e50a704a337f0927d10e
 2005-09-20 17:42:23 +00:00
drh
4f68623875 Cleanup the implementation and the documentation of the new 0x200 P1 flag 
on the VDBE comparison operands. (CVS 2729)

FossilOrigin-Name: f22d0f64a0b9100e16746fb800efa508d286e40e
 2005-09-20 13:55:18 +00:00
drh
e313382e3e NULLs compare equal to each other when computing GROUP BY categories. (CVS 2728) 
FossilOrigin-Name: d9b0c9705379a8b3a28a83bb29fc1cd688fe184e
 2005-09-20 13:11:59 +00:00
drh
b6fb62d9b4 Update comments in where.c. No code changes. (CVS 2727) 
FossilOrigin-Name: bb84d27eda64479d65b13fbbcaeef6a00da4d103
 2005-09-20 08:47:20 +00:00
drh
22d6a53a77 ON-clause terms in a LEFT JOIN that restrict only the left table, should not 
really restrict the left table but instead rows that fail to meet the condition
to be joined with NULL rows from the right table. (CVS 2725)

FossilOrigin-Name: ea10f9785e3c5248dafcc297f3a2c5465b6e0dba
 2005-09-19 21:05:48 +00:00