1
0
mirror of https://github.com/sqlite/sqlite.git synced 2025-11-21 09:00:59 +03:00

19158 Commits

Author SHA1 Message Date
shane
d87897dfa2 Minor changes to remove a few MSVC compiler warnings at /W3. Ticket #3610. (CVS 6215)
FossilOrigin-Name: c74c78e4eb7f6d674b7564b33387db996fbe5725
2009-01-30 05:40:27 +00:00
drh
db15bcd550 Add test cases to make sure that keywords that we say can be used as
identifiers really can be used as identifiers.  These tests were
inspired by ticket #3612, but they do not directly address ticket #3612. (CVS 6214)

FossilOrigin-Name: 6041ca87a16858f047727bc01f10b0bbc83609ed
2009-01-29 19:27:46 +00:00
drh
20abac2f87 Fix a segfault that can occur when attempting to insert into
a corrupt database file.  Need a test case. (CVS 6212)

FossilOrigin-Name: 68957cf0c4bae0c6cf450b4de1d6bc1bc64b232c
2009-01-28 20:21:17 +00:00
drh
6711002c7b Add testcase() macros for coverage in date.c. (CVS 6209)
FossilOrigin-Name: 90b42eba8e02402c342e04236148bbd5e4d93eb8
2009-01-28 02:55:28 +00:00
drh
dc86e2b2cd Fix some minor compiler warnings. Added sqlite3Isalpha() for use in
the soundex() function. (CVS 6203)

FossilOrigin-Name: bfc71edca471221add6b32b867d0b15171974eaf
2009-01-24 11:30:42 +00:00
danielk1977
25f42fe7a1 Remove incorrect ALWAYS macro associated with empty IN() sets. Ticket #3602. (CVS 6202)
FossilOrigin-Name: f3c09a0cb8bfc1a112c31b556d8921d5c75c5eef
2009-01-24 09:56:15 +00:00
danielk1977
e1fd508a28 Optimization: When loading a new page into the cache, avoid redundant memset() calls to zero it. (CVS 6201)
FossilOrigin-Name: 9c0b9f881367871105965d4268e2f2cde7f4d884
2009-01-23 16:45:00 +00:00
drh
663d56d46f Fix the VACUUM command so that it does not commit a transaction when it is
mistakenly run within a transaction - it should leave the transaction open. (CVS 6200)

FossilOrigin-Name: 75cc709be46ae2096d2ba3e7ac58de8140f8130c
2009-01-22 23:04:45 +00:00
danielk1977
859546cae6 Silence a C++ builder warning by writing "if( (rc = function())!=SQLITE_OK )" instead of "if( (rc = function()) )" in two places in pager.c. Ticket #3605. (CVS 6199)
FossilOrigin-Name: 78ae96def54026461c0d03a90394480f724ea584
2009-01-22 17:12:39 +00:00
danielk1977
bea2a94850 Big change to make pager.c easier to follow. Unused variables removed, comments improved, etc. (CVS 6197)
FossilOrigin-Name: 12f7346c13c180ed73d7a2e3b590be457360254a
2009-01-20 17:06:27 +00:00
danielk1977
78ca0e7eb4 When not compiling for an EBCDIC system, use built-in alternatives to the tolowe
r(), toupper() and other ctype.h library functions. Ticket #3597. (CVS 6196)

FossilOrigin-Name: 1041abd6784d283bebf646c54e93599522f7889d
2009-01-20 16:53:39 +00:00
drh
770b3cb763 Make sure the *pzErrMsg return from sqlite3_get_table() is aways zeroed.
Ticket #3598. (CVS 6195)

FossilOrigin-Name: 7035c35dbef72b7b4d00201a65734a6d93dd0d3e
2009-01-19 20:49:09 +00:00
drh
b8613ab127 Make sure mutexes are fully enabled for thread001.test. Take steps to
ensure that the thread tests run during regression testing. (CVS 6193)

