/ File History
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of test/auth.test

2019-08-08
15:24
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. file: [2154625c] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 65578
2018-09-19
17:09
Fix a compilation issue in the "userauth" extension. Also fix a few test script errors that occur with SQLITE_USER_AUTHENTICATION=1 builds. file: [3310d9c0] check-in: [221f3f57] user: dan branch: trunk, size: 65653
2018-09-06
17:47
Fix a problem in ALTER TABLE with SQLITE_OMIT_VIRTUALTABLE builds. file: [f0c1a8fc] check-in: [fa835145] user: dan branch: trunk, size: 65624
2018-08-25
16:14
Invoke the authorizer for ALTER TABLE RENAME COLUMN. file: [4dd570df] check-in: [fc293bcb] user: drh branch: alter-table-rename-column, size: 65618
2017-05-11
19:09
Add another test case for the new authorizer functionality. file: [3d6cd8f3] check-in: [339df63f] user: dan branch: trunk, size: 63786
13:43
New requirements marks and documentation for the authorizer. file: [32ee0e98] check-in: [3980ea09] user: drh branch: trunk, size: 63219
2017-05-10
16:12
Invoke the SQLITE_READ authorizer callback with a NULL column name for any table referenced by a query but from when no columns are extracted. file: [5caf9c6d] check-in: [92ab1f72] user: drh branch: trunk, size: 61964
2016-12-16
01:00
All temp.sqlite_master to be used as an alias for sqlite_temp_master. file: [c6ede04b] check-in: [8d646905] user: drh branch: trunk, size: 61368
2016-04-04
16:40
Test that the view name is passed to the authorization callback when a SELECT statement is run on a view. file: [872a122b] check-in: [8627a4cd] user: dan branch: trunk, size: 61368
2014-09-11
13:44
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. file: [855233ef] check-in: [596e728b] user: drh branch: user-auth, size: 60217
2014-01-16
22:40
Add the ability for the authorizer callback to disallow recursive queries. file: [5bdf154e] check-in: [9efc120a] user: drh branch: common-table-expr, size: 59492
2013-08-12
20:14
If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. file: [9bea2904] check-in: [cca8bf43] user: dan branch: sqlite_stat4, size: 58461
2013-08-03
20:24
Begin adding experimental sqlite_stat4 table. This commit is buggy. file: [cb43e31c] check-in: [2beea303] user: dan branch: sqlite_stat4, size: 58386
2013-05-06
13:22
Make sure the authorizer callback gets a valid pointer to "ROWID" for the column-name parameter when doing an UPDATE that changes the rowid. Fix for ticket [0eb70d77cb05bb2272]. file: [4a4c3b03] check-in: [26a59bb8] user: drh branch: trunk, size: 58386
2013-03-09
14:40
Fix a problem with resolving "db.view.column" references that appear in UPDATE or DELETE statements executed against views. file: [1b21145e] check-in: [ddee56c9] user: dan branch: trunk, size: 57818
2011-10-21
19:06
Purge lingering references to SQLITE_STAT2 from the code and test scripts. file: [304e82f3] check-in: [aed2bf7a] user: drh branch: trunk, size: 57674
2011-08-26
13:52
Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. file: [75010ec8] check-in: [0df04f92] user: drh branch: stat3-3.7.2, size: 57443
2011-08-12
01:51
Begin a branch that experimentally replaces sqlite_stat2 with a new table called sqlite_stat3 that will hopefully facilitate better query planning decisions. file: [ac996c81] check-in: [52e1d7e8] user: drh branch: stat3-enhancement, size: 57749
2011-02-04
00:51
Fix the ATTACH command so that the filename argument can be any expression and so that if authorizer callback gets a NULL pointer for the filename if the filename argument is anything other than a string literal. Ticket [9013e13dba5b58c7] file: [b047105c] check-in: [e64e1453] user: drh branch: trunk, size: 57674
2010-09-25
22:32
Enhance the ANALYZE command so that it gathers statistics in the sqlite_stat1 table even for tables that are empty or have no indices. file: [26cc6f21] check-in: [a7645d29] user: drh branch: trunk, size: 57368
2009-09-19
17:00
Check in implementation of foreign key constraints. file: [8f21c160] check-in: [d5d39981] user: dan branch: trunk, size: 57354
2009-08-31
08:22
Fix some authorization callback problems. file: [0f1237e1] check-in: [8a746fbf] user: dan branch: trunk, size: 57353
2009-08-19
08:18
Add the SQLITE_ENABLE_STAT2 macro. If this is not defined at build-time, the stat2 table is not created, populated, or used. file: [8e9a21d7] check-in: [362665e8] user: dan branch: trunk, size: 57353
2009-08-17
17:06
First version of sqlite_stat2 (schema forces exactly 10 samples). file: [393be593] check-in: [dd96bda2] user: dan branch: trunk, size: 57276
2009-07-02
18:40
Fix to sqlite3AuthRead to accommodate "new" or "old" references that are used in a context where a column reference may also be used (i.e. "SELECT new. FROM <tble>"). Ticket #3944. (CVS 6838) file: [b2813abf] check-in: [45fd5419] user: danielk1977 branch: trunk, size: 57263
2009-05-04
01:58
Work toward cleaning up the authorizer interface. Work is on-going. This is an incremental check-in. (CVS 6598) file: [b66c5711] check-in: [694662f7] user: drh branch: trunk, size: 56636
2008-10-27
15:34
If an SQLITE_DELETE authorization callback returns SQLITE_IGNORE, proceed with the delete operation but disable the truncate optimization. (CVS 5845) file: [0e901aeb] check-in: [65a2e131] user: danielk1977 branch: trunk, size: 56820
2008-07-02
13:13
Call the authorizer callback the same number of times whether or not the query flattening occurs. (CVS 5338) file: [9eb4b6b9] check-in: [8b88b64b] user: danielk1977 branch: trunk, size: 56755
2008-04-15
14:36
Do not attempt to omit unused columns of a view in an instead-of trigger since sometimes those columns can be used in ways that we do not expect. Ticket #3055. (CVS 5012) file: [100cde29] check-in: [f5fc42e9] user: drh branch: trunk, size: 56747
2008-02-12
16:52
When materializing a view for an UPDATE or DELETE make use of the WHERE clause to limit the number of rows materialized. Ticket #2938. (CVS 4782) file: [d5896499] check-in: [5ab71c3a] user: drh branch: trunk, size: 56747
2008-01-01
19:02
Optimize trigger compilation to avoid populating the OLD.* and NEW.* pseudo-tables with data that will never be used. Some testing to come. (CVS 4651) file: [be181f70] check-in: [e08a33ed] user: danielk1977 branch: trunk, size: 56677
2007-11-13
10:30
Modify the Tcl interface to use sqlite3_prepare_v2(). (CVS 4542) file: [74b49b66] check-in: [7bb00c7d] user: danielk1977 branch: trunk, size: 56677
2007-10-09
08:29
Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480) file: [6d98da67] check-in: [07c00fff] user: danielk1977 branch: trunk, size: 56183
2006-08-24
14:59
Enhance the sqlite3_set_authorizer() callback so that it provides callbacks on each SQL function that is invoked. (CVS 3365) file: [66923137] check-in: [4547c81f] user: drh branch: trunk, size: 55783
2006-06-17
09:39
Add tests (and fixes) for the virtual table transaction interface. (CVS 3265) file: [5e27e39e] check-in: [8a5b121f] user: danielk1977 branch: trunk, size: 55789
06:31
When updating a view, invoke the authorization callback for reading the view before setting the authorization-context to the view name. (CVS 3264) file: [b7db5241] check-in: [48d297c5] user: danielk1977 branch: trunk, size: 55800
2006-01-31
14:28
Authorization callback on the ALTER TABLE ADD COLUMN command. Ticket #1479. (CVS 3043) file: [9776ab43] check-in: [461f5869] user: drh branch: trunk, size: 55781
2006-01-17
09:35
Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [0e8d4fd6] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 54083
2006-01-16
16:24
Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS 2961) file: [639288b5] check-in: [c058f483] user: danielk1977 branch: trunk, size: 53886
15:14
Fix some of the issues raised in #1615. (CVS 2959) file: [11f73157] check-in: [0d5d83bc] user: danielk1977 branch: trunk, size: 53847
2006-01-13
13:55
Make sure the authenticator does not try to authenticate columns in subqueries. Ticket #1607. (CVS 2939) file: [487fdd95] check-in: [55b7dfaf] user: drh branch: trunk, size: 53832
2005-07-29
15:36
Fix authentication so that it works with AS aliases. Ticket #1338. (CVS 2570) file: [973ae727] check-in: [cc7ae73e] user: drh branch: trunk, size: 53598
2005-07-23
02:17
Full-coverage testing and documentation for the ANALYZE command. The results of analysis are still not loaded or used, however. (CVS 2561) file: [6a51c572] check-in: [bd7583a5] user: drh branch: trunk, size: 53355
2005-03-29
03:10
Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) file: [5129bfe2] check-in: [c41d5544] user: danielk1977 branch: trunk, size: 52471
2005-01-24
10:25
Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271) file: [b24d12de] check-in: [d5233e07] user: danielk1977 branch: trunk, size: 50875
2004-11-23
15:41
Add authorization callbacks for REINDEX. (CVS 2148) file: [559e0816] check-in: [9f0d744e] user: danielk1977 branch: trunk, size: 50682
10:13
Have tests pass when SQLITE_OMIT_SCHEMA_PRAGMAS is defined. (CVS 2144) file: [ecc43fc5] check-in: [6ccb589b] user: danielk1977 branch: trunk, size: 48570
2004-11-22
11:51
Ensure tests pass when SQLITE_OMIT_TRIGGER is defined. (CVS 2137) file: [050fe904] check-in: [53894988] user: danielk1977 branch: trunk, size: 48456
08:43
Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) file: [38a05466] check-in: [711e8d76] user: danielk1977 branch: trunk, size: 48183
03:34
Fix auth.test to work when SQLITE_OMIT_ALTERTABLE is defined. (CVS 2130) file: [6dd796db] check-in: [27a8379b] user: danielk1977 branch: trunk, size: 47975
2004-11-12
15:53
Add authorization callbacks to ALTER TABLE. (CVS 2093) file: [cf13e449] check-in: [c4115aa3] user: danielk1977 branch: trunk, size: 47845
2004-09-30
13:43
Allow functions to be created when there are outstanding VMs. (Ticket #926) Fix problems with sqlite3_errcode(). Add tests for sqlite3_errcode(). (CVS 1989) file: [1cc252d9] check-in: [d0f1dc58] user: drh branch: trunk, size: 45121
2004-09-09
13:55
Fix a segfault in the authorizer when it is given a SELECT statement with no FROM clause. Ticket #896. (CVS 1954) file: [300024c2] check-in: [97d63b92] user: drh branch: trunk, size: 45122
13:54
Fix a segfault in the authorizer when it is given a SELECT statement with no FROM clause. Ticket #896. (CVS 1953) file: [3bd865e3] check-in: [205d85d7] user: drh branch: version_2, size: 45926
2004-07-26
12:24
Fix problems for 64-bit machines and when SQLITE_OMIT_AUTHORIZATION is defined. (CVS 1868) file: [e74b0155] check-in: [e3cad1ab] user: drh branch: trunk, size: 45027
2004-06-29
12:39
Improved test coverage of tclsqlite.c (CVS 1761) file: [23d1dbf2] check-in: [008e57dc] user: drh branch: trunk, size: 44970
2004-06-19
00:16
Change the name of the TCL command from "sqlite" to "sqlite3" so that both SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) file: [a211eab0] check-in: [d705d051] user: drh branch: trunk, size: 44922
2004-06-14
11:54
Fix a bug in the auth.test script. (CVS 1590) file: [4077c84a] check-in: [1fa97dd8] user: danielk1977 branch: trunk, size: 44929
2004-05-27
17:22
Remove the COPY command. (CVS 1477) file: [95809b8f] check-in: [287f8673] user: drh branch: trunk, size: 44581
2003-12-07
00:24
Make the VACUUM command run out of the VDBE like all other commands. (Ticket #464). Make the VACUUM command work even if there are VIEWs in the SQLITE_MASTER table that come before tables they reference. (Ticket #515) (CVS 1128) file: [5c4d95cd] check-in: [614cbbaf] user: drh branch: trunk, size: 45827
2003-11-27
00:48
Disallow temporary indices on persistent tables. (CVS 1122) file: [b7d6bdef] check-in: [72bf73b2] user: drh branch: trunk, size: 45823
2003-06-06
19:00
Extend the authorization mechanism to disallow the ATTACH and DETACH commands. Ticket #340. (CVS 1010) file: [a618f0e9] check-in: [a97dca73] user: drh branch: trunk, size: 45649
2003-04-25
17:52
Report the correct authorization context in the authorization callback when coding an INSTEAD OF trigger on an update or delete. (CVS 936) file: [dee78be1] check-in: [67746833] user: drh branch: trunk, size: 43345
2003-04-22
20:30
Update the authorizer API so that it reports the database that table and indices belong to and so that it reports when actions are taken in response to a trigger. (CVS 928) file: [d25a76f2] check-in: [c675a550] user: drh branch: trunk, size: 41578
2003-04-16
20:24
Fix the authorizer so that it correctly interprets attempts to read the OLD and NEW pseudo-tables of a trigger. (CVS 911) file: [8128cd75] check-in: [f04bd432] user: drh branch: trunk, size: 38823
2003-04-05
03:42
Begin testing the new ATTACH and DETACH commands. (CVS 898) file: [bf039c94] check-in: [7a0f8024] user: drh branch: trunk, size: 38113
2003-01-31
17:21
The sqlite_exec() function now returns SQLITE_AUTH when authorization fails. Ticket #231. (CVS 857) file: [33e8b968] check-in: [d93c1aeb] user: drh branch: trunk, size: 38086
2003-01-14
13:48
Finish out the test suite for the new sqlite_set_authorizer API. (CVS 834) file: [95aeda24] check-in: [701a7391] user: drh branch: trunk, size: 37953
02:49
More tests of the sqlite_set_authorizer() API together with fixes for bugs that the new tests uncovered. (CVS 832) file: [30149de6] check-in: [cc2ae781] user: drh branch: trunk, size: 34348
2003-01-13
23:27
Revise the sqlite_set_authorizer API to provide more detailed information about the SQL statement being authorized. Only partially tested so far. (CVS 830) file: [c0b3210b] check-in: [45de93f9] user: drh branch: trunk, size: 3757
2003-01-12
19:33
The initial round of tests for the sqlite_set_authorizer() API. More are needed before release. Ticket #215. (CVS 829) file: [1e8e443b] check-in: [5707b3d5] user: drh branch: trunk, size: 7421 Added