Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/view.test
2024-04-25
| ||
16:55 | [3c23d7a068] part of check-in [b8ec8511b1] Back out the previous change on this branch. In its place: Determine the affinity of a subquery by the left-most arm of the subquery that has an affinity other than NONE. In other words, scan from left to right looking for an arm of the compound subquery with an affinity of BLOB, TEXT, INTEGER, or REAL and pick the first one found. Or stay with NONE if no arm has a defined affinity. Test cases added. (check-in: [b8ec8511b1] user: drh branch: compound-subquery-affinity, size: 19473) | |
2024-04-24
| ||
19:49 | [9df7e00eb1] part of check-in [779723ad79] An experimental minor tweak to the way affinities are computed for compound subqueries, when the actual affinity is ambiguous. (check-in: [779723ad79] user: drh branch: compound-subquery-affinity, size: 18695) | |
2023-01-10
| ||
19:57 | [d4c4281e16] part of check-in [497a98363f] When computing the datatypes for columns in a view, use the same datatype name as the underlying table if such is available and is consistent with the computed affinity of the column. Forum thread 7fb1fe9dcf310ef5. (check-in: [497a98363f] user: drh branch: trunk, size: 18696) | |
2022-12-14
| ||
14:41 | [a7c463254f] part of check-in [6ebb178c6b] If the SELECT that implements a subquery or a VIEW or a CREATE TABLE AS is a compound with different result datatypes on two or more arms of the compound, then the overall column type becomes BLOB (ANY). (check-in: [6ebb178c6b] user: drh branch: refactor-subquery-types, size: 18680) | |
2022-12-13
| ||
16:55 | [157a480bce] part of check-in [baf2c24133] Use standard datatype names for the column datatypes in views and subqueries. (check-in: [baf2c24133] user: drh branch: refactor-subquery-types, size: 18493) | |
2022-12-10
| ||
17:54 | [a5662e9c74] part of check-in [b0e49aa81a] Ensure that the types and collation sequences of a view are taken from the leftmost component of compound SELECTs, even when column names are explicitly provided for the view. Possible fix for [679ed6a2]. (check-in: [b0e49aa81a] user: dan branch: tkt-679ed6a2, size: 18510) | |
2022-07-18
| ||
19:32 | [d16e49e89a] part of check-in [22d280a5cd] Remove a few unsuitable scripts from the "veryquick" test suite. Also have every second testrunner.tcl process favour running test scripts that contain text like "testrunner: slow" before any others. (check-in: [22d280a5cd] user: dan branch: trunk, size: 17911) | |
2021-10-01
| ||
20:39 | [d654fbadae] part of check-in [2f7c946c5f] Change things so that SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTER_TABLE. (check-in: [2f7c946c5f] user: dan branch: trunk, size: 19395) | |
2021-09-21
| ||
17:26 | [798cf7936d] part of check-in [2c0e7ae541] Add the "PRAGMA table_list" command with its corresponding eponymous table-valued function: "pragma_table_list". (check-in: [2c0e7ae541] user: drh branch: trunk, size: 19370) | |
2021-03-05
| ||
18:33 | [ea88361d5e] part of check-in [83dab8b358] Modify the SQLITE_DBCONFIG_ENABLE_VIEW option so that it always permits TEMP views, just as SQLITE_DBCONFIG_ENABLE_TRIGGER always permits TEMP triggers. (check-in: [83dab8b358] user: drh branch: trunk, size: 19277) | |
2020-10-26
| ||
18:14 | [fd48eddb32] part of check-in [aa512f72cf] Always create a statement journal when using the OP_ParseSchema opcode, as you never know when it might fail. See the discussion on forum post daa2c728cc. (check-in: [aa512f72cf] user: drh branch: trunk, size: 19096) | |
2019-08-15
| ||
21:27 | [10ea54300a] part of check-in [61b4bccd29] Add the SQLITE_DBCONFIG_ENABLE_VIEW option, together with a "db config" command in the TCL interface that can access that option as well as all the other sqlite3_db_config() boolean options. (check-in: [61b4bccd29] user: drh branch: trunk, size: 18663) | |
2019-08-07
| ||
19:57 | [c1e64ff5a8] part of check-in [7f2246a17b] Remove use of the affinity() function from view.test, as it is only available in SQLITE_DEBUG builds. (check-in: [7f2246a17b] user: dan branch: trunk, size: 18403) | |
2019-08-06
| ||
21:16 | [3a4e64be30] part of check-in [17b3d2218c] Ensure that when the col in an operator like "val IN(col)" is a column of a view, its affinity is not used to coerce val. Fix for [0a5e2c1d]. (check-in: [17b3d2218c] user: dan branch: trunk, size: 18441) | |
2019-08-05
| ||
20:45 | [f0326e7878] part of check-in [f37317d81c] Add test cases to this branch. (check-in: [f37317d81c] user: dan branch: tkt-61c853-A, size: 18076) | |
2019-05-22
| ||
23:12 | [40d54c9ddf] part of check-in [cb1d06521d] New test case for check-in [74ef97bf51dd531a] that takes the fix in the previous check-in into account. (check-in: [cb1d06521d] user: drh branch: trunk, size: 17024) | |
2019-05-03
| ||
17:19 | [ee9262cee7] part of check-in [74ef97bf51] Fix a problem where self-joins on views that are aggregate queries may return the wrong result. (check-in: [74ef97bf51] user: dan branch: trunk, size: 16841) | |
2018-09-19
| ||
17:09 | [71e1bf4c0e] 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: 16426) | |
2018-08-21
| ||
17:03 | [226fb71e37] part of check-in [1e29fd430d] Fix a test case that was failing for SQLITE_ENABLE_STAT4 builds. (check-in: [1e29fd430d] user: dan branch: trunk, size: 16373) | |
2018-07-20
| ||
20:56 | [42b97dcd3d] part of check-in [2f5be3a2dd] When dropping a view, skip trying to delete from 'sqlite_stat*'. (check-in: [2f5be3a2dd] user: mistachkin branch: dropViewNoStat, size: 16279) | |
2016-04-05
| ||
20:59 | [765802c7a6] part of check-in [fb555c3c2a] Carry table column types through into VIEW definitions, where possible. (check-in: [fb555c3c2a] user: drh branch: trunk, size: 15744) | |
2015-10-11
| ||
20:39 | [f6c3a39e0c] part of check-in [9ab9c8c6d7] Detect and report circularly defined views even if the views have the columns defined in the CREATE VIEW statement. (check-in: [9ab9c8c6d7] user: drh branch: trunk, size: 15210) | |
2015-09-26
| ||
11:15 | [0d8935e648] part of check-in [f4704035a6] Fix a memory leak that can occur following a syntax error in CREATE VIEW. (check-in: [f4704035a6] user: drh branch: trunk, size: 15023) | |
2015-09-25
| ||
13:42 | [bfdec45ad4] part of check-in [6e4ac0be2d] Report an error if the number of named columns in a VIEW is different from the number of result columns in the SELECT statement that implements the VIEW. (check-in: [6e4ac0be2d] user: drh branch: trunk, size: 14889) | |
2015-08-24
| ||
17:42 | [3930ae9404] part of check-in [d794b34da6] Enhance the CREATE VIEW syntax so that the names of columns of the view can be specified after the view name. (check-in: [d794b34da6] user: drh branch: trunk, size: 14511) | |
2015-08-03
| ||
13:44 | [f44014f78d] part of check-in [70b57dafb3] Allow a VIEW to reference undefined tables and functions when initially created. The error report is deferred until the VIEW is used. This allows views to be created before subviews and tables that the view references. (check-in: [70b57dafb3] user: drh branch: trunk, size: 14234) | |
2014-03-04
| ||
21:19 | [f311691d69] part of check-in [554501f158] Avoid indexing off the front end of an array when creating a view with two or more blank column names in the SELECT statement that defines the view. (check-in: [554501f158] user: drh branch: trunk, size: 14252) | |
2013-03-04
| ||
17:41 | [4057630287] part of check-in [f40552ada5] Omit a test that uses the progress handler callback from view.test if OMIT_PROGRESS_HANDLER is defined. (check-in: [f40552ada5] user: dan branch: trunk, size: 13979) | |
2013-01-28
| ||
19:00 | [977eb3fa17] part of check-in [c2462a95ed] Issue an error message and quit (rather than overflowing a reference counter) if the number of references to a table exceeds the maximum due to nested UNION views. Fix for ticket [d58ccbb3f1]. (check-in: [c2462a95ed] user: drh branch: trunk, size: 13944) | |
2011-08-02
| ||
00:57 | [b182a67ec4] part of check-in [9007586fda] Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried. (check-in: [9007586fda] user: mistachkin branch: winopen-retry-logic, size: 12477) | |
2008-12-14
| ||
14:45 | [45f518205e] part of check-in [84f8417c07] Add the example from #3359 to the test suite. (CVS 6027) (check-in: [84f8417c07] user: danielk1977 branch: trunk, size: 12484) | |
2008-08-21
| ||
14:54 | [7fba28a47f] part of check-in [8593218c7c] Make sure "rowid" columns in views are named correctly. Ticket #3308. (CVS 5580) (check-in: [8593218c7c] user: drh branch: trunk, size: 12237) | |
2008-07-10
| ||
00:32 | [5799906511] part of check-in [636cd72329] Remove unused code. Test coverage enhancements. Modify the algorithm used to select column names for VIEWs of joins so that the constructed column names omits the underlying table names. (CVS 5386) (check-in: [636cd72329] user: drh branch: trunk, size: 11606) | |
2008-06-30
| ||
18:12 | [041ccaf4c9] part of check-in [6fcb3bffe2] Call the query flattener while processing the parent query. Previously, it was called while processing the sub-queries. (CVS 5330) (check-in: [6fcb3bffe2] user: danielk1977 branch: trunk, size: 11471) | |
2008-01-25
| ||
15:04 | [4864e3841a] part of check-in [50815a82e0] Error messages says "no such view" instead of "no such table" when trying to DROP a VIEW that does not exist. (CVS 4750) (check-in: [50815a82e0] user: drh branch: trunk, size: 11037) | |
2007-10-09
| ||
08:29 | [7e15fa1ba3] 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: 10763) | |
2006-09-11
| ||
23:45 | [852bd4101e] part of check-in [e4fe736cfb] Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899. (CVS 3406) (check-in: [e4fe736cfb] user: drh branch: trunk, size: 10718) | |
2006-06-11
| ||
23:41 | [16e2774fe3] part of check-in [898ec36b41] Progress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211) (check-in: [898ec36b41] user: drh branch: trunk, size: 10358) | |
2006-03-26
| ||
01:21 | [b0aeb933cc] part of check-in [80cda9f7ce] SQLite now always chooses the column names for compound selects using the left-most select. This makes SQLite work like other SQL database, but it also is a change from historical behavior and may break some scripts. Ticket #1721. (CVS 3153) (check-in: [80cda9f7ce] user: drh branch: trunk, size: 10350) | |
2006-03-09
| ||
17:28 | [ef328f28f5] part of check-in [36830fafa4] Correct names returned from a query against a view. Ticket #1709, #1688, #1711. (CVS 3128) (check-in: [36830fafa4] user: drh branch: trunk, size: 10350) | |
2006-02-05
| ||
18:55 | [7606d16559] part of check-in [f5341529d0] Detect circularly defined views and issue an error message. Ticket #1658. (CVS 3055) (check-in: [f5341529d0] user: drh branch: trunk, size: 10107) | |
2006-01-14
| ||
08:02 | [354bd0ceb3] part of check-in [8e79a0c24a] Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) (check-in: [8e79a0c24a] user: danielk1977 branch: trunk, size: 9948) | |
2005-08-20
| ||
03:03 | [ce0f0ad39f] part of check-in [f786f37a5e] Increased test coverage. Some malloc tests now fail though this is believed to be an instrumentation problem not a real error. (CVS 2604) (check-in: [f786f37a5e] user: drh branch: trunk, size: 9907) | |
2005-07-08
| ||
17:13 | [3c79232a2e] part of check-in [3bb9ce5f20] Change the name of the OpenTemp opcode to OpenVirtual which is more descriptive of what it does. (CVS 2541) (check-in: [3bb9ce5f20] user: drh branch: trunk, size: 9676) | |
2005-06-06
| ||
15:32 | [e24553116e] part of check-in [0d46289f02] Do not allow parameters in VIEW definitions. Ticket #1270. (CVS 2492) (check-in: [0d46289f02] user: drh branch: trunk, size: 9664) | |
2005-01-30
| ||
11:11 | [306cc4342e] part of check-in [9843c0dd79] Respect collation sequences in views. Ticket #1088. (CVS 2291) (check-in: [9843c0dd79] user: danielk1977 branch: trunk, size: 9476) | |
2005-01-29
| ||
08:32 | [a34c548893] part of check-in [b1b50f3158] Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) (check-in: [b1b50f3158] user: danielk1977 branch: trunk, size: 8991) | |
2005-01-21
| ||
04:25 | [5aac4c79eb] part of check-in [d4e19efcef] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) (check-in: [d4e19efcef] user: danielk1977 branch: trunk, size: 8992) | |
2004-11-22
| ||
13:35 | [3f96df86f1] part of check-in [007be591b7] Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: [007be591b7] user: danielk1977 branch: trunk, size: 8902) | |
08:43 | [a68bee7f5b] 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: 8856) | |
2004-11-03
| ||
16:27 | [2ec8fd4f38] part of check-in [b11fc9b3f3] Update tests to work even if some features of the library are disabled. (CVS 2050) (check-in: [b11fc9b3f3] user: drh branch: trunk, size: 8727) | |
2004-07-20
| ||
00:20 | [ac15192889] part of check-in [ef0d5ebe96] Correct handling of views on tables with quoted column names. Ticket #756. (CVS 1827) (check-in: [ef0d5ebe96] user: drh branch: version_2, size: 8638) | |
00:20 | [ca5c296989] part of check-in [8ac5a8ad5e] Correct handling of views on tables with quoted column names. Ticket #756. (CVS 1826) (check-in: [8ac5a8ad5e] user: drh branch: trunk, size: 8639) | |
2004-06-19
| ||
00:16 | [b42c98499a] 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: 8246) | |
2003-05-31
| ||
16:21 | [1ee12c6f8f] part of check-in [7202d4f1a8] Tighter binding of views, triggers, and indices to their respective databases. Ticket #323. Much more testing needs to be done to the sqliteFix...() routines in attach.c. (CVS 990) (check-in: [7202d4f1a8] user: drh branch: trunk, size: 8240) | |
2003-05-02
| ||
16:04 | [408fa464da] part of check-in [ad57693e9f] Enhance the query flattener to handle subqueries that are joins. All regressions pass but new tests need to be added before release. Ticket #272. (CVS 948) (check-in: [ad57693e9f] user: drh branch: trunk, size: 8235) | |
14:32 | [8b3b0b3067] part of check-in [be7aed2011] VDBE cursors numbers for tables in a join do not have to be consecutive. This is one step on the road to fixing ticket #272. (CVS 947) (check-in: [be7aed2011] user: drh branch: trunk, size: 7305) | |
2003-04-24
| ||
01:45 | [d356f445d4] part of check-in [206b17397b] Fix some issues with INSTEAD OF triggers. (CVS 930) (check-in: [206b17397b] user: drh branch: trunk, size: 7110) | |
2002-12-03
| ||
02:22 | [c64fa39ea5] part of check-in [dbf7893234] Honor ORDER BY clauses in VIEWs. Ticket #193. (CVS 792) (check-in: [dbf7893234] user: drh branch: trunk, size: 7080) | |
2002-08-25
| ||
19:20 | [76d3fe155f] part of check-in [c602603e7c] Fix for ticket #136: Added the OP_RenameCursor VDBE instruction and used it to make cursor numbers right on nested subqueries. Also added OP_Gosub and OP_Return but have not actually used them for anything yet. (CVS 727) (check-in: [c602603e7c] user: drh branch: trunk, size: 6142) | |
18:29 | [ed18cebaa1] part of check-in [b957dafc26] Fix the memory leak introduced by check-in (725). (CVS 726) (check-in: [b957dafc26] user: drh branch: trunk, size: 6091) | |
2002-08-24
| ||
18:24 | [e4d60d68ea] part of check-in [22d8726e61] Change the way token memory is allocated in an effort to fix ticket #136. There is now a memory leak when using views of views. (CVS 725) (check-in: [22d8726e61] user: drh branch: trunk, size: 6090) | |
2002-07-16
| ||
02:05 | [3afca084da] part of check-in [93710f7ed7] Fix for ticket #100: Correctly handle ON and USING clauses of JOINs within a VIEW. (CVS 679) (check-in: [93710f7ed7] user: drh branch: trunk, size: 5491) | |
2002-07-02
| ||
13:05 | [28700c1f9a] part of check-in [85793a4f03] Fix for ticket #92: Correct the sqliteExprCompare() function so that is takes into account the iTable and iColumn fields of the Expr structure. Otherwise, "min(a)" and "min(b)" will compare equal to each other in views. (CVS 658) (check-in: [85793a4f03] user: drh branch: trunk, size: 4502) | |
2002-06-28
| ||
12:18 | [d3f178e9ea] part of check-in [96515b813e] Additional test cases added. The following bug fixed: A segfault was occurring if a VIEW consisted of a join with a USING clause. (CVS 651) (check-in: [96515b813e] user: drh branch: trunk, size: 4269) | |
2002-05-08
| ||
21:30 | [b9851e9142] part of check-in [5f22d21571] Fix for ticket #34: VIEWs ignore their ORDER BY clause. (CVS 556) (check-in: [5f22d21571] user: drh branch: trunk, size: 3450) | |
11:54 | [1536b58161] part of check-in [08f27cb368] Fix for tickets #32 and #33: Generate the names of the result set early, before doing the flattening optimization or evaluating subqueries. Otherwise, the result set column names are generated incorrectly or after they are needed. (CVS 553) (check-in: [08f27cb368] user: drh branch: trunk, size: 3229) | |
2002-03-03
| ||
23:06 | [4a8a9cf59b] part of check-in [8130776230] More bugs fixed for views. (CVS 416) (check-in: [8130776230] user: drh branch: trunk, size: 2672) | |
18:59 | [56802271e3] part of check-in [6121e5ab93] VIEWs are bound to tables when they are used, not when they are first entered. This works around the problem of what to do if a table is deleted that a view refers to. (CVS 415) (check-in: [6121e5ab93] user: drh branch: trunk, size: 1996) | |
2002-02-27
| ||
01:47 | Added: [4619ebede5] part of check-in [668ef6380e] Bug fixes in the VIEW implementation. (CVS 396) (check-in: [668ef6380e] user: drh branch: trunk, size: 1763) | |