aboutsummaryrefslogtreecommitdiff
path: root/src/expr.c
Commit message (Collapse)AuthorAge
...
| * | | Add the sqlite3VdbeLoadString() and sqlite3VdbeMultiLoad() routines to helpdrh2015-09-03
| | | | | | | | | | | | | | | | | | | | | | | | with code generation, especially on PRAGMAs. Rename sqlite3VdbeAddGoto() to just sqlite3VdbeGoto(). FossilOrigin-Name: 847387ec8e6fef283899578fb232b2c23b00ee5b
| * | | Add the sqlite3VdbeAddGoto(v,i) routine as a shorthand fordrh2015-09-02
| | |/ | |/| | | | | | | | | | sqlite3VdbeAddOp2(v,OP_Goto,0,i). FossilOrigin-Name: be78f413df1b0d874b44a866ef6bf17543d7e8a2
* | | Merge enhancements from trunk.drh2015-09-01
|\| | | | | | | | FossilOrigin-Name: 29570a604806e2a60a8eef7eaf1dce022d2a7004
| * | Evaluate expressions only once when the same expression is used in both thedrh2015-08-26
| |/ | | | | | | | | result set and in the ORDER BY clause. FossilOrigin-Name: c2f3bbad778504681b39ab9399a1eb3c1a35ab3f
| * Enhances the parser so that it accepts arbitrary expressions for the argumentsdrh2015-08-24
| | | | | | | | | | | | | | of an index, though the code generator still rejects everything other than simple column names. The sqlite3RestrictColumnListSyntax() routine is removed since that feature is now handled by the parser. FossilOrigin-Name: bed42116addabcf3dfdc2e2d51ae183965704988
| * Disallow the use of COLLATE clauses and the ASC and DESC keywords withindrh2015-08-24
| | | | | | | | | | foreign key constraints and in the argument list to common table expressions. FossilOrigin-Name: 83cbc4d8761498647794affffa961a4fca311be7
| * Fix a comment typo on sqlite3ExprAlloc(). No code changes.drh2015-08-23
| | | | | | FossilOrigin-Name: 518d6220a12fb1289f699ef0821e6adfcd286ed0
* | Merge recent enhancements from trunk, including table-valued expressions.drh2015-08-20
|\| | | | | FossilOrigin-Name: b9927c876c1d4e146cb6a603d82cd2489594084d
| * Minor refactor of the SrcList object so that it is able to hold the argumentdrh2015-08-19
| | | | | | | | | | list to a table-valued-function in the FROM clause. FossilOrigin-Name: b919376147597c4b73421abe5788f893baf1560b
* | Fix a bug in sqlite3ExprContainsSubquery().drh2015-08-13
| | | | | | FossilOrigin-Name: be254715b5f56900e57ed57a179ca8d7bb68685d
* | Merge in all the trunk changes from the previous year. This breaks thedrh2015-08-13
|\| | | | | | | | | cursor-hint mechanism, but provides a baseline for trouble-shooting. FossilOrigin-Name: 82a7a61bc0883b1e7432548e4890791717aa1bb3
| * Cache the sqlite3_context structure in the P4 operand of VDBE programsdrh2015-06-26
| | | | | | | | | | for faster SQL function dispatch. FossilOrigin-Name: 2abc44eb3b9d489321baa50bc25e17dafbda3687
| * Make sure that the likelihood() function does not mess up generation ofdrh2015-06-20
| | | | | | | | | | | | result-set code when it is used (inappropropriately) in a result-set expression. FossilOrigin-Name: 7cdbae625eb029538a693d2bebec465a6f65fb90
| * Add the OP_ColumnsUsed opcode (when compiled withdrh2015-06-12
| |\ | | | | | | | | | | | | | | | SQLITE_ENABLE_COLUMN_USED_MASK) as a hint to the b-tree layer as to which columns of a btree cursor will be used. FossilOrigin-Name: 711a176cbfad5dde6defa9648fba6d0d663af134
| | * Add a new opcode to the VDBE that gives the b-tree a hint about the setdrh2015-06-05
| | | | | | | | | | | | | | | of columns in a table or index that are actually used by the query. FossilOrigin-Name: f167bba446b78dd7538d0b2bae3e6678f3b1ba28
| * | When generating code for partial indexes, be sure not to modify thedrh2015-06-11
| | | | | | | | | | | | | | | index condition expression in the schema. FossilOrigin-Name: e63d01c69c3e50f49ee3022a519c4f3e91f00520
| * | Factor out the TreeView parse tree printing module into a separate file.drh2015-06-08
| | | | | | | | | FossilOrigin-Name: c32ce54ca46a4be4373983be6fd44b1f3a0250d1
| * | Split FROM-clause subquery flattening and code generation into separate loops.drh2015-06-05
| |/ | | | | FossilOrigin-Name: be8e3fc70e4c13b28b07985df3457960f58ffddd
| * Change the name of SrcList.a[].zIndex to the more descriptivedrh2015-06-04
| | | | | | | | | | SrcList.a[0].zIndexedBy. FossilOrigin-Name: 6a9cf063379118dbb95c6cdc6d60af50e9867177
| * Rename SQLITE_AFF_NONE to SQLITE_AFF_BLOB.drh2015-06-02
| | | | | | FossilOrigin-Name: bce3f04186cd2d69414a5a98b5b77dc8f060554a
| * Corrections to comments in expr.c. No code changes.drh2015-06-01
| | | | | | FossilOrigin-Name: f925389eaf5bf8962a28fcaa652b75caa606efba
| * Fix a minor coding inefficiency found during pre-release inspection.drh2015-05-05
| | | | | | FossilOrigin-Name: cc50883d67334507227e1384fef6cc7c93fd7de1
| * Improvement to "ID" formatting on the ".selecttrace 0x1ff" debugging function.drh2015-04-23
| | | | | | FossilOrigin-Name: 01c50cee37bfaddfecdda014728c35a1be1d991a
| * Add an ALWAYS() around a new branch that was made unreachable by an evendrh2015-04-20
| | | | | | | | | | newer change. FossilOrigin-Name: 592c010478fba7410424f011a62e019c826f1ac3
| * Fix a potential NULL pointer deference on a corrupt database schema.drh2015-04-19
| | | | | | FossilOrigin-Name: dc61b292d8eaf422ca8a2b18f1caccef1a5389fd
| * In the expression-tree comparison routine, do not compiler Expr.iColumndrh2015-04-17
| | | | | | | | | | and Expr.iTable for TK_STRING expressions. FossilOrigin-Name: b67bb16c72c3e015ea82665ada9b5d3289ef6fb2
| * Improvements to the way VALUES clauses are parsed.drh2015-04-16
| | | | | | FossilOrigin-Name: ec5a493ad27593ca78899b3001630c1898b940ff
| * When adding the implied "LIMIT 1" to the end of a scalar subquery, make suredrh2015-04-15
| | | | | | | | | | | | that subquery is not a VALUES-only query as such queries cannot deal with LIMIT clauses. FossilOrigin-Name: 7c27310bdf6b4af44a0811a2787ed64966d720d2
| * Add a test case for what was formerly thought to be an unreachable condition:drh2015-04-15
| | | | | | | | | | | | when the LHS of an OR operator contains an error and the RHS contains an IN operator. FossilOrigin-Name: 3872742591add4e94033484c2844e7d7ab69674b
| * Fix a potential NULL pointer dereference following a syntax error.drh2015-03-22
| | | | | | FossilOrigin-Name: 8d27e3e16a9be79fe227e833f4770ebe09a9d90b
| * Fix a problem causing collation sequence names to be dequoted multiple times ↵dan2015-03-20
| | | | | | | | | | under some circumstances. FossilOrigin-Name: eddc05e7bb31fae74daa86e0504a3478b99fa0f2
| * Propagate COLLATE operators upward through function calls and CASE operations.drh2015-02-09
| |\ | | | | | | | | | | | | | | | | | | And do not flatten an aggregate subquery into a query that uses other subqueries. Fixes for tickets [ca0d20b6cdddec5] and [2f7170d73bf9], respectively. FossilOrigin-Name: 24e78b8d65734a6a8ae21a20542cd1839e756fb1
| | * Propagate the COLLATE operator upward through function calls.drh2015-02-09
| | | | | | | | | | | | | | | Initial fix for ticket [ca0d20b6cdddec5e8]. FossilOrigin-Name: c053448a55f9d030e8ffe88cf4fc14ada7f6ec19
| | * Disable the query flattener for aggregate subqueries if the parent querydrh2015-02-09
| |/ | | | | | | | | | | | | uses other subqueries in its result set or WHERE clause or ORDER BY clause. Preliminary fix for ticket [2f7170d73bf9abf8]. However it still contains a defect similar to the COLLATE problem of [ca0d20b6cddd]. FossilOrigin-Name: 0b7d65e3fda676d193347cb782854c28a48252af
| * Rename the internal "EP_Constant" bitmask to a less misleading "EP_ConstFunc".drh2015-02-09
| | | | | | FossilOrigin-Name: 4ef7ceced2b0000d21f7f8014384c04a0e4661d3
| * Fix a (almost always harmless) read past the end of a memory allocationdrh2015-01-27
| | | | | | | | | | | | | | that comes about because the Expr.pTab field is checked on an EXPR_REDUCEDSIZE Expr object before checking the Expr.op field to know that the Expr.pTab field is meaningless. FossilOrigin-Name: e098de691002a78270540430b0df1e120582b53f
| * Fix an assert() that may fail following an OOM error.dan2015-01-21
| | | | | | FossilOrigin-Name: 5f592359d6d41708da3b3ac9d987a1631bfa3d88
| * Fix three crash problems discovered by afl-fuzz.drh2015-01-09
| | | | | | | | | | Ticket [a59ae93ee990a55]. FossilOrigin-Name: fe5788633131281a0f27c5b75993ce2ff958bfeb
| * If a table is the right operand of a LEFT JOIN, then any column of thatdrh2014-12-04
| | | | | | | | | | | | table can be NULL even if that column as a NOT NULL constraint. Fix for ticket [6f2222d550f5b0ee7ed]. FossilOrigin-Name: 6f6fcbe4736b9468a495c684d5eebc8bfe5c566a
| * Add new requirements marks associated with the file format documentation.drh2014-11-19
| | | | | | | | | | No changes to code. FossilOrigin-Name: 6d00bcca6ed1903fb17275752cab71c14392355b
| * Do not automatically remove the DISTINCT keyword from "a IN (SELECT DISTINCT ↵dan2014-11-14
| | | | | | | | | | ...)" expressions. Fix for [db87229497]. FossilOrigin-Name: 55e453aadbb676dda07f0fa537d39ce184ef636c
| * Enhance the automatic index logic so that it creates a partial index whendrh2014-10-24
| | | | | | | | | | doing so gives the same answer for less work. FossilOrigin-Name: d95d0313c447f5baeabdb17284d8606331ab7d49
| * Show the TK_DOT operator in the TreeView debugging output.drh2014-10-01
| | | | | | | | | | No changes to production code. FossilOrigin-Name: 07c89940c49a5dca3205a4b6fa8290f23bcb6e10
| * Remove the SQLITE_ENABLE_TREE_EXPLAIN compile-time option. Add alternativedrh2014-09-30
| | | | | | | | | | | | debugging display routines: sqlite3TreeViewExpr(), sqlite3TreeViewExprList(), and sqlite3TreeViewSelect(). FossilOrigin-Name: 4ff51325d6b41d0c59e303b573700ec80c51d216
| * Do not allow parameters in a DEFAULT clause of a CREATE TABLE statement.drh2014-09-24
| | | | | | | | | | Ticket [78c0c8c3c9f7c1]. FossilOrigin-Name: 1ad2bc1ed4c4ac81ac67a9660761f0eeb47c7fef
| * Improved ".selecttrace" output.drh2014-09-21
| | | | | | FossilOrigin-Name: c0b61f7092a7fd2c5f51db26ce7a7a5c75c227fe
| * Fix the SELECTTRACE_ENABLE macro so that it doesn't cause problems fordrh2014-09-20
| | | | | | | | | | testfixture. Add new SELECTTRACE() calls. FossilOrigin-Name: f1ba68f131d2f03e4a7bc50cde23a7609d384279
| * Simplify the way the column cache is managed around OP_Move instructions.drh2014-09-12
| | | | | | FossilOrigin-Name: 320556233e19cdd9d590a09655c3465754700d39
| * Fix typos in comments. No code changes.peter.d.reid2014-09-06
| | | | | | FossilOrigin-Name: e62aab5e9290503869e1f4d5e0fefd2b4dee0a69
| * Avoid an unnecessary OP_Move operation for expression subqueries.drh2014-08-29
| | | | | | FossilOrigin-Name: 462f42af52f146fd328ddcbbe78c8444ef7bd2c3