SQLite

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

History for test/auth.test

FROM <tble>"). Ticket #3944. (CVS 6838) (check-in: [45fd5419a7] user: danielk1977 branch: trunk, size: 57263)

2024-02-29
13:44		[8d4152a8dc] part of check-in [2266086cf0] Add the ability to DROP one or more objects of the same class in a single statement by listing the objects as multiple arguments to the DROP command. (check-in: [2266086cf0] user: drh branch: multi-drop, size: 67252)
2023-02-06
10:47		[5b8558a405] part of check-in [81c118d90b] Fix some test scripts that were failing with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: [81c118d90b] user: dan branch: trunk, size: 67125)
2022-12-29
18:54		[4fbeaa2836] part of check-in [eed1e03072] A call to sqlite3_declare_vtab() should not cause DML/DDL authorization failures. (check-in: [eed1e03072] user: drh branch: trunk, size: 67088)
2022-01-18
16:16		[0f246deec5] part of check-in [aca6c61d79] Fix ALTER TABLE DROP COLUMN so that it invokes the authorizer. Fix for forum post fd82b85947541dec. (check-in: [aca6c61d79] user: drh branch: trunk, size: 66725)
2021-06-14
20:41		[567d917e0b] part of check-in [e5a5acd600] In the authorizer, use SQLITE_DROP_INDEX, not SQLITE_DROP_TEMP_INDEX when dropping an index in an attached database. (check-in: [e5a5acd600] user: drh branch: trunk, size: 65848)
2021-05-10
13:28		[ac0bcee1c2] part of check-in [905085a75d] Add new output columns to the "PRAGMA database_list" statement. (check-in: [905085a75d] user: drh branch: database-list-enhancement, size: 65583)
2019-08-08
15:24		[2154625c05] part of check-in [1e17ea2fd1] 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: [1e17ea2fd1] user: drh branch: omit-stat3, size: 65578)
2018-09-19
17:09		[3310d9c08e] part of check-in [221f3f572e] 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: [221f3f572e] user: dan branch: trunk, size: 65653)
2018-09-06
17:47		[f0c1a8fc7f] part of check-in [fa835145e6] Fix a problem in ALTER TABLE with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: [fa835145e6] user: dan branch: trunk, size: 65624)
2018-08-25
16:14		[4dd570df24] part of check-in [fc293bcb34] Invoke the authorizer for ALTER TABLE RENAME COLUMN. (check-in: [fc293bcb34] user: drh branch: alter-table-rename-column, size: 65618)
2017-05-11
19:09		[3d6cd8f397] part of check-in [339df63f40] Add another test case for the new authorizer functionality. (check-in: [339df63f40] user: dan branch: trunk, size: 63786)
13:43		[32ee0e9859] part of check-in [3980ea0911] New requirements marks and documentation for the authorizer. (check-in: [3980ea0911] user: drh branch: trunk, size: 63219)
2017-05-10
16:12		[5caf9c6d8e] part of check-in [92ab1f7257] 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: [92ab1f7257] user: drh branch: trunk, size: 61964)
2016-12-16
01:00		[c6ede04bee] part of check-in [8d646905b8] All temp.sqlite_master to be used as an alias for sqlite_temp_master. (check-in: [8d646905b8] user: drh branch: trunk, size: 61368)
2016-04-04
16:40		[872a122b39] part of check-in [8627a4cd6d] Test that the view name is passed to the authorization callback when a SELECT statement is run on a view. (check-in: [8627a4cd6d] user: dan branch: trunk, size: 61368)
2014-09-11
13:44		[855233ef26] part of check-in [596e728b0e] 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: [596e728b0e] user: drh branch: user-auth, size: 60217)
2014-01-16
22:40		[5bdf154eb2] part of check-in [9efc120a15] Add the ability for the authorizer callback to disallow recursive queries. (check-in: [9efc120a15] user: drh branch: common-table-expr, size: 59492)
2013-08-12
20:14		[9bea290418] part of check-in [cca8bf4372] 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: [cca8bf4372] user: dan branch: sqlite_stat4, size: 58461)
2013-08-03
20:24		[cb43e31c14] part of check-in [2beea303a1] Begin adding experimental sqlite_stat4 table. This commit is buggy. (check-in: [2beea303a1] user: dan branch: sqlite_stat4, size: 58386)
2013-05-06
13:22		[4a4c3b034f] part of check-in [26a59bb88d] 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: [26a59bb88d] user: drh branch: trunk, size: 58386)
2013-03-09
14:40		[1b21145e88] part of check-in [ddee56c9b2] Fix a problem with resolving "db.view.column" references that appear in UPDATE or DELETE statements executed against views. (check-in: [ddee56c9b2] user: dan branch: trunk, size: 57818)
2011-10-21
19:06		[304e82f315] part of check-in [aed2bf7a3c] Purge lingering references to SQLITE_STAT2 from the code and test scripts. (check-in: [aed2bf7a3c] user: drh branch: trunk, size: 57674)
2011-08-26
13:52		[75010ec8c4] part of check-in [0df04f920b] Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. (check-in: [0df04f920b] user: drh branch: stat3-3.7.2, size: 57443)
2011-08-12
01:51		[ac996c81ad] part of check-in [52e1d7e8dd] 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: [52e1d7e8dd] user: drh branch: stat3-enhancement, size: 57749)
2011-02-04
00:51		[b047105c32] part of check-in [e64e1453a9] 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: [e64e1453a9] user: drh branch: trunk, size: 57674)
2010-09-25
22:32		[26cc6f2195] part of check-in [a7645d2938] 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: [a7645d2938] user: drh branch: trunk, size: 57368)
2009-09-19
17:00		[8f21c160a4] part of check-in [d5d3998118] Check in implementation of foreign key constraints. (check-in: [d5d3998118] user: dan branch: trunk, size: 57354)
2009-08-31
08:22		[0f1237e10a] part of check-in [8a746fbfd5] Fix some authorization callback problems. (check-in: [8a746fbfd5] user: dan branch: trunk, size: 57353)
2009-08-19
08:18		[8e9a21d732] part of check-in [362665e89c] 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: [362665e89c] user: dan branch: trunk, size: 57353)
2009-08-17
17:06		[393be593c7] part of check-in [dd96bda2a8] First version of sqlite_stat2 (schema forces exactly 10 samples). (check-in: [dd96bda2a8] user: dan branch: trunk, size: 57276)
2009-07-02
18:40		[b2813abf4a] part of check-in [45fd5419a7] 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		[b66c571142] part of check-in [694662f786] Work toward cleaning up the authorizer interface. Work is on-going. This is an incremental check-in. (CVS 6598) (check-in: [694662f786] user: drh branch: trunk, size: 56636)
2008-10-27
15:34		[0e901aeb39] part of check-in [65a2e13173] If an SQLITE_DELETE authorization callback returns SQLITE_IGNORE, proceed with the delete operation but disable the truncate optimization. (CVS 5845) (check-in: [65a2e13173] user: danielk1977 branch: trunk, size: 56820)
2008-07-02
13:13		[9eb4b6b99e] part of check-in [8b88b64bb3] Call the authorizer callback the same number of times whether or not the query flattening occurs. (CVS 5338) (check-in: [8b88b64bb3] user: danielk1977 branch: trunk, size: 56755)
2008-04-15
14:36		[100cde29a9] part of check-in [f5fc42e96d] 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: [f5fc42e96d] user: drh branch: trunk, size: 56747)
2008-02-12
16:52		[d5896499f9] part of check-in [5ab71c3a79] 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: [5ab71c3a79] user: drh branch: trunk, size: 56747)
2008-01-01
19:02		[be181f70ce] part of check-in [e08a33ed72] 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: [e08a33ed72] user: danielk1977 branch: trunk, size: 56677)
2007-11-13
10:30		[74b49b669c] part of check-in [7bb00c7df6] Modify the Tcl interface to use sqlite3_prepare_v2(). (CVS 4542) (check-in: [7bb00c7df6] user: danielk1977 branch: trunk, size: 56677)
2007-10-09
08:29		[6d98da67f4] part of check-in [07c00fffe5] Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480) (check-in: [07c00fffe5] user: danielk1977 branch: trunk, size: 56183)
2006-08-24
14:59		[66923137cf] part of check-in [4547c81f7d] Enhance the sqlite3_set_authorizer() callback so that it provides callbacks on each SQL function that is invoked. (CVS 3365) (check-in: [4547c81f7d] user: drh branch: trunk, size: 55783)
2006-06-17
09:39		[5e27e39ed1] part of check-in [8a5b121f2f] Add tests (and fixes) for the virtual table transaction interface. (CVS 3265) (check-in: [8a5b121f2f] user: danielk1977 branch: trunk, size: 55789)
06:31		[b7db524134] part of check-in [48d297c561] 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: [48d297c561] user: danielk1977 branch: trunk, size: 55800)
2006-01-31
14:28		[9776ab43de] part of check-in [461f586973] Authorization callback on the ALTER TABLE ADD COLUMN command. Ticket #1479. (CVS 3043) (check-in: [461f586973] user: drh branch: trunk, size: 55781)
2006-01-17
09:35		[0e8d4fd60b] part of check-in [3a54a33dcb] Test suite fixes for builds that define OMIT symbols. (CVS 2962) (check-in: [3a54a33dcb] user: danielk1977 branch: trunk, size: 54083)
2006-01-16
16:24		[639288b5da] part of check-in [c058f483a5] Test file fixes for libaries compiled with various SQLITE_OMIT_ macros. (CVS 2961) (check-in: [c058f483a5] user: danielk1977 branch: trunk, size: 53886)
15:14		[11f73157a2] part of check-in [0d5d83bcbd] Fix some of the issues raised in #1615. (CVS 2959) (check-in: [0d5d83bcbd] user: danielk1977 branch: trunk, size: 53847)
2006-01-13
13:55		[487fdd95cf] part of check-in [55b7dfaf4d] Make sure the authenticator does not try to authenticate columns in subqueries. Ticket #1607. (CVS 2939) (check-in: [55b7dfaf4d] user: drh branch: trunk, size: 53832)
2005-07-29
15:36		[973ae7274e] part of check-in [cc7ae73ed0] Fix authentication so that it works with AS aliases. Ticket #1338. (CVS 2570) (check-in: [cc7ae73ed0] user: drh branch: trunk, size: 53598)
2005-07-23
02:17		[6a51c57219] part of check-in [bd7583a5d6] Full-coverage testing and documentation for the ANALYZE command. The results of analysis are still not loaded or used, however. (CVS 2561) (check-in: [bd7583a5d6] user: drh branch: trunk, size: 53355)
2005-03-29
03:10		[5129bfe268] part of check-in [c41d55443c] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d55443c] user: danielk1977 branch: trunk, size: 52471)
2005-01-24
10:25		[b24d12de3a] part of check-in [d5233e0747] Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271) (check-in: [d5233e0747] user: danielk1977 branch: trunk, size: 50875)
2004-11-23
15:41		[559e0816b8] part of check-in [9f0d744ee4] Add authorization callbacks for REINDEX. (CVS 2148) (check-in: [9f0d744ee4] user: danielk1977 branch: trunk, size: 50682)
10:13		[ecc43fc560] part of check-in [6ccb589bd9] Have tests pass when SQLITE_OMIT_SCHEMA_PRAGMAS is defined. (CVS 2144) (check-in: [6ccb589bd9] user: danielk1977 branch: trunk, size: 48570)
2004-11-22
11:51		[050fe904ab] part of check-in [53894988ac] Ensure tests pass when SQLITE_OMIT_TRIGGER is defined. (CVS 2137) (check-in: [53894988ac] user: danielk1977 branch: trunk, size: 48456)
08:43		[38a0546692] part of check-in [711e8d7695] Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) (check-in: [711e8d7695] user: danielk1977 branch: trunk, size: 48183)
03:34		[6dd796db74] part of check-in [27a8379b54] Fix auth.test to work when SQLITE_OMIT_ALTERTABLE is defined. (CVS 2130) (check-in: [27a8379b54] user: danielk1977 branch: trunk, size: 47975)
2004-11-12
15:53		[cf13e449cb] part of check-in [c4115aa3a1] Add authorization callbacks to ALTER TABLE. (CVS 2093) (check-in: [c4115aa3a1] user: danielk1977 branch: trunk, size: 47845)
2004-09-30
13:43		[1cc252d9e7] part of check-in [d0f1dc5898] 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: [d0f1dc5898] user: drh branch: trunk, size: 45121)
2004-09-09
13:55		[300024c28f] part of check-in [97d63b9290] Fix a segfault in the authorizer when it is given a SELECT statement with no FROM clause. Ticket #896. (CVS 1954) (check-in: [97d63b9290] user: drh branch: trunk, size: 45122)
13:54		[3bd865e306] part of check-in [205d85d77e] Fix a segfault in the authorizer when it is given a SELECT statement with no FROM clause. Ticket #896. (CVS 1953) (check-in: [205d85d77e] user: drh branch: version_2, size: 45926)
2004-07-26
12:24		[e74b015545] part of check-in [e3cad1ab62] Fix problems for 64-bit machines and when SQLITE_OMIT_AUTHORIZATION is defined. (CVS 1868) (check-in: [e3cad1ab62] user: drh branch: trunk, size: 45027)
2004-06-29
12:39		[23d1dbf223] part of check-in [008e57dcd5] Improved test coverage of tclsqlite.c (CVS 1761) (check-in: [008e57dcd5] user: drh branch: trunk, size: 44970)
2004-06-19
00:16		[a211eab054] part of check-in [d705d051be] 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: [d705d051be] user: drh branch: trunk, size: 44922)
2004-06-14
11:54		[4077c84a15] part of check-in [1fa97dd81d] Fix a bug in the auth.test script. (CVS 1590) (check-in: [1fa97dd81d] user: danielk1977 branch: trunk, size: 44929)
2004-05-27
17:22		[95809b8f6a] part of check-in [287f86731c] Remove the COPY command. (CVS 1477) (check-in: [287f86731c] user: drh branch: trunk, size: 44581)
2003-12-07
00:24		[5c4d95cdaf] part of check-in [614cbbafa1] 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: [614cbbafa1] user: drh branch: trunk, size: 45827)
2003-11-27
00:48		[b7d6bdeffa] part of check-in [72bf73b2c1] Disallow temporary indices on persistent tables. (CVS 1122) (check-in: [72bf73b2c1] user: drh branch: trunk, size: 45823)
2003-06-06
19:00		[a618f0e96b] part of check-in [a97dca73ae] Extend the authorization mechanism to disallow the ATTACH and DETACH commands. Ticket #340. (CVS 1010) (check-in: [a97dca73ae] user: drh branch: trunk, size: 45649)
2003-04-25
17:52		[dee78be1f4] part of check-in [67746833fc] Report the correct authorization context in the authorization callback when coding an INSTEAD OF trigger on an update or delete. (CVS 936) (check-in: [67746833fc] user: drh branch: trunk, size: 43345)
2003-04-22
20:30		[d25a76f214] part of check-in [c675a55041] 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: [c675a55041] user: drh branch: trunk, size: 41578)
2003-04-16
20:24		[8128cd7508] part of check-in [f04bd43254] Fix the authorizer so that it correctly interprets attempts to read the OLD and NEW pseudo-tables of a trigger. (CVS 911) (check-in: [f04bd43254] user: drh branch: trunk, size: 38823)
2003-04-05
03:42		[bf039c94d6] part of check-in [7a0f8024a1] Begin testing the new ATTACH and DETACH commands. (CVS 898) (check-in: [7a0f8024a1] user: drh branch: trunk, size: 38113)
2003-01-31
17:21		[33e8b9680e] part of check-in [d93c1aeb54] The sqlite_exec() function now returns SQLITE_AUTH when authorization fails. Ticket #231. (CVS 857) (check-in: [d93c1aeb54] user: drh branch: trunk, size: 38086)
2003-01-14
13:48		[95aeda24f7] part of check-in [701a73918d] Finish out the test suite for the new sqlite_set_authorizer API. (CVS 834) (check-in: [701a73918d] user: drh branch: trunk, size: 37953)
02:49		[30149de6b7] part of check-in [cc2ae781ac] More tests of the sqlite_set_authorizer() API together with fixes for bugs that the new tests uncovered. (CVS 832) (check-in: [cc2ae781ac] user: drh branch: trunk, size: 34348)
2003-01-13
23:27		[c0b3210b10] part of check-in [45de93f913] 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: [45de93f913] user: drh branch: trunk, size: 3757)
2003-01-12
19:33		Added: [1e8e443bc8] part of check-in [5707b3d56e] The initial round of tests for the sqlite_set_authorizer() API. More are needed before release. Ticket #215. (CVS 829) (check-in: [5707b3d56e] user: drh branch: trunk, size: 7421)