database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-26 21:59:27 +03:00
Code Activity
10,307 Commits 1,786 Branches 392 Tags
winFileMapping
Commit Graph

7475 Commits

Author SHA1 Message Date
drh
4b5db5ac9c Redesign the string to numeric value caster so that it is more likely to 
work on unusual floating point hardware.

FossilOrigin-Name: 8bb1104c6f02c88eb09ed345890be71dee099485
 2010-01-21 01:53:07 +00:00
dan
14d4cc4356 Fix a problem with handling OOM errors in fts3. 
FossilOrigin-Name: f9c54e95ecf1c36c4750bb151e91d81c1d1bd596
 2010-01-20 14:25:37 +00:00
drh
7ed97b9de9 Move the Apple OS-X VFS changes into the trunk. 
FossilOrigin-Name: 571594bfbe89d9949bdb8b07712e96d0a3467c6e
 2010-01-20 13:07:21 +00:00
drh
87f5c5f16e Manually copy over the rebustness fixes from the apple-osx branch. 
FossilOrigin-Name: 095c74ea6260096f6a600fdc0edccf7ea24aace4
 2010-01-20 01:20:56 +00:00
shaneh
b7977c5539 Fix a problem with the CLI where not all SQL commands were being echoed. 
Added tests of same to tools/shell2.test.  Ticket [eb620916be].

FossilOrigin-Name: 7080ae3bc3828168483ac23d5b8976d67ea5089e
 2010-01-18 18:17:10 +00:00
drh
a2460e0730 Comment cleanup in sqliteInt.h. 
FossilOrigin-Name: 67c3aea563e019083f0ed87b57982a0379637d4f
 2010-01-14 00:39:26 +00:00
drh
85c8f291e3 Make the sqlite3IsNaN() function a macro that evaluates to FALSE when 
compiled with SQLITE_OMIT_FLOATING_POINT.

FossilOrigin-Name: 56f232d562bc239103a5afd2e64c4b926a20de08
 2010-01-13 17:39:53 +00:00
drh
90038f8b07 When SQLITE_OMIT_FLOATING_POINT is defined, the floating-point formats in 
the sqlite3_*printf() functions should pull an int64 off of the parameter
list and ignore it.

FossilOrigin-Name: 3fd6f9ad06b786116ca18c1e812363d30cd3060e
 2010-01-13 16:43:27 +00:00
drh
c5a7b51c69 When SQLITE_OMIT_FLOATING_POINT is defined, make sure the result of a 
mathematical operation is always tagged as an integer.

FossilOrigin-Name: e12da0d316fcc34a75554d59fe6d11d9f0e059e2
 2010-01-13 16:25:42 +00:00
drh
52d14521fa Make the doubleToInt64() routine a pass-through when using OMIT_FLOATING_POINT. 
FossilOrigin-Name: 417167182efaa1da74008952137de3e00c23494e
 2010-01-13 15:15:40 +00:00
drh
44dbca83c7 Comment out unused code when SQLITE_OMIT_FLOATING_POINT is selected. 
Added testcase() macros to boundary conditions in util.c routines.

FossilOrigin-Name: dfc6595d347ea87923a857778b68751103f535d2
 2010-01-13 04:22:20 +00:00
drh
7ec5ea942e Make the sqlite3_result_double() interface work the same as 
sqlite3_result_int64() when SQLITE_OMIT_FLOATING_POINT is defined.

FossilOrigin-Name: 61df5986600b6c9e6d5c42efc0067a27fe54251f
 2010-01-13 00:04:13 +00:00
drh
6a9c64b363 Make sure internal queries are well ordered, even when the 
reverse_unordered_selects pragma is in effect.
Ticket [eb942c64a157].

FossilOrigin-Name: 0209f17180065d9c213b6c437be1c3c40660665f
 2010-01-12 23:54:14 +00:00
drh
2b1e690ff1 Fix the implementation of CURRENT_TIMESTAME and CURRENT_DATE when 
SQLITE_OMIT_DATETIME_FUNCS is defined.

FossilOrigin-Name: eb98265b59db59965b468a7070739921da55efc4
 2010-01-12 19:28:20 +00:00
drh
13573c71d8 Use #ifdefs to disable unused code when SQLITE_OMIT_FLOATING_POINT is defined. 
FossilOrigin-Name: 66bab8561926963a87f15ad559cba36545c9892c
 2010-01-12 17:04:07 +00:00
drh
ab2f1f9560 Add a few documentation evidence comments to the built-in function 
implementations.

FossilOrigin-Name: 8bd0f8147dbf75367243b3eecfb705da6e794ab7
 2010-01-11 18:26:42 +00:00
drh
1d9da70ad7 Fix the expression comparison logic to take the COLLATE operator into account. 
Ticket [360c6073e197]

