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

19158 Commits

Author SHA1 Message Date
drh
6ed48bf6d7 The C-api reference documentation is now generated directly from 
comments in the sqlite3.h header file. (CVS 4062)

FossilOrigin-Name: d93c41e9a97882bf90217d60744d62dece6d10d3
 2007-06-14 20:57:18 +00:00
danielk1977
3fe11f3021 Have queries interrupted by the progress-handler return SQLITE_INTERRUPT. Rollback any active transaction if a DML statement returns SQLITE_INTERRUPT. (CVS 4061) 
FossilOrigin-Name: 33454b5691637da7ded7d18d7f5726b796260c6b
 2007-06-13 16:49:48 +00:00
danielk1977
e965ac7773 Fix for #2409. Return SQLITE_IOERR_BLOCKED instead of SQLITE_BUSY in cases where failure to obtain a database lock leaves the cache in an inconsistent state. 
See additional information at CorruptionFollowingBusyError. (CVS 4060)

FossilOrigin-Name: ce2c9925d06315d73fb5fd0c7265fb4cd65665aa
 2007-06-13 15:22:28 +00:00
drh
109b43507d In the "transaction" command of the TCL interface, if a COMMIT fails finish 
it with a rollback. (CVS 4059)

FossilOrigin-Name: 6da39fa4429400e21924074f5f219f4cb32415ff
 2007-06-12 18:50:13 +00:00
drh
9c86df5269 Fix a bug in the LIKE optimization that was causing the pattern string 
to be dequoted twice.  Ticket #2407. (CVS 4056)

FossilOrigin-Name: abf64d1d0ae3e84c4482b38198eeb44b62cc5d9e
 2007-06-11 12:56:15 +00:00
drh
7361cb1f2c Define isnan() on windows. Ticket #2399. (CVS 4054) 
FossilOrigin-Name: fed9373e27b9d5338159a41772f8983420b902b0
 2007-06-10 22:57:33 +00:00
drh
b0e64f33da Documentation updates, in particular in the new limits.html file is added. (CVS 4053) 
FossilOrigin-Name: 4ca6cdae94f6d0a2c95755d4a250f9f3bc7a0d7b
 2007-06-09 09:53:51 +00:00
drh
3b62b2fa8b Use C-sylte comments exclusively, never C++ comments. Ticket #2406. (CVS 4052) 
FossilOrigin-Name: 8f5b789fea23d76128c10b37158de2525a54ce20
 2007-06-08 18:27:03 +00:00
drh
f07b484449 Make sure rowid comparisons against NULL work correctly. Ticket #2404. (CVS 4050) 
FossilOrigin-Name: 11ee8ea43f20f6146f4e4fcd9299468b3a99f998
 2007-06-08 08:39:01 +00:00
drh
0a168377ad Fix the query optimizer so that it correctly handles constant expressions 
in the ON clause of a LEFT JOIN.  Ticket #2403. (CVS 4049)

FossilOrigin-Name: 46fdd195483787eef209a9b8ad108eba147be6fa
 2007-06-08 00:20:47 +00:00
drh
98640a3fa1 Make sure zeroblob does reasonable things with a negative argument or 
an argument that is larger than the maximum blob size. (CVS 4048)

FossilOrigin-Name: f40218434e549144ddb48303df30e5191d44d3fc
 2007-06-07 19:08:32 +00:00
drh
0325d8731b Add the SQLITE_MAX_COMPOUND_SELECT compile-time parameter for limiting 
the number of terms in a compound select statement.  Set the default limit
to 100. (CVS 4046)

FossilOrigin-Name: 0d71ad4591eae9de8749fb2da6455ac661587f7a
 2007-06-07 10:55:35 +00:00
danielk1977
39984cdc8b Fix a vdbe stack leak that could occur where one side of a WHERE clause inequality evaluated to SQL null. (CVS 4045) 
FossilOrigin-Name: 17152bf1a268e130f0c43046bb438b617a747ff5
 2007-06-02 07:54:37 +00:00
danielk1977
9afe689ea4 Extend out-of-memory testing with fuzzily generated sql some. One fix for a problem found by the same. (CVS 4044) 
FossilOrigin-Name: d2282e64f1320913797dfb4dae4db0428a15a200
 2007-05-31 08:20:43 +00:00
danielk1977
c9cf901d8c Add some extra tests for malloc failure during expression parsing and execution using fuzzily generated SQL. (CVS 4043) 
FossilOrigin-Name: 7522d2fb3204d107b8b4816d7f39c88741f20230
 2007-05-30 10:36:47 +00:00
danielk1977
6b28f053fd Fix a problem with zeroblob() and CAST(...) expressions that could cause an assert() to fail. (CVS 4041) 
FossilOrigin-Name: 03750a2a6b5186689f7db6650c0a889429790b03
 2007-05-30 06:19:32 +00:00
