/ File History
Login

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