FossilOrigin-Name: 44bb1bfe5dedd8054ddd933941ee4112ed8d3b68
 2010-01-07 15:17:02 +00:00
dan
93a696f61b Changes to test code so that testfixture compiles when OMIT_SHARED_CACHE and OMIT_UTF16 are defined. 
FossilOrigin-Name: d6ee5ff6c815e3aadd92d331560b529394eae661
 2010-01-07 11:27:30 +00:00
drh
3918795951 Make sure new pages are zeroed even when loading a freelist page using the 
noContent option.  This prevents a harmless valgrind warning.

FossilOrigin-Name: e47e213369a2652d7eb6bddd58617959e21ca82b
 2010-01-05 13:40:35 +00:00
dan
4564cedd80 Fix a problem in the shell tool. In some cases sqlite3_errmsg() was being called before sqlite3_finalize(), causing error messages to be more generic than they should be. 
FossilOrigin-Name: e5d07045fabe0803715cfb291aa9e971235cb08a
 2010-01-05 04:59:56 +00:00
drh
10f864e8ef In the debugging memory allocator, initialize new memory allocations to 
pseudo-randomness in an effort to find problems with memcmp() of structures
that have uninitialized pad bytes.

FossilOrigin-Name: 6462817b2f817a6105449b0ea3e1e336e42571d1
 2010-01-05 03:30:15 +00:00
drh
9061ad10bc Fix a case in os_unix.c where two structures that might have uninitialized 
padding bytes are compared using memcmp().

FossilOrigin-Name: e02f25560216c7c96c5e1c7e71a8531650b3a96f
 2010-01-05 00:14:49 +00:00
drh
855787a1b3 Fix a bug in the new sqlite3_test_control case of the previous check-in. 
FossilOrigin-Name: 3b77701bc854997346e9cc33fe64d00d4b6332bd
 2010-01-02 03:46:43 +00:00
drh
0e857739c4 Add a new sqlite3_test_control() verb that facilitates testing that all 
keywords are shown in the documentation.  (Two keywords were found to
be missing while testing the change.)

FossilOrigin-Name: d3cdc4b12be7f1ed2249ad210482200868956d12
 2010-01-02 03:21:35 +00:00
drh
c79c761f84 Add evidence marks associated with autoincrement. 
FossilOrigin-Name: 0e918c54893c361fb005295847f89aadcbfae35d
 2010-01-01 18:57:48 +00:00
drh
5cfa584831 Add comments and an assert() to help clarify the operation of the 
sqlite3VdbeList() routine used to implement EXPLAIN.

FossilOrigin-Name: e1ccdb93d79a6f7b16f1f59cc3ad78f8d02eae84
 2009-12-31 20:35:08 +00:00
shaneh
46aae3c0da Changes to remove warnings in MSVC build. 
FossilOrigin-Name: 6cf76c2ae25d6e58926637ecd42eed6b300b1a25
 2009-12-31 19:06:23 +00:00
drh
f49f352320 Adjustments to column cache handling in order to restore 100% branch 
test coverage.

FossilOrigin-Name: cc6b959bc1f968e08eea1afd387201d70a0c1e80
 2009-12-30 14:12:38 +00:00
drh
27ee406e2c Remove some code in the column cache that is no longer used. Replace it with 
an assert().

FossilOrigin-Name: 1f890efb7863bd743b9f6ef841e0c0c4e67d76e1
 2009-12-30 01:13:11 +00:00
drh
c82b7513bf Remove obsolete comment text from expr.c. No functional code changes. 
FossilOrigin-Name: 84058be0beb799bc989d73a8d4cd8791ab709395
 2009-12-30 00:12:39 +00:00
drh
25e978df92 Within the special new.* and old.* tables of a trigger, recognize all the 
original table names even if those names overload the "rowid", "oid", or
"_rowid_" special names.  Ticket [34d2ae1c6d0].

FossilOrigin-Name: 1a0e5fa9f0ff792c678c99d49960601a0cef925b
 2009-12-29 23:39:04 +00:00
drh
b6da74ebd5 Immediately purge entries from the column cache when the associated register 
undergoes an affinity change.  Ticket [eb5548a849].  Enhance the
SQLITE_TESTCTRL_OPTIMIZATIONS setting of sqlite3_test_control so that it
can disable the column cache for testing purposes, in an effort to prevent
future problems of a similar nature to this one.

FossilOrigin-Name: ea4e57e1c1b6663ceb12872e31a8503f6c14e3d8
 2009-12-24 16:00:28 +00:00
drh
07096f68ae Move the query flattener turn-off from a pragma to an sqlite3_test_control() 
call.  Make provisions (not yet implemented) to turn off other optimizers
using the same call.

