1
0
mirror of https://github.com/sqlite/sqlite.git synced 2025-11-14 00:22:38 +03:00

19158 Commits

Author SHA1 Message Date
drh
cb9882a753 Fix a bug in the calculation of the table record header size.
Ticket #1163. (CVS 2389)

FossilOrigin-Name: bf82a04ff7c24a38d45721b3fae69d88d6e83149
2005-03-17 03:15:40 +00:00
danielk1977
d5d565235b Fix some memory leaks that can occur if a memory allocation fails. (CVS 2388)
FossilOrigin-Name: 9a358fc33d726d0b5782bf65b50f61f2bd096d56
2005-03-16 12:15:20 +00:00
drh
165ffe9708 When creating a new database, delete any preexisting journal that might be
left over from a prior database with the same name.  Ticket #1152. (CVS 2387)

FossilOrigin-Name: 856e2ec9688affbfe496cf184f460b18408e3dc0
2005-03-15 17:09:30 +00:00
drh
ae8b3615ee Allow the database name in a DETACH statement to be quoted.
Ticket #1151. (CVS 2386)

FossilOrigin-Name: 24e887735256499e58dabe90463524d9e6eb08ce
2005-03-15 02:04:12 +00:00
drh
b8ef32c3e8 Be more aggressive about using the busy handler. Ticket #1159. (CVS 2385)
FossilOrigin-Name: 644c6398e52481e5dda87671e1c196b26b1e4990
2005-03-14 02:01:49 +00:00
drh
f30cc9496a Fix bugs discovered in 3.1.4. F_FULLFSYNC not F_FULLSYNC. And a bug in
"make doc".  Also typos in the documentation. (CVS 2379)

FossilOrigin-Name: 3c57a4571fc8463ce9de1cbe5be45538bf2f0de9
2005-03-11 17:52:34 +00:00
drh
748f763f7a Fixes so that the FULLSYNC changes will build on windows. They do not have
any effect, but neither do they cause errors. (CVS 2377)

FossilOrigin-Name: ace3e30de1cde2e8990d8429b730ca5b68acd714
2005-03-11 04:41:39 +00:00
drh
6575a222d5 Another case of returning SQLITE_CORRUPT when a corrupt database file
is detected. (CVS 2374)

FossilOrigin-Name: 8710192797b5b22f29b2af90198d03664665bd83
2005-03-10 17:06:34 +00:00
drh
75ea0289cc Fix a problem with crashtest caused by the F_FULLSYNC change. (CVS 2373)
FossilOrigin-Name: f11c6e745200525056ae7cf97b4bdf1c7f1db588
2005-03-10 14:32:24 +00:00
drh
b851b2c938 Disable F_FULLSYNC if the sychronous pragma is not set to FULL. (CVS 2372)
FossilOrigin-Name: 58b8733b96165126ee8514f2ce0f88d249792847
2005-03-10 14:11:12 +00:00
drh
33fa535dca Fix a #ifdef in util.c. (CVS 2369)
FossilOrigin-Name: f426c625c4c3de626b5f5f8b5a6343a7ec3b16e9
2005-03-10 12:35:45 +00:00
danielk1977
5fd057af68 Fix a file corruption bug in CREATE INDEX in auto-vacuum databases. (CVS 2368)
FossilOrigin-Name: 64c4c717d35c8fce9b4be073196c507f6d471188
2005-03-09 13:09:43 +00:00
danielk1977
aee18ef8e2 Support for a future ALTER TABLE command to add columns with default values. (CVS 2367)
FossilOrigin-Name: 9d5abc1ddf6da37563c12d5a0401b89bb4e51c59
2005-03-09 12:26:50 +00:00
drh
d61c443e6a Fix the header comment on experimental.c. (CVS 2365)
FossilOrigin-Name: 0c4d2b11c922b41d0e03bfbd885dfdf52ce7ccab
2005-03-02 05:18:29 +00:00
drh
bf21627b6f Add the SQLITE_OMIT_FLAG_PRAGMAS compile-time option. (CVS 2362)
FossilOrigin-Name: c167e9054249361d1f464d3840a5c277e6ed44ab
2005-02-26 18:10:44 +00:00
drh
ccae6026e6 Fix an assertion fault that can occur while autovacuuming a corrupt database
file.  Add the SQLITE_OMIT_COMPLETE compile-time parameter. (CVS 2361)

