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
13,071 Commits 1,786 Branches 392 Tags
threadtest3
Commit Graph

4939 Commits

Author SHA1 Message Date
drh
e4f9b9b7c0 Add the win32-longpath VFS allowing windows filenames up to 32K characters in 
length.  Remove unused code when -DSQLITE_MAX_MMAP_SIZE=0.  Fix some
compiler warnings on windows.

FossilOrigin-Name: 12d0a8859de0a9d823997cfeccc77bd572cb6d13
 2013-08-28 18:18:12 +00:00
drh
d41d39f24d In the query optimizer, when converting BETWEEN and LIKE/GLOB expressions 
into simpler forms for processing, be sure to transfer the LEFT JOIN markings.
Fix for ticket [bc878246eafe0f52c].

FossilOrigin-Name: caab361ebee5f5c3fdafd9b1abe3d1ab7c5b4db9
 2013-08-28 16:27:01 +00:00
drh
868ccf2679 Fix an off-by-one error that causes a quoted empty string at the end of 
a CRNL-terminated line of CSV input to be misread by the shell.

FossilOrigin-Name: b5617e4fdadc4cded93c985008e90982dd48bc3b
 2013-08-28 13:33:40 +00:00
drh
f7f8de5fb2 Add a test case for empty quoted field in CSV import in the shell. 
FossilOrigin-Name: 3df56e849164811117f9ac8ee2aee1eee188bb96
 2013-08-28 11:57:52 +00:00
mistachkin
70e9ffa3bb In the win32longpath test, move the journal mode change down where it was intended to be. 
FossilOrigin-Name: 5cead293bbbcddd7d0976db41133e40704efcc99
 2013-08-28 07:42:43 +00:00
mistachkin
3741827ea1 Support database file names longer than 260 characters using the new 'win32-longpath' VFS variant. 
FossilOrigin-Name: 37e85e444cde18f061049437980b965d4485f43c
 2013-08-28 05:49:39 +00:00
drh
2f53b90665 Merge the STAT4 capability into trunk. 
FossilOrigin-Name: a32af0abe5fa6d570604fa3534e8230d5b6042fc
 2013-08-26 23:18:06 +00:00
drh
1efd81f7cf Fix a requirements comment in a test case. No changes to the testcase 
itself nor to any code.

FossilOrigin-Name: 3ad1f998e5db044849b528c31c4a7e1f3d527320
 2013-08-23 16:47:40 +00:00
dan
c63e880bdb Minor fixes for test cases. No code changes. 
FossilOrigin-Name: ef2a6a37366f91889dc2f1ba9cb6d1257d9b05db
 2013-08-21 20:04:54 +00:00
mistachkin
47b2995983 Fix typo in test. 
FossilOrigin-Name: f9859fe93bcecb4be7c1034291018523124c4a5c
 2013-08-21 19:59:14 +00:00
dan
36e78309de Candidate fix for [d666d600a6]. 
FossilOrigin-Name: 781592f32c8e1dcd59954c17211cf61349d1c0b1
 2013-08-21 12:04:32 +00:00
dan
22c745a9c9 Fix a minor problem in progress.test. No code changes. 
FossilOrigin-Name: a95ae93b32a9ad2ae017124ed0881802c3c741c0
 2013-08-21 07:25:03 +00:00
dan
c3c16cbd61 Fix a couple of test scripts to work with DEFAULT_AUTOVACUUM and OMIT_VIRTUALTABLE. 
FossilOrigin-Name: 356c6c59311eaf7d5633476f635e94a12b8b3924
 2013-08-20 20:25:03 +00:00
dan
e934e633a5 Fix an invalid assert() in where.c. Also a crash that can occur in the EXPLAIN QUERY PLAN code under obscure circumstances. 
FossilOrigin-Name: ef192abb82c2fc31135f875d7a19908d67c076b0
 2013-08-20 17:14:57 +00:00
drh
d0aa2f3afd Ignore IS NOT NULL and NOT NULL constraints on NOT NULL columns. 
FossilOrigin-Name: e476408e3c5ba5f3ba5e98ff264167c163d72e3f
 2013-08-20 17:00:55 +00:00
dan
4044906210 Test script changes to support testing sqlite3_interrupt(). 
FossilOrigin-Name: 0cede9f898bcd13dab51b25cb0e72213d988d3d2
 2013-08-20 16:08:39 +00:00
