Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/view.test
|
2019-08-15
| ||
| 21:27 | 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. file: [10ea5430] check-in: [61b4bccd] user: drh branch: trunk, size: 18663 | |
|
2019-08-07
| ||
| 19:57 | Remove use of the affinity() function from view.test, as it is only available in SQLITE_DEBUG builds. file: [c1e64ff5] check-in: [7f2246a1] user: dan branch: trunk, size: 18403 | |
|
2019-08-06
| ||
| 21:16 | 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]. file: [3a4e64be] check-in: [17b3d221] user: dan branch: trunk, size: 18441 | |
|
2019-08-05
| ||
| 20:45 | Add test cases to this branch. file: [f0326e78] check-in: [f37317d8] user: dan branch: tkt-61c853-A, size: 18076 | |
|
2019-05-22
| ||
| 23:12 | New test case for check-in [74ef97bf51dd531a] that takes the fix in the previous check-in into account. file: [40d54c9d] check-in: [cb1d0652] user: drh branch: trunk, size: 17024 | |
|
2019-05-03
| ||
| 17:19 | Fix a problem where self-joins on views that are aggregate queries may return the wrong result. file: [ee9262ce] check-in: [74ef97bf] user: dan branch: trunk, size: 16841 | |
|
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: [71e1bf4c] check-in: [221f3f57] user: dan branch: trunk, size: 16426 | |
|
2018-08-21
| ||
| 17:03 | Fix a test case that was failing for SQLITE_ENABLE_STAT4 builds. file: [226fb71e] check-in: [1e29fd43] user: dan branch: trunk, size: 16373 | |
|
2018-07-20
| ||
| 20:56 | When dropping a view, skip trying to delete from 'sqlite_stat*'. file: [42b97dcd] check-in: [2f5be3a2] user: mistachkin branch: dropViewNoStat, size: 16279 | |
|
2016-04-05
| ||
| 20:59 | Carry table column types through into VIEW definitions, where possible. file: [765802c7] check-in: [fb555c3c] user: drh branch: trunk, size: 15744 | |
|
2015-10-11
| ||
| 20:39 | Detect and report circularly defined views even if the views have the columns defined in the CREATE VIEW statement. file: [f6c3a39e] check-in: [9ab9c8c6] user: drh branch: trunk, size: 15210 | |
|
2015-09-26
| ||
| 11:15 | Fix a memory leak that can occur following a syntax error in CREATE VIEW. file: [0d8935e6] check-in: [f4704035] user: drh branch: trunk, size: 15023 | |
|
2015-09-25
| ||
| 13:42 | 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. file: [bfdec45a] check-in: [6e4ac0be] user: drh branch: trunk, size: 14889 | |
|
2015-08-24
| ||
| 17:42 | Enhance the CREATE VIEW syntax so that the names of columns of the view can be specified after the view name. file: [3930ae94] check-in: [d794b34d] user: drh branch: trunk, size: 14511 | |
|
2015-08-03
| ||
| 13:44 | 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. file: [f44014f7] check-in: [70b57daf] user: drh branch: trunk, size: 14234 | |
|
2014-03-04
| ||
| 21:19 | 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. file: [f311691d] check-in: [554501f1] user: drh branch: trunk, size: 14252 | |
|
2013-03-04
| ||
| 17:41 | Omit a test that uses the progress handler callback from view.test if OMIT_PROGRESS_HANDLER is defined. file: [40576302] check-in: [f40552ad] user: dan branch: trunk, size: 13979 | |
|
2013-01-28
| ||
| 19:00 | 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]. file: [977eb3fa] check-in: [c2462a95] user: drh branch: trunk, size: 13944 | |
|
2011-08-02
| ||
| 00:57 | 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. file: [b182a67e] check-in: [9007586f] user: mistachkin branch: winopen-retry-logic, size: 12477 | |
|
2008-12-14
| ||
| 14:45 | Add the example from #3359 to the test suite. (CVS 6027) file: [45f51820] check-in: [84f8417c] user: danielk1977 branch: trunk, size: 12484 | |
|
2008-08-21
| ||
| 14:54 | Make sure "rowid" columns in views are named correctly. Ticket #3308. (CVS 5580) file: [7fba28a4] check-in: [8593218c] user: drh branch: trunk, size: 12237 | |
|
2008-07-10
| ||
| 00:32 | 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) file: [57999065] check-in: [636cd723] user: drh branch: trunk, size: 11606 | |
|
2008-06-30
| ||
| 18:12 | Call the query flattener while processing the parent query. Previously, it was called while processing the sub-queries. (CVS 5330) file: [041ccaf4] check-in: [6fcb3bff] user: danielk1977 branch: trunk, size: 11471 | |
|
2008-01-25
| ||
| 15:04 | Error messages says "no such view" instead of "no such table" when trying to DROP a VIEW that does not exist. (CVS 4750) file: [4864e384] check-in: [50815a82] user: drh branch: trunk, size: 11037 | |
|
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: [7e15fa1b] check-in: [07c00fff] user: danielk1977 branch: trunk, size: 10763 | |
|
2006-09-11
| ||
| 23:45 | Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899. (CVS 3406) file: [852bd410] check-in: [e4fe736c] user: drh branch: trunk, size: 10718 | |
|
2006-06-11
| ||
| 23:41 | Progress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211) file: [16e2774f] check-in: [898ec36b] user: drh branch: trunk, size: 10358 | |
|
2006-03-26
| ||
| 01:21 | 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) file: [b0aeb933] check-in: [80cda9f7] user: drh branch: trunk, size: 10350 | |
|
2006-03-09
| ||
| 17:28 | Correct names returned from a query against a view. Ticket #1709, #1688, #1711. (CVS 3128) file: [ef328f28] check-in: [36830faf] user: drh branch: trunk, size: 10350 | |
|
2006-02-05
| ||
| 18:55 | Detect circularly defined views and issue an error message. Ticket #1658. (CVS 3055) file: [7606d165] check-in: [f5341529] user: drh branch: trunk, size: 10107 | |
|
2006-01-14
| ||
| 08:02 | Fixes for OMIT_SUBQUERY builds: Disable where clause OR->IN optimization. Include EXISTS keyword (for new CREATE TABLE syntax). Test file fixes. (CVS 2943) file: [354bd0ce] check-in: [8e79a0c2] user: danielk1977 branch: trunk, size: 9948 | |
|
2005-08-20
| ||
| 03:03 | Increased test coverage. Some malloc tests now fail though this is believed to be an instrumentation problem not a real error. (CVS 2604) file: [ce0f0ad3] check-in: [f786f37a] user: drh branch: trunk, size: 9907 | |
|
2005-07-08
| ||
| 17:13 | Change the name of the OpenTemp opcode to OpenVirtual which is more descriptive of what it does. (CVS 2541) file: [3c79232a] check-in: [3bb9ce5f] user: drh branch: trunk, size: 9676 | |
|
2005-06-06
| ||
| 15:32 | Do not allow parameters in VIEW definitions. Ticket #1270. (CVS 2492) file: [e2455311] check-in: [0d46289f] user: drh branch: trunk, size: 9664 | |
|
2005-01-30
| ||
| 11:11 | Respect collation sequences in views. Ticket #1088. (CVS 2291) file: [306cc434] check-in: [9843c0dd] user: danielk1977 branch: trunk, size: 9476 | |
|
2005-01-29
| ||
| 08:32 | Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) file: [a34c5488] check-in: [b1b50f31] user: danielk1977 branch: trunk, size: 8991 | |
|
2005-01-21
| ||
| 04:25 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) file: [5aac4c79] check-in: [d4e19efc] user: danielk1977 branch: trunk, size: 8992 | |
|
2004-11-22
| ||
| 13:35 | Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) file: [3f96df86] check-in: [007be591] user: danielk1977 branch: trunk, size: 8902 | |
| 08:43 | Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) file: [a68bee7f] check-in: [711e8d76] user: danielk1977 branch: trunk, size: 8856 | |
|
2004-11-03
| ||
| 16:27 | Update tests to work even if some features of the library are disabled. (CVS 2050) file: [2ec8fd4f] check-in: [b11fc9b3] user: drh branch: trunk, size: 8727 | |
|
2004-07-20
| ||
| 00:20 | Correct handling of views on tables with quoted column names. Ticket #756. (CVS 1827) file: [ac151928] check-in: [ef0d5ebe] user: drh branch: version_2, size: 8638 | |
| 00:20 | Correct handling of views on tables with quoted column names. Ticket #756. (CVS 1826) file: [ca5c2969] check-in: [8ac5a8ad] user: drh branch: trunk, size: 8639 | |
|
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: [b42c9849] check-in: [d705d051] user: drh branch: trunk, size: 8246 | |
|
2003-05-31
| ||
| 16:21 | 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) file: [1ee12c6f] check-in: [7202d4f1] user: drh branch: trunk, size: 8240 | |
|
2003-05-02
| ||
| 16:04 | 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) file: [408fa464] check-in: [ad57693e] user: drh branch: trunk, size: 8235 | |
| 14:32 | 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) file: [8b3b0b30] check-in: [be7aed20] user: drh branch: trunk, size: 7305 | |
|
2003-04-24
| ||
| 01:45 | Fix some issues with INSTEAD OF triggers. (CVS 930) file: [d356f445] check-in: [206b1739] user: drh branch: trunk, size: 7110 | |
|
2002-12-03
| ||
| 02:22 | Honor ORDER BY clauses in VIEWs. Ticket #193. (CVS 792) file: [c64fa39e] check-in: [dbf78932] user: drh branch: trunk, size: 7080 | |
|
2002-08-25
| ||
| 19:20 | 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) file: [76d3fe15] check-in: [c602603e] user: drh branch: trunk, size: 6142 | |
| 18:29 | Fix the memory leak introduced by check-in (725). (CVS 726) file: [ed18ceba] check-in: [b957dafc] user: drh branch: trunk, size: 6091 | |
|
2002-08-24
| ||
| 18:24 | 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) file: [e4d60d68] check-in: [22d8726e] user: drh branch: trunk, size: 6090 | |
|
2002-07-16
| ||
| 02:05 | Fix for ticket #100: Correctly handle ON and USING clauses of JOINs within a VIEW. (CVS 679) file: [3afca084] check-in: [93710f7e] user: drh branch: trunk, size: 5491 | |
|
2002-07-02
| ||
| 13:05 | 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) file: [28700c1f] check-in: [85793a4f] user: drh branch: trunk, size: 4502 | |
|
2002-06-28
| ||
| 12:18 | 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) file: [d3f178e9] check-in: [96515b81] user: drh branch: trunk, size: 4269 | |
|
2002-05-08
| ||
| 21:30 | Fix for ticket #34: VIEWs ignore their ORDER BY clause. (CVS 556) file: [b9851e91] check-in: [5f22d215] user: drh branch: trunk, size: 3450 | |
| 11:54 | 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) file: [1536b581] check-in: [08f27cb3] user: drh branch: trunk, size: 3229 | |
|
2002-03-03
| ||
| 23:06 | More bugs fixed for views. (CVS 416) file: [4a8a9cf5] check-in: [81307762] user: drh branch: trunk, size: 2672 | |
| 18:59 | 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) file: [56802271] check-in: [6121e5ab] user: drh branch: trunk, size: 1996 | |
|
2002-02-27
| ||
| 01:47 | Bug fixes in the VIEW implementation. (CVS 396) file: [4619ebed] check-in: [668ef638] user: drh branch: trunk, size: 1763 Added | |