FossilOrigin-Name: bb0e7e3857a06347b08d93553ac603e737322262
2005-02-26 17:31:26 +00:00
drh
51e75cafb0 Remove strcasecmp from shell.c. Tickets #1108, #1122. (CVS 2359)
FossilOrigin-Name: 4ae1a9fc2c484e59ef1e58972aa25772cede1187
2005-02-23 12:35:41 +00:00
danielk1977
3fdf826699 Fix bug reported on the mailing list for WHERE clauses like (rowid<'2'). (CVS 2357)
FossilOrigin-Name: b323f0f2832ac5d225d880db6f56314d2f766a25
2005-02-22 09:47:18 +00:00
danielk1977
36963fdca8 Support for a future file format that includes 'short' records. (CVS 2351)
FossilOrigin-Name: 173aeb256e2c09098a4392874f8623e8a760d951
2005-02-19 08:18:05 +00:00
drh
75f86a4b0b Compile-time option to limit the size of AUTOINCREMENT rowids to 32-bits. (CVS 2349)
FossilOrigin-Name: c5366deaf5beca9c99558c0f375ba73f817acd92
2005-02-17 00:03:06 +00:00
drh
0f68fd1bd9 Get vacuum working on database that used to have autoincrement tables but
where all such tables have been dropped.  Ticket #1121. (CVS 2344)

FossilOrigin-Name: 8f7c639da0f862fa2dd2f55eb7e4d453cd321540
2005-02-16 03:27:04 +00:00
drh
1f01ec1b7a Move the special built-in SQL functions used by ALTER TABLE out of func.c
and into alter.c. (CVS 2343)

FossilOrigin-Name: dbd11a0c581b447bb2f220a1a185d9fd36933ee3
2005-02-15 21:36:18 +00:00
drh
d0e4a6c11d Split the logic for the ALTER TABLE command off into a separate source
code file. (CVS 2342)

FossilOrigin-Name: 90d6573c2631fac92b9e572e9e21698ae2480c9d
2005-02-15 20:47:57 +00:00
drh
057cd3a0aa Btree checks the autovacuum flag after locking the database file. (CVS 2341)
FossilOrigin-Name: 6610188f09d08c65c46a140685b403aa74f71a19
2005-02-15 16:23:02 +00:00
danielk1977
1722181328 Ensure a database file is not truncated without an exclusive lock.
Fix for ticket #1114. (CVS 2332)

FossilOrigin-Name: dcbc983355d3207615b52b0724405a024a1a5955
2005-02-15 03:38:05 +00:00
danielk1977
3c407374fc Check that read-only pages are not being modified (disabled by default). (CVS 2331)
FossilOrigin-Name: 8514a4feb2a86e93c4251c491d394e861bb65edb
2005-02-15 02:54:14 +00:00
drh
aee128dc20 Make sure that when a CREATE INDEX fails, it does not leave a residue behind
that can corrupt the database.  Ticket #1115. (CVS 2330)

FossilOrigin-Name: cbed92f397ec13b57771ab8b5be74c0cacf35dfd
2005-02-14 20:48:18 +00:00
danielk1977
2b6d46b975 Tighten up the CREATE INDEX syntax accepted by the parser. (CVS 2329)
FossilOrigin-Name: 41d2214b83dd52acdda64a50d0c1ef16009d06d0
2005-02-14 06:38:40 +00:00
danielk1977
a1cb183d04 Fix a problem with sub-queries and the flattening optimization. Also handle an extra case of database corruption. (CVS 2324)
FossilOrigin-Name: f7858d8830cdd0f57b8f9bc73068d29a7062b8ac
2005-02-12 08:59:55 +00:00
drh
8cbd373ca7 Fix a problem with VACUUM that can lead to database corruption. (CVS 2323)
FossilOrigin-Name: 63894baf1b37156fd0b84eba4c9c5e8f43cee3f3
2005-02-12 00:19:30 +00:00
danielk1977
c30f9e7356 Return SQLITE_BUSY if the database is locked reading the schema within
sqlite_prepare(). Ticket #1106. (CVS 2322)

FossilOrigin-Name: c33c02d6069b90f295698a9f35f4aa99dee5f5e9
2005-02-09 07:05:46 +00:00
danielk1977
48af65aeae Add experimental collation_list pragma. (CVS 2321)
FossilOrigin-Name: f73a8aa34afd39e0b7df8f22b5c5d2c8d8979a1b
2005-02-09 03:20:37 +00:00
danielk1977
24c8ab8030 Document SQLITE_DEFAULT_CACHE_SIZE and SQLITE_DEFAULT_TEMP_CACHE_SIZE macros. (CVS 2320)
FossilOrigin-Name: ddcea6f8891b02e64f96591af161feb55c00a72c
2005-02-09 01:40:23 +00:00
danielk1977
4d88778b26 Fix a buggy interaction between "INSERT ... SELECT" processing and optimization (2170). (CVS 2319)
FossilOrigin-Name: c54ad2123693be8777d80343979e3261c4892105
2005-02-08 08:42:27 +00:00
danielk1977
a58fdfb162 Fix for correlated subqueries where the parent is an aggregate. Ticket #1105. (CVS 2318)
FossilOrigin-Name: f0d3ca10c5bccf8fca7143028ebb3e604c0e3f20
2005-02-08 07:50:40 +00:00
drh
7bec505e26 Add the (highly experimental) omit_readlock pragma that disables the use
of readlocks on read-only databases that are connected using ATTACH. (CVS 2317)

