]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
13 years agoReset the sqlite3_data_directory and sqlite3_temp_directory variables when the sqlite...
mistachkin [Fri, 16 Mar 2012 10:28:40 +0000 (10:28 +0000)] 
Reset the sqlite3_data_directory and sqlite3_temp_directory variables when the sqlite3_shutdown function is called since they may refer to memory allocated by the heap subsystem that was just shutdown.

FossilOrigin-Name: cd70bc4b788b947d47a7a7158c27028160df06bd

13 years agoAdd SQLITE_WIN32_HEAP_CREATE compiler define to control whether or not the Win32...
mistachkin [Thu, 15 Mar 2012 03:40:59 +0000 (03:40 +0000)] 
Add SQLITE_WIN32_HEAP_CREATE compiler define to control whether or not the Win32 native allocator will create an isolated heap for all allocated data.

FossilOrigin-Name: 8693fb652ecd1ad0b03e9067839970b321c3f904

13 years agoFix macro issues for osGetProcessHeap and sqlite3_win32_write_debug.
mistachkin [Wed, 14 Mar 2012 23:08:59 +0000 (23:08 +0000)] 
Fix macro issues for osGetProcessHeap and sqlite3_win32_write_debug.

FossilOrigin-Name: d3d071598aba367e3d73001ab38d7a78306875ea

13 years agoFix typos, use #if instead of #ifdef when checking for the Win32 native heap validati...
mistachkin [Wed, 14 Mar 2012 20:20:37 +0000 (20:20 +0000)] 
Fix typos, use #if instead of #ifdef when checking for the Win32 native heap validation define.

FossilOrigin-Name: 845aa46f69784420ada4116078f8dc0a68cf3707

13 years agoAvoid redefining macros. Enable use of the Win32 native heap on WinRT. Use the...
mistachkin [Wed, 14 Mar 2012 20:17:34 +0000 (20:17 +0000)] 
Avoid redefining macros.  Enable use of the Win32 native heap on WinRT.  Use the syscall table to call OutputDebugStringW and fix type casting warnings.

FossilOrigin-Name: 46c412a8f6470c9e8c4bdeafaf4db435fbb694ab

13 years agoRemove SQLITE_OS_WINRT setting from MSVC makefile.
mistachkin [Wed, 14 Mar 2012 03:41:32 +0000 (03:41 +0000)] 
Remove SQLITE_OS_WINRT setting from MSVC makefile.

FossilOrigin-Name: df4caf1326f5aa3ba11345e5e9604d7af4385fe8

13 years agoAdd warning to the docs about changing the data directory when a database connection...
mistachkin [Wed, 14 Mar 2012 01:28:35 +0000 (01:28 +0000)] 
Add warning to the docs about changing the data directory when a database connection is open.

FossilOrigin-Name: c07cd85ca9698b48f960b164cab3a38472a17640

13 years agoAdd experimental support for resolving relative database file paths using a fixed...
mistachkin [Wed, 14 Mar 2012 00:44:01 +0000 (00:44 +0000)] 
Add experimental support for resolving relative database file paths using a fixed user-defined directory.

FossilOrigin-Name: 7354ae8fd3eccee2cf9f6501da5b1a014c31556f

13 years agoAdd assert to verify the number of characters to write in sqlite3_win32_write_debug.
mistachkin [Tue, 13 Mar 2012 03:38:22 +0000 (03:38 +0000)] 
Add assert to verify the number of characters to write in sqlite3_win32_write_debug.

FossilOrigin-Name: 8083f6164f3308c1c1d4f4d84be1894e382fe2e6

13 years agoDefer creation of the sleep event object until it is needed. Added sqlite3_win32_wri...
mistachkin [Tue, 13 Mar 2012 03:35:07 +0000 (03:35 +0000)] 
Defer creation of the sleep event object until it is needed.  Added sqlite3_win32_write_debug and sqlite3_win32_sleep APIs to assist in portability to WinRT.

FossilOrigin-Name: 7af88ad306612dd316827c506dbf8df7477b2ec1

13 years agoCleanup the Windows syscall table, removing the unused CreateFileMapping entry.
mistachkin [Tue, 13 Mar 2012 01:30:20 +0000 (01:30 +0000)] 
Cleanup the Windows syscall table, removing the unused CreateFileMapping entry.

FossilOrigin-Name: fb7d8bf6ec5c0ef9a948bc14c28770e34f57db1a

13 years agoMore changes required to compile for WinRT using VS 11 beta. Also, replace more...
mistachkin [Tue, 13 Mar 2012 01:16:57 +0000 (01:16 +0000)] 
More changes required to compile for WinRT using VS 11 beta.  Also, replace more APIs with their WinRT alternatives.

