/ All files named "test/limit.test"
Login

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

History for test/limit.test

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