FossilOrigin-Name: 6242f113eb40d472b78685c296fecf9f749a11cd
2009-01-19 17:40:12 +00:00
danielk1977
3cfe07037f Fix a bug that was preventing SQLite from releasing locks properly under obscure circumstances. (CVS 6192)
FossilOrigin-Name: 502c66df8b5fc5ec8e3d94202030571a4920fb9c
2009-01-17 16:59:40 +00:00
drh
a6d90f0ddd Remove a harmless UMR that occurs inside some debugging code. (CVS 6190)
FossilOrigin-Name: 191c399fc6354b35477ec21f685377e2af26f49b
2009-01-16 23:47:42 +00:00
danielk1977
db3403973c Fix a change-counter bug similar to #3584. This one is much more obscure though, requiring a transient IO or malloc error to occur while running in exclusive mode. (CVS 6189)
FossilOrigin-Name: 9f07d2d9226b73c4dc311fd142e0aaba4ffcb078
2009-01-16 16:40:14 +00:00
danielk1977
45d6882fd9 Revert (6187). (CVS 6188)
FossilOrigin-Name: a353c1ab376b159c4d12532412365318cdbdcc60
2009-01-16 16:23:38 +00:00
danielk1977
443c0597fe This commit is an error. Reverted by (6188). (CVS 6187)
FossilOrigin-Name: aa67fd0cdb4f53a0c6e15c001d37554d15006718
2009-01-16 15:21:05 +00:00
danielk1977
78c2e6d837 Allow recently added keywords 'savepoint' and 'release' to be used as database object names. Just as they could be prior to 3.6.8. Ticket #3590. (CVS 6186)
FossilOrigin-Name: 54ab8326a1ea574b183f84c8465315e989a23ca4
2009-01-16 11:04:58 +00:00
drh
75d8f84678 Treat "or" as an ANSI-C keyword, even though it is not. Ticket #3588. (CVS 6185)
FossilOrigin-Name: ed4e308caaa50c55aa01cd34079f1be5c8a93c71
2009-01-15 17:40:42 +00:00
drh
c7288ee0b8 Avoid using ENOTSUP on systems that do not define that symbol.
Ticket #3512. (CVS 6182)

FossilOrigin-Name: fcb6c677124102558f7a7a22bc3569b664424a4c
2009-01-15 04:30:02 +00:00
drh
a81c64a2da Make some changes requested by Fedora. (CVS 6181)
FossilOrigin-Name: 7bc08bc719c2e9ca6d92d4709c0478e15fdfb131
2009-01-14 23:38:02 +00:00
drh
8f800a7d42 Fix the shell so that the ".schema" command works regardless of the
pragma settings.  Ticket #3585. (CVS 6180)

FossilOrigin-Name: 6f6b638e44a8cfc741594f02b0178fa98ed7e2c1
2009-01-14 23:17:55 +00:00
drh
8f941bc7a1 Add asserts to detect if a transaction commits without first incrementing
the transaction counter.  These asserts are intended to prevent future
problems similar to ticket #3584. (CVS 6179)

FossilOrigin-Name: b676ccfd9019e65b52251332d94de1b3018ec823
2009-01-14 23:03:40 +00:00
danielk1977
104f1fef2d Fix a problem with committing a transaction while there are other active statements. Sometimes, the database change counter was not being updated. (CVS 6176)
FossilOrigin-Name: b7d2a477aa2c3dbbb81d18fba1faa6835711b5c3
2009-01-14 17:45:57 +00:00
drh
a7e770612b Make sure the OR-clause optimizer takes the cost of sorting into account.
Reset the rowid cache on the OP_Rewind and OP_Last opcodes.  Bump the
version number so that we can do an emergency release.  Ticket #3581. (CVS 6173)

FossilOrigin-Name: d28b58209bf5eb575d0cad8dc71ac043395c6471
2009-01-14 00:55:09 +00:00
drh
a9e364f00f Updates to comments as suggested by tickets #3578 and #3579. (CVS 6172)
FossilOrigin-Name: b5927213b6171e57018f1f265940c9bcc7a0ba04
2009-01-13 20:14:15 +00:00
danielk1977
5f2d46b313 If the journal file is open when unlocking the database, close it just before unlocking the database file instead of just after. This may fix #3572. (CVS 6171)
FossilOrigin-Name: 36fe9a7a51b5279f1a3964139aa636e81f9c8b06
2009-01-13 16:03:44 +00:00
danielk1977
838cce4382 Only run tests that depend on SQLITE_PREFER_PROXY_LOCKING builds when said symbol is set. (CVS 6169)
FossilOrigin-Name: 5d88f8be7342acd2a7ed6f269bec615cd03e59e2
2009-01-12 14:01:45 +00:00
drh
44805ad8b6 Sometimes a single byte is written to the main database file. Make sure
that journaltest knows this. (CVS 6168)

FossilOrigin-Name: e0af5a43f3c6ae41042c74339e7404d3373fd6ce
2009-01-11 18:24:27 +00:00
drh
c0731c9d10 Fix an assert() so that it works correctly with SQLITE_TEMP_STORE=3. (CVS 6167)
FossilOrigin-Name: fd2bbcf8d8d03eecd4614636ae787331a8e99816
2009-01-11 17:00:02 +00:00
danielk1977
02983931eb Remove the unused Pager.alwaysRollback flag. Fix a couple of comments in pager.c. (CVS 6161)
FossilOrigin-Name: 8f0672af8d7d46124d01e540eec7b43fc16dd552
2009-01-10 17:57:48 +00:00
drh
ceb92adb9d Remove an faulty assertion inserted a few days ago. (CVS 6160)
FossilOrigin-Name: 495f017e03f32420e6a6a7685125a86929cef142
2009-01-10 17:02:02 +00:00
drh
47c3b3e099 When compiled with SQLITE_DEBUG (in other words, when assert() is enabled)
the ALWAYS and NEVER macros will throw an assertion if their arguments are
not true or false, respectively. (CVS 6159)