FossilOrigin-Name: 6b997d9c32076c480ff4f101ff93bae3f443e252

13 years agoMerge test current directory value fix from trunk and fix uri tests.
mistachkin [Thu, 8 Mar 2012 20:39:08 +0000 (20:39 +0000)] 
Merge test current directory value fix from trunk and fix uri tests.

FossilOrigin-Name: 88963c33c19a051280f7f31bdc1b322d6837cf43

13 years agoOn Windows, make sure the returned test current directory value does not contain...
mistachkin [Thu, 8 Mar 2012 20:28:31 +0000 (20:28 +0000)] 
On Windows, make sure the returned test current directory value does not contain any backslashes.

FossilOrigin-Name: efee39e64bd95c284220fdb0ae8ee6c1847fadab

13 years agoMerge and manually resolve testing updates from trunk.
mistachkin [Thu, 8 Mar 2012 20:22:42 +0000 (20:22 +0000)] 
Merge and manually resolve testing updates from trunk.

FossilOrigin-Name: 5eecdb44dd809e91002b8ecf59ada72f4b56549a

13 years agoOn Windows, make sure the current directory value used by the test suite is 'normaliz...
mistachkin [Thu, 8 Mar 2012 20:00:36 +0000 (20:00 +0000)] 
On Windows, make sure the current directory value used by the test suite is 'normalized' to what the parent command shell sees.  Also, clean the test directories used by the quota2.test file.

FossilOrigin-Name: 82bcd7ec1531f6d71c079578434c58d3ce46a1de

13 years agoWhen compiled for WinRT, use the CreateFile2 and LoadPackagedLibrary functions instea...
mistachkin [Wed, 7 Mar 2012 20:11:47 +0000 (20:11 +0000)] 
When compiled for WinRT, use the CreateFile2 and LoadPackagedLibrary functions instead of CreateFile and LoadLibrary.

FossilOrigin-Name: 27d6942ca270d6e724ffd230ed58a8683d67dfa4

13 years agoMerge in the latest trunk changes.
drh [Wed, 7 Mar 2012 16:52:38 +0000 (16:52 +0000)] 
Merge in the latest trunk changes.

FossilOrigin-Name: ca4708531a5e0debbe3d0999a4d210ef2a347972

13 years agoFix for test issues when there is no current directory support due to being compiled...
mistachkin [Tue, 6 Mar 2012 03:00:49 +0000 (03:00 +0000)] 
Fix for test issues when there is no current directory support due to being compiled for WinRT.

FossilOrigin-Name: a811cb01528beab8afd899411d187d4d960ddcc8

13 years agoAdd compile-time define to indicate if the VFS supports the concept of a current...
mistachkin [Mon, 5 Mar 2012 22:52:33 +0000 (22:52 +0000)] 
Add compile-time define to indicate if the VFS supports the concept of a current directory (as WinCE and WinRT do not).  Avoid using the GetTempPath and GetFullPathName APIs on WinRT.  Some tests still need adjustments.

FossilOrigin-Name: 86c049a171acc3f4a43771f3e7176a90210d7799

13 years agoFix a problem compiling the test code in fts3_test.c when SQLITE_ENABLE_FTS3 is not...
dan [Mon, 5 Mar 2012 16:24:26 +0000 (16:24 +0000)] 
Fix a problem compiling the test code in fts3_test.c when SQLITE_ENABLE_FTS3 is not defined.

FossilOrigin-Name: b00ccda307caae597c143ab0586f90acb77f79cf

13 years agoMerge the fts4-languageid branch with the trunk.
dan [Mon, 5 Mar 2012 15:33:32 +0000 (15:33 +0000)] 
Merge the fts4-languageid branch with the trunk.

FossilOrigin-Name: 99a9073b5e411ce94f38ce49608baaa15de8b850

13 years agoWhen creating the event used to sleep on WinRT, request the minimum access rights...
mistachkin [Sun, 4 Mar 2012 02:56:10 +0000 (02:56 +0000)] 
When creating the event used to sleep on WinRT, request the minimum access rights required for the desired operations on it (i.e. SYNCHRONIZE).

FossilOrigin-Name: ed603d75941ace159773b1a22ace84d51b630ad5

13 years agoAdd the xLanguageid method to sqlite3_fts3_tokenizer versions 1 and greater. fts4-languageid
dan [Sat, 3 Mar 2012 18:46:41 +0000 (18:46 +0000)] 
Add the xLanguageid method to sqlite3_fts3_tokenizer versions 1 and greater.

FossilOrigin-Name: f8e9c445dd358c40e5a7bf3756b9f291909dbea7

