/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of src/treeview.c

2019-09-28
16:14
Improvements to a comment. No code changes. file: [fddeb413] check-in: [1a3671c7] user: drh branch: trunk, size: 23012
2019-09-10
17:51
Enhance treeview to show SOFT-COLLATE for TK_COLLATE operators that omit the EP_Collate flag. file: [dd92b189] check-in: [a9780462] user: drh branch: trunk, size: 22898
2019-08-20
17:14
Bring the hard-heap-limit branch up-to-date with trunk. file: [72b78e17] check-in: [9b14eb77] user: drh branch: hard-heap-limit, size: 22589
2019-08-15
20:04
Provide the SQLITE_DIRECTONLY flag for app-defined functions that prohibits the use of those functions within triggers or views. file: [fc8c6c0a] check-in: [fc745845] user: drh branch: directonly, size: 22573
2019-08-05
18:01
Refactor field Expr.affinity into Expr.affExpr to avoid confusion with other fields and variables named "affinity" and display affExpr it in sqlite3TreeViewExpr() output. file: [06e65db6] check-in: [a29f2a7d] user: drh branch: trunk, size: 22555
2019-08-03
16:17
In the ".wheretrace 0x100" debugging mode, show the structure of the main parameters to sqlite3WhereBegin() calls. file: [e1faf913] check-in: [fd598e47] user: drh branch: trunk, size: 22412
2019-06-12
13:49
Handle expressions like "expr IS TRUE COLLATE xyz" in the same way as "expr IS TRUE". Fix for [4d01eda8115b10d1]. file: [cf03f9f6] check-in: [5c6146b5] user: dan branch: trunk, size: 22251
2019-04-25
18:15
Add the sqlite3_hard_heap_limit64() interface and the corresponding "PRAGMA hard_heap_limit=N" command. file: [47762086] check-in: [b0ccef61] user: drh branch: hard-heap-limit, size: 22243
2019-03-28
13:53
Show the pointer address for Window objects in the TreeView display. file: [56724725] check-in: [1ae70ad2] user: drh branch: trunk, size: 22227
13:35
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. file: [3885029c] check-in: [d6a07433] user: drh branch: trunk, size: 22205
13:03
Improved TreeView display of Window objects. Change the Window.eType field to Window.eFrmType to avoid confusion with other "eType" values. file: [f41d6a62] check-in: [ec2f207d] user: drh branch: trunk, size: 22131
2018-12-27
00:30
In the treeview debugging output, provide additional details for the Table object associated with each FROM clause term. file: [c6ff90da] check-in: [11d4682d] user: drh branch: trunk, size: 20870
2018-11-08
22:53
In the treeview.c module, break out the display of SrcList into a separate subroutine, so that it can be invoked while debugging. file: [7b12ac05] check-in: [8c74065f] user: drh branch: trunk, size: 20816
2018-09-20
19:02
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. file: [0ef7dc77] check-in: [ad130bb8] user: drh branch: trunk, size: 20760
2018-09-19
14:54
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. file: [1bc9fc4e] check-in: [147c61a6] user: drh branch: expr-simplify, size: 20927
2018-09-18
21:35
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. file: [b6f45983] check-in: [8849a463] user: drh branch: expr-simplify, size: 20830
2018-07-27
16:57
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. file: [e7a7f905] check-in: [82c67efb] user: drh branch: propagate-const-opt, size: 20758
2018-07-23
18:53
Fix typo of 'SQLITE_OMIT_WINDOWFUNC'. file: [26c56740] check-in: [8607b84a] user: mistachkin branch: trunk, size: 20648
2018-07-10
19:48
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. file: [462346b8] check-in: [a7cdc5bc] user: drh branch: trunk, size: 20648
06:32
Enhance the TreeView mechanism so that it shows the window function data structures as part of the abstract syntax tree. file: [2d0fa21b] check-in: [a2c0e1be] user: drh branch: trunk, size: 20929
2018-05-09
13:46
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. file: [2c5c4bc0] check-in: [87f261f0] user: drh branch: trunk, size: 17599
2018-05-03
19:47
Optimizations to the new EQP framework. file: [06dd506b] check-in: [956fef36] user: drh branch: rework-EQP, size: 17553
2018-05-01
01:18
The ".selecttrace 0x4000" command causes the AST to be output to stdout as a table with four columns. file: [c66a74b9] check-in: [2a75e631] user: drh branch: ast-trace-demo, size: 33599
2018-04-23
20:04
Fix a formatting issue in the TreeView output for bare expression lists. file: [6cea286c] check-in: [a6356817] user: drh branch: trunk, size: 17570
17:43
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. file: [538eda2c] check-in: [ca34c2dd] user: drh branch: trunk, size: 17403
2018-03-19
16:06
Improved ".selecttrace" output formatting. No changes in non-debug code. file: [14d5d125] check-in: [30704d2a] user: drh branch: trunk, size: 17386
2018-02-27
14:49
Clean up comments and variable names prior to merge. file: [e0d62678] check-in: [6445519e] user: drh branch: is-true-operator, size: 17082
2018-02-26
21:26
Code simplifications. New test cases. file: [b2470f16] check-in: [57508518] user: drh branch: is-true-operator, size: 17086
19:03
Enhance TreeView so that it can display the new IS TRUE expression trees. file: [bdc8ca85] check-in: [7e38305e] user: drh branch: is-true-operator, size: 17180
2017-12-22
19:53
In the sqlite3TreeViewExprList() routine, show the "AS" alias name for each expression in the list, if it exists. file: [eae35972] check-in: [5efd854f] user: drh branch: trunk, size: 16554
2017-11-14
23:48
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. file: [08a83195] check-in: [3925facd] user: drh branch: trunk, size: 16378
2017-07-10
13:24
For sqlite3TreeView() debugging output, show the Expr.flags field on scalar subqueries. file: [2ee4a5da] check-in: [dc857a96] user: drh branch: trunk, size: 16356
2017-04-14
19:03
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. file: [6cf8d7fe] check-in: [3a5860d8] user: drh branch: left-join-view, size: 16281
14:02
Enhance the sqlite3TreeView() display for Expr objects so that it shows the iRightJoinTable value for Expr nodes that have the EP_FromJoin property. file: [b92d57c1] check-in: [5159cb8f] user: drh branch: trunk, size: 16117
2017-03-13
17:37
Fix the sqlite3TreeViewSelect() routine so that it works with a null pointer to the Select object. file: [84d0ac73] check-in: [9034cf7e] user: drh branch: trunk, size: 15922
2016-11-04
11:23
Add an assert() to silence a coverity false-positive. file: [4e44ade3] check-in: [97354093] user: drh branch: trunk, size: 15845
2016-09-02
23:56
Merge recent changes from trunk. file: [f51b75a2] check-in: [c7271fbd] user: drh branch: rowvalue, size: 15820
2016-08-27
20:21
Fix typos in comments. No changes to running code. file: [70329ef4] check-in: [a07269f2] user: drh branch: trunk, size: 15369
2016-08-18
18:09
Display SELECT_COLUMN expressions in the .wheretrace debugging output. file: [15406fc4] check-in: [3b27a5da] user: drh branch: rowvalue, size: 15824
17:55
Display VECTOR expressions in .wheretrace and .selecttrace debugging output. file: [0ec6101f] check-in: [157347e2] user: drh branch: rowvalue, size: 15642
2016-05-27
12:30
Improvements to WHERE-clause debug tracing. Show TK_MATCH expressions and show more details on WhereTerm traces. file: [c56d6ddb] check-in: [71087c12] user: drh branch: trunk, size: 15373
2016-02-27
21:16
Eliminate the need for the Column.zDflt (using Column.pDflt instead) to reduce the amount of memory needed to hold the schema. file: [e4b41a37] check-in: [d8c94a46] user: drh branch: trunk, size: 15164
2016-02-25
16:04
Take the LIMIT clause into account when estimating the cost of sorting. file: [c5252824] check-in: [d491745c] user: drh branch: planner-improvements, size: 15011
2016-01-30
12:50
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. file: [dc39ccf0] check-in: [0bdb41c4] user: drh branch: trunk, size: 14971
2015-11-07
15:19
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. file: [78842e90] check-in: [2040d88e] user: drh branch: infinite-with-loop-bug, size: 15004
2015-09-05
22:36
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. file: [154f0acc] check-in: [7ab0b258] user: drh branch: trunk, size: 13676
2015-08-26
14:01
Evaluate expressions only once when the same expression is used in both the result set and in the ORDER BY clause. file: [46036cbb] check-in: [c2f3bbad] user: drh branch: trunk, size: 13823
11:34
Update the TreeView output for compound SELECT statements so that all entries are shown vertically aligned rather than each successive entry being indented. file: [24950c6a] check-in: [65a89187] user: drh branch: trunk, size: 13620
2015-08-19
17:11
A list of arguments following a table name translates into equality constraints against hidden columns in that table. file: [c15df007] check-in: [40e12cfe] user: drh branch: table-valued-functions, size: 13380
15:20
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. file: [fda5cfc4] check-in: [b9193761] user: drh branch: table-valued-functions, size: 13262
2015-06-18
14:09
Show the values of Expr.flag in the AST of ".selecttrace" file: [c84b1a8e] check-in: [a84d1004] user: drh branch: trunk, size: 13259
2015-06-08
15:08
Factor out the TreeView parse tree printing module into a separate file. file: [84aa2d2e] check-in: [c32ce54c] user: drh branch: view-optimization, size: 13072 Added