/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of test/limit.test

2015-03-05
01:29
New requirements marks on compound SELECT statements. file: [0c99a27a] check-in: [e7991bc5] user: drh branch: trunk, size: 16529
2014-03-21
18:16
Fix the OFFSET clause so that it works correctly on queries that lack a FROM clause. Ticket [07d6a0453d4ed8]. file: [3d7df19c] check-in: [179ef816] user: drh branch: trunk, size: 16273
2013-01-30
01:46
Remove some debugging logic accidently left in the limit.test module. file: [cc0ab633] check-in: [7d346250] user: drh branch: trunk, size: 15879
2013-01-29
23:55
Fix LIMIT and OFFSET so that they work and do not leak memory even on complex queries involving deeply nested views of UNION ALL compounds. Ticket [db4d96798da8]. Secondary to ticket [d58ccbb3f1b7]. file: [d31ab07c] check-in: [497ee36c] user: drh branch: trunk, size: 15973
2008-08-02
03:50
Additional coverage testing. Fix a segfault following OOM in sqltie3_load_extension(). (CVS 5523) file: [2db7b3b3] check-in: [f1e44eb3] user: drh branch: trunk, size: 11798
2008-01-16
18:20
Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) file: [ca61a9fc] check-in: [3a289b6d] user: danielk1977 branch: trunk, size: 11305
2006-06-20
11:01
Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276) file: [2a87b9cb] check-in: [c6ea353b] user: danielk1977 branch: trunk, size: 11307
2006-04-26
17:39
Get LIMIT 0 working on subqueries. Ticket #1784. (CVS 3177) file: [71884068] check-in: [7f3ef7dd] user: drh branch: trunk, size: 11254
2006-03-03
19:12
Ignore leading spaces on text to numeric conversions. Ticket #1662. Fixes to test cases broken by the recent changes to round(). (CVS 3118) file: [1d5a45f2] check-in: [cdca3383] user: drh branch: trunk, size: 11143
2006-01-17
09:35
Test suite fixes for builds that define OMIT symbols. (CVS 2962) file: [f593d0ff] check-in: [3a54a33d] user: danielk1977 branch: trunk, size: 11100
2006-01-08
18:10
Get LIMIT and OFFSET working again for negative limits and offsets. Ticket #1586. (CVS 2889) file: [4b538057] check-in: [b2ac0be0] user: drh branch: trunk, size: 11092
2005-09-08
10:37
The SUM() aggregate function returns an integer result if all inputs are integers. Any single non-integer input causes the result to be a floating point value. (CVS 2669) file: [39f084f4] check-in: [21adf4bd] user: drh branch: trunk, size: 10577
2005-02-05
12:48
Allow expressions (including variables) in LIMIT and OFFSET clauses. Ticket #1096. (CVS 2316) file: [270b076f] check-in: [515e5033] user: danielk1977 branch: trunk, size: 10589
2005-01-21
04:25
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) file: [f833e610] check-in: [d4e19efc] user: danielk1977 branch: trunk, size: 9823
03:12
Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [9913f3cc] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 9797
2005-01-20
02:17
Fix some test scripts so that they work with a minimal build configuration. (CVS 2241) file: [56101a45] check-in: [d267fb3c] user: danielk1977 branch: trunk, size: 9140
2005-01-15
01:52
Test coverage improvements. (CVS 2215) file: [f509165d] check-in: [92f9d2b2] user: drh branch: trunk, size: 9061
2004-12-16
21:09
Make sure LIMITs are handled correctly on UNION operators. Ticket #1035. (CVS 2166) file: [0225cadf] check-in: [ece0085f] user: drh branch: trunk, size: 8900
2004-11-22
13:35
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) file: [c7bddad2] check-in: [007be591] user: danielk1977 branch: trunk, size: 8275
08:43
Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) file: [4798e019] check-in: [711e8d76] user: danielk1977 branch: trunk, size: 8230
2004-08-20
18:34
Tcl interface transfers values directly between SQLite and Tcl_Objs, without at translation to strings. (CVS 1898) file: [f7c06fcc] check-in: [e97c3313] user: drh branch: trunk, size: 8185
2004-07-19
23:38
Refinements to the LIMIT patch (1823) for ticket #749. (CVS 1825) file: [e4ee72ab] check-in: [9d4f43f0] user: drh branch: trunk, size: 8181
23:33
Limit occurs after DISTINCT. Ticket #749. (CVS 1824) file: [c6365450] check-in: [db5ae13d] user: drh branch: version_2, size: 8219
23:16
LIMIT occurs after DISTINCT. Ticket #749. (CVS 1823) file: [404a540e] check-in: [e6bc8aa8] user: drh branch: trunk, size: 7987
2004-05-27
17:22
Remove the COPY command. (CVS 1477) file: [60d7f856] check-in: [287f8673] user: drh branch: trunk, size: 7742
2004-05-14
21:12
Cache record headers in the OP_Column opcode. (CVS 1382) file: [94c5dca1] check-in: [8d9eab17] user: drh branch: trunk, size: 7775
2004-03-08
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) file: [e28ce938] check-in: [2c6bd21e] user: drh branch: trunk, size: 7758
2003-07-20
01:16
Fix the LIMIT clause so that it applies to the entire query in a compound query. Prior to this change LIMITs on compound queries did not work at all. Ticket #393. (CVS 1058) file: [fa2a8b3f] check-in: [543479e3] user: drh branch: trunk, size: 7738
2003-07-16
11:51
Make LIMIT 0 return no rows. LIMIT -1 still returns all rows. Ticket #346. (CVS 1053) file: [87ca3910] check-in: [a31d0bd9] user: drh branch: trunk, size: 5780
02:19
Allow negative values for LIMIT and OFFSET. Add tests for negative LIMITs and OFFSETs. Make the OFFSET work even if LIMIT is 0 or negative. (CVS 1052) file: [10991f3f] check-in: [e6a752bf] user: drh branch: trunk, size: 5629
2003-02-20
00:44
Fix the parsing of the LIMIT clause when the limit and offset are separated by a comma. The offset comes before the limit in that case. Ticket #245. (CVS 872) file: [9ffb965a] check-in: [6ef91a36] user: drh branch: trunk, size: 4849
2002-09-08
17:23
Fix for ticket #147: Honor the ORDER BY and LIMIT clauses in a SELECT even if the destination of that SELECT is a subroutine call. (CVS 747) file: [9f26f874] check-in: [23fe36c7] user: drh branch: trunk, size: 4580
2002-08-13
23:02
Make the distinction between text and numeric data. (CVS 710) file: [dd932f75] check-in: [310ac4fb] user: drh branch: trunk, size: 3582
2002-06-21
23:01
Fix for bugs #77 and #80: Rework the LIMIT mechanism to be reentrant and to clean up the VDBE stack properly. (CVS 636) file: [49b44e02] check-in: [9d552310] user: drh branch: trunk, size: 3579
2002-06-14
22:38
Make the LIMIT clause work even if the destination of the SELECT is something other than a callback. (Ticket #66) (CVS 619) file: [96b33e10] check-in: [699cf362] user: drh branch: trunk, size: 2050
2002-05-24
16:14
Add support for the full SQL join syntax. This is just a parser enhancement. We now recognize all kinds of joins, but we don't actually do anything with them yet. (CVS 586) file: [6f98bcef] check-in: [e238643e] user: drh branch: trunk, size: 1683
2001-11-06
14:10
Added support for LIMIT. (CVS 302) file: [a930f3eb] check-in: [17701224] user: drh branch: trunk, size: 1671 Added