drh
f68686ae52
When a named CHECK constraint fails, include the name of the constraint
...
in the error message.
FossilOrigin-Name: 1b75f301affac654bee24fa247046ea0782d3c4d
2012-03-30 15:48:48 +00:00
drh
7da5fcb0b7
Fix MSVC compiler warnings in test code.
...
FossilOrigin-Name: cb7a850439c9a4a7887650d6b81d95ab8025de5b
2012-03-30 14:59:43 +00:00
drh
93416f1c83
Merge the latest trunk changes into the winrt branch.
...
FossilOrigin-Name: a1a85b846aac07979e732a9f36d178bd567e103a
2012-03-30 14:01:40 +00:00
mistachkin
05340e3257
Simplify the winRead and winWrite VFS functions to reduce the number of system calls.
...
FossilOrigin-Name: 10ce846759f6f22e70bb9b67bea7a0c2b8a156fe
2012-03-30 12:27:55 +00:00
drh
f9df449809
Change the name of a local variable from "not" to "bNot" to lessen the
...
chances of it colliding with some prior #define in the appliation.
FossilOrigin-Name: cbdd86387630600b309de4aaeaa131ec7b053ce2
2012-03-30 12:10:38 +00:00
drh
e1da8fadcc
In the ".output" command-line shell, if the first character of the output
...
filename is '|' then use popen() instead of fopen().
FossilOrigin-Name: fa82062c659ffbe7ad01106d3ef54d7bb44f1f44
2012-03-30 00:05:57 +00:00
drh
4e245a4c35
Fix compiler warnings on GCC and MSVC and fix a C89-ism that
...
broke the build for MSVC.
FossilOrigin-Name: b451c0f97f0abe78ebe6c62ff489ec1ad8a1f767
2012-03-30 00:00:36 +00:00
dan
c68939ef3e
Disable the LIKE optimization if the column on the left-hand-side of the LIKE operator belongs to a virtual table.
...
FossilOrigin-Name: 0bacb879e18026f2a8e22fe3e4bc8d27de5c4416
2012-03-29 14:29:07 +00:00
dan
9ace112c84
Fix an out of date comment on sqlite3ArrayAllocate().
...
FossilOrigin-Name: 4afdd5ae53ef0ff7c0fde74eaa04638c923c679b
2012-03-29 07:51:45 +00:00
drh
ac5e749be8
Minor changes to the core of OP_Column for performance and to clarify the
...
critical path.
FossilOrigin-Name: 868394761e41b7483a5874426ee052dfb3a9e2be
2012-03-28 16:14:50 +00:00
drh
dda5c08bf6
Improvements to comments. Minor changes to code in the hot path of
...
OP_Column - with the hope of get a few cycles of performance improvement.
FossilOrigin-Name: ca093103437f141caa3eb11539c6eb7b4dd65175
2012-03-28 13:41:10 +00:00
drh
31ec740a3d
Fix the typeof() and length() optimization so that it works for aggregates
...
as well as scalar queries.
FossilOrigin-Name: bc18215a8a660442db6ddeeda4a88df0acffe0f7
2012-03-28 02:43:20 +00:00
drh
a748fdcc43
Evaluate typeof(X) and length(Y) where X is any column and Y is a blob column
...
without actually loading X and Y from disk.
FossilOrigin-Name: b899dbeb60752843287e2c6ad3577e1d00f0d587
2012-03-28 01:34:47 +00:00
drh
fbbcd5deda
Add SQLITE_DBSTATUS_CACHE_WRITE to the command-line shell.
...
FossilOrigin-Name: 30b8dd326d28c0c08543989e376011ea41773a7e
2012-03-24 20:09:33 +00:00
drh
9ad3ee40f2
Add SQLITE_DBSTATUS_CACHE_WRITE. Used to query a database connection for the cumulative number of database pages written.
...
FossilOrigin-Name: 05f98d4eec0f029b76fd471f8d9edf2807de6b55
2012-03-24 20:06:14 +00:00
drh
d60f4f4c95
When an incremental blob cursor is invalidated (occurs when an SQL statement modifies or deletes the row the blob cursor points to) release all page references held by the cursor. Otherwise, the presence of these references may cause other code in btree.c to incorrectly infer that the database is corrupt.
...
FossilOrigin-Name: 341b703ce16361a64ed8bba64ff46792132c0b56
2012-03-23 14:23:52 +00:00
drh
bf92ec0ce3
Always quote the names of tables in the output of the shell's ".dump" command,
...
even if the name is pure alphabetic text, in case the name is a keyword.
FossilOrigin-Name: 638b71150281a211f89b4057b0d5d32d3fbcf323
2012-03-22 12:50:34 +00:00
drh
d878cab51a
Remove the _SafeInit() entry points from the TCL interface. They have long
...
been no-ops. Removing them completely avoids confusion as to why they
don't work.
FossilOrigin-Name: 0fb26c7bfa7a4bb1503f90fd6f5b9c70f444665b
2012-03-20 15:10:42 +00:00
drh
82ebc2a098
Fix out-of-bounds array references in the "echo" virtual table module
...
used for testing. No changes to the SQLite core.
FossilOrigin-Name: 7b449b301ea03295262b8d572b02625e4b39cfa5
2012-03-20 03:10:51 +00:00
mistachkin
9917a71da0
Merge updates from trunk.
...
FossilOrigin-Name: 4ab1ffd45d4c25368b9b393a3336068b747d8b22
2012-03-19 23:32:26 +00:00
mistachkin
ca04d8a9f1
Fix typo, use the syscall table for osOutputDebugStringA.
...
FossilOrigin-Name: 9598c2a398a6e7d9c3ee8b2ae32c21538ad3e15a
2012-03-19 23:28:35 +00:00
drh
0299b40f0f
Add additional test cases to e_insert.test. Update evidence marks.
...
no changes to core code.
FossilOrigin-Name: 036395c0a8e08883b11df025e3da9e2461e4b1eb
2012-03-19 17:42:46 +00:00
dan
0d1614c731
Ensure that compatible malloc and free functions are used with stat3 data if SQLITE_ENABLE_STAT3 is defined.
...
FossilOrigin-Name: 32bb1ecee4e43a4683512dbca047abf735afd313
2012-03-19 10:21:37 +00:00
mistachkin
5593b2e653
On Windows, when no temporary path is available, skip prepending the directory separator.
...
FossilOrigin-Name: 32b5c20e54474fcc33ba937293e97566a555e733
2012-03-18 03:22:44 +00:00
mistachkin
86f89871b0
Add SQLITE_OMIT_SHUTDOWN_DIRECTORIES compile-time option to disable clearing the sqlite3_data_directory and sqlite3_temp_directory variables during sqlite3_shutdown. Also, only clear the variables if the heap was actually shutdown.
...
FossilOrigin-Name: 1ae9f9e4f730eccbc0fc3408de1ac3c4be931e01
2012-03-18 01:32:44 +00:00
mistachkin
e4c46aaccd
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
2012-03-16 10:28:40 +00:00
drh
7a48480d07
Fix harmless compiler warnings.
...
FossilOrigin-Name: 74eadeec34c4b19cf5f8b7f648db3b7ad601a00e
2012-03-16 00:28:11 +00:00
drh
a929e6282b
Add the sqlite3_db_readonly() API to trunk.
...
FossilOrigin-Name: fed134a5f395533de0c9d76950697c060ddb126d
2012-03-15 22:54:37 +00:00
drh
421377e67a
Add the sqlite3_db_readonly() interface. This is still tentative, pending
...
a closer look at other ideas to accomplish the same thing.
FossilOrigin-Name: 254f99ea9ff1534948bdb179e69ab0c940c87ec1
2012-03-15 21:28:54 +00:00
mistachkin
40c471d921
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
2012-03-15 03:40:59 +00:00
mistachkin
16afb9ee96
Fix macro issues for osGetProcessHeap and sqlite3_win32_write_debug.
...
FossilOrigin-Name: d3d071598aba367e3d73001ab38d7a78306875ea
2012-03-14 23:08:59 +00:00
mistachkin
e8c9a184be
Fix typos, use #if instead of #ifdef when checking for the Win32 native heap validation define.
...
FossilOrigin-Name: 845aa46f69784420ada4116078f8dc0a68cf3707
2012-03-14 20:20:37 +00:00
mistachkin
0df898e27d
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
2012-03-14 20:17:34 +00:00
mistachkin
184997c9a6
Add warning to the docs about changing the data directory when a database connection is open.
...
FossilOrigin-Name: c07cd85ca9698b48f960b164cab3a38472a17640
2012-03-14 01:28:35 +00:00
mistachkin
a112d140ae
Add experimental support for resolving relative database file paths using a fixed user-defined directory.
...
FossilOrigin-Name: 7354ae8fd3eccee2cf9f6501da5b1a014c31556f
2012-03-14 00:44:01 +00:00
mistachkin
5ff72401c9
Add assert to verify the number of characters to write in sqlite3_win32_write_debug.
...
FossilOrigin-Name: 8083f6164f3308c1c1d4f4d84be1894e382fe2e6
2012-03-13 03:38:22 +00:00
mistachkin
f4f327ce07
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
2012-03-13 03:35:07 +00:00
mistachkin
5cfbeac070
Cleanup the Windows syscall table, removing the unused CreateFileMapping entry.
...
FossilOrigin-Name: fb7d8bf6ec5c0ef9a948bc14c28770e34f57db1a
2012-03-13 01:30:20 +00:00
mistachkin
df562d5535
More changes required to compile for WinRT using VS 11 beta. Also, replace more APIs with their WinRT alternatives.
...
FossilOrigin-Name: 6b997d9c32076c480ff4f101ff93bae3f443e252
2012-03-13 01:16:57 +00:00
drh
331b67c151
Candidate fix for the optimizer problem described in ticket
...
[b7c8682cc17f3] which can causes a LEFT JOIN to be changed
into a INNER JOIN if there are OR terms in the WHERE clause.
FossilOrigin-Name: 0dc4cb935514131c99172175d57feec3a1743aa9
2012-03-09 22:02:08 +00:00
mistachkin
6aa18c95f1
Merge and manually resolve testing updates from trunk.
...
FossilOrigin-Name: 5eecdb44dd809e91002b8ecf59ada72f4b56549a
2012-03-08 20:22:42 +00:00
mistachkin
f8a784645c
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
2012-03-08 20:00:36 +00:00
mistachkin
5483f772b1
When compiled for WinRT, use the CreateFile2 and LoadPackagedLibrary functions instead of CreateFile and LoadLibrary.
...
FossilOrigin-Name: 27d6942ca270d6e724ffd230ed58a8683d67dfa4
2012-03-07 20:11:47 +00:00
drh
2938f924cc
If a CHECK constraint is named, report that name on the error message when
...
the constraint fails.
FossilOrigin-Name: 9a0f90d9deb335ac71044b8afa81538d85cc7ccf
2012-03-07 19:13:29 +00:00
drh
4cdb9076d6
Merge in the latest trunk changes.
...
FossilOrigin-Name: ca4708531a5e0debbe3d0999a4d210ef2a347972
2012-03-07 16:52:38 +00:00
mistachkin
c548465435
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
2012-03-05 22:52:33 +00:00
mistachkin
9668e24e62
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
2012-03-04 02:56:10 +00:00
mistachkin
287a48d67b
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
2012-03-03 13:15:25 +00:00
drh
7f67d94cfe
Fix a bug [3557ad65a07] that causes incorrect DISTINCT processing on
...
an indexed query involving the IN operator.
FossilOrigin-Name: dec9a995d7012a1f85be4edb71240b9d4f07c60e
2012-03-03 00:34:47 +00:00
mistachkin
62d1924fc5
When compiled for WinRT, avoid using the FORMAT_MESSAGE_ALLOCATE_BUFFER flag to FormatMessage (i.e. because LocalFree is unavailable).
...
FossilOrigin-Name: 9eb331be7e905d11d9075ce1596478b55a7f488b
2012-03-02 23:53:54 +00:00