Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for src/treeview.c
|
2025-01-28
| ||
| 12:50 | [d85ce76e6d] part of check-in [a4625bb995] Simplify the IdList object to remove unnecessary fields. Performance increases by about 0.8%. (check-in: [a4625bb995] user: drh branch: trunk, size: 41822) | |
|
2025-01-02
| ||
| 21:23 | [d1f3003cb2] part of check-in [2b16d6947c] Improve the treeview output for CteUse objects. (check-in: [2b16d6947c] user: drh branch: trunk, size: 42340) | |
| 18:43 | [e5848f30a6] part of check-in [4a2d65cdcd] Improvements to the display of subqueries in the FROM clause for treeview output. (Debug and analysis code only - does not affect production builds.) (check-in: [4a2d65cdcd] user: drh branch: trunk, size: 42191) | |
|
2024-12-02
| ||
| 13:29 | [9213925613] part of check-in [7aef0b9305] Slighly less confusing output from treeview during debugging. (check-in: [7aef0b9305] user: drh branch: trunk, size: 42309) | |
|
2024-11-20
| ||
| 14:19 | [4eeb155abe] part of check-in [c77a4a42f2] Provide the sqlite3ShowWhereTerm() interface callable interactively from a debugger, when compiling with SQLITE_DEBUG. (check-in: [c77a4a42f2] user: drh branch: trunk, size: 42307) | |
|
2024-10-05
| ||
| 15:51 | [ebcf0398c5] part of check-in [a92bb48a48] Merge latest trunk changes into this branch. (check-in: [a92bb48a48] user: dan branch: lateral-join, size: 42327) | |
|
2024-08-21
| ||
| 10:32 | [88aa39b754] part of check-in [0a835d18d9] Improvements to treetrace output for subqueries. Debug code only. (check-in: [0a835d18d9] user: drh branch: trunk, size: 42247) | |
|
2024-08-19
| ||
| 22:48 | [e98dbc8068] part of check-in [8ff5dda844] Refactor the SrcItem object so that information about subqueries is stored in a separately allocated Subquery object. This reduces the memory requirements for SrcItem and makes the code run faster. It also provides an expansion path for subquery processing that does not burden simple queries. The current checking mostly works, but there are still issues that need to be tracked down and fixed. (check-in: [8ff5dda844] user: drh branch: srcitem-opt, size: 41888) | |
|
2024-08-17
| ||
| 23:23 | [a337ab329f] part of check-in [9f5aeef3cb] Give unique names to fields in the SrcItem object, to facilitate analysis of how those fields are used using "grep". (check-in: [9f5aeef3cb] user: drh branch: srcitem-opt, size: 41887) | |
|
2024-07-21
| ||
| 23:36 | [4ea0cb81db] part of check-in [9182e99952] Merge debugging output fixes from trunk into the lateral-join branch. (check-in: [9182e99952] user: drh branch: lateral-join, size: 41949) | |
| 23:34 | [774838df4e] part of check-in [b6aed8bcb0] Fixes to TreeView debugging output for VALUES clauses. (check-in: [b6aed8bcb0] user: drh branch: trunk, size: 41869) | |
|
2024-07-20
| ||
| 01:19 | [324f285fde] part of check-in [3c045a96bc] Experimental implementation of LATERAL JOIN. (check-in: [3c045a96bc] user: drh branch: lateral-join, size: 41996) | |
|
2024-06-14
| ||
| 18:33 | [e4f0c5ca87] part of check-in [e87966cf63] Improvement to treeview.c: Show the DESC and BIGNULL flags when printing out ExprList objects. (check-in: [e87966cf63] user: drh branch: recursive-cte-orderby-fix, size: 41916) | |
|
2024-05-23
| ||
| 15:05 | [4b0e9131c3] part of check-in [1e5385ffc3] Merge various enhancements that were being held on a branch until after the 3.46.0 release. (1) Allow arbitrary expressions in the second argument to the RAISE() function. (2) Performance optimization to the OP_OpenRead and OP_OpenWrite bytecode operators. (3) Allow FTS5 tables to be dropped even if the associated tokenizer is not available. (4) Performance optimizations in FTS5. (5) Generate better bytecode to improve performance of ONEROW scans. (check-in: [1e5385ffc3] user: drh branch: trunk, size: 41654) | |
|
2024-05-18
| ||
| 20:00 | [38eefdc85d] part of check-in [922731ce98] Fix the definition of sqlite3_vtab_distinct() such that return codes 2 and 3 mean that all rows must be distinct over "colUsed" which is a superset of "aOrderBy". Also, disallow return codes 2 and 3 if the rowid of the virtual table is accessed. (check-in: [922731ce98] user: drh branch: vtab-distinct-fix, size: 41624) | |
|
2024-05-08
| ||
| 17:42 | [5538cc0e88] part of check-in [003e1c8c27] Allow arbitrary expressions as the second argument to RAISE(). (check-in: [003e1c8c27] user: drh branch: enhanced-raise, size: 41592) | |
|
2024-04-26
| ||
| 11:32 | [4f9ba6c1c7] part of check-in [38f1e5ce4e] Fix the TreeView display of a LIMIT clause on a compound query. Debugging code only - not part of production builds. (check-in: [38f1e5ce4e] user: drh branch: trunk, size: 41562) | |
|
2024-04-21
| ||
| 23:35 | [a8aa3086c8] part of check-in [5560df2726] Fix an indentation problem in debugging routine sqlite3ShowSrcList(). No changes to production code. (check-in: [5560df2726] user: drh branch: trunk, size: 41568) | |
|
2023-11-10
| ||
| 20:46 | [c6fc972683] part of check-in [aca31e49d1] Additional debugging information on the tree-dump of the BETWEEN operator. (check-in: [aca31e49d1] user: drh branch: trunk, size: 41483) | |
|
2023-10-20
| ||
| 15:47 | [62fafcd31e] part of check-in [56142a7816] Simplifications and optimizations to the Expr object duplication logic. The 5x multiplier crutch from [f371e4c0f8ea73ae] is still present. More fixes are still needed. (check-in: [56142a7816] user: drh branch: trunk, size: 41474) | |
|
2023-10-19
| ||
| 19:08 | [bd8ec60f37] part of check-in [d2c6b82c34] In the TreeView logic (used for debugging only) do not show unnecessary fields of the Window object when a function has a FILTER. (check-in: [d2c6b82c34] user: drh branch: trunk, size: 41366) | |
|
2023-10-18
| ||
| 13:18 | [6c44150013] part of check-in [3a98ff24bf] Enhance the parser so that it can accept an ORDER BY clause on a function invocation. For this incremental check-in, the ORDER BY clause is currently ignored. (check-in: [3a98ff24bf] user: drh branch: agg-orderby, size: 41257) | |
|
2023-05-17
| ||
| 00:26 | [1d52fbc4e9] part of check-in [8504fe812c] Fix two assert() statements that failed to take into account the likely() built-in function. This does not impact production code. (check-in: [8504fe812c] user: drh branch: trunk, size: 41029) | |
|
2023-01-28
| ||
| 21:01 | [fccf3b8c51] part of check-in [3d05dddd0b] Show more details about the SrcItem.fg field in tree-trace output. (check-in: [3d05dddd0b] user: drh branch: trunk, size: 41000) | |
|
2022-11-26
| ||
| 20:48 | [29b1dc7e0f] part of check-in [b8076f4dc5] Show which AggInfo.aCol an Expr node represents in the tree trace debugging logic. Does not affect production builds. (check-in: [b8076f4dc5] user: drh branch: trunk, size: 40544) | |
|
2022-10-21
| ||
| 20:12 | [bb143b907d] part of check-in [5dd7858820] Begin transitioning the fixed-length (64-bit) bitmap used to keep track of the subset of columns of a table that are used by a query into a more general structure that can work with wide tables. Experimental. (check-in: [5dd7858820] user: drh branch: column-set, size: 40457) | |
|
2022-07-11
| ||
| 19:29 | [9591c77f71] part of check-in [9931bb202e] Fix harmless compiler warnings. (check-in: [9931bb202e] user: drh branch: branch-3.39, size: 40415) | |
| 18:26 | [07787f67cd] part of check-in [4d6f907712] Fix harmless compiler warnings about unused debugging functions in treeview.c. (check-in: [4d6f907712] user: drh branch: trunk, size: 40426) | |
|
2022-07-06
| ||
| 23:50 | [4d8eda2423] part of check-in [61e2094afb] Fix harmless compiler warnings seen with MSVC. (check-in: [61e2094afb] user: mistachkin branch: trunk, size: 40267) | |
|
2022-06-22
| ||
| 14:43 | [0bd550f597] part of check-in [edbe24e7fc] Allow more line with on the debugging output for SrcItem elements in the parse tree. This affects debugging builds only and is a no-op for production builds. (check-in: [edbe24e7fc] user: drh branch: trunk, size: 40256) | |
|
2022-06-08
| ||
| 15:30 | [c48bbb4b04] part of check-in [c585d6a467] Add restriction (29) to the query flattener - do not allow flattening that would leave both EP_InnerON and EP_OuterON constraints on the same join term. (check-in: [c585d6a467] user: drh branch: right-join-query-flattener, size: 40254) | |
|
2022-05-13
| ||
| 16:38 | [73facf395c] part of check-in [6f741d6cfb] Redefine the acccess rules for the Expr.w union so that the Expr.w.iJoin member is accessible on either EP_OuterON or EP_InnerON. (check-in: [6f741d6cfb] user: drh branch: trunk, size: 40138) | |
| 14:52 | [ae4a3c115c] part of check-in [1ffea07ff9] Improved names for flags on the Expr object: EP_FromJoin becames EP_OuterON and EP_InnerJoin becomes EP_InnerON. (check-in: [1ffea07ff9] user: drh branch: trunk, size: 40110) | |
|
2022-05-02
| ||
| 20:49 | [4153f2f044] part of check-in [5341d4bbe9] Organize the various flag bits of the ExprList_item object into a substructure so that the whole lot can be copied all at once. Faster and smaller code. (check-in: [5341d4bbe9] user: drh branch: right-join, size: 40015) | |
| 20:14 | [e33a0fa956] part of check-in [e01f4c05c2] Merge trunk fixes into the right-join branch. (check-in: [e01f4c05c2] user: drh branch: right-join, size: 40003) | |
| 19:59 | [c91eee716a] part of check-in [6f9c0b07aa] Name resolution and "*" wildcard expansion for parenthesized FROM clauses seems to work the same as PG. The code is chaos, however, and needs some cleanup. (check-in: [6f9c0b07aa] user: drh branch: right-join, size: 39979) | |
| 15:23 | [5e81880b7c] part of check-in [daff607003] Fix a harmless compiler warning in sqlite3TreeViewWinFunc() (a routine that does not even appear in release builds). (check-in: [daff607003] user: drh branch: trunk, size: 39857) | |
| 15:10 | [5c2a8d3bc6] part of check-in [afbcf075c1] Merge the latest trunk fixes and enhancements into the right-join branch. (check-in: [afbcf075c1] user: drh branch: right-join, size: 39905) | |
|
2022-04-30
| ||
| 19:55 | [a47e424639] part of check-in [b250c218b4] Defensive code in sqlite3TreeViewWindow() to fix a compiler warning. (check-in: [b250c218b4] user: drh branch: trunk, size: 39833) | |
| 00:05 | [7dd99cf420] part of check-in [aec1e4cd59] Enhance the TreeView debugging output for Expr with opcode TK_IN so as to show the RHS table and the subroutine address. (check-in: [aec1e4cd59] user: drh branch: trunk, size: 39809) | |
|
2022-04-29
| ||
| 17:45 | [9b4fcabab8] part of check-in [7b4a0d0fa1] With TreeView, only show the table columns for a SrcItem if the data source is a subquery rather than a persistent table. (check-in: [7b4a0d0fa1] user: drh branch: trunk, size: 39408) | |
| 17:13 | [330f396050] part of check-in [293afa8111] Multiple enhancements to the TreeView output for SrcItem, cherrypicked from the right-join experimental branch. (check-in: [293afa8111] user: drh branch: trunk, size: 39433) | |
| 17:03 | [06fbe7bcd8] part of check-in [9cba3ce577] Show the USING clause as part of the tree-view display of SrcItem. (check-in: [9cba3ce577] user: drh branch: right-join, size: 39474) | |
|
2022-04-28
| ||
| 18:17 | [d9c5192f2c] part of check-in [3aafccb5c3] In treeview.c, show the columns of the table associated with each SrcItem. (check-in: [3aafccb5c3] user: drh branch: right-join, size: 39252) | |
|
2022-04-22
| ||
| 23:18 | [2fb6681614] part of check-in [c3a427575f] Add the ability to access the USING columns of the right or left tables of an OUTER JOIN even if the OUTER JOIN is in parentheses. Prototype code only. (check-in: [c3a427575f] user: drh branch: right-join-colnames, size: 37700) | |
| 16:15 | [396c21e21c] part of check-in [8d631a6b9e] Honor the MATERIALIZED keyword on a common table expression by not flattening the CTE into an outer query. (check-in: [8d631a6b9e] user: drh branch: trunk, size: 37628) | |
|
2022-04-21
| ||
| 14:08 | [c834e0c903] part of check-in [e611e8e62c] Ensure correct fg.isNestedFrom values even on crazy parses. (check-in: [e611e8e62c] user: drh branch: right-join, size: 37485) | |
| 12:11 | [4b68539a80] part of check-in [6b326b3bcf] Further attempts to get name resolution to work correctly with parenthisized FROM clauses. Work-in-progress. Lots of crashes and wrong answers. (check-in: [6b326b3bcf] user: drh branch: right-join-paren, size: 37486) | |
|
2022-04-20
| ||
| 15:07 | [f304faa8b5] part of check-in [0da2232624] Improved tracking of nested SELECT objects used to implement parenthensized FROM terms. (check-in: [0da2232624] user: drh branch: right-join, size: 37413) | |
| 12:15 | [26c904f27a] part of check-in [c1d4286177] Also show the ENAME_SPAN value in sqlite3TreeViewExprList(), if there is one. (check-in: [c1d4286177] user: drh branch: right-join, size: 37342) | |
| 12:14 | [5271fe3267] part of check-in [eb3f883b45] Improved TreeView output for ExprList: Show the ENAME_TAB value, if there is one. (check-in: [eb3f883b45] user: drh branch: right-join, size: 37396) | |
|
2022-04-15
| ||
| 15:47 | [d5fae332a5] part of check-in [40f3c95871] Enhance the IdList object to exist in a single memory allocation (rather than a separate allocate for the base object and the array of IDs). Also permit an IdList object to store an Expr pointer together with each name. (check-in: [40f3c95871] user: drh branch: right-join, size: 37077) | |
|
2022-04-13
| ||
| 18:32 | [cf275af590] part of check-in [185d2720e7] Make the sqlite3TreeViewSrcList() routine a no-op if called with a NULL SrcList object. (check-in: [185d2720e7] user: drh branch: right-join, size: 36581) | |
|
2022-04-11
| ||
| 11:48 | [e143d3def2] part of check-in [29927926eb] Merge the Expr.w.iJoin name change from trunk into the right-join branch. (check-in: [29927926eb] user: drh branch: right-join, size: 36557) | |
| 11:25 | [67fc7d8960] part of check-in [e8c00442d2] Rename the Expr.w.iRightJoinTable to just Expr.w.iJoin, so that the words "RightJoin" in the former name do not lead readers to believe that this has something to do with RIGHT JOINs in particular. (check-in: [e8c00442d2] user: drh branch: trunk, size: 36246) | |
| 00:54 | [7e50db6ae3] part of check-in [21eb44919f] Show the JT_LTORJ flag in TreeView debugging output. (check-in: [21eb44919f] user: drh branch: right-join, size: 36566) | |
|
2022-04-08
| ||
| 19:20 | [d1401c129c] part of check-in [415abd6731] Preliminary code to support RIGHT JOIN. Everything seems to work, except that the code to compute the unmatched rows for the RIGHT JOIN has not yet been added, so the result of a RIGHT JOIN is currently the same as an INNER JOIN. (check-in: [415abd6731] user: drh branch: right-join, size: 36478) | |
|
2022-04-07
| ||
| 10:11 | [80a3d70bbc] part of check-in [61095b5bcb] Fix harmless compiler warnings. (check-in: [61095b5bcb] user: drh branch: trunk, size: 36255) | |
|
2022-04-06
| ||
| 18:30 | [433434c230] part of check-in [84c239a071] Improvements to the display of AST for DML statements. (check-in: [84c239a071] user: drh branch: trunk, size: 36279) | |
| 15:41 | [4ed907fc34] part of check-in [b0939d6f4d] Attempt to show triggers in the TreeView output from DELETE, INSERT, and UPDATE statements. (check-in: [b0939d6f4d] user: drh branch: trunk, size: 36138) | |
| 12:25 | [9f867920ef] part of check-in [bc33168cf1] Add the sqlite3Show() family of debugging interfaces under SQLITE_DEBUG. No changes to deliverable builds. Rename SQLITE_ENABLE_SELECTTRACE to SQLITE_ENABLE_TREETRACE in ctime.c. (check-in: [bc33168cf1] user: drh branch: trunk, size: 33987) | |
| 10:37 | [7e95d0dcf5] part of check-in [fbd288ff3d] Add additional tree display routines for DELETE and UPDATE. No changes to deliverable code. (check-in: [fbd288ff3d] user: drh branch: trunk, size: 32822) | |
| 00:29 | [46d5a45387] part of check-in [f308412203] Add new diagnostic "sqlite3TreeView" routines for IdList, Upsert, and for INSERT statements. This is all debugging code. There are no changes to release builds. (check-in: [f308412203] user: drh branch: trunk, size: 29543) | |
|
2022-03-10
| ||
| 16:01 | [3fac35b083] part of check-in [d9475ebcde] Refactor Window.pFunc into Window.pWFunc to disambiguate from other uses of the variable or field named "pFunc". (check-in: [d9475ebcde] user: drh branch: trunk, size: 25934) | |
|
2022-03-08
| ||
| 13:59 | [90e133ebe9] part of check-in [5e30c6ea70] Fix compiler warnings. (check-in: [5e30c6ea70] user: drh branch: trunk, size: 25932) | |
|
2022-02-05
| ||
| 21:49 | [a84b57d15e] part of check-in [32a3a53b62] Record the position of many identifiers in the parse using the new Expr.w.iOfst field. This is done with the idea of providing offset results for sqlite3_error_offset() for a more kinds of errors, though that part is not yet implemented. (check-in: [32a3a53b62] user: drh branch: trunk, size: 25922) | |
|
2021-10-07
| ||
| 20:46 | [9dfdb7ff7f] part of check-in [87e2f5eb43] Protect access to the Expr.y union using nearby assert()s and branches. (check-in: [87e2f5eb43] user: drh branch: trunk, size: 25920) | |
| 17:43 | [e80a6126f8] part of check-in [8eaa1d4a98] Protect all accesses to the Expr.x union using nearby assert()s and branches. (check-in: [8eaa1d4a98] user: drh branch: trunk, size: 25882) | |
| 13:40 | [f8eaf6e9a2] part of check-in [9af863f065] Protect all accesses to the FuncDef.u and Expr.u unions using nearby assert()s or branches. (check-in: [9af863f065] user: drh branch: trunk, size: 25567) | |
|
2021-07-22
| ||
| 16:07 | [43f88d0fd1] part of check-in [1f67960440] One of the optimizations of check-in [de9c86c9e4cdb34f] does not work for terms originating in the ON/USING clause, as demonstrated by forum post 6cf3bb457c3f4685. This check-in disables that optimization for ON/USING terms. Also improve the TreeView display for the resulting "true"/"false" nodes to show that they originate from the ON/USING clause. Add a testcase() to the other optimization to show that it can still be used for ON/USING terms. (check-in: [1f67960440] user: drh branch: trunk, size: 25027) | |
|
2021-07-05
| ||
| 02:40 | [ce7a3da38c] part of check-in [2547cfe38f] Improved rebustness in sqlite3ExprListDup() when it contains a vector assignment from an UPDATE where the initial term is omitted. This can happen during a UNION ALL query flattening while processing a virtual table update in which the first term of the vector is repeated. Forum post 16ca0e9f32. (check-in: [2547cfe38f] user: drh branch: trunk, size: 25013) | |
| 01:11 | [f34b02f379] part of check-in [026f08d4cf] Ensure that TK_SELECT_COLUMN Expr nodes always have their iTable field set to to the number of columns in the vector. This is not strictly necessary. It just simplifies the state description and make the code easier to reason about. (check-in: [026f08d4cf] user: drh branch: trunk, size: 24943) | |
|
2021-07-04
| ||
| 22:33 | [6c1dbbc114] part of check-in [e87fdb6514] Enhance the treeview debugging mechanism so that it correctly deals with TK_ROW expression nodes. (check-in: [e87fdb6514] user: drh branch: trunk, size: 24901) | |
|
2021-06-23
| ||
| 11:39 | [306674a0ff] part of check-in [72e09b6c9b] Show CROSS JOINs in the TreeView debuggingn output. (check-in: [72e09b6c9b] user: drh branch: trunk, size: 24653) | |
|
2021-05-24
| ||
| 11:35 | [21449a944d] part of check-in [dd56fbe0cf] Fix the TreeView module so that it works with the TK_ERROR exprssion. Also fix an assert() that was failing due to the recent TK_ERROR addition. (check-in: [dd56fbe0cf] user: drh branch: trunk, size: 24560) | |
|
2021-04-12
| ||
| 12:58 | [e483aeedf6] part of check-in [28ecb3810b] Fix the display of SrcList in the sqlite3TreeView debugging routines. (check-in: [28ecb3810b] user: drh branch: trunk, size: 24371) | |
|
2021-03-19
| ||
| 19:44 | [70f57a2b77] part of check-in [1fadd30525] Further simplification of the EQP output. Only show "SUBQUERY n" if the subquery is anonymous. (check-in: [1fadd30525] user: drh branch: eqp-improvements, size: 24326) | |
|
2021-02-21
| ||
| 23:44 | [c6260e1fa5] part of check-in [ba59159fbe] Materialize any CTE that is used more than once. (check-in: [ba59159fbe] user: drh branch: as-materialize-redux, size: 24593) | |
| 21:04 | [04bf47d19b] part of check-in [bfd5bf2c73] Rename the "struct SrcList_item" object to the more succinct "SrcItem". This is a symbolic change only. The logic is unmodified. (check-in: [bfd5bf2c73] user: drh branch: trunk, size: 24395) | |
|
2021-02-16
| ||
| 19:29 | [734a65babc] part of check-in [30bb18b450] Remove unnecessarily complexity from sqlite3WithReleaseByParse(). Improved TreeView output for the enhanced CTE structures. This code still does not work 100%. I'm saving my place in order to (maybe) come back to it later. (check-in: [30bb18b450] user: drh branch: as-materialize, size: 24743) | |
|
2020-06-09
| ||
| 11:59 | [4b92992176] part of check-in [b5711b4eea] Improved tree-view debugging output for aggregate functions. (check-in: [b5711b4eea] user: drh branch: trunk, size: 24407) | |
|
2020-06-07
| ||
| 12:26 | [3515c2aa9d] part of check-in [a7c5c73992] Improvements to the treeview debugging display. (check-in: [a7c5c73992] user: drh branch: early-winfunc-rewrite-dev, size: 24573) | |
|
2020-06-06
| ||
| 18:45 | [3d267d39dc] part of check-in [15babdcb91] Clearly distinguish between window functions and scalar functions in the debugging TreeView output. (check-in: [15babdcb91] user: drh branch: early-winfunc-rewrite-dev, size: 24499) | |
|
2020-06-05
| ||
| 04:01 | [c5691babcd] part of check-in [c1c8937a30] In the debugging treeview output, change the name of "SELECT-expr" expression nodes to be "subquery-expr", so as to not confuse them with actual SELECT nodes. (check-in: [c1c8937a30] user: drh branch: trunk, size: 24333) | |
|
2020-05-24
| ||
| 02:05 | [9df54af6e5] part of check-in [f7e5a68a7e] Improvements to parse-tree tracing logic. No changes in deliverable code. (check-in: [f7e5a68a7e] user: drh branch: trunk, size: 24331) | |
|
2020-03-21
| ||
| 22:03 | [82c6391a3b] part of check-in [8a5c539b77] Enhance the treeview system to show the SrcList_item.colUsed field for FROM clause elements. (check-in: [8a5c539b77] user: drh branch: trunk, size: 24257) | |
|
2020-03-10
| ||
| 19:24 | [f78cd9cd79] part of check-in [5f60b527b9] Enhanced detection logic for preventing the use of static schema expressions by code generating routines. (check-in: [5f60b527b9] user: drh branch: trunk, size: 24231) | |
|
2020-01-08
| ||
| 22:22 | [438c100058] part of check-in [da434dc149] Block edgy functions used in DEFAULT constraints. (check-in: [da434dc149] user: drh branch: new-security-options, size: 24062) | |
| 14:39 | [f51bdcac26] part of check-in [fe7472fd2a] In the TreeView debugging output, show a "DDL" mark on SrcList and Expr nodes that derive from a non-TEMP schema. (check-in: [fe7472fd2a] user: drh branch: new-security-options, size: 24021) | |
|
2020-01-03
| ||
| 00:28 | [2f712c8217] part of check-in [cd56872afb] Fix a problem in sqlite3TreeViewBareExprList() in which the routine was not interpreting the new ExprList format correctly. (check-in: [cd56872afb] user: drh branch: trunk, size: 23921) | |
|
2019-12-31
| ||
| 14:49 | [74d4fb2b6a] part of check-in [39d5557937] Merge recent enhancements from trunk. (check-in: [39d5557937] user: drh branch: two-size-lookaside, size: 23867) | |
|
2019-12-20
| ||
| 20:08 | [7a8097cff1] part of check-in [64154ac450] Debugging enhancment: Show the Expr.y.pTab pointer on TK_COLUMN nodes of an expression tree in the treeview. (check-in: [64154ac450] user: drh branch: trunk, size: 23865) | |
|
2019-12-12
| ||
| 20:22 | [b36e832d4d] part of check-in [d3783357f8] Change the name of the Expr.a.zName field to zEName, so that it has a name that is distinct from other fields and variables and is hence easier to grep for. (check-in: [d3783357f8] user: drh branch: two-size-lookaside, size: 23825) | |
|
2019-11-14
| ||
| 23:08 | [dd7efb04c2] part of check-in [ba27012d43] Backport support for the sqlite3_hard_heap_limit64() interface and the hard_heap_limit pragma to the 3.30 branch. (check-in: [ba27012d43] user: drh branch: branch-3.30, size: 23028) | |
| 15:21 | [41d928f04d] part of check-in [b8a631fd30] Merge recent enhancements from trunk. (check-in: [b8a631fd30] user: drh branch: hard-heap-limit, size: 23823) | |
|
2019-11-13
| ||
| 16:50 | [5b1ecf70a6] part of check-in [fa2416f623] Fix the sqlite3TreeView() output to consistently use a colon and not a comma after the table number in the AST dumps. (check-in: [fa2416f623] user: drh branch: trunk, size: 23807) | |
|
2019-10-31
| ||
| 12:30 | [1de448df04] part of check-in [aceeaf9e28] Enhance the TreeView logic to show information about Expr.op2 for FUNCTION and COLUMN nodes. (check-in: [aceeaf9e28] user: drh branch: trunk, size: 23807) | |
|
2019-10-23
| ||
| 18:09 | [19e660b3a4] part of check-in [978b2d20cf] When a vector comparison appears in the WHERE clause and the constraint side has a COLLATE clause on the first term of the vector, be sure to honor that COLLATE clause. Ticket [135c9da7513e5a97]. (check-in: [978b2d20cf] user: drh branch: trunk, size: 23079) | |
|
2019-09-28
| ||
| 16:14 | [fddeb41315] part of check-in [1a3671c700] Improvements to a comment. No code changes. (check-in: [1a3671c700] user: drh branch: trunk, size: 23012) | |
|
2019-09-10
| ||
| 17:51 | [dd92b189d8] part of check-in [a97804620a] Enhance treeview to show SOFT-COLLATE for TK_COLLATE operators that omit the EP_Collate flag. (check-in: [a97804620a] user: drh branch: trunk, size: 22898) | |
|
2019-08-20
| ||
| 17:14 | [72b78e17fd] part of check-in [9b14eb7754] Bring the hard-heap-limit branch up-to-date with trunk. (check-in: [9b14eb7754] user: drh branch: hard-heap-limit, size: 22589) | |
|
2019-08-15
| ||
| 20:04 | [fc8c6c0a8a] part of check-in [fc745845d8] Provide the SQLITE_DIRECTONLY flag for app-defined functions that prohibits the use of those functions within triggers or views. (check-in: [fc745845d8] user: drh branch: directonly, size: 22573) | |
|
2019-08-05
| ||
| 18:01 | [06e65db6ff] part of check-in [a29f2a7d07] Refactor field Expr.affinity into Expr.affExpr to avoid confusion with other fields and variables named "affinity" and display affExpr it in sqlite3TreeViewExpr() output. (check-in: [a29f2a7d07] user: drh branch: trunk, size: 22555) | |
|
2019-08-03
| ||
| 16:17 | [e1faf913bb] part of check-in [fd598e475d] In the ".wheretrace 0x100" debugging mode, show the structure of the main parameters to sqlite3WhereBegin() calls. (check-in: [fd598e475d] user: drh branch: trunk, size: 22412) | |
|
2019-06-12
| ||
| 13:49 | [cf03f9f6ef] part of check-in [5c6146b56a] Handle expressions like "expr IS TRUE COLLATE xyz" in the same way as "expr IS TRUE". Fix for [4d01eda8115b10d1]. (check-in: [5c6146b56a] user: dan branch: trunk, size: 22251) | |
|
2019-04-25
| ||
| 18:15 | [47762086f3] part of check-in [b0ccef61a7] Add the sqlite3_hard_heap_limit64() interface and the corresponding "PRAGMA hard_heap_limit=N" command. (check-in: [b0ccef61a7] user: drh branch: hard-heap-limit, size: 22243) | |
|
2019-03-28
| ||
| 13:53 | [56724725c6] part of check-in [1ae70ad2ff] Show the pointer address for Window objects in the TreeView display. (check-in: [1ae70ad2ff] user: drh branch: trunk, size: 22227) | |
| 13:35 | [3885029c82] part of check-in [d6a0743342] More improvements to TreeView output for Window objects: (1) Show when the frame-spec is implied rather than explicit. (2) Move the FILTER clause out from within the OVER clause, making it a sibling of the OVER clause, to match syntax. (check-in: [d6a0743342] user: drh branch: trunk, size: 22205) | |
| 13:03 | [f41d6a62ff] part of check-in [ec2f207ded] Improved TreeView display of Window objects. Change the Window.eType field to Window.eFrmType to avoid confusion with other "eType" values. (check-in: [ec2f207ded] user: drh branch: trunk, size: 22131) | |
|
2018-12-27
| ||
| 00:30 | [c6ff90da4c] part of check-in [11d4682d2e] In the treeview debugging output, provide additional details for the Table object associated with each FROM clause term. (check-in: [11d4682d2e] user: drh branch: trunk, size: 20870) | |
|
2018-11-08
| ||
| 22:53 | [7b12ac059d] part of check-in [8c74065f00] In the treeview.c module, break out the display of SrcList into a separate subroutine, so that it can be invoked while debugging. (check-in: [8c74065f00] user: drh branch: trunk, size: 20816) | |
|
2018-09-20
| ||
| 19:02 | [0ef7dc77d6] part of check-in [ad130bb86e] Combine the Expr.pTab and Expr.pWin fields into a union named "y". Add a new EP_WinFunc property that is only true if Expr.y.pWin is a valid pointer. This reduces the size of the Expr object by 8 bytes, reduces the overall amount of code, and shaves over 1 million cycles off of the speed test. (check-in: [ad130bb86e] user: drh branch: trunk, size: 20760) | |
|
2018-09-19
| ||
| 14:54 | [1bc9fc4ebd] part of check-in [147c61a6d4] Reduce the size of Expr from 80 to 72 bytes moving the pRight field inside the "x" union. This is an incremental check-in that still has issues. (check-in: [147c61a6d4] user: drh branch: expr-simplify, size: 20927) | |
|
2018-09-18
| ||
| 21:35 | [b6f459831c] part of check-in [8849a463d6] In the Expr object, the Expr.eX field determines what value is stored in the Expr.x union. This mostly works, but there are issues identified by valgrind. (check-in: [8849a463d6] user: drh branch: expr-simplify, size: 20830) | |
|
2018-07-27
| ||
| 16:57 | [e7a7f90552] part of check-in [82c67efb72] Constant propagation is now restricted to just the WHERE clause. The mechanism is changed to take affinity and collation into account. This seems to give correct answers. But the search for constant propagation costs 4 million cycles in the speed test. (check-in: [82c67efb72] user: drh branch: propagate-const-opt, size: 20758) | |
|
2018-07-23
| ||
| 18:53 | [26c5674083] part of check-in [8607b84a5c] Fix typo of 'SQLITE_OMIT_WINDOWFUNC'. (check-in: [8607b84a5c] user: mistachkin branch: trunk, size: 20648) | |
|
2018-07-10
| ||
| 19:48 | [462346b82a] part of check-in [a7cdc5bc85] Identify Select objects within a single statement using small sequential integers rather than "0x%p". This is more readable and yields the same result on successive runs. (check-in: [a7cdc5bc85] user: drh branch: trunk, size: 20648) | |
| 06:32 | [2d0fa21bef] part of check-in [a2c0e1bec0] Enhance the TreeView mechanism so that it shows the window function data structures as part of the abstract syntax tree. (check-in: [a2c0e1bec0] user: drh branch: trunk, size: 20929) | |
|
2018-05-09
| ||
| 13:46 | [2c5c4bc0a4] part of check-in [87f261f0cb] Make the internal dynamic string interface available to extensions using the new sqlite3_str object and its associated methods. This is mostly just a renaming of internal objects and methods to use external names, through there are a few small wrapper functions. (check-in: [87f261f0cb] user: drh branch: trunk, size: 17599) | |
|
2018-05-03
| ||
| 19:47 | [06dd506b1d] part of check-in [956fef361a] Optimizations to the new EQP framework. (check-in: [956fef361a] user: drh branch: rework-EQP, size: 17553) | |
|
2018-05-01
| ||
| 01:18 | [c66a74b9cd] part of check-in [2a75e631ee] The ".selecttrace 0x4000" command causes the AST to be output to stdout as a table with four columns. (check-in: [2a75e631ee] user: drh branch: ast-trace-demo, size: 33599) | |
|
2018-04-23
| ||
| 20:04 | [6cea286ca9] part of check-in [a635681781] Fix a formatting issue in the TreeView output for bare expression lists. (check-in: [a635681781] user: drh branch: trunk, size: 17570) | |
| 17:43 | [538eda2ca0] part of check-in [ca34c2dd20] The ".selecttrace 0x2000" command causes just the top-level parse tree to be displayed, after all transformations, and showing the EQP iSelectId at each level. (check-in: [ca34c2dd20] user: drh branch: trunk, size: 17403) | |
|
2018-03-19
| ||
| 16:06 | [14d5d12547] part of check-in [30704d2a52] Improved ".selecttrace" output formatting. No changes in non-debug code. (check-in: [30704d2a52] user: drh branch: trunk, size: 17386) | |
|
2018-02-27
| ||
| 14:49 | [e0d6267831] part of check-in [6445519e91] Clean up comments and variable names prior to merge. (check-in: [6445519e91] user: drh branch: is-true-operator, size: 17082) | |
|
2018-02-26
| ||
| 21:26 | [b2470f1606] part of check-in [57508518ef] Code simplifications. New test cases. (check-in: [57508518ef] user: drh branch: is-true-operator, size: 17086) | |
| 19:03 | [bdc8ca85b6] part of check-in [7e38305e6f] Enhance TreeView so that it can display the new IS TRUE expression trees. (check-in: [7e38305e6f] user: drh branch: is-true-operator, size: 17180) | |
|
2017-12-22
| ||
| 19:53 | [eae35972ff] part of check-in [5efd854fe2] In the sqlite3TreeViewExprList() routine, show the "AS" alias name for each expression in the list, if it exists. (check-in: [5efd854fe2] user: drh branch: trunk, size: 16554) | |
|
2017-11-14
| ||
| 23:48 | [08a83195de] part of check-in [3925facd94] In the parse tree, combine LIMIT and OFFSET into a single expression rooted on a TK_LIMIT node, for a small code size reduction and performance increase, and a reduction in code complexity. (check-in: [3925facd94] user: drh branch: trunk, size: 16378) | |
|
2017-07-10
| ||
| 13:24 | [2ee4a5dada] part of check-in [dc857a96b0] For sqlite3TreeView() debugging output, show the Expr.flags field on scalar subqueries. (check-in: [dc857a96b0] user: drh branch: trunk, size: 16356) | |
|
2017-04-14
| ||
| 19:03 | [6cf8d7fe9e] part of check-in [3a5860d86f] Add the TK_IF_NULL_ROW opcode to deal with non-NULL result columns in the result set of a view or subquery on the RHS of a LEFT JOIN that gets flattened. (check-in: [3a5860d86f] user: drh branch: left-join-view, size: 16281) | |
| 14:02 | [b92d57c1ac] part of check-in [5159cb8f2b] Enhance the sqlite3TreeView() display for Expr objects so that it shows the iRightJoinTable value for Expr nodes that have the EP_FromJoin property. (check-in: [5159cb8f2b] user: drh branch: trunk, size: 16117) | |
|
2017-03-13
| ||
| 17:37 | [84d0ac737e] part of check-in [9034cf7efc] Fix the sqlite3TreeViewSelect() routine so that it works with a null pointer to the Select object. (check-in: [9034cf7efc] user: drh branch: trunk, size: 15922) | |
|
2016-11-04
| ||
| 11:23 | [4e44ade3bf] part of check-in [97354093bc] Add an assert() to silence a coverity false-positive. (check-in: [97354093bc] user: drh branch: trunk, size: 15845) | |
|
2016-09-02
| ||
| 23:56 | [f51b75a28b] part of check-in [c7271fbde1] Merge recent changes from trunk. (check-in: [c7271fbde1] user: drh branch: rowvalue, size: 15820) | |
|
2016-08-27
| ||
| 20:21 | [70329ef46b] part of check-in [a07269f2a0] Fix typos in comments. No changes to running code. (check-in: [a07269f2a0] user: drh branch: trunk, size: 15369) | |
|
2016-08-18
| ||
| 18:09 | [15406fc49b] part of check-in [3b27a5da10] Display SELECT_COLUMN expressions in the .wheretrace debugging output. (check-in: [3b27a5da10] user: drh branch: rowvalue, size: 15824) | |
| 17:55 | [0ec6101f55] part of check-in [157347e258] Display VECTOR expressions in .wheretrace and .selecttrace debugging output. (check-in: [157347e258] user: drh branch: rowvalue, size: 15642) | |
|
2016-05-27
| ||
| 12:30 | [c56d6ddbed] part of check-in [71087c12bc] Improvements to WHERE-clause debug tracing. Show TK_MATCH expressions and show more details on WhereTerm traces. (check-in: [71087c12bc] user: drh branch: trunk, size: 15373) | |
|
2016-02-27
| ||
| 21:16 | [e4b41a3753] part of check-in [d8c94a46df] Eliminate the need for the Column.zDflt (using Column.pDflt instead) to reduce the amount of memory needed to hold the schema. (check-in: [d8c94a46df] user: drh branch: trunk, size: 15164) | |
|
2016-02-25
| ||
| 16:04 | [c525282442] part of check-in [d491745cab] Take the LIMIT clause into account when estimating the cost of sorting. (check-in: [d491745cab] user: drh branch: planner-improvements, size: 15011) | |
|
2016-01-30
| ||
| 12:50 | [dc39ccf04e] part of check-in [0bdb41c45a] Simplification and size reduction to the printf logic. Remove the bFlags parameter from sqlite3VXPrintf() and sqlite3XPrintf(). Use sqlite3XPrintf() instead of sqlite3_snprintf() for rendering P4 values in EXPLAIN output. (check-in: [0bdb41c45a] user: drh branch: trunk, size: 14971) | |
|
2015-11-07
| ||
| 15:19 | [78842e90c1] part of check-in [2040d88e87] Enhance TreeView to show WITH clauses. Add an assert to detect the infinite loop behavior when certain kinds of errors occur on a nested WITH clause. (check-in: [2040d88e87] user: drh branch: infinite-with-loop-bug, size: 15004) | |
|
2015-09-05
| ||
| 22:36 | [154f0acc62] part of check-in [7ab0b258ea] Omit all use of Expr nodes for TK_AS, as those nodes no longer served a useful purpose and in fact interferred with the query planner. (check-in: [7ab0b258ea] user: drh branch: trunk, size: 13676) | |
|
2015-08-26
| ||
| 14:01 | [46036cbbce] part of check-in [c2f3bbad77] Evaluate expressions only once when the same expression is used in both the result set and in the ORDER BY clause. (check-in: [c2f3bbad77] user: drh branch: trunk, size: 13823) | |
| 11:34 | [24950c6a79] part of check-in [65a8918776] Update the TreeView output for compound SELECT statements so that all entries are shown vertically aligned rather than each successive entry being indented. (check-in: [65a8918776] user: drh branch: trunk, size: 13620) | |
|
2015-08-19
| ||
| 17:11 | [c15df00728] part of check-in [40e12cfe4c] A list of arguments following a table name translates into equality constraints against hidden columns in that table. (check-in: [40e12cfe4c] user: drh branch: table-valued-functions, size: 13380) | |
| 15:20 | [fda5cfc463] part of check-in [b919376147] Minor refactor of the SrcList object so that it is able to hold the argument list to a table-valued-function in the FROM clause. (check-in: [b919376147] user: drh branch: table-valued-functions, size: 13262) | |
|
2015-06-18
| ||
| 14:09 | [c84b1a8ebc] part of check-in [a84d1004cb] Show the values of Expr.flag in the AST of ".selecttrace" (check-in: [a84d1004cb] user: drh branch: trunk, size: 13259) | |
|
2015-06-08
| ||
| 15:08 | Added: [84aa2d2ed2] part of check-in [c32ce54ca4] Factor out the TreeView parse tree printing module into a separate file. (check-in: [c32ce54ca4] user: drh branch: view-optimization, size: 13072) | |