database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
14,839 Commits 1,785 Branches 392 Tags
reoptimizeArm
Commit Graph

180 Commits

Author SHA1 Message Date
drh
22c17b8bf5 Simplifications to error message processing. Fix a possible problem in error 
message formatting when vacuuming a database with a corrupt schema.

FossilOrigin-Name: 56ef98a04765c34c1c2f3ed7a6f03a732f3b886e
 2015-05-15 04:13:15 +00:00
drh
22ecef5c20 When parsing the schema, ignore any SQL that does not begin with "CREATE". 
FossilOrigin-Name: d3c00d61581c8ba6dce5618391432d3af8d324d4
 2015-04-16 00:26:03 +00:00
drh
9bd3cc4681 Add extra tests to threadtest4.c. Fix a benign data race accessing the 
text encoding using ENC(db).

FossilOrigin-Name: d7bb7ea4ab97ad26f4c84c9b8dc2827010093803
 2014-12-12 23:17:54 +00:00
drh
9ca95730e3 Add the SQLITE_ENABLE_API_ARMOR compile-time option. This is a work in 
progress and is not yet completely functional.

FossilOrigin-Name: c297a84bc678f81ffc0aa9139ab73f0ca87c1971
 2014-10-24 00:35:58 +00:00
drh
b2445d5ee8 Move user authentication blocking from sqlite3_prepare() over to the 
table lock generator, thus allowing SQL statements (like 
"PRAGMA locking_mode") that do not touch database content to run
prior to authentication.

FossilOrigin-Name: 70121e7cf868b7d6d19bf98794ddc3809a901456
 2014-09-11 14:01:41 +00:00
drh
32c6a48b5e Add support for the extra parameter on the sqlite3_set_authorizer() callback 
and support for failing an ATTACH with an authentication-required database
using bad credentials.  The extension is now feature complete, but much
testing and bug-fixing remains.

FossilOrigin-Name: 596e728b0eb19a34c888e33d4d37978ca2bf1e00
 2014-09-11 13:44:52 +00:00
drh
09e60541ae Complete the implementation of the various APIs. Fix several problems. 
This is another incremental check-in that does not completely work.

FossilOrigin-Name: 4eaaa7fa87aa912d24f8b35440ab60310dc08310
 2014-09-10 22:46:46 +00:00
drh
f442e33e3a Add the ".user" shell command and implement the sqlite3_user_add() 
routine.  Incremental check-in.  The code compiles but does not work.

FossilOrigin-Name: a0455f9deb603bf91684158d911269622720fc1a
 2014-09-10 19:01:14 +00:00
drh
e933b83f02 Further ideas on user authentication. Not yet working code. 
FossilOrigin-Name: c8171ecd0d6f097c9e95d5f6643bae8d67f44750
 2014-09-10 17:34:28 +00:00
drh
d45309796b Non-working preliminary implementation attempts on user authentication. 
FossilOrigin-Name: 8440f093bac19a41d44ee352744354eab897fe4e
 2014-09-09 14:47:53 +00:00
drh
13f40da31d Split the sqlite3Error() routine into sqlite3Error() and 
sqlite3ErrorWithMsg(), for a slight size reduction and performance increase.

FossilOrigin-Name: cf561d1f0bb60b3d638632d20bd686dda4fa4a04
 2014-08-22 18:00:11 +00:00
drh
73d5b8f550 Move elements of the Vdbe object that are only used during statement 
preparation out into the Parse object.

FossilOrigin-Name: c289a253c0c053ac8fc344efe138262c327d8096
 2013-12-23 19:09:07 +00:00
drh
f30a969b80 Rework the logic that factors constant expressions out of inner loops, making 
it both simpler and faster.

FossilOrigin-Name: 8dc5c76c766828d7c28090bec30ff48227e7b140
 2013-11-15 01:10:18 +00:00
drh
7232ad0700 Make sure the sqlite3_prepare16 and sqlite3_prepare16_v2 interfaces do not 
read past a zero-terminator if the nBytes parameter is too large.

FossilOrigin-Name: 20dba3a7fb3e7078b95af3beca948467a3af6a89
 2013-07-16 23:26:43 +00:00
drh
c7f0d229a7 Fix compiler warnings. Fix a harmless off-by-one error in the solver. 
FossilOrigin-Name: 10021941d0258951b916e788881df140113f0597
 2013-06-19 03:27:12 +00:00
drh
8e23daf372 Fix the Parse.nQueryLoop state variable to work with NGQP. 
FossilOrigin-Name: f1cac24f06b9c71cfa472fdcf2da4cd8689a7cc3
 2013-06-11 13:30:04 +00:00