danielk1977
bcbb04e501 Consider explicit collate clauses when matching WHERE constraints to indices. Fix for #2391. (CVS 4040) 
FossilOrigin-Name: f9a95e92dfaaa61ec0a44b9b7017b07929c94d26
 2007-05-29 12:11:29 +00:00
danielk1977
e48b1f1e9b Fix a typo in comments in sqlite.h.in. No code changes. Ticket #2384. (CVS 4038) 
FossilOrigin-Name: e8ae6214bfef4230096b6b56e688e9d4cd93f1b8
 2007-05-24 09:44:10 +00:00
danielk1977
369f3a050c Remove an assert() statement that may not be true if an IO or malloc error has occured. (CVS 4037) 
FossilOrigin-Name: 16c8e9c20cd2a7628c20a31c3e9605fe2d92ba2e
 2007-05-24 09:41:20 +00:00
danielk1977
deb403e797 Fix a page reference leak that could occur after an IO error. (CVS 4036) 
FossilOrigin-Name: d00c8242c610476c15d6eb4dc53fecab3971fea1
 2007-05-24 09:20:16 +00:00
danielk1977
d3a29ce7dc Remove an incorrect assert() statement that was being triggered by ioerr tests run in utf-16 mode. (CVS 4035) 
FossilOrigin-Name: c6575173be13296fbe57932f2d24a568f6d552ff
 2007-05-24 07:47:06 +00:00
danielk1977
2df71c742c Fix an assert() failure occuring in corrupt.test. (CVS 4034) 
FossilOrigin-Name: 3c54cddf23e3b9f62815d1b825110563f78cc325
 2007-05-24 07:22:42 +00:00
danielk1977
7677c0cc62 Add some code to MemTranslate() to prevent the READ_UTF8() macro from overreading a buffer. (CVS 4033) 
FossilOrigin-Name: 0595319cd716611bb5a12eb952e395283ea749bb
 2007-05-23 16:23:09 +00:00
danielk1977
17a240a25e Make sure the database schema has been read before compiling an incrmental_vacuum pragma. (CVS 4032) 
FossilOrigin-Name: efd7bcb34c1b4a0a3d4b954b90dfee93ac87bc86
 2007-05-23 13:50:23 +00:00
danielk1977
89a4be8af1 Fix a leaked page reference that could occur after an IO error in auto-vacuum databases. Also modify incrvacuum.test to work with DEFAULT_AUTOVACUUM=1 builds. (CVS 4031) 
FossilOrigin-Name: e691f2fa3d8c1bbb66d27eea299ae2fb1ea1a16d
 2007-05-23 13:34:32 +00:00
danielk1977
4ef24490a1 Fix a database corrupting bug in the optimistic overflow chain. Exposed by running bigrow.test with auto-vacuum enabled. (CVS 4030) 
FossilOrigin-Name: 10ee2d50cbcdcbbd8141ff2aba4fd2c0c0b70d67
 2007-05-23 09:52:41 +00:00
drh
7a4f5023a4 Additional comments ono the SQLITE_MIXED_ENDIAN_64BIT_FLOAT issue. (CVS 4029) 
FossilOrigin-Name: dd48a31e671de09f59661b2ba1a20e7b9f09099a
 2007-05-23 07:20:08 +00:00
drh
50027d1c0c Make sure zeroblob() works with the concatenation operator. Ticket #2379. (CVS 4028) 
FossilOrigin-Name: 6e19ef758207cedd6db8b2796ef5d4d688cc0b62
 2007-05-23 06:31:38 +00:00
danielk1977
b39f70b04a Change the way overflow pages are allocated from the free-list to increase the chance that they are a contiguous block. Much more can still be done. (CVS 4023) 
FossilOrigin-Name: b7391892041eb72b0ebcbb7a9a6721ae3482dd80
 2007-05-17 18:28:11 +00:00
danielk1977
6338c762a5 Bring the autoconf based build system up to date with the recent changes. #2366, #2367 and #2368. (CVS 4022) 
FossilOrigin-Name: ae644bc7aad229f2d219ea20eb4774318feb3051
 2007-05-17 16:38:30 +00:00
danielk1977
5b159dc312 Fix a problem with casting blobs to numeric types. (CVS 4021) 
FossilOrigin-Name: f2ce727c4d798c666e95876a2b67e8a305d82e3a
 2007-05-17 16:34:43 +00:00
danielk1977
63c64f3b8c Add speed3.test file. For testing performance issues related to overflow pages. (CVS 4020) 
FossilOrigin-Name: 684f765df3e8a4836f254717d175a4a7b5e7d15f
 2007-05-17 14:45:12 +00:00
danielk1977
92182323e0 Remove the SKIP_UTF16 macros (they are no longer in use). (CVS 4018) 
FossilOrigin-Name: 73e654fbdc791daa10c49557bf479f152586ac28
 2007-05-16 18:23:05 +00:00
danielk1977
a9c16b0a38 Fix handling of utf-16 encoding of code point 0xE000. (CVS 4017) 
FossilOrigin-Name: bfc35ce8673ce51f726535b90c1d86be272848bb
 2007-05-16 18:11:41 +00:00
