/ Timeline

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

13 check-ins using file src/func.c version 061a520a

Added tests for the new IN operator optimizer and fixed a bug that the new tests found. This completes the implementation of enhancement #63. (CVS 612) check-in: 2a710e18 user: drh tags: trunk
Fix for ticket #65: If an integer value is too big to be represented as a 32-bit integer, then treat it as a string. (CVS 611) check-in: ad962479 user: drh tags: trunk
Add optimizations for the IN operator in WHERE clauses. This is a partial implementation of enhancement #63. Still need to add test cases. (CVS 610) check-in: 8481e841 user: drh tags: trunk
Bug fix: do not segfault if a SELECT without a FROM clause includes the * wildcard in the result column list. (CVS 609) check-in: d9392949 user: drh tags: trunk
Fix for ticket #59: Add documentation for the || operator. Also added documentation for the new SQL92 join syntax. (CVS 608) check-in: a0abef62 user: drh tags: trunk
Fix for ticket #62: Do not report an SQLITE_READONLY error until the application actually tries to write data into a readonly file. It is OK to start a transaction on a read-only file, and doing so will get you a read lock. This change allows TEMP tables to be read/write even though the main database is readonly. (CVS 607) check-in: 9ef795d1 user: drh tags: trunk
Additional grammar cleanup resulting from the %fallback directive. (CVS 606) check-in: c0cb3a01 user: drh tags: trunk
Added the %fallback directive to the lemon parser generator and used this in the parser to make the parse tables much smaller. This reduced the size of the library by 15K. (CVS 605) check-in: 7ac5bd29 user: drh tags: trunk
Fix a compiler warning. (CVS 604) check-in: 637ee587 user: drh tags: trunk
Add the ability to parse FOREIGN KEYs. Foreign keys are still ignored, but at least they now do not cause a syntax error. (CVS 603) check-in: 6fdcee3c user: drh tags: trunk
Enhance the ORDER BY clause so that an integer term means to sort by the corresponding column. (CVS 602) check-in: 7acbf84b user: drh tags: trunk
Multiplying NULL by zero gives NULL, not zero. I misread the test data and coded it wrong. This check-in fixes the problem. (CVS 601) check-in: df9cc852 user: drh tags: trunk
Refinements to NULL processing: NULLs are indistinct for DISTINCT and UNION. 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) check-in: da61aa1d user: drh tags: trunk