13 years agoWhen compiled for WinRT, avoid using MapViewOfFile and GetFileAttributes. Also,...
mistachkin [Sat, 3 Mar 2012 13:15:25 +0000 (13:15 +0000)] 
When compiled for WinRT, avoid using MapViewOfFile and GetFileAttributes.  Also, reset the private 'sleep' event handle when the VFS is cleaned up.

FossilOrigin-Name: 38df8fc1b49d55b61cb168a61134b4a314a62f21

13 years agoAdd a test case for ticket [3557ad65a076c].
drh [Sat, 3 Mar 2012 01:44:12 +0000 (01:44 +0000)] 
Add a test case for ticket [3557ad65a076c].

FossilOrigin-Name: 4f34d7077b9acf7926c5e7375ca870d4ed3c60b9

13 years agoFix a bug [3557ad65a07] that causes incorrect DISTINCT processing on
drh [Sat, 3 Mar 2012 00:34:47 +0000 (00:34 +0000)] 
Fix a bug [3557ad65a07] that causes incorrect DISTINCT processing on
an indexed query involving the IN operator.

FossilOrigin-Name: dec9a995d7012a1f85be4edb71240b9d4f07c60e

13 years agoWhen compiled for WinRT, avoid using the FORMAT_MESSAGE_ALLOCATE_BUFFER flag to Forma...
mistachkin [Fri, 2 Mar 2012 23:53:54 +0000 (23:53 +0000)] 
When compiled for WinRT, avoid using the FORMAT_MESSAGE_ALLOCATE_BUFFER flag to FormatMessage (i.e. because LocalFree is unavailable).

FossilOrigin-Name: 9eb331be7e905d11d9075ce1596478b55a7f488b

13 years agoFix test pragma-19.5 so that it works on file names that may contain spaces and/or...
mistachkin [Fri, 2 Mar 2012 22:41:06 +0000 (22:41 +0000)] 
Fix test pragma-19.5 so that it works on file names that may contain spaces and/or backslashes.

FossilOrigin-Name: 9aaa1ab7c63c9045fecf5e965b333cc5f28b0791

13 years agoWhen running on Windows with an NT-based kernel, always use the LockFileEx/UnlockFile...
mistachkin [Fri, 2 Mar 2012 22:38:49 +0000 (22:38 +0000)] 
When running on Windows with an NT-based kernel, always use the LockFileEx/UnlockFileEx functions (with the correct flags).

FossilOrigin-Name: 3e7ba3ddb956056b8132ed383feed4f329c634e0

13 years agoRemove an obsolete comment from FTS3. No code changes.
drh [Fri, 2 Mar 2012 20:34:57 +0000 (20:34 +0000)] 
Remove an obsolete comment from FTS3.  No code changes.

FossilOrigin-Name: 74d224b14467d8a6915d3cf372f45e0d28708fa2

13 years agoFix problems with combining content= and languageid= in a single fts4 table.
dan [Fri, 2 Mar 2012 19:53:02 +0000 (19:53 +0000)] 
Fix problems with combining content= and languageid= in a single fts4 table.

FossilOrigin-Name: 22491e7bc38aee43819b888e04241cb6a6ef73a3

13 years agoAdd test for FTS 'rebuild' command.
dan [Fri, 2 Mar 2012 16:18:21 +0000 (16:18 +0000)] 
Add test for FTS 'rebuild' command.

FossilOrigin-Name: 181bc35731f19c3e4497ba3338c209918d34ea69

13 years agoAdd new Win32 APIs used to the system call table. Add error handling code for SetFil...
mistachkin [Fri, 2 Mar 2012 13:47:16 +0000 (13:47 +0000)] 
Add new Win32 APIs used to the system call table.  Add error handling code for SetFilePointerEx.  Make sure the last error number is saved from the call to GetFileInformationByHandleEx.

FossilOrigin-Name: a782d2dc3cd4ef49ed46b361cdd331be846c3d50

13 years agoFix the FTS 'optimize' command on multi-lingual databases.
dan [Fri, 2 Mar 2012 12:26:19 +0000 (12:26 +0000)] 
Fix the FTS 'optimize' command on multi-lingual databases.

FossilOrigin-Name: 65fa693729a336e4d905ce72e6b9ccf4faa772bd

13 years agoFix a bug in merging FTS language tables for languages other than language 0.
dan [Fri, 2 Mar 2012 11:48:50 +0000 (11:48 +0000)] 
Fix a bug in merging FTS language tables for languages other than language 0.

FossilOrigin-Name: d281cb8984c911a4c0cce2ec299e1351d8e580e4

13 years agoOmit all ANSI APIs for winRT.
drh [Fri, 2 Mar 2012 00:00:47 +0000 (00:00 +0000)] 
Omit all ANSI APIs for winRT.