drh
60625313b0 Increase the default SQLITE_MAX_SCHEMA_RETRY to 50. Make sure that macro 
covers every case where a prepared statement might need to be reprepared due
to a schema change.  The sqlite3_exec() interface now uses 
sqlite3_prepare_v2().

FossilOrigin-Name: c1d7304c80c4a6244c8a9f6fad1eebd0f339c724
 2013-04-06 18:06:51 +00:00
mistachkin
48864df97d Many spelling fixes in comments. No changes to code. 
FossilOrigin-Name: 6f6e2d50941e444ebc83604daddcc034137a05b7
 2013-03-21 21:20:32 +00:00
dan
dbd4d5fc77 If SQLITE_OMIT_UTF16 is defined, avoid setting the 'enc' field of Schema objects to any value except SQLITE_UTF8. Otherwise, assert() statements may fail or spurious SQLITE_NOMEM errors may be returned at the vdbe level later on. 
FossilOrigin-Name: 69746ef787680a4b7590bd1d3c86b229d9d0dac4
 2013-03-08 07:10:37 +00:00
mistachkin
ba2bba3c32 Silence harmless compiler warning seen with SQLITE_OMIT_DEPRECATED. 
FossilOrigin-Name: c5cee969322d14114e4136510c3891a2e743520d
 2012-09-18 23:21:32 +00:00
drh
a19b89627e Make sure the Index.azColl pointers do not point to connection-specific memory. 
Also, remove an unnecessary reinitialization to sqlite3.pDfltColl.

FossilOrigin-Name: c469850b2eb61a63150cc5fc7d2fe98f0b5abffb
 2012-06-06 10:56:22 +00:00
drh
81028a455d The former sqlite3ResetInternalSchema() routine was really two different 
routines, selected by parameter, each with a confused mission.  So split
this routine up into three separate smaller routines, calling each
separately as needed.  Hopefully this will make further refactoring and
schema reset collateral damage containment easier.

FossilOrigin-Name: aa0c3493d3647d7efe527067e9fcccefda8e3008
 2012-05-15 18:28:27 +00:00
drh
74ea19b489 Add an assert() that verifies that the statement pointer from 
the sqlite3_prepare() family of functions is always NULL if the routines
return other than SQLITE_OK.

FossilOrigin-Name: 0bb1cfc63f982db7b29c8e6be6698a6dad100f70
 2012-05-14 12:20:54 +00:00
drh
e73c91496f Minor changes needed to restore full branch test coverage. 
FossilOrigin-Name: bc10a753579b65ba4604867204b7b3d8383f3ac7
 2011-11-09 16:12:24 +00:00
drh
2b89fbcb1e Do not do a backup if the number of reserved bytes in the source and 
destination do not match.  Try to make the match, but if unable fail.

FossilOrigin-Name: 0ca8a2332b28d88585dc890e5162b095e783fc20
 2011-04-09 02:09:44 +00:00
drh
cdf011dcc4 Additional schema mutex checks for sqlite3RootPageMoved(). 
Reduce the scope of sqlite3ResetInternalSchema() in a few places.

FossilOrigin-Name: 39c00907833413c0d97d3e06fdda967b825d23ea
 2011-04-04 21:25:28 +00:00
drh
2120608e0f Add a description of access rules for the Schema object and lots of asserts 
to verify that the access rules are followed.

FossilOrigin-Name: ae8374af057b6e6546e9265148cfffe32fcb0849
 2011-04-04 18:22:02 +00:00
drh
c7792fa052 Begin a series of changes designed to reduce the scope and frequency of 
invalidating schemas.  Design goals are that the internal schema should
never be deleted out from under a prepared statement that is running and
that all prepared statements should be expired if the schema is invalidated.
At the same time, minimize the number of schema invalidations.  This change
merely revises the sqlite3ResetInternalSchema() function to use -1 as the
wildcard for "all" rather than 0, so that we can reset the main schema
independently of all the others.

FossilOrigin-Name: 6a8ad6e31e0d2b8a5ace38faf0efd805155ee5f3
 2011-04-02 16:28:52 +00:00
drh
d50ffc416f Fix additional cases of possible signed integer overflow, especially with 
regard to negation.

FossilOrigin-Name: 2d5800bd8cfc7d7f5578a71b1aeaa74b2ec4b372
 2011-03-08 02:38:28 +00:00
drh
c126e63e4f Remove dead code identified by the clang static analyzer. 
FossilOrigin-Name: 01a79d5a7af48fb7e50291c0c7c6283d3fb359d0
 2011-03-06 21:28:32 +00:00
dan
0ecdeb2414 Fix a couple of typos in comments. No changes to actual code. 
FossilOrigin-Name: 9167fdb3560b1567a0bdc9a1906a87ec98e161f1
 2011-01-25 13:43:35 +00:00
