aboutsummaryrefslogtreecommitdiff
path: root/src/expr.c
Commit message (Collapse)AuthorAge
...
* Use sqliteVdbeOp3 instead of sqliteVdbeChangeP3 where applicable. (CVS 1266)drh2004-02-22
| | | FossilOrigin-Name: 51f1e8f7539596b33bc3365ec8f34041602d049c
* Use sqliteErrorMsg instead of sqliteSetString whereever practical. (CVS 1264)drh2004-02-22
| | | FossilOrigin-Name: 69aac043af7f93e7b3f036622c0ac9261cae1839
* Fix a long-standing memory leak that the new last_insert_rowid() testsdrh2004-02-21
| | | | | brought to light. (CVS 1259) FossilOrigin-Name: 7d5ede5b6ef515808995d4631f8d19aca95a9105
* Fix an uninitialized variable in expr.c. Ticket #604. (CVS 1225)drh2004-02-11
| | | FossilOrigin-Name: 1673bf7c7b64542530ee03328186be33cb88c98d
* Modularize the column name resolution code so that it is smaller, faster,drh2004-01-25
| | | | | | and ready for some enhancements that will fix long-standing name resolutions problems. (CVS 1198) FossilOrigin-Name: d3648034b409822909d79eb5aa4e64cafa986541
* More compaction of expr.c. (CVS 1184)drh2004-01-16
| | | FossilOrigin-Name: 92e7f78057c4e8f6214b6e0a2d80c3ffcbfdf68e
* Incremental code compaction in expr.c. Now about 4% smaller.drh2004-01-16
| | | | | Lots more work to do. (CVS 1183) FossilOrigin-Name: d292ba5148059dce3893b80eabdca4af9f75194e
* Remove an incomplete comment that somehow snuck into the sources. (CVS 1172)drh2004-01-14
| | | FossilOrigin-Name: ea1ad4653e6248f112d5516a0dcf3a72aa9b60d7
* Fix problem in the code generator were incorrect code was being created if drh2004-01-06
| | | | | | the SQL source contained a negative integer that was too large to fit in a 32-bit signed integer variable. Ticket #552. (CVS 1157) FossilOrigin-Name: b8381d9fe99273507e8626638110646801afef06
* Fix a bulk-memory initialization problem in the expression list logic. (CVS ↵drh2003-12-10
| | | | | 1130) FossilOrigin-Name: d6549954408b01e5eaf865b9100739c94de28f16
* A failed malloc() could have resulted in a segfault. Fixed by this ↵drh2003-09-23
| | | | | check-in. (CVS 1102) FossilOrigin-Name: 4bb256ee3ecd44d71d90556e16bb56c0389fd5b5
* Update Makefile.in for the new vdbeaux.c file. Remove the experimentaldrh2003-09-06
| | | | | | "sqlite_instantiate()" routine and replace it with "sqlite_bind()" which is more like ODBC and JDBC. (CVS 1095) FossilOrigin-Name: 990bb11898a539bb0795a4a216fcd989943a0fb2
* The beginnings of changes to support pre-compiled SQL. Mostly untested,drh2003-09-06
| | | | | though all regression tests to pass. (CVS 1093) FossilOrigin-Name: 912f47c72d3597c6d5acff765d94922bd660339a
* The {quote: SrcList} object was not being expanded correctly by a call to drh2003-07-30
| | | | | | | | sqliteSrcListAppend() if the {quote: SrcList} had previously been duplicated by a call to sqliteSrcListDup(). Ticket #416. This check-in fixes that problem by keeping a separate nAlloc field on {quote: SrcList}. A similar change is made to {quote: IdList} and {quote: ExprList} to avoid future problems. (CVS 1067) FossilOrigin-Name: da6273255471673841fdcadc688aeac80722e130
* Fix the LIMIT clause so that it applies to the entire query in a compounddrh2003-07-20
| | | | | | query. Prior to this change LIMITs on compound queries did not work at all. Ticket #393. (CVS 1058) FossilOrigin-Name: 543479e3aed77976a0c689cf40811bf88353f706
* Tighter binding of views, triggers, and indices to their respectivedrh2003-05-31
| | | | | | databases. Ticket #323. Much more testing needs to be done to the sqliteFix...() routines in attach.c. (CVS 990) FossilOrigin-Name: 7202d4f1a8853368954a967b7ccca9d8a6645a2e
* VDBE cursors numbers for tables in a join do not have to be consecutive.drh2003-05-02
| | | | | This is one step on the road to fixing ticket #272. (CVS 947) FossilOrigin-Name: be7aed2011b4af868b6a0c370c3d41354ae0cdf4
* Update the authorizer API so that it reports the database that table anddrh2003-04-22
| | | | | | indices belong to and so that it reports when actions are taken in response to a trigger. (CVS 928) FossilOrigin-Name: c675a5504138f34cae6def782b5d3add2c67d2bc
* Modify the optimizer so that it does not assume that functions aredrh2003-04-19
| | | | | constant. (CVS 920) FossilOrigin-Name: 767f1af236d115e8388e1dcc28a4df1be48d6c85
* Get triggers working on tables with INTEGER PRIMARY KEYs. Ticket #291.drh2003-04-15
| | | | | | This may also fix #159. Still need to add tests so both bugs remain open for the time being. (CVS 908) FossilOrigin-Name: 0b996959b8d8bc2c82eab9cccc190befd0056505
* Add the sqliteErrorMsg() function and use it to generate error messagedrh2003-03-31
| | | | | | text during parsing and code generation. This simplifies the code somewhat and makes it easier to handle names with a database prefix. (CVS 891) FossilOrigin-Name: 1d3fc977211abdc7ba3fd51d661863e8ce5aef69
* Changes to the "sqlite" structure that allow simultaneous operations ondrh2003-03-27
| | | | | | multiple database files. Many regession tests pass - but not all of them. Do not use this version except for debugging SQLite itself. (CVS 883) FossilOrigin-Name: d2fb2bb50cf1e13feb90995079f291384abd6ba9
* Record the database name in addition to the table name for DELETE, INSERT,drh2003-03-20
| | | | | and UPDATE statements. (CVS 879) FossilOrigin-Name: a5d8fc95ee58dc3205a0bbbcadaa3b9c902a941b
* Allow double-quoted strings as string constants in the IN operator. As adrh2003-01-31
| | | | | | side-efffect, allow the GROUP BY clause to refer to columns by their integer column number. Ticket #237. (CVS 856) FossilOrigin-Name: 187d9c405891e543fc706f8ddb41f3966a842214
* Better error messages on constraint violations. Additional tests and bug fixesdrh2003-01-29
| | | | | for the callback-free API. (CVS 854) FossilOrigin-Name: ccc82f1ab4539a60ee5cc2625743c5389f9ccd8e
* Fix datatype reporting and collating sequence selection so that it worksdrh2003-01-18
| | | | | correctly on views and with the UNION, EXCEPT, and INTERCEPT operators. (CVS 839) FossilOrigin-Name: 71cc292dce59cf8224b205d1cdbff59ad12f1043
* More tests of the sqlite_set_authorizer() API together with fixes for bugsdrh2003-01-14
| | | | | that the new tests uncovered. (CVS 832) FossilOrigin-Name: cc2ae781ac186f9ee1afacdc9117087421955369
* Initial check-in of the code for the new sqlite_set_authorizer() API function.drh2003-01-12
| | | | | The code is mostly untested at this point. (CVS 827) FossilOrigin-Name: 52d5007f64d0af5286b2a0e1f0b9e53c86bece3f
* Fix an assert that might fail if malloc() fails. (CVS 774)drh2002-10-31
| | | FossilOrigin-Name: 8ad018944c3aa8f58e1c68b1fa634ef922d6476f
* Correctly handle column names and string constants in parentheses.drh2002-10-22
| | | | | Fix for ticket #179. (CVS 770) FossilOrigin-Name: 3b68aa25c451b7c09ece457ac2b70a9a5d93508a
* Modify the build process so that the VDBE opcode numbers and the tabledrh2002-09-08
| | | | | | that contains the opcode names are both automatically generated. This makes it much easier to create new VDBE opcodes. (CVS 746) FossilOrigin-Name: eb54d455b0325d3be96daf6c220c4ee3e0da1a85
* Change the way token memory is allocated in an effort to fix ticket #136.drh2002-08-24
| | | | | There is now a memory leak when using views of views. (CVS 725) FossilOrigin-Name: 22d8726e61eec0e53893f492cb2163824b87a23e
* Fix for ticket #107: Fix a design defect in indices that was causing queriesdrh2002-07-18
| | | | | | to fail when using an index on a column containing an empty string. This fix is an incompatible file-format change. (CVS 681) FossilOrigin-Name: 20d152fcddb4fa53556a9c93c7a869600a7c5183
* Fix for ticket #100: Correctly handle ON and USING clauses of JOINs withindrh2002-07-16
| | | | | a VIEW. (CVS 679) FossilOrigin-Name: 93710f7ed7e1baa6acbf4bc32982e046f61ffa44
* Fix for ticket #92: Correct the sqliteExprCompare() function so that is takesdrh2002-07-02
| | | | | | into account the iTable and iColumn fields of the Expr structure. Otherwise, "min(a)" and "min(b)" will compare equal to each other in views. (CVS 658) FossilOrigin-Name: 85793a4f03250166c21007cab3525709592d0866
* Add a few more tests and fix a few bugs that the tests uncovered. (CVS 652)drh2002-06-29
| | | FossilOrigin-Name: 91c0db66c86facb21b5b522afadd83d91a488256
* Additional test cases added. The following bug fixed: A segfault was occurringdrh2002-06-28
| | | | | if a VIEW consisted of a join with a USING clause. (CVS 651) FossilOrigin-Name: 96515b813eb57e1f48c28d357d1f38639b2fdcfa
* The datatype of the i-th column in the result set is given by thedrh2002-06-26
| | | | | azColName(argc+1+i) parameter to the callback. (CVS 647) FossilOrigin-Name: bdb006b809feb0f29342eb5138c0884d34e95599
* This patch contains the beginnings of the data-typing infrastructure.drh2002-06-20
| | | | | | | The new build-in TypeOf() function is added. New opcodes for doing pure text comparisons are added. Most changes are disabled pending the 2.6.0 release. (CVS 632) FossilOrigin-Name: cbbc858d973c2d515c6a2464981316549a241b73
* Add preliminary logic for the eventual move to having separate TEXT anddrh2002-06-17
| | | | | | NUMTEXT datatypes. Also change the version number to 2.5.0 in preparation for an interim release. (CVS 625) FossilOrigin-Name: 05783a9db585c1ead42135252dca97d2bc6e2118
* Add RAISE() function, which allows more advanced flow-control in trigger ↵danielk19772002-06-11
| | | | | programs (ticket #55) (CVS 614) FossilOrigin-Name: d4a2fb10067203a0d49317db747759872e62927e
* Fix for ticket #65: If an integer value is too big to be represented as adrh2002-06-09
| | | | | 32-bit integer, then treat it as a string. (CVS 611) FossilOrigin-Name: ad9624798edbd6d0c4652fed3d74fe87498844ff
* Fix a compiler warning. (CVS 604)drh2002-06-02
| | | FossilOrigin-Name: 637ee587b5438c54ba2d8bd8fc15e584abb70946
* Add the ability to parse FOREIGN KEYs. Foreign keys are still ignored,drh2002-06-02
| | | | | but at least they now do not cause a syntax error. (CVS 603) FossilOrigin-Name: 6fdcee3c99e994ef3ab83a0cc57344cdb16210df
* Enhance the ORDER BY clause so that an integer term means to sort by thedrh2002-06-02
| | | | | corresponding column. (CVS 602) FossilOrigin-Name: 7acbf84b492202d8b5a05276a95b475027eb5f58
* Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION.drh2002-05-31
| | | | | | | Multiplying a NULL by zero yields zero. In a CASE expression, a NULL comparison is considered false, not NULL. With these changes, NULLs in SQLite now work the same as in PostgreSQL and in Oracle. (CVS 600) FossilOrigin-Name: da61aa1d238539dff9c43fd9f464d311e28d669f
* Bug fix: bad code was generated for when the first operand of a CASEdrh2002-05-30
| | | | | was NULL. (CVS 598) FossilOrigin-Name: 4debc8db929fdc201759ba211acdeadc4e30e8af
* NULL values are distinct. A comparison involving a NULL is always false.drh2002-05-26
| | | | | | | | Operations on a NULL value yield a NULL result. This change makes SQLite operate more like the SQL spec, but it may break existing applications that assumed the old behavior. All the old tests pass but we still need to add new tests to better verify the new behavior. Fix for ticket #44. (CVS 589) FossilOrigin-Name: 9051173742f1b0e15a809d12a0c9c98fd2c4614d
* Split the IdList structure into IdList and SrcList. SrcList is used todrh2002-05-24
| | | | | | | represent a FROM clause and IdList is used for everything else. This change allows SrcList to grow to support outer joins without burdening the other uses of IdList. (CVS 584) FossilOrigin-Name: a167b71d8c27e870bc3079c6132e483bffc83298
* Fix some places where a malloc() failure would lead to a segfault. (CVS 580)drh2002-05-23
| | | FossilOrigin-Name: 01ad352c3c82a86d9c94010cbc85d098b8fbc08a
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-08 20:16:46 +0000