FossilOrigin-Name: cbf23b461f599d0b025c0f42dd3189cfa4e84bac

13 years agoUse GetInformationByHandleEx() instead of GetFileSize() on winRT.
drh [Thu, 1 Mar 2012 22:44:56 +0000 (22:44 +0000)] 
Use GetInformationByHandleEx() instead of GetFileSize() on winRT.

FossilOrigin-Name: 119f251de77aa88cf8ff9fcc72bfbecbe6b741e3

13 years agoDo not run the large file tests if a file named "skip-big-file" exists
drh [Thu, 1 Mar 2012 22:33:41 +0000 (22:33 +0000)] 
Do not run the large file tests if a file named "skip-big-file" exists
in the test directory.  This enables tests to be run much faster on
systems that lack sparse file support.

FossilOrigin-Name: 5a83912352ad6626970efd72e70c433e3a219b6b

13 years agoUse SetFilePointerEx() instead of SetFilePointer() on winRT.
drh [Thu, 1 Mar 2012 22:06:30 +0000 (22:06 +0000)] 
Use SetFilePointerEx() instead of SetFilePointer() on winRT.

FossilOrigin-Name: 36efafc618017b6448f222776d0143e5f98d1e65

13 years agoFix a typo in the header comment of sqlite3_commit_hook().
drh [Thu, 1 Mar 2012 21:30:44 +0000 (21:30 +0000)] 
Fix a typo in the header comment of sqlite3_commit_hook().

FossilOrigin-Name: 3784d1475b49f24e4a51450edc94aee66fd48fe4

13 years agoUse WaitForSingleObjectEx() as a substitute for Sleep on winRT.
drh [Thu, 1 Mar 2012 21:19:39 +0000 (21:19 +0000)] 
Use WaitForSingleObjectEx() as a substitute for Sleep on winRT.

FossilOrigin-Name: bf897be0daa2f7e16f63b78849ffb76ce02d48f1

13 years agoAdd recognition of the SQLITE_OS_WINRT compile-time option.
drh [Thu, 1 Mar 2012 20:05:41 +0000 (20:05 +0000)] 
Add recognition of the SQLITE_OS_WINRT compile-time option.
Use InitializeCriticalSectionEx() under winRT.

FossilOrigin-Name: 8b7ca8a09f7b69db1fe766616cba0307e681a6f3

13 years agoAdd the "languageid=" option to fts4. This code is still largely untested and alsmost...
dan [Thu, 1 Mar 2012 19:44:20 +0000 (19:44 +0000)] 
Add the "languageid=" option to fts4. This code is still largely untested and alsmost certainly buggy.

FossilOrigin-Name: bea257f70f10dd1111d79cabd1e1462dc651704d

13 years agoAdd back in some #includes that were removed incorrectly by the
drh [Thu, 1 Mar 2012 19:14:13 +0000 (19:14 +0000)] 
Add back in some #includes that were removed incorrectly by the
previous check-in.

FossilOrigin-Name: 718905367ff3f86a449c2c27f724089ba31dea3a

13 years agoRemove unused #defines from os.h.
drh [Thu, 1 Mar 2012 18:16:48 +0000 (18:16 +0000)] 
Remove unused #defines from os.h.

FossilOrigin-Name: c0891296b49fb95917db8a881425f8131cbf6de7

13 years agoFix spurious errors that may occur if an empty database is opened and then initialize...
dan [Tue, 28 Feb 2012 17:57:34 +0000 (17:57 +0000)] 
Fix spurious errors that may occur if an empty database is opened and then initialized as a WAL database by a second connection.

FossilOrigin-Name: 16330a2f7262173a32ae48a72c0ee2522b6dc554

13 years agoFix a case where an error code was being overwritten in multiplexDelete().
dan [Tue, 28 Feb 2012 11:52:12 +0000 (11:52 +0000)] 
Fix a case where an error code was being overwritten in multiplexDelete().

FossilOrigin-Name: c267893a0813beb1764071409025e178318e1ca3

13 years agoFix the xDelete implementation of the multiplexor VFS so that it correctly
drh [Mon, 27 Feb 2012 14:28:50 +0000 (14:28 +0000)] 
Fix the xDelete implementation of the multiplexor VFS so that it correctly
deletes overflow WAL files.

FossilOrigin-Name: e44e26771e5aa48f3bfa14d6db3e669b5b2a1e73

13 years agoSeparate multiplexor overflow pages for -wal and -journal files into
drh [Fri, 24 Feb 2012 16:13:55 +0000 (16:13 +0000)] 
Separate multiplexor overflow pages for -wal and -journal files into
separate namespaces when in 8+3 filename mode.

