SQLite

Timeline
Login

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

138 check-ins using file test/expr.test version ad985242

2007-01-08
16:20
Fix a date round-off problem in strftime(). Ticket #2153. (CVS 3575) (Leaf check-in: 47fee16b user: drh tags: version_2)
13:43
Fix a round-off error in the %W conversion of strftime(). Ticket #2150. (CVS 3572) (check-in: e6a18741 user: drh tags: version_2)
2006-10-24
11:26
Fix a bad variable reference. The reference is actually in unreachable code and is therefore harmless. The fix is to remove the code. (CVS 3483) (check-in: 46b91807 user: drh tags: version_2)
2005-12-19
17:56
Version 2.8.17 (CVS 2836) (check-in: 50d7e50a user: drh tags: version_2)
17:38
Bump the version number of the 2.8 branch to 2.8.17. (CVS 2833) (check-in: 94dfb4bd user: drh tags: version_2)
17:37
Backport the fix for ticket #1567 to version 2.8. (CVS 2832) (check-in: 3f5f358f user: drh tags: version_2)
2005-06-06
15:07
Handle failures of getcwd() without segfaulting. Ticket #1274. (CVS 2491) (check-in: c1bd0a15 user: drh tags: version_2)
2005-02-16
03:53
The ".dump" method in the shell for version 2 should not sort tables by name because this can put views out of dependency order. Ticket #1124. (CVS 2347) (check-in: b82c06fd user: drh tags: version_2)
2005-02-15
16:04
Update the publish.sh script so that it grabs the correct source tree. (CVS 2339) (check-in: 74684507 user: drh tags: version_2)
13:07
Version 2.8.16 (CVS 2336) (check-in: 2efbbba5 user: drh tags: version_2)
2005-02-14
05:47
Modifications to the publish.sh script prior to 2.8.16. (CVS 2328) (check-in: affde443 user: drh tags: version_2)
00:25
Cleanup the vacuum bug fixes in version 2.8. (CVS 2327) (check-in: 5658da7e user: drh tags: version_2)
00:21
Fix the vacuum bug in version 2.8. Also prepare for release 2.8.16. (CVS 2326) (check-in: 0eaebad5 user: drh tags: version_2)
2004-11-20
20:42
Avoid excess heap usage when copying expressions. Ticket #979. (CVS 2126) (check-in: 0f444c03 user: drh tags: version_2)
19:01
Preserve the default_temp_store pragma across VACUUM in version 2.8. (Version 3.0 already does this.) Ticket #1008. (CVS 2120) (check-in: 7fa623f2 user: drh tags: version_2)
2004-11-02
18:30
Disable trigger tests that use ATTACH in version 2.8 when there is a codec enabled. (CVS 2042) (check-in: f77f7753 user: drh tags: version_2)
2004-10-06
15:52
Fix naming conflict between sqlite.h and sqlite3.h. Ticket #946. (CVS 2008) (check-in: e750ae5a user: drh tags: version_2)
2004-10-01
15:11
Fix for ticket #905. (CVS 1995) (check-in: bf90799d user: drh tags: version_2)
2004-09-09
13:54
Fix a segfault in the authorizer when it is given a SELECT statement with no FROM clause. Ticket #896. (CVS 1953) (check-in: 205d85d7 user: drh tags: version_2)
2004-08-28
14:53
Correct handling of quoted names in CREATE INDEX. Ticket #869. (CVS 1907) (check-in: b01d5665 user: drh tags: version_2)
2004-07-23
01:10
More fixes to the publish.sh script. (CVS 1863) (check-in: 022e3f56 user: drh tags: version_2)
2004-07-22
18:53
Version 2.8.15 (CVS 1859) (check-in: 102ab941 user: drh tags: version_2)
18:08
Fix the publish.sh script so that it builds and packages windows DLLs correctly. (CVS 1856) (check-in: 81aa41e7 user: drh tags: version_2)
17:10
Another attempt at fixing the memory allocation problem in sqliteExprListDup(). (CVS 1855) (check-in: 49c2ad8a user: drh tags: version_2)
16:32
Bug fix in allocation of expression lists after a malloc() failure. (CVS 1854) (check-in: 09494cab user: drh tags: version_2)
16:08
Add join tests to the 2.8 branch. (CVS 1850) (check-in: e5546f49 user: drh tags: version_2)
15:53
Update the version number for release 2.8.15. (CVS 1849) (check-in: 9b3c3ca4 user: drh tags: version_2)
2004-07-20
02:05
Fix an obscure memory leak in the expression list allocator. (CVS 1835) (check-in: 5c77b332 user: drh tags: version_2)
01:45
Handle quotes on table names in TABLE.* terms in SELECT. Ticket #680. (CVS 1834) (check-in: 9937ffb0 user: drh tags: version_2)
00:50
Fix the handling of indices with quoted names. Ticket #695. (CVS 1830) (check-in: 46730997 user: drh tags: version_2)
00:40
Comment out all of date/time functions with SQLITE_OMIT_DATETIME_FUNCS. Ticket #784. (CVS 1829) (check-in: 28c01d2a user: drh tags: version_2)
00:20
Correct handling of views on tables with quoted column names. Ticket #756. (CVS 1827) (check-in: ef0d5ebe user: drh tags: version_2)
2004-07-19
23:33
Limit occurs after DISTINCT. Ticket #749. (CVS 1824) (check-in: db5ae13d user: drh tags: version_2)
19:30
Fix for ticket #813. (CVS 1820) (check-in: 0cc612f8 user: drh tags: version_2)
02:24
Correctly handle joins of move than 32 tables. Ticket #806. (CVS 1813) (check-in: 5ba0acd6 user: drh tags: version_2)
2004-07-18
23:03
Use only unsigned characters in upper() and lower(). Ticket #708. (CVS 1807) (check-in: f9b2aa8f user: drh tags: version_2)
22:25
The %W date specifier in strftime should be measured from the first Monday of the year. Ticket #758. (CVS 1806) (check-in: 135e5447 user: drh tags: version_2)
21:14
Min() and max() ignore NULL values. Ticket #800. (CVS 1803) (check-in: 223521c0 user: drh tags: version_2)
2004-07-17
21:59
Fix for ticket #812 in the 2.8 branch. (CVS 1801) (check-in: ea364dff user: drh tags: version_2)
2004-07-15
13:37
Make SrcList.nSrc a signed quantity to avoid problems on AIX. (CVS 1795) (check-in: 41526d09 user: drh tags: version_2)
13:08
Correct return type on sqliteStrICmp() when argument strings differ. Ticket #804. (CVS 1793) (check-in: 296528b2 user: drh tags: version_2)
2004-06-26
14:40
Fold in changes submitted by the PHP developers. (CVS 1742) (check-in: a4a25708 user: drh tags: version_2)
2004-06-23
21:16
The MIN() aggregate function returns NULL if any element in the result was NULL. This makes MIN() consistent with ORDER BY which sorts NULL first. Ticket #777. (CVS 1679) (check-in: 78ced6e3 user: drh tags: version_2)
2004-06-19
11:57
Add the source code to the sqlite_analyzer utility. (CVS 1637) (check-in: 06bf4c7e user: drh tags: version_2)
11:57
Fix a compiler warning in os.c. (CVS 1636) (check-in: 28b737b5 user: drh tags: version_2)
04:23
Backport of (1628) to version 2. (CVS 1631) (check-in: cce250ea user: danielk1977 tags: version_2)
2004-06-16
01:21
Update the publish.sh script so that it no longer generates documentation pages (that is handled by the version 3.0.0 publish.sh). Also insert version numbers in the filenames of all build products. (CVS 1601) (check-in: f2b8d358 user: drh tags: version_2)
2004-06-14
11:58
Do not authenticate statements when reading the schema. Backport of bug fix in (1588) to version 2. (CVS 1591) (check-in: 24adf9ed user: drh tags: version_2)
2004-06-09
23:20
Version 2.8.14 (CVS 1554) (check-in: 7d393774 user: drh tags: version_2)
22:49
Update the version number to 2.8.14. For whatever reason, the version at the tip of the 2.8 branch fixes ticket #757. (CVS 1552) (check-in: 7538d2e5 user: drh tags: version_2)
2004-06-04
19:07
Calling sqlite_interrupt() while VACUUM is running should not cause an error. (CVS 1529) (check-in: 1cf94a7c user: drh tags: version_2)
2004-05-13
05:20
Commit vdbeaux.c, which should of gone in with the previous commit. (CVS 1369) (check-in: 5378a640 user: danielk1977 tags: trunk)
05:16
Manifest types in indices. At the moment indices use manifest typing, but some other parts of the SQL engine do not, which can lead to some strange results. (CVS 1368) (check-in: 9f2b6d9d user: danielk1977 tags: trunk)
01:12
Allocate more overflow data onto overflow pages, thus wasting less disk space. (CVS 1367) (check-in: 1d52a4bb user: drh tags: trunk)
2004-05-12
21:11
Fix a problem with B+trees. (CVS 1366) (check-in: 64a75c4c user: drh tags: trunk)
19:18
Implement a B+tree option (all data stored on leaves). (CVS 1365) (check-in: b8f70d17 user: drh tags: trunk)
15:15
Btree uses signed integers for the rowid. The intToKey() and keyToInt() macros are now no-ops. (CVS 1364) (check-in: fb3c8030 user: drh tags: trunk)
13:30
The pager now handles file ":memory:" complete in memory with no disk I/O. (CVS 1363) (check-in: 97de9f7c user: drh tags: trunk)
11:24
Add some more code to support manifest typing in indices. Not activated yet. (CVS 1362) (check-in: 2f16c9ef user: danielk1977 tags: trunk)
07:33
Change the table record format to support manifest typing. (CVS 1361) (check-in: 0242c9e4 user: danielk1977 tags: trunk)
2004-05-11
10:04
Change sqlite_ to sqlite3_ in the attach2.test test script. (CVS 1360) (check-in: 98f756e6 user: drh tags: trunk)
09:57
A different fix for the problem with opening existing files. See also check-in (1358). (CVS 1359) (check-in: 93deaf54 user: drh tags: trunk)
09:50
Fix a bug that was preventing the library from opening existing files. (CVS 1358) (check-in: ad064bd4 user: danielk1977 tags: trunk)
09:31
Fix an offset problem in the meta values that was causing problems for many tests. (CVS 1357) (check-in: 6d378cb7 user: drh tags: trunk)
09:05
Remove the unused upgrade_3_schema subroutine from main.c. (CVS 1356) (check-in: b5d2771e user: drh tags: trunk)
08:48
More small changes to get test cases to execute. (CVS 1355) (check-in: 6dc60046 user: danielk1977 tags: trunk)
07:11
Remove code dealing with old file formats. (CVS 1354) (check-in: dfde1121 user: danielk1977 tags: trunk)
06:55
More minor changes to accomadate the new btree. All the select* tests pass now. (CVS 1353) (check-in: 941d0fdc user: danielk1977 tags: trunk)
06:17
Minor changes to the vdbe so that more tests pass. (CVS 1352) (check-in: 16078fe0 user: danielk1977 tags: trunk)
04:54
Fix up a couple of little things in the vdbe. select1.test passes now. (CVS 1351) (check-in: 9ba0df4d user: danielk1977 tags: trunk)
03:11
Internal symbols MEM_Dyn and MEM_AggCtx were defined as the same bit pattern. Change MEM_AggCtx to 0x1000. (CVS 1350) (check-in: 2fffd133 user: danielk1977 tags: trunk)
02:10
Fix a bug in the btree code for reading varints greater than 2^32. (CVS 1349) (check-in: 7bc4f554 user: danielk1977 tags: trunk)
01:18
Update the main.mk makefile so that it builds everything again. (CVS 1348) (check-in: e6e52fc2 user: drh tags: trunk)
00:58
Updates to sqlite3BtreeKeyFetch() and sqlite3BtreeDataFetch(). (CVS 1347) (check-in: a675ac49 user: drh tags: trunk)
00:28
Change to OP_PutIntKey to use new btree API. (CVS 1346) (check-in: c080fed7 user: danielk1977 tags: trunk)
2004-05-10
23:29
Work toward getting the new btree.c integrated with vdbe.c. (CVS 1345) (check-in: bc5a2daf user: drh tags: trunk)
20:27
Improvements to testing of sqlite_interrupt. More checking for interrupt inside of VACUUM. (CVS 1344) (check-in: d596f513 user: drh tags: version_2)
18:45
The btree.c module passes all tests and is ready for integration. Still need to go back and do coverage testing. (CVS 1343) (check-in: 84506b23 user: drh tags: trunk)
16:18
The btree.c module now passes all the historical regression tests. New tests for new functionality still need to be added. (CVS 1342) (check-in: 433ae0d3 user: drh tags: trunk)
12:07
Add flags values to the Mem structure to accomodate BLOBs and to show the representation of strings. (CVS 1341) (check-in: 3af283f4 user: drh tags: trunk)
10:37
Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1340) (check-in: ac46bd68 user: danielk1977 tags: trunk)
10:37
Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1339) (check-in: 19b100ec user: danielk1977 tags: trunk)
10:34
Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1338) (check-in: 2242423e user: danielk1977 tags: trunk)
10:34
Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1337) (check-in: ba2ba242 user: danielk1977 tags: trunk)
10:05
Add some functions to serialize and deserialize vdbe values (used by manifest typing). (CVS 1336) (check-in: 05434497 user: danielk1977 tags: trunk)
07:17
Add versions of OP_MakeRecord and OP_Column that use manifest typing (not activated yet). (CVS 1335) (check-in: 9ea8e8ab user: danielk1977 tags: trunk)
07:17
Add versions of OP_MakeRecord and OP_Column that use manifest typing (not activated yet). (CVS 1334) (check-in: 8a66a502 user: danielk1977 tags: trunk)
01:17
Change some code that assumes the root-page of sqlite_master is 2 (it is now 1) (CVS 1333) (check-in: 37ae528f user: danielk1977 tags: trunk)
2004-05-09
23:23
Add a temporary sqlite2BtreeKeyCompare() function to help get regression tests passing again. (CVS 1332) (check-in: d8d1c91e user: danielk1977 tags: trunk)
20:40
More btree.c bug fixing. It's getting closer but still not there yet. Move obsolete test scripts into the attic. (CVS 1331) (check-in: 9379c7c9 user: drh tags: trunk)
11:51
The btree.test test is no working with integrity_check enabled. (CVS 1330) (check-in: 9f1caa53 user: drh tags: trunk)
01:35
Begin trying to get integrity checking working on the new btree.c. (CVS 1329) (check-in: 499569da user: drh tags: trunk)
00:40
All tests in btree.test now pass (but only because I commented out the btree_integrity_check test.) (CVS 1328) (check-in: ee706e9c user: drh tags: trunk)
2004-05-08
20:07
More btree.c bug fixes. (CVS 1327) (check-in: e9f84ff3 user: drh tags: trunk)
10:56
Get the code back to the point where it will compile the btree.c tests. Move the default key comparison routine from btree.c into vdbeaux.c. Commented out code in vdbe.c that will need to be fixed. (CVS 1326) (check-in: 2bca9224 user: drh tags: trunk)
10:11
Minor change to main.c so that it will compile with GCC 2.96. (CVS 1325) (check-in: 1a09a1ad user: drh tags: trunk)
08:23
Change lots of internal symbols from sqliteXXX to sqlite3XXX so that the library links again. It doesn't work yet, due to changes in the btree layer calling convention. (CVS 1324) (check-in: 8af6474c user: danielk1977 tags: trunk)
02:03
More bug fixes in btree.c. (CVS 1323) (check-in: 2d64cba3 user: drh tags: trunk)
2004-05-07
23:50
More bug fixes in btree.c. (CVS 1322) (check-in: a80939ef user: drh tags: trunk)
17:57
The btree.c module compiles and links and passes some tests. Many tests still fail, though. (CVS 1321) (check-in: d394b2b2 user: drh tags: trunk)
13:30
New btree.c module compiles and links. (CVS 1320) (check-in: dcd6b55f user: drh tags: trunk)
02:26
Trying to synchronize the test3.c module with the new btree.c code. (CVS 1319) (check-in: 7fd1a660 user: drh tags: trunk)
01:50
Fix compilation problem in test5.c (CVS 1318) (check-in: 49c3c86c user: danielk1977 tags: trunk)
01:46
Fix a memory leak in DETACH when using the codec. (CVS 1317) (check-in: c4bd99b7 user: drh tags: version_2)
00:57
Add the sqlite_temp_directory global variable which, if set, defines the directory in which temporary files are created. (CVS 1316) (check-in: c90ed20d user: drh tags: version_2)
2004-05-06
23:37
Add code to convert between the various supported unicode encoding schemes. Untested at this point. (CVS 1315) (check-in: 71260ff7 user: danielk1977 tags: trunk)
2004-05-04
17:27
Update test3.c to work with the new btree.c API. (CVS 1314) (check-in: bfb3234d user: drh tags: trunk)
15:00
Added template for the utf.c file containing conversion routines. (CVS 1313) (check-in: 89b42c46 user: drh tags: trunk)
2004-05-03
19:49
Incremental btree.c changes. (CVS 1312) (check-in: fdc629db user: drh tags: trunk)
2004-05-02
21:12
Changes to btree for the new file format are mostly complete. Still need to test and debug. (CVS 1311) (check-in: 0eee3b5c user: drh tags: trunk)
2004-04-29
16:16
Fix a stack overflow problem with INSTEAD OF triggers. (CVS 1310) (check-in: 5a33e0b0 user: drh tags: version_2)
14:42
Sync all version 3 changes. (CVS 1309) (check-in: 51892d6c user: drh tags: trunk)
2004-04-26
14:10
Pager tests working. (CVS 1308) (check-in: 910067a2 user: drh tags: trunk)
2004-04-24
12:59
Changes to lemon.c so that it compiles on OpenWatcom 1.3. Ticket #665. (CVS 1307) (check-in: b8b8ce5c user: drh tags: version_2)
2004-04-23
23:43
Begin modifying the BTree code for the new version-3 file format. This is a work-in-progress. As of this check-in, SQLite will not build. (CVS 1306) (check-in: ce0bbd3a user: drh tags: trunk)
23:38
Add an extra assert() to lemon.c to make debugging easier. Ticket #692. (CVS 1305) (check-in: 818bdba5 user: drh tags: trunk)
23:37
Add some extra debugging logic to lemon.c. Ticket #692. (CVS 1304) (check-in: 635f674d user: drh tags: version_2)
23:20
Branch version_2. Code for version 3 is on the trunk. (CVS 1303) (check-in: db84ddf5 user: drh tags: trunk)
17:04
Get the temp_store and default_temp_store pragmas working. Update the documentation. Also fix a malloc problem that popped up during the regression testing. (CVS 1302) (check-in: 7ace5762 user: drh tags: trunk)
2004-03-26
23:16
Fix windows DLL section of Makefile.in for use with build dir. (CVS 1301) (check-in: 1e84f70f user: rdc tags: trunk)
2004-03-17
23:42
Change the ".database" command in the shell to allocate more characters to the database name and filename. (CVS 1300) (check-in: 85238f06 user: drh tags: trunk)
23:32
Fix a VDBE stack overflow that occurs when the left-hand side of an IN expression is NULL and the result is stored on the stack rather than used to control a jump. Ticket #668. (CVS 1299) (check-in: fc7a7975 user: drh tags: trunk)
18:44
The sqlite_trace() API only works for commands started by the user, not for SQL commands run during initialization. (CVS 1298) (check-in: 0a12473c user: drh tags: trunk)
2004-03-16
21:49
Makefile.in and sqlite.def changes for encode and non-toplevel build; ticket #667 (CVS 1297) (check-in: 72205a37 user: dougcurrie tags: trunk)
2004-03-14
22:12
Prototypes for sqlite_encode_binary() and sqlite_decode_binary() added to sqlite.h. (CVS 1296) (check-in: 359f0e78 user: drh tags: trunk)
22:12
Make sqlite_encode_binary() and sqlite_decode_binary() an official part of the library. (CVS 1295) (check-in: 786fe545 user: drh tags: trunk)
11:57
Updates to the architecture document. (CVS 1294) (check-in: c661cc81 user: drh tags: trunk)
2004-03-13
14:00
Fix the min/max optimizer so that it works when the FROM clause is a subquery. Ticket #658. (CVS 1293) (check-in: 31c94acc user: drh tags: trunk)
2004-03-10
18:57
Typecast to work around a bug in {quote: CodeWarrior} Studio v9.1. Ticket #654. (CVS 1292) (check-in: 5864fc69 user: drh tags: trunk)
18:53
Fixed default target. (CVS 1291) (check-in: af19ab32 user: a.rottmann tags: trunk)
16:32
* Added rule for rebuilding Makefile from Makefile.in. * Fixed double-slash problem induced by adding DESTDIR support. (CVS 1290) (check-in: 957827e3 user: a.rottmann tags: trunk)
13:42
The BTree layer now returns SQLITE_READONLY on an attempt to open a write cursor on a read-only database. Previously, the failure would not occur until there was an attempt to write to the cursor. (CVS 1289) (check-in: 8a8be468 user: drh tags: trunk)
2004-03-09
13:37
The shell program now ignores extra whitespace at the end of dot-commands. (CVS 1288) (check-in: b6817e99 user: drh tags: trunk)
2004-03-08
13:57
Version 2.8.13 (CVS 1287) (check-in: 4d5bbb3d user: drh tags: trunk)
13:45
Update change log for version 2.8.13. (CVS 1286) (check-in: 4431e637 user: drh tags: trunk)
13:26
Bump the version number to 2.8.13. Patch up the limit test so that it works in spite of ticket #521 - we don't want any tests failing in an official release even if there are bugs. :-D (CVS 1285) (check-in: 2c6bd21e user: drh tags: trunk)
2004-03-04
19:09
Correct duplicate tracing of SQL statements. (CVS 1284) (check-in: bb67311b user: rdc tags: trunk)
2004-03-03
01:51
A vdbe stack element might have a string value even after a call to Integerify(). Ticket #641. (CVS 1283) (check-in: 3cac4b7b user: drh tags: trunk)