mistachkin
98ab33a82f Add test cases for tointeger() and toreal() functions. Fixes for several tests. 
FossilOrigin-Name: 5e1e9fd5e4f189836442baa42244be00de13ff0f
 2013-08-20 09:26:38 +00:00
mistachkin
cf02d7cf0b Add tointeger() and toreal() SQL functions. 
FossilOrigin-Name: af49707211ff7c7c4d30f4f457631ea8a9fa39eb
 2013-08-19 21:15:34 +00:00
dan
e704713cb8 Fix test script pragma2.test so that it works with ENABLE_MEMORY_MANAGEMENT. 
FossilOrigin-Name: 6acf728100ff339e4451bcefd3a20fd5c3cfd662
 2013-08-19 18:37:18 +00:00
dan
290703091e Add some extra assert() statements to silence a few clang warnings. 
FossilOrigin-Name: 1c63e9515b5f5cb9169928b108d002dcd18ad4fd
 2013-08-19 18:17:03 +00:00
drh
d3605a4f20 The fullfsync, checkpoint_fullfsync, and cache_spill pragmas apply to all 
files of a database connection, including those opened by future ATTACH
statements.

FossilOrigin-Name: d07c4331a28d44deca1ece8a34118f5b121b3ee2
 2013-08-17 15:42:29 +00:00
drh
d4b5c60eca Test cases for the cache_spill pragma. 
FossilOrigin-Name: b85c9ec5e02c1b92faa8eeb9e56e02a576a43a96
 2013-08-17 00:25:07 +00:00
dan
0e8194a9c7 Add a test for the problem fixed by [91733bc485]. 
FossilOrigin-Name: 5c591104813a7e55e59f4f557cbb3e500fa817c2
 2013-08-16 17:46:49 +00:00
dan
22d73b1cbe Fixes for test code that was not working with utf16 databases. Run the analyze*.test scripts as part of the 'utf16' permutation test. 
FossilOrigin-Name: fe99494d99df95f699ffab07b1e212800b5ff00d
 2013-08-16 14:48:23 +00:00
dan
585c823256 Add extra tests. No code changes. 
FossilOrigin-Name: 949127d53e0a907ed6f73c6828637d94b265468c
 2013-08-16 14:23:02 +00:00
dan
c367d4c052 Avoid buffer overreads and false OOM error reports that could be caused by corrupted sample records in the sqlite_stat4 table. 
FossilOrigin-Name: 9f85b6a52a0b9b1524daa6f24d85257e7f591e95
 2013-08-16 14:09:43 +00:00
drh
d94f512f58 Merge recent trunk changes into the STAT4 branch. 
FossilOrigin-Name: c69b512af276a438399747af22659415af3a5d4d
 2013-08-16 12:26:33 +00:00
drh
0af16ab2c2 Make sure that GROUP BY terms select input column names in preference to 
output column names, in compliance with the SQL standard.
Ticket [1c69be2dafc28].

FossilOrigin-Name: f2d175f975cd0be63425424ec322a98fb650019e
 2013-08-15 22:40:21 +00:00
drh
e35463b312 Bare identifiers in ORDER BY clauses bind more tightly to output column name, 
but identifiers in expressions bind more tightly to input column names.
This is a compromise between SQL92 and SQL99 behavior and is what
PostgreSQL and MS-SQL do.  Ticket [f617ea3125e9c].

FossilOrigin-Name: c78b357c00a35ed48ce2ffbc041de8d22570d1e2
 2013-08-15 20:24:27 +00:00
dan
0adbed8a60 Fix a crash that can occur if the sqlite_stat3 or sqlite_stat4 table is corrupt. 
FossilOrigin-Name: d51df8a8fcc31c37f6e1c9612204af5738ed865e
 2013-08-15 19:56:32 +00:00
dan
af2583c83c Fix a crash that can occur following an OOM fault. 
FossilOrigin-Name: 9f80b2687012ab7c4d6d654fe19f40878bd78bd8
 2013-08-15 18:43:21 +00:00
dan
3bc9f74fe9 Change some assert() statements in vdbe.c to ensure that a memory cell used to store a VdbeCursor object is not also used for some other purpose. 
FossilOrigin-Name: 71070c9fce86103f174220e07771df99b2e01405
 2013-08-15 16:18:39 +00:00
dan
1f616ad8fa Add tests for sqlite_stat4 sample selection. And a fix for the same. 
FossilOrigin-Name: 1fb4d9d6f2675515feb8e3d971bbd54716372549
 2013-08-15 14:39:09 +00:00