FossilOrigin-Name: d6850667ea61172ea0ebea4a22b6b306f74775fa

13 years agoFix the multiplexor so that it works with WAL mode and 8+3 filenames.
drh [Fri, 24 Feb 2012 15:57:13 +0000 (15:57 +0000)] 
Fix the multiplexor so that it works with WAL mode and 8+3 filenames.

FossilOrigin-Name: a9fcb46bc08c29aebaf3bc999f45846c3c320f68

13 years agoAdd #ifdef SQLITE_ENABLE_ZIPVFS around those bits of code that are only
drh [Fri, 24 Feb 2012 14:33:28 +0000 (14:33 +0000)] 
Add #ifdef SQLITE_ENABLE_ZIPVFS around those bits of code that are only
used by ZIPVFS.

FossilOrigin-Name: 3130275c64a60c5cfacbd11123305e6d99ea866d

13 years agoIf the SQLITE_FCNTL_PRAGMA file control returns something other than
drh [Fri, 24 Feb 2012 00:03:12 +0000 (00:03 +0000)] 
If the SQLITE_FCNTL_PRAGMA file control returns something other than
SQLITE_NOTFOUND, then skip the rest of Pragma code generation.

FossilOrigin-Name: 9e6d340f557c2f2c8a07300ac60357af9906a7fa

13 years agoA simple change that allows the SQLITE_32BIT_ROWID compile-time option to
drh [Fri, 24 Feb 2012 00:02:28 +0000 (00:02 +0000)] 
A simple change that allows the SQLITE_32BIT_ROWID compile-time option to
work better.

FossilOrigin-Name: f9df4063fbd100ce306a89fc649c1860fd801f31

13 years agoFix an obscure bug that causes a crash when parsing certain invalid SQL
drh [Thu, 23 Feb 2012 17:35:28 +0000 (17:35 +0000)] 
Fix an obscure bug that causes a crash when parsing certain invalid SQL
statements.

FossilOrigin-Name: c8c7846fb990199dcc0774a69e8257510bc36f2d

13 years agoFix a typo made inside an assert() statement in the previous commit.
dan [Thu, 23 Feb 2012 16:45:42 +0000 (16:45 +0000)] 
Fix a typo made inside an assert() statement in the previous commit.

FossilOrigin-Name: f0640615f25ebe8bf2eed0e1a0f2e309471889fe

13 years agoAdd the sqlite3PagerWalFramesize() function to pager.c. This is used by zipvfs.
dan [Thu, 23 Feb 2012 15:35:49 +0000 (15:35 +0000)] 
Add the sqlite3PagerWalFramesize() function to pager.c. This is used by zipvfs.

FossilOrigin-Name: 786e24dc56504d1958db0618e645610f2600a087

13 years agoExpose the sqlite3_stricmp() interface. Add the SQLITE_FCNTL_PRAGMA file
drh [Thu, 23 Feb 2012 14:28:46 +0000 (14:28 +0000)] 
Expose the sqlite3_stricmp() interface.  Add the SQLITE_FCNTL_PRAGMA file
control.

FossilOrigin-Name: c539cf21ef8f4eb4782790aa97a67d10ae9ffd64

13 years agoMove test logic for SQLITE_FCNTL_PRAGMA out of os_unix.c and into test_vfs.c. file-control-pragma
drh [Wed, 22 Feb 2012 20:08:49 +0000 (20:08 +0000)] 
Move test logic for SQLITE_FCNTL_PRAGMA out of os_unix.c and into test_vfs.c.

FossilOrigin-Name: c81fc40b2b584820ac7d1c3848ebeb7225d4eeeb

13 years agoIf the SQLITE_FCNTL_PRAGMA file-control returns anything other than
drh [Wed, 22 Feb 2012 19:56:17 +0000 (19:56 +0000)] 
If the SQLITE_FCNTL_PRAGMA file-control returns anything other than
SQLTIE_NOTFOUND and SQLITE_OK, then treat the result as an error.

FossilOrigin-Name: 5643618108a8aafba67ed4004039b862bb5e5da8

13 years agoDisable the "filename" pragma implemented by os_unix.c except when compiled
drh [Wed, 22 Feb 2012 19:03:19 +0000 (19:03 +0000)] 
Disable the "filename" pragma implemented by os_unix.c except when compiled
with SQLITE_TEST.

FossilOrigin-Name: 9a1da91850b6074e5f9d18382f517eb868cad63c

13 years agoMake benign any malloc failures inside the sqlite3_file_control() call within
drh [Wed, 22 Feb 2012 18:21:20 +0000 (18:21 +0000)] 
Make benign any malloc failures inside the sqlite3_file_control() call within
PRAGMA parsing.  Add a couple simple tests for SQLITE_FCNTL_PRAGMA.

