/ File History
Login

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

History of src/walker.c

2019-07-19
15:00
Refinement to check-in [348e7f193a963390] that avoids unreachable branches. file: [d5a94907] check-in: [bbfb2908] user: drh branch: trunk, size: 7006
11:20
Fix a problem with renaming tables when the schema contains WINDOW definitions with (illegal) non-numeric expressions as part of a PRECEDING or FOLLOWING clause. file: [20a8455c] check-in: [348e7f19] user: dan branch: trunk, size: 6669
10:31
Fix a faulty assert() in walker.c that could fail when processing an ALTER TABLE statement on a schema containing invalid table references that are part of a WINDOW definition. file: [8fb08ed5] check-in: [ee076c28] user: dan branch: trunk, size: 6537
2019-07-13
16:22
Rework the FILTER clause implementation to share more code with window functions. file: [ccbe57a6] check-in: [5dac8c38] user: dan branch: filter-clause, size: 6422
2019-07-10
20:16
Minor performance improvement in sqlite3ExprDeleteNN(). file: [588e7f5f] check-in: [bcc8b38a] user: dan branch: filter-clause, size: 6647
2019-07-02
11:56
Experimental implementation of FILTER clause for aggregate functions. file: [31844651] check-in: [1f1ae2d6] user: dan branch: filter-clause, size: 6408
2019-01-24
04:44
Remove an unreachable branch. file: [7607f1a6] check-in: [4c976f17] user: drh branch: trunk, size: 6285
2019-01-23
16:59
Fix problems with sub-selects in WINDOW definitions. Also rename-column operations when the column being renamed appears in a WINDOW definition that is part of a VIEW or TRIGGER. file: [ec63d6e2] check-in: [0387cb3a] user: dan branch: trunk, size: 6248
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: [fb94aadc] check-in: [ad130bb8] user: drh branch: trunk, size: 5693
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: [4ba292ca] check-in: [147c61a6] user: drh branch: expr-simplify, size: 5710
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: [b2d62136] check-in: [8849a463] user: drh branch: expr-simplify, size: 5793
2018-06-25
11:42
Fix another problem that could cause a crash when a window function was used in a view. file: [ba722577] check-in: [e954145a] user: dan branch: exp-window-functions, size: 5707
2018-06-23
19:29
Fix problems with using window-functions in correlated sub-queries. file: [14c43912] check-in: [3e23cfc8] user: dan branch: exp-window-functions, size: 5630
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: [da987a20] check-in: [3925facd] user: drh branch: trunk, size: 5333
2017-10-31
03:40
Remove unnecessary NEVER() and ALWAYS() conditionals. file: [d591e8a9] check-in: [1c80c75d] user: drh branch: trunk, size: 5396
2017-08-17
19:23
Small optimization in the Expr tree walker. file: [3ccfa863] check-in: [264a5e1b] user: drh branch: trunk, size: 5421
2017-07-07
13:59
Exploit the fact that Expr.pRight and Expr.x are never used at the same time for a small performance gain. file: [a7ca64ce] check-in: [aacbb9a4] user: drh branch: trunk, size: 5383
12:58
More efficient and compact implementation of walkExpr(). file: [3541df29] check-in: [115d4b83] user: drh branch: trunk, size: 5314
11:49
Very slightly smaller and faster sqlite3WalkSelect(). file: [8fa7438b] check-in: [9bc65635] user: drh branch: trunk, size: 5298
2017-05-29
14:26
Optimizations to the Walker object and its methods to make the code a little smaller and to help it run a little faster. file: [d46044e7] check-in: [6854a34e] user: drh branch: trunk, size: 5254
2017-03-07
12:18
Minor comment typo fixes. No changes to code. file: [b71a992b] check-in: [01cd9fb1] user: drh branch: trunk, size: 5309
2016-09-23
21:36
Add the EP_Leaf flag bit to the Expr.flags field to indicate Expr nodes that do not have substructure. Use that bit to avoid unnecessary recursion. file: [91a6df74] check-in: [8a6ea455] user: drh branch: trunk, size: 5305
2016-09-19
02:19
Small performance optimization in the expression walker. file: [83042807] check-in: [c6e6afb9] user: drh branch: trunk, size: 5286
2016-08-10
18:56
Performance enhancement in the expression walker. file: [2d2cc7fb] check-in: [ebccbd96] user: drh branch: trunk, size: 5265
2016-01-11
14:19
Performance optimization in sqlite3WalkExpr(). file: [0f142b5b] check-in: [2f8bd5fa] user: drh branch: trunk, size: 5273
2015-08-19
17:11
A list of arguments following a table name translates into equality constraints against hidden columns in that table. file: [2e14d17f] check-in: [40e12cfe] user: drh branch: table-valued-functions, size: 5185
2014-09-06
16:39
Fix typos in comments. No code changes. file: [c253b95b] check-in: [e62aab5e] user: peter.d.reid branch: trunk, size: 5053
2014-05-06
15:28
Experimental changes that reduce the size of Expr objects from 72 to 64 bytes each on x64 and from 48 to 44 bytes each on x32. file: [4a73ee39] check-in: [8ad0a123] user: drh branch: smaller-expr, size: 5146
2014-01-17
14:59
Fix some problems to do with WITH clauses and name resolution. file: [11edb74d] check-in: [6a549187] user: dan branch: common-table-expr, size: 5052
2013-09-12
16:50
Increase the number of bits available in Expr.flags. Other tweaks aimed at making expression processing more robust. file: [e9e593d5] check-in: [579a5125] user: drh branch: expr-tuning, size: 5175
2013-04-25
00:57
Make sure the affinity and datatype of sub-subqueries are initialized prior to subqueries as the latter relies on the former. file: [4fa43583] check-in: [39b4e6ff] user: drh branch: trunk, size: 5178
2012-08-23
19:46
Add test cases and fix bugs associated with the previous check-in enhancements to nested aggregate subquery processing. file: [3d75ba73] check-in: [00b1dc71] user: drh branch: nested-agg, size: 4630
2009-11-10
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. file: [3112bb3a] check-in: [f6c045f6] user: drh branch: trunk, size: 4552
2009-06-15
23:15
Additional updates to the symbol resolver and expression tree walker to facilitate test coverage. (CVS 6764) file: [1edca756] check-in: [a49c2d4b] user: drh branch: trunk, size: 4608
2009-05-28
01:00
Additional refinements to Expr handling. Restore compression of trigger expressions. Change Expr.zToken to Expr.u.zToken and added Expr.u.iValue. Remove an unnecessary ExprDup from CHECK constraint processing. And so forth. (CVS 6682) file: [ec4b9742] check-in: [4ac2bdfb] user: drh branch: trunk, size: 4624
2009-05-27
10:31
Simplifications to the Expr object: Remove Expr.span completely and convert Expr.token into a char* Expr.zToken. Also simplify the Token object by removing the Token.dyn and Token.quoted fields. (CVS 6681) file: [b28cc618] check-in: [7cb1c3ba] user: drh branch: trunk, size: 4624
2009-04-08
13:51
Minor refactoring of the expression-compaction logic for clarity of presentation. New comments added. The EXPRDUP_DISTINCTSPAN flag is removed as obsolete. (CVS 6470) file: [7cdf6322] check-in: [44ded2ea] user: drh branch: trunk, size: 4689
12:21
Do not attempt to walk a TokenOnly or SpanOnly expression tree node. Ticket #3791. (CVS 6469) file: [b32028f4] check-in: [8362d883] user: drh branch: trunk, size: 4673
2009-02-19
14:39
Changes to reduce the heap space consumed by triggers, views and tables in the in-memory representation of the schema. Also to reduce the space used by prepared statements slightly. (CVS 6305) file: [42bd3f00] check-in: [d9f6ffbc] user: danielk1977 branch: trunk, size: 4473
2008-08-20
16:35
Refactor the name resolution procedures in the code generator. (CVS 5569) file: [488c2660] check-in: [daf730d1] user: drh branch: trunk, size: 4405 Added