danielk1977
2be2be92c4 Avoid passing a negative value to isspace() in a couple places. (CVS 4016) 
FossilOrigin-Name: d5db8be3680e16a74edb385dfa3730c66d5f4fd6
 2007-05-16 17:50:45 +00:00
danielk1977
1cc5ed8150 Change a few selected functions to macros to speed things up. (CVS 4015) 
FossilOrigin-Name: 93f811ec747f6a42daf9ee27cd8b013f248552a1
 2007-05-16 17:28:43 +00:00
danielk1977
246ad31db6 Omit some extra code when OMIT_INCRBLOB is defined. (CVS 4014) 
FossilOrigin-Name: 1d89be287d34423b1a405cde0490260e7c731f07
 2007-05-16 14:23:00 +00:00
drh
cd7b46db84 Keep the full precision of integers if possible when casting to "numeric". 
Ticket #2364. (CVS 4012)

FossilOrigin-Name: 2ac985a38034da87b0fa3837976e1f2164b22672
 2007-05-16 11:55:56 +00:00
drh
7e326c09c2 Make sure pParse->rc gets set whenever sqlite3ErrorMsg() is called. This is 
added insurance that parsing will stop quickly after an error.  This change
did make the parser stop faster in some cases, which required some revisions
to tests. (CVS 4010)

FossilOrigin-Name: f84d9dab110c4415d9b772f8043397640162b6b2
 2007-05-15 16:51:37 +00:00
drh
f076504b1c Remove the alternative UTF-16 implementation of SUBSTR(). It does not 
work anymore and the UTF-8 version can do everything that the UTF-16
version does. (CVS 4009)

FossilOrigin-Name: 9b91502ef0ea9c0bfb8362c4b70314dc8449eb9e
 2007-05-15 14:40:11 +00:00
drh
9a087a99e5 Relax the restriction on using bytes 0x80 through 0xbf as the first 
character of an identifier.  Enhancements to ALTER TABLE tests for
tables with strange names or stange column names. (CVS 4008)

FossilOrigin-Name: 262a3e6339b31f269f8f07e43d295b90827e2779
 2007-05-15 14:34:32 +00:00
drh
150dbacea4 Fix to check-in (4005). A call to sqlite3_column_blob() should not make 
subsequent calls to sqlite3_column_type() return SQLITE_BLOB.
Sqlite3_column_type() returns the initial type. (CVS 4006)

FossilOrigin-Name: b5e85deb5a0316781a6f39d6085b9fcfb9f88c6d
 2007-05-15 14:10:40 +00:00
drh
1f0feef80b Clarification on the best practices for using the _bytes() APIs. 
Change sqlite3_value_blob() to force the representation to be purely
a BLOB and not a dual BLOB/String.  Ticket #2360. (CVS 4005)

FossilOrigin-Name: cf2dd45b58380de7f3e167b5357848d12872caa3
 2007-05-15 13:27:07 +00:00
drh
4a919118d3 A new approach for UTF-8 translation. (CVS 4004) 
FossilOrigin-Name: 6c8ad2790eaede90b3f1ef62614e667178b2a8c4
 2007-05-15 11:55:09 +00:00
drh
eab7f3fe8d Do not allow bytes 0x80 through 0xBF to be the first character of an 
identifer because no valid UTF-8 character can begin with those bytes.
If we allowed an identifier to begin with one of those bytes, then the
substr() function in ALTER TABLE will not work correctly. (CVS 4003)

FossilOrigin-Name: 252810424d8c4dcd19b369d62027094df7cf0bcc
 2007-05-15 09:00:14 +00:00
danielk1977
15d7982ad8 A fix for queries that used correlated, compound sub-queries in the HAVING clause. Also update fuzz.test some more. (CVS 4001) 
FossilOrigin-Name: da0c1ab4deedd2b952a43b3af6962a9403f8c9ee
 2007-05-15 07:00:34 +00:00
drh
4e5dd85135 Fix problems in ALTER TABLE that occur when column or table names are 
invalid UTF encodings. (CVS 4000)

FossilOrigin-Name: 9ff382f4584ff685a78b39f24424319709efb382
 2007-05-15 03:56:49 +00:00
drh
e279195400 Fix a typo in a comment. Ticket #2359. (CVS 3999) 
FossilOrigin-Name: 1fbbc108a9e7ad1dc22c08ee990e2b6b949784eb
 2007-05-15 02:45:18 +00:00
drh
eaad32b1df Fix a bug in sqlite3_mprintf() which could have caused a buffer 
overrun if malloc() failed. (CVS 3998)

FossilOrigin-Name: 5af49a57d4866be21c0206f34584bcc63adc1315
 2007-05-15 02:34:09 +00:00
drh
f764e6fc3d The built-in substr() function applied to a BLOB counts bytes, not characters. (CVS 3997) 
FossilOrigin-Name: 75d573080d03ee48fe88710f70c6875ff9cae19c
 2007-05-15 01:13:47 +00:00