FossilOrigin-Name: a1f29fa653b788f563967f55c3d20e64cbe3f549

13 years agoChange the SQLITE_FCNTL_PRAGMA file-control so that it can return a string
drh [Wed, 22 Feb 2012 16:58:36 +0000 (16:58 +0000)] 
Change the SQLITE_FCNTL_PRAGMA file-control so that it can return a string
value.

FossilOrigin-Name: fd8d7440277b17f57a6dc0a210f42adf1fa2dcd2

13 years agoBegin adding support for SQLITE_FCNTL_PRAGMA.
drh [Wed, 22 Feb 2012 14:45:19 +0000 (14:45 +0000)] 
Begin adding support for SQLITE_FCNTL_PRAGMA.

FossilOrigin-Name: 5be07904baf6e5b8b99ca6f4bb6ddec973e59cd4

13 years agoAvoid redefining NDEBUG if the fuzzer is included in an amalagmated source file.
drh [Tue, 21 Feb 2012 18:35:42 +0000 (18:35 +0000)] 
Avoid redefining NDEBUG if the fuzzer is included in an amalagmated source file.

FossilOrigin-Name: f8ac826f95ae6b7b981e4765d2e65b6839d0eff9

13 years agoPrevent the fuzzer from ever returning a string longer than 100 bytes.
dan [Tue, 21 Feb 2012 18:00:20 +0000 (18:00 +0000)] 
Prevent the fuzzer from ever returning a string longer than 100 bytes.

FossilOrigin-Name: 969095ca3067d60f4d3a0a4ad419541cb8b146db

13 years agoFurther fuzzer test cases. Fix a case in the fuzzer where an error code was being...
dan [Tue, 21 Feb 2012 14:11:12 +0000 (14:11 +0000)] 
Further fuzzer test cases. Fix a case in the fuzzer where an error code was being dropped.

FossilOrigin-Name: 8b77d3953f082e6fa42e42fe903ea9eddf99dd91

13 years agoAdd further test cases and minor fixes for the fuzzer.
dan [Tue, 21 Feb 2012 10:36:27 +0000 (10:36 +0000)] 
Add further test cases and minor fixes for the fuzzer.

FossilOrigin-Name: 583dde93a9176ba4fff85241bafbbe4e5a6cc95f

13 years agoUpdates to the instructions in the header comment of the fuzzer implementation.
drh [Mon, 20 Feb 2012 22:44:12 +0000 (22:44 +0000)] 
Updates to the instructions in the header comment of the fuzzer implementation.
New test cases for the fuzzer.

FossilOrigin-Name: bf1dc7907cf1a5c7e19b04fa1278b2089316c30a

13 years agoChange the way the fuzzer (test_fuzzer.c) works so that it loads its configuration...
dan [Mon, 20 Feb 2012 20:03:48 +0000 (20:03 +0000)] 
Change the way the fuzzer (test_fuzzer.c) works so that it loads its configuration from a database table.

FossilOrigin-Name: 90b7b957f8933047fd2878048dfa3ec4891988b8

13 years agoFix a case in test_fuzzer.c causing transformations from the wrong ruleset to be...
dan [Mon, 20 Feb 2012 19:36:09 +0000 (19:36 +0000)] 
Fix a case in test_fuzzer.c causing transformations from the wrong ruleset to be applied in some cases.

FossilOrigin-Name: cb5f5ebc563b8d3e47bc30b6dbb374bb91efd3ef

13 years agoIncrease the maximum ruleset id in the fuzzer from 50 to 2^31-1.
drh [Tue, 14 Feb 2012 18:56:01 +0000 (18:56 +0000)] 
Increase the maximum ruleset id in the fuzzer from 50 to 2^31-1.

FossilOrigin-Name: 760e009adc6d0fffb8e6f64c7ec283938a417a77

13 years agoEnhance the fuzzer virtual table to support multiple rule sets.
drh [Tue, 14 Feb 2012 15:34:50 +0000 (15:34 +0000)] 
Enhance the fuzzer virtual table to support multiple rule sets.

FossilOrigin-Name: a82938731b21d6166d7d482994cb065c8b725083

13 years agoMerge the non-blocking ROLLBACK changes into trunk.
drh [Mon, 13 Feb 2012 21:24:03 +0000 (21:24 +0000)] 
Merge the non-blocking ROLLBACK changes into trunk.

FossilOrigin-Name: 9c572d424a20b0585bfac358a5d1ee5276dd05ba

13 years agoFix a harmless compiler warning introduced by the previous check-in.
drh [Mon, 13 Feb 2012 20:28:15 +0000 (20:28 +0000)] 
Fix a harmless compiler warning introduced by the previous check-in.