dan
f00e902580 Change the way ANALYZE works to use a single cursor when scanning indices. 
FossilOrigin-Name: bdce612b35193abf72de1a563ea7962375b3574e
 2013-08-14 19:54:12 +00:00
dan
8ad169abb4 If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. 
FossilOrigin-Name: cca8bf4372ab7a0258aa5c9397818415c6cf0abf
 2013-08-12 20:14:04 +00:00
dan
86f69d98d2 If there is data in both the sqlite_stat4 and sqlite_stat3 tables for a single index, ignore the sqlite_stat3 records. 
FossilOrigin-Name: 2a41736728d83a777ea8112da927cb047ec6684e
 2013-08-12 17:31:32 +00:00
dan
0106e378f1 Re-enable reading from the sqlite_stat3 table (as well as sqlite_stat4). 
FossilOrigin-Name: 6d45078e621526fc2bac0eaefbb0f9602b9a8ec5
 2013-08-12 16:34:32 +00:00
dan
dd6e1f193e Add the rowid field to the end of sample records stored in the sqlite_stat4 table. 
FossilOrigin-Name: 3a5e8ab7ddbe1d943b35ef329fe4e5a1bfdb0d9d
 2013-08-10 19:08:30 +00:00
dan
ad45ed7414 Fix a segfault in "ALTER TABLE t1 ADD COLUMN b DEFAULT (-+1)". Also an assert() failure that could occur if SQLITE_ENABLE_STAT4 were not defined. 
FossilOrigin-Name: 9fec3e38287067d60874530300fbeb602958c951
 2013-08-08 12:21:32 +00:00
dan
6cb8d76ccb Fix a bug in using stat4 data to estimate the number of rows selected by a range constraint. 
FossilOrigin-Name: f783938ea999731ea073cd2c78e278095f7bea6d
 2013-08-08 11:48:57 +00:00
dan
3d40759803 Merge latest trunk changes with this branch. 
FossilOrigin-Name: 08f74c45ecf711a2373af578d44470add9082377
 2013-08-07 18:42:27 +00:00
dan
ddc2d6e8f5 Fixes for builds without SQLITE_ENABLE_STAT4. 
FossilOrigin-Name: 84999e27cc0d14b89d9fe024e29d287c69285369
 2013-08-06 20:15:06 +00:00
drh
9fe809c561 Fix a test case related to partial indices so that it works even if 
STAT3 is disabled.

FossilOrigin-Name: 153c645025637bbff14dfce793e4b92210ded7e8
 2013-08-06 19:18:17 +00:00
dan
e043201d3d Use N separate cursors when scanning an index with N columns to collect sqlite_stat4 data. This fixes a problem with collecting incorrect nEq values from multi-column indexes. 
FossilOrigin-Name: 3a71afe67418ce00097cd9714c395fe9ff16f23b
 2013-08-05 18:00:56 +00:00
dan
c55521a60b Fix a couple of problems in code related to sqlite_stat4. 
FossilOrigin-Name: badd24d987240db5528b37d1c177431617079f9b
 2013-08-05 05:34:30 +00:00
dan
f52bb8d385 Begin adding experimental sqlite_stat4 table. This commit is buggy. 
FossilOrigin-Name: 2beea303a1d609cd2ff252412c50b966b9e5e8f1
 2013-08-03 20:24:58 +00:00
drh
3975974780 Updates to requirements marks. No code changes. 
FossilOrigin-Name: 213020769f310aec1591d97756b53891d0b64005
 2013-08-02 23:40:45 +00:00
drh
b47e07f1c1 Add support for partial indices. 
FossilOrigin-Name: 478113f18b1d28606b107b5a0bed04cb90a82cf2
 2013-08-02 16:41:02 +00:00
drh
1e7d43c977 Silently ignore database name qualifiers in CHECK constraints and in 
partial index WHERE clauses.

FossilOrigin-Name: 2e8c845eb5011a2743dace333aa38383588f2080
 2013-08-02 14:18:18 +00:00
drh
989b116a03 Fix the CREATE INDEX statement so that trying to create a TEMP index on 
a non-TEMP table throws an error rather than segfaulting.

FossilOrigin-Name: e3c8935f8736d00dc83644fa21d86ca7fec6d2fc
 2013-08-01 22:27:26 +00:00