/ All files named "test/auth.test"
Login

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

History for test/auth.test

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