FossilOrigin-Name: a8a042a751557d06bf04455ed7629cb29adcd87f

13 years agoOn unix, ignore the umask when creating journal files. That way, journal files
drh [Mon, 13 Feb 2012 20:16:37 +0000 (20:16 +0000)] 
On unix, ignore the umask when creating journal files.  That way, journal files
will have exactly the same permissions as the original database and any
process that has permission to write to the database can also recover
hot journals.

FossilOrigin-Name: 84b324606adc8437338c086404eb157f30f04130

13 years agoAdd the new SQLITE_ABORT_ROLLBACK extended error code to be returned for nonblocking-rollback
drh [Mon, 13 Feb 2012 17:01:51 +0000 (17:01 +0000)] 
Add the new SQLITE_ABORT_ROLLBACK extended error code to be returned for
statements that are cancelled due to a rollback.

FossilOrigin-Name: 549f4fd00d8325c10099b100e5202b77ee1d83ad

13 years agoChange the ROLLBACK command so that pending statements to not block it. The
drh [Mon, 13 Feb 2012 16:43:16 +0000 (16:43 +0000)] 
Change the ROLLBACK command so that pending statements to not block it.  The
pending statements instead return SQLITE_ABORT upon next access.  Note: This
causes separate shared-cache connections in read_uncommitted mode to abort as
well.

FossilOrigin-Name: 9b66c79e054c8a109d1ee8d35fed1c42814c330d

13 years agoChanges to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT...
dan [Mon, 13 Feb 2012 10:00:35 +0000 (10:00 +0000)] 
Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined.

FossilOrigin-Name: 76bb649ee2633226324130f5898622c348f93769

13 years agoFix a typo in the type of the fchown() function in os_unix.c.
dan [Mon, 13 Feb 2012 08:50:23 +0000 (08:50 +0000)] 
Fix a typo in the type of the fchown() function in os_unix.c.

FossilOrigin-Name: bfbfe05b81919ecc3d6e7be4c24994f795f16582

13 years agoMake fchown() an overrideable system call in os_unix.c.
drh [Sat, 11 Feb 2012 23:55:15 +0000 (23:55 +0000)] 
Make fchown() an overrideable system call in os_unix.c.

FossilOrigin-Name: 98efac9630ca96ba0497c8e206dc5022612ff381

13 years agoCleanup some directories and files left by the MinGW build, even when using the MSVC...
mistachkin [Sat, 11 Feb 2012 22:19:26 +0000 (22:19 +0000)] 
Cleanup some directories and files left by the MinGW build, even when using the MSVC Makefile.

FossilOrigin-Name: 3ab89e255d1f2f8004d3256515ac43f74e57f39b

13 years agoRevise the preprocessor directives used to handle malloc.h and _msize, in order to...
mistachkin [Sat, 11 Feb 2012 21:56:59 +0000 (21:56 +0000)] 
Revise the preprocessor directives used to handle malloc.h and _msize, in order to detect and handle the MSVC special-case automatically.

FossilOrigin-Name: 90e73dc3682680847238e625d415b27fa9c59ba8

13 years agoSilence GCC compiler warnings about unused return value from fchown().
drh [Sat, 11 Feb 2012 21:21:17 +0000 (21:21 +0000)] 
Silence GCC compiler warnings about unused return value from fchown().

FossilOrigin-Name: b022547389a40930cf0d2a75f5eb293acc9fbfe0

13 years agoAnother attempt to fix warnings in the randomFunc() function.
drh [Sat, 11 Feb 2012 19:53:24 +0000 (19:53 +0000)] 
Another attempt to fix warnings in the randomFunc() function.

FossilOrigin-Name: 768df4e11670ac704d96e3b601d009aaa2fd793a

13 years agoWhen creating journal files (including -wal and -shm files) try to set the
drh [Sat, 11 Feb 2012 19:23:48 +0000 (19:23 +0000)] 
When creating journal files (including -wal and -shm files) try to set the
ownership to be the same as the original database.  This will prevent root
from locking out the original owner of the file.

FossilOrigin-Name: 1254dffe4071656a783cd000b1dd40c975ac18cb

13 years agoRemove a redundant test from the shared-memory logic in os_unix.c.
drh [Sat, 11 Feb 2012 18:51:34 +0000 (18:51 +0000)] 
Remove a redundant test from the shared-memory logic in os_unix.c.

FossilOrigin-Name: 31142ca795005bf664f34000591e6572c72652f2

13 years agoFix a warning coming from the Solaris Studio compiler.
drh [Fri, 10 Feb 2012 20:43:05 +0000 (20:43 +0000)] 
Fix a warning coming from the Solaris Studio compiler.