FossilOrigin-Name: 2155448d2128119f74241da0ea07d6713b71765c
2005-02-06 02:45:41 +00:00
danielk1977
a2dc3b1a5e Allow expressions (including variables) in LIMIT and OFFSET clauses. Ticket #1096. (CVS 2316)
FossilOrigin-Name: 515e5033a5482f55e7edb66d69ff3da7e234ff2e
2005-02-05 12:48:48 +00:00
danielk1977
99ba19ea08 Add a numeric version number. Ticket #1097. (CVS 2315)
FossilOrigin-Name: a9c33a804d572dd9df15be2029637b10e5a65cc4
2005-02-05 07:33:34 +00:00
danielk1977
ac17178853 Detect database corruption in rootpage flags (see also (2313)). (CVS 2314)
FossilOrigin-Name: 6d91a1e91bf0e8b4a0f5f78d079031f3ee69603b
2005-02-05 06:49:54 +00:00
drh
4e6083cb56 Detect and report a subtle case of database file corruption. (CVS 2313)
FossilOrigin-Name: 9fc0a5cbf892a22eaa950f3b2ed572ab4985c220
2005-02-04 21:13:00 +00:00
danielk1977
6a67fe8edf Remove code for SQL cursors. (CVS 2312)
FossilOrigin-Name: 2eb90870556c90b8d85da3d5eb7554f74ec922c2
2005-02-04 04:07:16 +00:00
drh
62d54916c4 Get AUTOINCREMENT and VACUUM working together. Ticket #1095. (CVS 2311)
FossilOrigin-Name: 332a531d06a610e6597b02105fcda767313f0225
2005-02-03 01:08:20 +00:00
drh
f8eb96ab9c Fix the ".dump" command in the shell so that it works with AUTOVACUUM.
This is related to ticket #1095. (CVS 2310)

FossilOrigin-Name: 76c4a96c5a2148f253cc5e034567b16317343be7
2005-02-03 00:42:34 +00:00
drh
4c7f941cfc Make sure the rc variable in OsWrite of os_win.c is always initialized.
Also assert that the amt parameter is always greater than zero.
Ticket #1094. (CVS 2309)

FossilOrigin-Name: 4b399ae7791288e5d44f90da530908d9ca77ff4b
2005-02-03 00:29:47 +00:00
danielk1977
99b214d28e Fix a comment in sqlite3.h. No code changes. Ticket #1093. (CVS 2308)
FossilOrigin-Name: d1ea2fb70be905947c8ff74da8e1f719a8fb85f5
2005-02-02 01:13:38 +00:00
danielk1977
d0a6932f70 Handle "rowid<=X ORDER BY rowid DESC" where X is an integer. Fix for ticket #1092. (CVS 2307)
FossilOrigin-Name: 506088796c846243e24c4cba6be4ce6511fdb345
2005-02-02 01:10:44 +00:00
danielk1977
a38432df12 Have debugging code handle sqliteMalloc(n) where n<0 in the same way as production. (CVS 2303)
FossilOrigin-Name: ab85e1d01299e383bda1834664370f04b13634b6
2005-02-01 10:35:06 +00:00
danielk1977
441daf68d2 Fix an error introduced with (2299). (CVS 2301)
FossilOrigin-Name: 22041d5f26355b0fc80eb355bfec897fb50ac1e1
2005-02-01 03:46:43 +00:00
danielk1977
48d0d866fc Avoid allocating a vdbe in sqlite3FinishCoding() if one has not been allocated already. (CVS 2299)
FossilOrigin-Name: eaf1866e4d10f0ddf5ccc02b7d9aff281ff9efc0
2005-02-01 03:09:52 +00:00
danielk1977
201f7168df Change to sqlite3AffinityType() to remove hex constants. (CVS 2298)
FossilOrigin-Name: d8b4b0ef13dddbf527e7440e7343c458210dceac
2005-02-01 02:13:29 +00:00