FossilOrigin-Name: 64a8dcd8d6152108809e4d10c459f1de5d36a435
2009-01-10 16:15:20 +00:00
danielk1977
7cbd589da0 Improve coverage of pager.c. (CVS 6158)
FossilOrigin-Name: 855c4093cf331496d9ef508011ad814e91e3882f
2009-01-10 16:15:09 +00:00
drh
96c7a7d95f Fix a bug caused by overzealous code test coverage simplifications.
Bug found by TH3. (CVS 6157)

FossilOrigin-Name: 3da5578726cb22118dfca38a2098a1e378644387
2009-01-10 15:34:12 +00:00
drh
d1fa7bca39 Remove some unused code from expr.c in order to increase test coverage. (CVS 6156)
FossilOrigin-Name: 2cbea64fb00a1b5b8aa0e9c958b2a09256ae59bc
2009-01-10 13:24:50 +00:00
drh
d2cb50b74c Coverage improvements in pragma.c. Change the __DARWIN__ macro to __APPLE__,
which is available by default on Leopard. (CVS 6153)

FossilOrigin-Name: 64c56226b91e57883c8059f65330318e53376b8a
2009-01-09 21:41:17 +00:00
danielk1977
0371f1b243 Increase pager.c coverage a bit. Fix an assert failure that can occur following a "PRAGMA omit_readlock" command on a read-only database. (CVS 6152)
FossilOrigin-Name: 0f3f9011fa143f7b63c9bf79d3e411327d5c6f9d
2009-01-09 17:11:04 +00:00
drh
6402250ea2 Simplifications to btree.c to improve test coverage. (CVS 6150)
FossilOrigin-Name: ac84f106d572e881136adc3434d00d70564f57cb
2009-01-09 14:11:04 +00:00
drh
1c767f0df3 More coverage improvements. (CVS 6148)
FossilOrigin-Name: 6e171c0a64850013b26a223189d5bebcc0a01a8b
2009-01-09 02:49:31 +00:00
drh
e2f02bacc1 Increased test coverage. (CVS 6147)
FossilOrigin-Name: 45bb5703d7ef5e835b43a6fa7ee2a2d96db76939
2009-01-09 01:12:27 +00:00
drh
103bd88cf7 Increased test coverage in where.c. (CVS 6146)
FossilOrigin-Name: 1e5725c5179660277c2e8c321877d7ee3ca21808
2009-01-08 21:00:02 +00:00
danielk1977
ad0ea2280a Fix a comment in pager.c. No actual code changes. (CVS 6145)
FossilOrigin-Name: 44d3bfddf44b10b3744db6b41bc3f53c3903df5e
2009-01-08 18:04:13 +00:00
danielk1977
484fe37c9e Avoid an 'invalid cast' warning in test_osinst.c. (CVS 6144)
FossilOrigin-Name: 931f3a21bd4b6c5760ed64c23e8210cf2c3e3ab5
2009-01-08 17:57:31 +00:00
danielk1977
112f752be8 Fix a couple of potential corruption problems in pager.c. (CVS 6143)
FossilOrigin-Name: 5a39525ba3e65f1c6df3cf23fbfb57f6a0bf4b62
2009-01-08 17:50:45 +00:00
drh
4fd18c4b31 Add a test script for ticket #2565. Change the assert() in pager.c into
a testcase() macro. (CVS 6142)

FossilOrigin-Name: 1e53e382e5030de4d908098bf77af053dd81f0c5
2009-01-08 15:24:01 +00:00
drh
617634eca2 Allow database files to be created in the root directory on unix.
Ticket #3570. (CVS 6141)

FossilOrigin-Name: 81014334ad57e380e21c47ad6eebe9f16b4ad24c
2009-01-08 14:36:20 +00:00
danielk1977
e86a5b7798 Clean up test_journal.c to make it easier to follow. (CVS 6140)
FossilOrigin-Name: 5a28c7c7b45655dcfd0da4898e77d0240b511c5f
2009-01-08 12:05:56 +00:00
drh
171256c45c Increase test coverage of where.c. Make sure OR-optimization works on
UPDATE and DELETE in addition to SELECT.  (Bug found by coverage tests.) (CVS 6139)

FossilOrigin-Name: 4b2c08e8984befb12fa2173ca89d9f54cf764d22
2009-01-08 03:11:19 +00:00