FossilOrigin-Name: 33294bbd1724665832464b33f865a29dc82b90f6

13 years agoDisable the ability to have multiple values in the VALUES clause of an
drh [Fri, 10 Feb 2012 17:38:58 +0000 (17:38 +0000)] 
Disable the ability to have multiple values in the VALUES clause of an
INSERT statement when SQLITE_OMIT_COMPOUND_SELECT is used.

FossilOrigin-Name: 92131195d0c24c0116992db51ed5d8316626ba57

13 years agoFix an important bug in the handling of EINTR in unixRead(). Never came
drh [Fri, 10 Feb 2012 03:10:27 +0000 (03:10 +0000)] 
Fix an important bug in the handling of EINTR in unixRead().  Never came
up on x86 but crashes on sparc.

FossilOrigin-Name: 1a16db0bca717a2582a48332d81854ca90d6d49b

13 years agoFix a boundary case for the integer affinity routine for non-x86 processors.
drh [Fri, 10 Feb 2012 01:25:13 +0000 (01:25 +0000)] 
Fix a boundary case for the integer affinity routine for non-x86 processors.

FossilOrigin-Name: bea05ddddf5089bac9b1aa9fe1d2cd24b069ad44

13 years agoAdd an autoconf test for malloc.h and use the results of that test to
drh [Wed, 8 Feb 2012 12:13:28 +0000 (12:13 +0000)] 
Add an autoconf test for malloc.h and use the results of that test to
conditionally #include the malloc.h header file.

FossilOrigin-Name: 16a471129d497f45935b5d00df7ce9ec731ee498

13 years agoCommand-line shell enhancements: Reorganize the "usage" comment so that
drh [Tue, 7 Feb 2012 14:13:50 +0000 (14:13 +0000)] 
Command-line shell enhancements:  Reorganize the "usage" comment so that
options are in alphabetical order.  Add the new "--cmd" option.  Allow
either "--option" or "-option" for options.

FossilOrigin-Name: 9497893b1b9219eac4ec2183bd90b4e4b860d9fe

13 years agoMore structure packing for smaller objects and less memory usage.
drh [Thu, 2 Feb 2012 21:02:43 +0000 (21:02 +0000)] 
More structure packing for smaller objects and less memory usage.

FossilOrigin-Name: f14e7f29ff7f2d7706dc3cdd715e103e04ba0ef1

13 years agoReduce the size of the MemPage object by about 32 bytes. Other structure
drh [Thu, 2 Feb 2012 19:37:18 +0000 (19:37 +0000)] 
Reduce the size of the MemPage object by about 32 bytes.  Other structure
size optimizations.

FossilOrigin-Name: 21695c3476804477cb378b5a643196380e7e2281

13 years agoWhen non-aggregate columns occur in an aggregate query with a single min()
drh [Thu, 2 Feb 2012 18:46:41 +0000 (18:46 +0000)] 
When non-aggregate columns occur in an aggregate query with a single min()
or max(), then the values of the non-aggregate columns are taken from
one of the rows that was the min() or max().

FossilOrigin-Name: fa13edd39c3b8ec752d4e90a69ebf7fed4ebf62f

13 years agoFix a problem with NULL handling in aggregate min/max when returning output-minmax-row
drh [Thu, 2 Feb 2012 18:42:09 +0000 (18:42 +0000)] 
Fix a problem with NULL handling in aggregate min/max when returning
values from the row containing the min or max.

FossilOrigin-Name: f27c7b4fb193126548e6a620ac89664d1efa3856

13 years agoFor queries of the form "SELECT p, max(q) FROM t1", the value of column p
drh [Thu, 2 Feb 2012 17:35:43 +0000 (17:35 +0000)] 
For queries of the form "SELECT p, max(q) FROM t1", the value of column p
returned is the one on the same row that holds the maximum value of q.

FossilOrigin-Name: adb29232b659c5332b6841776372407fcc350b08

13 years agoData structure cleanup. Remove unused fields. Rearrange other files for
drh [Thu, 2 Feb 2012 15:50:17 +0000 (15:50 +0000)] 
Data structure cleanup.  Remove unused fields.  Rearrange other files for
tighter packing and reduced memory usage.

FossilOrigin-Name: 0bc594e861ae1142e8c6c83f39b095e1432856bf

13 years agoSimplified array allocation in the IdList and AggInfo objects.
drh [Thu, 2 Feb 2012 03:38:30 +0000 (03:38 +0000)] 
Simplified array allocation in the IdList and AggInfo objects.

FossilOrigin-Name: 25df2a7458d025bc00380b4a0893637639f9f0d4