/ History for src/treeview.c
Login

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

History for src/treeview.c

2020-06-09
11:59
[4b929921] part of check-in [b5711b4e] Improved tree-view debugging output for aggregate functions. (check-in: [b5711b4e] user: drh branch: trunk, size: 24407)
2020-06-07
12:26
[3515c2aa] part of check-in [a7c5c739] Improvements to the treeview debugging display. (check-in: [a7c5c739] user: drh branch: early-winfunc-rewrite-dev, size: 24573)
2020-06-06
18:45
[3d267d39] part of check-in [15babdcb] Clearly distinguish between window functions and scalar functions in the debugging TreeView output. (check-in: [15babdcb] user: drh branch: early-winfunc-rewrite-dev, size: 24499)
2020-06-05
04:01
[c5691bab] part of check-in [c1c8937a] 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: [c1c8937a] user: drh branch: trunk, size: 24333)
2020-05-24
02:05
[9df54af6] part of check-in [f7e5a68a] Improvements to parse-tree tracing logic. No changes in deliverable code. (check-in: [f7e5a68a] user: drh branch: trunk, size: 24331)
2020-03-21
22:03
[82c6391a] part of check-in [8a5c539b] Enhance the treeview system to show the SrcList_item.colUsed field for FROM clause elements. (check-in: [8a5c539b] user: drh branch: trunk, size: 24257)
2020-03-10
19:24
[f78cd9cd] part of check-in [5f60b527] Enhanced detection logic for preventing the use of static schema expressions by code generating routines. (check-in: [5f60b527] user: drh branch: trunk, size: 24231)
2020-01-08
22:22
[438c1000] part of check-in [da434dc1] Block edgy functions used in DEFAULT constraints. (check-in: [da434dc1] user: drh branch: new-security-options, size: 24062)
14:39
[f51bdcac] part of check-in [fe7472fd] In the TreeView debugging output, show a "DDL" mark on SrcList and Expr nodes that derive from a non-TEMP schema. (check-in: [fe7472fd] user: drh branch: new-security-options, size: 24021)
2020-01-03
00:28
[2f712c82] part of check-in [cd56872a] Fix a problem in sqlite3TreeViewBareExprList() in which the routine was not interpreting the new ExprList format correctly. (check-in: [cd56872a] user: drh branch: trunk, size: 23921)
2019-12-31
14:49
[74d4fb2b] part of check-in [39d55579] Merge recent enhancements from trunk. (check-in: [39d55579] user: drh branch: two-size-lookaside, size: 23867)
2019-12-20
20:08
[7a8097cf] part of check-in [64154ac4] Debugging enhancment: Show the Expr.y.pTab pointer on TK_COLUMN nodes of an expression tree in the treeview. (check-in: [64154ac4] user: drh branch: trunk, size: 23865)
2019-12-12
20:22
[b36e832d] part of check-in [d3783357] 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: [d3783357] user: drh branch: two-size-lookaside, size: 23825)
2019-11-14
23:08
[dd7efb04] part of check-in [ba27012d] Backport support for the sqlite3_hard_heap_limit64() interface and the hard_heap_limit pragma to the 3.30 branch. (check-in: [ba27012d] user: drh branch: branch-3.30, size: 23028)
15:21
[41d928f0] part of check-in [b8a631fd] Merge recent enhancements from trunk. (check-in: [b8a631fd] user: drh branch: hard-heap-limit, size: 23823)
2019-11-13
16:50
[5b1ecf70] part of check-in [fa2416f6] Fix the sqlite3TreeView() output to consistently use a colon and not a comma after the table number in the AST dumps. (check-in: [fa2416f6] user: drh branch: trunk, size: 23807)
2019-10-31
12:30
[1de448df] part of check-in [aceeaf9e] Enhance the TreeView logic to show information about Expr.op2 for FUNCTION and COLUMN nodes. (check-in: [aceeaf9e] user: drh branch: trunk, size: 23807)
2019-10-23
18:09
[19e660b3] part of check-in [978b2d20] 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: [978b2d20] user: drh branch: trunk, size: 23079)
2019-09-28
16:14
[fddeb413] part of check-in [1a3671c7] Improvements to a comment. No code changes. (check-in: [1a3671c7] user: drh branch: trunk, size: 23012)
2019-09-10
17:51
[dd92b189] part of check-in [a9780462] Enhance treeview to show SOFT-COLLATE for TK_COLLATE operators that omit the EP_Collate flag. (check-in: [a9780462] user: drh branch: trunk, size: 22898)
2019-08-20
17:14
[72b78e17] part of check-in [9b14eb77] Bring the hard-heap-limit branch up-to-date with trunk. (check-in: [9b14eb77] user: drh branch: hard-heap-limit, size: 22589)
2019-08-15
20:04
[fc8c6c0a] part of check-in [fc745845] Provide the SQLITE_DIRECTONLY flag for app-defined functions that prohibits the use of those functions within triggers or views. (check-in: [fc745845] user: drh branch: directonly, size: 22573)
2019-08-05
18:01
[06e65db6] part of check-in [a29f2a7d] 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: [a29f2a7d] user: drh branch: trunk, size: 22555)
2019-08-03
16:17
[e1faf913] part of check-in [fd598e47] In the ".wheretrace 0x100" debugging mode, show the structure of the main parameters to sqlite3WhereBegin() calls. (check-in: [fd598e47] user: drh branch: trunk, size: 22412)
2019-06-12
13:49
[cf03f9f6] part of check-in [5c6146b5] Handle expressions like "expr IS TRUE COLLATE xyz" in the same way as "expr IS TRUE". Fix for [4d01eda8115b10d1]. (check-in: [5c6146b5] user: dan branch: trunk, size: 22251)
2019-04-25
18:15
[47762086] part of check-in [b0ccef61] Add the sqlite3_hard_heap_limit64() interface and the corresponding "PRAGMA hard_heap_limit=N" command. (check-in: [b0ccef61] user: drh branch: hard-heap-limit, size: 22243)
2019-03-28
13:53
[56724725] part of check-in [1ae70ad2] Show the pointer address for Window objects in the TreeView display. (check-in: [1ae70ad2] user: drh branch: trunk, size: 22227)
13:35
[3885029c] part of check-in [d6a07433] 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: [d6a07433] user: drh branch: trunk, size: 22205)
13:03
[f41d6a62] part of check-in [ec2f207d] Improved TreeView display of Window objects. Change the Window.eType field to Window.eFrmType to avoid confusion with other "eType" values. (check-in: [ec2f207d] user: drh branch: trunk, size: 22131)
2018-12-27
00:30
[c6ff90da] part of check-in [11d4682d] In the treeview debugging output, provide additional details for the Table object associated with each FROM clause term. (check-in: [11d4682d] user: drh branch: trunk, size: 20870)
2018-11-08
22:53
[7b12ac05] part of check-in [8c74065f] 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: [8c74065f] user: drh branch: trunk, size: 20816)
2018-09-20
19:02
[0ef7dc77] part of check-in [ad130bb8] 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: [ad130bb8] user: drh branch: trunk, size: 20760)
2018-09-19
14:54
[1bc9fc4e] part of check-in [147c61a6] 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: [147c61a6] user: drh branch: expr-simplify, size: 20927)
2018-09-18
21:35
[b6f45983] part of check-in [8849a463] 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: [8849a463] user: drh branch: expr-simplify, size: 20830)
2018-07-27
16:57
[e7a7f905] part of check-in [82c67efb] 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: [82c67efb] user: drh branch: propagate-const-opt, size: 20758)
2018-07-23
18:53
[26c56740] part of check-in [8607b84a] Fix typo of 'SQLITE_OMIT_WINDOWFUNC'. (check-in: [8607b84a] user: mistachkin branch: trunk, size: 20648)
2018-07-10
19:48
[462346b8] part of check-in [a7cdc5bc] 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: [a7cdc5bc] user: drh branch: trunk, size: 20648)
06:32
[2d0fa21b] part of check-in [a2c0e1be] Enhance the TreeView mechanism so that it shows the window function data structures as part of the abstract syntax tree. (check-in: [a2c0e1be] user: drh branch: trunk, size: 20929)
2018-05-09
13:46
[2c5c4bc0] part of check-in [87f261f0] 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: [87f261f0] user: drh branch: trunk, size: 17599)
2018-05-03
19:47
[06dd506b] part of check-in [956fef36] Optimizations to the new EQP framework. (check-in: [956fef36] user: drh branch: rework-EQP, size: 17553)
2018-05-01
01:18
[c66a74b9] part of check-in [2a75e631] The ".selecttrace 0x4000" command causes the AST to be output to stdout as a table with four columns. (check-in: [2a75e631] user: drh branch: ast-trace-demo, size: 33599)
2018-04-23
20:04
[6cea286c] part of check-in [a6356817] Fix a formatting issue in the TreeView output for bare expression lists. (check-in: [a6356817] user: drh branch: trunk, size: 17570)
17:43
[538eda2c] part of check-in [ca34c2dd] 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: [ca34c2dd] user: drh branch: trunk, size: 17403)
2018-03-19
16:06
[14d5d125] part of check-in [30704d2a] Improved ".selecttrace" output formatting. No changes in non-debug code. (check-in: [30704d2a] user: drh branch: trunk, size: 17386)
2018-02-27
14:49
[e0d62678] part of check-in [6445519e] Clean up comments and variable names prior to merge. (check-in: [6445519e] user: drh branch: is-true-operator, size: 17082)
2018-02-26
21:26
[b2470f16] part of check-in [57508518] Code simplifications. New test cases. (check-in: [57508518] user: drh branch: is-true-operator, size: 17086)
19:03
[bdc8ca85] part of check-in [7e38305e] Enhance TreeView so that it can display the new IS TRUE expression trees. (check-in: [7e38305e] user: drh branch: is-true-operator, size: 17180)
2017-12-22
19:53
[eae35972] part of check-in [5efd854f] In the sqlite3TreeViewExprList() routine, show the "AS" alias name for each expression in the list, if it exists. (check-in: [5efd854f] user: drh branch: trunk, size: 16554)
2017-11-14
23:48
[08a83195] part of check-in [3925facd] 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: [3925facd] user: drh branch: trunk, size: 16378)
2017-07-10
13:24
[2ee4a5da] part of check-in [dc857a96] For sqlite3TreeView() debugging output, show the Expr.flags field on scalar subqueries. (check-in: [dc857a96] user: drh branch: trunk, size: 16356)
2017-04-14
19:03
[6cf8d7fe] part of check-in [3a5860d8] 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: [3a5860d8] user: drh branch: left-join-view, size: 16281)
14:02
[b92d57c1] part of check-in [5159cb8f] 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: [5159cb8f] user: drh branch: trunk, size: 16117)
2017-03-13
17:37
[84d0ac73] part of check-in [9034cf7e] Fix the sqlite3TreeViewSelect() routine so that it works with a null pointer to the Select object. (check-in: [9034cf7e] user: drh branch: trunk, size: 15922)
2016-11-04
11:23
[4e44ade3] part of check-in [97354093] Add an assert() to silence a coverity false-positive. (check-in: [97354093] user: drh branch: trunk, size: 15845)
2016-09-02
23:56
[f51b75a2] part of check-in [c7271fbd] Merge recent changes from trunk. (check-in: [c7271fbd] user: drh branch: rowvalue, size: 15820)
2016-08-27
20:21
[70329ef4] part of check-in [a07269f2] Fix typos in comments. No changes to running code. (check-in: [a07269f2] user: drh branch: trunk, size: 15369)
2016-08-18
18:09
[15406fc4] part of check-in [3b27a5da] Display SELECT_COLUMN expressions in the .wheretrace debugging output. (check-in: [3b27a5da] user: drh branch: rowvalue, size: 15824)
17:55
[0ec6101f] part of check-in [157347e2] Display VECTOR expressions in .wheretrace and .selecttrace debugging output. (check-in: [157347e2] user: drh branch: rowvalue, size: 15642)
2016-05-27
12:30
[c56d6ddb] part of check-in [71087c12] Improvements to WHERE-clause debug tracing. Show TK_MATCH expressions and show more details on WhereTerm traces. (check-in: [71087c12] user: drh branch: trunk, size: 15373)
2016-02-27
21:16
[e4b41a37] part of check-in [d8c94a46] Eliminate the need for the Column.zDflt (using Column.pDflt instead) to reduce the amount of memory needed to hold the schema. (check-in: [d8c94a46] user: drh branch: trunk, size: 15164)
2016-02-25
16:04
[c5252824] part of check-in [d491745c] Take the LIMIT clause into account when estimating the cost of sorting. (check-in: [d491745c] user: drh branch: planner-improvements, size: 15011)
2016-01-30
12:50
[dc39ccf0] part of check-in [0bdb41c4] 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: [0bdb41c4] user: drh branch: trunk, size: 14971)
2015-11-07
15:19
[78842e90] part of check-in [2040d88e] 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: [2040d88e] user: drh branch: infinite-with-loop-bug, size: 15004)
2015-09-05
22:36
[154f0acc] part of check-in [7ab0b258] 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: [7ab0b258] user: drh branch: trunk, size: 13676)
2015-08-26
14:01
[46036cbb] part of check-in [c2f3bbad] Evaluate expressions only once when the same expression is used in both the result set and in the ORDER BY clause. (check-in: [c2f3bbad] user: drh branch: trunk, size: 13823)
11:34
[24950c6a] part of check-in [65a89187] 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: [65a89187] user: drh branch: trunk, size: 13620)
2015-08-19
17:11
[c15df007] part of check-in [40e12cfe] A list of arguments following a table name translates into equality constraints against hidden columns in that table. (check-in: [40e12cfe] user: drh branch: table-valued-functions, size: 13380)
15:20
[fda5cfc4] part of check-in [b9193761] 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: [b9193761] user: drh branch: table-valued-functions, size: 13262)
2015-06-18
14:09
[c84b1a8e] part of check-in [a84d1004] Show the values of Expr.flag in the AST of ".selecttrace" (check-in: [a84d1004] user: drh branch: trunk, size: 13259)
2015-06-08
15:08
[84aa2d2e] part of check-in [c32ce54c] Factor out the TreeView parse tree printing module into a separate file. (check-in: [c32ce54c] user: drh branch: view-optimization, size: 13072) Added