drh
60ac3f426c Fix the max_page_count pragma so that it will not set to a value smaller 
than the current database size, as the documentation requires.  Also,
remove all occurances of atoi() from the core.

FossilOrigin-Name: 2031974b606ef713b5f34522b2221470d98687c5
 2010-11-23 18:59:27 +00:00
dan
2ce224535f Experimental changes to EXPLAIN QUERY PLAN. 
FossilOrigin-Name: f4747eb83dacce6430ad6e5eb20155ffad975514
 2010-11-08 19:01:16 +00:00
dan
d19c933e8e Change the way SubProgram objects are deleted so that the code is the same for deletion and measurement. 
FossilOrigin-Name: 00e55102a8309eb6df08ad4a8937ba02688bac62
 2010-07-26 12:05:17 +00:00
drh
9e55d47d33 Reorder variable declarations in the previous check-in to avoid putting code 
before declarations when not testing.

FossilOrigin-Name: d1fe8ab4a176180053d35300ad0540a27c6cd76d
 2010-07-06 09:29:01 +00:00
dan
9859c427a2 Ensure the correct error code is returned if an attempt to parse a database schema made by an ATTACH statement fails. 
FossilOrigin-Name: c272196115ab3926e56b6f4183ec127e3f98ef9c
 2010-07-06 07:36:18 +00:00
drh
6498f0bb2e Avoid unnecessary calls to sqlite3_step() with null prepared statements 
while parsing the schema.

FossilOrigin-Name: ae04d2d15d3d96f607adb394a631d96cd4cf2c1d
 2010-04-09 09:14:05 +00:00
drh
8b307fbfa0 Automatically generate transient indices for tables in joins that would 
otherwise have to use a full table scan.

FossilOrigin-Name: 1b2a04125f964e14f3fb90171c5ab86a0641d1c9
 2010-04-06 15:57:05 +00:00
dan
b7dca7d733 Modify the vdbe so that the comparison operator opcodes do not modify the data type of operands. Fix for [aa92c76cd4]. 
FossilOrigin-Name: 8858042fa1449516a2c7dbb991dca3eb6c5794cb
 2010-03-05 16:32:12 +00:00
drh
a6129fa79a Enhancements to the way errors are reported up when an automatic 
statement reprepare fails.

FossilOrigin-Name: 1a6d4bb130382564093b6370818ae4a7633f4074
 2010-02-24 17:15:19 +00:00
drh
413c3d36a2 Continuing improvements to error reporting and the sqlite3_log() routine. 
FossilOrigin-Name: edea3bb740ddd096a46e00678b59d465bb1e2903
 2010-02-23 20:11:56 +00:00
drh
9978c97ec5 Remove the obsolete sqlite3SafetyOn() mechanism. Add additional logging 
output for CORRUPT, and CANTOPEN errors.

FossilOrigin-Name: 7c4cca6d1a23a6d1591b62f58c3716a944969947
 2010-02-23 17:36:32 +00:00
drh
6a9c64b363 Make sure internal queries are well ordered, even when the 
reverse_unordered_selects pragma is in effect.
Ticket [eb942c64a157].

FossilOrigin-Name: 0209f17180065d9c213b6c437be1c3c40660665f
 2010-01-12 23:54:14 +00:00
shaneh
d77f56efe5 Fix typo in comment of prepare.c. 
FossilOrigin-Name: 333c3ffe6d4d2293d01958812b9c02b0bf9796a4
 2009-12-17 21:05:42 +00:00
drh
c81c11f62c Remove the obsolete "$Id:$" RCS identifier strings from the source code. 
FossilOrigin-Name: f6c045f649036958078cb15cd9d5453680c82b0c
 2009-11-10 01:30:52 +00:00
dan
937d0dea4f Add the experimental sqlite3_reoptimize() API. 
FossilOrigin-Name: 9bd6f3d8864d422fe42074688b191915b27ad8ea
 2009-10-15 18:35:38 +00:00
dan
65a7cd1631 More fixes and comment updates. 
FossilOrigin-Name: 38a9327bad1a01e3d7a47fad44ece2f6c7e88643
 2009-09-01 12:16:01 +00:00
dan
2832ad4221 More fixes for test cases. 
FossilOrigin-Name: 85d9f23be1e8673dbda42e43b9b23332ada9225f
 2009-08-31 15:27:27 +00:00
dan
165921a742 Changes to support recursive triggers. 
FossilOrigin-Name: 9b9c19211593d5ff7b39254a29c284560a8bcedb
 2009-08-28 18:53:45 +00:00
drh
3d5f74b275 Alternative fix for ticket #3810. This is a replacement for check-in (6956). (CVS 6960) 
FossilOrigin-Name: ba1afc040171810d0c996708d7b9cb11abcd99d8
 2009-08-06 17:43:31 +00:00