FossilOrigin-Name: 4a97c623f4e190134de4b2ca406e311034a74797
 2009-12-22 23:52:32 +00:00
drh
7b688ede64 Add a pragma to disable the query flattener - for use during testing. 
FossilOrigin-Name: 1d8550e5c88db0ea76aea579c1a5bf99d48fbe43
 2009-12-22 00:29:53 +00:00
shaneh
c7d526e92b Modified statement machine in sqlite3_complete() to return 0 on empty string. 
Added/updated tests for same.  Ticket 356c885b0b.

FossilOrigin-Name: 76eca7295cf7df4bef013af6c8c37251300cd383
 2009-12-17 22:17:38 +00:00
shaneh
13b3602e1c In shell.c (CLI), modified local_getline() to remove '\r' as well as '\n' from end of lines. 
FossilOrigin-Name: b1b48be1cf55f3179eab8824cf5fee8100518845
 2009-12-17 21:07:15 +00:00
shaneh
d77f56efe5 Fix typo in comment of prepare.c. 
FossilOrigin-Name: 333c3ffe6d4d2293d01958812b9c02b0bf9796a4
 2009-12-17 21:05:42 +00:00
drh
702b919a67 Disable trace when recursively running commands while vacuuming. 
FossilOrigin-Name: 69a1348a3c88ffbf401cf72bbec8b4a76557bd11
 2009-12-17 03:49:56 +00:00
drh
b057e56f22 Remove unreachable code that was added by the fix to the "(xANDy)OR(z)" bug 
in the previous check-in.

FossilOrigin-Name: 04915562a0c2cb377bc7baa0c06c5d9ac376563c
 2009-12-16 23:43:55 +00:00
drh
c01a3c1775 Ensure WHERE clause terms involving tables on the right end of a join 
are not prematurely evaluated when tables on the left end of the join
make use of the OR-clause optimization.  
Fix for ticket [31338dca7e].

FossilOrigin-Name: 2c2de252666662f5459904fc33a9f2956cbff23c
 2009-12-16 22:10:49 +00:00
drh
d3479b94e3 Add a few simple evidence comments to the tokenizer. No functional changes. 
FossilOrigin-Name: 0daec3099d439ce8a8779260b12975f262037bc8
 2009-12-14 17:42:12 +00:00
drh
7a98b853da Additional corrections to documentation comments. No functional code changes. 
FossilOrigin-Name: b3740b0aa0a7c6932e33e02b37baed5a5960a0bd
 2009-12-13 23:03:01 +00:00
drh
df6473aa7a Minor documentation updates. No functional changes. 
FossilOrigin-Name: 6ae7e40ba0f710609cf1bc8baa54e7839eb7a2d7
 2009-12-13 22:20:08 +00:00
drh
9be37f691b Fix some documentation comments in sqlite.h.in. No functional code changes. 
FossilOrigin-Name: c16b9bec77c8b9120b728f8431648d95175a83b8
 2009-12-12 23:57:36 +00:00
dan
f5fff2a7b2 Add coverage test cases for fts3. 
FossilOrigin-Name: 8fcb0478c82507403165719724b62a308cb83b57
 2009-12-12 09:51:25 +00:00
drh
fb43403641 Additional changes to C-language interface documentation. 
FossilOrigin-Name: 1342916fd350d06e1c1f3d7d380249f0c9282c7b
 2009-12-11 23:11:26 +00:00
drh
d68eee04b4 Extensive edits to the comments in the sqlite.h.in source file to identify 
testable statements of truth about the C-language interface.

FossilOrigin-Name: ea884e1ed8dba1aa0f3cf68fc71923954983f6c6
 2009-12-11 03:44:18 +00:00
drh
0edb3cf53d Only declare the sqlite3_mutex_held() and sqlite3_mutex_notheld() interfaces 
in the header file if NDEBUG is not defined.

FossilOrigin-Name: ee9b1c05a7f12d3d668b804bd11ae0def984b66e
 2009-12-10 01:17:29 +00:00
drh
c29c5aa1fd Restore the incorrect legacy ON INSERT syntax to the parser as a no-op. 
That way, older databases that actually use this meaningless syntax will
still be readable.

FossilOrigin-Name: 54b955c36ba5c139a63c6031855305b764d3fa6c
 2009-12-09 21:43:36 +00:00
drh
2179b43465 The USING clause and NATURAL JOIN look at all tables to the left when 
searching for a match, not just the one table to the immediate left.
Tables further to the left are preferred.
Fix for ticket [f74beaabde].  Still need to add test cases to complete
the ticket.

FossilOrigin-Name: b558e96f0a3cd2cbbe86e44293246a4730960d52
 2009-12-09 17:36:39 +00:00